SQL Counter Escape String !

[Suman Dash]

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 at 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-attribute-tt2775323.html#a2775328
>
>  <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
>