Hi.

I use freeradius 8.1 on RH9 with mysql
It works perfect. (authorization from sql)
I work on some features and I've problem.
In sql.conf :
authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM ${authcheck_table} 
WHERE Username = '%{SQL-User-Name}' ORDER BY id"

Now I want to pass "id" value as command line argument to Exec-Program-Wait.
I read variables.txt  
I checked such variable %{config:authorize.sql.id} or %{sql.id} but
it didn't work. 
Maybe such solution will probably work but it's rather work around for me.
        Exec-Program-Wait = `/etc/raddb/check %{sql: select id from radcheck WHERE 
username = %{User-Name} and attribute = 'Password' and value = %{User-Password}}'

Regards.
-- 
Adam

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to