radreply is not queried
Charly
netflow at geosciences.ensmp.fr
Thu Apr 26 17:15:29 CEST 2018
Hello,
I don't understand why radreply table is not queried whereas
radgroupreply is queried :
(0) authorize {
(0) [preprocess] = ok
(0) sql: EXPAND %{User-Name}
(0) sql: --> john
(0) sql: SQL-User-Name set to 'john'
rlm_sql (sql): Reserved connection (0)
(0) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck
WHERE username = '%{SQL-User-Name}' ORDER BY id
(0) sql: --> SELECT id, username, attribute, value, op FROM radcheck
WHERE username = 'john' ORDER BY id
(0) sql: Executing select query: SELECT id, username, attribute, value,
op FROM radcheck WHERE username = 'john' ORDER BY id
(0) sql: EXPAND SELECT groupname FROM radusergroup WHERE username =
'%{SQL-User-Name}' ORDER BY priority
(0) sql: --> SELECT groupname FROM radusergroup WHERE username =
'john' ORDER BY priority
(0) sql: Executing select query: SELECT groupname FROM radusergroup
WHERE username = 'john' ORDER BY priority
(0) sql: User found in the group table
(0) sql: EXPAND SELECT id, groupname, attribute, Value, op FROM
radgroupcheck WHERE groupname = '%{sql-SQL-Group}' ORDER BY id
(0) sql: --> SELECT id, groupname, attribute, Value, op FROM
radgroupcheck WHERE groupname = 'common' ORDER BY id
(0) sql: Executing select query: SELECT id, groupname, attribute, Value,
op FROM radgroupcheck WHERE groupname = 'common' ORDER BY id
(0) sql: Group "common": Conditional check items matched
(0) sql: Group "common": Merging assignment check items
(0) sql: EXPAND SELECT id, groupname, attribute, value, op FROM
radgroupreply WHERE groupname = '%{sql-SQL-Group}' ORDER BY id
(0) sql: --> SELECT id, groupname, attribute, value, op FROM
radgroupreply WHERE groupname = 'common' ORDER BY id
(0) sql: Executing select query: SELECT id, groupname, attribute, value,
op FROM radgroupreply WHERE groupname = 'common' ORDER BY id
(0) sql: Group "common": Merging reply items
Thank for your help
Charly
More information about the Freeradius-Users
mailing list