(RADIATOR) <AddressAllocatorSQL>

[Hugh Irvine]

Hello Harrison -

Having more than one Radiator host will not cause a problem.

Note the ReclaimQuery that is run:

> Wed Aug 22 19:22:14 2001: DEBUG: do query is: update RADPOOL set STATE=0
> where state!=0 and EXPIRY < 998479334

This will only reclaim leases that have expired, as configured by the 
DefaultLeasePeriod. This is the correct behaviour.

In any case, you can disable the query in the configuration file by 
specifying an empty string.

Ie:

	ReclaimQuery

hth

Hugh


On Thursday 23 August 2001 20:12, Harrison Ng wrote:

> > Hello,
>
> Is there any way to disable ReclaimQuery during radiator startup.
> Using <AddressAllocatorSQL> on one radius server with one database should
> be fine.
> But not in <AuthBy ROUNDROBIN> environment. Here is our machine
> configuration.
>
> 1. One Ericsson GSN with 2 radius clients. It send access request, a/c
> start, a/c stop to radius proxy using <AuthBy ROUNDROBIN>.
> 2. The proxy will forward those request to two radius server for enhancing
> performance.
> 3. The two radius server use <AddressAllocatorSQL> to reply ip address to
> client. They share a RADPOOL reside in mysql db.
>
> Serious problem arises when either one radius server restart, it will reset
> all ip address STATE to zero. Pls see debug message.
> Even though some ip address is already allocated by another health radius
> server.
> Is anyone have different implementation method.
> Can anyone give me some hint.
> Pls find attached radius.cfg for your reference.
>
>
> Harrison
> SmarTone BroadBand Services Limited
>
>
>
> Wed Aug 22 19:22:11 2001: DEBUG: Reading users file
> /usr/local/etc/raddb/users.accept
> Wed Aug 22 19:22:11 2001: DEBUG: Reading users file
> /usr/local/etc/raddb/users.reject
> Wed Aug 22 19:22:11 2001: DEBUG: Checking address 202.140.74.2
> Wed Aug 22 19:22:11 2001: DEBUG: Query is: select STATE from RADPOOL where
> YIADDR='202.140.74.2'
> ....
> ....
>
> Wed Aug 22 19:22:14 2001: DEBUG: Reclaiming expired leases
> Wed Aug 22 19:22:14 2001: DEBUG: do query is: update RADPOOL set STATE=0
> where state!=0 and EXPIRY < 998479334
>
> Wed Aug 22 19:22:14 2001: INFO: Server started: Radiator 2.18.2 on grad1
> Wed Aug 22 19:22:14 2001: DEBUG: Packet dump:
> *** Received from 10.25.157.17 port 1033 ....
> Code:       Access-Request
> ....
> ....
>
>
>
>  <<radius.proxy.txt>>
>
>  <<radius.server.txt>>

----------------------------------------
Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 
----------------------------------------

----------------------------------------
Content-Type: text/plain; charset="iso-8859-1"; name="radius.proxy.txt"
Content-Transfer-Encoding: 7bit
Content-Description: 
----------------------------------------

----------------------------------------
Content-Type: text/plain; charset="iso-8859-1"; name="radius.server.txt"
Content-Transfer-Encoding: quoted-printable
Content-Description: 
----------------------------------------

-- 
Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
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.