I need to thank you again and congratulate you guys for such a great support. Question: Even with freeradius-snapshot-20060920.tar.gz I will need to use ./configure --with-modules="rlm_sqlippool"? If all works well, I assume that in radcheck table, the users need to have "Pool-Name := test_pool" right? Thanks a lot. On 9/19/06, Peter Nixon <listuser@peternixon.net> wrote:
On Wed 20 Sep 2006 01:51, Tuyan Ozipek wrote:
Hi everybody, Sorry for not being able to cc to radius-users list. I will be on the list as soon as possible.
Gentlemen,
Thank you very much for lending me your time.
That's ok. Thank you for testing the software...
I'm downloading freeradius-snapshot-20060919.tar.gz right now.
Yes, my allocate-clear is configured exactly as Tuyan's and that's why I stated before that "regardless of my configuration in sqlippool.conf and radiusd.conf" the trace is always empty.
For example, if in sqlippool.conf I set sql-instance-name = "foobar", the output of radiusd -X is always:
Module: Loaded SQL IP Pool sqlippool: sql-instance-name = "sql"
There should be something wrong with your sqlippool.conf file, are you sure you are including the right one from the main radius configuration file? All the variables that we see in your trace, are the default ones.Basically we are putting them in case there is no value set for that variable.. For example : If there is no sql-instance-name set in your sqlippool.conf file, we set it as "sql" internally.
Please double check your include paths for the sqlippool.conf file. Is there any sqlippool { } directives hanging around in your radiusd.conf? Maybe a clean install with ./configure --prefix=/xxx/xxx can help you to find the config problem as well..
My guess is that his problem is caused by the way he built sqlippool:
Well, I've tried to install todays freeradius CVS, and it installed without the sqlippool module, don't know why. So, I've compiled it manually from freeradius-snapshot-20060918/src/modules/rlm_sqlippool/
If he does a clean install from tonight's cvs I think everything will work as expected.
--
Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc
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
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
participants (2)
-
Guilherme Franco -
Peter Nixon