Counter attribute Daily-Session-Time MUST be integer64
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"
On Jun 21, 2017, at 2:16 AM, akash@arrownet.com.np wrote:
I am getting following issue.
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked Creating attribute SQL-Group ... /etc/raddb/mods-enabled/sqlcounter[41]: Counter attribute MUST be integer64 /etc/raddb/mods-enabled/sqlcounter[41]: Instantiation failed for module "dailycounter"
Which version are you using? Also, the Daily-Session-Time attribute is NOT in the dictionaries. Instead, it's created by the module on the fly. So if Daily-Session-Time has the wrong data type, it's because someone edited the configuration files and added it, with the wrong type. Don't do that. Alan DeKok.
participants (2)
-
akash＠arrownet.com.np -
Alan DeKok