Am Donnerstag, 21. Januar 2016, 09:52:53 schrieben Sie: > > From: Thomas <thomasit...@gmail.com> > > To: asterisk-users@lists.digium.com, > > Date: 01/21/2016 04:17 AM > > Subject: [asterisk-users] Queue logfile txt format in mySQL needed > > Sent by: asterisk-users-boun...@lists.digium.com > >
> > database instead of using var/log/asterisk/queue_log? > > I haven't done this myself, but it looks like you just need to set up the > appropriate database connections. See here for a semi-recent example: > http://stackoverflow.com/questions/30161384/asterisk-11-queue-log-to-mysql Hi, thanks... in /etc/asterisk/res_config_mysql.c for example define in [mydatabase] acsess to your database in /etc/asterisk/extconfig.conf queue_log => mysql,mydatabase,queue_log CREATE TABLE IF NOT EXISTS `queue_log` ( `id` int(10) unsigned NOT NULL auto_increment, `time` varchar(40) default NULL, `callid` varchar(80) NOT NULL default '', `queuename` varchar(80) NOT NULL default '', `agent` varchar(80) NOT NULL default '', `event` varchar(32) NOT NULL default '', `data` varchar(255) NOT NULL default '', `data1` varchar(255) NOT NULL default '', `data2` varchar(255) NOT NULL default '', `data3` varchar(255) NOT NULL default '', `data4` varchar(255) NOT NULL default '', `data5` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ); after make an reload of asterisk info will be written in this table and not any more in the txt file.... I found some explantion for the data written in the fields: https://wiki.asterisk.org/wiki/display/AST/Queue+Logs -- _____________________________________________________________________ -- 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
