Hi Everbody,

I am using Hibernate3.0 and MYSQl (version 5.02 alpha nt)as DB. While starting tomcat serevr I get following error message :





Oct 19, 2005 9:07:43 AM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://192.168.253.10:3306/retailpc
Oct 19, 2005 9:07:43 AM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=retailpc , password=****}
Oct 19, 2005 9:07:44 AM org.hibernate.cfg.SettingsFactory buildSettings
WARNING: Could not obtain connection metadata
java.sql.SQLException: Access denied for user 'retailpc '@'192.168.253.21' (using password: YES)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:771)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3647)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1176)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2544)
at com.mysql.jdbc.Connection.<init>(Connection.java:1474)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1463)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1004)
at utilities.HibernateUtil.<clinit>(Unknown Source)
at com.transending.TransendingStartup.initialize(Unknown Source)
at com.transending.TransendingStartup.init(Unknown Source)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1029)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:862)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4013)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4357)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478)
at org.apache.catalina.core.StandardService.start(StandardService.java:480)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:2313)
at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:287)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425)
Oct 19, 2005 9:07:44 AM org.hibernate.dialect.Dialect <init>


Entry in hibernate.properties


hibernate.dialect org.hibernate.dialect.MySQLDialect
hibernate.dialect org.hibernate.dialect.MySQLInnoDBDialect
hibernate.dialect org.hibernate.dialect.MySQLMyISAMDialect
hibernate.connection.driver_class = com.mysql.jdbc.Driver
hibernate.connection.url =jdbc:mysql://192.168.253.10:3306/retailpc
hibernate.connection.username = retailpc
hibernate.connection.password = retailpc_dev

I checked my MYSQL permission, all grant is assigned to the user. I am able to generate Java class and hbm.xml file using middlegen. When I try to connect same database using java "connection" object and sql , I am able to make it but somehow this error is comming. Please help me to sort out this bug. Thanks in advance

Thanks
Vikram

the red stuff has password = YES, the blue stuff has a password of retailpc_dev .

Thanks for reply, red stuff "password = YES " means that this require password, if it is No than password is not required

Thanks
Vikram

is the web server on the same machine as the one you used middlegen w/ ?

there also appears to be a space after the username in the logging output.

Yes webserevr(Tomcat/5.0.28) is on the same machine as the middlegen.

Thanks
Vikram

In this line ?

java.sql.SQLException: Access denied for user 'retailpc '@'192.168.253.21' (using password: YES)

yes, there is a space. is this your problem?

Hi Dnnis,

It does not seems to be problem....


Thanks
Vikram

try
jdbc:mysql://localhost:3306/retailpc
instead of
jdbc:mysql://192.168.253.10:3306/retailpc

Hi chirigi,

Thanks for reply, actually my DB server is on remote machine, so I have to give remote address.

Vikram