Updated 16/06/2010
This guide has been tested and works with the latest version of Pentaho BI Server 3.6.
Updated 28/02/2010
This guide has been tested and works with the latest version of Pentaho BI Server 3.5.2.
Updated 09/02/2010
All the guides have been updated as well as the MySQL and PostgreSQL SQL Packs. I have made a bunch of fixes to grammatical and spelling errors (ouch!), cleaned up the layout and process flow, extended the Java and Tomcat-Apache sections and added SMTP and Publishing sections (all changes are listed on the front page of each guide).
Last year I created a tutorial on how to install Pentaho Business Intelligence Server 2.0 with MySQL on Linux and the response was overwhelming with the amount of people who found the tutorial helpful.
I have taken the suggestions and feedback and have updated the tutorial for 3.5 and added PostgreSQL 8+ and Oracle 10g (XE and 11g) to the list, all the tutorials are split up for Windows and Linux operating systems.
Can’t wait? Head over to the Pentaho project page and start downloading!
Posted by Roland Bouman on Jan 8, 2010
Cool! thanks, and great to see you blogging again. Keep it up!!
regards,
Roland
Posted by marcos on Jan 8, 2010
Hi Prashant,
I’m currently working through the Pentaho Solutions book which contains a link to your website in order to obtain the sample MySQL scripts. I keep getting 404 errors with all the script download links. For example:
http://www.prashantraju.com/pentaho/download/sampledatamysql5.sql
Thank you for your help!
Marcos
Posted by Robert on Jan 10, 2010
Really nice guide, I’d pay money for this.
Posted by Prashant Raju on Jan 10, 2010
@marcos,
I no longer support that guide however you can get the new 3.5 tutorial and necessary SQL scripts from the Pentaho Tutorials project page.
Peace.
Posted by Midhun on Jan 10, 2010
Prasanth,
When I try to download the updated Installation guide for Pentaho 3.5 on linux it is throwing 404 error .
Please help .
Thanks
Posted by Midhun on Jan 10, 2010
Am sorry It worked .Thanks a lot.
Posted by Prashant Raju on Jan 10, 2010
@mohan,
The Oracle and Linux Sample SQL Script link was broken. Just fixed it.
Peace.
Posted by simm13 on Jan 11, 2010
hi,Prashant,
in ur pdf,why not use start-pentaho to start the BI server?
I try to do everything in ur pdf,but the bi serv does not work,what can i do then?
Posted by Prashant Raju on Jan 11, 2010
@simm13,
I don’t use the start-pentaho.bat or start-pentaho.sh file as these are for the out-of-box install which is setup for HSQLDB – you edit these to work with your setup though (not hard).
I would need some more information about your error i.e. What is your setup and what’s the error you are getting?
Prashant.
Posted by simm13 on Jan 11, 2010
hi,Prashant,
i do this work on winxp and oracle10g
the problem is: after i started the tomcat5 service and visit http://localhost:8080/pentaho
there is a long time waiting but finally got a 404 erro on the web, and there is not any loging file to located the erro,plz help me,thanks!
Posted by Prashant Raju on Jan 11, 2010
@simm13,
What happens when you go to http://localhost:8080/pentaho – do you get the Tomcat welcome screen? If not it looks like Tomcat hasn’t started up or it is setup to start on a different port.
Are there no logs under the biserver-ce/pentaho/tomcat/logs/ folder?
If you wish you can send me an email and we can discuss it that way rather than sending comments back and forth.
Prashant.
Posted by simm13 on Jan 13, 2010
i finally resolved the problem:
i find the jdbc driver file ojdbc14.jar for Oracle Database 10g 10.1.0.5 JDBC Drivers and placed it in the tomcat\common\lib folder
then restarted the tomcat service, it works well.the Whole problem is the bug for the jdbc driver.
if the oracle version is 10.1.0.2.0 and jdbc driver file is for 10.1.0.2.0,it will generate the problem which i Encountered.but i found in your guide the oracle version is 10.2.0.4, probablly,itdoesnt have any problem.
Posted by Prashant Raju on Jan 13, 2010
Good work simm13!
I have updated the Oracle guides to take this into account.
Prashant.
Posted by vaibhav on Jan 13, 2010
Hi Raju,
Thanks for the work,
well, how to configure MSSQL server for pentaho report publishing. I could publish mondrian reports but could not publish MSSQL reports. Could you please give me some steps to do it ?
Thanks
Vaibhav Kumar
Posted by Prashant Raju on Jan 13, 2010
@Vaibhav,
Are talking about setting up the BI Server (3.5) on MSSQL?
or
Publising reports from PRD 3.5 to the BI Server (3.5) which is sitting on MSSQL?
Regards,
Prashant
Posted by Rinaldo Bonazzo on Jan 14, 2010
Hi Prashant I try your tutorial, I find a problem in the database hibernate in table datasource the he gave the following error
No suitable driver found for jdbc:mysql:mysql://localhost:3306/sampledata
I made the follwoing query as suggested in (http://osbi.nl/2009/09/how-to-install-configure-pentaho-bi-server-3-5-on-ubuntu/)
UPDATE DATASOURCE SET DRIVERCLASS = ‘com.mysql.jdbc.Driver’, URL = ‘jdbc:mysql://localhost:3306/sampledata’ , QUERY = ‘SELECT 1′ WHERE NAME = ‘SampleData’
and now all is ok
regards Rinaldo
Posted by Prashant Raju on Jan 14, 2010
@Rinaldo,
I worked out the error it was in the MySQL SQL Script pack. I had the line:
jdbc:mysql:mysql://localhost:3306/sampledataIt should of been this:
jdbc:mysql://localhost:3306/sampledataI have fixed the pack and uploaded the newest version.
Thanks for the heads up!
Prashant.
Posted by Corn3r on Jan 23, 2010
Really useful & easy to understand work Prashant!
Thanks!
Posted by Benjamin on Jan 26, 2010
Hi,
I have been working with your guide for Pentaho 3.5 & Postgres. I was running into an error with quartz.
Here is the error description and the resolution: http://jira.pentaho.com/browse/BISERVER-2251 , you might want to add or mention this in your guide.
Thanks!
Posted by Benjamin on Jan 26, 2010
Hi,
I just found another error, this time in the file “create_sample_datasource_postgresql.sql”.
it should say jdbc:postgresql://localhost:5432/sampledata‘
instead of
jdbc:postgresql://localhost:5432/hibernate‘
Posted by Prashant Raju on Jan 26, 2010
@Benjamin
I have updated the SQL script pack for postgresql.sql and also added the quartz.properties fix in both the Windows and Linux PostgreSQL guides.
Thanks for pointing it out!
Prashant.
Posted by Rodrigo Berto on Mar 1, 2010
Hi,
Congratulations for this article, it is very easy and best of all it works…
Thank you,
Rodrigo Berto
Sysadmin, SP , Brazil
Posted by Guillermo Galindo on Apr 6, 2010
Hi, i finish the tutorial but, what is the user/pass to access to user console?, thanks
Posted by Prashant Raju on Apr 6, 2010
@Guillermo,
There should be a drop down list of users which populate the userid and password fields i.e. joe/password. If you are talking about the administration console admin/password will work (which is also mentioned in the guide).
Prashant.
Posted by Bernabeu R. Dario on Jun 6, 2010
Excelente material, gracias por compartirlo!
Fijate en el tutorial de GNU/Linux & PostgreSQL, en la sección “Configuring Hibernate and Quartz” -> “quartz.properties”.
El archivo “quartz.properties” se encuentra en /pentaho-solutions/system/quartz
Saludos.
Dario
Posted by Paco Barrera on Jun 25, 2010
Hi Prashant,
when you say to simm13 that
“I don’t use the start-pentaho.bat or start-pentaho.sh file as these are for the out-of-box install which is setup for HSQLDB – you edit these to work with your setup though (not hard).”
can you guide us to what simple modifications are needed?
I try it, but always appears a message in Tomcat manager indicating that Pentaho causes a memory leak.
Another question, is that if I use an existing Tomcat server, all this scripts start the Tomcat that comes whith Pentaho, isn’t it?
Thanks in advance.
Posted by IVARS on Jun 26, 2010
FABULOUS,
You make an absolutely FABULOUS Work,
THANK a lot, Your tutorials and the add of view screen are an example. THANK a lot for all you give to us.
BEST REGARDS
Alain IVARS
Posted by Prashant Raju on Jun 26, 2010
@IVARS
Thanks mate!
Posted by Michel on Jun 28, 2010
Thanks a lot for the manual!
I had one problem when installing as described.
Turned out the location of the “mysql-connector-java-5.0.7.jar” should be in the “Classpath” otherwise it won’t startup and you will get “connection refused” in the pentaho.log and/or tomcat logs.
Maybe you should add it to the manual?
Thanks!
Michel
Posted by Prashant Raju on Jun 28, 2010
@Michel
What is your setup? I haven’t had an issue with the CLASSPATH on a fresh setup.
Thanks
Prashant
Posted by Prashant Raju on Jun 28, 2010
@Paco
Can you pastie the Tomcat error?
If you are using an existing Tomcat setup then you can start Tomcat via Services in Windows and /tomcat/bin/startup.sh in Linux.
Prashant
Posted by Prashant Raju on Jun 28, 2010
@Bernabeu
Sorry mate don’t speak Spanish … I think it is Spanish
Prashant
Posted by Nicolas Raoul on Jul 12, 2010
Thanks a lot Prashant!
The guide for Linux MySQL says to download pentaho-ce-3.6.x.stable.tar.gz
Should not that be biserver-ce-3.6.x-stable.tar.gz ?
If I understood well, that’s the new name for this package. Can you confirm? Thanks!
Posted by Nicolas Raoul on Jul 12, 2010
Very minor inconsistency:
source 5_sample_data_mysql.sql;
should probably read:
source 5_sampledata_mysql.sql;
I just finished the steps described in your document, and launched Pentaho, it works great
Posted by harteni on Aug 2, 2010
Dear Mr.Raju,
I just start using pentaho with zero knowledge. i’m stuck,i already follow all the step but have a problem in the mysql part and after i run the tomcat it doesn’t display the login page.. can you help me.
Posted by Ray DiGiacomo, Jr. on Aug 31, 2010
Hi Prashant,
Great job on the mySQL guide! It is very helpful.
I think I may have found an error though. On page 18, I think the path for the email_config file is wrong.
- Ray
Posted by Ray DiGiacomo, Jr. on Sep 1, 2010
Hi Prashant,
I could not start tomcat after installing it for the first time and found out a fix that I would like to share with your community:
copy msvcr71.dll from the bin directory of the java installation to the bin directory of the tomcat installation. Works for Vista.
- Ray