On 2 Oct 2014, at 12:08, Haviaras Kostas <koshalirod@gmail.com> wrote:
Hello, I have configure my FreeRadius to work with MySQL, I also add the sqlcounter to count the hours user after the first login. Here is my code: mods-enabled/sqlcounter:
sqlcounter checkthetime { sql_module_instance = sql dialect = ${modules.sql.dialect}
counter_name = All-Hours-Passed check_name = Max-Hours-Passed reply_name = Session-Timeout key = User-Name reset = never
$INCLUDE ${modconfdir}/sql/counter/${dialect}/${.:instance}.conf }
checkthetime.conf:
query = "\ SELECT HOUR(SEC_TO_TIME(UNIX_TIMESTAMP() - UNIX_TIMESTAMP(AcctStartTime))) \ FROM radacct \ WHERE UserName = '%{${key}}' LIMIT 1;"
sites-available/default:
authorize { ....
sql checkthetime .... }
I am getting this message from the debug mode:
(0) WARNING: checkthetime : Couldn't find control attribute 'control:Max-Hours-Passed'
Hm I guess that should be Couldn't find check attribute 'control:Max-Hours-Passed' but still the message is pretty clear... You've not set the check item in the sql db 'Max-Hours-passed'. -Arran Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS development team FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2