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

Ramy Mostafa

  • Newbie
  • *
  • Posts: 2
  • Karma: 0
    • View Profile
Dear All

It's my 1st time installing QueueMetrics, but after installstion i found this in web interface.



"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 -- - "


The QueueMetrics is installed by yum
queuemetrics-java-1.6.0_22-21
queuemetrics-tomcat-5.0.28-9
queuemetrics-1.7.0.0-79

Is there is any solution to this please help  :(

Regards

Ramy Mostafa

  • Newbie
  • *
  • Posts: 2
  • Karma: 0
    • View Profile
It's working fine now due to checking and repaire the mysql databases of queuemetrics so please follow instruction bellow as in FQ :


In order to fix these issues, you should:

stop MySQL - THIS IS EXTREMELY IMPORTANT
/etc/init.d/mysqld stop
check tables using myisamchk (use the same case as written here):
myisamchk -c /var/lib/mysql/queuemetrics/*.MYI
if any error is shown, repair tables:
myisamchk -r /var/lib/mysql/queuemetrics/*.MYI
after that, restart Mysql:
/etc/init.d/mysqld start

:)
Regards

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics