QueueMetrics > MySQL storage and Qloaderd/Uniloader

qloaderd not loading after log rotation started again

(1/3) > >>

trymes:
I had a working qloaderd install on Trixbox until I removed and reinstalled asterisk (don't ask, it was a bad idea). Anyhow, that forced asterisk to start rotating the queue_log file again, and I didn't notice until a week or so later. I repeated to process of combining the rotated queue_log files into one big file and I restarted qloaderd, checked all of the settings, etc, and all appears to be working, except that the database is not receiving any new data.

qloader.log prints out multiple lines of "Heart is still beating... Imported 0 lines." and it just spits out "Skipped xxxxxx lines" if I restart it.

In the Queuemetrics datbase inspector, it only shows data up to Jan 15, though we have data all the way to today in the queue_log file.

If I connect to mysql using the parameters specified in the qloaderd.pl script, (username, password, database), I can connect successfully.

Does anyone have any suggestions as to where I can look next? I'm sure it's something obvious, but I can't seem to figure it out.

Tom

QueueMetrics:
The thing that usually affects qloaderd not loading is the highest index it has in that partition. Try this: use a different partition name and see if the DB gets loaded.

trymes:
OK, I modified the partition name in the /etc/init.d/qloaderd file, and it loaded the info to the p002 partition. However, there seems to be some information missing, as P001 has data from October through Feb 12, while P002 has info just from November through Feb 12. (I had the permissions wrong on the /var/log/asterisk file, so it seems that asterisk has been unable to write anything to it since Feb 12) Maybe the "chown asterisk.asterisk /var/log/asterisk/queue_log" command and the appropriate chmod command would be a good thing to add to the tutorial on combining previously rotated call log files.

QueueMetrics:
I think that you lost some data due to a rotation then - but you can manually load the previous data from partition P001 to P002.

trymes:

--- Quote ---I think that you lost some data due to a rotation then - but you can manually load the previous data from partition P001 to P002.
--- End quote ---
Would the easiest way to do this be to copy Partition P001 to P003 and then force qloaderd to use that?

Navigation

[0] Message Index

[#] Next page