UPDATED: dumb humble question about sqlippool

Peter Nixon listuser at peternixon.net
Wed Oct 4 08:22:05 CEST 2006


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 at 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 at 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
-------------- 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/20061004/f31a37b2/attachment.pgp>


More information about the Freeradius-Users mailing list