asterisk users - Jun 2011 - Queue Log in Mysql

It is possible to log queue in mysql without turning on realtime asterisk?

Thanks!

[]'sf.rique
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20110616/6e31dcf5/attachment.htm>

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