ca0abinary / docker-pentaho Goto Github PK

View Code? Open in Web Editor NEW

17.0 17.0 16.0 17 KB

Docker image for Pentaho Server

Home Page: https://hub.docker.com/r/ca0abinary/docker-pentaho/

License: MIT License

Shell 63.72% Dockerfile 36.28%

docker-pentaho's People

Contributors

Stargazers

Watchers

Forkers

eltechno lanphan tornmarketing salvatoretrimarchi smachado87 full360 nilroy tcnh jhulick djravine ytitov mvmendes tgarciai im-alexandre mmbbrepo

docker-pentaho's Issues

Kubernetes Yaml

Hello i need to run pentaho docker on kubernetes with mount volume, but getting error
any reference for yaml file with hypersql

Adding plugins

As a newbee it would help to understand where the installation of plugins would go. Even if there was a comment or commented out commands.

MaxPermSize warning in JDK 8

Found this warning while running docker image

OpenJDK 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0

Upgrade JDK to 8 and fix NPE in report generation

First of all thanks for the awesome work done here. First please upgrade the docker file to use OpenJDK 8 since it is the supported version for v7. Please see the Pentaho v7 Components Reference.

Also there is a regression with report generation when headless JDK 7 (not sure jdk 8 has an issue):

You need to add the following:

# Fix NPE in non-pdf report generation
# See https://github.com/docker-library/openjdk/issues/73
USER root
RUN apk add --update ttf-dejavu

If you would like, I could submit a PR for it.

Quartz and Hibernate + PostgreSQL Investigation

I bet this line is part of the Hibernate/Quartz connection problem. localhost is on 127.x.x.x range on your machine but in a docker environment it is actually another IP address that can be in the 172.x.x.x range on my machine. Maybe that's part of the problem?

We may need to patch it with the PG_HOST environment variable.

PentahoSystem.ERROR_0014

I created the following docker compose:

version: "3"
services:
  # Pentaho BI
  pentaho:
    container_name: pentaho
    image: ca0abinary/docker-pentaho
    depends_on:
      - pentaho-pg
    ports:
      - "8080:8080"
    environment:
      - PGHOST=pentaho-pg
      - PGUSER=pentaho
      - PGPASSWORD=password
    volumes:
      - pentaho-hsqldb-data:/opt/pentaho/server/pentaho-server/data/hsqldb
      - pentaho-jackrabbit-data:/opt/pentaho/server/pentaho-server/pentaho-solutions/system/jackrabbit/repository
    networks:
      - integracion

  # PostgreSQL Database for Pentaho BI
  pentaho-pg:
    container_name: pentaho-pg
    image: postgres:9.4
    ports:
      - "4432:5432"
    environment:
      - POSTGRES_USER=pentaho
      - POSTGRES_PASSWORD=password
      - PGDATA=/var/lib/postgresql/data/pgdata
    volumes:
      - pentaho-pg-data:/var/lib/postgresql/data/pgdata
    networks:
      - integracion

volumes:
    pentaho-hsqldb-data: null
    pentaho-jackrabbit-data: null
    pentaho-pg-data: null
networks:
    integracion:
        driver: bridge
        ipam:
            driver: default
            config:
              - subnet: 172.19.0.0/16

then execute docker-compose up

and te output is:

