Anyone know how to get app_queue to send logs to MySQL or any other sql server. I found info for cdr's and even configs but nothing on queue_log. If sql is not supported in the current app_queue I will be willing to pay someone to add it. John Bittner Simlab.net
John Bittner wrote:> Anyone know how to get app_queue to send logs to MySQL or > any other sql server. > I found info for cdr's and even configs but nothing on > queue_log. > > If sql is not supported in the current app_queue I will be > willing to pay someone to add it.It does not currently do anything except a straight text file dump. If you're interested in getting this done, email me off-list or find me on freenode (kpfleming).
On Tue, 4 Jan 2005 12:19:31 -0500, John Bittner <john@simlab.net> wrote:> Anyone know how to get app_queue to send logs to MySQL or > any other sql server. > I found info for cdr's and even configs but nothing on > queue_log. > > If sql is not supported in the current app_queue I will be > willing to pay someone to add it. > > John Bittner > Simlab.net >John, I wrote a little perl routine that monitors the log and sends it to MySQL as it's written. Now, my perl skills are very weak. The app works fine and we have been running it in production for months, but keep in mind it was written by a total non-programmer type (me). If you don't find what you are looking for, I would be glad to send this to you. Just let me know. -Chuji
Hello John, xc-ast - http://demo.xcept.it/xc-ast - is currently able to produce reports based on the file-based queue_log but will soon be able to run the analysis on a mysql database (this feature is planned for 0.9). We will provision a perl upload utility, though it will not initially be real-time, as xc-ast currently is. Bye l. In data Tue, 4 Jan 2005 12:19:31 -0500, John Bittner <john@simlab.net> ha scritto:> Anyone know how to get app_queue to send logs to MySQL or > any other sql server. > I found info for cdr's and even configs but nothing on > queue_log. > > If sql is not supported in the current app_queue I will be > willing to pay someone to add it. > > John Bittner > Simlab.net > > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users-- Assum est, versa et manduca.
Guys, anybody has some info regarding the format that queue_log has and how to interpret it.. I found some info on the wiki about the conditions of a call but the first fields I still don't know what they are for, although I can imagine one of them is a call identifier, etc. but want to be sure.