zhicwu/docker-biserver-ce

Docker image for Pentaho BI server(community edition). https://hub.docker.com/r/zhicwu/biserver-ce/

docker-biserver-ce's Issues

saiku-plugin-p7-3.14.zip 404 not found

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.

Error while building

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

7.1 will not start

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...

MySQL - Repository Database

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

The following errors were detected
One or more system listeners failed. These are set in the systemListeners.xml.
    org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - Error while trying to execute startup sequence for org.pentaho.platform.scheduler2.quartz.EmbeddedQuartzSystemListener "

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.

cannot start BI 8.0-base

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.

More examples and docs

Examples:

• running different flavors of BI server
• running in different environments(docker, docker swarm, mesos, k8s)
• nginx/apache/traefik as reverse proxy in front of BI server
• running against different databases(MySQL & PostgreSQL)
• ansible scripts for rolling update cluster across data centers

Docs:

• tutorials
• hwotos (customize images?)
• known issues
• FAQ

with docker compose not retaining data

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

Cant resolve rm: cannot remove 'tomcat/temp': Directory not empty

*** 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)

upgrade to pentaho 8?

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?

More flavors and better hierarchy

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:

• multi-stage build and alpine for skinny image
• version number - 7.1-base-20170712 in addition to 7.1-base?

Fixed: Publishing Mondrian Schema via console

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'

More tools

Add more tools / utilities for convenience, for examples:

• (re)schedule a job
• purge jackrabbit repository
• purge useless(mostly empty) files in repository
• automated daily/weekly backup
• clear cache

A better idea is probably to introduce a lightweight graphql server with most pentaho rest apis encasulated for ease of use.

Error with docker compose

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...

Error while building 8.3 version

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

Multiple database servers support

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.

Saiku doesn't match pentaho 7.1 version

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.