You can call your AuthBy SQL from a ReplyHook making the whole thing easier than you might think. Examples are in goodies/hooks.txt.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:alexander.deboer@;kpn.com] Sent: Wednesday, October 23, 2002 11:59 AM To: [EMAIL PROTECTED] Subject: (RADIATOR) Add IP from SQL table to AuthBy Radius Reply packet Hi all, I'm trying to solve the following problem. Our radiator proxies authentication requests. Upon receiving the response from the remote radius server, we want to add an user-specific IP-address from our own SQL table. I'm considering the following approach: <AuthBy Group> Identifier proxy AuthByPolicy ContinueWhileAccept <AuthBy Radius> Host ... .... </AuthBy> <AuthBy SQL> DBSource dbi:mysql:radius DBUsername ... DBAuth ... AuthSelect select ipaddress from tblAccess where username='%u' AuthColumnDef 0, GENERIC, reply </AuthBy> </AuthBy> However, due to the asynchronous behavior of AuthBy Radius this won't work. See also: http://www.open.com.au/archives/radiator/2001-04/msg00192.html http://www.open.com.au/archives/radiator/2002-08/msg00107.html I'm a bit reluctant to use the Synchronous parameter, since we cannot really trust the remote radius server. Another solution could be using a ReplyHook. However, this seems a bit cumbersome to me; writing a failure-back-off-fall-back procedure to multiple SQL-servers myself, while it is so nicely implemented in Radiators AuthBy SQL. Does anybody has a suggestion to overcome this problem? Cheers, Alexander > ---------------------------------------------------------------- > dr. Alexander P. de Boer > KPN Royal Dutch Telecom > Room L C7, P.O.Box 421, 2260 AK Leidschendam > The Netherlands > === 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. === 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.