Apologies for Mr. Peter Nixon and updated sqlippool debug

[Peter Nixon]

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
-------------- 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/02590bb4/attachment.pgp>