Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - cuban_cigar

Pages: [1] 2
1
This began happening after a QM upgrade.

1) queue_logs show no activity for sip extension or asterisk agent

2) "queue show" readout does not display the agent.


As far as my understanding, this should not be happening. I have invested time troubleshooting, and the site personal would like this fixed as it has persisted for a good amount of time, and interferes with their operations.

2
Suddenly after an upgrade, when an agent is logged into QM, and a call comes in, QM automatically pops up a new tab and does a search for "www.server.com"


This sudden new behavior is highly unwanted.

I'm having difficulty locating the documentation which describes how to turn it off.

Questions

1) Why does this even exist?
2) How to be rid of it?

Thanks,

3

update dbversion to be 10 like it wanted manually in the queuemetrics mysql database

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


The mysql DB is repaired an optimized to no avail. QM just keeps being stuck in it's "update the database" loop, never completing.


Checking database revision - required version:10     Error     Java Error: DB revision error: was 2 - required 10



What now?




4
I confess that I have been struggling with understanding the XML-RPC and QM. It has been difficult to learn simple things such as pulling data from it.
What I would like to be able to do is this:

1) Pull a simple list of the agents

2) Pull agent status

3) Pull calls waiting



Anyone have any idea how to do it?


Thanks again

5
Running QueueMetrics / [solved] - Transaction handler trouble
« on: October 16, 2012, 01:00:47 »
Doh, the expired license tricked me again, I think I have spend a dozen hours on these until I pick out the hidden "Please contact Loway for a renewal"

There is low probability that an office manager, secretary, or call center manager will be able to determine that they need to renew the license.

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

Sofar I have put in the following work to attempt to resolve this:

1) optimized and repaired databases
2) restarted http, queumetrics, tomcat
3) yum installed the latest version of QM



Still this error persists:

"[JSP] javax.servlet.ServletException - -- Inner Exception -- Exception: javax.servlet.ServletException Error: **** DTSC - HarperMo-USA-CC1 - Please contact Loway for a renewal. Stack trace: javax.servlet.ServletException: **** DTSC - HarperMo-USA-CC1 - Please contact Loway for a renewal. at it.loway.tpf.transaction.servlets.common.ServletEnvironment.init(ServletEnvironment.java:96) at it.loway.tpf.transaction.servlets.LowayTransactionController.init(LowayTransactionController.java:82) at javax.servlet.GenericServlet.init(GenericServlet.java:212) at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173) at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:809) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:129) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) -- End Inner Exception -- "


Thanks

6
If i'm not mistaken, queuemetrics played nice in the past with chkconfig startup scripts

To my chargin, this is sadly not the case any longer

Now, chkscripts are not supported for fedora and when putting "service queuemetrics start" in rc.local, it gives a spotty unpredictable record of actually starting.


The effected client have started grumbling and have expressed their displeasure at having to call us when QM fails to start at boot.



Now the question is:

How to whip this behavior into how it was before, in terms of an actual working startup script, or at least get it starting at boot with a hacky work around?


Any help would be appreciated

Thanks

7
Running QueueMetrics / List of agents and queue assignments ?
« on: February 11, 2012, 01:49:11 »
Is there any way to get a simple list of agents and which queues they are in?


Unfortunately, the "cfg agents" page does not include queues in the columns for each agent. If It did, I could cut and paste the list.

Without agents/queues being cross referenced in any screen, I'm looking at thousands of clicks. That makes me sad.


Is there any way to export a list? I've checked google but was unsuccessful.

Thanks

8
Adding a new partition number to queloader.conf and restarting the service most certainly does not work.


Why isn't there any documentation on the QM homepage or forums regarding this issue?

The directions page:

http://queuemetrics.com/manuals/QM_MySQL_Cluster-chunked/ar01s02.html


Makes no mention of other steps, but simply updating qloader.conf and restarting the services as it directs has no impact.

9
So the current partition is borked, I ran a mysql repair to no avail.

Now it wont set a new partition.


1) I followed the directions as always, adding a new partition number to queloader on the asterisk server.

2) Restarted  qloader, verified that a new partition had been created on the QM server. And accepted data

3) In QM on the license section, it still shows the old partition. Wont show data.

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

11
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?

12
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>";
}
?>


13


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

14
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



15

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?


Pages: [1] 2