[asterisk-users] Queue Log in Mysql

Henrique Fernandes sf.rique at gmail.com
Mon Jun 20 16:25:24 CDT 2011


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 <ish at pack-net.co.uk> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110620/0379127a/attachment.htm>


More information about the asterisk-users mailing list