[sql] expand: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'pepe@dominio.com' ORDER BY id WARNING: Found User-Password == "...". WARNING: Are you sure you don't mean Cleartext-Password? WARNING: See "man rlm_pap" for more information.
Fix that.
[sql] User found in radcheck table rlm_sql (sql): Released sql socket id: 4 ++[sql] returns ok
And what happened to authorize_reply_query? It would be helpful to see part of the server startup debug where sql module is instatiated. Ivan Kalik Kalik Informatika ISP
It's checking the query in radcheck but not in radgroupreply. And I've tested the query in dialup.conf and seems correct
authorize_group_reply_query = "SELECT ${groupreply_table}.id, ${groupreply_table}.GroupName,${groupreply_table}.Attribute, ${groupreply_table}.Value,${groupreply_table}.op FROM ${groupreply_table},${usergroup_table} WHERE ${usergroup_table}.Username = '%{SQL-User-Name}' AND ${usergroup_table}.GroupName = ${groupreply_table}.GroupName ORDER BY ${groupreply_table}.id"
Thanks in advance
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html