similar to: queue_log/cel sqlite

On Thu, Oct 20, 2016 at 4:50 AM, marek cervenka <cervajs2 at gmail.com> wrote: > i tested this > > # cat /etc/asterisk/extconfig.conf > [settings] > queue_log => sqlite3,cdrDb > > # cat /etc/asterisk/res_config_sqlite3.conf > [cdrDb] > dbfile = /var/lib/asterisk/realtime.sqlite3 > > sqlite3 /var/lib/asterisk/realtime.sqlite3 > > CREATE TABLE

Hi, I am using RT engine to log queue_log to a mysql database. My extconfig is [settings] queue_log => mysql,asterisk16_production Logging to mysql is working fine. But I find that the queue_log file now only has QUEUESTART lines for eg: 1250519094|NONE|NONE|NONE|QUEUESTART| 1250519186|NONE|NONE|NONE|QUEUESTART| How can I have queue_log in both db as well as in a file? thanks and

Hello Team, Can you help me on this? I have attached here the queue logs of my asterisk. I've searching a parser for this. I do not know what are the meaning of that logs. Thank you so much. Your response is highly appreciated. Regards, Cristina -------------- next part -------------- An HTML attachment was scrubbed... URL:

I'm in search of useful ACD type statistics from the queues. Ie talk time, ratio's, dropped calls etc. The flat file queue_log is nice, but more useful would be the data in Postgres or Mysql. Unfortunately the queue module does not yet support ODBC DB logging (yet). In the meantime this quick and dirty hack gets the job done. Replace the flat file with a unix named pipe.

Hello! I'm trying to registers events of queues in /var/log/asterisk/queue_log and Mysql database .I have configured realtime queue_log on MySQL and works well, but /var/log/asterisk/queue_log file is empty, since you're not registering events of queues. Removing extconfig.conf configurations (queue_log => mysql,general), /var/log/asterisk/queue_log works well, events logs on

Hello, can /var/log/messages/queue_log be saved in a MySQL database ?? So it would be easier to work with... Kind regards, Jonas. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110113/87d9ef53/attachment.htm>

Hi, Anyone knows if TRANSFER event on queue_log is still working on 1.6.0.6. I make an attended transfer (asterisk feature), and I cant see the event. Any idea? Should I submit a bug report? -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090313/eb5a7ea0/attachment.htm

What third party programs are available for parsing the queue_log file and CDR file? I know about XC-AST, but management would prefer a php based solution. What have other admins done to retrieve detailed call information about the queue system? Anyone develop their own that they don't mind sharing? --johann

Hi, I am trying to log queue_log to odbc (MS SQL) I have res_odbc.conf configured and modules.conf have preload => res_odbc.so preload => res_config_odbc.so extconfig.conf has queue_log => odbc,asterisk. When I start asterisk I get the following messages. The important one being: Realtime mapping for 'queue_log' found to engine 'odbc', but the engine is not available

Anyone know how to get app_queue to send logs to MySQL or any other sql server. I found info for cdr's and even configs but nothing on queue_log. If sql is not supported in the current app_queue I will be willing to pay someone to add it. John Bittner Simlab.net

Hi list, I hope someone could help me. I've started using Asterisk 1.6.0.14 to get queue logs in real time with odbc (our databases are all PostgreSQL) but it's not working. However, cdr odbc is working well. When asterisk starts next message appears: WARNING[4217] config.c: Realtime mapping for 'queue_log' found to engine 'odbc', but the engine is not available My

Hello list, as I'm writing a little perl parser for queue_log analysis, I'd like to know *which* telephone answered a specific queue call. Unfortunately app_queue only logs the call id but does not log the call end point. This is okay for SIP endpoints, because their call id is something like SIP/endpointname-1234 so you can reasonably understand who was on answering, but for

Hi, How do I read (make sense of) the timestamp in the queue_log? I'm probably just slow but I don't understand it. Thanks! Regards, Jan

Hello List, Question: Has anyone been able to create multiple queue_log files in /var/log/asterisk for multiple queues? We are designing a multi-tenant system and separating the log files would be useful, instead of dropping all queue actions into one file. Is it possible this is a user configurable option I am missing? Cheers, -- ------ Christopher T Aloi ------

Hi, Watching my queue_log file content, I can read entries like : 1349940957|1349940957.4|6025|Local/6455 at from-queue/n|ADDMEMBER| My extensions.conf file used this statement: exten => *9876,n,AddQueueMember(6025,Local/6455 at from-queue /n,10,,FOOBAR,hint:6455 at ext-local) I was expecting to see: 1349940957|1349940957.4|6025|FOOBAR|ADDMEMBER| Searching the web, I found a reference to

Hi Guys! We were using queuemetrics since long time with asterisk 1.2 but recently we have install 1.8 asterisk and but there is a big different in queue_log its saying SIP/XXXX instead of Agent/XXXX that is obvious behaviors. so do i need to change Agent/XXXX to SIP/XXXX in queuemetrics ? or is there any workaround to keep business running same like it was before. -S --------------

I went to run my queue_log parser so that I could send out a monthly report to one of my customers, and I noticed that every valid call complete action (COMPLETEAGENT, COMPLETECALLER) is followed by an ABANDON: Here is a complete-caller: 1123325015|1123325011.2|mainq|NONE|ENTERQUEUE||00110102102 1123325020|1123325011.2|mainq|Agent/21|CONNECT|5

I'm using asterisk blind/attended transfer feature on a queue (also tried with sip phones feature), and both type of transfers work fine. The problem is that attended trasfers doesn't get logged to queue_log, but blind transfers are logged just fine. Anyone knows if this is the correct behavior? -- Regards, Miguel Paolino -------------- next part -------------- An HTML attachment was

Hello, Iam using queues and agents, thats OK. I have interesting information form Asterisk in txt file format var/log/asterisk/queue_log Today Iam reading these txt files and wrote them in an mySQL databases. I would need this information more realtime. Some information I do writing in the dialplan direct in an mySQL database. Is there any way that Asterisk write this information direct in

Skipped content of type multipart/alternative-------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: image/gif Size: 2151 bytes Desc: not available Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20060505/1729faf8/attachment.gif