2012-02-18 - [GRASE-Hotspot] #60: Recurring limits don’t work for first login of the day

Header Data

From: GRASE Trac <tr***c@grasehotspot.org>
Message Hash: a7332c1a2b5150560aed677da8412fc684f277b7a1e9a5e2f973ff5c07f9792a
Message ID: <039.9bb9867751af0cacd5a91c4d7090a207@grasehotspot.org>
Reply To: N/A
UTC Datetime: 2012-02-18 22:45:07 UTC
Raw Date: Sun, 19 Feb 2012 05:45:07 -0000

Raw message 

#60: Recurring limits don't work for first login of the day
------------------------------------+-----------------
 Reporter:  tim                     |      Owner:  tim
     Type:  defect                  |     Status:  new
 Priority:  critical                |  Milestone:  3.8
Component:  Other Backend           |    Version:  3.6
 Keywords:  freeradius, sqlcounter  |
------------------------------------+-----------------
 The SQL for rlm_sqlcounter may treat NULL as 0 on some arch's. On arm (x86
 currently untested) it treats NULL as NULL, and so the SQL to set the
 Session-Timeout based on user/group recurring limits, fails.
 We need to surround the SUM with an IFNULL (or the alternative we can use,
 coalesce) so it returns 0 instead of NULL

-- 
Ticket URL: <http://trac.grasehotspot.org/ticket/60>
GRASE Hotspot <http://grasehotspot.org/>
GRASE Hotspot bug tracker

Thread