Summary:	ASTERISK-02535: [patch] mysql log of queue_log
Reporter:	anaymon (anaymon)	Labels:
Date Opened:	2004-10-05 12:53:10	Date Closed:	2011-06-07 14:05:09
Priority:	Major	Regression?	No
Status:	Closed/Complete	Components:	Applications/app_queue
Versions:		Frequency of Occurrence
Related Issues:
Environment:		Attachments:	( 0) asterisk-queue_log_on_mysql-queuelogpatch.0.1.patch
Description:	Hi, I wanted to use queue_log to have reports of the activity of some callcenters I'm taking care of but I also wanted to work on a database instead of a text file. All this patch does is to store each row divided by fields on a mysql server. As the number of fields is not constant I use three fields extra1,...,extra3 to store the extra information. Maybe the mysql library could be used to store also other logs on a database... Tested for  2 days on call center. This is my first patch so any comment is welcome! ****** ADDITIONAL INFORMATION ****** Create the following table: # # Table structure for table `queue_log` # CREATE TABLE `queue_log` (  `time` datetime default NULL,  `callid` varchar(32) default NULL,  `queuename` varchar(32) default NULL,  `agent` varchar(32) default NULL,  `event` varchar(32) default NULL,  `extra1` varchar(32) default NULL,  `extra2` varchar(32) default NULL,  `extra3` varchar(32) default NULL ) TYPE=MyISAM; and then add information about your mysql server and database in logger.conf dbpass = secret dbuser = asterisk dbhost = localhost dbname = logger
Comments:	By: Brian West (bkw918) 2004-10-06 09:43:55 Please checkout the new realtime stuff and see if you can adapt this into that framework. Thanks, Brian By: anaymon (anaymon) 2004-10-06 14:43:37 Thank you for the reply. Where should I start? I don't know exactly what you mean with realtime stuff. Can you explain better? Thanks, Dimitri By: Brian West (bkw918) 2004-10-06 15:48:09 checkout the latest dev branch... look at app_realtime. bkw By: anaymon (anaymon) 2004-10-07 03:33:22 so you suggest to move the code away from logger.c and retrieve the parameters I need through ast_load_realtime. Am I right? I've seen that function and ast_update_realtime used in chan_iax2 but I think I can't retrieve anything about queues or agents. It would be great anyway to get information about queues and agents directly from extensions.conf using app_realtime before to launch app_queue. dimitri By: Brian West (bkw918) 2004-10-14 01:11:32 Ok I would like to see: 1. Dynamic Queues 2. Queues from realtime 3. Agents from realtime bkw By: twisted (twisted) 2004-10-27 17:11:51 I like this idea, realtime or not.  I would push towards it being realtime friendly, but it's a good idea, none the less. Update? By: Brian West (bkw918) 2004-11-08 09:28:33.000-0600 well this patch will never go in because its uses mysql.  It would have to use realtime to have any chance of going in. bkw By: Russell Bryant (russell) 2004-11-14 21:44:00.000-0600 The author seems to have lost interest in this patch.