monitoring buffered-sql

[Ivan Kalik]

> I installed freeradius with detail, buffered-sql active. How to monitor
> the
> buffered-sql module. If it stops or sleeps for very long time responding
> to
> mysql db.?
> I saw all of a sudden buffered-sql not pushing packets to mysql db
> yesterday. After restarting radius process it started processing.
> Please suggest.

Monitor the database, not module. If last insert is x minutes/hours ago
send alert or even restart radiusd. I have an alert - first examine packet
that caused the freeze, then release the rest. In my experience every time
reason for the freeze was database backup - I am backing it up via the
network, so it can be slow.

Ivan Kalik
Kalik Informatika ISP