2 thoughts on - Queue agent login notification

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

  • 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,,queue_log

    you will also need an entry in your res_config_mysql.conf along the lines of

    []
    dbhost =
    dbname =
    dbuser =

    dbpass =

    dbport = 3306

    All the above are for asterisk 1.8

    Regards

    Ish