On Jan 18, 2013, at 3:34 PM, Alan DeKok <[email protected]> wrote:
> authorize {
> ...
>
> if (! "%{sql:SELECT ... }") {
> reject
> }
Can I use a userdefined variable in the select statement that the EXEC perl
script returns:
I would like to use the User-Password below:
[evdoesn] expand: %{User-Name} -> [email protected]
Exec-Program output: User-Password := 268435460102579521, CHAP-Password :="" ,
CHAP-Challenge :="" , Auth-Type := PAP
Exec-Program-Wait: value-pairs: User-Password := 268435460102579521,
CHAP-Password :="" , CHAP-Challenge :="" , Auth-Type := PAP
Exec-Program: returned: 0
++[evdoesn] returns ok
Here is the relevant entry from the "default" file:
evdoesn (exec script/perl)
if (! "%{sql:SELECT username FROM 'radcheck' WHERE username=%{User-Name} AND
value=%{User-Password} }") {
reject
}
update control {
Auth-Type := Accept
}
But it can't expand the %User-Password...
rlm_sql_postgresql: query: SELECT username FROM 'radcheck' WHERE
[email protected] AND value=
rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
rlm_sql_postgresql: Error syntax error at or near "'radcheck'"
rlm_sql_postgresql: Postgresql Fatal Error: [42601: SYNTAX ERROR] Occurred!!
Its not expanding the User-Password variable which was setup in EXEC.
>
> update control {
> Auth-Type := Accept
> }
> ...
> }
>
> It's that easy.
--
respectfully, Joseph / IT
[M] +1(606)477-7551 / [email protected]
East Kentucky Network, LLC.
dba Appalachian Wireless
==============================
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