pentaho       | 21:38:11,794 ERROR [Logger] Error: Pentaho
pentaho       | 21:38:11,795 ERROR [Logger] misc-org.pentaho.platform.engine.core.system.PentahoSystem: org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - Error while trying to execute startup sequence for org.pentaho.platform.engine.services.connection.datasource.dbcp.DynamicallyPooledDatasourceSystemListener
pentaho       | org.pentaho.platform.api.engine.PentahoSystemException: org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - Error while trying to execute startup sequence for org.pentaho.platform.engine.services.connection.datasource.dbcp.DynamicallyPooledDatasourceSystemListener
pentaho       | 	at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:369)
pentaho       | 	at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:331)
pentaho       | 	at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:227)
pentaho       | 	at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:162)
pentaho       | 	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4853)
pentaho       | 	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5314)
pentaho       | 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)
pentaho       | 	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
pentaho       | 	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
pentaho       | 	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
pentaho       | 	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1092)
pentaho       | 	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1834)
pentaho       | 	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
pentaho       | 	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
pentaho       | 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
pentaho       | 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
pentaho       | 	at java.lang.Thread.run(Thread.java:745)
pentaho       | Caused by: org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - Error while trying to execute startup sequence for org.pentaho.platform.engine.services.connection.datasource.dbcp.DynamicallyPooledDatasourceSystemListener
pentaho       | 	at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:451)
pentaho       | 	at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:433)
pentaho       | 	at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:412)
pentaho       | 	at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:433)
pentaho       | 	at org.pentaho.platform.engine.core.system.PentahoSystem.access$000(PentahoSystem.java:83)
pentaho       | 	at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:364)
pentaho       | 	at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:361)
pentaho       | 	at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:412)
pentaho       | 	at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:361)
pentaho       | 	... 16 more
pentaho       | Caused by: java.lang.NullPointerException
pentaho       | 	at org.pentaho.platform.repository.JcrBackedDatasourceMgmtService.init(JcrBackedDatasourceMgmtService.java:67)
pentaho       | 	at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.retreiveObject(AbstractSpringPentahoObjectFactory.java:266)
pentaho       | 	at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.get(AbstractSpringPentahoObjectFactory.java:82)
pentaho       | 	at org.pentaho.platform.engine.core.system.objfac.AggregateObjectFactory.get(AggregateObjectFactory.java:273)
pentaho       | 	at org.pentaho.platform.engine.core.system.objfac.AggregateObjectFactory.get(AggregateObjectFactory.java:137)
pentaho       | 	at org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledDatasourceSystemListener.getListOfDatabaseConnections(NonPooledDatasourceSystemListener.java:137)
pentaho       | 	at org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledDatasourceSystemListener.startup(NonPooledDatasourceSystemListener.java:53)
pentaho       | 	at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:442)
pentaho       | 	... 24 more

Empty and weird hsqldb folder

While investigating other problems, I found the following empty folder hsqldb, that is owned by root:root. I added some newlines for readability. Any ideas?

$ sudo docker exec -it pentaho /bin/bash

bash-4.3# cd /opt/pentaho/server/pentaho-server/data/

bash-4.3# ls -al | grep hsqldb
drwxr-xr-x    5 pentaho  pentaho       4096 Apr 18 05:01 hsqldb
drwxr-xr-x    2 root     root          4096 Apr 18 05:01 hsqldb,

bash-4.3# ls -alR hsqldb,
hsqldb,:
total 8
drwxr-xr-x    2 root     root          4096 Apr 18 05:01 .
drwxr-xr-x   10 pentaho  pentaho       4096 Apr 18 05:01 ..

Sample compose file error

There is an error

ERROR: The Compose file './docker-compose.yml' is invalid because:
Unsupported config option for pentaho: 'depends_on'
Unsupported config option for volumes: 'pentaho-jackrabbit-data'

It happens because the given compose file sample doesn't include
version field as well as the root services field.

The following structure fixes it

version: "3" # <--- added
services:    # <--- added

    # Pentaho BI
    pentaho:
        container_name: pentaho
        image: ca0abinary/docker-pentaho
        depends_on: 
            - pentaho-pg
        ports:
            - "8080:8080"
...

Upgrade to 7.1 request

Any plans to upgrade this docker image please to 7.1?

Source: 7.1 Release notes

Recommend Projects

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.
Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
TensorFlow

An Open Source Machine Learning Framework for Everyone
Django

The Web framework for perfectionists with deadlines.
Laravel

A PHP framework for web artisans
D3

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
web

Some thing interesting about web. New door for the world.
server

A server is a program made to process requests and deliver data to clients.
Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Visualization

Some thing interesting about visualization, use data art
Game

Some thing interesting about game, make everyone happy.

Recommend Org

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft

Open source projects and samples from Microsoft.
Google

Google ❤️ Open Source for everyone.
Alibaba

Alibaba Open Source for everyone
D3

Data-Driven Documents codes.
Tencent

China tencent open source team.