realtime queue_log and database name

QueueMetrics > QueueMetrics installation

(1/1)

voicelogic:
Hi,

I have just done a fresh install of 1.7 and trying to get it to work with realtime queue_log but there seems to be some setting hard coded somewhere.

My queuemetrics and realtime are all in a database named qmetrics_ccc1 and I am using the a16 profile in configuration.properties along with the correct settings in web.xml (database connection / test is all successful) however when I try and view any stats I get a sql exception and then when I delve a bit deeper with ngrep I can see that queuemetrics is prefixing the table name with asterisk -

SELECT time , callid , queuename , agent , event , data FROM asterisk.queue_log WHERE (time >= '1321275600' AND time<='1321354239') AND queuename IN ( '', 'NONE' , 'queue-dps' , 'q2' , 'queue-test' , 'q1' , 'none' ) ORDER BY time ASC , id ASC

I cannot see anywhere in the config where I can tell QM the database name to use for this query - is this a bug - should it not just be querying the table name with no database name prefixed?

Regards,

Ben

QueueMetrics:
That is the *.table attribute of the table definition - see http://queuemetrics.com/manuals/QM_UserManual-chunked/ar01s18.html#_using_the_asterisk_realtime_queuelog_subsystem

Navigation

[0] Message Index

Go to full version