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 -- Ishfaq Malik Software Developer PackNet Ltd Office: 0161 660 3062
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 > > IshCan 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
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 <ish at 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 >-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110607/bac7b1da/attachment.htm>
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 <ish at 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
Realtime table queue_log at 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 <ish at 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