dailycounter isnt started

[Sanity Computers]

Guys, I found the right code from the Daloradius /sql/counter.conf. In all
my googling I have not seen it like this. 

 

I found it a little tough when the wiki and Github show code that does not
work for a daily-max-session. I guess there is a reason but loads of the
examples out there simply don't work unless the radacct table is already
populated, cheers.

 

sqlcounter dailycounter {

       counter-name = Daily-Session-Time

       check-name = Max-Daily-Session

       reply-name = Session-Timeout

       sqlmod-inst = sql

       key = User-Name

       reset = daily

query = "SELECT IFNULL(SUM(acctsessiontime - \

                 GREATEST((%b - UNIX_TIMESTAMP(acctstarttime)), 0)),0) \

                 FROM radacct WHERE username = '%{%k}' AND \

                 UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '%b'"

 

 

Regards

 

Jim

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20140308/f870c6f0/attachment.html>