Hi All, I'm using mysql server 5.1.30 for storing radius accounting details. The system works fine and accounting is done to log file and to mysql server installed in a separate machine. But the problem arises when the mysql server is not working. When the radius accounting server lost the connectivity to the mysql server it does not report any kind of error. The radius daemon is working fine in the radius accounting server. But it does not respond to any requests. Is there any way for me to recognize whether the mysql server is offline from the radius server? Thanks Asin New Email addresses available on Yahoo! Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry before someone else does! http://mail.promotions.yahoo.com/newdomains/aa/
But the problem arises when the mysql server is not working. When the radius accounting server lost the connectivity to the mysql server it does not report any kind of error. The radius daemon is working fine in the radius accounting server. But it does not respond to any requests.
So it isn't "working fine". It's not responding because it hasn't (better said can't) complete processing of the request (sql is failing).
Is there any way for me to recognize whether the mysql server is offline from the radius server?
You can use buffered-sql virtual server to deal with this - when database goes down NAS will get the response and accounting data will keep on piling up in the detail file until database is back on line.
participants (2)
-
Asin Silva -
Ivan Kalik