Hello Iqbal,
On Apr 15, 11:54am, me wrote:
> Subject: (RADIATOR) replyattr and fixed ip's
> Hi
>
> I origiannly used to have asimple query which authenticated users fine
> select Password etc etc , however I now want to assign some of my users
> with fixed IP addresses (they are currently assigned from a pool in our
> NAS).
OK, should be no problem.
>
> The fixed IP's used to be assigned from the flat radius users file
> Fixed-IP-Address=xxx.xxx.xxx.xxx
I guess you mean Framed-IP-Address, but fine.
>
> However when i went down the sql route I cant seem to assign these fixed
> IP, the "normal" customers work fine.
>
> Then i decided to alter the Authselect statement
>
> ...select PASSWORD,CHECKATTR,REPLYATTR from SUBSCRIBERS where
> USERNAME='%n'
Hmm, its a bit hard to tell without seeing your config file, but I would
suggect this approach:
1. Make a new column in your database for the framed ip address, call it, say
FRAMEDIPADDRESS.
2. use this in your config file:
AuthSelect select PASSWORD,FRAMEDIPADDRESS from SUBSCRIBERS \
where USERNAME='%n'
AuthColumnDef 0,User-Password,check
AuthColumnDef 1,Framed-IP-Address,reply
Then, whenever a user has an entry in FRAMEDIPADDRESS, it will be used to set
Framed-IP-Address in the reply. If FRAMEDIPADDRESS is NULL, then it will not be
set in the reply.
3. Make sure your NAS uses a pool adddress of a static address is not supplied
by radius.
(it _is_ possible to do something similar using REPLYATTR as you are trying,
but its a bit harder to set up, and wastes some space)
Hope that helps.
Cheers.
>
> now nothing gets access no dynamic IP customers or fixed.
>
> I had a look at the logfile, and in there it does say Access Accept
>
> Thu Apr 15 10:57:34 1999: DEBUG: Handling request with Handler 'Realm='
> Thu Apr 15 10:57:34 1999: DEBUG: Handling with Radius::AuthSQL
> Thu Apr 15 10:57:34 1999: DEBUG: Query is: select PASSWORD, CHECKATTR,
> REPLYATTR
>
> from SUBSCRIBERS where USERNAME='mirza'
>
> Thu Apr 15 10:57:34 1999: DEBUG: Radius::AuthSQL looks for match with
> mirza
> Thu Apr 15 10:57:34 1999: DEBUG: Packet dump:
> *** Sending to 193.218.160.68 port 3760 ....
> Code: Access-Accept
> Identifier: 13
> Authentic: 7<21><196>u<0>u<24><188><0><0>M<1><0><0>l<153>
> Attributes:
> Service-Type = Framed
> Framed-Protocol = PPP
> Framed-IP-Netmask = 255.255.255.0
> Framed-Routing = None
> Framed-MTU = 1500
> Framed-Compression = Van-Jacobson-TCP-IP
>
> etc etc
>
> but they get an entry into the accounting logs, then disconnect. the
> fixed Ips dont even get that far.
>
> My CheckATTR in the db is NULL, but the replies are the ones above. I
> havent got any replies for fixed IP ones cause they dont get that far.
>
> Iqbal
>
> ===
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
>-- End of excerpt from me
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, external, etc etc on Unix, Win95/8, NT, Rhapsody
===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
