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