Re: Apologies for Mr. Peter Nixon and updated sqlippool debug

2006-09-26 Thread Guilherme Franco
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_

Re: Apologies for Mr. Peter Nixon and updated sqlippool debug

2006-09-26 Thread 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_qu

Re: Apologies for Mr. Peter Nixon and updated sqlippool debug

2006-09-26 Thread 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

Re: Apologies for Mr. Peter Nixon and updated sqlippool debug

2006-09-26 Thread Guilherme Franco
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

Re: Apologies for Mr. Peter Nixon and updated sqlippool debug

2006-09-26 Thread Peter Nixon
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 f

Re: Apologies for Mr. Peter Nixon and updated sqlippool debug

2006-09-26 Thread 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

Apologies for Mr. Peter Nixon and updated sqlippool debug

2006-09-25 Thread Guilherme Franco
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. T