|
|
|
| ||||
| ||||
| Question: PPPoE-Server : Freeradius 2 + case_sensitive + sql setting |
look on file /etc/freeradius/sql.conf change to
# Use these for case sensitive usernames. authorize_check_query = "SELECT id, UserName, Attribute, Value, op FROM ${authcheck_table} WHERE Username = BINARY '%{SQL-User-Name}' ORDER BY id" authorize_reply_query = "SELECT id, UserName, Attribute, Value, op FROM ${authcheck_table} WHERE Username = BINARY '%{SQL-User-Name}' ORDER BY id" and
# Use these for case sensitive usernames.
authorize_group_check_query = "SELECT ${groupcheck_table}.id,${groupcheck_table}.GroupName,${groupcheck_table}.Attribute,${groupcheck_table}.Value,${groupcheck_table}.op FROM ${groupcheck_table},${usergroup_table} WHERE ${usergroup_table}.Username = BINARY '%{SQL-User-Name}' AND ${usergroup_table}.GroupName = ${groupcheck_table}.GroupName ORDER BY ${groupcheck_table}.id"
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 = BINARY '%{SQL-User-Name}' AND ${usergroup_table}.GroupName = ${groupreply_table}.GroupName ORDER BY ${groupreply_table}.id"
by: EasyZone วันที่ 6/9/2553 - 16:25:57 |
