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! (http://www.prashantraju.com/projects/pentaho/)

Peace.

[k2dart]

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

(local setup, mysql, tomcat, on windows xp)http://forums.pentaho.org/images/icons/icon14.gif

[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.datasource.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.DatasourceServiceException: 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.datasource.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.DatasourceServiceException: 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.java:205)
java.io.FileOutputStream.<init>(FileOutputStream.java:96)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:141)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:296)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:277)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:265)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:564)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:302)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.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

[ton.swart@capgemini.com]

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.datasource.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.DatasourceServiceException: 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]

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]

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]

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]

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:

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

Pentaho Google Maps Dashboard:

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 (http://www.google.com/apis/maps/signup.html) to get a Google Maps API Key for this server.
Dasboard Revenue Analysis:

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:

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]

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

[andrason]

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

[parveenh]

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.ResourceKeyCreationException: 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.JFreeReportComponent)Debug: Starting execute of bi-developers/reporting/CitrusPoc/testingwar.xaction (org.pentaho.platform.engine.services.solution.SolutionEngine)
Debug: Getting runtime context and data (org.pentaho.platform.engine.services.solution.SolutionEngine)
Debug: Loading action sequence definition file (org.pentaho.platform.engine.services.solution.SolutionEngine)
Debug: audit: instanceId=389a791b-75c8-11de-86b8-853c34d71cef, objectId=org.pentaho.platform.engine.services.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.platform.engine.services.runtime.RuntimeContext)
Error: JFreeReport.ERROR_0007 - Could not parse report bi-developers\reporting/CitrusPoc\testingwar.xml - org.jfree.resourceloader.ResourceKeyCreationException: 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.JFreeReportComponent)
Error: null (org.pentaho.platform.plugin.action.jfreereport.JFreeReportComponent)
Error: RuntimeContext.ERROR_0012 - ActionDefinition for JFreeReportComponent did not execute successfully (org.pentaho.platform.engine.services.runtime.RuntimeContext)
Error: SolutionEngine.ERROR_0007 - Action sequence execution failed (org.pentaho.platform.engine.services.solution.SolutionEngine)


Please help me.

Thanks in advance
Parveen

[jar]

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

[mmichael]

The pro_schedule in the hibernate database will be created after starting the bi-server for the first time (at least it was generated on my server).

[jar]

Hello,

I did succeed in moving from Hypersonic to Mysql for my repository. The manual in the first post in this thread is awesome. Without it I would not have come close to getting Mysql run. This is my feed-back.

A few points :

- the "load_sample_users_mysql.sql" script in ..\data\mysql5 is not needed? I was mixed up because I thought I had to install all scripts. Maybe something left-over from a previous version? I did not use it but all default users (Joe (admin) for example) are available.

- Migration.sql is only needed when you do an upgrade? I used this script for a fresh install and the pro-schedule table was not there as it is created when you start BI-server for the first time. I skipped that line and all seems to work OK. Thanks you mmichael.

- In the manual it is advised to remove the "validation-query" from the context.xml. I removed the whole line in those files but that is wrong. The "/>" at the end of the line must be there as a closing tag. Had me puzzled for a 15 minutes.

I have 1 question left. Is it possible to make the administration-console run as a service also? I could not find the answer to that one when I was writing this but I will look some more. I anybody has a "How-to" then I am interested.

Greetings,
Jeroen

[sheublein]

Hello,

thanks for this excellent tutorial!
I used it to install the BI Server 3.0 Stable version with MySQL.

One thing that was not working right away, was a port conflict with an existing tomcat on our server.
As BI Server uses its own tomcat instance, i configured some other ports for it in
biserver-ce/tomcat/conf/server.xml.

The default tomcat ports are 8080 for HTTP, 8005 for SHUTDOWN and 8009 for the AJP protocol (whatever this is), specified in server.xml like this:


<Server port="8005" shutdown="SHUTDOWN">

<Connector port="8080" maxHttpHeaderSize="8192"
maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
enableLookups="false" redirectPort="8443" acceptCount="100"
connectionTimeout="20000" disableUploadTimeout="true" />

<Connector port="8009"
enableLookups="false" redirectPort="8443" protocol="AJP/1.3" />
I replaced this by:


