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@caspur.it
------------------------------------------------