Hello Ingvar -
What exactly do you mean by "multiple Radiator threads"?
I have also copied this mail to Mike for additional comments.
regards
Hugh
On Monday, Sep 1, 2003, at 22:24 Australia/Melbourne, Ingvar Bjarnason wrote:
Hi all,
I�m currently running into problems with <AddressAllocator SQL>. When
running multiple Radiator threads and since there is no locking taking place
between the select and allocatequery the threads are "bumping" into each
other selecting and trying to allocate the same ip addresses for different
clients. This significantly slows down processing. Is there a way to
make <AddressAllocator SQL> lock the tables during processing ?
Here is our Addressallocator clause.
<AddressAllocator SQL>
Identifier adsldhcpallocator
DBSource dbi:mysql:radius:192.168.1.1
DBUsername ******
DBAuth *****
Timeout 10
FailureBackoffTime 120
DefaultLeasePeriod 8640000
LeaseReclaimInterval 8640000
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='%w' where YIADDR='%3' and STATE=0 and TIME_STAMP %4
<AddressPool ADSL>
Subnetmask 255.255.255.255
Range *********************
</AddressPool>
</AddressAllocator>
Best regards, Ingvar
Ingvar Bjarnason Engineer Data Net Iceland Telecom
=== Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
NB: have you included a copy of your configuration file (no secrets), together with a trace 4 debug showing what is happening?
-- Radiator: the most portable, flexible and configurable RADIUS server anywhere. Available on *NIX, *BSD, Windows, 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
