(RADIATOR) Question about spliting the NAS-IP-ADDRESS for SQL use

[Hugh Irvine]

Hello Troy -

I suggest you write a PreClientHook that will add the pseudo-attributes 
shown below to the incoming request packet.

There is an example that does something quite similar for Cisco 
pseudo-attributes in the file "goodies/hooks.txt".

regards

Hugh


On Friday, Aug 22, 2003, at 06:49 Australia/Melbourne, Troy Holder 
wrote:

> We have a DB table with all of our network equipment in it and plan to
> use that to determine what Authby to use for different types of
> equipment ( got to love how Cisco wants different reply values to allow
> a user into enable mode). I plan to have a Handler call an AuthBy SQL 
> to
> do a query for the Auth-Type the device needs use and then run that
> AuthBy clause. The problem that I am running into is that we have the
> equipment's IP address broken up into the octets. I know that I can use
> %N in the SQL in the config, but how can I get %IP1.%IP2.%IP3.%IP4 (as
> in %N = %IP1.%IP2.%IP3.%IP4) instead?
>
> -- 
> -----------------------------------
> | Troy Holder    troy at ncstate.net |
> |     Senior Network Engineer     |
> |   Communication Technologies    |
> | North Carolina State University |
> -----------------------------------
> 	
> ===
> 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.
>
>

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
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.