Pentaho5.0.1 port the database to mysql

The built-in data of Pentaho is hsql. database. So how can we replace the port with mysql? Thought: transplantation condition: 1. First, there must be a mysql data. 2. Connect the startup configuration of pentaho to mysql. Now I am working on an example of porting the pentaho5.0 database. I use Windows 7 as an example. 1. First, in biserver-c

The built-in data of Pentaho is hsql. database. So how can we replace the port with mysql? Thought: transplantation condition: 1. First, there must be a mysql data. 2. Connect the startup configuration of pentaho to mysql. Now I am working on an example of porting the pentaho5.0 database. I use Windows 7 as an example. 1. First, in biserver-c

The built-in data of Pentaho is hsql. database. So how can we replace the port with mysql?

Thoughts:

Porting conditions:

1. First, you must have a mysql data.

2. Connect the startup configuration of pentaho to mysql.

Now I am working on an example of porting the pentaho5.0 database. I use Windows 7 as an example.

1. First, run the three SQL files in the biserver-ce \ data \ mysql5 folder under mysql. As long as it is pentaho5 decompression is three files. So the name is not mentioned.

Step: log on to mysql-u-p

Import SQL file: Source and file path

2. Connect the startup configuration of pentaho to mysql.

Therefore, a total of six xml files are modified.

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/simple-jndi/jdbc. properties

Biserver-ce/tomcat/webapps/pentaho/META-INF/context. xml

Biserver-ce/tomcat/conf/Catalina/localhost/pentaho. xml

Configuration File 1

Biserver-ce/pentaho-solutions/system/applicationContext-spring-security-jdbc.xml

The modification is as follows (the red part has been modified ):

Class = "org. springframework. jdbc. datasource. DriverManagerDataSource">

Value ="Jdbc: mysql: // localhost: 3306/hibernate"/>

Configuration File 2

Biserver-ce/pentaho-solutions/system/applicationContext-spring-security-hibernate.properties

The modification is as follows (the red part has been modified ):

Jdbc. driver = com. mysql. jdbc. Driver

Jdbc. url = jdbc: mysql: // localhost: 3306/hibernate

Jdbc. username = hibuser

Jdbc. password = password

Hibernate. dialect = org. hibernate. dialect. MySQL5Dialect

Configuration File 3

Biserver-ce/pentaho-solutions/system/hibernate/hibernate-settings.xml

The modification is as follows (the red part has been modified ):

System/hibernate/mysql5.hibernate. cfg. xml

Configuration File 4

Biserver-ce/pentaho-solutions/system/simple-jndi/jdbc. properties

The modification is as follows (the red part has been modified ):

SampleData/type = javax. SQL. Datasource

SampleData/driver =Com. mysql. jdbc. Driver

SampleData/url =Jdbc: mysql: // localhost: 3306/sampledata

SampleData/user = pentaho_user

SampleData/password = password

Hibernate/type = javax. SQL. DataSource

Hibernate/driver =Com. mysql. jdbc. Driver

Hibernate/url =Jdbc: mysql: // localhost: 3306/hibernate

Hibernate/user = hibuser

Hibernate/password = password

Quartz/type = javax. SQL. DataSource

Quartz/driver =Com. mysql. jdbc. Driver

Quartz/url =Jdbc: mysql: /// localhost: 3306/quartz

Quartz/user = pentaho_user

Quartz/password = password

Shark/type = javax. SQL. DataSource

Shark/driver =Com. mysql. jdbc. Driver

Shark/url =Jdbc: mysql: /// localhost: 3306/shark

Shark/user = sa

Shark/password =

SampleDataAdmin/type = javax. SQL. DataSource

SampleDataAdmin/driver =Com. mysql. jdbc. Driver

SampleDataAdmin/url =Jdbc: mysql: // localhost: 3306/sampledata

SampleDataAdmin/user = pentaho_admin

SampleDataAdmin/password = password

Configuration File 5

Biserver-ce/tomcat/webapps/pentaho/META-INF/context. xml

The modification is as follows (the red part has been modified ):

Factory = "org. apache. commons. dbcp. BasicDataSourceFactory" maxActive = "20" maxIdle = "5"

MaxWait = "10000" username = "hibuser" password = "password"

DriverClassName ="Com. mysql. jdbc. Driver"Url ="Jdbc: mysql: // localhost: 3306/hibernate"

ValidationQuery ="Select 1"/>

Factory = "org. apache. commons. dbcp. BasicDataSourceFactory" maxActive = "20" maxIdle = "5"

Maxwafit = "10000" username = "pentaho_user" password = "password"

DriverClassName ="Com. mysql. jdbc. Driver"

Url ="Jdbc: mysql: /// localhost: 3306/quartz"

ValidationQuery ="Select 1"/>

Configuration file 6

Biserver-ce/tomcat/conf/Catalina/localhost/pentaho. xml

The modification is as follows (the red part has been modified ):

Factory = "org. apache. commons. dbcp. BasicDataSourceFactory" maxActive = "20" maxIdle = "5"

MaxWait = "10000" username = "hibuser" password = "password"

DriverClassName ="Com. mysql. jdbc. Driver"Url ="Jdbc: mysql: // localhost: 3306/hibernate"

ValidationQuery ="Select 1"/>

Factory = "org. apache. commons. dbcp. BasicDataSourceFactory" maxActive = "20" maxIdle = "5"

Maxwafit = "10000" username = "pentaho_user" password = "password"

DriverClassName ="Com. mysql. jdbc. Driver"Url ="Jdbc: mysql: /// localhost: 3306/quartz"

ValidationQuery ="Select 1"/>

Such a database is always successful.

Then start the pentaho platform. Enter: localhost: 8080/pentaho in the browser and go to the page as shown in the first section.