北京纵横.张志宇.pentaho mysql 配置.docx

 

pentaho mysql 配置 .docx

1.   下载

Reporting

prd-ce-3.8.3-GA.zip

http://community.pentaho.com/

 

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 是不能够作为切换数据库使用的