将Pentaho的资源库迁移至MySQL中.docxVIP

将Pentaho的资源库迁移至MySQL中版本说明：MySQL数据库版本：5.7.3（mysql-installer-community--m13.2063434697.msi）Pentaho版本：（biserver-ce--752.zip）安装MySQL数据库，配置账户（例如：用户名root，密码root）启动pentaho解压biserver-ce--752.zip，双击\biserver-ce--752\biserver-ce\start-pentaho.bat，启动pentaho平台，查看登录是否正常：http://localhost:8080/pentaho创建数据库在MySQL中执行\biserver-ce--752\biserver-ce\data\ mysql5目录下的3个脚本：create_repository_mysql.sqlcreate_quartz_mysql.sqlcreate_jcr_mysql.sql修改pentaho配置文件applicationCperties打开\biserver-ce--752\biserver-ce\pentaho-solutions\system\目录下的：applicationCperties(红色字体是修改的配置项)datasource.driver.classname=com.mysql.jdbc.Driverdatasource.url=jdbc:mysql://localhost:3306/hibernatedatasource.username=rootdatasource.password=rootdatasource.validation.query=SELECT 1applicationCperties打开\biserver-ce--752\biserver-ce\pentaho-solutions\system\目录下的：applicationCperties，修改为下面的内容：jdbc.driver=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/hibernatejdbc.username= hibuserjdbc.password=passwordhibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialecthibernate-settings.xml打开\biserver-ce--752\biserver-ce\pentaho-solutions\system\hibernate目录下的：hibernate-settings.xml，修改config-file标签config-filesystem/hibernate/mysql5.hibernate.cfg.xml/config-filecontext.xml打开\biserver-ce--752\biserver-ce\tomcat\webapps\pentaho\META-INF目录下的：context.xml，修改红色字体的内容Resource name=jdbc/Hibernate auth=Container type=javax.sql.DataSourcefactory=mons.dbcp.BasicDataSourceFactory maxActive=20 maxIdle=5maxWait=10000 username=hibuser password=passworddriverClassName=com.mysql.jdbc.Driver url=jdbc:mysql://localhost:3306/hibernatevalidationQuery=select 1 /Resource name=jdbc/Quartz auth=Container type=javax.sql.DataSourcefactory=mons.dbcp.BasicDataSourceFactory maxActive=20 maxIdle=5maxWait=10000 username=pentaho_user password=passworddriverClassName=com.mysql.jdbc.Driver url=jdbc:mysql://localhost:3306/quartzvalidationQuery=select 1/Catalina\localhost\ pentaho.xml打开\biserver-ce--752\biserver-ce\tomcat\conf\Catalina\localhost目录下的：pentaho.xml，修改