Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

[asterisk-users] Queue logfile txt format in mySQL needed


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users
View previous topic :: View next topic  
Author Message
thomasitcom at gmail.com
Guest
PostPosted: Thu Jan 21, 2016 5:17 am    Post subject: [asterisk-users] Queue logfile txt format in mySQL needed Reply with quote
Hello,

Iam using queues and agents, thats OK.

I have interesting information form Asterisk in txt file format
var/log/asterisk/queue_log

Today Iam reading these txt files and wrote them in an mySQL databases.

I would need this information more realtime. Some information I do writing in
the dialplan direct in an mySQL database.

Is there any way that Asterisk write this information direct in an mySQL
database instead of using var/log/asterisk/queue_log?

best regards
Thomas





--
_____________________________________________________________________
-- 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
Back to top
kevin.larsen at pionee...
Guest
PostPosted: Thu Jan 21, 2016 10:53 am    Post subject: [asterisk-users] Queue logfile txt format in mySQL needed Reply with quote
Quote:
From: Thomas <thomasitcom@gmail.com>
To: asterisk-users@lists.digium.com,
Date: 01/21/2016 04:17 AM
Subject: [asterisk-users] Queue logfile txt format in mySQL needed
Sent by: asterisk-users-bounces@lists.digium.com

Hello,

Iam using queues and agents, thats OK.

I have interesting information form Asterisk in txt file format
var/log/asterisk/queue_log

Today Iam reading these txt files and wrote them in an mySQL databases.

I would need this information more realtime. Some information I do writing in
the dialplan direct in an mySQL database.

Is there any way that Asterisk write this information direct in an mySQL
database instead of using var/log/asterisk/queue_log?

I haven't done this myself, but it looks like you just need to set up the appropriate database connections. See here for a semi-recent example:
http://stackoverflow.com/questions/30161384/asterisk-11-queue-log-to-mysql ______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com ______________________________________________________________________
Back to top
thomasitcom at gmail.com
Guest
PostPosted: Thu Jan 21, 2016 4:31 pm    Post subject: [asterisk-users] Queue logfile txt format in mySQL needed Reply with quote
Am Donnerstag, 21. Januar 2016, 09:52:53 schrieben Sie:
Quote:
Quote:
From: Thomas <thomasitcom@gmail.com>
To: asterisk-users@lists.digium.com,
Date: 01/21/2016 04:17 AM
Subject: [asterisk-users] Queue logfile txt format in mySQL needed
Sent by: asterisk-users-bounces@lists.digium.com


Quote:
Quote:
database instead of using var/log/asterisk/queue_log?

I haven't done this myself, but it looks like you just need to set up the
appropriate database connections. See here for a semi-recent example:
http://stackoverflow.com/questions/30161384/asterisk-11-queue-log-to-mysql

Hi,
thanks...


in /etc/asterisk/res_config_mysql.c
for example define in [mydatabase] acsess to your database

in /etc/asterisk/extconfig.conf

queue_log => mysql,mydatabase,queue_log


CREATE TABLE IF NOT EXISTS `queue_log` (
`id` int(10) unsigned NOT NULL auto_increment,
`time` varchar(40) default NULL,
`callid` varchar(80) NOT NULL default '',
`queuename` varchar(80) NOT NULL default '',
`agent` varchar(80) NOT NULL default '',
`event` varchar(32) NOT NULL default '',
`data` varchar(255) NOT NULL default '',
`data1` varchar(255) NOT NULL default '',
`data2` varchar(255) NOT NULL default '',
`data3` varchar(255) NOT NULL default '',
`data4` varchar(255) NOT NULL default '',
`data5` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
);


after make an reload of asterisk info will be written in this table and not
any more in the txt file....



I found some explantion for the data written in the fields:
https://wiki.asterisk.org/wiki/display/AST/Queue+Logs




--
_____________________________________________________________________
-- 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
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services