Hello Kirk -
On Thu, 09 Dec 1999, Kirk Rogers wrote:
> Hello all,
> I am new to the group and RADIATOR and am stumped on a details concerning
> the reply items sent back to the NAS (Ascend MAX4000). I have a profile
> defined for a dial-up router (Ascend Pipeline 85) and it is configured as a
> small subnet (255.255.255.248). The IP address of the router and the subnet
> are both stored in the SQL DB and needs to be relayed to the NAS via the
> RADIUS response from the original authentication request.
> Problem...I cant seem to figure out which reply attribute(s) to enter into
> the radius.cfg file to get this to work. Is anyone out there familiar with
> this problem? Here's what I have so far:
>
> <Realm co.com>
> <AuthBy SQL>
> DBSource dbi:ODBC:remacc
> DBUsername sa
> DBAuth password
> # AuthSelect select PASSWORD, CALLED_STATION_ID, TIME_OF_DAY,
> EXPIRATION from AUTHENTICATION where USER_NAME='%U'
> AuthSelect select PASSWORD, CALLED_STATION_ID, EXPIRATION
> from AUTHENTICATION where USER_NAME='%U'
> AuthColumnDef 0, User-Password, check
> AuthColumnDef 1, Called-Station-Id, check
> AuthColumnDef 2, Expiration, check
>
> AccountingTable ACCOUNTING1
> AcctColumnDef User_Name, User-Name
> AcctColumnDef NAS_IP_Address, NAS-IP-Address
> AcctColumnDef NAS_Port, NAS-Port
> ...
> ...
> ...
> AcctColumnDef Framed_Protocol,
> Framed-Protocol
> AcctColumnDef Framed_IP_Address,
> Framed-IP-Address
> AcctColumnDef Time, Timestamp,
> formatted-date, '%a %b %d %H:%M:%S %Y'
> </AuthBy>
> AcctLogFileName c:/radiator/logs/detail
> </Realm>
>
You will need to return those values in your AuthSelect statement and return
them to the NAS as reply items. Something like this (use your own columns):
AuthSelect select PASSWORD, CALLED_STATION_ID, EXPIRATION,
IP_ADDRESS, IP_NETMASK from AUTHENTICATION where USER_NAME='%U'
AuthColumnDef 0, User-Password, check
AuthColumnDef 1, Called-Station-Id, check
AuthColumnDef 2, Expiration, check
AuthColumnDef 3, Framed-IP-Address, reply
AuthColumnDef 4, Framed-IP-Netmask, reply
Have a look at section 6.24 in the Radiator 2.14.1 reference manual.
hth
Hugh
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
