Summary: | ASTERISK-11103: Store queue_log in RT | ||
Reporter: | Sergey Tamkovich (sergee) | Labels: | |
Date Opened: | 2007-12-22 15:28:36.000-0600 | Date Closed: | 2007-12-26 09:54:52.000-0600 |
Priority: | Major | Regression? | No |
Status: | Closed/Complete | Components: | 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 |