(RADIATOR) FW: Disabling ReclaimQuery

[Ingvar Bjarnason]

Hi Moon,

    We simply use  (in MySQL)

        ReclaimQuery  select database()

    as the reclaim query.   It´s a simple harmless query that does nothing
but return the database in use;

In Oracle you could use

        ReclaimQuery  select sysdate from dual

Which gives you output like below:

SQL> select sysdate from dual;

SYSDATE
---------------
04-FEB-04

In other words does nothing ;-)

Best regards,

Ingvar Bjarnason
Senior Engineer
Data Networks

Iceland Telecom
Ármúla 25 - 108 Reykjavík
Tel +354 550-7478 - Fax +354 511-7070
Email:  ingvarbj at simi.is
www:  http://siminn.is

----- Original Message ----- 
From: "Matthew Trout" <matthewtrout at businessserve.co.uk>
To: "Moon Kwang (Products O2)" <Kwang.Moon at O2.com>
Cc: <radiator at open.com.au>
Sent: Wednesday, February 04, 2004 1:14 PM
Subject: Re: (RADIATOR) FW: Disabling ReclaimQuery


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

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