Issue with cuisql timing out on FR 3.12
alex.sharaz at york.ac.uk
Tue May 10 13:17:51 CEST 2016
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
On 10 May 2016 at 12:07, Alan DeKok <aland at deployingradius.com> wrote:
> On May 10, 2016, at 5:59 AM, Alex Sharaz <alex.sharaz at 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
> > 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
More information about the Freeradius-Users