Hi,
I wrote a custom xlat sql function (my setup is with mysql backend),
registered it, and radius_xlat gets the function running. However,
variables in query are not replaced with attribute values... So my
question is: what did I do wrong? :)
sql.conf :
test_query = "SELECT id FROM ${authcheck_table} WHERE Username =
'%{SQL-User-Name}'"
Debug mode output for authorization:
modcall[authorize]: module "files" returns ok for request 0
radius_xlat: 'test1'
rlm_sql (sql): sql_set_user escaped user --> 'test1'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck
WHERE Username = 'test1' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 4
radius_xlat: 'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op
FROM radgroupcheck,usergroup WHERE usergroup.Username = 'test1' AND
usergroup.GroupName = radgroupcheck.GroupName ORDER BY
radgroupcheck.id'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply
WHERE Username = 'test1' ORDER BY id'
radius_xlat: 'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op
FROM radgroupreply,usergroup WHERE usergroup.Username = 'test1' AND
usergroup.GroupName = radgroupreply.GroupName ORDER BY
radgroupreply.id'
rlm_sql (sql): Released sql socket id: 4
modcall[authorize]: module "sql" returns ok for request 0
Debug output for my function:
radius_xlat: Running registered xlat function of module sql for string
'%{config:modules.sql.test_query}'
rlm_sql (sql): - sql_xlat
radius_xlat: 'test1'
rlm_sql (sql): sql_set_user escaped user --> 'test1'
radius_xlat: Running registered xlat function of module config for
string 'modules.sql.test_query'
radius_xlat: 'SELECT id FROM radcheck WHERE Username = '%{SQL-User-Name}''
rlm_sql (sql): Reserving sql socket id: 3
rlm_sql (sql): SQL query did not return any results
rlm_sql (sql): Released sql socket id: 3
radius_xlat: ''
I'm executing this function from post-auth section, Freeradius v1.0.1.
Thanks,
R.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
