Wednesday, September 15, 2010

settings for Pentaho BI Server with MySQL DB

 After extracting pentaho-ce-3.5.0.stable.zip on computer then directory structure as follows :
\pentaho\ adminstration-console\
\pentaho\ biserver-ce\

For setting up Pentaho BI Server you need to change in
biserver-ce directory
biserver-ce\
pentaho-solutions\System\applicationContext-spring-security-jdbc.xmlbiserver-ce\pentaho-solutions\System\ applicationContext-spring-security-hibernate.propertiesbiserver-ce\pentaho-solutions\System\ hibernate\hibernate-settings.xmlbiserver-ce\pentaho-solutions\System\ hibernate\ mysql5.hibernate.cfg.xml biserver-ce\tomcat\web-apps\pentaho\WEB-INF\web.xml

biserver-ce\tomcat\META-INF\context.xml

above mentioned file need to change as follows :-

1) applicationContext-spring-security-jdbc.xml For mySQL database you need add Configuration
which is highlight as BOLD
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"


2)
applicationContext-spring-security-hibernate.properties

For mySQL database you need add Configuration which is highlight as BOLD 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

3) hibernate-settings.xml
When you opened this file you get following code
system/hibernate/hsql.hibernate.cfg.xmlFor mySQL database you need add Configuration which is highlight as BOLD
system/hibernate/mysql5.hibernate.cfg.xml


5) mysql5.hibernate.cfg.xml

User hibuser - which was created with the script load_sample_users_mysql.sql , If you want to specigy your user you can change in following property

property name="connection.username" rootproperty name="connection.password"
root

and also change same in all above property.


\Tomcat
You have to change in Tomcat directory as location mentioned above.1) web.xml http://localhost:8080/pentaho/
make changes as highlighted in BOLD for Ip address or Domain
http://180.168.10.28:8080/pentaho/
http://www.nilesh.com:8080/pentaho/

2) context.xml

When you open context.xml make following changes for MySQL database


xml version="1.0" encoding="UTF-8"
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="root"
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="root"
driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/quartz" validationQuery="select 1"
/Context


I recommend that you resize the command window that displays the Tomcat messages. This will make it easier to read messages that are output by Tomcat.
  • In the top left corner of the Window, click the Java icon.
  • Click Properties.
  • Select the Layout tab.
  • Set the Width = 180
  • Set the Height =300
  • Click OK.

After all successfully changes are done then to start BI server run following bat file

to start BI server :- \biserver-ce-3.5.0.stable\biserver-ce\start-pentaho.bat

to stop BI server :- \biserver-ce-3.5.0.stable\biserver-ce\stop-pentaho.bat

to start administrative console :- biserver-ce-3.5.0.stable\administration-console\start-pac.bat

to stop administrative console :- biserver-ce-3.5.0.stable\administration-console\stop-pac.bat

NOTE

If you are using database as MySQL for BI Server and you are getting (refer forum post)

"PacService.Error_007" error

http://forums.pentaho.com/showthread.php?74727

Well, this tutorial has already taken several hours to write and edit.
I hope I pointed out some of the things that made integration with BI more clear for you. Have fun !

No comments:

Post a Comment

Create MongoDB service in Windows OS

1) Open Command Prompt 2) Create directory for Database and Logs                    mkdir c:\data\db                     mkdir c:\...