now i'm using: ATTRIBUTE System-Date 3002 date ATTRIBUTE Start_Time 3000 date ATTRIBUTE Stop_Time 3001 date and in policy.conf policy { sql check_validity { update control { System-Date := "%l" } if (control:Start_Time > control:System-Date) { update reply { Reply-Message := "account not yet active" } reject } if (control:Stop_Time < control:System-Date) { update reply { Reply-Message := "account no longer active" } reject } } in this way i have error: ++- entering policy check_validity {...} expand: %l -> 1432060355 +++[control] returns noop +++? if (control:Start_Time > control:System-Date) Failed parsing "control:System-Date": failed to parse time string "control:System-Date" +++? if (control:Stop_Time < control:System-Date) Failed parsing "control:System-Date": failed to parse time string "control:System-Date" ++- policy check_validity returns noop 2015-05-19 20:11 GMT+02:00 Alan DeKok <aland@deployingradius.com>:
On May 19, 2015, at 1:42 PM, Franz Angeli <franz.angeli@gmail.com> wrote:
in this way i have:
sql policy {
check_validity {
That's... weird. The policies SHOULD go into raddb/policy.conf. Then, just use the policy name:
... sql check_validity ...
but it seems doesnt' work
++[sql] returns ok ++- entering policy check_validity {...} expand: %l -> 1432057169 +++[control] returns noop +++? if (Start_Time > control:System-Date)
Try using control:Start_Time. See the WIki for how the rlm_sql module works.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html