similar to: Compile logger-mysql.c with UNDEFINED REF to `mysql_error'

Hello list, I've got a client who's weak sip passwords are being guessed by remote entities who then connect to their server and use it to wardial large swaths of numbers. When they start receiving complaints, they call me and I add the ip address of the remote user to the iptables drop list. At the same time, my own personal asterisk server, using strong sip passwords, has seen

Hi, Since yesterday my Asterisk 1.2.3 is displaying the following message every few seconds >Asterisk Event Logger restarted >Rotated Logs Per SIGXFSZ (Exceeded file size limit) This causes my log files (verbose, queue_log) to become huge with lots of logger rotate messages, but I don't know which files is exceeding size limit, since even if I delete all log files I still get this

Hi guys, I have noticed that 'logger rotate' command only rotates log files in the /var/log/asterisk directory, but not in the subdirectories. How could I rotate my /var/log/asterisk/cdr-custom/Master.csv log file? Regards, Alex -------------- next part -------------- An HTML attachment was scrubbed... URL:

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 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, 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, is it possible log cel/queue_log to sqlite? via odbc? any experience? marek

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

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

Hi, is it possible to have the information stored in /var/log/asterisk/queue_log realtime in mySQL? thanks

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

Hi, Surely, I must be overlooking something. If I run the following SQL queries I don't get the same number of rows. Is this coherent? mysql> select * from queue_log where queuename = '4010' and FROM_UNIXTIME(time) between 20080308000000 and 20080313145900 group by callid; 357 rows in set (0.01 sec) mysql> select * from cdr where dst = 4010 and calldate between 20080308000000

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

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

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

I know in v1.6 its part of logger.c but I noticed this: https://issues.asterisk.org/bug_view_advanced_page.php?bug_id=11625 However, it doesn't seem to ever been applied to any version of 1.4.x branch.. Nor can I figure out what it was applied to? This is over 3 years old, you would of figured it would have been applied to 1.4 at some point in time.. Any ideas?

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