(RADIATOR) Adding an SQL based attribute before AuthBy SQLRADIUS

[Hugh Irvine]

Hello Sebastian -

Probably the simplest thing to do is have an AuthBy SQL clause before the 
AuthBy SQLRADIUS clause, something like this:

# define AuthBy clauses

<AuthBy SQL>
	Identifier GetCustomAttribute
	DBSource ....
	DBUsername ....
	DBAuth ....
	AuthSelect select ATTRIBUTE from ......
	AuthColumnDef 0, Custom-Attribute-Name, reply
</AuthBy>

<AuthBy SQLRADIUS>
	Identifier ForwardToProxy
	.....
</AuthBy>

# define Realm or Handler

<Handler>
	AuthByPolicy ContinueAlways
	AuthBy GetCustomAttribute
	AuthBy ForwardToProxy
	.....
</Handler>

Of course the Custom-Attribute-Name must be defined in the dictionary.

regards

Hugh


On Mon, 24 Jun 2002 16:36, Sebastian Filzek wrote:
> Hello,
>
> Quick question:
>
> I'm running a proxy radius server, and trying to add a custom attribute
> (whos value must be fetched by SQL) to all auth/acct packets before they
> are passed on using AuthBy SQLRADIUS.  Is there any way to do this besides
> using a preauthhook?
>
> Any pointers/ideas appreciated.
>
> Regards,
> Sab.

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
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.