[RADIATOR] SQL Timeout

[Ricardo Martinez]

Is there a way to mark the DB SQL as down in the configuration file, maybe
with a PostHook? Or something like that?

Regards,
Ricardo.-

-----Mensaje original-----
De: Ricardo Martinez [mailto:rmartinez at redvoiss.net]
Enviado el: lunes, 19 de noviembre de 2012 18:50
Para: 'Heikki Vatiainen'; 'radiator at open.com.au'
Asunto: RE: [RADIATOR] SQL Timeout

There is also other post about the same issue :

http://www.open.com.au/pipermail/radiator/2011-April/017237.html



-----Mensaje original-----
De: Ricardo Martinez [mailto:rmartinez at redvoiss.net] Enviado el: lunes, 19
de noviembre de 2012 18:36
Para: 'Heikki Vatiainen'; 'radiator at open.com.au'
Asunto: RE: [RADIATOR] SQL Timeout

Is there another more safe way to do the BackOff.  What I'm trying to do
is when a SQLquery is Timeout by Radiator mark the server as "down" and do
the next AuthBy Clause.
I saw a pair of question about the same issue near 2002 :
http://www.open.com.au/pipermail/radiator/2002-October/005289.html

Please help me here.

I'm using :
Radiator 4.9
perl, v5.10.1 (*) built for x86_64-linux-thread-multi DBI : 1 .622
DBD:mysql  4.022

Regards,
Ricardo.-


-----Mensaje original-----
De: radiator-bounces at open.com.au [mailto:radiator-bounces at open.com.au] En
nombre de Heikki Vatiainen Enviado el: lunes, 19 de noviembre de 2012
18:21
Para: radiator at open.com.au
Asunto: Re: [RADIATOR] SQL Timeout

On 11/19/2012 10:47 PM, Ricardo Martinez wrote:

> Question : When it says ".Radiator will wait for when trying to
> contact the SQL server." this means that a */select/* is a CONTACT???

Hello Ricardo,

there is a contact before the select. The contact succeeds but the
subsequent query (DELYREQ) times out. Since it was the query that returned
error and not the contact just before it, FailureBackoffTime is not
triggered.

> So, I don't understand why the Radiator is not doing the Backoff.

If you make the DB contact to block, for example using iptables to drop
traffic destined to the DB, it will then time out the connection attempt.
When this happens you will see it start the backoff timer.

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.
_______________________________________________
radiator mailing list
radiator at open.com.au
http://www.open.com.au/mailman/listinfo/radiator