Pentaho BI Server 3.5 - MySQL, PostgreSQL and Oracle for Windows & Linux Tutorial

[pgraju]

Hi all,

I have updated this tutorial for version 3.6 the new set of tutorials support:

• Windows with
  • Microsoft SQL Server 2005+
  • MySQL 5.x
  • PostgreSQL 8.x.x
  • Oracle XE, 10g and 11g

• Linux with
  • MySQL 5.x
  • PostgreSQL 8.x.x
  • Oracle XE, 10g and 11g

Can't wait? Click here to start downloading!

Peace.

[k2dart]

Thank's alot this guide really helped me out getting Pentaho running.

(local setup, mysql, tomcat, on windows xp)

[campi]

Too bad for me, I have installed before you publish this. It will have been very helpful ^^.

I also wanted to add a comment on the fact for the mysql server set the max_allowed_packet variable to 1 Mo. So when you use the Database Repository as solution if you have a file bigger than 1 Mo an exception will occurs (I have this error when trying to publish my metadata file).

Thanks for the tutorial it'll be very helpful, I will read it in order to know if you have done something differently than I. Another point of view is always good.

[cpalacio]

link failed

[joannamm]

Wow! this really helped me a lot. Thank you very much.

[TeMPO]

Dear all,

I followed the tutorial (local.pdf) on a Debian Etch machine with Tomcat
I can connect to the database via the administration console but in the log file
of Tomcat (catalina.out) I find the following after startup

22:48:57,428 ERROR [Logger] misc-org.pentaho.platform.engine.services.connection.da tasource.dbcp.PooledDatasourceSystemListener: PooledDatasourceSystemListener.ERROR_0003 - Unable to pool datasource object: SampleData caused by java.sql.SQLException: socket creation error
22:48:58,016 ERROR [SQLLookupRule] Error Start: Pentaho Pentaho Platform Engine
Core 2.0.0.stable.35509
22:48:58,018 ERROR [SQLLookupRule] 72873b71-fbaa-11dd-8460-e7470939ae9c:COMPONENT:context-29383158-1234734537597:global-department-list.xactionConnectFactory.ERROR_0001 - [fr_1] Database connection could not be established to: SampleData
org.pentaho.platform.api.data.DatasourceServiceExc eption: java.sql.SQLException: socket creation error

I cannot figure out what is wrong

Any help is welcome

Maurice

[TeMPO]

Dear all,

I finally managed to get it working on Debian with MySQL
the only way I found is to start pentaho with the start-pentaho.sh script
located in the root directory biserver-ce
It's almost the same script as the one described in the documentation
but it runs the hypersonic program that is not invoked by the other procedure

Maurice

[bearstar]

Dear all,

I followed the tutorial (local.pdf) on a Debian Etch machine with Tomcat
I can connect to the database via the administration console but in the log file
of Tomcat (catalina.out) I find the following after startup

22:48:57,428 ERROR [Logger] misc-org.pentaho.platform.engine.services.connection.da tasource.dbcp.PooledDatasourceSystemListener: PooledDatasourceSystemListener.ERROR_0003 - Unable to pool datasource object: SampleData caused by java.sql.SQLException: socket creation error
22:48:58,016 ERROR [SQLLookupRule] Error Start: Pentaho Pentaho Platform Engine
Core 2.0.0.stable.35509
22:48:58,018 ERROR [SQLLookupRule] 72873b71-fbaa-11dd-8460-e7470939ae9c:COMPONENT:context-29383158-1234734537597:global-department-list.xactionConnectFactory.ERROR_0001 - [fr_1] Database connection could not be established to: SampleData
org.pentaho.platform.api.data.DatasourceServiceExc eption: java.sql.SQLException: socket creation error

I cannot figure out what is wrong

Any help is welcome

Maurice

Hi Maurice.
I'm just exploring the BI server, so I don't know a lot about it yet.
But, I get similair errors when the user that starts that server process by running start-pentaho.sh does not have $JAVA_HOME set.

[continuousops]

Dear All,
I've been trying to upgrade to the BiServer-ce 2.0 but with no luck so far.
I am installing this on a Suse Linux 10 with MySQL.
I've followed the (very well detailled) document, but I now get stuck when I try to start Tomcat. I get the HTTP Status 500 error and don't know how to go any further now.

here's the route cause they mention:
java.io.FileNotFoundException: /opt/pentaho/biserver-ce/tomcat/work/Catalina/localhost/_/org/apache/jsp/index_jsp.java (No such file or directory)
java.io.FileOutputStream.<init>(FileOutputStream.j ava:205)
java.io.FileOutputStream.<init>(FileOutputStream.j ava:96)
org.apache.jasper.compiler.Compiler.generateJava(C ompiler.java:141)
org.apache.jasper.compiler.Compiler.compile(Compil er.java:296)
org.apache.jasper.compiler.Compiler.compile(Compil er.java:277)
org.apache.jasper.compiler.Compiler.compile(Compil er.java:265)
org.apache.jasper.JspCompilationContext.compile(Js pCompilationContext.java:564)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:302)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet .java:803)


Anyone got any idea... please?

Thanks a lot!
Sam

[DMurray3]

Hi prashant (schone),
First, thanks for the tutorial... I am trying to follow it using Windows XP, but am falling short on setting up the datasources. I am currently using PCI 1.7GA against MySQL 5.0 and have a number of dbs already set up and working and would like to move up to bi-server-ce 2.0.

I followed your tutorial, with a variation: I did not go through the loading of sample data, quartz and hibernate, given I already have that data loaded Tomcat, User Console and Admin console are working...

However when trying to set up the data sources in the Admin Console none of my connections work. They all turn out: "Connection attempt failed: No suitable driver".

On PCI 1.7GA I am using mysql-connector-java-5.0.7-bin.jar with no problems; so I thought that might be the problem and changed the mysql connector in
...\Pentaho20\biserver-ce\administration-console\jdbc and in
...\Pentaho20\biserver-ce\tomcat\common\lib

But I am getting the same connection failed...

I'd appreciate your or anyone else's advise for that matter.

Kind regards, DMurray3