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.xmlWhen 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.


\TomcatYou 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 !

Comments

Post a Comment

Popular posts from this blog

Changing the Java VM Memory Limits in Pentaho BI

-
You can find docs biserver-ce\tomcat\webapps\pentaho\docs\ Changing the Java VM Memory Limits If you are running out of memory even though your server has a lot of RAM, you probably need to increase the resources allocated to the JRE instance that runs the Pentaho software you're trying to improve performance on. Adjusting the memory limit is an easy configuration change to make, but the instructions differ depending on the client tool or Web application server you're using. Refer only to the sections below that apply to your situation. Note: If you are running multiple Pentaho programs concurrently, the sum of their JVM maximum memory limits must not exceed the available RAM minus system overhead. Increasing Memory Limits on Microsoft Windows with a Graphical Installation By default, Tomcat has a relatively low memory allotment. This can cause out-of-memory errors in the BA Server fromtime to time. The below instructions will explain how to increase the mem...
Read more

utf8_general_ci VS utf8_unicode_ci what should we use?

-
These two collations are both for the UTF-8 character encoding. The differences are in how text is sorted and compared. Note: in new versions of MySQL use utf8mb4 , rather than utf8 , which is the same UTF-8 data format with same performance but previously only accepted the first 65,536 Unicode characters. Accuracy utf8mb4_unicode_ci is based on the Unicode standard for sorting and comparison, which sorts accurately in a very wide range of languages. utf8mb4_general_ci fails to implement all of the Unicode sorting rules, which will result in undesirable sorting in some situations, such as when using particular languages or characters. Performance utf8mb4_general_ci is faster at comparisons and sorting, because it takes a bunch of performance-related shortcuts. On modern servers, this performance boost will be all but negligible. It was devised in a time when servers had a tiny fraction of the CPU performance of today's computers. utf8mb4_unicode_c...
Read more

CAS with Pentaho Community Edition

-
In this week I integrate one of the most useful feature i.e. CAS (Single Sign on) with the help my collegue and online user community . So with my boss’ blessing, I decided to document what I had to do to make this work in the spirit of giving back to the community. Plus with the rising awareness of the benefits of BI even for small to medium corporations, I have no doubt that this information would be useful for someone somewhere. The need 1) CAS Server 2) Pentaho BI 3.x server (Community Edition) 3) Install certificate IMPLEMENTATION OF CAS CLIENT IN PENTAHO BI SERVER 1) \biserver-ce\pentaho-solutions\system\applicationContext-spring-security.xml make changes in applicationContext file for CAS Client. and add following jars in biserver-ce\tomcat\webapps\pentaho\WEB-INF\lib folder 1) spring-security-cas-client-2.0.5.RELEASE.jar 2) cas-client-core-3.1.10.jar After added jars and configuration in applicationContext file then install certificate step-1) download...
Read more