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 <[EMAIL PROTECTED]> 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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
