Thanks,
I used that broken config because it was stated in freeradius user
list as "Sucsessfully installed rlm_sqlippool" from Alfred H. Dahl in
Tue, 8 Feb 2005 20:58:34 +0100.
I did read the docs.
I only didn't know how could I specify 192.168.1.1/28, if I do not
have inet, but that's ok.
Thanks everybody, I'm going to test all until it works now!
Case closed, thanks.
On 9/20/06, Peter Nixon <[EMAIL PROTECTED]> wrote:
On Wed 20 Sep 2006 23:32, Guilherme Franco wrote:
> 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...
OK. Well, if you had just used the existing config files instead of adding
your own broken config it would have worked all along :-)
> Now, if netmask does not exist, nor range-start - range-stop, how can
> I specify that in radippool?
You do not! As "doc/rlm_sqlippool" states:
The initialization of the radippool table is left to the user instead of
being handled inside the module. This allows pool management to be done
from any sql capable programming language and pools can be created,
resized, deleted at run time without radiusd needing to be restarted.
The only required fields are, pool_name and ip_address. A pool consists
of one or more rows in the table with the same pool_name and a different
ip_address. The is no restriction on which ip addresses/ranges may be in
the same pool, and addresses do not need to be concurrent.
The fact that you are asking this means that you did NOT read the docs :-)
> Please remember that I'm using Oracle and it does not have "inet" like
> postgres, so I've created the tables like this:
You are going to have to work out the oracle specifics yourself but the
structure you have looks ok to me. The INET type is not necessary, although
it IS more efficient.
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
