Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: mysql connection

  1. #1

    Default mysql connection

    I have intalled pentho 1.6 and I have installed the database dump into my mysqldatabase. I'm working on a Ubuntu machine with mysql 5.0. I have check the -ds.xml files to check for connection parameters and even confirmed that the pentaho_user has the password "password" but I still get the error: Error: SQLBaseComponent.ERROR_0007 - [es_258] Connection to data source is not valid (org.pentaho.plugin.sql.SQLLookupRule)
    ....
    Error: ConnectFactory.ERROR_0001 - [es_1] Database connection could not be established to: SampleData - org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: S1000 General error java.lang.RuntimeException: database alias does not exist); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: S1000 General error java.lang.RuntimeException: database alias does not exist)) (org.pentaho.plugin.sql.SQLLookupRule)

    Can anyone help me?? I should have ready a demo in 2 weeks and this is not working so smooth as I thought.

    Thanks

    Iván Gómez ----> LAF

  2. #2
    Join Date
    Nov 2005
    Posts
    164

    Default

    There are also some other files that have been configured for mysql:

    They are configured to use localhost and port 3306 (default port for mysql):

    pentaho.war/WEB-INF/classes/hibernate.cfg.xml
    pentaho.war/WEB-INF/classes/jndi/hibernate.cfg.xml
    pentaho.war/WEB-INF/classes/org/pentaho/repository/*.xml
    pentaho.war/WEB-INF/classes/org/pentaho/repository/content/*.xml
    pentaho.war/WEB-INF/classes/org/pentaho/repository/runtime/*.xml
    pentaho.war/WEB-INF/classes/com/pentaho/repository/dbbased/solution/*.xml
    pentaho.war/WEB-INF/classes/com/pentaho/repository/subscribe/*.xml
    server/default/deploy/*-ds.xml

    So if you are running mysql on a port other than 3306, then you need to modify these files.

    Let's start there. Let me know on which port mysql is running. If it is other than 3306, open the above files and modify them. Then restart pentaho.

    - Brian Hagan
    Pentaho Support Engineer / Build Engineer

  3. #3
    Join Date
    Aug 2007
    Posts
    13

    Default context.xml for mysql

    i created the following file context.xml and put it into the <tomcat-root>/webapps/pentaho/META-INF directory.
    this enables connection for the pentaho-solutions sample apps.

    <Context path="/pentaho" docbase="webapps/pentaho/">
    <Resource name="jdbc/SampleData" auth="Container" type="javax.sql.DataSource" maxActive="20"
    maxIdle="5" maxWait="10000" username="pentaho_user" password="password"
    factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="com.mysql.jdbc.Driver"
    url="jdbc:mysql://localhost:3306/sampledata" />
    <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" />
    <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" />
    <Resource name="jdbc/Shark" auth="Container" type="javax.sql.DataSource"
    factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5"
    maxWait="10000" username="sa" password="" driverClassName="com.mysql.jdbc.Driver"
    url="jdbc:mysql://localhost/shark" />
    <Resource name="jdbc/SampleDataAdmin" auth="Container" type="javax.sql.DataSource" maxActive="20"
    maxIdle="5" maxWait="10000" username="pentaho_admin" password="password"
    factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="com.mysql.jdbc.Driver"
    url="jdbc:mysql://localhost:3306/sampledata" />
    </Context>

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.