New Problem with sqlcounter
Haviaras Kostas
koshalirod at gmail.com
Thu Dec 4 13:00:54 CET 2014
Hello, I have write the following rule on the sqlcounter module:
sqlcounter checkthetime {
sql_module_instance = "sql"
dialect = ${modules.sql.dialect}
counter_name = "All-Hour-Used"
check_name = "Max-Hour-Used"
key = "User-Name"
reset = "never"
$INCLUDE ${modconfdir}/sql/counter/${dialect}/${.:instance}.conf
}
checkthetime file:
query = "SELECT HOUR(SEC_TO_TIME(UNIX_TIMESTAMP() -
UNIX_TIMESTAMP(AcctStartTime))) FROM radacct WHERE UserName = '%{${key}}'
LIMIT 1
my debug mode is here: http://pastebin.com/F9QA2WN2, but also the
interesting parts is here:
........
# Instantiating module "checkthetime" from file
/etc/freeradius/mods-enabled/sqlcounter
sqlcounter checkthetime {
sql_module_instance = "sql"
key = "User-Name"
query = "SELECT HOUR(SEC_TO_TIME(UNIX_TIMESTAMP() -
UNIX_TIMESTAMP(AcctStartTime))) FROM radacct WHERE UserName =
'%{User-Name}' LIMIT 1;"
reset = "never"
counter_name = "All-Hour-Used"
check_name = "Max-Hour-Used"
reply_name = "Session-Timeout"
}
............
(0) checkthetime : --> 2
(0) checkthetime : Allowing user, control:Max-Hour-Used value (336) is
greater than counter value (2)
(0) checkthetime : Setting reply:Session-Timeout value to 334
..........
Sending Access-Accept Id 72 from 192.168.40.12:1812 to 192.168.40.102:54010
Mikrotik-Rate-Limit = '512k/2M'
Session-Timeout = 334
And in my MySQL radgroupcheck table:
7 2 Week Max-Hour-Used := 336
Even I don't have define property reply_name = "Session-Timeout" in my rule
it appears!! My problem is that the Session Time out is defined even if I
didn't define it.
Thanks for your attention and time.
My Freeradius is 3.0.4
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20141204/7541f9ca/attachment.html>
More information about the Freeradius-Users
mailing list