On Thu, 2011-06-16 at 19:12 -0300, Henrique Fernandes wrote: > It is possible to log queue in mysql without turning on realtime > asterisk? > > Thanks! > > []'sf.rique > -- Hi
Yes, you can pick and choose which things you want to use your DB by defining them in your extconfig.conf so, in extconfig.conf you would need to add queue_log=>mysql,<your-db-name>,queue_log in res_config_mysql.conf (1.8) or res_mysql.conf (1.4,1.6) you would have to put in the connection details for your database If you are using 1.8 your table create statement would be CREATE TABLE `queue_log` ( `id` int(10) unsigned NOT NULL auto_increment, `time` char(26) 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(100) NOT NULL default '', `data1` VARCHAR(100), `data2` VARCHAR(100), `data3` VARCHAR(100), `data4` VARCHAR(100), `data5` VARCHAR(100), PRIMARY KEY (`id`) )ENGINE=InnoDB ; Ish -- Ishfaq Malik Software Developer PackNet Ltd Office: 0161 660 3062 -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
