pentaho mysql 配置 .docx
1. 下载
Reporting
prd-ce-3.8.3-GA.zip
mysql 数据:
http://www.prashantraju.com/projects/pentaho/
2. 导入数据时注意,用户密码改成自己的
GRANT ALL ON hibernate.* TO 'hibuser'@'localhost' identified by 'password'; grant all on quartz.* to 'pentaho_user'@'localhost' identified by 'password'; grant all on sampledata.* to pentaho_user identified by 'password'; grant all on sampledata.* to pentaho_admin identified by 'password'; |
3. D:\pentaho\biserver-ce\pentaho-solutions\system\publisher_config.xml
<publisher-config> <publisher-password>password</publisher-password> </publisher-config> |
4. D:\pentaho\biserver-ce\pentaho-solutions\system\applicationContext-spring-security-jdbc.xml
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <!-- <property name="driverClassName" value="org.hsqldb.jdbcDriver" /> <property name="url" value="jdbc:hsqldb:hsql://localhost:9001/hibernate" /> <property name="username" value="hibuser" /> <property name="password" value="password" /> --> <property name="driverClassName" value="com.mysql.jdbc.Driver" /> <property name="url" value="jdbc:mysql://localhost:3306/hibernate" /> <property name="username" value="root" /> <property name="password" value="PASSWORD" /> </bean> |
5. D:\pentaho\biserver-ce\pentaho-solutions\system\applicationContext-spring-security-hibernate.properties
jdbc.driver=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql://localhost:3306/hibernate jdbc.username=root jdbc.password=PASSWORD hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect |
6. D:\pentaho\biserver-ce\pentaho-solutions\system\hibernate\hibernate-settings.xml
<config-file>system/hibernate/mysql5.hibernate.cfg.xml</config-file> |
7. D:\pentaho\biserver-ce\pentaho-solutions\system\hibernate\mysql5.hibernate.cfg.xml
<!-- MySQL Configuration --> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="connection.url">jdbc:mysql://localhost:3306/hibernate</property> <property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> <property name="connection.username">root</property> <property name="connection.password">PASSWORD</property> |
8. D:\pentaho\biserver-ce\tomcat\webapps\pentaho\META-INF\context.xml
<?xml version="1.0" encoding="UTF-8"?> <Context path="/pentaho" docbase="webapps/pentaho/"> <Resource name="jdbc/Hibernate" auth="Container" type="javax.sql.DataSource" factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5" maxWait="10000" username="root" password="PASSWORD" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/hibernate" validationQuery="select 1" />
<Resource name="jdbc/Quartz" auth="Container" type="javax.sql.DataSource" factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5" maxWait="10000" username="root" password="PASSWORD" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/quartz" validationQuery="select 1"/> </Context> |
9. D:\ pentaho \biserver-ce\tomcat\conf\Catalina\localhost\pentaho.xml
<?xml version="1.0" encoding="UTF-8"?> <Context path="/pentaho" docbase="webapps/pentaho/"> <Resource name="jdbc/Hibernate" auth="Container" type="javax.sql.DataSource" factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5" maxWait="10000" username="root" password="PASSWORD" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/hibernate" validationQuery="select 1" />
<Resource name="jdbc/Quartz" auth="Container" type="javax.sql.DataSource" factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5" maxWait="10000" username="root" password="PASSWORD" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/quartz" validationQuery="select 1"/> </Context> |
10. 重新启动 pentaho (运行 start-pentaho.bat )
11. 还有一步
进入 admin istration-console 修改数据源配置即可(不需要重新启动 pentaho )。启动 administration-console\start-pac.bat ,在浏览器中输入 http://localhost:8099 ,以 admin/password 登录后修改 SampleData 数据源即可,注意处理修改 jdbc 配置外,把 validationQuery 的值修改为 select 1 ,使用 test 按钮测试一下。
在浏览器中输入 http://localhost:8080 即可进入 pentaho 页面。
备注: Pentaho.BI.Server 解压缩之后生成的 Mysql5 文件夹下面的 SQL 是不能够作为切换数据库使用的