On Mon 09 Jul 2007, Hugh Messenger wrote:
> On Behalf Of Dave said:
> > Yes accounting is working well from the NAS
>
> Are you sure the NAS is sending 'interim update' accounting packets, not
> just start/stop?
>
> Here's my understanding of how it works (I'm sure Peter will correct me if
> I'm wr
Peter Nixon wrote:
> Great. Looks like rlm_sqlippool is ready to take over the world :-)
My latest tests look promising. Stock clients work.
No, there's no secret agenda. The agenda is public, but the
implementation details are secret.
Alan DeKok.
-
List info/subscribe/unsubscribe? See
On Wed 11 Jul 2007, Hugh Messenger wrote:
> Peter Nixon said:
> > > I take that back. It seems like a good idea, but that will break
> > > things for ISPs who have multiple NAS in failover or OSPF groups and
> > > therefore can happily assign the same IP to the same user even if they
> > > are
> >
Peter Nixon said:
> > I take that back. It seems like a good idea, but that will break things
> > for ISPs who have multiple NAS in failover or OSPF groups and therefore
> > can happily assign the same IP to the same user even if they are
> connected
> > to a different physical NAS.
>
> I changed m
On Wed 11 Jul 2007, Peter Nixon wrote:
> -snip-
>
> > > that wasn't my understanding of how the expiration works in sqlippool.
> > > The 'allocate-clear' query looks like this:
> > >
> > > allocate-clear = "UPDATE radippool \
> > > SET NASIPAddress = '', pool_key = 0, CallingStationId = '', \
> >
-snip-
> > that wasn't my understanding of how the expiration works in sqlippool.
> > The 'allocate-clear' query looks like this:
> >
> > allocate-clear = "UPDATE radippool \
> > SET NASIPAddress = '', pool_key = 0, CallingStationId = '', \
> > expiry_time = NOW() - INTERVAL 1 SECOND \
> > W
You are welcome. I suppose we should update the docs/wiki to make this
clearer..
-Peter
On Wed 11 Jul 2007, Dave wrote:
> To update, turning on interim updates on my NAS, fixed my problem...
> Thanks for all your help.
>
> Peter Nixon wrote:
> > On Tue 10 Jul 2007, Dave wrote:
> >> My NAS is cur
To update, turning on interim updates on my NAS, fixed my problem...
Thanks for all your help.
Peter Nixon wrote:
> On Tue 10 Jul 2007, Dave wrote:
>
>>
>> My NAS is currently NOT sending interm updates, but there is an option
>> to use that, just wasn't sure what it did, or how it would apply
On Tue 10 Jul 2007, Dave wrote:
> Hugh Messenger wrote:
> > On Behalf Of Dave said:
> >> Yes accounting is working well from the NAS
> >
> > Are you sure the NAS is sending 'interim update' accounting packets, not
> > just start/stop?
>
> My NAS is currently NOT sending interm updates, but there is
Hugh Messenger wrote:
> On Behalf Of Dave said:
>
>> Yes accounting is working well from the NAS
>>
>
> Are you sure the NAS is sending 'interim update' accounting packets, not
> just start/stop?
>
>
My NAS is currently NOT sending interm updates, but there is an option
to use that, ju
On Behalf Of Dave said:
> Yes accounting is working well from the NAS
Are you sure the NAS is sending 'interim update' accounting packets, not
just start/stop?
Here's my understanding of how it works (I'm sure Peter will correct me if
I'm wrong!):
On an access request, sqlippool will first check
On Mon 09 Jul 2007, Alan DeKok wrote:
> Peter Nixon wrote:
> >> In other words, it should only be clearing IP's
> >> for which a 'stop' query has gone astray, on the basis that you can't
> >> have more than one connection to an individual NAS port. It certainly
> >> shouldn't just free up all IP's
Peter Nixon wrote:
>> In other words, it should only be clearing IP's
>> for which a 'stop' query has gone astray, on the basis that you can't have
>> more than one connection to an individual NAS port. It certainly
>> shouldn't just free up all IP's based on expiry_time.
>
> Exactly..
Will i
Yes accounting is working well from the NAS
> Are you receiving accounting packets from your NAS?
>
>
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Its posted a few posts back in this thread, that version is still the
one Im using.
>
> Dave - can you copy and paste your sqlippool.conf, so we can see what your
> actual queries look like?
>
>-- hugh
>
>
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On Sun 08 Jul 2007, Hugh Messenger wrote:
> Alan DeKok <[EMAIL PROTECTED]>
>
> > Dave wrote:
> > > Im still having trouble with this problem, I switched the pool key to
> > > NAS port, the expiry time is 24 hours, and it seems after 24 hours, it
> > > wipes all the existing entries from the databas
Alan DeKok <[EMAIL PROTECTED]>
>
> Dave wrote:
> > Im still having trouble with this problem, I switched the pool key to
> > NAS port, the expiry time is 24 hours, and it seems after 24 hours, it
> > wipes all the existing entries from the database,
>
> That would seem to fit the 24-hour expiry
On Sun 08 Jul 2007, Dave wrote:
> Alan DeKok wrote:
> > Dave wrote:
> >> Im still having trouble with this problem, I switched the pool key to
> >> NAS port, the expiry time is 24 hours, and it seems after 24 hours, it
> >> wipes all the existing entries from the database,
> >
> > That would seem
Alan DeKok wrote:
> Dave wrote:
>
>> Im still having trouble with this problem, I switched the pool key to
>> NAS port, the expiry time is 24 hours, and it seems after 24 hours, it
>> wipes all the existing entries from the database,
>>
>
> That would seem to fit the 24-hour expiry time
Dave wrote:
> Im still having trouble with this problem, I switched the pool key to
> NAS port, the expiry time is 24 hours, and it seems after 24 hours, it
> wipes all the existing entries from the database,
That would seem to fit the 24-hour expiry time you set.
> again re-assigning
> IP's
Im still having trouble with this problem, I switched the pool key to
NAS port, the expiry time is 24 hours, and it seems after 24 hours, it
wipes all the existing entries from the database, again re-assigning
IP's that are already in use, these IPs could be used indefinitely by
some customers
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 o
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 han
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
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 p
25 matches
Mail list logo
