Messages

16

QueueMetrics installation / [Help Needed]: It looks like you don't have a working JDBC connection.

« on: November 03, 2011, 18:29:26 »

QM went boom


Error JDBC:-- Inner Exception -- - Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException - Error: - Could not create connection to database server. Attempted reconnect 3 times. Giving up.Stack trace: - com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. - at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) - at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) - at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) - at java.lang.reflect.Constructor.newInstance(Constructor.java:513) - at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) - at com.mysql.jdbc.Util.getInstance(Util.java:386) - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013) - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) - at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2237) - at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2158) - at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:792) - at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47) - at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) - at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) - at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) - at java.lang.reflect.Constructor.newInstance(Constructor.java:513) - at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) - at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381) - at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) - 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:549) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(LowayTransactionController.java:391) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doGet(LowayTransactionController.java:235) - 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) - Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure - - The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. - at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) - at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) - at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) - at java.lang.reflect.Constructor.newInstance(Constructor.java:513) - at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) - at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116) - at com.mysql.jdbc.MysqlIO.(MysqlIO.java:344) - at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2332) - at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2176) - ... 42 more - Caused by: java.net.ConnectException: Connection refused - 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:529) - at java.net.Socket.connect(Socket.java:478) - at java.net.Socket.(Socket.java:375) - at java.net.Socket.(Socket.java:218) - at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257) - at com.mysql.jdbc.MysqlIO.(MysqlIO.java:294) - ... 44 more - -- End Inner Exception -- - "

17

QueueMetrics installation / [resolved] "User not found" login error after creating new user SIP/2000

« on: November 01, 2011, 08:10:45 »

I created a new user identical to the others in the format:

SIP/2000


Attempt to login to queuemetrics with that user:

"User not found"



The others appear to login ok, anyone have a suggestion?

18

QueueMetrics installation / Re: [solved] QM fails silently after install, wont load main page or dbtest

« on: July 26, 2011, 20:46:12 »

Thanks, removing the queuemetrics java package then installing qm again worked great !

19

Scripting QueueMetrics / Working example for php custom wallboard

« on: July 25, 2011, 22:55:38 »

Update: Multiple bugs on the provided wallboard, unhappy clients, no resolution will realistically be available:

Tell your clients NO, these ad-hoc wallboards are NOT officially supported. Just don't do it, unless you are in prison and really need something to take time.


DO: use the built in supported wallboards

-----------------------

Thanks, that works great.
-------------
A customer requested a custom display, but I am in a bind as the documentation appears non-existant at this time.


There is a huge post a bit further down this page, although the source code link is down and no one bothered to paste the program in it's entirety into the post, which of course invalidates the entire thing.
http://forum.queuemetrics.com/index.php?topic=156.0

(I even attempted to mine the google cache for that downed reference site)


I got a standard "wallboard" going just fine with the robot user.

Where is there a working example anywhere for PHP ??



I followed the instructions in the .pdf but all I get is an error message.

Fault Code: 5 Fault Reason: Didn't receive 200 OK from remote server. (HTTP/1.1 404 /queuemetrics-1.7.1.0/xmlrpc.do)


Is this a user authentiction error or an input error, what?







 

Code: [Select]

<h1>A QueueMetrics XML-RPC client in PHP</h1>
<?php
require_once 'XML/RPC.php';
$qm_server = "ip_address"; // the QueueMetrics server address
$qm_port   = "8080";        // the port QueueMetrics is running on
$qm_webapp = "queuemetrics-1.7.1.0"; // the webapp name for QueueMetrics


// set which response blocks we are looking for
$req_blocks = new XML_RPC_Value(array(
                          new XML_RPC_Value("DetailsDO.CallsOK"),
                          new XML_RPC_Value("DetailsDO.CallsKO")
                 ), "array");
// general invocation parameters - see the documentation
$params = array(
new XML_RPC_Value("queue-dps"),
                 new XML_RPC_Value("robot"),
                 new XML_RPC_Value("robot"),
                 new XML_RPC_Value("lol"),
                 new XML_RPC_Value("lol"),
                 new XML_RPC_Value("2011-07-25.12:23:12"),
                 new XML_RPC_Value("2011-07-25.08:23:10"),
                 new XML_RPC_Value(""),
                 $req_blocks
       );
