(RADIATOR) FW: Disabling ReclaimQuery

[Matthew Trout]

On Wed, Feb 04, 2004 at 12:00:36PM -0000, Moon Kwang (Products O2) wrote:
> Forgot to include the error messages in my last post - this is what I'm
> getting...
> 
> On the command line when radiusd is invoked:
> DBD::Oracle::db do failed: ORA-24373: invalid length specified for statement
> (DBD ERROR: OCIStmtPrepare) [for Statement ""] at
> /usr/local/ActivePerl-5.8/lib/site_perl/Radius/SqlDb.pm line 220, <FILE>
> line 46
> 
> And in the LogFile:
> Wed Feb  4 11:40:42 2004: DEBUG: Reclaiming expired leases
> Wed Feb  4 11:40:42 2004: DEBUG: do query is: '':
> 
> Wed Feb  4 11:40:42 2004: ERR: do failed for '': ORA-24373: invalid length
> specified for statement (DBD ERROR: CIStmtPrepare)

Try using a no-op query instead, e.g. UPDATE foo SET foo = 0 WHERE 0 = 1

(with a dummy table "foo" with a single column "foo" and no rows)

> 
> 
> -----Original Message-----
> From: Moon Kwang (Products O2) 
> Sent: 04 February 2004 11:55
> To: 'radiator at open.com.au'
> Subject: Disabling ReclaimQuery
> 
> 
> 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.

-- 
Matt S Trout
Network Programmer
Business Serve plc
===
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.