Summary:ASTERISK-02535: [patch] mysql log of queue_log
Reporter:anaymon (anaymon)Labels:
Date Opened:2004-10-05 12:53:10Date Closed:2011-06-07 14:05:09
Versions:Frequency of
Environment:Attachments:( 0) asterisk-queue_log_on_mysql-queuelogpatch.0.1.patch
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!


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

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.


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?



By: Brian West (bkw918) 2004-10-06 15:48:09

checkout the latest dev branch... look at app_realtime.


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.


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


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.


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.


By: Russell Bryant (russell) 2004-11-14 21:44:00.000-0600

The author seems to have lost interest in this patch.