Sorry, to not answer before!<br><br>Thanks a lot, as sun as i am able i will test this setup!<br><br clear="all">[]'sf.rique <br>
<br><br><div class="gmail_quote">On Fri, Jun 17, 2011 at 4:50 AM, Ishfaq Malik <span dir="ltr"><<a href="mailto:ish@pack-net.co.uk">ish@pack-net.co.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div></div><div class="h5">On Thu, 2011-06-16 at 19:12 -0300, Henrique Fernandes wrote:<br>
> It is possible to log queue in mysql without turning on realtime<br>
> asterisk?<br>
><br>
> Thanks!<br>
><br>
> []'sf.rique<br>
</div></div>> --<br>
Hi<br>
<br>
Yes, you can pick and choose which things you want to use your DB by<br>
defining them in your extconfig.conf<br>
<br>
so, in extconfig.conf you would need to add<br>
queue_log=>mysql,<your-db-name>,queue_log<br>
<br>
in res_config_mysql.conf (1.8) or res_mysql.conf (1.4,1.6)<br>
you would have to put in the connection details for your database<br>
<br>
If you are using 1.8 your table create statement would be<br>
CREATE TABLE `queue_log` (<br>
`id` int(10) unsigned NOT NULL auto_increment,<br>
`time` char(26) default NULL,<br>
`callid` varchar(32) NOT NULL default '',<br>
`queuename` varchar(32) NOT NULL default '',<br>
`agent` varchar(32) NOT NULL default '',<br>
`event` varchar(32) NOT NULL default '',<br>
`data` varchar(100) NOT NULL default '',<br>
`data1` VARCHAR(100),<br>
`data2` VARCHAR(100),<br>
`data3` VARCHAR(100),<br>
`data4` VARCHAR(100),<br>
`data5` VARCHAR(100),<br>
PRIMARY KEY (`id`)<br>
)ENGINE=InnoDB ;<br>
<br>
Ish<br>
<br>
--<br>
Ishfaq Malik<br>
Software Developer<br>
PackNet Ltd<br>
<br>
Office: 0161 660 3062<br>
<br>
<br>
--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
</blockquote></div><br>