Re: Help Regarding SQL Counter

2008-12-20 Thread tnt
but one thing i wanted to ask you why NAS-IP-Addres is always shown as 0.0.0.0 in my case nas ip address is 192.168.2.5. do i need to make any other configuration. - Is that in the request packet? If it is - that's what your NAS is sending. Ivan Kalik Kalik Informatika ISP - List

Help Regarding SQL Counter

2008-12-19 Thread pushpraj nimbalkar
Hello All; I just installed freeradius on fedora 10. freeradius version is freeradius-2.1.1-2.fc10.i386 i also installed radius mysql packages. After basic set up I configured radius with mysql. All thing are working fine but i am not able to resolve sqlcounter issue. I have defined counters in

Re: Help Regarding SQL Counter

2008-12-19 Thread Padam J Singh
The NAS has to implement session disconnection after the requisite time/byte limit. What NAS are you using? Padam pushpraj nimbalkar wrote: Hello All; I just installed freeradius on fedora 10. freeradius version is "freeradius-2.1.1-2.fc10.i386" i also installed radius mysql packages.

Re: Help Regarding SQL Counter

2008-12-19 Thread pushpraj nimbalkar
Thanks for reply, I am using linksys WRT54GL router with DD-WRT and Chillispot. SQLCounter works only when radacct tables contains accounting information of logging user. On Fri, Dec 19, 2008 at 5:08 PM, Padam J Singh padam.si...@inventum.cc wrote: The NAS has to implement session

Re: Help Regarding SQL Counter

2008-12-19 Thread Padam J Singh
pushpraj nimbalkar wrote: Thanks for reply, I am using linksys WRT54GL router with DD-WRT and Chillispot. SQLCounter works only when radacct tables contains accounting information of logging user. Please also post the reply sent back to the NAS - run the radius server in debug

Re: Help Regarding SQL Counter

2008-12-19 Thread tnt
I am using linksys WRT54GL router with DD-WRT and Chillispot. SQLCounter works only when radacct tables contains accounting information of logging user. It should still limit to 30 minutes if user has no record. Post the debug of the request for a user that has no radacct entries. Ivan Kalik

Re: Help Regarding SQL Counter

2008-12-19 Thread pushpraj nimbalkar
Sir, when user first connects following reply sent to nas Sending Access-Accept of id 0 to 192.168.2.5 port 2051 Idle-Timeout := 600 Acct-Interim-Interval := 60 and when same user connects 2nd time following reply is sent Sending Access-Accept of id 0 to 192.168.2.5 port 2051

Re: Help Regarding SQL Counter

2008-12-19 Thread pushpraj nimbalkar
On Fri, Dec 19, 2008 at 6:20 PM, t...@kalik.net wrote: I am using linksys WRT54GL router with DD-WRT and Chillispot. SQLCounter works only when radacct tables contains accounting information of logging user. It should still limit to 30 minutes if user has no record. Post the debug of the

Re: Help Regarding SQL Counter

2008-12-19 Thread tnt
sqlcounter_expand: 'SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{User-Name}'' [noresetcounter] expand: SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{User-Name}' - SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='jose' sqlcounter_expand: '%{sql:SELECT

Re: Help Regarding SQL Counter

2008-12-19 Thread pushpraj nimbalkar
On Fri, Dec 19, 2008 at 8:28 PM, t...@kalik.net wrote: sqlcounter_expand: 'SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{User-Name}'' [noresetcounter] expand: SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{User-Name}' - SELECT SUM(AcctSessionTime) FROM radacct