On Jan 18, 2013, at 3:34 PM, Alan DeKok <aland@deployingradius.com> 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} -> 6064191111@evdo.myawi.net 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 username=6064191111@evdo.myawi.net 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 / tech@ekn.com East Kentucky Network, LLC. dba Appalachian Wireless ==============================