On Mon, Feb 7, 2011 at 1:08 AM, Tyller D <[email protected]> wrote: > Hi > > I will try run the queries manually and see what happens. > > rlm_sqlcounter is cool, but this should work right?
The idea looks good. However, since you're trying to reimplement what's already available, you might have a hard time trying to get everything right. For example, what happens when a user exceeds their quota? Your setup would accept the user while sending a negative quota (which might or might not work). On my implmentation, I use rlm_sqlcounter, but I changed the way it gets the numbers. I didn't like the way it does a sum() on radacct every time a user logs in (one of the reasons were I want to delete old entries from my radacct table), so I created an additional table to record total usage, and update it using sql trigger. So instead of having to examine thousands of rows when a user logs in, now the db simply has to examine one row, plus update that row when a user logs out. This way I can still make use of rlm_sqlcounter without having to reinvent the whole logic behind it. -- Fajar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
