zhicwu / docker-biserver-ce Goto Github PK
View Code? Open in Web Editor NEWDocker image for Pentaho BI server(community edition). https://hub.docker.com/r/zhicwu/biserver-ce/
Docker image for Pentaho BI server(community edition). https://hub.docker.com/r/zhicwu/biserver-ce/
wget http://meteorite.bi/downloads/saiku-plugin-p7-3.14.zip
--2017-09-21 09:32:59-- http://meteorite.bi/downloads/saiku-plugin-p7-3.14.zip
Resolving meteorite.bi (meteorite.bi)... 46.4.70.189
Connecting to meteorite.bi (meteorite.bi)|46.4.70.189|:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2017-09-21 09:33:00 ERROR 404: Not Found.
Whenever I try to build the docker image I get this error:
The command '/bin/sh -c wget -P $BISERVER_HOME/tomcat/webapps/pentaho/WEB-INF/lib https://github.com/zhicwu/saiku/releases/download/3.8.8-SNAPSHOT/saiku-olap-util-3.8.8.jar && wget -O btable.zip https://github.com/zhicwu/BTable/releases/download/7.0-RC1/BTable-7.0-RC1.zip && wget -O saiku-chart-plus.zip http://sourceforge.net/projects/saikuchartplus/files/SaikuChartPlus3/saiku-chart-plus-vSaiku3-plugin-pentaho.zip/download && wget --progress=dot:giga https://github.com/zhicwu/saiku/releases/download/3.8.8-SNAPSHOT/saiku-plugin-p6-3.8.8.zip http://ci.pentaho.com/job/webdetails-cte/29/artifact/dist/cte-7.0-SNAPSHOT.zip http://ctools.pentaho.com/files/d3ComponentLibrary/14.06.18/d3ComponentLibrary-14.06.18.zip https://github.com/rpbouman/pash/raw/master/bin/pash.zip && for i in *.zip; do echo "Unpacking $i..." && unzip -q -d pentaho-solutions/system $i && rm -f $i; done && rm -f *.zip' returned a non-zero code: 8
Regardless which method I choose (build / compose / use your image), I get the same error when trying to start the container:
*** Running /etc/my_init.d/00_regen_ssh_host_keys.sh...
*** Running /etc/rc.local...
*** Booting runit daemon...
*** Runit started as PID 9
*** Running ./docker-entrypoint.sh...
*** ./docker-entrypoint.sh exited with status 0.
*** Shutting down runit daemon (PID 9)...
*** Killing all processes...
Hello, I thank you and congratulate you for your great contribution with this repository.
I am trying to use MySQL as a repository (not to use HSQLDB by default in Pentaho), however I do not get it to work, modifying the information in "secret.env" and modifying the file "docker-compose.yml" returns me as error:
====================
"Pentaho Initialization Exception
I see that "docker-entrypoint.sh" contains the replacements that should be done to convert MySQL as a repository, but I can not make it work.
Can you please tell me a general step by step so that I can validate that this is wrong?
Thank you.
Hello,
I get branch 8.0-base, and try to start it with some modifications in docker-compose.yml from version 7.1 (remove command)
I got issue with hsqldb, seems that pentaho tries to connect to hsqldb with hibuser account (hibernate db) and pentaho_user account (quartz db):
java.sql.SQLInvalidAuthorizationSpecException: invalid authorization specification - not found: hibuser
...
java.sql.SQLInvalidAuthorizationSpecException: invalid authorization specification - not found: pentaho_user
I see that hsqldb are loaded successfully at the beginning of script:
bi | [Server@325e9b2d]: Database [index=0, id=0, db=file:../../data/hsqldb/quartz, alias=quartz] opened sucessfully in 1086 ms.
bi | [Server@325e9b2d]: Database [index=1, id=1, db=file:../../data/hsqldb/hibernate, alias=hibernate] opened sucessfully in 41 ms.
bi | [Server@325e9b2d]: Database [index=2, id=2, db=file:../../data/hsqldb/sampledata, alias=sampledata] opened sucessfully in 44 ms.
From my understanding, default user name of hsqldb is "sa", I don't see anyplace to define user "hibuser" or "pentaho_user" in /biserver-ce/data/hsqldb ... Would you please give me some advices?
Thanks.
Examples:
Docs:
hi,
when i launch the command "docker-compose up -d" the container will correctly start and i can log in on localhost:8080 with admin/password credentials; then (for example) i create a new data source connection.
if i logout and login again i still see the data source.
However if i stop the container with "docker-compose down" and launch it again with "docker-compose up -d" the data source has disappeared!!
what should i add to the docker-compose.yml to get the container save my work/changes ?
thank u in advance.
Ken
*** Running /etc/my_init.d/00_regen_ssh_host_keys.sh...
*** Running /etc/rc.local...
*** Booting runit daemon...
*** Runit started as PID 9
*** Running ./docker-entrypoint.sh biserver...
rm: cannot remove 'tomcat/temp': Directory not empty
*** ./docker-entrypoint.sh exited with status 1.
*** Killing all processes...
Traceback (most recent call last):
File "/sbin/my_init", line 314, in main
sys.exit(exit_status)
SystemExit: 1
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/sbin/my_init", line 353, in
main(args)
File "/sbin/my_init", line 317, in main
shutdown_runit_services()
File "/sbin/my_init", line 250, in shutdown_runit_services
os.system("/usr/bin/sv -w %d down /etc/service/*", KILL_PROCESS_TIMEOUT)
TypeError: system() takes at most 1 argument (2 given)
I'm having a real hard time with BI Server CE 8, so I thought about hunting for a docker image. Found this one, but it's still at 7. Any plans to upgrade this image to 8?
Instead of one image with everything(plugins, patches) included, it's better to refine image hierarchy and introduce more flavors to fit different needs.
For examples:
pentaho/biserver:7.1-base (vanilla BI server without any additional plugin and customization)
|-- pentaho/biserver:7.1-full (7.1-base with more plugins, customizable in build and deployment time)
|-- pentaho/biserver:7.1-patched (7.1-full with patches and entry points for further customization)
May also need to consider:
7.1-base-20170712
in addition to 7.1-base
?After studying the docker container produced from Dockerfile, I discovered why the resulting image has problems with not only Marketplace, but also schema publishing. There is a mixture of permissions between root and say the user 'pentaho'. This is easily fixed near the end of the build by 'chown -R $BISERVER_USER.$BISERVER_USER /biserver-ce'
Add more tools / utilities for convenience, for examples:
A better idea is probably to introduce a lightweight graphql server with most pentaho rest apis encasulated for ease of use.
On Mac 10.14.5 pulling 7.1 image using following command works great for me.
docker pull zhicwu/biserver-ce:7.1; docker run --name bi -p 8080:8080 -d zhicwu/biserver-ce:7.1 biserver;docker logs -f bi
When I try running docker compose off of origin/7.1 branch using following command I get an error.
docker-compose up -d;docker-compose logs -f
DEBUG: Using JAVA_HOME
bi | DEBUG: _PENTAHO_JAVA_HOME=/usr/lib/jvm/java-8-oracle
bi | DEBUG: _PENTAHO_JAVA=/usr/lib/jvm/java-8-oracle/bin/java
bi | Killed
bi | *** ./docker-entrypoint.sh exited with status 137.
bi | *** Shutting down runit daemon (PID 9)...
bi | *** Killing all processes...
bi | *** Running /etc/my_init.d/00_regen_ssh_host_keys.sh...
bi | *** Running /etc/rc.local...
bi | *** Booting runit daemon...
bi | *** Runit started as PID 8
bi | *** Running ./docker-entrypoint.sh biserver...
bi | Running custom installation script...
bi | * Installing additional files...
bi | * Enabling URL-based authentication...(i.e. ...?userid=admin&password=password)
bi | * Setup environments...
bi | Fixing permissions...
bi | DEBUG: Using JAVA_HOME
bi | DEBUG: _PENTAHO_JAVA_HOME=/usr/lib/jvm/java-8-oracle
bi | DEBUG: _PENTAHO_JAVA=/usr/lib/jvm/java-8-oracle/bin/java
bi | Jun 13 11:08:28 localhost syslog-ng[16]: syslog-ng starting up; version='3.5.6'
bi | Killed
bi | *** ./docker-entrypoint.sh exited with status 137.
bi | *** Shutting down runit daemon (PID 8)...
bi | *** Killing all processes...
I was trying to update the base branch to 8.3 and then got this error
[INFO] --- maven-install-plugin:2.4:install-file (default-cli) @ standalone-pom ---
[INFO] Installing /org.eclipse.swt.gtk.linux.x86_64-4.6.1.jar to /root/.m2/repository/org/eclipse/swt/org.eclipse.swt.gtk.linux.x86_64/4.6.1/org.eclipse.swt.gtk.linux.x86_64-4.6.1.jar
[INFO] Installing /tmp/mvninstall3451859682394367020.pom to /root/.m2/repository/org/eclipse/swt/org.eclipse.swt.gtk.linux.x86_64/4.6.1/org.eclipse.swt.gtk.linux.x86_64-4.6.1.pom
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 0.580 s
[INFO] Finished at: 2019-07-22T22:11:20Z
[INFO] Final Memory: 9M/303M
[INFO] ------------------------------------------------------------------------
[INFO] Scanning for projects...
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building Maven Stub Project (No POM) 1
[INFO] ------------------------------------------------------------------------
[INFO]
[INFO] --- maven-install-plugin:2.4:install-file (default-cli) @ standalone-pom ---
[INFO] Installing /syslog4j-0.9.46.jar to /root/.m2/repository/org/syslog4j/syslog4j/0.9.46/syslog4j-0.9.46.jar
[INFO] Installing /tmp/mvninstall6734464320327871163.pom to /root/.m2/repository/org/syslog4j/syslog4j/0.9.46/syslog4j-0.9.46.pom
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 0.561 s
[INFO] Finished at: 2019-07-22T22:11:22Z
[INFO] Final Memory: 9M/303M
[INFO] ------------------------------------------------------------------------
**[ERROR] Jul 22, 2019 10:29:11 PM java.util.prefs.FileSystemPreferences$1 run
[ERROR] INFO: Created user preferences directory.**
No idea which library could be
For now the image only support one database server, meaning all three databases including hibernate, jackrabbit and quartz exist in one database server, which is not always true.
Sorry for writing in this repo, I was unable to create issue in https://github.com/zhicwu/saiku
In latest branch saiku cannot save files. I've found an issue http://jira.meteorite.bi/browse/SKU-1579
and commits fixing it (OSBI/saiku@41a5628
and OSBI/saiku@a313e33 ).
I've applied patches and built it. But result artifacts don't match. Sources in saiku-bi-platform-plugin-p6 and saiku-service don't match to what I've found in your binary dist https://github.com/zhicwu/saiku/releases/download/3.8.8-SNAPSHOT/saiku-plugin-p6-3.8.8.zip
There is no package bi.meteorite.license, classes like org.saiku.plugin.LicenseUtils. Without it licensing doesnt't work.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.