Good afternoon list.
I am facing a problem with the CDR and Queue_log tables (MySQL). The ABANDON
events is being saved correctly in queue_log, but in the table CDR is not
saving the registry of such abandoned calls.
Apparently the CDR table is functioning normally, I have several records of
links in it. From what I noticed, is only the events abandonment that are
malfunctioning.
With this SELECT [1] I can pick up the records on other servers without
problems. With this another SELECT [2], I get the events Abaddon normally. With
this other [3] I can get all the channels that joined the queue with no
problems.
Both tables are recording normally and Asterisk has no errors in the logs. Only
happens with the event Abandon.
[1] SELECT from_unixtime(ql.time),ql.callid,ql.event FROM cdr c,queue_log ql
WHERE c.uniqueid = ql.callid AND ql.event = 'ABANDON';
[2] SELECT * FROM queue_log WHERE event = 'ABANDON';
[3] SELECT from_unixtime(ql.time),ql.callid,ql.event FROM cdr c,queue_log ql
WHERE c.uniqueid = ql.callid AND ql.event = 'ENTERQUEUE';
Thanks in advanced,
--
Rodrigo Lang
Opening your mind - Just another Open Source
site<http://openingyourmind.wordpress.com/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20101201/2abd0dc7/attachment.htm
