similar to: Queue log in MySQL DB

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

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

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

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

On 12/04/2018 07:07 PM, Antony Stone wrote: > On Tuesday 04 December 2018 at 16:11:39, hw wrote: > >> On 12/01/2018 05:30 PM, Marcelo Terres wrote: >>> Queue_log >> >> Thanks! >> >> That's not really it; however, how do I make it so that asterisk writes >> this information right away into a mariadb database instead of into a >> file so

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, I have 5 Asterisk servers all using mysql realtime to store queue log information. There is 1 out of 5 servers which stores the data in 4 columns : 'data1' --> 'data 5'. All other servers store data in 1 column 'data' with the data seperated by pipe. I see no difference in my configuration of extconfig.conf and logger.conf. Maybe a hidden default value ?

Hello, Is it possible to use the switch => statement in extensions.conf (http://www.voip-info.org/wiki/view/Asterisk+RealTime+Extensions) to point to a database and in the database use the include-statement ? In extconfig.conf I would have : extensions => mysql,asterisk,extensions_table In extensions.conf I would then have : [includecontext] switch => Realtime/includecontext at

Hello I did not mention it but of course the MOH directory is listed in /etc/asterisk/musiconhold.conf : [default] mode=files directory=/var/lib/asterisk/moh [myfolder_1] mode=files directory=/var/lib/asterisk/moh/myfolder/1 sort=alpha [myfolder_2] mode=files directory=/var/lib/asterisk/moh/myfolder/2 sort=alpha [myfolder_3] mode=files directory=/var/lib/asterisk/moh/myfolder/3 sort=alpha

Hello using Asterisk 1.8.32.3 Current music on hold : myserver*CLI> moh show files Class: default File: /var/lib/asterisk/moh/macroform-robot_dity File: /var/lib/asterisk/moh/macroform-cold_day File: /var/lib/asterisk/moh/reno_project-system File: /var/lib/asterisk/moh/manolo_camp-morning_coffee File: /var/lib/asterisk/moh/macroform-the_simplicity New musiconhold

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

I have followed the instructions on voip-info.org for Realtime SIP peers, but I get this notice : [Feb 22 20:05:32] NOTICE[15298]: chan_sip.c:15889 handle_request_register: Registration from '<sip:testsip at 192.168.1.150;transport=UDP>' failed for '192.168.1.105' - No matching peer found The CLI shows : [Feb 22 19:58:23] == Parsing

On 12/05/2018 01:19 PM, Antony Stone wrote: > On Wednesday 05 December 2018 at 13:04:57, hw wrote: > >> On 12/04/2018 07:07 PM, Antony Stone wrote: >>> On Tuesday 04 December 2018 at 16:11:39, hw wrote: >>>> On 12/01/2018 05:30 PM, Marcelo Terres wrote: >>>>> Queue_log >>>> >>>> Thanks! >>>> >>>>

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

Hello, Is there a way to either store login/logout agent information in a database or at least send an email when an agent logs in or out of a queue? Thanks, Michael -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110812/84130e1a/attachment.htm>

Hi Andrew, OK, (the simple fact that those machines are not connected to internet makes that i have to go to those machines and copy them on a usb-stick, so it causes some delay each time...) -------- Forwarded Message -------- Sorry - I meant extconfig.conf - not cdr_mysql.conf (my mistake). I use (and done for a long time) mySQL for realtime storage - and it's never let me down (touch

On 12/01/2018 05:30 PM, Marcelo Terres wrote: > Queue_log Thanks! That's not really it; however, how do I make it so that asterisk writes this information right away into a mariadb database instead of into a file so that I could actually use it?

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

Le 23/03/2017 ? 20:17, Jonas Kellens a ?crit : > Hello > > > is there any more information on how to reload/read musiconhold files ? CLI> module reload res_musiconhold -- Daniel > On 07-03-17 10:46, Jonas Kellens wrote: >> Hello >> >> I did not mention it but of course the MOH directory is listed in >> /etc/asterisk/musiconhold.conf : >> >>