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