pentaho移植到MySQL

pentaho配置详解，mysql版（biserver-ce-4.5.0-stable.zip)

(2012-07-16 16:39:44)

标签： pentaho biserver it

分类：pentaho

BIServer移植到mysql

1、下载biserver-ce-4.5.0-stable.zip

file:///C:/Users/MUHE/Downloads/biserver-ce-4.5.0-stable.zip

2、解压到E:\BI\pentaho

3、转到该路径下：E:\BI\pentaho\biserver-ce\pentaho-solutions\system

A、将applicationContext-spring-security-hibernate.properties文件的内容由：

jdbc.driver=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://localhost:3306/hibernate

jdbc.username=hibuser

jdbc.password=root

hibernate.dialect=org.hibernate.dialect.MySQLDialect

改成：

jdbc.driver=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://localhost:3306/hibernate

jdbc.username=root

jdbc.password=root

hibernate.dialect=org.hibernate.dialect.MySQLDialect

B、将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="root" />

                  <property name="password" value="root" />

</bean>

改成：

<bean id="dataSource"

                  class="org.springframework.jdbc.datasource.DriverManagerDataSource">

                  <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="root" />

</bean>

C、将--》进入hibernate目录：将mysql5.hibernate.cfg.xml中的：

<property name="connection.username">hibuser</property>

<property name="connection.password">password</property>

改成：

<property name="connection.username">root</property>

<property name="connection.password"> root</property>

D、将hibernate-settings.xml中的：

<config-file>system/hibernate/hsql.hibernate.cfg.xml</config-file>

改成：

<config-file>system/hibernate/mysql5.hibernate.cfg.xml</config-file>

E、找到E:\BI\pentaho\biserver-ce\tomcat\webapps\pentaho\WEB-INF下：web.xml

找到：

         <context-param>

                  <param-name>solution-path</param-name>

                  <param-value> </param-value>

         </context-param>

将我们之前的DB配置的solution设置进来：

<context-param>

                  <param-name>solution-path</param-name>

                  <param-value> E:\BI\pentaho\biserver-ce\pentaho-solutions</param-value>

</context-param>

F、找到E:\BI\pentaho\biserver-ce\tomcat\webapps\pentaho\META-INF下context.xml

将内容改为：

<?xml version="1.0" encoding="UTF-8"?>

<Context path="/pentaho"docbase="webapps/pentaho/">

         <Resourcename="jdbc/Hibernate" auth="Container"type="javax.sql.DataSource"

                  factory="org.apache.commons.dbcp.BasicDataSourceFactory"maxActive="20" maxIdle="5"

                  maxWait="10000" username="root" password="root"

                  driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/hibernate"

                  validationQuery="select 1" />

                  

         <Resourcename="jdbc/Quartz" auth="Container"type="javax.sql.DataSource"

                  factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20"maxIdle="5"

                  maxWait="10000" username="root" password="root"

                  driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/quartz"

                  validationQuery="select 1"/>

</Context>

G、找到：E:\BI\pentaho\biserver-ce\pentaho-solutions\bi-developers\datasources下的HQL_Datasource_MySQL.cfg.xml

将其中的：

         <propertyname="connection.username">hibuser</property>

    <propertyname="connection.password">password</property>

改为：

         <property name="connection.username">root</property>

    <property name="connection.password"> root</property>

4、配置环境变量：

CATALINA_OPTS= Dsun.rmi.dgc.server.gcInterval=3600000

PENTAHO_JAVA_HOME= C:\Program Files\Java\jdk1.6.0_31

5、导入SQL

找到E:\BI\pentaho\biserver-ce\data\mysql5文件下的四个文件，

进入mysql控制台，导入sql命令：顺序如下：

source E:\BI\pentaho\biserver-ce\data\mysql5\create_repository_mysql.sql

source  E:\BI\pentaho\biserver-ce\data\mysql5\create_quartz_mysql.sql

source  E:\BI\pentaho\biserver-ce\data\mysql5\load_sample_users_mysql.sql

source  E:\BI\pentaho\biserver-ce\data\mysql5\migration.sql

 

ok

现在已经导入完数据库了，可以点击

 

配置完毕。

运行：start-pentaho.bat启动程序即可