dumb humble question about sqlippool

[Guilherme Franco]

Thank you very much for your kindness.

I'm sorry, again, for posting too much questions about this.

It's correct that I'm trying to put this in production as this is the
only module that does not worked for me.

I'm happy with dialup_admin, AAA and everything else in Oracle!

The only missing thing is sqlippool :(

I know that it is an experimental module and I also have limited time
to work on this module as it's not for me, it's for another company.

In the mean time, I'm using regular ippool db in a NFS with just 1
radius active per time (to prevent lockups). That was the only way
I've managed to do ippools with 2 servers (is there any
alternatives?).

As you see I can't abandon oracle, nor install postgre as it would
break up some dependencies with other oracle databases that we have.

I'm being such a pain for you guys because the sqlippool module is
almost working! If I saw that it wouldn't work at all, I would never
took the time to work in it as I'm taking now :)

I appreciate your concerns and as I'm out of time to deliver the
solution to the client, I think I can't try sqlippool anymore.

That's a shame because I'm almost there!

Now that I've managed to change somethings it's doing all the selects
without any errors (that return ie: ip 1.1.1.1 in sqlplus) but it's
stating sqlippool_query1: row[0] returned NULL in radiusd -X ( how can
it be null if the select was successful? ). It's the only $!*!@! thing
that is preventing the user to get an IP!! That kind of things just
take time to debug...

Besides that, if I don't set pool_name = "name_of_the_pool" in
sqlippool.conf, allocate-find tries to select from "ippool" (wich does
not exists) instead of the one I've set in radippool table.

Other issue is related to multiple pools, one with dynamic IP's and
other with fixed ones (actually it's not possible to do that with only
just one sqlippool.conf file without modifying rlm_sqlippool.c).

Another thing lies in proxy -> if the proxy returns IP 255.255.255.254
for me, sqlippool does not overrides it and do nothing (it doesn't
have the override = yes option like ippool).

So, to close this out, I would REALLY LIKE to make this work and help
you guys  as well, but because of lack of time, the only way would do
this as an enhancement to the already deployed solution for the
client, thanks.

Thank you again!

On 9/28/06, Peter Nixon <listuser at peternixon.net> wrote:
> On Wed 27 Sep 2006 16:41, Guilherme Franco wrote:
> > Hi,
> >
> > I know you guys must be angry with all the questions I'm posting here.
> >
> > In Devel-List, I found this: "Is it usefull to community? (SQLIPPOOL
> > and NASCATS)" by Roman M. Bibikov on Thu, 16 Oct 2003 17:36:26 +1100.
> >
> > He says that created a sucessfull ip pool in Oracle (exactly what I'm
> > trying to do) and also that developed stored functions and procedures
> > handling in rlm_oracle (sql_runfunction() and sql_runprocedure())
> >
> > I didn't found out those functions and I'm wondering if it's because
> > of this that I can't make sqlippool work in oracle...
>
> Hi Guilherme
>
> We are not angry. We are however busy, and have limited time.
>
> Any posts you see about sqlippool prior to August 2006 do not directly relate
> to the sqlippool module that is in FreeRADIUS 1.1.3 (Although it may share
> some code.. There have been several different modules available on the net
> called sqlippool prior to the one that is now available as part of
> FreeRADIUS)
>
> The code in CVS head has been modified even futher (as you know). sqlippool is
> an EXPERIMENTAL module which is why it is not enabled by default. It is
> currently tested ONLY on Postgresql. There are currently no _known_
> production deployments of (our) sqlippool on Oracle although we are happy
> that you are testing it and appreciate your feedback.
>
> Currently you are writing many emails to the list with "CRITICAL/URGENT etc"
> in the subject in relation to sqlippool and you are clearly trying to deploy
> it for production use. I have very clearly told you previously these issues
> and you KNOW that it is an experimental module!!
>
> We are trying to help you as much as we can, but we expect you to also be
> prepared to do testing and possibly some development yourself, otherwise
> please dont use EXPERIMENTAL modules, especially not in production!
>
> If you wish to have my company (Suntel Communications) develop, test and
> support this module for/on an Oracle version of your choice then we would be
> happy to do so for a fee (which we can discuss offlist without bothering
> everyone else) otherwise you will have to make do with the (free) support we
> are providing to you and everyone else via this mailing list in our spare
> time.
>
> Alternatively there is a list of other companies/people who would also be
> happy to provide you support at http://www.freeradius.org/business/
>
> Regards
>
> --
>
> 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
>
>
>