lists.freeradius.org
Sign In Sign Up
Manage this list Sign In Sign Up

Keyboard Shortcuts

Thread View

  • j: Next unread message
  • k: Previous unread message
  • j a: Jump to all threads
  • j l: Jump to MailingList overview
thread

Antonio Fernández Pérez

5 Feb 2014 5 Feb '14
5:27 a.m.

Hi list, 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.

Attachments:

  • attachment.html (text/html — 1.1 KB)
0 0
Reply
Sign in to reply online Use email software

Back to the thread

Back to the list

HyperKitty Powered by HyperKitty version 1.3.12.