Rlm sqlcounter -- Data Based Counter

2008-12-02 Thread Marcel Grandemange
Good Day. Im wondering is someone could assist me here. I currently have freeradius setup and working somewhat. However I have following setup: sqlcounter monthlytraffic { counter-name = Monthly-Traffic check-name = Max-Monthly-Traffic

Re: Rlm sqlcounter -- Data Based Counter

2008-12-02 Thread tnt
#query = SELECT SUM(OctetTotal) FROM thismonthsusage WHERE UsernameView='%{%k}' } .. As soon as a new month rolls over there are NO accounting entries for that user for that month, hence no record and freeradius denies user as he hasn't got any entries, any body know how I should modify the view