Re: Counter SQL Calculation

2010-11-04 Thread Neville
Can anyone please help on this as I've googled as cannot find a solution to the issue I've outlined below. Thx Nev Hi Everyone, Here is some Debug if anyone can help explain or correct the [monthlytraffic] Counter calculation. Sat Oct 30 22:39:39 2010 : Info: [monthlytraffic] expand:

Re: Counter SQL Calculation

2010-10-30 Thread Neville
Hi Everyone, Here is some Debug if anyone can help explain or correct the [monthlytraffic] Counter calculation. Sat Oct 30 22:39:39 2010 : Info: [monthlytraffic] expand: SELECT IFNULL((sum(acctinputoctets)+sum(acctoutputoctets)),0) FROM radacct WHERE username='%{User-Name}' AND

Re: Counter SQL Calculation

2010-10-25 Thread Neville
Anyone got any pointers at all on this one? Thx Nev - Original Message - From: Neville n...@itsnev.co.uk To: freeradius-users@lists.freeradius.org Sent: Wednesday, October 20, 2010 5:14 PM Subject: Counter SQL Calculation Hi everyone, I have a small problem where the counter

Counter SQL Calculation

2010-10-20 Thread Neville
Hi everyone, I have a small problem where the counter is not working how I would like it two work. sqlcounter monthlytraffic { counter-name = Monthly-Traffic check-name = Max-Monthly-Traffic reply-name = Session-Octets-Limit sqlmod-inst =