Author Topic: The connection to MySQL does not seem to be working correctly.  (Read 3864 times)

haihai2212

  • Newbie
  • *
  • Posts: 3
  • Karma: 0
    • View Profile
    • Email
 

     

A problem occurred in QueueMetrics.

The following error occurred in the Transaction handler:
"Error JDBC:-- Inner Exception -- - Exception: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException - Error: - Server connection failure during transaction. Due to underlying exception: 'java.sql.SQLException: Access denied for user 'queuemetrics'@'localhost' (using password: YES)'. - - ** BEGIN NESTED EXCEPTION ** - - java.sql.SQLException - MESSAGE: Access denied for user 'queuemetrics'@'localhost' (using password: YES) - - STACKTRACE: - - java.sql.SQLException: Access denied for user 'queuemetrics'@'localhost' (using password: YES) - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) - at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) - at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885) - at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421) - at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247) - at com.mysql.jdbc.Connection.createNewIO(Connection.java:2924) - at com.mysql.jdbc.Connection.(Connection.java:1555) - at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285) - at java.sql.DriverManager.getConnection(DriverManager.java:582) - at java.sql.DriverManager.getConnection(DriverManager.java:207) - at it.loway.tpf.SQL.openConnection(SQL.java:51) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(LowayTransactionController.java:531) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(LowayTransactionController.java:373) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doGet(LowayTransactionController.java:217) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) - at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) - at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) - at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) - at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) - at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) - at java.lang.Thread.run(Thread.java:662) - - - ** END NESTED EXCEPTION ** - - - Attempted reconnect 3 times. Giving up.Stack trace: - com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Server connection failure during transaction. Due to underlying exception: 'java.sql.SQLException: Access denied for user 'queuemetrics'@'localhost' (using password: YES)'. - - ** BEGIN NESTED EXCEPTION ** - - java.sql.SQLException - MESSAGE: Access denied for user 'queuemetrics'@'localhost' (using password: YES) - - STACKTRACE: - - java.sql.SQLException: Access denied for user 'queuemetrics'@'localhost' (using password: YES) - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) - at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) - at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885) - at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421) - at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247) - at com.mysql.jdbc.Connection.createNewIO(Connection.java:2924) - at com.mysql.jdbc.Connection.(Connection.java:1555) - at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285) - at java.sql.DriverManager.getConnection(DriverManager.java:582) - at java.sql.DriverManager.getConnection(DriverManager.java:207) - at it.loway.tpf.SQL.openConnection(SQL.java:51) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(LowayTransactionController.java:531) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(LowayTransactionController.java:373) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doGet(LowayTransactionController.java:217) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) - at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) - at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) - at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) - at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) - at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) - at java.lang.Thread.run(Thread.java:662) - - - ** END NESTED EXCEPTION ** - - - Attempted reconnect 3 times. Giving up. - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888) - at com.mysql.jdbc.Connection.createNewIO(Connection.java:2997) - at com.mysql.jdbc.Connection.(Connection.java:1555) - at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285) - at java.sql.DriverManager.getConnection(DriverManager.java:582) - at java.sql.DriverManager.getConnection(DriverManager.java:207) - at it.loway.tpf.SQL.openConnection(SQL.java:51) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(LowayTransactionController.java:531) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(LowayTransactionController.java:373) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doGet(LowayTransactionController.java:217) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) - at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) - at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) - at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) - at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) - at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) - at java.lang.Thread.run(Thread.java:662) - -- End Inner Exception -- - " 
Root cause: The connection to MySQL does not seem to be working correctly. 

What bug is this?
when i access http://192.168.11.183:8080/queuemetrics/

haihai2212

  • Newbie
  • *
  • Posts: 3
  • Karma: 0
    • View Profile
    • Email
Re: The connection to MySQL does not seem to be working correctly.
« Reply #1 on: March 12, 2011, 10:43:01 »
 

     

A problem occurred in QueueMetrics.

Root cause: The connection to MySQL does not seem to be working correctly. 

What bug is this?
when i access http://192.168.11.183:8080/queuemetrics/
Help me please.................

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: The connection to MySQL does not seem to be working correctly.
« Reply #2 on: March 14, 2011, 09:15:41 »
java.sql.SQLException: Access denied for user 'queuemetrics'@'localhost' (using password: YES)

It is on the FAQs: see here: http://queuemetrics.com/faq.jsp#faq-009


haihai2212

  • Newbie
  • *
  • Posts: 3
  • Karma: 0
    • View Profile
    • Email
Re: The connection to MySQL does not seem to be working correctly.
« Reply #3 on: March 29, 2011, 11:45:34 »
thank you

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: The connection to MySQL does not seem to be working correctly.
« Reply #4 on: March 30, 2011, 16:52:04 »
 ;D