Fwd: (RADIATOR) Re: SQLRADIUS questions

[Mike McCauley]

Hi Sam,

>
> ----------  Forwarded Message  ----------
>
> Subject: (RADIATOR) Re: SQLRADIUS questions
> Date: Wed, 23 Jan 2002 10:10:37 -0800
> From: Sam Nilsson <sam at enabledsites.com>
> To: radiator at open.com.au
>
> This does help quite a bit.
>
> Are you saying that I can use the "FailureBackoffTime" parameter in an
> AuthBy SQLRADIUS
> clause to indicate how long to mark the SQL connection unavailable?
Yes. Any clause that has an SQL interface accepts FailureBackoffTime (which 
defaults to 600 seconds).


>
> In this case, can i set it to 0 to always attempt to contact the SQL
> server? 

Yes, but I would only do this if the SQL server is typically 
down/uncontactable only for very short periods of time.

> Can i also use
> "Retries" and "RetryTimeout" as parameters to control the SQL connection
> attempts?

No, "Retries" and "RetryTimeout" are to do with proxying: how many times a 
packet will be retransmitted to the selected host,and the timeout between 
retransmissions.


There is however a Timeout parameter that all SQL clauses take that specifies 
how long to wait for a dead/slow SQL connection.

>
> I'm using mysql although i guess that doesn't matter.
Correct.

>
> The documentation for radiator is excellent, but it is also difficult to
> fully document something
> that is so flexible and full featured.

Thanks for your understanding. We are happy to receive suggestions for 
improvment at any time.

Cheers.

>
> Thanks for your help.
> - Sam
>
> Mike McCauley wrote:
> > FailureBackoffTime for a host is not used in AuthBy SQLRADIUS. It is only
> > the results of the SQL query that determine which host to use.
> >
> > One way it could decide there are no working hosts would be if the
> > connection to the SQL database failed. Radiator would then assume their
> > were no available hosts until the FailureBackoffTime of the AuthBy
> > SQLRADIUS (as opposed to a host) expired and the SQL connection was
> > reestablished.
> >
> > You can alter this policy by providing one or more hardwired <Host xxxx>
> > clause inside the AuthBy SQLRADIUS. They will be consulted if the SQL
> > connection fails.
> >
> > Hope that helps, but please let me know if not.
> >
> > Cheers.
>
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
>
> -------------------------------------------------------

-- 
Mike McCauley                               mikem at open.com.au
Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
Phone +61 3 9598-0985                       Fax   +61 3 9598-0955

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 etc etc 
on Unix, Win95/8, 2000, NT, MacOS 9, MacOS X
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.