Re: [asterisk-users] RealTime Queue Logging in 1.8
Thanks for that, the table got created. Should be plain sailing from here on :) Ish On Tue, 2011-06-07 at 10:43 +0530, Satish Barot wrote: I use following for MySQL... CREATE TABLE queue_log( id int(11) NOT NULL auto_increment, time datetime not null, queuename VARCHAR(50), agent VARCHAR(50), callid varchar(32), event VARCHAR(100), data1 VARCHAR(100), data2 VARCHAR(100), data3 VARCHAR(100), data4 VARCHAR(100), data5 VARCHAR(100), PRIMARY KEY (id) ) ENGINE=InnoDB ; Check the link to know the meaning of data1,data2... for Events. http://www.voip-info.org/wiki/view/Asterisk+log+queue_log [SATISH] On Mon, Jun 6, 2011 at 1:49 PM, Ishfaq Malik i...@pack-net.co.uk wrote: On Thu, 2011-06-02 at 16:03 +0100, Ishfaq Malik wrote: Hi Does anyone know of an accurate resource I could refer to for this? The best I can find is http://www.voip-info.org/wiki/view/Asterisk+queue_log+on +MySQL And that table wont create in my database... Thanks Ish Can someone at least point me to the source file that I can analyse to find out the table requirements? 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 -- _ -- 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
Re: [asterisk-users] RealTime Queue Logging in 1.8
Realtime table queue_log@asterisk: Column time cannot be a datetime Works fine once the time column is turned to char... On Tue, 2011-06-07 at 10:43 +0530, Satish Barot wrote: I use following for MySQL... CREATE TABLE queue_log( id int(11) NOT NULL auto_increment, time datetime not null, queuename VARCHAR(50), agent VARCHAR(50), callid varchar(32), event VARCHAR(100), data1 VARCHAR(100), data2 VARCHAR(100), data3 VARCHAR(100), data4 VARCHAR(100), data5 VARCHAR(100), PRIMARY KEY (id) ) ENGINE=InnoDB ; Check the link to know the meaning of data1,data2... for Events. http://www.voip-info.org/wiki/view/Asterisk+log+queue_log [SATISH] On Mon, Jun 6, 2011 at 1:49 PM, Ishfaq Malik i...@pack-net.co.uk wrote: On Thu, 2011-06-02 at 16:03 +0100, Ishfaq Malik wrote: Hi Does anyone know of an accurate resource I could refer to for this? The best I can find is http://www.voip-info.org/wiki/view/Asterisk+queue_log+on +MySQL And that table wont create in my database... Thanks Ish Can someone at least point me to the source file that I can analyse to find out the table requirements? 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 -- _ -- 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
Re: [asterisk-users] RealTime Queue Logging in 1.8
On Thu, 2011-06-02 at 16:03 +0100, Ishfaq Malik wrote: Hi Does anyone know of an accurate resource I could refer to for this? The best I can find is http://www.voip-info.org/wiki/view/Asterisk+queue_log+on+MySQL And that table wont create in my database... Thanks Ish Can someone at least point me to the source file that I can analyse to find out the table requirements? 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
Re: [asterisk-users] RealTime Queue Logging in 1.8
I use following for MySQL... CREATE TABLE queue_log( id int(11) NOT NULL auto_increment, time datetime not null, queuename VARCHAR(50), agent VARCHAR(50), callid varchar(32), event VARCHAR(100), data1 VARCHAR(100), data2 VARCHAR(100), data3 VARCHAR(100), data4 VARCHAR(100), data5 VARCHAR(100), PRIMARY KEY (id) ) ENGINE=InnoDB ; Check the link to know the meaning of data1,data2... for Events. http://www.voip-info.org/wiki/view/Asterisk+log+queue_log [SATISH] On Mon, Jun 6, 2011 at 1:49 PM, Ishfaq Malik i...@pack-net.co.uk wrote: On Thu, 2011-06-02 at 16:03 +0100, Ishfaq Malik wrote: Hi Does anyone know of an accurate resource I could refer to for this? The best I can find is http://www.voip-info.org/wiki/view/Asterisk+queue_log+on+MySQL And that table wont create in my database... Thanks Ish Can someone at least point me to the source file that I can analyse to find out the table requirements? 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 -- _ -- 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