[RADIATOR] SqlDb.pm - sql server failover.

[Heikki Vatiainen]

On 11/11/2011 12:55 AM, Michael wrote:

> It happened for me when a customer logged in with a ' in their
> username.  the mysql insert for the AuthLog of course didn't like that.
> i didn't originally use the the sql quoted special characters in my
> insert statement.  I am using those special characters now though.  Not
> too crucial of an issue, i just thought i'd mention it.

Thanks for the clarification. I think one reason for special handling
for primary key problems are the *Alt options in AuthBy FREERADIUS and
the possibility for similarly fixing e.g., accounting requests where it
may not always be possible to know if the key is already there or not.

The syntax errors are in a bit different category. Anyone please comment
on this if you see good reasons to or not to special syntax errors this way.

Thanks!
Heikki

-- 
Heikki Vatiainen <hvn at open.com.au>

Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS,
TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP,
DIAMETER etc. Full source on Unix, Windows, MacOSX, Solaris, VMS,
NetWare etc.