Counter attribute Daily-Session-Time MUST be integer64
    akash at arrownet.com.np 
    akash at arrownet.com.np
       
    Wed Jun 21 08:16:46 CEST 2017
    
    
  
 
I am getting following issue. 
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and
linked
Creating attribute SQL-Group
 # Loaded module rlm_sqlcounter
 # Loading module "dailycounter" from file
/etc/raddb/mods-enabled/sqlcounter
 sqlcounter dailycounter {
 sql_module_instance = "sql"
 key = "User-Name"
 query = "SELECT SUM(acctsessiontime - GREATEST((%%b -
UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username =
'%{User-Name}' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime >
'%%b'"
 reset = "daily"
 counter_name = "Daily-Session-Time"
 check_name = "Max-Daily-Session"
 reply_name = "Session-Timeout"
 }
/etc/raddb/mods-enabled/sqlcounter[41]: Counter attribute
Daily-Session-Time MUST be integer64
/etc/raddb/mods-enabled/sqlcounter[41]: Instantiation failed for module
"dailycounter"
 
    
    
More information about the Freeradius-Users
mailing list