Author Topic: realtime queue_log and database name  (Read 2214 times)

voicelogic

  • Newbie
  • *
  • Posts: 1
  • Karma: 0
    • View Profile
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

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: realtime queue_log and database name
« Reply #1 on: January 18, 2012, 17:58:41 »