[asterisk-users] queue information in mySQL

[Steve Totaro]

> -----Original Message-----
> From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-
> bounces at lists.digium.com] On Behalf Of Philipp Kempgen
> Sent: Wednesday, March 07, 2007 11:08 AM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: Re: [asterisk-users] queue information in mySQL
> 
> Thomas Winter wrote:
> 
> > is it possible to have the information stored in
> >
> > /var/log/asterisk/queue_log
> >
> > realtime in mySQL?
> 
> No. You need to write a custom script.
> See
> http://www.voip-info.org/wiki/view/Asterisk+queue_log+on+MySQL
> 
> William Lloyd has a Perl script for that:
> http://lists.digium.com/pipermail/asterisk-users/2005-July/109892.html
> 
> And QueueMetrics (free demo) comes with a Perl script as well:
> http://queuemetrics.loway.it/
> 
> But there's one big disadvantage of replacing the queue_log file
> by a FIFO: should your script ever fail to read from the pipe
> Asterisk will stop working as the FIFO is blocking.
> 
> So you might want to use logrotate which has an option to truncate
> the file in place. Disadvantage: there's a very small chance that
> some log entries get lost during the rotation although that is not
> very likely.
> 
> Regards,
>   Philipp
> 
> --
> amooma GmbH - Bachstr. 126 - 56566 Neuwied - http://www.amooma.de
>      Let's use IT to solve problems and not to create new ones.
>            Asterisk? -> http://www.das-asterisk-buch.de
> 

Queuemetrics has two different scripts that work great.  One will parse
your log files and input the data into MySQL, the second one just tails
the file and puts the data into the MySQL DB on the fly as it is written
to queue_log.  Neither one will modify the way your original queue_log
files are written or operate.

Thanks,
Steve