Hello all
I have problems with ClientsListSQL.
For example, I have 2 NASes each of which has more 2 FramedGroupBaseAddress.
So I've put in the RADCLIENT table the following:
insert into RADCLIENT (NASIDENTIFIER,SECRET,FramedGroupBaseAddress)
values ('1.1.1.1','secret1','1.1.10.0');
insert into RADCLIENT (NASIDENTIFIER,SECRET,FramedGroupBaseAddress)
values ('1.1.1.1','secret1','1.1.20.0');
insert into RADCLIENT (NASIDENTIFIER,SECRET,FramedGroupBaseAddress)
values ('2.2.2.2','secret2','2.2.10.0');
insert into RADCLIENT (NASIDENTIFIER,SECRET,FramedGroupBaseAddress)
values ('2.2.2.2','secret2','2.2.20.0');
Then I have configured the ClientListSQL clause
<ClientListSQL>
DBSource dbi:Oracle:xxxxxxx
DBUsername xxxxxx
DBAuth xxxxxx
GetClientQuery SELECT NASIDENTIFIER, SECRET, NULL, NULL, NULL, \
NULL, NULL, NULL, NULL,
FramedGroupBaseAddress \
FROM RADCLIENT
ORDER BY NASIDENTIFIER, FramedGroupBaseAddress
</ClientLisrSQL>
I expect that '1.1.20.0' has Framed-Group number 1.
But when I put Framed-Group=1 in reply items and try to access from NAS 1.1.1.1 I get
>Tue Jul 25 09:36:16 2000: DEBUG: Radius::AuthPLSQL looks for match with testuser
>Tue Jul 25 09:36:16 2000: DEBUG: Radius::AuthPLSQL ACCEPT:
>Tue Jul 25 09:36:16 2000: DEBUG: FramedGroup 1 address is being assigned
>Tue Jul 25 09:36:16 2000: WARNING: There is no FramedGroupBaseAddress defined for a
>Framed-Group of 1. No address will
be allocated
>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>Tue Jul 25 09:36:16 2000: DEBUG: Access accepted for testuser
Furthermore if I assign 0 to Framed-Group Radiator tells me
>Tue Jul 25 09:58:57 2000: DEBUG: Radius::AuthPLSQL looks for match with testuser
>Tue Jul 25 09:58:57 2000: DEBUG: Radius::AuthPLSQL ACCEPT:
>Tue Jul 25 09:58:57 2000: DEBUG: FramedGroup 0 address is being assigned
>Tue Jul 25 09:58:57 2000: DEBUG: Access accepted for testuser
>Tue Jul 25 09:58:57 2000: DEBUG: Packet dump:
>*** Sending to a.b.c.d port 34391 ....
>Code: Access-Accept
>Identifier: 132
>Authentic: 1234567890123456
>Attributes:
> Framed-Protocol = PPP
> Service-Type = Framed-User
> Framed-IP-Netmask = 255.255.255.255
> Framed-MTU = 1500
> Framed-Compression = Van-Jacobson-TCP-IP
> Framed-IP-Address = 2.2.20.5
??????????????????????????^^^^^^^^^^^
But why not 1.1.10.5?
I think it is mistake in Radiator code?
Or may be I do something wrong...
With respect,
Pavel A. Crasotin
____________________________________
Open Joint-Stock Company SeverTransCom
40/13 Sobinova Yaroslavl Russia 150000
Tel/Fax: +7 (0852) 72-17-28, 72-17-38
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
