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.


Messages - gap712

Pages: [1]
1
General Asterisk configuration / Re: Listening to recorded calls using QM
« on: May 09, 2011, 16:47:11 »
Hello.
 Yes, I am trying to listen to recorded calls.
 
 I run a report, selected a call and showed its details.
 
 In the pop up window I did not see any file.

Example Pop Up window
Detalle de llamada
 
ID llamada:    1304861204.215576
Fecha y Hora:    05/08 - 08:56:44
Queue:    contacto [contacto]
ID Llamante:    332
Administrada por:    agent/711
Duracion:    34 sec.
Tiempo de espera:    5 sec.
Posición Original    # 1
Causa de desconexion:    Llamante desconectado
Transferida a:     
Attempts:    1
Stints:    1
URL     
Código de estado:     
Srv     
DNIS     
IVR selection   

Asterisk:
[root@VEe01astCC1 monitor]# pwd
/var/spool/asterisk/monitor
[root@VEe01astCC1 monitor]# ls *.215576*
Q-contacto-20110508085644-332-1304861204.215576.WAV
[root@VEe01astCC1 monitor]#



2
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

3
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.

4
Running QueueMetrics / Re: Several Calls are showing Not Answer Yet
« on: December 10, 2010, 15:43:57 »
Hello
 I really think that I only have one qloaderd service running in my asterisk. I double checked it with ps –aux and only see one process.
root      7628 44.5  0.2  11612  4604 pts/1    RN   09:44   0:00 /usr/bin/perl /usr/local/qloader/qloader.pl -h …..

 Since tuesday I did not see more "unaswered yet" calls.  :)

In order to repair the data, I tried to do the queuepartialUpdater process. I´m not sure what I did wrong. Here what I did:
cd /usr/local/qloader
cp qloader.pl queuepartialUpdater.pl
service qloaderd stop
then to test it I run:
./queuepartialUpdater.pl /var/log/asterisk/queue_log P002 /var/log/asterisk/qlog1.log
I went to the web page and run a Custom Report using this partition and everything was fine.
Then I run the same command but using the partition P001 (the one I have by default) and another log (just in case)  and all the unanswered yet calls keep showing.
Any help you can give to me I really appreciate
(Besides of changing the default partition) ;D


5
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)

6
MySQL storage and Qloaderd/Uniloader / Re: Problema DB: java.sql.SQLException: Can't find file: 'dbversion' (errno: 2)
« on: June 10, 2010, 18:11:05 »
Solved

 It was disk space...

 Thanks...

7
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

8
Running QueueMetrics / Re: Problems with Asterisk 1.6 in the Realtime Call Center monitoring
« on: January 19, 2010, 20:32:13 »
Hi

 Now my problem is different. If an agent answers the call, it is show in the Realtime Monitoring, and I can see that agent busy for a call. But, the time the call is waiting for an agent or if it is not answered, I can not see the call.

 Also the time that is show in the realtime monitoring, when a call is answered, is 30 minutes lower than the time from the asterisk and the queuemetrics (then QM shows like the call has more than 30 minutes waiting). But when i watch the reports the times are fine.
 
 There is no diference in time between QM and asterisk. All the calls answered and unaswered are fine in the reports.

 These are some logs from the queue, now it is call contacto. The first log (ID 1263925517.28) is an aswered call, the other two are abandon calls.
1263926236|CLI|contacto|SIP/355|ADDMEMBER|
1263926241|1263925517.28|contacto|SIP/355|CONNECT|720|1263926237.30
1263926620|1263925517.28|contacto|SIP/355|COMPLETEAGENT|720|379|1
1263926620|1263925517.28|contacto|NONE|EXITHANGUP|
1263926668|1263926664.31|contacto|NONE|ENTERQUEUE||354
1263926671|1263926664.31|contacto|SIP/355|RINGNOANSWER|3000
1263926676|1263926664.31|contacto|NONE|ABANDON|1|1|8
1263926676|1263926664.31|contacto|NONE|EXITHANGUP|
1263927283|CLI|contacto|SIP/355|REMOVEMEMBER|
1263927291|1263927287.33|contacto|NONE|ENTERQUEUE||354
1263927360|1263927287.33|contacto|NONE|ABANDON|1|1|69
1263927360|1263927287.33|contacto|NONE|EXITHANGUP|

Thanks



9
Running QueueMetrics / Re: Problems with Asterisk 1.6 in the Realtime Call Center monitoring
« on: December 23, 2009, 19:32:45 »
Yes they are   ???

What else can I check?

10
Running QueueMetrics / Re: Problems with Asterisk 1.6 in the Realtime Call Center monitoring
« on: December 21, 2009, 22:04:06 »
Hi
 
 I did what you said and i still can't see the calls.

 I can see the calls in the reports, It does not show only in the realtime monitoring

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