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

**ton.swart@capgemini.com** · 03-19-2009 09:37 AM

Originally Posted by 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

Got the same error.
And when I try to update de SampleData data source in the administration concole, the following error occured "PacService.ERROR_0025: Connection attempt failed: No suitable driver"

**DMurray3** · 03-19-2009 03:37 PM

Hi.. I had the same problem... I think it's the way you specify the url... in the Admn Console - DataSources creation.

Try specifying:

jdbc:mysql://localhost:your_mysql_port/your_database_name

HTH, DMurray3

**ton.swart@capgemini.com** · 03-21-2009 05:41 AM

Originally Posted by DMurray3

Hi.. I had the same problem... I think it's the way you specify the url... in the Admn Console - DataSources creation.

Try specifying:

jdbc:mysql://localhost:your_mysql_port/your_database_name

HTH, DMurray3

DMurray3,
Thanks, this solved my problem. I just followed the steps in the manual because the steps where spot on (at least till that point).
Greetz Ton.

**DMurray3** · 03-24-2009 06:36 PM

I used the guide to get bi-server-ce 3.0RC1 up and running, no problems as well.

Again many thanks to the author... DMurray3

**reis3k** · 04-01-2009 10:01 AM

Hi,

Thanks again for your easy-to-follow tutorial.

I had a problem to allow my bi server to get access from remote machines. I did everything written on remote version of the tutorials. First of all, wtih the local version of the tutorial, everything works great. When tried to apply remote tutorial. I got access to user console but Steel Wheels sample give these error:

Analysis part:

Code:

            This page cannot be accessed directly. It must be linked to from other page.

Pentaho Google Maps Dashboard:

Code:

The Google Maps API key that ships with the Pentaho Pre-Configured Installation will only work with a server address of 'http://localhost:8080'.   To use Google Maps with this server address ( 172.18.2.212:8080 ) you need to apply to Google for a new key. 
 Once you have the new key you need to add it to the Google settings file in the Pentaho system (.../pentaho-solutions/system/google/googlesettings.xml) 
 Click here to get a Google Maps API Key for this server.

Dasboard Revenue Analysis:

Code:

Could not generate chart image.
Could not load chart data from steel-wheels/dashboards/Sales_by_Territory.xaction                                                                     Could not generate chart image.
Could not load chart data from steel-wheels/dashboards/Sales_by_Productline_all.xaction                                                                                                                        Could not generate chart image.
Could not load chart data from steel-wheels/dashboards/sales_overtime_all.xaction

Dasboard Sales for All Territories:

Code:

Click on a Territory
 No data for chart to display

I think we need more things to do to allow us to access user console w/o any problem from local and remote machines?

**reis3k** · 04-01-2009 10:57 AM

I should have just change bind-url in web.xml. The rest is unnecessary

**andrason** · 05-13-2009 01:19 AM

Error: ConnectFactory.ERROR_0001 - Database connection could not be established to: - java.lang.ClassCastException: org.apache.naming.NamingContext (org.pentaho.platform.plugin.action.sql.SQLLookupR ule)Debug: Starting execute of PayOne Reporting/PayOne Reports/PayOne - Custom Codes.xaction (org.pentaho.platform.engine.services.solution.Sol utionEngine)
Debug: Getting runtime context and data (org.pentaho.platform.engine.services.solution.Sol utionEngine)
Debug: Loading action sequence definition file (org.pentaho.platform.engine.services.solution.Sol utionEngine)
Debug: audit: instanceId=32df72e1-3f7d-11de-8d42-c35d0574aac7, objectId=org.pentaho.platform.engine.services.runt ime.RuntimeContext, messageType=action_sequence_start (org.pentaho.platform.engine.services.runtime.Runt imeContext)
Error: ConnectFactory.ERROR_0001 - Database connection could not be established to: - java.lang.ClassCastException: org.apache.naming.NamingContext (org.pentaho.platform.plugin.action.sql.SQLLookupR ule)
Error: SQLBaseComponent.ERROR_0007 - Connection to data source is not valid (org.pentaho.platform.plugin.action.sql.SQLLookupR ule)
Error: RuntimeContext.ERROR_0012 - ActionDefinition for SQLLookupRule did not execute successfully (org.pentaho.platform.engine.services.runtime.Runt imeContext)
Error: SolutionEngine.ERROR_0007 - Action sequence execution failed (org.pentaho.platform.engine.services.solution.Sol utionEngine)