$msg = new XML_RPC_Message('QM.stats', $params);
$cli = new XML_RPC_Client("/$qm_webapp/xmlrpc.do", $qm_server, $qm_port);
//$cli->setDebug(1);
$resp = $cli->send($msg);
if (!$resp) {
    echo 'Communication error: ' . $cli->errstr;
    exit;
}
if ($resp->faultCode()) {
    echo 'Fault Code: ' . $resp->faultCode() . "\n";
    echo 'Fault Reason: ' . $resp->faultString() . "\n";
} else {
    $val = $resp->value();
    $blocks = XML_RPC_decode($val);
    // now we print out the details....
    printBlock( "result", $blocks );
    printBlock( "DetailsDO.CallsOK", $blocks );
    printBlock( "DetailsDO.CallsKO", $blocks );
}
// output a response block as HTML
function printBlock( $blockname, $blocks ) {
         echo "<h2>Response block: $blockname </h2>";
         echo "<table border=1>";
         $block = $blocks[$blockname];
         for ( $r = 0; $r < sizeof( $block ); $r++ ) {
                 echo "<tr>";
                 for ( $c = 0; $c < sizeof( $block[$r] ); $c++ ) {
                          echo( "<td>" . $block[$r][$c] . "</td>" );
                 }
                 echo "</tr>\n";
         }
         echo "</table>";
}
?>


20

Scripting QueueMetrics / [solved] XML/RPC.php apparently not found

« on: July 25, 2011, 22:21:46 »

yum install php-pear


--------------------------
Hello,

I've been trying to get the php example to work and a key is apparently the file "XML/RPC.php"


It appears that the file does not exist on the server. I installed the  http://sourceforge.net/projects/phpxmlrpc/files/phpxmlrpc/2.2.2/

but the required fie is not there.




Thanks

21

QueueMetrics installation / [solved] QM fails silently after install, wont load main page or dbtest

« on: July 15, 2011, 06:18:37 »

yum -y remove queuemetrics-java

yum -y install queuemetrics

----------------------------------------------------------------
For some reason it wont install on my laptop.

When going to: http://127.0.0.1:8080/queuemetrics, a blank page.


Mysql is running, it gave no errors, apparently.


I attempted to delete folders manually, but yum looked like it didnt install the init script so "queuemetrics" is unrecognized service even if it is installed.



]# yum -y install queuemetrics;
Loaded plugins: presto, refresh-packagekit
Setting up Install Process
Package queuemetrics-1.7.1.0-84.noarch already installed and latest version
Nothing to do

# service queuemetrics restart
queuemetrics: unrecognized service

22

QueueMetrics installation / stuck at: "We have detected that your database needs updating"

« on: May 26, 2011, 21:19:13 »

Hello, the software has a bug where it wont take up a previous versions database. We are stuck at a continuous cycle of "We have detected that your database needs updating".

http://i.imgur.com/FWAvb.png

This is after upgrade from a previous version to the most current

How can we get past this screen and get QM up and running as designed?

23

Running QueueMetrics / [solved] License key wont update from demo after upgrade

« on: April 05, 2011, 20:33:08 »

after doing yum -y install queuemetrics it created the new folder: queuemetrics-version

1) I went to the old folder copied that key, making certain that I copied it exactly from the previous installed and purchased version.

2) Copied old key into newinstall

3) it said demo

4) sent both old and new keys th QM, they said they were both demo's, but kindly sent a copy of the key to the client as they had purchesed it.


CONCLUSION:

The install wiped out the old and paid for key, almost no question about it, and replaced with a demo. It also wiped out the company logo and all other files except for web.xml in the old folder.

---------------------------------------

After a reinstall of a new version of QM,

and putting the old license key in web.xml,

it wont update to the paid for key.



tomcat and QM restarted,

24

Running QueueMetrics / Re: QM suddenly failed, no error messages, web page wont load

« on: April 05, 2011, 19:32:53 »

yes, did that yesterday

ok, reinstalling queumetrics with yum, its taking a long time to download the package "queuemetrics-java"

UPDATE:


reinstalled qm, fixed the issue

New problem with licences not updating:

25

Running QueueMetrics / [solved] QM suddenly failed, no error messages, web page wont load

« on: April 04, 2011, 22:58:28 »

Resolved with a complete removal of queuemetrics-java package, then

yum -y install queuemetrics

new issue:

key wont update
http://forum.queuemetrics.com/index.php?topic=1240.0


-------------------------------------

Queue metrics died suddenly on a system

1) times out when going to page
2) no error messages or indication that anything is wrong
3) did a mysqlcheck on queuemetrics database, it found and fixed an error
3) restarted mysql / tomcat / queuemetrics / httpd / asterisk


