Show Posts
1
QueueMetrics installation / realtime queue_log and database name
« on: November 15, 2011, 11:51:56 »
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
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