pentaho mysql配置

ゝ一世哀愁。 2022-08-04 12:59 187阅读 0赞

1. groupadd pentaho  
2. useradd --system --gid pentaho  pentaho  
3. mkdir /opt/pentaho  
4. chown -R pentaho:pentaho /opt/pentaho  
5. 配置JAVA\_HOME  
6. 启动脚本pentaho-init.sh：  
  
  
\#!/bin/sh  
\# go to the pentaho home  
cd /opt/pentaho/biserver-ce  
\# set up command for pentaho user, set java environment  
cmd="sudo -u pentaho JAVA\_HOME=/usr/local/jdk1.7.0\_67 JAVA\_OPTS=-Djava.awt.headless=true"   
case "$1" in  
start)  
\# run the original pentaho start script  
$cmd ./start-pentaho.sh >> pentaho-demo.log &  
;;  
stop)  
\# run the original pentaho start script  
$cmd ./stop-pentaho.sh >> pentaho-demo.log &  
;;  
restart)  
$0 stop  
$0 start  
;;  
\*)  
echo "Usage: $0 \{start|stop|restart \}"  
exit 1  
esac  
exit 0  
  
  
  
  
7. 修改配置文件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="hibuser" 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="pentaho\_user" password="password"  
                driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/quartz"  
                validationQuery="select 1"/>  
  
  
</Context>  
  
  
  
  
8. 修改配置文件pentaho-solutions/system/hibernate/hibernate-settings.xml  
修改为：  
<config-file>system/hibernate/mysql5.hibernate.cfg.xml</config-file>  
  
  
  
  
9. 修改pentaho-solutions/system/applicationContext-spring-security-hibernate.properties  
jdbc.driver=com.mysql.jdbc.Driver  
jdbc.url=jdbc:mysql://localhost:3306/hibernate  
jdbc.username=hibuser  
jdbc.password=password

hibernate.dialect=org.hibernate.dialect.MySQLDialect

10.安装mysql，yum install mysql 安装配置mysql

参考http://blog.csdn.net/vah101/article/details/5774636

11.执行sql脚本，注入系统表

mysql -uroot -ppasswd < data/mysql5/create\_jcr\_mysql.sql   
mysql -uroot -ppasswd < data/mysql5/create\_repository\_mysql.sql   
mysql -uroot -ppasswd < data/mysql5/create\_quartz\_mysql.sql

进入mysql，为pentaho用户配置远程权限

grant all on \*.\* to 'pentaho\_user'@'\*' identified by 'password';

flush privileges;