Sorry, to not answer before! Thanks a lot, as sun as i am able i will test this setup!
[]'sf.rique On Fri, Jun 17, 2011 at 4:50 AM, Ishfaq Malik <[email protected]> wrote: > 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 >
-- _____________________________________________________________________ -- 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
