Thanks Roberto for your answer but
I did the changes in sqlcounter.conf and with my cisco, sqlcounter
doesnt work, with NTRadping it works very well. I looked into the
source code in freeradius 1.0.4 but this module is the same for 1.0.2
version (I have working 1.0.2)
What can I do?
Do you
I modified the users file and now it works, user is now like:
DEFAULT Simultaneous-Use := 1
Fall-Through = 1
cmartinez Max-Monthly-Session := 108000, Auth-Type := ldap
Service-Type = Framed-User,
Framed -Protocol = PPP
--
Thanks a lot to Roberto and Alan for
sqlcounter noresetcounter {
## Look here
driver = rlm_sqlcounter
counter-name = Max-All-Session-Time
check-name = Max-All-Session
## Look here
check-item = Max-All-Session
sqlmod-inst = sql
key = User-Name
Hello.
I have freradius-1.0.2 with autorizathion and authentication in LDAP
and accounting in MySQL. I configured to use rlm_sqlcounter to control
time connections, testing with NTRadping work well but testing with my
Cisco NAS it doesnt work
With my cisco NAS this is the message:
Show us your sqlcounter.conf ...
You should define 'check-item' in sqlcounter.conf ...
-
Roberto Gonzalez Azevedo
Carlos Martnez-Troncoso Cera wrote:
Hello.
I have freradius-1.0.2 with autorizathion and authentication in LDAP and
accounting in MySQL. I configured to
Ok Roberto, here is my
sqlcounter.conf
sqlcounter noresetcounter {
counter-name = Max-All-Session-Time
check-name = Max-All-Session
sqlmod-inst = sql
key = User-Name
reset = never
query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE
UserName='%{%k}'"
}
sqlcounter dailycounter {
ok Roberto:
sqlcounter noresetcounter {
counter-name = Max-All-Session-Time
check-name = Max-All-Session
sqlmod-inst = sql
key = User-Name
reset = never
query = SELECT SUM(AcctSessionTime) FROM radacct WHERE
7 matches
Mail list logo