Issue with cuisql timing out on FR 3.12
alex.sharaz at york.ac.uk
Tue May 10 13:19:18 CEST 2016
p.s. tried master/slave replication for accounting info and gave up,
couldn't get it to work reliably
On 10 May 2016 at 12:17, Alex Sharaz <alex.sharaz at york.ac.uk> wrote:
> 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