similar to: Queue logfile txt format in mySQL needed

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>

On 12/05/2018 05:00 PM, Antony Stone wrote: > On Wednesday 05 December 2018 at 15:31:38, hw wrote: >> I don't see a table for that. > > You need to create that for yourself. > > Asterisk can write to database tables, but doesn't help you set them up, for > reasons I can't comment on. How do I know what the schema needs to be? Does anybody have a scheme for

Hello, Iam lookong for an Softphone for iPhor oder Android smartphone using togehter with an headset. I tried Zoiper and CSipSimple but quality was bad compared to an desktop SIP phone. Is there an better softphone? Or are there softphone solutions for PC desktop MAC or Android with an headset? I want to save cost for desktop phones. thanks Thomas

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

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

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

Thirdlane Connect can be used as a softphone. It works in modern browsers (no installation is required), on Mac, Windows and Linux desktops, and on mobile phones. Besides basic softphone functionality, it provides instant messaging, group chat (channels), voice and video conferencing, and screen sharing. It integrates with a variety of applications and CRMs such as Salesforce, Zoho, Zendesk,

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

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

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, is it possible to have the information stored in /var/log/asterisk/queue_log realtime in mySQL? thanks

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

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

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.

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