[asterisk-users] RealTime Queue Logging in 1.8

Ishfaq Malik ish at pack-net.co.uk
Tue Jun 7 05:05:02 CDT 2011


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




More information about the asterisk-users mailing list