4 thoughts on - RealTime Queue Logging in 1.8

  • Can someone at least point me to the source file that I can analyse to
    find out the table requirements?

    Ish

  • 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]

  • Thanks for that, the table got created. Should be plain sailing from
    here on 🙂

    Ish

  • Realtime table queue_log@asterisk: Column time cannot be a datetime

    Works fine once the time column is turned to char…