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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html