authorize users ( time + traffic )

[Ilaria De Marinis]

Hi list,
   I'm trying to set authorize section in my default sites file.

  I need to allow traffic users in terms of time and bandwidth.
  So, my attempts were like these:


authorize{
dailycounter

         if (Auth-Type == "Reject") {           #I tried also if(!ok) or 
if (reject)
            update control{
                 Post-Auth-Type := "Access-Accept"
            }
            dailybandwidthcounter
        }
   .....
  }

The control never enters the condition and the dailycounter returns "reject"

Wed Aug 22 13:15:39 2012 : Info: [dailycounter] sql_xlat
Wed Aug 22 13:15:39 2012 : Info: [dailycounter]     expand: %{User-Name} 
-> xxxxxx
Wed Aug 22 13:15:39 2012 : Info: [dailycounter] sql_set_user escaped 
user --> 'xxxxxx'
Wed Aug 22 13:15:39 2012 : Info: [dailycounter]     expand: SELECT 
SUM(acctsessiontime -                  GREATEST((1345586400 - 
UNIX_TIMESTAMP(acctstarttime)), 0))                  FROM radacct WHERE 
username = 'xxxxxx' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime 
 > '1345586400' -> SELECT SUM(acctsessiontime - GREATEST((1345586400 - 
UNIX_TIMESTAMP(acctstarttime)), 0))                  FROM radacct WHERE 
username = 'xxxxxx' AND                  UNIX_TIMESTAMP(acctstarttime) + 
acctsessiontime > '1345586400'
Wed Aug 22 13:15:39 2012 : Debug: rlm_sql (sql): Reserving sql socket id: 11
Wed Aug 22 13:15:39 2012 : Info: [dailycounter] sql_xlat finished
Wed Aug 22 13:15:39 2012 : Debug: rlm_sql (sql): Released sql socket id: 11
Wed Aug 22 13:15:39 2012 : Info: [dailycounter]     expand: %{sql:SELECT 
SUM(acctsessiontime - GREATEST((1345586400 - 
UNIX_TIMESTAMP(acctstarttime)), 0))                  FROM radacct WHERE 
username = 'xxxxxx' AND                  UNIX_TIMESTAMP(acctstarttime) + 
acctsessiontime > '1345586400'} -> 327
Wed Aug 22 13:15:39 2012 : Debug: rlm_sqlcounter: (Check item - counter) 
is less than zero
Wed Aug 22 13:15:39 2012 : Debug: rlm_sqlcounter: Rejected user xxxxxx, 
check_item=180, counter=327
*Wed Aug 22 13:15:39 2012 : Info: ++[dailycounter] returns reject*
Wed Aug 22 13:15:39 2012 : Auth: Invalid user (rlm_sqlcounter: Maximum 
daily usage time reached): [xxxxxx] (from client localhost port 0 cli 
xxxxxx)
Wed Aug 22 13:15:39 2012 : Info: Using Post-Auth-Type Reject


Thank you very much for any help
Regards
Ilaria

-- 
------------------------------------------------
Ilaria De Marinis
Settore Reti e Servizi

CASPUR - Via dei Tizii ,6 - 00185 Roma
e-mail: ilaria.demarinis at caspur.it
------------------------------------------------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20120822/13e3ad9f/attachment-0001.html>