PENTAHO-SERVER-CE-9.4配置MYSQL8存储

环境：虚拟机WINDOWS2019 + MYSQL-8.0.45+ JAVA8U202 .

1. 安装JAVA-8U202
2. 解压安装MYSQL-8.0.45-winx64.zip ,
3. 解压“pentaho-server-ce-9.4.0.0-343.zip”到D:\pentaho-server
4. 修改D:\pentaho-server\data\mysql\ 下的三个SQL脚本（create_jcr_mysql.sql\create_quartz_mysql.sql\ create_repository_mysql.sql）的 字符集、密码插件、密码。
   例如：

1. 执行上面的三个SQL脚本，创建数据库，例如：
   
2. Jackrabbit 建表时可能依赖某些 MySQL 默认行为，若 sql_mode 包含 NO_ZERO_DATE、ONLY_FULL_GROUP_BY 等，可能导致 DDL 执行失败（错误可能被日志吞没）。请临时设置：
   
3. pentaho-server/pentaho-solutions/system/applicationContext-spring-security-jdbc.properties
   
4. pentaho-server/pentaho-solutions/system/quartz/quartz.properties
   
5. pentaho-server/pentaho-solutions/system/simple-jndi/jdbc.properties
   
   

SampleData/type=javax.sql.DataSource

SampleData/driver=com.mysql.cj.jdbc.Driver

SampleData/url=jdbc:mysql://localhost:3306/hibernate?useSSL=false&serverTimezone=UTC

SampleData/user=hibuser

SampleData/password=Win2019#

Hibernate/type=javax.sql.DataSource

Hibernate/driver=com.mysql.cj.jdbc.Driver

Hibernate/url=jdbc:mysql://localhost:3306/hibernate?useSSL=false&serverTimezone=UTC

Hibernate/user=hibuser

Hibernate/password=Win2019#

Quartz/type=javax.sql.DataSource

Quartz/driver=com.mysql.cj.jdbc.Driver

Quartz/url=jdbc:mysql://localhost:3306/quartz?useSSL=false&serverTimezone=UTC

Quartz/user=pentaho_user

Quartz/password=Win2019#

Shark/type=javax.sql.DataSource

Shark/driver=com.mysql.cj.jdbc.Driver

Shark/url=jdbc:mysql://localhost:3306/hibernate?useSSL=false&serverTimezone=UTC

Shark/user=hibuser

Shark/password=Win2019#

SampleDataAdmin/type=javax.sql.DataSource

SampleDataAdmin/driver=com.mysql.cj.jdbc.Driver

SampleDataAdmin/url=jdbc:mysql://localhost:3306/hibernate?useSSL=false&serverTimezone=UTC

SampleDataAdmin/user=hibuser

SampleDataAdmin/password=Win2019#

1. pentaho-server/pentaho-solutions/system/applicationContext-spring-security-hibernate.properties
   
2. pentaho-server\pentaho-solutions\system\dialects\mysql5\applicationContext-spring-security-hibernate.properties
   
3. pentaho-server/pentaho-solutions/system/hibernate/hibernate-settings.xml
   
4. pentaho-server/pentaho-solutions/system/hibernate/mysql5.hibernate.cfg.xml
   
5. 替换audit_sql.xml, 将D:\pentaho-server\pentaho-solutions\system\dialects\mysql5\audit_sql.xml放到
   D:\pentaho-server\pentaho-solutions\system 下,原来改名（=audit_sql.xml=）或删除.
   
6. pentaho-server/pentaho-solutions/system/jackrabbit\repository.xml
   
   
   

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

<param name="driver" value="com.mysql.cj.jdbc.Driver"/>

<param name="url" value="jdbc:mysql://localhost:3306/jackrabbit?useSSL=false&amp;serverTimezone=UTC"/>

<param name="user" value="jcr_user" />

<param name="password" value="Win2019#" />

<param name="databaseType" value="mysql"/>

<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>

<Cluster id="node1">

<!-- <Journal class="org.apache.jackrabbit.core.journal.MemoryJournal"/> -->

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

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

<param name="driver" value="com.mysql.cj.jdbc.Driver"/>

<param name="url" value="jdbc:mysql://localhost:3306/jackrabbit?useSSL=false&amp;serverTimezone=UTC"/>

<param name="user" value="jcr_user" />

<param name="password" value="Win2019#" />

<param name="schema" value="mysql"/>

<param name="databaseType" value="mysql"/>

<param name="janitorEnabled" value="true"/>

<param name="janitorSleep" value="86400"/>

<param name="janitorFirstRunHourOfDay" value="3"/>

</Journal>

</Cluster>

1. 换MYSQL驱动，由mysql-connector-java-5.1.17.jar换为mysql-connector-j-8.0.33.jar
   
2. 修改监听（pentaho-server/pentaho-solutions/system/systemListeners.xml）
   
   
3. Tomcat配置
   （1）、context.xml 配置
   

（2）、web.xml配置

18、如果在WINDOWS下，修改一下startup.bat 启动文件。

19、启动PENTAHO

启用失败，本地残留文件确保彻底删
除 D:\pentaho-server\pentaho-solutions\system\jackrabbit\repository 目录（或您配置的 rep.home 指向的路径）. 重新启用PENTAHO.

登陆界面：