(RADIATOR) Disabling ReclaimQuery
Moon Kwang (Products O2)
Kwang.Moon at O2.com
Wed Feb 4 05:54:44 CST 2004
Hi,
I'm trying to disable the ReclaimQuery - but having problems.
I understand that it's possible to do by setting the parameter with an empty
string (http://www.open.com.au/archives/radiator/2001-08/msg00177.html).
I'm using version version 3.8 on a RedHat server (installed as an RPM).
Here's the block of code I'm using.
<AddressAllocator SQL>
Identifier SQLAllocator
DBSource DBI:Oracle:radius
DBUsername xxx
DBAuth xxx
FailureBackoffTime 5
FindQuery select TIME_STAMP, YIADDR from RADPOOL where POOL='%0' and
STATE=0 \
and rownum=1 order by TIME_STAMP asc
AllocateQuery update RADPOOL set STATE=1, TIME_STAMP=%0, EXPIRY=%1,
MSISDN=%{Calling-Station-Id} \
where YIADDR='%3'
ReclaimQuery
</AddressAllocator>
Thanks in advance for your assistance.
Cheers,
Kwang
This email and any attachments may be confidential and the subject of legal
professional privilege. Any disclosure, use, storage or copying of this
email without the consent of the sender is strictly prohibited. Please
notify the sender immediately if you are not the intended recipient and then
delete the email from your inbox and do not disclose the contents to another
person, use, copy or store the information in any medium.
===
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.
More information about the radiator
mailing list