Convert Pentaho BI Server 2.0 to use Postgres

[greg.banbury]

Hi,

Having evaluated Pentaho and now decided to roll with BI 2.0 I want to move the sample data out of the solution and configure the application to run in our Postgres database, before getting our reports set up for the business user to access through the excellent User Console in 2.0.

The Sample datasources seem to be referenced quite a bit in the code, is there a simple way to reconfigure for Postgres? I have searched the wiki, and now am looking to you for help!

Thanks,
Greg

[Peter Schmidt]

This should help, let me know if you have a problem.
I am running BI 2.0 against postgreSQL.

http://wiki.pentaho.com/display/PEOpen/Configuring+2.X+Server+for+a+Non-Default+Repository+DB

-- Peter

[greg.banbury]

Thanks Peter,

I've just stumbled across this page also:

http://wiki.pentaho.com/display/PentahoDoc/Configuring+for+PostgreSQL

I guess I need to run all these sqls first to physically create the schemas for hibernate, quartz and shark and then jump to your wiki page to configure the application?

Greg

[greg.banbury]

Hi Peter,

I've created a hibernate and quartz schema in a new database, rather than creating two separate databases.

I've followed the instructions on the wiki page you mentioned, and the server starts, however when I hit pizza:8080/pentaho I get an error:

Pentaho Initialization Exception

he following errors were detected One or more system listeners failed. These are set in the pentaho.xml under the node <system-listeners>. PentahoSystem.ERROR_0014 - Error while trying to execute startup sequence for org.pentaho.platform.scheduler.QuartzSystemListener
Please see the server console for more details on each error detected.

The catalina log has the following:

SEVERE: Exception processing Global JNDI Resources
javax.naming.NamingException: Could not load resource factory class [Root exception is java.lang.ClassNotFoundException: org.apache.commons.dbcp.BasicDataSourceFactory]

Any ideas?

[greg.banbury]

I seem to have fixed this Peter. Thanks for your help on this one!

[Peter Schmidt]

Greg,

What was the fix? (so that other's may benefit)

Thanks,

Peter

[greg.banbury]

Oh apologies for that!

It was more user error that anything else! I hadn't changed the validation query in context.xml to be just

SELECT 1

Once this was in, the server could see the database and was happy again!

[Peter Schmidt]

No problem, thanks!

[narender]

i think your doing something wrong in creating the databases
while creatting the tables and you need to enter through specified user only thats y ur getting the problem called system lister failed

regards
Narender.v


Hi Peter,

I've created a hibernate and quartz schema in a new database, rather than creating two separate databases.

I've followed the instructions on the wiki page you mentioned, and the server starts, however when I hit pizza:8080/pentaho I get an error:

Pentaho Initialization Exception

he following errors were detected One or more system listeners failed. These are set in the pentaho.xml under the node <system-listeners>. PentahoSystem.ERROR_0014 - Error while trying to execute startup sequence for org.pentaho.platform.scheduler.QuartzSystemListener
Please see the server console for more details on each error detected.

The catalina log has the following:

SEVERE: Exception processing Global JNDI Resources
javax.naming.NamingException: Could not load resource factory class [Root exception is java.lang.ClassNotFoundException: org.apache.commons.dbcp.BasicDataSourceFactory]

Any ideas?

[greg.banbury]

Hi Narender,

Thanks for this. I'm a bit confused as to what you are saying here.

What is it you say I am missing?

The tables were built using the sql scripts from the pentaho wiki.

Greg