[asterisk-users] Queue agent login notification

[Ishfaq Malik]

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,<db-name>,queue_log

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

[<db-name>]
dbhost = <location of db>
dbname = <db-name>
dbuser = <db-user>
dbpass = <db-pass>
dbport = 3306

All the above are for asterisk 1.8

Regards

Ish



On Thu, 2011-09-08 at 09:20 +0500, Sam Govind wrote:
> 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. 
> 
> On Wed, Sep 7, 2011 at 6:19 PM, Michael <voip.question at gmail.com>
> wrote:
>         I couldn't find the extconfig.conf file in /etc/asterisk and
>         queue_log doesn't exist either (as a file or as a db table).
>         We're using AsteriskNOW, so maybe these files/tables were not
>         created.
>         
>         How should we add them?
>         
>         Thanks.
>         
>         On Wed, Sep 7, 2011 at 8:54 AM, Sam Govind
>         <govoiper at gmail.com> wrote:
>         
>                 See this link: 
>                 http://www.voip-info.org/wiki/view/Asterisk+queue_log
>                 +on+MySQL
>                 
>                 
>                 You'll find similar pages where you can setup to store
>                 queue logs/events(as Alex mentioned) in MySQL DB and
>                 further do your triggers or functions on them.
>         
>         --
>         _____________________________________________________________________
>         -- 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