<Server port="8006" shutdown="SHUTDOWN">

<Connector port="8081" maxHttpHeaderSize="8192"
maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
enableLookups="false" redirectPort="8443" acceptCount="100"
connectionTimeout="20000" disableUploadTimeout="true" />

<Connector port="8010"
enableLookups="false" redirectPort="8443" protocol="AJP/1.3" />
Both tomcats are running fine with this change.

To make BI Server listen on port 8081 instead 8080 the base-url has to be changed in
tomcat/webapps/pentaho/WEB-INF/web.xml
as described in the tutorial, i.e. to


<context-param>
<param-name>base-url</param-name>
<param-value>http://localhost:8081/pentaho/</param-value>
</context-param>
I hope this helps, when you encounter the same problems.

Regards,
Stefan

[mmichael]

If you want to use different pentaho instances on the same server the post from sheublein also helps.
Remember to change the ports for the administration-console. (See resource/config/console.properties)

[toddh]

Great document!

I'm moving right along, but am getting stuck trying to run the administration console on 3.0.0 stable on CentOS.

When I try to browse the the adminstrator console, I get a nice frame with a little spinner that says "Pentaho Admin Console initializing..." This fades out and I'm only left the frame. Completely blank.

I can't seem to find any log messages that help me figure out what's going on. I edited log4j.xml in the administration-console/resources/config directory but no dice.

Any suggestions?

Thanks in advance for your help.

[karikalan]

Hi,

I succeeded the migration in bi server version 3.0. It works well.

If I am trying to use the bi server 3.5 version, I am facing the following issues.

The home page error.
--------------------
HTTP Status 404 - /pentaho/

type Status report

message /pentaho/

description The requested resource (/pentaho/) is not available.
Apache Tomcat/5.5.26

The pentaho.log & catalina-2009......log files are attached for more info.

Please let me know if any issues and how to solve this.

Thanks & Regards,
p.karikalan.

[drapsag]

I made a new howto for the 3.5 version:

http://osbi.nl/2009/09/how-to-install-configure-pentaho-bi-server-3-5-on-ubuntu/

[naveen.arumugam]

Hi ... I am new..

In your tutorial you've mentioned to change "../tomcat5.5/pentaho/WEB-INF/web.xml"
<context-param>
<param-name>solution-path</param-name>
<param-value>/opt/pentaho/pentaho-solutions</param-value>
</context-param>

I am using tomcat supplied with pentaho... still do I need to do the change?

Also, I am using jdbc url="jdbc:mysql://localhost:3306/hibernate" does it affects ? because you've given "jdbc:mysql://localhost/hibernate" (w/o port)

Thx
Naveen

[Marco Mantini]

In your tutorial you've mentioned to change "../tomcat5.5/pentaho/WEB-INF/web.xml"
<context-param>
<param-name>solution-path</param-name>
<param-value>/opt/pentaho/pentaho-solutions</param-value>
</context-param>


it's the same. (you can omitted the param value).

The port of mysql: if you omitted port the connection fail.

--Marco

[chandrasekard]

Its very useful.. i get some knowledge on your decision about mysql.. thanks..

[matthoov]

The files have changed a bit in 3.5. Has anyone been able to get 3.5 running from mysql only?

Thanks

Matt

[cthein]

The files have changed a bit in 3.5. Has anyone been able to get 3.5 running from mysql only?

Thanks

Matt

Yes, although it did take awhile. This http://osbi.nl/2009/09/how-to-install-configure-pentaho-bi-server-3-5-on-ubuntu/ was very helpful. As well as one of the commenters.

[wvaibhav]

Hi,

If you are looking for windows configuration, here is a link,

http://forums.pentaho.org/showthread.php?t=73039&highlight=standalone+mysql

Thanks
Vaibhav Kumar

[pgraju]

This has been updated for 3.5 and now supports MySQL, PostgreSQL and Oracle on both Windows and Linux operating systems!

