Question About rlm_sql_log (it was Re: Time connected)

2009-11-03 Thread Sergio Belkin
2009/10/29 Ivan Kalik t...@kalik.net: Sergio Belkin wrote: 2009/10/29 Ivan Kalik t...@kalik.net: Sergio Belkin wrote: Hi, Sorry for the stupid question, but I'd want to get how many time every user is connected, please could you provide some kind of guideliness? Using Version 2.1.1.

Re: Question About rlm_sql_log (it was Re: Time connected)

2009-11-03 Thread Ivan Kalik
Sorry for the stupid question, but I'd want to get how many time every user is connected, please could you provide some kind of guideliness? Using Version 2.1.1. SELECT Count(*) FROM radacct WHERE UserName='some_username' I guess that you're using database module, aren't you? You

Re: Question About rlm_sql_log (it was Re: Time connected)

2009-11-03 Thread Sergio Belkin
2009/11/3 Ivan Kalik t...@kalik.net: Sorry for the stupid question, but I'd want to get how many time every user is connected, please could you provide some kind of guideliness? Using Version 2.1.1. SELECT Count(*) FROM radacct WHERE UserName='some_username' I guess that you're using

Re: Time connected

2009-10-29 Thread Ivan Kalik
Sergio Belkin wrote: Hi, Sorry for the stupid question, but I'd want to get how many time every user is connected, please could you provide some kind of guideliness? Using Version 2.1.1. SELECT Count(*) FROM radacct WHERE UserName='some_username' Ivan Kalik Kalik Informatika ISP - List

Re: Time connected

2009-10-29 Thread Sergio Belkin
2009/10/29 Ivan Kalik t...@kalik.net: Sergio Belkin wrote: Hi, Sorry for the stupid question, but I'd want to get how many time every user is connected, please could you provide some kind of guideliness? Using Version 2.1.1. SELECT Count(*) FROM radacct WHERE UserName='some_username'

Re: Time connected

2009-10-29 Thread Ivan Kalik
Sergio Belkin wrote: 2009/10/29 Ivan Kalik t...@kalik.net: Sergio Belkin wrote: Hi, Sorry for the stupid question, but I'd want to get how many time every user is connected, please could you provide some kind of guideliness? Using Version 2.1.1. SELECT Count(*) FROM radacct

RE: Time connected

2009-10-29 Thread Scott Miller
I use the following: SELECT SUM(AcctOutputOctets/1024) AS data, SUM(AcctSessionTime/60) AS minutes, DATE_FORMAT(AcctStartTime,'%M %Y') AS month, CalledStationId, UserName INTO OUTFILE /tmp/feb-09-result.txt FROM radacct GROUP BY month, CalledStationId, UserName HAVING month LIKE 'February 2009';