New Modified Query ! SELECT SUM(acctsessiontime) FROM tbl_acct where \ username = '%{%k}' AND acctstarttime BETWEEN \ (SELECT STR_TO_DATE((SELECT value FROM tbl_check \ WHERE username = '%{%k}' AND attribute = 'Activation'), '%%d %%M %%Y %%H:%%i:%%s')) \ AND (SELECT STR_TO_DATE((SELECT value FROM tbl_check WHERE username = '%{%k}' \ AND attribute = 'Expiration'), '%%d %%M %%Y %%H:%%i:%%s')); DEBUG : sqlcounter_expand: 'SELECT SUM(acctsessiontime) FROM tbl_acct where username = '%{User-Name}' AND acctstarttime BETWEEN (SELECT STR_TO_DATE((SELECT value FROM tbl_check WHERE username = '%{User-Name}' AND attribute = 'Activation'), '%1298917800d %1298917800M %1298917800Y %1298917800H:%1298917800i:%1298917800s')) AND (SELECT STR_TO_DATE((SELECT value FROM tbl_check WHERE username = '%{User-Name}' AND attribute = 'Expiration'), '%1298917800d %1298917800M %1298917800Y %1298917800H:%1298917800i:%1298917800s'));' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] expand: SELECT SUM(acctsessiontime) FROM tbl_acct where username = '%{User-Name}' AND acctstarttime BETWEEN (SELECT STR_TO_DATE((SELECT value FROM tbl_check WHERE username = '%{User-Name}' AND attribute = 'Activation'), '%1298917800d %1298917800M %1298917800Y %1298917800H:%1298917800i:%1298917800s')) AND (SELECT STR_TO_DATE((SELECT value FROM tbl_check WHERE username = '%{User-Name}' AND attribute = 'Expiration'), '%1298917800d %1298917800M %1298917800Y %1298917800H:%1298917800i:%1298917800s')); -> SELECT SUM(acctsessiontime) FROM tbl_acct where username = 'suman' AND acctstarttime BETWEEN (SELECT STR_TO_DATE((SELECT value FROM tbl_check WHERE username = 'suman' AND attribute = 'Activation'), '%1298917800d %1298917800M %1298917800Y %1298917800H:%1298917800i:%1298917800s')) AND (SELECT STR_TO_DATE((SELECT value FROM tbl_check WHERE username = 'suman' sqlcounter_expand: '%{sql:SELECT SUM(acctsessiontime) FROM tbl_acct where username = 'suman' AND acctstarttime BETWEEN (SELECT STR_TO_DATE((SELECT value FROM tbl_check WHERE username = 'suman' AND attribute = 'Activation'), '%1298917800d %1298917800M %1298917800Y %1298917800H:%1298917800i:%1298917800s')) AND (SELECT STR_TO_DATE((SELECT value FROM tbl_check WHERE username = 'suman' AND attribute = 'Expiration'), '%1298917800d %1298917800M %1298917800Y %1298917800H:%1298917800i:%1298917800s'));}' [monthlycounter] sql_xlat [monthlycounter] expand: %{User-Name} -> suman [monthlycounter] sql_set_user escaped user --> 'suman' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] WARNING: Unknown variable '%1': See 'doc/variables.txt' [monthlycounter] expand: SELECT SUM(acctsessiontime) FROM tbl_acct where username = 'suman' AND acctstarttime BETWEEN (SELECT STR_TO_DATE((SELECT value FROM tbl_check WHERE username = 'suman' AND attribute = 'Activation'), '%1298917800d %1298917800M %1298917800Y %1298917800H:%1298917800i:%1298917800s')) AND (SELECT STR_TO_DATE((SELECT value FROM tbl_check WHERE username = 'suman' AND attribute = 'Expiration'), '%1298917800d %1298917800M %1298917800Y %1298917800H:%1298917800i:%1298917800s')); -> SELECT SUM(acctsessiontime) FROM tbl_acct where username = 'suman' AND acctstarttime BETWEEN (SELECT STR_TO_DATE((SELECT value FROM tbl_check WHERE username = 'suman' AND attribute = 'Activation'), '%1298917800d %1298917800M %1298917800Y %1298917800H:%1298917800i:%1298917800s')) AND (SELECT STR_TO_DATE((SELECT value FROM tbl_check WHERE username = 'suman' AND rlm_sql (sql): Reserving sql socket id: 2 [monthlycounter] row[0] returned NULL rlm_sql (sql): Released sql socket id: 2 [monthlycounter] expand: %{sql:SELECT SUM(acctsessiontime) FROM tbl_acct where username = 'suman' AND acctstarttime BETWEEN (SELECT STR_TO_DATE((SELECT value FROM tbl_check WHERE username = 'suman' AND attribute = 'Activation'), '%1298917800d %1298917800M %1298917800Y %1298917800H:%1298917800i:%1298917800s')) AND (SELECT STR_TO_DATE((SELECT value FROM tbl_check WHERE username = 'suman' AND attribute = 'Expiration'), '%1298917800d %1298917800M %1298917800Y %1298917800H:%1298917800i:%1298917800s'));} -> rlm_sqlcounter: No integer found in string "" ++[monthlycounter] returns noop On Tue, Mar 15, 2011 at 11:41 AM, Alan DeKok <aland@deployingradius.com> wrote:
Suman Dash wrote:
Please anyone advice me the way to escape run-time variables in freeradius. I am using STR_TO_DATE and freeradius run-time variable is over-riding the mysql time variables
Yes... that's what it does.
I have tried escaping as per the thread http://freeradius.1045715.n5.nabble.com/Changing-the-format-of-a-date-attrib...
<sigh> What's wrong with reading the documentation?
But no luck ..
My Entire Counter is :
... which doesn't follow the escaping rules of either the above message, or the documentation.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html