[{"_1":2,"_173":-5,"_174":-5},"loaderData",{"_3":4,"_13":14,"_21":22,"_152":153},"root",{"_5":-5,"_6":-7,"_7":8,"_9":-7,"_10":11,"_12":-7},"currentUser","primaryEmail","siteVerification","6LeIxAcTAAAAAJcZVRqyHh71UMIEGNQ_MXjiZKhI","toast","enableDev",false,"incidentStatus","routes/_layout",{"_15":-5,"_16":17,"_18":17,"_19":11,"_20":11},"username","isAskGordonEnabled",true,"isUsingNewTemplate","showMinimalLanding","showHoneypotTrap","routes/_layout.r.$namespace.$reponame",{"_23":24,"_25":-5,"_26":11,"_27":11,"_28":29,"_30":31,"_32":-5,"_33":11,"_34":35,"_84":85,"_107":108,"_145":-5,"_146":11,"_147":17,"_148":11,"_149":-5,"_150":151},"canonicalUrl","https://hub.docker.com/r/doccom/pentaho-bi-server-ce/tags","mcpServer","canSeeDockerfile","canSeeAutobuilds","namespace","doccom","reponame","pentaho-bi-server-ce","cloudBuildSource","isAutobuildsAvailable","repo",{"_36":37,"_38":39,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":51,"_53":31,"_28":29,"_54":55,"_56":40,"_57":58,"_59":58,"_60":61,"_62":-5,"_63":64,"_65":66,"_67":11,"_68":29,"_69":70,"_75":11,"_76":77,"_81":29,"_82":83},"categories",[],"content_types",[40],"image","date_registered","2019-07-29T23:32:29.049448Z","description","Pentaho Bi Server CE for docker, also contains Athena JDBC Driver","is_private","last_updated","2019-07-30T19:02:33.774207Z","last_modified","2024-10-16T13:48:34.145251Z","media_types",[52],"application/vnd.docker.container.image.v1+json","name","pull_count",1619,"repository_type","star_count",1,"status","status_description","active","source","collaborator_count",0,"full_description","# Pentaho BI Server\r\nThis project contains a Docker Image for deploying Pentaho BI Server with Tomcat and also contains the AthenaJDBC driver to enable connections to Amazon Athena\r\n\r\n\r\n###How to run this image\r\n```sh\r\n$ docker run --name my-bi-server -p 8080:8080 -d pentaho-server:tag\r\n```\r\n\r\n!!!!!!!!!!!!!!!!!!!!!!!!!!IMPORTANT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!\r\n\r\nWhen using a custom db environment it's necessary to create the db users, tables and schemas that Pentaho needs. You can find the PostgreSQL scripts in the postgresql-db-scripts directory. For other database engines you can find the corresponding scripts within the Pentaho Community Edition distribution, under /pentaho-server/data\r\n\r\nFor postgresql just run create_quartz_postgresql.sql,create_repository_postgresql.sql and create_jcr_postgresql.sql on your Postgresql DB instance\r\n\r\n!!!!!!!!!!!!!!!!!!!!!!!!!!IMPORTANT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!\r\n\r\n\r\nBy default Pentaho Server uses the file-system repository but you can change it to one of the supported databases.\r\n\r\nHere you can find the specific setup steps for each type of database:\r\n\r\n - [PostgreSQL][PSQL]\r\n - [MySQL][MSQL]\r\n - [Oracle][ORCL]\r\n - [MS SQL Server][MSSQL]\r\n\r\nMake sure that your db repository is up and running and has the necessary schemas, then you basically need to edit three files to specify your custom connections\r\n\r\nYou can find a copy of the configuration files on this [repo][PDBCONF], download them and edit them with your own connections\r\n\r\n##For a PostgreSQL repository:\r\n\r\n###Step 1: Set up Quartz on PostgreSQL\r\nEvent information, such as scheduled reports, is stored in the Quartz JobStore. During the installation process, you must indicate where the JobStore is located by modifying the quartz.properties file.\r\n\r\nOpen quartz.properties file in any text editor.\r\nLocate the #_replace_jobstore_properties section and set the org.quartz.jobStore.driverDelegateClass as shown:\r\n\r\n```sh\r\n- 1 | org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.PostgreSQLDelegate\r\n```\r\n\r\nLocate the # Configure Datasources section and set the org.quartz.dataSource.myDS.jndiURL equal to Quartz, as shown:\r\n\r\n```sh\r\n- 1 | org.quartz.dataSource.myDS.jndiURL = Quartz\r\n```\r\nSave the file and close the text editor.\r\n\r\n### Step 2: Modify Jackrabbit repository information for PostgreSQL\r\nEdit the following code to change the default Jackrabbit repository to PostgreSQL.\r\n\r\nOpen the repository.xml file with any text editor.\r\n\r\nAs shown in the table below, locate and verify or change the code so that the PostgreSQL lines are not commented out, but the MySQL, Oracle, and MS SQL Server lines are commented out.\r\n\r\nCaution : If you have a different port or different password, make sure that you change the password and port number in these examples to match the ones in your configuration.\r\n\r\n

Item Code Section

Repository

\r\n\t\t\t\t\t\t\t\t\t\t

`1`	`<FileSystem` `class=\"org.apache.jackrabbit.core.fs.db.DbFileSystem\">`

`2`	`<param` `name=\"driver\"` `value=\"org.postgresql.Driver\"/>`

`3`	`<param` `name=\"url\"` `value=\"jdbc:postgresql://localhost:5432/jackrabbit\"/>`

4 ...

`5`	`</FileSystem>`

\r\n\t\t\t\t\t\t\t\t\t

DataStore

\r\n\t\t\t\t\t\t\t\t\t\t

`1`	`<DataStore` `class=\"org.apache.jackrabbit.core.data.db.DbDataStore\">`

`2`	`<param` `name=\"url\"` `value=\"jdbc:postgresql://localhost:5432/jackrabbit\"/>`

3 ...

`4`	`</DataStore>`

\r\n\t\t\t\t\t\t\t\t\t

Workspaces

\r\n\t\t\t\t\t\t\t\t\t\t

`1`	`<FileSystem` `class=\"org.apache.jackrabbit.core.fs.db.DbFileSystem\">`

`2`	`<param` `name=\"driver\"` `value=\"org.postgresql.Driver\"/>`

`3`	`<param` `name=\"url\"` `value=\"jdbc:postgresql://localhost:5432/jackrabbit\"/>`

4 ...

`5`	`</FileSystem>`

\r\n\t\t\t\t\t\t\t\t\t

PersistenceManager (1st part)

\r\n\t\t\t\t\t\t\t\t\t\t

`1`	`<PersistenceManager` `class=\"org.apache.jackrabbit.core.persistence.bundle.PostgreSQLPersistenceManager\">`

`2`	`<param` `name=\"url\"` `value=\"jdbc:postgresql://localhost:5432/jackrabbit\"/>`

3 ...

`4`	`<param` `name=\"schemaObjectPrefix\"` `value=\"${wsp.name}_pm_ws_\"/>`

`5`	`</PersistenceManager>`

\r\n\t\t\t\t\t\t\t\t\t

Versioning

\r\n\t\t\t\t\t\t\t\t\t\t

`1`	`<FileSystem` `class=\"org.apache.jackrabbit.core.fs.db.DbFileSystem\">`

`2`	`<param` `name=\"driver\"` `value=\"org.postgresql.Driver\"/>`

`3`	`<param` `name=\"url\"` `value=\"jdbc:postgresql://localhost:5432/jackrabbit\"/>`

4 ...

`5`	`</FileSystem>`

\r\n\t\t\t\t\t\t\t\t\t

PersistenceManager (2nd part)

\r\n\t\t\t\t\t\t\t\t\t\t

`1`	`<PersistenceManager` `class=\"org.apache.jackrabbit.core.persistence.bundle.PostgreSQLPersistenceManager\">`

`2`	`<param` `name=\"url\"` `value=\"jdbc:postgresql://localhost:5432/jackrabbit\"/>`

3 ...

`4`	`<param` `name=\"schemaObjectPrefix\"` `value=\"pm_ver_\"/>`

`5`	`</PersistenceManager>`

\r\n\t\t\t\t\t\t\t\t\t

DatabaseJournal

\r\n\t\t\t\t\t\t\t\t\t\t

`01`	`<Journal` `class=\"org.apache.jackrabbit.core.journal.DatabaseJournal\">`

`02`	`<param` `name=\"revision\"` `value=\"${rep.home}/revision.log\"/>`

`03`	`<param` `name=\"url\"` `value=\"jdbc:postgresql://localhost:5432/jackrabbit\"/>`

`04`	`<param` `name=\"driver\"` `value=\"org.postgresql.Driver\"/>`

`05`	`<param` `name=\"user\"` `value=\"jcr_user\"/>`

`06`	`<param` `name=\"password\"` `value=\"password\"/>`

`07`	`<param` `name=\"schema\"` `value=\"postgresql\"/>`

`08`	`<param` `name=\"schemaObjectPrefix\"` `value=\"cl_j_\"/>`

`09`	`<param` `name=\"janitorEnabled\"` `value=\"true\"/>`

`10`	`<param` `name=\"janitorSleep\"` `value=\"86400\"/>`

`11`	`<param` `name=\"janitorFirstRunHourOfDay\"` `value=\"3\"/>`

`12`	`</Journal>`

\r\n\t\t\t\t\t\t\t\t\t

\r\n\t\t\t\t\t\t\t\t\t\r\n##Step 3: Modify JDBC connection information in the Tomcat context.xml File\r\nDatabase connection and network information, such as the username, password, driver class information, IP address or domain name, and port numbers for your Pentaho Repository database are stored in the context.xml file. \r\n\r\nModify this file to reflect the database connection and network information to reflect your operating environment.\r\n\r\nIf you have chosen to use an Pentaho Repository database other than PostgreSQL, you also need to modify the values for the validationQuery parameters in this file.\r\n\r\nCaution : If you have a different port, password, user, driver class information, or IP address, make sure that you change the password and port number in these examples to match the ones in your configuration environment.\r\nConsult your database documentation to determine the JDBC class name and connection string for yourPentaho Repository database.\r\n\r\n- Open the context.xml file with any text editor.\r\n\r\n- Add the following code to the file if it does not already exist.\r\n\t\t\t\t\t\t\t\t\t\r\n

1 <Resource name=\"jdbc/Hibernate\" auth=\"Container\" type=\"javax.sql.DataSource\" factory=\"org.apache.tomcat.jdbc.pool.DataSourceFactory\" initialSize=\"0\" maxActive=\"20\" maxIdle=\"10\" maxWait=\"10000\" username=\"hibuser\" password=\"password\" driverClassName=\"org.postgresql.Driver\" url=\"jdbc:postgresql://localhost:5432/hibernate\" validationQuery=\"select 1\"/>

`2`	`<Resource` `name=\"jdbc/Audit\"` `auth=\"Container\"` `type=\"javax.sql.DataSource\"` `factory=\"org.apache.tomcat.jdbc.pool.DataSourceFactory\"` `initialSize=\"0\"` `maxActive=\"20\"` `maxIdle=\"10\"`

doccom/pentaho-bi-server-ce

Tags for doccom/pentaho-bi-server-ce