Yes. That is the way we handle it also :-) -Peter
On Wed 04 Oct 2006 02:45, Guilherme Franco wrote: > Nevermind the proxy issue, I've managed to circumvent it using attrs file > > Thanks > > On 10/3/06, Guilherme Franco <[EMAIL PROTECTED]> wrote: > > Mr. Peter, > > > > Thanks, I was using "sql_instance2{...}" instead of "sql > > sql_instance2{...}" > > > > :) > > > > Everything is working nice now with this hybrid oracle/postgresql > > except when I'm proxying and sqlippool won't set an IP because of > > 255.255.255.254 answer from the proxy server. > > > > As we talked earlier, there's no override = yes for this so I need to > > put "Pool-Name := FOO" in radreply, but even with the reply, it > > doesn't work. What I'm doing is convince the proxy ISP to change it's > > conf so it don't send me 255.255.255.254 for now. > > > > I have to thank you again for all your help! Now it's my turn to > > contribute, as soon as I have the time to look for, I hope to patch > > rlm_sqlippool.c and CVS it along with oracle.sqlippool.conf and > > radippool schema for oracle. > > > > Greetings > > > > On 10/3/06, Peter Nixon <[EMAIL PROTECTED]> wrote: > > > On Tue 03 Oct 2006 19:29, Guilherme Franco wrote: > > > > Hello, > > > > > > > > I've installed Postgres with exactly the same configuration as > > > > Oracle's and Postgres works. > > > > > > Good. > > > > > > > The only point of failure using Oracle should be in radippool > > > > Framedipaddress which is VARCHAR in Oracle but is INET in Postgres. > > > > > > > > Could be a parsing error in rlm_sqlippool.c > > > > > > Hmm. It could be. Patches to fix it are welcome :-) > > > > > > > That's because xlat outputs: > > > > --------------------------------------------- > > > > 'SELECT framedipaddress FROM (select framedipaddress from radippool > > > > WHERE pool_name = 'SPW' ORDER BY dbms_random.value) where rownum = 1' > > > > sqlippool_query1: row[0] returned NULL > > > > rlm_sqlippool: ip=[] len=0 > > > > radius_xlat: 'COMMIT' > > > > rlm_sqlippool: IP number could not be allocated. > > > > --------------------------------------------- > > > > > > > > The same query on sqlplus is ok: > > > > SQL> SELECT framedipaddress FROM (select framedipaddress from > > > > radippool WHERE pool_name = 'SPW' ORDER BY dbms_random.value) where > > > > rownum = 1; > > > > > > > > FRAMEDIPADDRESS > > > > ------------------------------ > > > > 192.168.1.3 > > > > > > > > Now, considering that Postgres works like a breeze, how can I setup > > > > just sqlippool.conf to look in postgres, but the regular user and > > > > password queries to look in oracle? > > > > > > > > I've created a sql.conf containing oracle's confs (sql{..}) and > > > > sql2.conf containing postgres confs (sql2{...}). > > > > > > > > If I specify sql-instance-name = "sql2" in sqlippool.conf it does not > > > > works. > > > > > > http://wiki.freeradius.org/Rlm_sql#Instances > > > > > > Just give your instances different names as the documentation says. > > > > > > > I appreciate any help on this issue. Thanks! > > > > > > Cheers > > > > > > -- > > > > > > 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
pgp0fsaRXAHc5.pgp
Description: PGP signature
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html