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
SQL>
Thank you.
On 9/26/06, Peter Nixon <[EMAIL PROTECTED]> wrote:
On Tue 26 Sep 2006 00:49, Guilherme Franco wrote:
> Mr. Nixon,
>
> Please accept my humble apologies for the earlier spam.
>
> I would like to test your experimental module sqlippool in Oracle and
> in return, contribute somehow with my working configs and tables to
> the CVS.
>
> I understand that you are a busy man, so please excuse me if I did bother
> you.
>
> This question is not directed only to you but I'm asking it because
> module rlm_sqlippool have pnixon ownership. Please correct me with I'm
> wrong.
>
> With all the help from yours and everyone from freeradius-user-list,
> I've managed to make some progress with the sqlippool in Oracle, with
> just one error left.
>
> I'm not a SQL newbie, but I'm struggling to debug that error because I
> can't see the originating query as it is apparently mounted on the fly
> in lib/rlm_sqlippool* objects.
>
> I have C knowledge but didn't discovered what might be causing the
> error in rlm_sqlippool.c.
>
> Currently, I'm using freeradius-snapshot-20060925.
>
> I've compiled it with --enable-developer and ran radiusd -X through gdb.
>
> The error happens even when I'm using the default v1.4 of
> sqlippool.conf, without modifying it:
> ----------------------------------------------------------
> Processing the post-auth section of radiusd.conf
> modcall: entering group post-auth for request 0
> rlm_sql (sql): Reserving sql socket id: 2
> radius_xlat: 'BEGIN'
> BEGIN
> rlm_sql_oracle: execute query failed in sql_query: ORA-06550: line 1,
> column 5: PLS-00103: Encountered the symbol "end-of-file" when
> expecting one of the following: begin case declare exit for goto
> if loop mod null pragma raise return select update while with <an
> identifier> <a double-quoted delimited-identifier> <a bind
> variable> << close current delete fetch lock insert open rollback
> savepoint set sql execute commit forall merge pipe
> rlm_sql_oracle: OCI_SERVER_NORMAL
> sqlippool_command: database query error
> -----------------------------------------------------------
>
> Next is an output of Oracle's compatible version of sqlippool.conf
> that I've made. It works, but the IP from the sql pool does not get
> allocated because of the previous error:
>
> -----------------------------------------------------------
> UPDATE radippool SET nasipaddress = '', pool_key = 0,
> callingstationid = '', expiry_time = current_timestamp - interval
> '1' second(1) WHERE pool_key = '2398432'
> 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
> sqlippool_query1: SQL query did not succeed
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
What happens when you run this query manually?
--
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
