Re: rlm_sqlcounter problem

2005-06-20 Thread Carlos Martínez-Troncoso Cera
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

Re: rlm_sqlcounter problem

2005-06-20 Thread Carlos Martínez-Troncoso Cera
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

Re: rlm_sqlcounter problem

2005-06-18 Thread Roberto Gonzalez Azevedo
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

rlm_sqlcounter problem

2005-06-17 Thread Carlos Martínez-Troncoso Cera
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:

Re: rlm_sqlcounter problem

2005-06-17 Thread Roberto Gonzalez Azevedo
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

Re: rlm_sqlcounter problem

2005-06-17 Thread Carlos Martínez-Troncoso Cera
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 {

Re: rlm_sqlcounter problem

2005-06-17 Thread Carlos Martínez-Troncoso Cera
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