QueueMetrics forum
QueueMetrics => MySQL storage and Qloaderd/Uniloader => Topic started by: savoy6 on March 30, 2010, 20:58:26
-
Hello. I upgraded to a different version of Trixbox and Asterisk which fixed one problem but now my Queue data is not saved over night. I can see it realtime but the next day, there is nothing saved. I am completely new to Queuemetric but have done some reading on it. I notice that Qloaderd plays a role in the operation of Queuemetrics but cannot even find any instance of it in my Trixbox. Without reading thousands of pages of info on the topic, can someone point me in the right direction on this?
-
Qloaderd is advised but optional - likely your QM is reading straight from the queue_log file, and that is rotated. See here: http://astrecipes.net/index.php?n=205
-
I found the file suggested.
/var/log/asterisk/messages /var/log/asterisk/*log /var/log/asterisk/debug /var/log/asterisk/console /var/log/asterisk/full {
create 0640 asterisk asterisk
daily
extension .txt
mail root@localhost
missingok
nocompress
# notifempty
rotate 32
sharedscripts
# size 10M
postrotate
/usr/sbin/asterisk -rx 'logger reload' >/dev/null 2>/dev/null || true
endscript
}
/var/log/asterisk/cdr-csv/*csv /var/log/asterisk/cdr-custom/*csv {
create 0640 asterisk asterisk
monthly
extension .txt
mail root@localhost
missingok
nocompress
# notifempty
rotate 2
sharedscripts
# size 10M
postrotate
/usr/sbin/asterisk -rx 'logger reload' >/dev/null 2>/dev/null || true
endscript
}
Should I just delete the part highlighted in red above? Thank you so much for helping out. I really appreciate it.
-
Yes - consider that it will not rotate any of the _log files. You may add more rules manually if you need to.
-
That fixed the historical reporting issue but now the realtime data does not show up. I cannot see current activity now. Please advise. Thank you.
As an edit: If I am logged into admin mode, I can see the "live" data from the live tab. In supervisor mode I cannot see realtime data. All historical data is there...just realtime says all 0's. Thanks you again...
-
You see data in historical reports and not realtime? (the "live" page does not count).
Everything on the same box?
-
In admin mode, I can see "live" data. Nothing on the "realtime" tab.
In Supervisor mode, no realtime data when that tab is clicked.
As of right now, I can only see data from the day before yesterday and back. I followed the instructions on the link above yesterday.
Before I could only see realtime data and no historical. Now I can see historical and no realtime. Is one of the queues I deleted a "realtime" queue?
This is a single server set-up running Trixbox. Thank you.
-
Do you see data uploaded to the queue_log table in real-time, when you process calls on Asterisk?
-
Yes. I changed it back to the way it was before.
Now I can see realtime data being added to queue_log but no historical (7 days, last 30 days etc.)
When I follow the procedure you gave me before, realtime data does not add to queue_log.
Procedure says to "Remove all files but queue_log itself" after concatenating all the files. Is that accurate?
-
Yes it is so. Qm ignores them, anyway.
Just make sure that:
- you are loading from the Qm database (filename sql:XXX)
- all data is present in the MySQL database.
-
Sir or Maam,
Would you give details on "how" to do that? I think it's loading from queue_log. Queue_log is the one that is changing throughout the day. Sorry, I am 100% new to Queuemetrics. I've read through the manual a few times now and can't seem to find how to do this.
-
Look here: http://queuemetrics.com/download/QM_mysql_cluster_100.pdf
-
That article gives excellent detail for when using Qloaderd. I am not using a MySQL database. I am using flat storage and my QM says to look here for data:
/var/log/asterisk/queue_log
I'm going to just assume that the queue_log is being rotated daily and figure that if I can get it to rotate monthly or every 90 days then my problem will be solved?
-
Yes. If you have a smaller CC, you can even avoid rotating it at all, or yearly.... or use Qloaderd, so you are abstracted from the physical file....