Here's the table structure 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) default NULL, `data2` varchar(100) default NULL, `data3` varchar(100) default NULL, `data4` varchar(100) default NULL, `data5` varchar(100) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB
in your extconfig.conf you need a line along the lines of queue_log=>mysql,<db-name>,queue_log you will also need an entry in your res_config_mysql.conf along the lines of [<db-name>] dbhost = <location of db> dbname = <db-name> dbuser = <db-user> dbpass = <db-pass> dbport = 3306 All the above are for asterisk 1.8 Regards Ish On Thu, 2011-09-08 at 09:20 +0500, Sam Govind wrote: > you definitely need to create the file extconfig - take sample from > internet. the DB tables need to be created on your own, take help from > internet pages. > > On Wed, Sep 7, 2011 at 6:19 PM, Michael <voip.quest...@gmail.com> > wrote: > I couldn't find the extconfig.conf file in /etc/asterisk and > queue_log doesn't exist either (as a file or as a db table). > We're using AsteriskNOW, so maybe these files/tables were not > created. > > How should we add them? > > Thanks. > > On Wed, Sep 7, 2011 at 8:54 AM, Sam Govind > <govoi...@gmail.com> wrote: > > See this link: > http://www.voip-info.org/wiki/view/Asterisk+queue_log > +on+MySQL > > > You'll find similar pages where you can setup to store > queue logs/events(as Alex mentioned) in MySQL DB and > further do your triggers or functions on them. > > -- > _____________________________________________________________________ > -- 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 > > -- > _____________________________________________________________________ > -- 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 -- 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