Re: Total Data download

2012-02-25 Thread Mike
Here is how I do it (this is for traffic in a particular month) SELECT username, truncate(sum(acctinputoctets + acctoutputoctets) / 100, 1) traffic FROM radacct WHERE month(acctstarttime) = 12 AND year(acctstarttime) =

Re: Oauth2 Google?

2012-02-25 Thread Phil Mayers
On 02/24/2012 05:10 PM, Jesse Crayston wrote: Trying to get my users to have the same password on a radius server, as they do on the google apps domain. That might be tricky. Since you can't read the passwords from an apps domain, the only thing you could possibly do is use it as an "oracle"

Re: Simultaneous-Use checking

2012-02-25 Thread Fajar A. Nugraha
On Sat, Feb 25, 2012 at 11:51 AM, opti2k4 wrote: > Hi, > > i need little help with this. I have MySQL setup with freeradis, that is > working. Now for Simultaneous-Use checking there are no querys to uncomment > inside sql.conf by default (installed freeradius over apt-get ). It should be there.

Re: adding radius accounts

2012-02-25 Thread Fajar A. Nugraha
On Sat, Feb 25, 2012 at 10:33 AM, Dom wrote: > Is there a tool/addon to add and remove radius accounts in the users file > without modify the file directly. No. That's why most people use db. >  Also can the users file be configured to > authenticate based on linux users already existing. Yes.