Problem with the sqlcounter!
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' I don't know if I have make any syntax error! Thanks for your attention and time!
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
Can you send all debug output ? Thanks RM -- On Thu, Oct 2, 2014 at 11:08 AM, 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'
I don't know if I have make any syntax error! Thanks for your attention and time!
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (3)
-
Arran Cudbard-Bell -
Haviaras Kostas -
Russell Mike