(RADIATOR) AuthColumnDef questions

[Hugh Irvine]

Hello Terry -

If you are using Radiator users file(s) in the "standard" format, the 
first line is the list of check attributes and the second and following 
indented lines are the reply attributes. Note that most radius 
attributes can be used both in requests (check) and in replies (reply).

# users file

someuser		Password = xxxxxx, Service-Type = Framed-User, NAS-Port-Type 
= Async
	Service-Type = Framed-User,
	Framed-Protocol = PPP,
	Framed-IP-Address = n.n.n.n,
	.....

Note that there is a "buildsql" utility included with the Radiator 
distribution that you can use to load a users file in the above format 
into an SQL database.

regards

Hugh	


On Sunday, Feb 16, 2003, at 03:21 Australia/Melbourne, terry at ccis.net 
wrote:

> I am in the process of converting our login profiles from a text list 
> of
> exception users and a default, to a MySQL database.
>
> 1) There are some fields I cannot determine to be "Check" or "Reply". 
> Can
> anyone confirm what I have flagged, and provide the fills (?)?
>
> field               c/r       Typical Values
> NAS-Port-Type       (Check)        Async,  for  Dialup, blank for multi
> User-Service-Type   (Check)        Framed-User or Login-User (shell)
> Framed-Protocol     (Reply)        PPP
> Framed-Address (Reply)        255.255.255.254
> Framed-Netmask (Reply)        255.255.255.255           R
> Framed-Routing (Reply)        None            R
> Framed-MTU          (Reply)        1500            R
> Framed-Compression  (?)       Van-Jacobsen-TCP-IP
> Framed-Route        (Reply)        blank, otherwise 
> (ex:"209.195.254.68/30
> 209.195.254.28")
> Ascend-Maximum-Channels  (Relpy)   1
> Login-Service       (Reply)        blank                 login, Telnet
> Login-Host          (Reply)        blank
>
> 2) Is there a way to code a default Check/Reply in the case where an
> AuthSelect-ed field is blank? E.g.,
>
> AuthSelect select PASSWORD, CHECKATTR, REPLYATTR from SUBSCRIBERS where
> USERNAME=%0
> AuthColumnDef 0, User-Password, check
> AuthColumnDef 1, GENERIC, check
> AuthColumnDef 2, GENERIC, reply
> ..if field 1 is "", use 'Service-Type=Framed-User"'
> ..if field 2 is "" use 'Framed-Protocol=PPP,Framed-IP-Netmask
> =255.255.255.0,....'
>
> Terry Ryan, CCIS Inc.
>
> ===
> 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.
>
>

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