QueueMetrics forum
QueueMetrics => QueueMetrics installation => Topic started by: jpbconsulting on November 13, 2008, 04:13:34
-
Server: CentOS 5.2
Asterisk Version: 1.4.21.2
QueueMetrics installed via YUM. Installed without issue.
Tomcat Root: /usr/local/queuemetrics/tomcat/webapps/ROOT/
QueueMetrics Root: /usr/local/queuemetrics/webapps/queuemetrics-1.4.7/
Logical link queuemetrics exists
Unable to start with http://servername:8080/queuemetrics or http://servername:8080/queuemetrics-1.4.7
Tomcat starts with http://servername:8080 and all servlets appear to be working properly.
QueueMetrics will not start. I receive "Loading..." and that's it. What am I missing?
-
QM will compile its own page son first access. This might take a while on a slower box. Try this:
/etc/init.d/queuemetrics restart
Try to access: http://seerver:8080/queuemetrics
If it does not work, wait a couple of minutes without restarting and try again.
-
Unfortunately, that didn't work. When executing the restart command, the following appears:
/etc/rc.d/init.d/queuemetrics restart ..
Stopping QueueMetrics: Using CATALINA_BASE: /usr/local/queuemetrics/tomcat
Using CATALINA_HOME: /usr/local/queuemetrics/tomcat
Using CATALINA_TMPDIR: /usr/local/queuemetrics/tomcat/temp
Using JAVA_HOME: /usr/local/queuemetrics/java
... and then it just sits there. Nothing further appears to occur. No errors, nothing.
-
It appears that I didn't wait long enough. The following occurs:
Catalina.stop: java.net.ConnectException: Connection timed out
java.net.ConnectException: Connection timed out
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:519)
at java.net.Socket.connect(Socket.java:469)
at java.net.Socket.<init>(Socket.java:366)
at java.net.Socket.<init>(Socket.java:179)
at org.apache.catalina.startup.Catalina.stopServer(Catalina.java:410)
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:585)
at org.apache.catalina.startup.Bootstrap.stopServer(Bootstrap.java:336)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:427)
Starting QueueMetrics: Using CATALINA_BASE: /usr/local/queuemetrics/tomcat
Using CATALINA_HOME: /usr/local/queuemetrics/tomcat
Using CATALINA_TMPDIR: /usr/local/queuemetrics/tomcat/temp
Using JAVA_HOME: /usr/local/queuemetrics/java
How does QueueMetrics address the local mySQL server and databases. I am assuming that it is using the root connection or the javadude user name assigned when installing. Is this a typeo somewhere? Where do I look?
-
This error is strange - it is not Queuemetrics, it's Tomcat trying to connect somewhere - as you can see there are no "loway" classes in the strack trace.... do you have a firewall on the box? maybe it's trying to connect to itself.
-
The application worked for a short period of time and now is displaying the following error when I attempt to connect:
"Errore JDBC:java.sql.SQLException: Server connection failure during transaction. Due to underlying exception: 'java.net.SocketException: java.net.ConnectException: Connection timed out'. - - ** BEGIN NESTED EXCEPTION ** - - java.net.SocketException - MESSAGE: java.net.ConnectException: Connection timed out - - STACKTRACE: - - java.net.SocketException: java.net.ConnectException: Connection timed out - at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) - at com.mysql.jdbc.MysqlIO.(MysqlIO.java:284) - at com.mysql.jdbc.Connection.createNewIO(Connection.java:2680) - at com.mysql.jdbc.Connection.(Connection.java:1485) - at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) - at java.sql.DriverManager.getConnection(DriverManager.java:525) - at java.sql.DriverManager.getConnection(DriverManager.java:193) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(Unknown Source) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(Unknown Source) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doGet(Unknown Source) - 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:595) - - - ** END NESTED EXCEPTION ** - - - Attempted reconnect 3 times. Giving up."
This error occurred after rebooting the server. Any suggestions?
-
This is QM trying to connect to the MySQL server, with the MySQL server not responding - likley it's not running, or it has been moved elsewhere. Check the JDBC_URI property in your web.xml file.
-
That fixed it. The problem was resolved by adding the server name to the list of hosts for access to the database. By default, QueueMetrics uses "localhost". Unfortunately, the way I connect requires either "Any" or the host name to attach.
Thank you for your help.
-
:D
-
@jpbconsulting
I am new to CentOS and QM, I had similar issue after rebooting my server, I am no longer able to access QM and getting an error.
How did you exactly add localhost to the list of hosts for access to database? Please advise.
Thanks,
FD360
-
Hello,
Get in touch with support at support@loway.ch.
Send a screenshot with the error message and the complete error log.
/usr/local/queuemetrics/tomcat/logs/
Best Regards,
Iacob