Le 31/10/2013 13:01, Arran Cudbard-Bell a écrit :
cloned master branch => not working, always noop returned if user is not found, is your patch commited on this branch ?? It was, but then it got nuked by accident.
I've committed that and couple of other fixes now.
cloned v3.0.x branch => half success, as this user is not found : Ok, this should work now. Hmmm, half success, return code is now OK but groups are not processed although I've read_groups = yes in sql module configuration ??
(12) sql : expand: "%{User-Name}" -> '002324609e3f' (12) sql : SQL-User-Name set to "002324609e3f" rlm_sql (sql): Reserved connection (6) (12) 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 user name = '002324609E3F' ORDER BY id' rlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op FROM radcheck WHERE username = '002324609E3F' ORDER BY id' (12) sql : User found in radcheck table (12) sql : Check items matched (12) 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 = '002324609E3F' ORDER BY id' rlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op FROM radreply WHERE username = '002324609E3F' ORDER BY id' (12) sql : expand: "SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority" -> 'SELECT groupname FROM radusergroup WHERE username = '002324609E3F' ORDER BY priority' rlm_sql (sql): Executing query: 'SELECT groupname FROM radusergroup WHERE username = '002324609E3F' ORDER BY priority' rlm_sql (sql): Released connection (6) (12) [sql] = ok BTW, the SQL Username seems to be uppercased.
Thanks for testing. You're welcome.
Rgds. -- Philippe MARASSE Pôle Infrastructures - Direction du Système d'Informations et de l'Organisation Centre Hospitalier Henri Laborit CS 10587 - 370 avenue Jacques Coeur 86021 Poitiers Cedex Tel : 05.49.44.57.19