Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Pentaho 5.0.1 new installation does not work with mysql.

  1. #1
    Join Date
    May 2013
    Posts
    5

    Exclamation Pentaho 5.0.1 new installation does not work with mysql.

    Hi, I have some problems when installing biserver 5.0.1. I follow the normal install procedure to have pentaho working with the original hSQLdb. No probs and all functions are operating well.

    After that, I proceed to change the configuration to operate with mysql ddbb, then astonishingly some options are not operating well or doesn't operate at all.

    As a summary of what I did, I list below the configuration files and the updates that I did, following the different tutorials found in the web:

    - applicationContext-spring-security-hibernate.properties

    jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/hibernate
    jdbc.username=hibuser
    jdbc.password=password
    hibernate.dialect=org.hibernate.dialect.MySQLDialect

    - hibernate-settings.xml

    <config-file>system/hibernate/mysql5.hibernate.cfg.xml</config-file>

    - mysql5.hibernate.cfg.xml

    <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="connection.url">jdbc:mysql://localhost:3306/hibernate</property>
    <property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>
    <property name="connection.username">hibuser</property>
    <property name="connection.password">password</property>

    - quartz.properties

    org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegate

    - context.xml

    <Resource name="jdbc/Hibernate" auth="Container" type="javax.sql.DataSource"
    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" />

    <Resource name="jdbc/Quartz" auth="Container" type="javax.sql.DataSource"
    factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5"
    maxWait="10000" username="pentaho_user" password="password"
    driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/quartz"
    validationQuery="select 1"/>

    - repository.xml

    i) FileSystem part

    Comment this code

    <FileSystem>
    <param name=”path” value=”${rep.home}/repository”/>
    </FileSystem>

    Active this code

    <FileSystem>
    <param name="driver" value="com.mysql.jdbc.Driver"/>
    <param name="url" value="jdbc:mysql://localhost:3306/jackrabbit"/>
    <param name="user" value="jcr_user"/>
    <param name="password" value="password"/>
    <param name="schema" value="mysql"/>
    <param name="schemaObjectPrefix" value="fs_repos_"/>
    </FileSystem>

    ii) DataStore part

    Comment this code


    <DataStore/>

    Active this code

    <DataStore class="org.apache.jackrabbit.core.data.db.DbDataStore">
    <param name="url" value="jdbc:mysql://localhost:3306/jackrabbit"/>
    <param name="user" value="jcr_user"/>
    <param name="password" value="password"/>
    <param name="databaseType" value="mysql"/>
    <param name="driver" value="com.mysql.jdbc.Driver"/>
    <param name="minRecordLength" value="1024"/>
    <param name="maxConnections" value="3"/>
    <param name="copyWhenReading" value="true"/>
    <param name="tablePrefix" value=""/>
    <param name="schemaObjectPrefix" value="ds_repos_"/>
    </DataStore>

    iii) Security part in the FileSystem Workspace part

    Comment this code

    <FileSystem>
    <param name=”path” value=”${wsp.home}”/>
    </FileSystem>

    Active this code

    <FileSystem>
    <param name="driver" value="com.mysql.jdbc.Driver"/>
    <param name="url" value="jdbc:mysql://localhost:3306/jackrabbit"/>
    <param name="user" value="jcr_user"/>
    <param name="password" value="password"/>
    <param name="schema" value="mysql"/>
    <param name="schemaObjectPrefix" value="fs_ws_"/>
    </FileSystem>

    iv) PersistenceManager part

    Comment this code
    <PersistenceManager>
    <param name=”url” value=”jdbc:h2:${wsp.home}/db”/>
    <param name=”schemaObjectPrefix” value=”${wsp.name}_”/>
    </PersistenceManager>

    Active this code

    <PersistenceManager>
    <param name="url" value="jdbc:mysql://localhost:3306/jackrabbit"/>
    <param name="user" value="jcr_user" />
    <param name="password" value="password" />
    <param name="schema" value="mysql"/>
    <param name="schemaObjectPrefix" value="${wsp.name}_pm_ws_"/>
    </PersistenceManager>

    v) FileSystem Versioning part

    Comment this code

    <FileSystem>
    <param name=”path” value=”${rep.home}/version” />
    </FileSystem>

    Active this code

    <FileSystem>
    <param name="driver" value="com.mysql.jdbc.Driver"/>
    <param name="url" value="jdbc:mysql://localhost:3306/jackrabbit"/>
    <param name="user" value="jcr_user"/>
    <param name="password" value="password"/>
    <param name="schema" value="mysql"/>
    <param name="schemaObjectPrefix" value="fs_ver_"/>
    </FileSystem>

    vi) PersistenceManager Versioning part

    Comment this code:

    <PersistenceManager>
    <param name=”url” value=”jdbc:h2:${rep.home}/version/db”/>
    <param name=”schemaObjectPrefix” value=”version_”/>
    </PersistenceManager>

    Active this code:

    <PersistenceManager>
    <param name="url" value="jdbc:mysql://localhost:3306/jackrabbit"/>
    <param name="user" value="jcr_user" />
    <param name="password" value="password" />
    <param name="schema" value="mysql"/>
    <param name="schemaObjectPrefix" value="pm_ver_"/>
    </PersistenceManager>

    - web.xml

    <!– [BEGIN HSQLDB DATABASES]
    <context-param>
    <param-name>hsqldb-databases</param-name>
    <param-value>sampledata@../../data/hsqldb/sampledata,hibernate@../../data/hsqldb/hibernate,quartz@../../data/hsqldb/quartz</param-value>
    </context-param>
    [END HSQLDB DATABASES] –>

    <!– [BEGIN HSQLDB STARTER]
    <listener>
    <listener-class>org.pentaho.platform.web.http.context.HsqldbStartupListener</listener-class>
    </listener>
    [END HSQLDB STARTER] –>

    I created the databases correctly, with users and passwords, without any problem, everyting is operating well at this level.

    The problem now, is that some options aren't operating as expected or as they did before. I can't upload reports with PRD to the BI server, when I try system returns this error:

    "Unable to publish your file. Please try again or contact your system administrator for assistance"

    And if i try to open any file or manage anything in the pentaho user console it doesn't respond.

    I read the log files of the tomcat java application server, and they show some errors in the files pentaho.log and catalina.out
    ...
    Does someone know what is the problem? why do I have this errors? I attached the log files.

    Anyway, now I'm still working with pentaho and the original installed hSQLdb database for the platform and MySQL database for the data. I create the connections with mysql from the report data section and it's working perfectly, I can upload reports with PRD and all options and functions work as expected.

    How could I make the system work with mysql as the main database for the BI platform administration and operation?

    Many thanks in advance!
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2009
    Posts
    10

    Default

    I think you also need to change your JNDI datasources for system/jdbc.properties to use MySQL.

  3. #3
    Join Date
    May 2013
    Posts
    5

    Default

    Thanks kynx, but not function!


    I changed JNDI datasources for system/simple-jndi/jdbc.properties


    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
    jackrabbit/type=javax.sql.DataSource
    jackrabbit/driver=com.mysql.jdbc.Driver
    jackrabbit/url=jdbc:mysql://localhost:3306/jackrabbit
    jackrabbit/user=jcr_user
    jackrabbit/password=password

    After I restarted the service of pentaho, and I have the same errors.

    Reference number: 6efafe15-6f27-401a-8539-486936d46c1d
    2014-02-13 07:22:26,213 ERROR [org.pentaho.platform.dataaccess.datasource.wizard.service.impl.DSWDatasourceServiceImpl] DatasourceServiceImpl.ERROR_0022 - Unable to process logical model for domain id: steel-wheels.
    org.pentaho.platform.api.repository2.unified.UnifiedRepositoryException: PentahoMetadataDomainRepository.ERROR_0005 - Error retrieving domain with id [steel-wheels] - exception while getting data for file with id "fc37cbd3-30a9-4182-9e78-f2e4c87b10a8"
    .......
    2014-02-13 07:22:26,219 ERROR [org.pentaho.platform.dataaccess.datasource.wizard.service.impl.ConnectionServiceImpl] ConnectionServiceImpl.ERROR_0002 - Unable to get the list of connections: DatasourceMgmtService.ERROR_0004 - Error occurred during retrieving the datasource . Cause: exception while getting children for folder with id "5328ff95-64eb-46a2-b08b-ec42c77c4b45"



    Have another idea? Someone know what happens? Many thanks.

  4. #4
    Join Date
    Dec 2013
    Posts
    11

    Default

    check your MySQL, see if SampleData exists
    Name:  022414_115421_AM.jpg
Views: 55
Size:  31.1 KB


    and my JNDI content is bellow
    i add SampleData,then work for me

    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=pentaho_user
    Shark/password=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
    Attached Images Attached Images  

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.