|
Deal all,
I have solved this problem, it looks like a JDBC problem.
Use this Mysql command at mysql server,
set password for <username>@<servername> =
old_password('<password>');
Reference from http://forums.mysql.com/read.php?39,6448,7168#msg-7168
===============================================
javax.servlet.ServletException: Communication failure during
handshake. Is there a server running on cetusa.mic.cwb:3306?
at gov.noaa.pmel.tmap.SessionFilter.initDefaultContexts(SessionFilter.java:210) at gov.noaa.pmel.tmap.SessionFilter.checkSession(SessionFilter.java:338) at gov.noaa.pmel.tmap.SessionFilter.doFilter(SessionFilter.java:367) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at gov.noaa.pmel.tmap.ExceptionFilter.doFilter(ExceptionFilter.java:24) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:195) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) Root cause of servlet exception was:
java.sql.SQLException: Communication failure during handshake.
Is there a server running on cetusa.mic.cwb:3306? at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:337) at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:276) at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Connection.java:89) at org.gjt.mm.mysql.Driver.connect(Driver.java:167) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:193) at gov.noaa.pmel.tmap.ConnectionManager.getConnection(ConnectionManager.java:39) at gov.noaa.pmel.tmap.db.DbaseObject.doDeserializeAggregate(DbaseObject.java:228) at gov.noaa.pmel.tmap.db.DbaseObject.deserializeAggregate(DbaseObject.java:332) at gov.noaa.pmel.tmap.db.DbaseObject.deserializeAggregate(DbaseObject.java:353) at gov.noaa.pmel.tmap.db.DbaseObject.deserializeAggregate(DbaseObject.java:341) at gov.noaa.pmel.tmap.db.Config.getConfigs(Config.java:82) at gov.noaa.pmel.tmap.DatasetItem.getItems(DatasetItem.java:79) at gov.noaa.pmel.tmap.DatasetItem.getItems(DatasetItem.java:24) at gov.noaa.pmel.tmap.SessionFilter.initDefaultContexts(SessionFilter.java:51) at gov.noaa.pmel.tmap.SessionFilter.checkSession(SessionFilter.java:338) at gov.noaa.pmel.tmap.SessionFilter.doFilter(SessionFilter.java:367) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at gov.noaa.pmel.tmap.ExceptionFilter.doFilter(ExceptionFilter.java:24) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:195) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) java.sql.SQLException: Communication failure during handshake. Is there a server running on cetusa.mic.cwb:3306? at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:337) at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:276) at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Connection.java:89) at org.gjt.mm.mysql.Driver.connect(Driver.java:167) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:193) at gov.noaa.pmel.tmap.ConnectionManager.getConnection(ConnectionManager.java:39) at gov.noaa.pmel.tmap.db.DbaseObject.doDeserializeAggregate(DbaseObject.java:228) at gov.noaa.pmel.tmap.db.DbaseObject.deserializeAggregate(DbaseObject.java:332) at gov.noaa.pmel.tmap.db.DbaseObject.deserializeAggregate(DbaseObject.java:353) at gov.noaa.pmel.tmap.db.DbaseObject.deserializeAggregate(DbaseObject.java:341) at gov.noaa.pmel.tmap.db.Config.getConfigs(Config.java:82) at gov.noaa.pmel.tmap.DatasetItem.getItems(DatasetItem.java:79) at gov.noaa.pmel.tmap.DatasetItem.getItems(DatasetItem.java:24) at gov.noaa.pmel.tmap.SessionFilter.initDefaultContexts(SessionFilter.java:51) at gov.noaa.pmel.tmap.SessionFilter.checkSession(SessionFilter.java:338) at gov.noaa.pmel.tmap.SessionFilter.doFilter(SessionFilter.java:367) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at gov.noaa.pmel.tmap.ExceptionFilter.doFilter(ExceptionFilter.java:24) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:195) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) --
cch |