Pre-requisite
Centos Linux 7.2 on x86_64
Java Runtime Environment OpenJDK 1.8.0_121
MySQL 5.7
Create a user id pentaho that have administration privileges.
$ id pentaho
uid=6006(pentaho) gid=6006(pentaho) groups=6006(pentaho),10(wheel),66(database)
Ensure JAVA_HOME contains directory of the JVM
$ env |grep JAVA_HOME
If value is empty, add following to ~/.bashrc
export JAVA_HOME=/usr/lib/jvm/jre
Step 1: Download pentaho-server-ce-7.0.0.0-25.zip
Login to the Linux server as user id pentaho$ links https://sourceforge.net/projects/pentaho/files/Business%20Intelligence%20Server/7.0/
. . .
$ unzip pentaho-server-ce-7.0.0.0-25.zip
$ cd pentaho-server
Step 2: Prepare the database
$ cd data/mysql5
Edit .sql files to use user pentaho and password <password>. Check with SQL syntax if needed.
- create_jcr_mysql.sql
- create_quartz_mysql.sql
- create_repository_mysql.sql
Login to Mysql and create the database with user ID pentaho
> create database quartz;
> create database jackrabbit;
> create database hibernate;
> create user 'pentaho'@'localhost' identified by 'Password';
> grant all privileges on quartz.* to 'pentaho'@'localhost' with grant option;
> source create_jcr_mysql.sql
> source create_quartz_mysql.sql
> source create_repository_mysql.sql
$ cd ..
$ ./set-pentaho-env.sh
Edit following file and replace all mention of mysql user and database.
- pentaho-solutions/system/jackrabbit/repository.xml
=== START
<FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
<param name="driver" value="com.mysql.jdbc.Driver"/>
<param name="url" value="jdbc:mysql://localhost:3306/jackrabbit"/>
<param name="user" value="
<param name="password" value="password"/>
<param name="schema" value="mysql"/>
<param name="schemaObjectPrefix" value="fs_repos_"/>
</FileSystem>
<DataStore class="org.apache.jackrabbit.core.data.db.DbDataStore">
<param name="url" value="jdbc:mysql://localhost:3306/jackrabbit"/>
<param name="user" value="
<param name="password" value="password"/>
<param name="databaseType" value="mysql"/>
<param name="driver" value="com.mysql.jdbc.Driver"/>
<param name="minRecordLength" value="1024"/>
<param name="maxConnections" value="3"/>
<param name="copyWhenReading" value="true"/>
<param name="tablePrefix" value=""/>
<param name="schemaObjectPrefix" value="ds_repos_"/>
</DataStore>
. . .
=== END
Edit the file tomcat/webapps/pentaho/META-INF/context.xml and replace user ID and password for database
=== START
<Context path="/pentaho" docbase="webapps/pentaho/">
<Resource name="jdbc/Hibernate" auth="Container" type="javax.sql.DataSource"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxTotal="20" maxIdle="5"
maxWaitMillis="10000" username="
driverClassName="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:hsql://localhost/hibernate"
validationQuery="select
<Resource name="jdbc/Quartz" auth="Container" type="javax.sql.DataSource"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxTotal="20" maxIdle="5"
maxWaitMillis="10000" username="
driverClassName="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:hsql://localhost/quartz"
validationQuery="select
</Context>
=== END
Configure not to use dynamic listeners for the development server. Edit vi pentaho-solutions/system/systemListeners.xml
Comment out following beans
=== START
<!--
<bean id="pooledDataSourceSystemListener" class="org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceSystemListener" />
-->
<!--
bean id="dynamicallyPooledDataSourceSystemListener" class="org.pentaho.platform.engine.services.connection.datasource.dbcp.DynamicallyPooledDatasourceSystemListener" />
-->
=== END
Step 3: Start Pentaho
$ ./start-pentaho.sh
DEBUG: Using JAVA_HOME
DEBUG: _PENTAHO_JAVA_HOME=/usr/lib/jvm/jre
DEBUG: _PENTAHO_JAVA=/usr/lib/jvm/jre/bin/java
Using CATALINA_BASE: /home/pentaho/pentaho-server/tomcat
Using CATALINA_HOME: /home/pentaho/pentaho-server/tomcat
Using CATALINA_TMPDIR: /home/pentaho/pentaho-server/tomcat/temp
Using JRE_HOME: /usr/lib/jvm/jre
Using CLASSPATH: /home/pentaho/pentaho-server/tomcat/bin/bootstrap.jar:/home/pentaho/pentaho-server/tomcat/bin/tomcat-juli.jar
Tomcat started.
Successful startup as shown in pentaho.log |
With a web browser access localhost:8080/pentaho with default user ID displayed at login page. The default admin User Name is admin.
At login, the Pentaho User Console (PUC) is displayed.
Troubleshooting notes:
When loading the web site it displaysPentahoSystem.ERROR_0014
Verify that the file tomcat/webapps/pentaho/META-INF/context.xml is edited as above. It should have the validationQuery="select 1"
Reference: https://help.pentaho.com/Documentation/7.0/0F0/0P0/020/0B0#Install_the_Pentaho_Repository_Host_Database
No comments:
Post a Comment