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