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

[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 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

[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-instal...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

[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!

[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 postgres

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.


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.