Author Topic: mysql data is inserted but can not be seen in queuemetrics  (Read 4207 times)

wilsonchua

  • Newbie
  • *
  • Posts: 16
  • Karma: 2
    • View Profile
    • Email
Hi Guys,

I was able to migrate our queuemetrics installation from flatfile to using mysql over on a separate server. I followed the instructions on : http://queuemetrics.com/download/QM_mysql_cluster_100.pdf .

So our partition is P001.

I can see qloader.log and queue_log in the /var/log/asterisk are working.
I can see in mysql that new data are being inserted, including the heartbeat records.

However, in http://localhost:8080/queuemetrics, when i set the [File] parameter to : sql:P001
I dont see any records for the current day up to the 7 days old. I can see data from 7days old and older.

Also, since i migrated, i noticed that the "Start Real Time Monitoring" does not show any data at all.

Anyone ever experienced this before? I appreciate any tips or directions to take.
« Last Edit: April 20, 2011, 11:09:26 by wilsonchua »

wilsonchua

  • Newbie
  • *
  • Posts: 16
  • Karma: 2
    • View Profile
    • Email
Re: mysql data is inserted but can not be seen in queuemetrics
« Reply #1 on: April 20, 2011, 11:08:56 »
if i point the file back to /var/log/asteriks/queue_log
I can see all the data.

If i do a mysql command:
SELECT `partition`, from_unixtime(`time_id`), from_unixtime(`call_id`), `queue`, `agent` FROM `queue_log` order by time_id desc

I can see new records inserted:
partition    from_unixtime( `time_id` )    from_unixtime( `call_id` )    queue    agent
P001   2011-04-20 17:03:20   1970-01-01 08:00:00   NONE   NONE
P001   2011-04-20 16:44:29   1970-01-01 08:00:00   NONE   NONE
P001   2011-04-20 13:45:48   2011-04-20 13:28:22   7202   NONE
P001   2011-04-20 13:28:55   2011-04-20 13:28:22   7202   NONE
P001   2011-04-20 13:28:43   2011-04-20 13:28:22   7202   NONE
P001   2011-04-20 13:12:00   2011-04-20 13:08:04   7202   NONE
P001   2011-04-20 13:08:46   2011-04-20 13:08:04   7202   NONE
P001   2011-04-20 13:08:35   2011-04-20 13:08:04   7202   NONE


So why is it now showing up on the queuemetrics page?




wilsonchua

  • Newbie
  • *
  • Posts: 16
  • Karma: 2
    • View Profile
    • Email
Re: mysql data is inserted but can not be seen in queuemetrics
« Reply #2 on: April 21, 2011, 15:45:21 »
Hi Guys,

Thanks to help from Lorenzo,  the issue is resolved. Apparently, the web.xml file also had a pointer to the old flatfile.
By changing the pointers in that file, it is now working!

Thanks Lorenzo!!

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: mysql data is inserted but can not be seen in queuemetrics
« Reply #3 on: April 22, 2011, 10:52:10 »
 ;D