Upgrading from FR3.0.0 to 3.0.1 : no more sql group reply query !

Philippe MARASSE philippe.marasse at ch-poitiers.fr
Thu Feb 13 16:41:12 CET 2014


Hello,

I'm testing an upgrade from my FR3.0.0 to 3.0.1 on an up to date Debian 7. Unfortunately, 
I don't get attributes from radgroupreply table any more... as the attached log shows :

(1) 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 = 'eca86bf20216' ORDER BY id'
rlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op FROM radcheck 
WHERE username = 'eca86bf20216' ORDER BY id'
(1) sql : User found in radcheck table
(1) sql : Check items matched
(1) sql :     expand: "SELECT id, username, attribute, value, op FROM radreply WHERE 
username = '%{SQL-User-Name}' ORDER BY id" -> 'SELECT id, username, attribute, value, op 
FROM radreply WHERE username = 'eca86bf20216' ORDER BY id'
rlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op FROM radreply 
WHERE username = 'eca86bf20216' ORDER BY id'
(1) sql :     expand: "SELECT groupname FROM radusergroup WHERE username = 
'%{SQL-User-Name}' ORDER BY priority" -> 'SELECT groupname FROM radusergroup WHERE 
username = 'eca86bf20216' ORDER BY priority'
rlm_sql (sql): Executing query: 'SELECT groupname FROM radusergroup WHERE username = 
'eca86bf20216' ORDER BY priority'
rlm_sql (sql): Released connection (4)

radreply table is queried but not radgroupdeply although the query about radusergroup 
table returns 2 entries.

On an older log done with FR3.0.0 (with the very same data in DB of course) I used to have :

(39049) sql : SQL-User-Name set to "eca86bf20216"
rlm_sql (sql): Reserved connection (2292)
(39049) 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 = 'eca86bf20216' ORDER BY id'
rlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op FROM radcheck 
WHERE username = 'eca86bf20216' ORDER BY id'
(39049) sql : User found in radcheck table
(39049) sql :   expand: "SELECT id, username, attribute, value, op FROM radreply WHERE 
username = '%{SQL-User-Name}' ORDER BY id" -> 'SELECT id, username, attribute, value, op 
FROM radreply WHERE username = 'eca86bf20216' ORDER BY id'
rlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op FROM radreply 
WHERE username = 'eca86bf20216' ORDER BY id'
(39049) sql :   expand: "SELECT groupname FROM radusergroup WHERE username = 
'%{SQL-User-Name}' ORDER BY priority" -> 'SELECT groupname FROM radusergroup WHERE 
username = 'eca86bf20216' ORDER BY priority'
rlm_sql (sql): Executing query: 'SELECT groupname FROM radusergroup WHERE username = 
'eca86bf20216' ORDER BY priority'
(39049) sql :   expand: "SELECT id, groupname, attribute, Value, op FROM radgroupcheck 
WHERE groupname = '%{Sql-Group}' ORDER BY id" -> 'SELECT id, groupname, attribute, Value, 
op FROM radgroupcheck WHERE groupname = 'pcs-miletrie' ORDER BY id'
rlm_sql (sql): Executing query: 'SELECT id, groupname, attribute, Value, op FROM 
radgroupcheck WHERE groupname = 'pcs-miletrie' ORDER BY id'
(39049) sql : User found in= RLM_MODULE_OK; group pcs-miletrie
(39049) sql :   expand: "SELECT id, groupname, attribute, value, op FROM radgroupreply 
WHERE groupname = '%{Sql-Group}' ORDER BY id" -> 'SELECT id, groupname, attribute, value, 
op FROM radgroupreply WHERE groupname = 'pcs-miletrie' ORDER BY id'
rlm_sql (sql): Executing query: 'SELECT id, groupname, attribute, value, op FROM 
radgroupreply WHERE groupname = 'pcs-miletrie' ORDER BY id'
rlm_sql (sql): Released connection (2292)

Have I missed something ?

Regards

-------------- next part --------------
A non-text attachment was scrubbed...
Name: freeradius.log
Type: text/x-log
Size: 74870 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20140213/6db5052d/attachment-0001.bin>


More information about the Freeradius-Users mailing list