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).
The fixed IP's used to be assigned from the flat radius users file
Fixed-IP-Address=xxx.xxx.xxx.xxx
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'
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.
