sqlippool not working
Guilherme Franco
guilhermefranco at gmail.com
Wed Sep 20 22:32:21 CEST 2006
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 <tuyan at suntel.com.tr> 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 <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
> > >
> > >
> > >
> --
> Tuyan Ozipek <tuyan at suntel.com.tr>
>
>
More information about the Freeradius-Users
mailing list