[asterisk-users] queue information in mySQL

[Philipp Kempgen]

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