On 5/5/06, Jon Farmer <[EMAIL PROTECTED]> wrote:
We use a Perl script called acd_logger.pl. I can't remember when I got it from now but if you want a copy then mail me directly.
Regards
Jon
Jon Farmer
Telford, Shropshire, UK
----- Original Message ----
From: Kevin Savoy < [EMAIL PROTECTED]>
To: Asterisk Users Mailing List - Non-Commercial Discussion <asterisk-users@lists.digium.com >
Sent: Friday, 5 May, 2006 2:57:06 PM
Subject: [Asterisk-Users] Dumping queue_log to MySQLAnyone have a working solution for this? I played with the demo that came with QueueMetrics to see how they were doing it and it was working for a bit but now somehow every night it stopped. Perl and Tail are still running on the server but the information is not dumping to the MySQL database. I don't get any error messages anywhere telling me why it stops. As far as tail and perl are concerned everything is fine.
We will be using this for a call center and need more reliability. Anyone got one working?
We've had a fair amount of success using the script attached with the following mysql schema.
mysql> desc queue_actions;
+-----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| queueid | int(11) | | MUL | 0 | |
| uniqueid | varchar(25) | | MUL | | |
| queuename | varchar(45) | | MUL | | |
| agentname | varchar(45) | | | | |
| action | varchar(25) | | MUL | | |
| alt1 | varchar(10) | | | | |
| alt2 | varchar(10) | | | | |
| userfield | varchar(75) | | | | |
| calltype | int(4) | YES | | NULL | |
| nodename | varchar(25) | YES | | NULL | |
+-----------+-------------+------+-----+---------+-------+
10 rows in set (0.00 sec)
--
Bird's The Word Technologies, Inc.
http://www.btwtech.com/
+-----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| queueid | int(11) | | MUL | 0 | |
| uniqueid | varchar(25) | | MUL | | |
| queuename | varchar(45) | | MUL | | |
| agentname | varchar(45) | | | | |
| action | varchar(25) | | MUL | | |
| alt1 | varchar(10) | | | | |
| alt2 | varchar(10) | | | | |
| userfield | varchar(75) | | | | |
| calltype | int(4) | YES | | NULL | |
| nodename | varchar(25) | YES | | NULL | |
+-----------+-------------+------+-----+---------+-------+
10 rows in set (0.00 sec)
--
Bird's The Word Technologies, Inc.
http://www.btwtech.com/
insert-queue-info.pl
Description: Binary data
_______________________________________________ --Bandwidth and Colocation provided by Easynews.com --
Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
