Problem with expire_on_login module and users with large connection periods

Antonio Fernández Pérez antoniofernandez at fabergames.com
Wed Feb 5 11:47:46 CET 2014


Hi list,

Sorry, the last email had subject empty.

I think that there are a mistake in sqlcounter_expire_on_login module with
large uses. I have detected that users with three duration months could
navigate more than three months.
The problem is with the use of TIME_DIFF function that is limited to the
range allowd for TIME's values. By default, TIME's range is '-838:59:59' to
'838:59:59', thirty four days, more or less. So if you have a username of
two months and this uses expre_on_login module, there are a problem!

I have fixed the problem modifying the query on module file: I have
replaced "TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime))" by
"TIMESTAMPDIFF(SECOND,
acctstarttime, NOW())" and now works fine.

Please, let me know if this is a bug in FreeRADIUS or If I have a mistake
in my configuration (In MySQL or FreeRADIUS services).

Thanks in advance.

Regards,

Antonio.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20140205/2330b3dc/attachment.html>


More information about the Freeradius-Users mailing list