sql returns fail for some stop requests

Arran Cudbard-Bell a.cudbardb at freeradius.org
Tue Jul 24 19:18:30 CEST 2012


On 24 Jul 2012, at 14:24, Alan DeKok wrote:

> Amir Tal wrote:
>> After additional debugging the fault seems to be with a rouge backup
>> process running on DB host, causing it to be slow to un-responsive for
>> 10-20 minutes.
> 
>  Stop that.  The database used by the RADIUS server should ONLY be used
> by the RADIUS server.

Use SQL replication to transfer the records to another system and backup from that. Do not perform intensive queries on a live system. It also sounds like you might be using MyISAM for radacct, if you are convert it to InnoDB ASAP.

Yes you can use buffered SQL to protection against temporary DB outages. But only for Accounting. Don't try this on 2.1x branch, use 3.0 if you want something that actually works reliably...

Yes you can use redundant to fail open or closed, but its simpler to just:

sql {
	fail = 1
}
if (fail) {
	update control {
		Auth-Type := 'Accept'
	}
}

or

if (fail) {
	reject
}

-Arran


More information about the Freeradius-Users mailing list