Hi Sam, > > ---------- Forwarded Message ---------- > > Subject: (RADIATOR) Re: SQLRADIUS questions > Date: Wed, 23 Jan 2002 10:10:37 -0800 > From: Sam Nilsson <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > > 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 [EMAIL PROTECTED] > To unsubscribe, email '[EMAIL PROTECTED]' with > 'unsubscribe radiator' in the body of the message. > > ------------------------------------------------------- -- Mike McCauley [EMAIL PROTECTED] 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
