Apologies for Mr. Peter Nixon and updated sqlippool debug
Peter Nixon
listuser at peternixon.net
Tue Sep 26 14:23:25 CEST 2006
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
-------------- 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/11c1f4b9/attachment.pgp>
More information about the Freeradius-Users
mailing list