Hello Pavel -
You would normally just have a list of addresses seperated by commas in the
FramedGroupBaseAddress column in the database. Ie - 1.1.10.0, 1.1.20.0 for
Client 1.1.1.1, and 2.2.10.0, 2.2.20.0 for Client 2.2.2.2.
The problems you have below are because the values for FramedGroupBaseAddress
in the Clients are being overwritten.
In any case, Radiator 2.16.1 has a much superiour mechanism for allocating IP
addresses with the AuthBy DYNADDRESS and AddressAllocator SQL constructs.
hth
Hugh
On Tue, 25 Jul 2000, Pavel A. Crasotin wrote:
> 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.
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
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.
