Issue with cuisql timing out on FR 3.12

[Alex Sharaz]

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 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
> 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
>