Reject User Pre-Proxy - SQL

[Andrei Antonelli]

Thanks a lot Matthew.

Worked.

--

Att.
Andrei Antoneli


On Sun, Apr 1, 2018 at 11:28 AM, Matthew Newton <mcn at freeradius.org> wrote:

> On 1 April 2018 14:30:30 BST, Andrei Antonelli <andreirp at gmail.com> wrote:
> >if (&User-Name == 'XXX at XXX') {
> >                reject
>
> &User-Name on the LHS.
>
>
> >if ("%{sql:SELECT username FROM radcheckblock WHERE username =
> >'%{User-Name}'}" == &User-Name) {
>
> &User-Name on the RHS.
>
>
> >policy.d/filter[20]:  ^ Cannot use attribute reference on right side of
> >condition
>
> >What would be the best way to do this filter?
>
> Attribute needs to be on the left, just like the error says.
>
> if (&User-Name == "%{sql:SELECT username FROM radcheckblock WHERE username
> = '%{User-Name}'}") {
>
>
> --
> Matthew
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/
> list/users.html