Thanks, that's ok now.
I removed the block as you said and now it shows the queries. I had
added those block earlier because I've seen this configuration from
another post as a working sqlippool configuration...
Now, if netmask does not exist, nor range-start - range-stop, how can
I specify that in radippool?
Please remember that I'm using Oracle and it does not have "inet" like
postgres, so I've created the tables like this:
CREATE TABLE radippool (
id INT PRIMARY KEY,
pool_name VARCHAR(30) NOT NULL,
framedipaddress VARCHAR(30) NOT NULL,
nasipaddress VARCHAR(30) NOT NULL,
nas_port INT NOT NULL,
calling_station_id VARCHAR(30) NOT NULL,
expiry_time timestamp(0) NOT NULL,
username VARCHAR(100)
);
CREATE INDEX radippool_poolname_ipaadr ON radippool (pool_name,
framedipaddress);
CREATE INDEX radippool_poolname_expire ON radippool (pool_name, expiry_time);
CREATE INDEX radippool_nasipaddr_port ON radippool (nas_ip_address, nas_port);
CREATE INDEX radippool_nasipaddr_calling ON radippool (nas_ip_address,
calling_station_id);
CREATE SEQUENCE radippool_seq START WITH 1 INCREMENT BY 1;
CREATE OR REPLACE TRIGGER radippool_serialnumber
BEFORE INSERT OR UPDATE OF id ON radippool
FOR EACH ROW
BEGIN
if ( :new.id = 0 or :new.id is null ) then
SELECT radippool_seq.nextval into :new.id from dual;
end if;
END;
/
How can I use this, please?
Sorry for bothering about everything, but everytime I have a question,
I first search through the entire freeradius maillist, man pages, docs
as well as thoroughly in google. The problem is that usually I don't
find much information about those things, so I come back here to ask.
Thanks a lot!
On 9/20/06, Tuyan Ozipek <[EMAIL PROTECTED]> wrote:
On Wed, 2006-09-20 at 14:14 -0300, Guilherme Franco wrote:
> 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 manuallyThe following is in my radiusd.conf:
$INCLUDE ${confdir}/sqlippool.conf
get rid of this block, since there is no need for
range,netmask,cache-size,override,timeout...
in sqlipoool..
---------------------------------------------------
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
}
----------------------------------------------------
you are missing the first pools trace in the messages and
all youre seeing is the misconfiguration on the second sqlippool
instance..
just keep the $INCLUDE directive, and remove the rest..
there is already an ippool configured in the sqlippool.conf file..
Cheers
Tuyan
> 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
> >
> >
> >
--
Tuyan Ozipek <[EMAIL PROTECTED]>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
