similar to: asterisk 1.8 realtime queue_log

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

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

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

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

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

Hi, 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! 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

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.

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 list. We just upgraded to 1.6.1.11. We are using real time information stored on mysql databases. That is all running fine. Now, since we upgraded, some member don't get calls from queues. In CLI: "queue show" shows something like: 611 (Local/611 at agents) with penalty 20 (realtime) (*In use*) has taken no calls yet We use the extension 611 in different computers, in the

hi, is it possible log cel/queue_log to sqlite? via odbc? any experience? marek

Hi to all. I make some tests with Asterisk 1.8.2 in Realtime. But i have one problem, the asterisk don't connect in the base and show this message: [Feb 17 11:18:01] WARNING[19061]: res_config_mysql.c:441 realtime_multi_mysql: MySQL RealTime: Invalid database specified: 'asterisk_teste' (check res_mysql.conf) I checked the asterisk config file (res_mysql.conf) and the configuration

I am trying to find where the authoritative sql definitions for Asterisk Realtime Architecture ARA are located. I have found many locations but each and everyone seems to be different. http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html/asterisk-book.html http://www.open-voip.org/index.php?title=Asterisk_Full_RealTime_example Files included with the distribution:

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, I'm looking for a way to have the estimated hold time on a queue prior to joining it. someone suggested to me to Queue() first for 1 sec, read variable QUEUEHOLDTIME, validade it and Queue() again. But as we're using real time configuration that would mean a event ENTERQUEUE and a LEAVEQUEUE too much in MySQL's queue_log any suggestions?? Thanks in advance

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

Hi, I am running a call center based on Asterisk and building some statistics based on the queue_log file. I have some doubts about it that maybe you could help (actually, maybe these doubts are suggestions for enhancements!): 1st Scenario - Agent receives the call, and puts it on parking for somebody else to pick it up. Parking # 7000 (for attender transfer)

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>

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