On Tue 03 Jul 2007, Dave wrote:
> Hugh Messenger wrote:
> > Dave <[EMAIL PROTECTED]> said:
> >> I use the sqlippool setup for handling IP pools, and it works well,
> >> except I want to rid of the expiry time, (maximum timeout=0). right now
> >> its setting for 24 hours, and then it cleans itself out, and then
> >> freeradius starts handing out already assigned/used IP addresses. Im
> >> not sure where to put the maximum timeout=0 value when using sqlippool.
> >
> > That shouldn't happen, regardless of the expiry time. The expiry_time
> > value in the radippool entries is derived from the 'lease-duraction' set
> > in sqlippool.conf. But the expiry_time should only affect clearing
> > unique sessions which have gotten "stuck" (like for lost 'stop'
> > packets). It shouldn't just start handing out in-use IP's based on
> > expiry time.
> >
> > What do you have $pool-key set to in sqlippool.conf? And are you sure
> > whatever value you are using (usually either NAS-Port or
> > Calling-Station-Id) is a unique value from the NAS?
>
> I have pool-key = "%{Calling-Station-Id}", which I just realized is not
> always unique, (NAS is returning MAC address for Calling station ID, which
> if passing thru one of my bridge devices always returns the MAC address of
> the ethernet bridge)
Yep. That would cause havoc. Use pool-key = "%{NAS-Port}" unless you have a
very good reason not to!
> > What flavor of db do you have - postgres or mysql? They use different
> > configs, and depending where you got the query file from, you may have
> > an earlier broken version (especially if you are using MySQL).
> >
> > What version of freeradius are you running?
>
> Im using mysql, and I believe I have a working version of
> sqlippool.conf, Ill paste it here. Freeradius 1.1.6
-snip-
Hugh recently spent quite some effort sending and testing patches for
rlm_sqlippool with MySQL. They are in cvs head as of a few days ago. As
always, I recommend sqlippool users run 2.0preX or cvs head as we have made
a lot of changed since 1.1.x which have not been backported.
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
