Possible Spam : Low Spam probability - : Re: SQL Counter Problem

[Keith Dovale]

Thanks alan, I have tested and it definitely seems to be a problem, the
field is using a varchar(255) in sql I thought this was an issue but it is
not. Is there any way you could rebuild the sqlcounters for freeradius.net ?
have a compiled version already.

I have seen some mention about the sqlcounter being compiled using a traffic
based option and not looking at the session time

Regards

Keith Dovale


-----Original Message-----
From: freeradius-users-bounces+keith=hostworx.co.za at lists.freeradius.org
[mailto:freeradius-users-bounces+keith=hostworx.co.za at lists.freeradius.org]
On Behalf Of Alan DeKok
Sent: Friday, January 11, 2008 2:41 PM
To: FreeRadius users mailing list
Subject: Possible Spam : Low Spam probability - : Re: SQL Counter Problem

Keith Dovale wrote:
> Is there a limitation with the SQLCounter routine using a value above
> 2,148,000,000 in the
> checkfield ? As if I set this value to anything below this figure the
> routine works as planned however if I go above this value it rejects the
> user as no available time.

  The counters are 32 bits, so that is likely the source of the limitation.

> I am trying to use the sqlcounter to check to see if the user has
available
> bandwidth and if so give them access, but this now limits me to this
value.
> I am using the freeradius port for cygwin, can anyone help me out with
this
> as I need to set this figure to above 30Mb value

  30Mb should work.

  If you need 64-bit counters, the code will have to be modified.

  Alan DeKok.
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html