QueueMetrics > QueueMetrics installation

The connection to MySQL does not seem to be working correctly.

(1/1)

haihai2212:
 

     

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:

--- Quote from: haihai2212 on March 12, 2011, 10:00:39 --- 

     

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/

--- End quote ---
Help me please.................

QueueMetrics:

--- Quote from: haihai2212 on March 12, 2011, 10:00:39 ---java.sql.SQLException: Access denied for user 'queuemetrics'@'localhost' (using password: YES)

--- End quote ---

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

haihai2212:
thank you

QueueMetrics:
 ;D

Navigation

[0] Message Index