[RADIATOR] SqlDb.pm - sql server failover.

[Heikki Vatiainen]

On 11/10/2011 08:15 PM, Michael wrote:
> In SqlDb.pm sub do{} should a mysql syntax error also be reason NOT to disconnect/reconnect from/to the mysql server?

Hmm, good question. If it does not mask a real problem, then probably yes.

Isn't this something that happens with an incorrect configuration or can
these errors happen during the normal operation. If so, what would be
the reason for this?

It would be useful to know why this happens before adding it.

Thanks!

>              # Primary key violation is not a cause for disconnection.
>              # Also SQL syntax error.
>              return $rc if defined $rc
>                            || $reason =~ /error in your SQL syntax/i
>                            || $reason =~ /violation/i
>                            || $reason =~ /duplicate key/im
>                            || $reason =~ /Duplicate entry/im
>                            || $reason =~ /^ORA-00001/;


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