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 <guilhermefranco@gmail.com> 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 <listuser@peternixon.net> 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