pentaho移植到MySQL

原创
2015/10/29 18:11
阅读数 146

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

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

BapplicationContext-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-INFcontext.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启动程序即可

 

 

展开阅读全文
打赏
0
0 收藏
分享
加载中
更多评论
打赏
0 评论
0 收藏
0
分享
返回顶部
顶部