[asterisk-users] Queue Log in Mysql

[Ishfaq Malik]

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