Two sql queries in counter module

Bishal bishal at
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
                        query = "SELECT SUM(AcctSessionTime) FROM
radacct WHERE UserName='%{%k}' AND ActiveDate='$query1'"

More information about the Freeradius-Users mailing list