search

zhicwu / docker-biserver-ce

Docker image for Pentaho BI server(community edition). https://hub.docker.com/r/zhicwu/biserver-ce/
38 stars 27 forks source link

cannot start BI 8.0-base #47

Open lanphan opened 6 years ago

lanphan commented 6 years ago

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.