Hi Alan,
Did you managed to look into the issue ?
or maybe any hints on how to use DATETIME in Expiration instead of String ?
Regads
Suman
On 3/15/2011 4:04 PM, Suman Dash wrote:
Dear Alan,
I have not removed any debug messages. I will try to put everything
once again . I was not aware
Suman Dash wrote:
Hi Alan,
Did you managed to look into the issue ?
No.
or maybe any hints on how to use DATETIME in Expiration instead of String ?
Honestly, in 2.1.10, you can just write SELECT statements directly in
unlang.
update reply {
Session-Timeout :=
Much thanks Alan,
That was some really good advice on how to make the thing work.
So now i have to write unlang statement in preprocess so that it
directly gives the Session-Timeout . Please correct me if i am wrong.
Thanks Again
On 3/16/2011 4:09 PM, Alan DeKok wrote:
Suman Dash 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
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
I have tried almost all sql escape but looks like none are working or
maybe i am missing something. I am stuck in this issue for more than 3
days and now i don't have any clue due to which i am trying to reach for
help on the mailing list.
SELECT SUM(acctsessiontime) FROM tbl_acct where
Suman Dash wrote:
I have tried almost all sql escape but looks like none are working or
maybe i am missing something. I am stuck in this issue for more than 3
days and now i don't have any clue due to which i am trying to reach for
help on the mailing list.
Hmm... the issue seems to be that
mysql select * from tbl_check;
++--+-++--+
| id | username | attribute | op | value|
++--+-++--+
| 17 | suman| Crypt-Password | := | TeatgXaDQelbQ
Suman Dash wrote:
sqlcounter monthlycounter {
...
WHERE username = '%{%k}' AND attribute = 'Activation'),
'd M Y H:i:s')) \
The debug log doesn't show that this string is being used.
And *again* you delete large amounts of the debug log. Why? It
Dear Alan,
I have not removed any debug messages. I will try to put everything once
again . I was not aware that i sent you a mail. I am having a nightmare
and accidently i clicked Send All instead of selecting the mailing list.
sqlcounter monthlycounter {
counter-name =
Hi Alan,
Looks like i am getting some meaningful debugs in fr-2.1.10.
Undermentioned are the Counter and Debug Messages.
I used %% escape but in the query it's '%d %M %Y %H:%i:%s' . Seems like
that's how escaping works.
I assumed that i needed to add more % but adding more doesn't help .
Is it possible to change the date of Expiration to DATETIME rather
than String ?
Expiration Attribute is unable to parse a DATETIME but is able to
parse a String
10 Jan 2011 Is Parsed
2011-01-10 Unable to Parse
Reason is that i want to run a counter which will pick the Expiration
and
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
SELECT STR_TO_DATE('14 Mar 2012 21:37:23','%d %M %Y %H:%i:%s') gives
2012-03-14 21:37:23 in MySQL
Whereas in freeradius
13 matches
Mail list logo