Apologies for Mr. Peter Nixon and updated sqlippool debug

[Guilherme Franco]

Sorry if I did not made myself clear.

Because of the very first problem, I think:

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

As a result, it DOES NOT assign an IP to the user:

rlm_sqlippool: ip=[ ] len=0
radius_xlat:  'COMMIT'
COMMIT
rlm_sqlippool: IP number could not be allocated.
rlm_sql (sql): Released sql socket id: 2
rlm_sql (sql): Processing sql_postauth
radius_xlat:  'test_user2'
rlm_sql (sql): sql_set_user escaped user --> 'test_user2'
modcall: group post-auth returns noop for request 0
Sending Access-Accept of id 44 to 172.16.4.1 port 2243
Finished request 0


The access is accepted but without an IP.


That's the problem.

Thank you very much.

On 9/26/06, Peter Nixon <listuser at peternixon.net> wrote:
> 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
>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
>
>