FW: (RADIATOR) Re: Please help.

[Harrison Ng]

Sam,

 

For IP address allocation in Radiator, use <AuthBy DYNADDRESS> and <AddressAllocator SQL>.

Below is an example of radius.cfg.

 

Regards,

Harrison

 

 

 

<AddressAllocator SQL>

 

        Identifier myallocator

 

        DBSource dbi:mysql:radius:xxx.xxx.xxx.xxx
        DBUsername xyz
        DBAuth xyz

 

        DefaultLeasePeriod 86000
        LeaseReclaimInterval 300

 

        FindQuery select TIME_STAMP,YIADDR,SUBNETMASK,DNSSERVER from RADPOOL where POOL='%0' and STATE=0 order by TIME_STAMP limit 1

 

        AllocateQuery update RADPOOL set STATE=1,TIME_STAMP=%0,EXPIRY=%1,USERNAME='%2',CALLINGSTATIONID='%{Calling-Station-Id}' \
                      where YIADDR='%3' and TIME_STAMP%4

 

        <AddressPool trial1>
                Subnetmask 255.255.255.0
                Range xxx.xxx.xxx.xxx yyy.yyy.yyy.yyy

        </AddressPool>

 

        <AddressPool trial2>
                Subnetmask 255.255.255.0
                Range xxx.xxx.xxx.xxx yyy.yyy.yyy.yyy

        </AddressPool>

 

</AddressAllocator SQL>

 

 

<Handler Client-Id = x.x.x.x>

 

        AuthBy xxx

        AuthBy yyy

 

        <AuthBy DYNADDRESS>

 

                Allocator myallocator
                PoolHint %{Reply:PoolHint}
                MapAttribute yiaddr, Framed-IP-Address
                MapAttribute subnetmask, Framed-IP-Netmask
                StripFromReply PoolHint
                StripFromReply Framed-IP-Netmask
                AddToReplyIfNotExist Service-Type = Framed-User
                AddToReplyIfNotExist Framed-Protocol = PPP

 

        </AuthBy DYNADDRESS>

 

</Handler>

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sam Cheung
Sent: Tuesday, December 18, 2001 3:06 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: (RADIATOR) Re: Please help.

Dear Genius,
 

I am trying to config. a radiator (2.19-demo) allocating IP address dynamically
using DB1 to get the authentication info. from DB1 (an mysql server stored username
and password) and using DB2 (another mysql server) to log the dhcp client info.,
DHCP pool and leased IP, etc. using the database which created by a script called
mysqlCreate.sql. Can you give me some suggestion what to put down in the config.cfg?
Thanks so much for paying attention. Thanks a lot.

----
Best Regards,
Sam Cheung

 

* This Email is virus-scanned and identified clean.