Two sql queries in counter module

Bishal bishal at baayu.com.np
Thu Nov 2 12:22:22 CET 2006


Hello all

 Is it possible to make two queries in sql counter module? like


sqlcounter noresetcounter {
                        driver = "rlm_sqlcounter"
                        counter-name = Max-All-Session-Time
                        check-name = Max-All-Session
                        sqlmod-inst = sql
                        key = User-Name
                        reset = never
                        query1=SELECT activedate from radacct where
username='%{%k}"'
                        query = "SELECT SUM(AcctSessionTime) FROM
radacct WHERE UserName='%{%k}' AND ActiveDate='$query1'"
        }




More information about the Freeradius-Users mailing list