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-St
ation-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: owner-radiator at open.com.au [mailto:owner-radiator at open.com.au]On
Behalf Of Sam Cheung
Sent: Tuesday, December 18, 2001 3:06 PM
To: radiator at open.com.au; radmin at open.com.au; nets at open.com.au;
dts at open.com.au; subs at open.com.au; piratecheck at open.com.au
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
  

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20011218/2e0c575f/attachment.html>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: InterScan_Disclaimer.txt
URL: <http://www.open.com.au/pipermail/radiator/attachments/20011218/2e0c575f/attachment.txt>