QueueMetrics > General Asterisk configuration

Asterisk 1.8 does not write queue_log to file

(1/1)

QueueMetrics:
A number of issues are experiencing the problem that Asterisk 1.8 is not writing the queue_log file when it has just started.

This is caused by an issue with Asterisk 1.8 that Digium is aware of and is currently tracked (but unsolved) in the Asterisk bug database:

* https://issues.asterisk.org/jira/browse/ASTERISK-17036
* https://issues.asterisk.org/jira/browse/ASTERISK-18208

We offer a couple of workarounds:

* Patch your system as described in ASTERISK-17036 or here: http://forum.queuemetrics.com/index.php?topic=1171.0
* Use the native Asterisk database logging with QM. See http://queuemetrics.com/manuals/QM_UserManual-chunked/ar01s18.html#_using_asterisk_realtime_queuelog_subsystem

See also: http://queuemetrics.com/manuals/QM_UserManual-chunked/ar01s23.html#_running_asterisk_1_8_with_queuemetrics

We will update when the issue is fixed in the main Asterisk sourcecode trunk.

QueueMetrics:
QM at the moment does not support Asterisk realtime logging on Asterisk 1.8, as they changed the file format since 1.6.

We have a workaround anyway:

1. let's say your Asterisk writes to table queue_logs in database asterisk.

2. give your queuemetrics MySQL user the grants to read the database asterisk. Make sure you can run a:

--- Code: ---SELECT * FROM asterisk.queue_logs LIMIT 0,1
--- End code ---
without errors when using the queuemetrics database.

3. Create a view in the QM database, as follows:


--- Quote ---CREATE VIEW ql_live AS SELECT unix_timestamp(time) as time_id, callid
as call_id, queuename as queue, agent as agent, event as verb, data1,
data2, data3, data4, data5, id as unique_row_count, 'LIVE' as
partition, '' as serverid FROM asterisk.queue_logs

--- End quote ---


4. Edit the configurations.properties file of QM as follows:


--- Code: ---default.queue_log_file=sql:LIVE
--- End code ---

And


--- Code: ---sqlPreset.1.table=ql_live
--- End code ---

It will be a bit less efficient, but works.

Wessel:
It's solved in 1.8.8
No need to hack the code anymore  :o

QueueMetrics:
Thanks! I am closing this topic.

Navigation

[0] Message Index