UPDATED: dumb humble question about sqlippool

Peter Nixon listuser at peternixon.net
Tue Oct 3 19:52:43 CEST 2006


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
-------------- 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/20061003/d6953661/attachment.pgp>


More information about the Freeradius-Users mailing list