virtualbox虚拟机Ubuntu配置pentaho环境BI

1、安装jdk

sudo apt-get  install openjdk-7-jdk

sudo vim ~/.bashrc

i

在底部加上

export JAVA_HOME=/usr/lib/jvm/java-7-openjdk-i386
export CLASSPATH=.:$JAVA_HOME/lib:$JAVA_HOME/jre/lib:$CLASSPATH
export PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$PATH

esc

:wq

source ~/.bashrc

2、安装mysql

sudo apt-get install mysql-server

 

要输入两次密码，我这里就输入root

mysql -uroot –proot

 

exit

启动

sudo chmod +x /var/lib/mysql 

sudo /etc/init.d/mysql start

3、安装pentaho

http://sourceforge.jp/projects/sfnet_pentaho/releases/  下载一个你需要的版本

cd /usr/local/

mkdir pentaho

cd  pentaho

sudo wget http://ftp.jaist.ac.jp/pub/sourceforge/p/pe/pentaho/Business%20Intelligence%20Server/5.1/biserver-ce-5.1.0.0-752.zip

sudo chmod 777 /usr/local/pentaho

unzip biserver-ce-5.1.0.0-752.zip

 

4、配置web.xml

cd  /usr/local/pentaho/biserver-ce/tomcat/webapps/pentaho/WEB-INF/

sudo vim web.xml

i 

<context-param>

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

              <param-value>/usr/local/pentaho/biserver-ce/pentaho-solutions</param-value>

       </context-param>

       <context-param>

              <param-name>base-url</param-name>

              <param-value></param-value>

       </context-param>

       <context-param>

              <param-name>fully-qualified-server-url</param-name>

              <param-value>http://localhost:8080/pentaho/</param-value>

       </context-param>

 esc

:wq

5、配置server.xml 

cd  /usr/local/pentaho/biserver-ce/tomcat/conf

重点，不配置会报错，如图

 

 

sudo vim server.xml

i 

在<host></host>中加入

 

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

<Resource name="jdbc/SampleData" auth="Container" type="javax.sql.DataSource" maxActive="20"

maxIdle="5" maxWait="10000" username="pentaho_user" password="password"

factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="com.mysql.jdbc.Driver"

url="jdbc:mysql://localhost:3306/sampledata"/>

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

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

<Resource name="jdbc/Shark" auth="Container" type="javax.sql.DataSource"

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

maxWait="10000" username="sa" password="" driverClassName="com.mysql.jdbc.Driver"

url="jdbc:mysql://localhost:3306/shark"/>

</Context>

ESC 

:wq

6、配置 applicationContext-spring-security-hibernate.properties

cd /usr/local/pentaho/biserver-ce/pentaho-solutions/system

sudo vim applicationContext-spring-security-hibernate.properties

i 

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

ESC

:wq

7、配置applicationContext-spring-security-jdbc.properties

cd /usr/local/pentaho/biserver-ce/pentaho-solutions/system

sudo vim applicationContext-spring-security-jdbc.properties

4.x版本中是sudo vim applicationContext-spring-security-jdbc.xml

i

datasource.driver.classname=com.mysql.jdbc.Driver

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

datasource.username=root

datasource.password=root

ESC

:wq

 8、配置 mysql5.hibernate.cfg.xml

cd /usr/local/pentaho/biserver-ce/pentaho-solutions/system/hibernate

sudo vim  mysql5.hibernate.cfg.xml

i 

    <propertyname="connection.driver_class">com.mysql.jdbc.Driver</property>

    <propertyname="connection.url">jdbc:mysql://localhost:3306/hibernate</property>

    <propertyname="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>

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

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

 ESC 

:wq

9、配置hibernate-settings.xml

cd /usr/local/pentaho/biserver-ce/pentaho-solutions/system/hibernate

sudo vim hibernate-settings.xml

改为

<?xml version='1.0' encoding='utf-8'?>
<settings>
        <config-file>
system/hibernate/mysql5.hibernate.cfg.xml
</config-file>
       <managed>false</managed>
</settings>

 

10、配置context.xml

cd /usr/local/pentaho/biserver-ce/tomcat/webapps/pentaho/META-INF

sudo vim 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="select1" />

             

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

</Context>

 

11、导入sql

cd /usr/local/pentaho/biserver-ce/data/mysql5

5.x和4.x版本不同，sql文件也不一样，注意

mysql -uroot –proot

进入mysql控制台，导入sql命令：

source  /usr/local/pentaho/biserver-ce/data/mysql5/create_repository_mysql.sql;

source  /usr/local/pentaho/biserver-ce/data/mysql5/create_quartz_mysql.sql;

source  /usr/local/pentaho/biserver-ce/data/mysql5/create_jcr_mysql.sql;

4.x

source  /usr/local/pentaho/biserver-ce/data/mysql5/create_repository_mysql.sql;

source  /usr/local/pentaho/biserver-ce/data/mysql5/create_quartz_mysql.sql;

source  /usr/local/pentaho/biserver-ce/data/mysql5/create_sample_datasource_mysql.sql;

source  /usr/local/pentaho/biserver-ce/data/mysql5/migration.sql;

 

12、运行

cd /usr/local/pentaho/biserver-ce/tomcat/bin

sudo  chmod +x *.sh

cd   /usr/local/pentaho/biserver-ce/data

sh  ./start_hypersonic.sh  启动数据库

cd   /usr/local/pentaho/biserver-ce/

sh  ./start-pentaho.sh

Windows下是start-pentaho.bat

cd /usr/local/pentaho/biserver-ce/tomcat/bin

 sh ./startup.sh

 sh ./catalina.sh run

建议大家还是用4.x，5.x改动太大

 

13、FAQ

1、 ./start-pentaho.sh

Cannot find ./catalina.sh

This file isneeded to run this program

cd 跳转到tomcat/bin目录执行 sudo  chmod +x *.sh

2、zh_CN_49

 如果你已启动 ./start-pentaho.sh

 先sh ./stop-pentaho.sh

 cd  /usr/local/pentaho/biserver-ce/data/

sh ./start_hypersonic.sh

欢迎大家交流

转载请注明出处