sqlippool not working

[Guilherme Franco]

Hello,

Unfortunately, even with  freeradius-snapshot-20060920.tar.gz and
using the ./configure --with-modules="rlm_sqlippool" option, the
module did not install.

I needed again, to compile it manually from
freeradius-snapshot-20060920/src/modules/rlm_sqlippool/

And then, the same problem persists:

Module: Loaded SQL IP Pool
  sqlippool: sql-instance-name = "sql"
  sqlippool: lease-duration = 86400
  sqlippool: pool-name = ""
  sqlippool: allocate-begin = "BEGIN"
  sqlippool: allocate-clear = ""
  sqlippool: allocate-find = ""
  sqlippool: allocate-update = ""
  sqlippool: allocate-commit = "COMMIT"
  sqlippool: allocate-rollback = "ROLLBACK"
  sqlippool: start-begin = "BEGIN"
  sqlippool: start-update = ""
  sqlippool: start-commit = "COMMIT"
  sqlippool: start-rollback = "ROLLBACK"
  sqlippool: alive-begin = "BEGIN"
  sqlippool: alive-update = ""
  sqlippool: alive-commit = "COMMIT"
  sqlippool: alive-rollback = "ROLLBACK"
  sqlippool: stop-begin = "BEGIN"
  sqlippool: stop-clear = ""
  sqlippool: stop-commit = "COMMIT"
  sqlippool: stop-rollback = "ROLLBACK"
  sqlippool: on-begin = "BEGIN"
  sqlippool: on-clear = ""
  sqlippool: on-commit = "COMMIT"
  sqlippool: on-rollback = "ROLLBACK"
  sqlippool: off-begin = "BEGIN"
  sqlippool: off-clear = ""
  sqlippool: off-commit = "COMMIT"
  sqlippool: off-rollback = "ROLLBACK"
rlm_sqlippool: the 'allocate-clear' statement must be set.

The following is in my radiusd.conf:

      $INCLUDE  ${confdir}/sqlippool.conf

        sqlippool foo {

                range-start = 192.168.1.1
                range-stop = 192.168.3.254

                netmask = 255.255.255.0
                cache-size = 800
                override = no
                maximum-timeout = 0
        }

------------------------

I didn't modified my sqlippool.conf, so it's the same as
sqlipool.conf,v 1.3 2006/09/13 12:49:37 pnixon Exp $

What can it be?

Also, what values should I populate in radippool table?

PS. Some things left:
IN configure.in (rlm_sql_oracle)
checking for oci.h... configure: WARNING: PETER XXXXXXXXXXXXXXXX1.

IN oracle-dialup.conf
# Optional Query - pnixon
        #accounting_stop_query =3D

Another issue: with oracle instant_client_10_2, rlm_sql_oracle would
not find it's libs, even when the required paths are configured. The
only way that I managed to install it was copying the whole oracle
folder to the freeradius server. I know that simply a matter of
changing the 10.1.0.3 version and something to the new one in
configure.in of rlm_sql_oracle, but I was in a rush:

# Look for Oracle10g "Instant Client" installed from RPM
        if test "x$ORACLE_INCLUDE" = "x"; then
                old_CFLAGS="$CFLAGS"

        AC_MSG_WARN([PETER XXXXXXXXXXXXXXXX1.])
                FR_LOCATE_DIR(oracle_include_dir,oci.h)
                for try in /usr/include/oracle/10.1.0.3/

THANK YOU!


On 9/20/06, Peter Nixon <listuser at peternixon.net> wrote:
> On Wed 20 Sep 2006 05:49, Guilherme Franco wrote:
> > I need to thank you again and congratulate you guys for such a great
> > support.
>
> You're welcome. Thanks for helping us make FreeRADIUS better :-)
>
> > Question: Even with freeradius-snapshot-20060920.tar.gz I will need to
> > use ./configure --with-modules="rlm_sqlippool"?
>
> Yes. This is because the module is sill considered experimental and is
> therefore not enabled by default.
>
> > If all works well, I assume that in radcheck table, the users need to
> > have "Pool-Name := test_pool" right?
>
> Yes. You need to tell FreeRADIUS which pool (if any) to use for that user.
> With sqlippool there is effectively no limit on the number of pools you may
> have configured (Only limit is disk space on your SQL server and IP space on
> your network)
>
> 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
>
>
>