US and Worldwide: +1 (866) 660-7555
Results 1 to 3 of 3

Thread: migrating to MySQL

  1. #1

    Default migrating to MySQL

    hi,

    i downloaded biserver-ce 2.0.0.M1 module which comes with a preconfigured Tomcat and Admin console. I'm trying to migrate this installation from using Hypersonic to using MySQL. Looks like the reporting part works but not the Admin console. On startup hibernate doesn't load properly. I modified all the config files in the administration-console, context.xml in META-INF of pentaho war, and everything in pentaho-solutions that had anything to do with hibernate to make it point to a remote mysql database, but it seems like something is holding on to the old url and user/password. Did I forget to modify something? Here's the stack trace:

    INFO: Hibernate Validator not found: ignoring
    Oct 16, 2008 10:57:40 AM org.hibernate.connection.DriverManagerConnectionProvide
    r configure
    INFO: Using Hibernate built-in connection pool (not for production use!)
    Oct 16, 2008 10:57:40 AM org.hibernate.connection.DriverManagerConnectionProvide
    r configure
    INFO: Hibernate connection pool size: 10
    Oct 16, 2008 10:57:40 AM org.hibernate.connection.DriverManagerConnectionProvide
    r configure
    INFO: autocommit mode: false
    Oct 16, 2008 10:57:40 AM org.hibernate.connection.DriverManagerConnectionProvide
    r configure
    INFO: using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/hi
    bernate
    Oct 16, 2008 10:57:40 AM org.hibernate.connection.DriverManagerConnectionProvide
    r configure
    INFO: connection properties: {user=hibuser, password=****}

    Oct 16, 2008 10:57:40 AM org.hibernate.cfg.SettingsFactory buildSettings
    WARNING: Could not obtain connection metadata
    java.sql.SQLException: Access denied for user 'hibuser'@'localhost' (using passw
    ord: YES)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:894)
    at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3808)
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1256)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2032)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
    :283)
    at java.sql.DriverManager.getConnection(DriverManager.java:525)
    at java.sql.DriverManager.getConnection(DriverManager.java:140)
    at org.hibernate.connection.DriverManagerConnectionProvider.getConnectio
    n(DriverManagerConnectionProvider.java:110)
    at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:
    84)
    at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073
    )
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.jav
    a:1298)
    at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(Annotat
    ionConfiguration.java:859)
    at org.pentaho.pac.server.common.HibernateSessionFactory.addOrUpdateConf
    iguration(HibernateSessionFactory.java:64)
    at org.pentaho.pac.server.common.HibernateSessionFactory.addConfiguratio
    n(HibernateSessionFactory.java:53)
    at org.pentaho.pac.server.common.HibernateSessionFactory.addDefaultConfi
    guration(HibernateSessionFactory.java:43)
    at org.pentaho.pac.server.PacServiceImpl.initialze(PacServiceImpl.java:9
    84)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
    java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
    sorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:5
    27)
    at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(Remot
    eServiceServlet.java:164)
    at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServ
    iceServlet.java:86)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487
    )
    at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:3
    67)
    at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:1
    81)
    at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:7
    12)
    at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.
    java:114)
    at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:1
    39)
    at org.mortbay.jetty.Server.handle(Server.java:285)
    at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:50
    2)
    at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnectio
    n.java:835)
    at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:638)
    at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:208)
    at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:378)
    at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.
    java:226)
    at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool
    .java:450)
    Oct 16, 2008 10:57:40 AM org.hibernate.dialect.Dialect <init>
    INFO: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect
    Oct 16, 2008 10:57:40 AM org.hibernate.transaction.TransactionFactoryFactory bui
    ldTransactionFactory
    INFO: Using default transaction strategy (direct JDBC transactions)
    Oct 16, 2008 10:57:40 AM org.hibernate.transaction.TransactionManagerLookupFacto
    ry getTransactionManagerLookup
    INFO: No TransactionManagerLookup configured (in JTA environment, use of read-wr
    ite or transactional second-level cache is not recommended)
    Oct 16, 2008 10:57:40 AM org.hibernate.cfg.SettingsFactory buildSettings

  2. #2

    Default Where does these settings come from????

    I have the same problem: I changed to mysql-Setting in admin-console and bi-server. I also changed database name and the database user. While accessing admin-console in webbrowser, I got the following Message:

    Unable to refresh data sources list: Failed to get a Data Source.

    and

    Unable to refresh security information: Failed to get user names.


    I think there is a standard configuration in the source code.

    Here the log:

    SCHWERWIEGEND: Unable to read file : ../pentaho-solutions/system/pentahoObjects.spring.xml
    2008-10-21 08:55:24.135::INFO: Started SocketConnector @ localhost:8099
    21.10.2008 08:55:43 org.hibernate.cfg.annotations.Version <clinit>
    INFO: Hibernate Annotations 3.3.1.GA
    21.10.2008 08:55:43 org.hibernate.cfg.Environment <clinit>
    INFO: Hibernate 3.2.6
    21.10.2008 08:55:43 org.hibernate.cfg.Environment <clinit>
    INFO: hibernate.properties not found
    21.10.2008 08:55:43 org.hibernate.cfg.Environment buildBytecodeProvider
    INFO: Bytecode provider name : cglib
    21.10.2008 08:55:43 org.hibernate.cfg.Environment <clinit>
    INFO: using JDK 1.4 java.sql.Timestamp handling
    21.10.2008 08:55:43 org.hibernate.cfg.Configuration configure
    INFO: configuring from resource: mysql5.hibernate.cfg.xml
    21.10.2008 08:55:43 org.hibernate.cfg.Configuration getConfigurationInputStream
    INFO: Configuration resource: mysql5.hibernate.cfg.xml
    21.10.2008 08:55:43 org.hibernate.cfg.Configuration addResource
    INFO: Reading mappings from resource : mysql5.hbm.xml
    21.10.2008 08:55:43 org.hibernate.cfg.Configuration doConfigure
    INFO: Configured SessionFactory: null
    21.10.2008 08:55:44 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
    INFO: Mapping class: org.pentaho.pac.common.datasources.PentahoDataSource -> DATASOURCE
    21.10.2008 08:55:44 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
    INFO: Mapping class: org.pentaho.pac.server.PentahoRole -> AUTHORITIES
    21.10.2008 08:55:44 org.hibernate.cfg.HbmBinder bindCollection
    INFO: Mapping collection: org.pentaho.pac.server.PentahoRole.assignedUsers -> GRANTED_AUTHORITIES
    21.10.2008 08:55:44 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
    INFO: Mapping class: org.pentaho.pac.server.PentahoUser -> USERS
    21.10.2008 08:55:44 org.hibernate.cfg.HbmBinder bindCollection
    INFO: Mapping collection: org.pentaho.pac.server.PentahoUser.assignedRoles -> GRANTED_AUTHORITIES
    21.10.2008 08:55:44 org.hibernate.cfg.AnnotationConfiguration secondPassCompile
    INFO: Hibernate Validator not found: ignoring
    21.10.2008 08:55:44 org.hibernate.connection.DriverManagerConnectionProvider configure
    INFO: Using Hibernate built-in connection pool (not for production use!)
    21.10.2008 08:55:44 org.hibernate.connection.DriverManagerConnectionProvider configure
    INFO: Hibernate connection pool size: 10
    21.10.2008 08:55:44 org.hibernate.connection.DriverManagerConnectionProvider configure
    INFO: autocommit mode: false
    21.10.2008 08:55:44 org.hibernate.connection.DriverManagerConnectionProvider configure
    INFO: using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/hibernate
    21.10.2008 08:55:44 org.hibernate.connection.DriverManagerConnectionProvider configure
    INFO: connection properties: {user=hibuser, password=****}
    21.10.2008 08:55:44 org.hibernate.cfg.SettingsFactory buildSettings
    WARNUNG: Could not obtain connection metadata
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'hibuser'@'localhost' to database 'hibernate'


    hibuser, localhost and hibernate are not configured! I don't know where the adminconsole find these settings.

    please help!

  3. #3

    Default

    i posted the solution in this thread http://forums.pentaho.org/showthread.php?t=65236

    good luck

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •