QueueMetrics > MySQL storage and Qloaderd/Uniloader

qloaderd not loading after log rotation started again

<< < (2/3) > >>

QueueMetrics:
I would select the lowest timestamp in partition P002 and then move all values from P001 that have a lower timestamp than that to partition P001, something like:

UPDATE queue_log
SET partition = 'P002'
WHERE partition = 'P001' and time_id < 1111111111

where 1111111111 is the minimum timestamp for P002.

Do run a backup first :)

ew:
My Qloaderd doesn't collect data, when the logratation starts again. I add the lines to /etc/logrotate.d/asterisk with the qloaderd manual


--- Code: ---/var/log/asterisk/debug /var/log/asterisk/messages /var/log/asterisk/full /var/log/asterisk/*_log {
        weekly
        missingok
        rotate 4
        sharedscripts
        postrotate
                /usr/sbin/invoke-rc.d asterisk logger-reload > /dev/null 2> /dev/null
                /etc/init.d/qloaderd restart > /dev/null 2> /dev/null
        endscript
}

--- End code ---

Now I have to rename the file queue_log.1 to queue_log and do an restart of qloaderd.
An restart of qloaderd only, doesnt show any data on the QM page.

My System:

Ubuntu 7.04
Asterisk 1.4

Any suggestions are welcome. Thanks in advance

Bes regards

T. Lai

QueueMetrics:
You should likely create the /var/log/asterisk/queue_log file - if it has been rotated and nothing is written to it, qloaderd will stop complaining that the file does not exist.

ew:
There was some Data in the queue_log file. But qloaderd doesn't load the datas into SQL after logratation.

QueueMetrics:
You have to restart qloaderd

Navigation

[0] Message Index

[#] Next page

[*] Previous page