update: was able to produce this error after stopping qloader, restarting, killing off processes named java, then restarting queuemetrics:

[root@server ~]# service 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
Catalina.stop: java.net.ConnectException: Connection refused
java.net.ConnectException: Connection refused
   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:529)
   at java.net.Socket.connect(Socket.java:478)
   at java.net.Socket.<init>(Socket.java:375)
   at java.net.Socket.<init>(Socket.java:189)
   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:597)
   at org.apache.catalina.startup.Bootstrap.stopServer(Bootstrap.java:336)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:427)


not sure if this is normal, but I'm searching for anything remotely related

any testing ideas?


Thanks

26

Running QueueMetrics / Re: Discrepancy between Real time and Live monitoring

« on: November 19, 2010, 21:36:34 »

thank you for the reply

the client reports that agents in question were logged in and out,

27

Running QueueMetrics / Discrepancy between Real time and Live monitoring

« on: November 16, 2010, 19:58:03 »

Hello,

Queue metrics is report different values depending on the screen, and the client is persistent with questions and a request to get it working.


In Reatime monitoring, several agents do not show as logged in.

In Live monitoring, they do show as logged in.



What could explain the difference and how to get it fixed?

28

Running QueueMetrics / Re: QM dead on box 2, when HD on asterisk box 1 became full

« on: April 14, 2010, 20:52:15 »

Queuemetrics loads without errors generated on the web page portion.

Login is allowed,

Liscence info shows current info of a valid QM install.

No current status shows up, that is all agents and queues are shown, but it says calls:0.


Box2

tomcat restart procedure ( several steps )
service queuemetrics restart
service httpd  restart
service mysqld  restart

then finally a reboot


Box1

tomcat restart procedure ( several steps )
service queuemetrics restart
service httpd  restart
service asterisk restart  (and manual restart of asterisk with cli )
service qloaderd restart
service mysqld  restart

The technician who set it up was on it yesterday and presumable this morning, but the client emailed again asking about it.

Could the qloader have started with a blank partition somehow when the HD got full and mysql database was repaired?

How to check if qloader is drawing the data correctly from the messages log?  Not certain but it could be that qloader is not sending data to box 2.

29

Running QueueMetrics / QM not showing status on box 2, when HD on asterisk box one became full

« on: April 13, 2010, 22:41:48 »

A setup had been working for about a year with asterisk on box 1, and queuemetrics on box 2.


The asterisk box (1) suffered a full harddrive and now queuemetrics is effectively dead on server (2), not showing live readout.


why / how to fix ?

30

Running QueueMetrics / Change daylight savings time to correct? (Java updater Broken)

« on: March 15, 2010, 19:32:39 »

Final Update:

Fixed with a hacky workaround, the java opts variable:

export JAVA_OPTS="-Xms128M -Xmx128M -server -Duser.timezone=GMT+05:00"

(Altering the GMT in the daemon startup script)


A sanctioned and lasting way does not work, but life goes on  .


---------------------------

I have run the java updater over and over, it does not give errors, but queuemetrics time simply refuses to change. This is frustrating because everything was seemingly done right, need to get this going.

( tomcat shurtdown/ restart, service queuemtrics restarted)





[root@server1 tzupdater-1.3.25-2009u]# /usr/local/queuemetrics/jdk1.5.0_11/jre/bin/java -jar tzupdater.jar -u -v -f
java.home: /usr/local/queuemetrics/jdk1.5.0_11/jre
java.vendor: Sun Microsystems Inc.
java.version: 1.5.0_11
JRE time zone data version: tzdata2009u
Embedded time zone data version: tzdata2009u
Extracting files... done.
Renaming directories... done.
Validating the new time zone data... done.
Time zone data update is complete.

-------------------------------------------------------------------------------------------------

Queuemetrics time is off by 1 hour due to daylight savings time. Google came up dry.

This thread mentions a java updater, but it spits back complaints.
http://forum.queuemetrics.com/index.php?topic=6.0


tried the updater:

[root@server1 tzupdater-1.3.25-2009u]# java -jar tzupdater.jar --verbose --test
The Java runtime doesn''t have time zone data (zi directory).



Java version:

[root@server1 tzupdater-1.3.25-2009u]# java --version
java version "1.5.0"
gij (GNU libgcj) version 4.1.2 20070925 (Red Hat 4.1.2-27)

Copyright (C) 2006 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
You have mail in /var/spool/mail/root

Please help, it there no other way to force queuemetrics into the correct time?