No subject

<AuthBy SQL>
AuthSelect select PASSWORD, REPLYATTR, PLAINTEXT, CHECKATTR 
from SUBSCRIBERS where USERNAME='%n'

AuthColumnDef 0, User-Password, check
AuthColumnDef 1, GENERIC, reply
AuthColumnDef 2, Framed-IP-Address, reply
AuthColumnDef 3, Framed-IP-Netmask, reply
-------

Note that PLAINTEXT and CHECKATTR are unused columns in our
SUBSCRIBERS table - varchar(50) and varchar(200) respectively.

In the level 4 trace that follows, I've modified the IP's
to protect the innocent ;-) otherwise all is as radiator replies.
As can be seen, we are trying to give the client a netmask of
255.255.255.240, but the client is coming up with 255.255.255.0

Fri Nov 29 11:53:44 2002: DEBUG: Handling with Radius::AuthSQL
Fri Nov 29 11:53:44 2002: DEBUG: Query is: select PASSWORD, REPLYATTR, PLAINTEXT, CHECKATTR from SUBSCRIBERS where USERNAME='xxxxxx'

Fri Nov 29 11:53:44 2002: DEBUG: Radius::AuthSQL looks for match with xxxxxx
Fri Nov 29 11:53:44 2002: DEBUG: Radius::AuthSQL ACCEPT:
Fri Nov 29 11:53:44 2002: DEBUG: Access accepted for xxxxxx
Fri Nov 29 11:53:44 2002: DEBUG: Packet dump:
*** Sending to 192.168.1.28 port 1097 ....
Code:       Access-Accept
Identifier: 190
Authentic:  <edited out>
Attributes:
        Framed-IP-Address = 192.168.1.177
        Class = "xxxxxxx.yyy"
        Framed-IP-Netmask = 255.255.255.240

---------

Thanks for any help ...


-- 
Best regards,

Tony Hunter
===
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.