Grab it here! (http://www.prashantraju.com/tutorials/pentaho-tutorials)

[wselwood]

There seems to be a bit of a problem with the postgres sample data files. It doesn't create the db or change to it so all the tables get created in the postgres database.


drop database if exists sampledata;

CREATE DATABASE sampledata WITH OWNER = postgres ENCODING = 'UTF8' TABLESPACE = pg_default;

\connect sampledata postgresI would guess needs adding, I have attached a version with the changes in it. Needs renaming, the forum won't let me upload a .sql file.


Wil

[pgraju]

\connect sampledata postgres[/code]I would guess needs adding, I have attached a version with the changes in it. Needs renaming, the forum won't let me upload a .sql file.


Thanks Wil!

I have now updated the sample data sql script for postgresql.

[wvaibhav]

Hi,

I have updated BI Server MSSQL configuration for reference at
http://forums.pentaho.org/showthread.php?t=74677. Please let me know of any modifications to be done.

Vaibhav

[rgilaard]

When running the script,sample_data_postgresql.sql, I see the following on line number 7876 (but also in other lines in that script)

GRANT SELECT,INSERT,REFERENCES,DELETE,TRIGGER,UPDATE ON TABLE customer_w_ter TO pentaho_admin;

However, in none of the 5 this user is created.

Do I have to add it manually?

[yapt]

Same here.

[AdrianP]

Hi

Excellent tutorial, without it I would not have got Pentaho installed and running.

It did take me 3 hours to work out that MS SQLExpress 2008 Reporting Services was hogging port 8080 which gave me weird results.

1. The Tomcat server would running but not give me access.
2. netstat said the the port was free :eek:

Luckily this can be disabled in the windows services.

Many Thanks
Adrian

[AdrianP]

Admin Console PAC

I had a little trouble getting the Admin Console up and running and thought I would document this to help out others in the same position.

I have installed Pentaho using the excellent guide by Prashant Rajuon on a Windows XP platform with MySQL and Navicat as a frontend for the MySQL server.

1. The Admin Console would not run until I had entered the correct path into the console.xml file.

File Location; C:\pentaho\administration-console\resource\config\console.xml

<solution-path>C:\pentaho\administration-console</solution-path>

I also added the following location into the same file

<war-path>C:\pentaho\biserver-ce\tomcat\webapps\pentaho</war-path>

2. Now I could log into the Admin Console but could not see any users or the sample database or make a new database connection, I could see all the database information thought the Pentaho BI web page though.

The error message I was getting was that the Admin Console could not connect to the hibernate database.

The fix for this was to copy the C:\pentaho\pentaho-solutions\system\hibernate folder and its contents into C:\pentaho\administration-console\system\hibernate.

After restarting the PAC server all works.

[MM_6891]

Hi all. I did all steps of Prashant's tutorial for the installation of biserver 3.50 with BD Oracle and system linux, but i get a connection refused when i start the administration console, and i don't know that can due to. Too when i started the user's console not start, is loading very time and not started.
I fixed too the error :
cannot insert NULL into ("HIBUSER"."PRO_AUDIT"."AUDIT_ID").


I hope your helps, thx.

regards

[gapson]

how to change the data source for the report already published in Pentaho BI

[X3n0n]

I know the tutorial is talking about MySQL 5 but, is MySQL 4.1 supported by BI-server or it's mandatory to have v5.0 ?
Thanks :)

[jefepwnzer]

Removed

[fpascual]

Hello people,
I have a problem with the instalation of Pentaho bi-server.
I folow point by point the steps in the guide of Prashant Raju (very good guide and complete; thanks) version 1.3.2 for PostgreSQL and Linux.

The details of the problem.

In first instance, run correctly and show de loggin screen.
When I login like joe and select Steel Wheels for see a report apear:
An error ocurred while rendering Pivot.jsp. Please see the log for details.

In the logs /opt/pentaho/bi-server/tomcat/bin/pentaho.log
2010-09-09 09:40:56,321 WARN [org.pentaho.platform.util.logging.Logger] misc-org.pentaho.platform.engine.core.system.PentahoSystem: PentahoSystem.WARN_OBJECT_NOT_CONFIGURED - Object with name "Mondrian-UserRoleMapper" has not been configured in the Pentaho object factory.
2010-09-09 09:40:56,387 WARN [org.pentaho.platform.engine.services.runtime.TemplateUtil] not found: [Measures].[Quantity]


The details of my instalation

Instalador:
biserver-ce-3.6.0-stable.tar.gz

