Apologies for Mr. Peter Nixon and updated sqlippool debug

[Peter Nixon]

So what exactly is the problem. You posted me a debug log. I told you what the 
problem was. If you say that it now works then there is no problem.

If you have ANOTHER problem, then post the debug for it.

The first query is not SUPPOSED to work if the pool_key doesn't exist. I 
CLEARS existing IP leases. Do you have any active leases right now? If not 
why would you be trying to clear them?

Peter

On Tue 26 Sep 2006 15:41, Guilherme Franco wrote:
> Hello,
>
> But how can my first query work if the pool-key was not saved anywhere
> in the database?
>
> When I do the same query without the "where pool_key = something", it
> works:
>
> UPDATE radippool   SET nasipaddress = '', pool_key =
> 0,callingstationid = '',   expiry_time = current_timestamp - interval
> '1' second(1);
>
> 4 rows updated.
>
> SQL> select * from radippool;
>
>         ID POOL_NAME                      NASIPADDRESS
> ---------- ------------------------------ ------------------------------
>         1   FOO
>  NAS_PORT
> ----------
> EXPIRY_TIME
> 26-SEP-06 09.27.54 AM
> ---------------------------------------------------------------------------
> USERNAME
> ---------------------------------------------------------------------------
>----- FRAMEDIPADDRESS
> 192.168.1.1
> POOL_KEY            CALLINGSTATIONID
> ------------------------------
> 0
>
>
> Sorry, in the second query I pasted an old query earlier for you. The
> second query works, it is:
>
> SQL> SELECT framedipaddress FROM radippool   WHERE pool_name = 'FOO'
> AND expiry_time < current_timestamp AND ROWNUM = 1   ORDER BY (select
> username from radippool where username <> ''), (select
> callingstationid from radippool where callingstationid <>
> ''),expiry_time   FOR UPDATE;
>
> FRAMEDIPADDRESS
> ------------------------------
> 192.168.1.1
>
> Thanks.
>
> On 9/26/06, Peter Nixon <listuser at peternixon.net> wrote:
> > On Tue 26 Sep 2006 14:45, Guilherme Franco wrote:
> > > Hi,
> > >
> > > This is what happens:
> > >
> > > SQL> UPDATE radippool   SET nasipaddress = '', pool_key =
> > > 0,callingstationid = '',   expiry_time = current_timestamp - interval
> > > '1' second(1)   WHERE pool_key = '2398432';
> > >
> > > 0 rows updated.
> > >
> > > SQL> SELECT framedipaddress FROM radippool   WHERE pool_name = 'FOO'
> > > AND expiry_time < current_timestamp AND ROWNUM = 1   ORDER BY (select
> > > username from radippool where username <> ''), (select
> > > callingstationid from radippool where callingstationid <>
> > > ''),expiry_time   FOR UPDATE;
> > >
> > > no rows selected
> >
> > So there you go. You found the problem.. Why doesn't it find any rows?
> >
> > --
> >
> > Peter Nixon
> > http://www.peternixon.net/
> > PGP Key: http://www.peternixon.net/public.asc
> >
> >
> > -
> > List info/subscribe/unsubscribe? See
> > http://www.freeradius.org/list/users.html
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html

-- 

Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20060926/d3241901/attachment.pgp>