Messages

1

QueueMetrics installation / Connecting to the database Error

« on: November 07, 2008, 11:43:17 »

   
I bought the 10 licensed agents.
I'm trying to install 1.4.7 on queuemetrics slackware 12.0 kernel 2.6.21.5-smp with asterisk 1.4 and freepbx.

The server has no graphical interface, and the connection is from another computer:

http://10.0.0.114:8080/queuemetrics/

10.0.0.114 ip server

The web.xml file is the default, but I also tried with: ... jdbc: mysql: / / 10.0.0.114/queuemetrics? ...

I also tried to add user mysql

queuemetrics@10.0.0.114, queuemetrics@localhost.localdomain
queuemetrics @%

I tried to use:
- Tomcat 5.0.28, 5.5.12, and 6.0.16
- Java j2sdk-1_5_0_04-i586-1, jdk-1_5_0_11-linux-i586, dk-6u10-linux-i586.
- J Connector Mysql 3.0.10, 3.1.12, 5.0.8, 5.1.7
- MySql 5.0.37

I always make the same mistake: Connecting to the database.

Problem encountered:
Please set the correct server address, database name, user name and password to access the MySQL database.
To do so, edit the JDBC_URL property of WEB-INF/web.xml

- Only in some cases (eg connector 3.1.12)

Java Error:
java.sql.SQLException: Server connection failure during transaction. Due to underlying exception: 'java.net.SocketException: java.net.ConnectException: Connection refused'. ** BEGIN nested EXCEPTION ** java.net.SocketException MESSAGE: java.net.ConnectException: Connection refused STACKTRACE: java.net.SocketException: java.net.ConnectException: Connection refused 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.app.queuemetrics.jdbcTester.jdbcTester.testJdbcConn (Unknown Source) at org.apache.jsp.dbtest.index_jsp._jspService (index_jsp.java: 187) at org.apache.jasper.runtime.HttpJspBase.service (HttpJspBase.java: 94) at javax.servlet.http.HttpServlet.service (HttpServlet.java: 802) at org.apache.jasper.servlet.JspServletWrapper.service (JspServletWrapper.java: 324) at org.apache.jasper. servlet.JspServlet.serviceJspFile (JspServlet.java: 292) at org.apache.jasper.servlet.JspServlet.service (JspServlet.java: 236) 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.

Thanks for the help.