sql module behavior differs from 2.2.1 to 3.0.0 ?

Philippe MARASSE philippe.marasse at ch-poitiers.fr
Thu Oct 31 16:06:57 CET 2013


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


-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4539 bytes
Desc: Signature cryptographique S/MIME
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20131031/ba24750f/attachment-0001.bin>


More information about the Freeradius-Users mailing list