hi i cant find any how to store the queue log in mysql instead of file. any one can send me a link or a pdf? in voip info i found how to setup a realtime queue but not to store the log in mysql. end beyond the storing where i can find a good queue log parser? it must be opensource because is to integrate in a CRM system (vtiger) wich is opensource. if it isnt in php there is no problem i can port it. THANKS David -- (\__/) (='.'=)This is Bunny. Copy and paste bunny into your (")_(")signature to help him gain world domination. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090104/34012910/attachment.htm
With regards to storing queue_log data in mysql, it depends on the Asterisk service your running. 1.6.x check out the following: http://www.voip-info.org/wiki/view/Asterisk+queue_log+on+MySQL 1.2.x OR 1.4.x check out the following patch/solution: http://www.plack.net/index.php/2007/01/07/asterisk_modification_for_queue_logging Hope that's what you're looking for. Good luck! David fire wrote:> hi > i cant find any how to store the queue log in mysql instead of file. > any one can send me a link or a pdf? in voip info i found how to setup a > realtime queue but not to store the log in mysql. > > end beyond the storing where i can find a good queue log parser? > it must be opensource because is to integrate in a CRM system (vtiger) > wich is opensource. > if it isnt in php there is no problem i can port it. > > THANKS > David
On Sunday 04 January 2009 14:42:50 David fire wrote:> i cant find any how to store the queue log in mysql instead of file. > any one can send me a link or a pdf? in voip info i found how to setup a > realtime queue but not to store the log in mysql.The realtime family (in extconfig.conf) is called "queue_log". The table must contain the following fields: time integer callid char(23) queuename char(80) agent char(80) event char(30) data char(255) Storage of realtime data for queue_log is only available for version 1.6.0 and higher. -- Tilghman