1 Reply Latest reply on Sep 20, 2002 9:05 PM by dragos popa

    mysql on linux, could not create connection

    dragos popa Newbie

      Hi,
      I have the same configuration(mysql and jboss 3.0.0) on Windows and it is working fine. When I am deploying on Linux it is failing. I am sure that I am missing something in the configuration (it is funny, I am getting some default values from somewhere like nobody@linuxfour - I am not using this values...:) )

      Do You have an ideea please?
      Any help very appreciated.

      Thank You,
      Madalin.

      Caused by: org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Invalid authorization specification: Access denied for user: 'nobody@linuxfour' (Using password: NO
      ; - nested throwable: (org.jboss.resource.ResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Invalid authorization specification: Access denied for user: 'nobody@linuxfour' (Usi
      password: NO)))
      at org.jboss.resource.adapter.jdbc.local.LocalDataSource.getConnection(LocalDataSource.java:106)
      at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.fixTableName(SQLUtil.java:38)
      ... 84 more
      Caused by: org.jboss.resource.ResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Invalid authorization specification: Access denied for user: 'nobody@linuxfour' (Using password:
      O))
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:144)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnection(InternalManagedConnectionPool.java:236)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:101)
      at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:312)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:467)
      at org.jboss.resource.connectionmanager.LocalTxConnectionManager.getManagedConnection(LocalTxConnectionManager.java:221)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:532)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:812)
      at org.jboss.resource.adapter.jdbc.local.LocalDataSource.getConnection(LocalDataSource.java:102)
      ... 85 more
      Caused by: java.sql.SQLException: Invalid authorization specification: Access denied for user: 'nobody@linuxfour' (Using password: NO)
      at org.gjt.mm.mysql.MysqlIO.init(Unknown Source)
      at org.gjt.mm.mysql.Connection.connectionInit(Unknown Source)