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 - gap712

Pages: [1]
1
General Asterisk configuration / Listening to recorded calls using QM
« on: May 03, 2011, 22:49:25 »
Hello

 
I can see any calls when I try to listen the answered calls.

My configuration:

QM and Asterisk in different box .

Asterisk
.
exten => s,n,Set(calltime=${STRFTIME(${EPOCH},,%C%y%m%d%H%M%S)})
exten => s,n,MixMonitor(/var/spool/asterisk/monitor/Q-${COLAS}-${calltime}-${CALLERID(num)}-${UNIQUEID}.wav49,b)
exten => s,n,Set(MONITOR_FILENAME=/var/spool/asterisk/monitor/Q-${COLAS}-${calltime}-${CALLERID(num)}-${UNIQUEID})
.

[root@VEe01astCC1 monitor]# pwd
/var/spool/asterisk/monitor
[root@VEe01astCC1 monitor]# ls
Q--20110503142918-332-1304449158.185348.WAV          Q-contacto-20110503153528-332-1304453128.185982.WAV  Q-q-777-20100806154502-716-1281125702.361.WAV
Q--20110503143108-332-1304449268.185364.WAV          Q-contacto-20110503153632-332-1304453192.185986.WAV  Q-q-777-20100806154941-716-1281125981.368.WAV


Queuemetrics

configuration.properties
#The top level directory where monitored calls are held.
#Do NOT forget to add the ending slash.
default.monitored_calls=/var/spool/asterisk/monitor/

When I do the debug i don´t see any files

Show filesystem
This page is a helper to trace the content of available directories under the "default.monitored_calls" parameter.

User has the CALLMONITOR key? true
Search path: /var/spool/asterisk/monitor/


.gsm files

.wav files

.WAV files

What am I missing here?
Thanks

2
Running QueueMetrics / "Errore tecnico nella classe 'it.loway.app.queuemetrics.autenticazion
« on: December 10, 2010, 17:31:16 »
Hello

 In my other server running Queuemetrics i got this error since yesterday.

"Errore tecnico nella classe 'it.loway.app.queuemetrics.autenticazione.caricaDatiIniziali'. -- Inner Exception -- - Exception: it.loway.tpf.common.exceptions.TechException - Stack trace: - Problema DB: - java.sql.SQLException:   '/tmp/#sqla36_1e70c_0.frm' (Errcode: 28) - at it.loway.tpf.SQL.execSql(Unknown Source) - at it.loway.app.queuemetrics.FA.makeSqlUnionLt(FA.java:964) - at it.loway.app.queuemetrics.autenticazione.caricaDatiIniziali.doRun(caricaDatiIniziali.java:177) - 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 Inner Exception -- - " 
System time when the error occurred: 2010-12-10.08:53:05 

I reboot the server, no solution. Then I upgrade to 1.6.2.1-64 version of queuemetrics. When I was doing the JDBC connection test i got this error "Checking database revision - required version:20 Error Java Error: DB revision error: was 19 - required 20 " I follow the process and I got other error
1.6.0.3   Creating index 'by_hotdesking'   Err

and every time i tried to run queuemetrics it goes to the  dbtest page, getting the same result.
 Then i updated the mysql server and it did not work..
Please help.

3
Running QueueMetrics / Several Calls are showing Not Answer Yet
« on: December 06, 2010, 17:10:23 »

Hello
Since I upgraded to QueueMetrics - 1.6.2.1, several calls  (like 35%) are showing Not Answer Yet.
I see the same call in the answered detail  and the unanswered detail pages, but in the answered page the call is followed by an “asterisk (*)”  call assigned to the same agent, same duration, hour, etc.

Example:
Answered Detail

12/01 - 14:28:07    ficha 4596 611341   ea    0:01      0:11      1   Llamante    Carlos Nunes    2       1               
12/01 - 14:28:07    *   ea    0:01      0:11      1   Llamante    Carlos Nunes    0       1               

Unanswered Detail
12/01 - 14:28:07       ficha 4596 611341   ea    No contestado aun     0   0:00      0   0           1               
                                             

Thanks for your suggestions
(Asterisk 1.6.2.6 in different server, running qloaderd. MySql and queuemetrics in the same box)

4
MySQL storage and Qloaderd/Uniloader / Problema DB: java.sql.SQLException: Can't find file: 'dbversion' (errno: 2)
« on: June 10, 2010, 17:21:33 »
Hello

 I got a Queuemetrics servcer, version 1.5.3 running in a diferent server than the asterisk bok (1.4)
It was running fine since a year ago.

 Yesterday I got this error:

"Errore tecnico nella classe 'it.loway.app.queuemetrics.autenticazione.start'. -- Inner Exception -- - Exception: it.loway.tpf.common.exceptions.TechException - Stack trace: - Problema DB: java.sql.SQLException: Can't find file: 'dbversion' (errno: 2) - at it.loway.tpf.SQL.selectScalare(Unknown Source) - at it.loway.app.queuemetrics.autenticazione.start.doRun(start.java:47) - 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 Inner Exception -- - "


When I try to make a backup I got this error.

[root@qmetrics usr]# mysqldump -u root -p queuemetrics > /root/Desktop/queuemetricsrespaldo.sql
Enter password:
mysqldump: Got error: 1017: Can't find file: 'dbversion' (errno: 2) when using LOCK TABLES
[root@qmetrics usr]#

 Any help?

Thanks

5
Running QueueMetrics / Problems with Asterisk 1.6 in the Realtime Call Center monitoring
« on: December 17, 2009, 15:47:57 »
Hi

 I am running Asterisk 1.6.1.9 and Queuemetrics 1.5.3. They were instaled in two separates servers,
and I am using qloader.


 I have a problem with Realtime Call center. The agents part is working fine. I can see when they login and logout,and the pause status and codes. But i can't see any calls witch are procesed by the queue.

 In the reports I can see all the calls answered and unaswered.


 Same configurations works fine with Asterisk 1.4.X and Queuemetrics 1.5.3.


This is what i get from the asterisk console

VEe01astCC1*CLI> queue show VEcc
VEcc         has 1 calls (max unlimited) in 'rrmemory' strategy (45s holdtime), W:0, C:9, A:25, SL:100.0% within 86400s
   Members:
      SIP/001 (Unavailable) has taken no calls yet
   Callers:
      1. SIP/711-b7d3d8b0 (wait: 3:09, prio: 0)

VEe01astCC1*CLI>



This is the same call in /var/log/asterisk/queue_log

1261057337|1261057337.329|VEcc|NONE|ENTERQUEUE||711
1261057560|1261057337.329|VEcc|NONE|ABANDON|1|1|223


The part from the extensions.conf when the queue is calling

exten => s,1,Queue(${COLA1})
exten => s,n,System( echo "${EPOCH}|${UNIQUEID}|${COLA1}|NONE|EXITCODE|${QUEUESTATUS}" >> /var/log/asterisk/queue_log )

Could you please give any ideas to solve this situation. :-[

 Thanks

Pages: [1]