[Home]

Summary:ASTERISK-11103: Store queue_log in RT
Reporter:Sergey Tamkovich (sergee)Labels:
Date Opened:2007-12-22 15:28:36.000-0600Date Closed:2007-12-26 09:54:52.000-0600
Priority:MajorRegression?No
Status:Closed/CompleteComponents:Applications/app_queue
Versions:Frequency of
Occurrence
Related
Issues:
Environment:Attachments:( 0) queuelog-rt-r94615.diff
Description:No more silly Perl scripts, store queue_log in your favorite RT engine directly.

****** ADDITIONAL INFORMATION ******

Sample queue_log table for MySQL:

CREATE TABLE `queue_log` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `time` int(10) unsigned default NULL,
 `callid` varchar(32) NOT NULL default '',
 `queuename` varchar(32) NOT NULL default '',
 `agent` varchar(32) NOT NULL default '',
 `event` varchar(32) NOT NULL default '',
 `data` varchar(255) NOT NULL default '',
 PRIMARY KEY  (`id`)
);


queue_log message consists of 2 parts: constant and variable. Constant part is splited among corresponding fields (time, callid, queuename, agent, event). Variable data is stored in `data` field as is, so you'll meet | there. Examples:

mysql> select * from queue_log;
+----+------------+--------------+-----------+-------+------------+-------+
| id | time       | callid       | queuename | agent | event      | data  |
+----+------------+--------------+-----------+-------+------------+-------+
|  1 | 1198356717 | 1198356717.0 | test      | NONE  | ENTERQUEUE | |serg |
|  2 | 1198356719 | 1198356717.0 | test      | NONE  | ABANDON    | 1|1|2 |
+----+------------+--------------+-----------+-------+------------+-------+

I hope that asterisk community would love this patch.
Comments:By: Sergey Tamkovich (sergee) 2007-12-22 15:31:42.000-0600

to activate RT logging add a line like

queue_log => mysql,asterisk

to your extconfig.conf

By: Digium Subversion (svnbot) 2007-12-26 09:54:52.000-0600

Repository: asterisk
Revision: 94782

U   trunk/CHANGES
U   trunk/configs/extconfig.conf.sample
U   trunk/main/logger.c

------------------------------------------------------------------------
r94782 | mmichelson | 2007-12-26 09:54:52 -0600 (Wed, 26 Dec 2007) | 7 lines

Adding support for storing the queue log entries in a realtime backend.

(closes issue ASTERISK-11103, reported and patched by sergee)

Thank you very much to sergee for adding this new feature!


------------------------------------------------------------------------

http://svn.digium.com/view/asterisk?view=rev&revision=94782