uname -a
Linux cemed26.unl.edu.ar 2.6.26-2-686 #1 SMP Mon Aug 30 07:01:57 UTC 2010 i686 GNU/Linu
Debian Lenny

java -version
java version "1.6.0_20"
Java(TM) SE Runtime Environment (build 1.6.0_20-b02)
Java HotSpot(TM) Client VM (build 16.3-b01, mixed mode, sharing)

PostgreSQL 8.3

Iceweasel 3.0.6

Apache-Tomcat embebed in the Pentaho.


echo $JAVA_HOME
/usr/lib/jvm/java-6-sun
echo $JRE_HOME
/usr/lib/jvm/java-6-sun/jre
echo $CATALINA_OPTS
-Xms256m -Xmx768m -XX:MaxPermSize=256m -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000
echo $CATALINA_HOME
/opt/pentaho/biserver-ce/tomcat

[Leandro]

Im following the tutorial above:

https://docs.google.com/Doc?docid=0AdJmocc0fj_EZDJ3YmZiZF83M2RtaHhwcmRk&hl=en

Everything looks fine, but when i start the tomcat, i have the message:

INFO: Deploying configuration descriptor pentaho.xml
13/09/2010 15:21:34 org.apache.tomcat.util.digester.Digester fatalError
SEVERE: Parse Fatal Error at line 7 column 2: The markup in the document following the root element must be well-formed.
org.xml.sax.SAXParseException: The markup in the document following the root element must be well-formed.

and

INFO: Deploying web application directory pentaho
13/09/2010 15:21:35 org.apache.tomcat.util.digester.Digester fatalError
SEVERE: Parse Fatal Error at line 1 column 10: The processing instruction target matching "[xX][mM][lL]" is not allowed.
org.xml.sax.SAXParseException: The processing instruction target matching "[xX][mM][lL]" is not allowed.

in tomcat log...

I openned the pentaho.xml file and it looks ok.

Please, someone could help me with that??

Thank you very much!!

[lumifer]

I already had Pentaho Bi server 3.6 working but never with the examples and demo dashboard.
System: Windows
Database: MS SQL

I figured it would work if i followed this tutoral:


Pentaho Initialization Exception
https://docs.google.com/Doc?docid=0AdJmocc0fj_EZDJ3YmZiZF8xMTBnZ2s2d3Fjeg&hl=en&authkey=CN3-z9kK&pli=1

When i followed all the steps i get this error:

The following errors were detected
One or more system listeners failed. These are set in the systemListeners.xml.
PentahoSystem.ERROR_0014 - Error while trying to execute startup sequence for org.pentaho.platform.plugin.action.mondrian.MondrianSystemListener
Please see the server console for more details on each error detected.


When i untag this sentence in systemlisteners.xml another listener giving the error.
Anyone got an idea what i am doing wrong?

[lumifer]

I suddenly also got this message in the admin console:
Unable to refresh database connection list: Unable to refresh hibernate.
The entity "nbsp" was referenced, but not declared.
Unable to refresh security information: Unable to refresh hibernate.

any clues?

[lumifer]

anyone?

[2ashishs]

I am using Pentaho 3.7 on Windows XP with Oracle XE. I got the following error while running the load sample users script:
SQL> @3_load_sample_users_ora
Connected.
INSERT INTO USERS (username, password, enabled) VALUES(‘joe’,'cGFzc3dvcmQ=’,1)
*
ERROR at line 1:
ORA-00942: table or view does not exist
……
I checked and the error seems to lie in the fact that 1_create_repository_ora.sql has missing semi-colon after CREATE TABLE terminating brackets.
Sharing.. just in case :P

[2ashishs]

Also with Pentaho 3.7, disabling HSQL DB requires different steps from those provided in the guide.. I am trying..

[2ashishs]

Unable to disable HSQLDB in pentaho biserver ce3.7... has anyone figured that out..?

[masaveu]

Issue Starting BI Server 3.7.0. quartz listeners error,


Hi friends,could somebody help me, I think it doesn't uses quartz mysql database
WEB SCREEN:



Pentaho Initialization Exception


The following errors were detected [es_49] One or more system listeners failed. These are set in the systemListeners.xml. 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.





TOMCAT LOG

RROR [Logger] Error: Pentaho
ERROR [Logger] misc-org.pentaho.platform.engine.core.system.Pentaho
System: PentahoSystem.ERROR_0014 - Error while trying to execute startup sequence for for
org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 -Error while
trying to execute startup sequence for org.pentaho.platform.scheduler.QuartzSystemListener

at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:348)
at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:322)
at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:348)
at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:348)
at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:137)

