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@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