mysql data is inserted but can not be seen in queuemetrics

[wilsonchua]

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.

[wilsonchua]

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]

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]