(RADIATOR) <AddressAllocatorSQL>

[Harrison Ng]

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>> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20010823/d7db10eb/attachment.html>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: radius.proxy.txt
URL: <http://www.open.com.au/pipermail/radiator/attachments/20010823/d7db10eb/attachment.txt>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: radius.server.txt
URL: <http://www.open.com.au/pipermail/radiator/attachments/20010823/d7db10eb/attachment-0001.txt>