asterisk users - Mar 2007 - queue information in mySQL

Hi,

is it possible to have the information stored in 

/var/log/asterisk/queue_log

realtime in mySQL?

thanks

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

Gesch?ftsf?hrer: Stefan Wintermeyer
Handelsregister: Neuwied B 14998

> -----Original Message-----
> From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-
> bounces@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