Public | Automated Build

Last pushed: 20 hours ago
Short Description
Pentaho BI server(community edition) docker image for development and testing purposes.
Full Description

docker-biserver-ce

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

What's inside

ubuntu:16.04
 |
 |-- phusion/baseimage:0.9.22
      |
      |-- zhicwu/java:8
           |
           |-- zhicwu/biserver-ce:7.1-base
                |
                |-- zhicwu/biserver-ce:7.1-full
                    |
                    |-- zhicwu/biserver-ce:7.1

Known issue

Get started

  • Run vanilla Pentaho server
    $ docker run --name bi -p 8080:8080 -p 12345:1234 -d zhicwu/biserver-ce:7.1
    $ docker logs -f bi
    
  • Run patched Pentaho server
    $ docker run --name bi -e APPLY_PATCHES=Y -p 8080:8080 -p 12345:1234 -d zhicwu/biserver-ce:7.1
    $ docker logs -f bi
    
  • Use docker-compose (Recommended)
    $ git clone https://github.com/zhicwu/docker-biserver-ce.git -b 7.1 --single-branch
    $ cd docker-biserver-ce
    ... edit .env and/or docker-compose.yml based on your needs, put your Pentaho configuration files under ext directory if necessary ...
    $ docker-compose up -d
    $ docker-compose logs -f
    
    Regardless which approach you took, after server started, you should be able to access Pentaho Server(admin/password) and monitor metrics using Prometheus and Grafana.

How to use external database

Taking MySQL 5.x as an example. Assuming you have pbi_repository, pbi_quartz and pdi_jcr 3 databases created, change docker-compose.yml to set STORAGE_TYPE to mysql5, and then mount volume ./database.env:/biserver-ce/data/database.env with the following content:

SERVER_PASSWD=password
DB_HOST=xxx
DB_PORT=3306
DB_USER=xxx
DB_PASSWD=xxx

How to build

$ git clone https://github.com/zhicwu/docker-biserver-ce.git -b 7.1 --single-branch
$ cd docker-biserver-ce
$ docker build -t my/biserver:7.1 .
Docker Pull Command
Owner
zhicwu
Source Repository

Comments (4)
akj131183
a month ago

Hi zhicwu,
Could you please give your valuable comment.
How you done Saiku - enabled SaikuWidgetComponent in CDE..
Thanks !!

akj131183
a month ago

How you done Saiku - enabled SaikuWidgetComponent in CDE.
Please give me your valuable comment.
I want to use saiku in Pentaho CDE.

zhicwu
2 months ago

Sorry I missed this. Someone else asked similar issue before, I'm working on a new hierarchy for building the images and I'll work this out and document the instructions.

Feel free to submit an issue on github to track the status.

nquarato
3 months ago

Hi zhicwu,
I'm trying to set external postgres database, but I received (java.net.ConnectException: Connection refused (Connection refused)).
I have created three databases, mounted the volume ./secret.env:/biserver-ce/data/secret.env:rw update the files .ENV ( STORAGE_TYPE=postgresql ) , loaded .ENV file in compose-file, edited file secret.env as below:
SERVER_PASSWD=password
DB_HOST=postgres
DB_PORT=5432
DB_USER=postgres
DB_PASSWD=postgres

The postgres database is reachable by other container with upper information.
where I wrong? could you explain better how I can connect to external postgres database? thanks