Caused by: org.pentaho.platform.engine.PentahoSystemException: PentahoSystem.ERROR_0014 -Error while trying to execute startup sequence
for
org.pentaho.platform.scheduler.QuartzSystemListener
at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:341)
((( .... 28 more )))
ERROR [Logger] Error end:
Pentaho BI Platform server failed to properly initialize. The system will not be available for the requests


Thanks

[fabiogas]

Win32 Vista
Tomcat 6
Mysql 5.5
biserver-ce-3.9.0

I followed all the instructions; I edited also the file pentaho-solutions\system\simple-jndi\jdbc.properties and copied the mysql jar connector in Tomcat 6.0\webapps\pentaho\WEB-INF\lib, not mentioned in the guide.
When the app starts, I obtain the following exception:


*******************************************************************************************************************
2012-01-30 22:43:15,774 WARN [org.pentaho.reporting.libraries.base.boot.PackageState] Unable to initialize the module ext-datasources-sampledata
2012-01-30 22:43:16,086 ERROR [org.pentaho.platform.util.logging.Logger] misc-org.pentaho.platform.scheduler.QuartzSystemListener: QuartzSystemListener.ERROR_0001 - Lo Scheduler non è stato inizializzato correttamente all'avvio
org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'quartz': java.sql.SQLException: There is no DataSource named 'quartz' [See nested exception: java.sql.SQLException: There is no DataSource named 'quartz']]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:493)
at org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:68)
at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1010)
at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1152)
at org.pentaho.platform.scheduler.QuartzSystemListener.startup(QuartzSystemListener.java:112)
at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:340)
at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:322)
at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:289)
at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:206)
at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:137)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
at org.apache.catalina.core.StandardService.start(StandardService.java:525)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
* Nested Exception (Underlying Cause) ---------------
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'quartz': java.sql.SQLException: There is no DataSource named 'quartz' [See nested exception: java.sql.SQLException: There is no DataSource named 'quartz']

.................

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - Errore nel tentativo di eseguire la sequenza di startup per org.pentaho.platform.scheduler.QuartzSystemListener
at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:341)
... 28 more
2012-01-30 22:43:16,091 ERROR [org.pentaho.platform.util.logging.Logger] Error end:

***********************************************************************************************

Any help will be very appreciated!!!

Gas

[psweist]

I have the same problem. Did you have a solution for the problem?

[fabiogas]

No, I have not...
Now I focus on Kettle but, as You, I'll appreciate any contribute to our trouble.
Bye

[x2bunty]

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


Hi Murray,

I am trying to create new DB connection, I enter all the credentials correctly and test connection is successful. But when I try to save the connection it gives me PacService.Error_0007

Any help or suggestion is highly appreciated.

Regards,
X2bunty

[prasanths]

I found some info on one blog. http://pentahointegra.blogspot.in/2010/09/settings-for-pentaho-bi-server-with.html
May be it can use full resolve the error.


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.xml
biserver-ce\pentaho-solutions\System\ applicationContext-spring-security-hibernate.properties
biserver-ce\pentaho-solutions\System\ hibernate\hibernate-settings.xml
biserver-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.xml

When you opened this file you get following code
system/hibernate/hsql.hibernate.cfg.xml

For 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" root
property name="connection.password" root

and also change same in all above property.


\Tomcat

You 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



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

[joao.ciocca]

I know there are probably things different on 3.10, but it seemed to me that everything was going OK following the tutorial... except that, at the end, when Tomcat is running as a service and all, I access 8080 and get this message:

HTTP Status 404 -

type Status report
message
description The requested resource () is not available.
Apache Tomcat/6.0.29


oh yeah, I'm running BIS locally, connecting to a remote postgreSQL. all configurations checked.

[hansva]

Hi !
You should check your tomcat log to see what is going wrong.
That error can be anything...

Greetz,
Hans