Well, we're planning a move to postgresql, the two FR servers use that for storing radacct and radpostauth info. Just running on mysql for the cui stuff while I still have the two FR 2.2.9 machines ( need to puppetise my ref 3.12 machine and use that to replace the 2.2.9 machines) Haven't checked yet if the same issue will arise with postgresql A On 10 May 2016 at 12:07, Alan DeKok <aland@deployingradius.com> wrote:
On May 10, 2016, at 5:59 AM, Alex Sharaz <alex.sharaz@york.ac.uk> wrote:
So the above is happening because of the mysql backups and hence, every morning I get text messages saying both eduroam3 & eduroam4 are down .. which they're not.
Well, yes they mostly are... because the database is down.
Guess you're going to tell me to fix the mysql database access .... or is there something I can do to ignore cui stuff while the database is being backed up?
You can ignore the CUI checks, but the problem will just show up somewhere else.
If you're going to use MySQL, set up master/slave replication, and have FreeRADIUS write to the master. Then, back up the slave.
Or, switch to a real SQL database that doesn't break when people use it. Sorry... but MySQL is just not good enough.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html