**parveenh** · 07-21-2009 03:42 AM

Hi,

I have used the same steps and I am able to run the tomcat.

But i have to start my hypersonic data, i want to remove that dependency..

Is it possible o do that.

One more thing, I create one report with mysql, and provided the datasource entry from admin console, when I am trying to publish it to the server I am getting following exception

Error: JFreeReport.ERROR_0007 - Could not parse report bi-developers\reporting/CitrusPoc\testingwar.xml - org.jfree.resourceloader.ResourceKeyCreationExcept ion: Unable to create key: No loader was able to handle the given key data: solution:/bi-developers\reporting/CitrusPoc\testingwar.xml (org.pentaho.platform.plugin.action.jfreereport.JF reeReportComponent)Debug: Starting execute of bi-developers/reporting/CitrusPoc/testingwar.xaction (org.pentaho.platform.engine.services.solution.Sol utionEngine)
Debug: Getting runtime context and data (org.pentaho.platform.engine.services.solution.Sol utionEngine)
Debug: Loading action sequence definition file (org.pentaho.platform.engine.services.solution.Sol utionEngine)
Debug: audit: instanceId=389a791b-75c8-11de-86b8-853c34d71cef, objectId=org.pentaho.platform.engine.services.runt ime.RuntimeContext, messageType=action_sequence_start (org.pentaho.platform.engine.services.runtime.Runt imeContext)
Error: JFreeReport.ERROR_0007 - Could not parse report bi-developers\reporting/CitrusPoc\testingwar.xml - org.jfree.resourceloader.ResourceKeyCreationExcept ion: Unable to create key: No loader was able to handle the given key data: solution:/bi-developers\reporting/CitrusPoc\testingwar.xml (org.pentaho.platform.plugin.action.jfreereport.JF reeReportComponent)
Error: null (org.pentaho.platform.plugin.action.jfreereport.JF reeReportComponent)
Error: RuntimeContext.ERROR_0012 - ActionDefinition for JFreeReportComponent did not execute successfully (org.pentaho.platform.engine.services.runtime.Runt imeContext)
Error: SolutionEngine.ERROR_0007 - Action sequence execution failed (org.pentaho.platform.engine.services.solution.Sol utionEngine)

Please help me.

Thanks in advance
Parveen

**jar** · 07-22-2009 03:05 PM

Hello,

I have tomcat running as a service now and would like replace hypersonic with mysql.
I have mysql 5.x installed on localhost (BI server is running there too) and working fine. I can make a connection using the reportdesigner. I am using the 3.0 stable release.

My problem is with the scripts to create and fill the mysql databases. I use the order as asked for in the PDF file.
- The repository DB is created with 1 table (with the name datasource).
- Then the quarts DB is created with multiple tables, looks good.
- The "create_sample_datasource_mysql.sql" file fills the datasource table in hibernate with 1 record (is this good?)
- When I run the "migration.sql" then it goes wrong. This file is referring to a pro_schedule table in the hibernate DB but that table does not exist. When I remove that row it works OK.

- After I remove the error-row in the previous SQL script I try to run the last sql script which should load the default users and roles in my hibernate DB but it goed wrong in a lot of ways. The users, authorities and granted_authorities are all not available tables.

I do not understand how you got past this problem but I like to hear about that. Thanks in advance for any answer you can give me.

Jeroen