radius_xlat: 'SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'swinter' ORDER BY id'
radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroup check.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'swinter' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'
What do these two SQL queries return if you run them in the CLI SQL client?
First: +----+----------+-------------+----------------------------------+----+ | id | UserName | Attribute | Value | op | +----+----------+-------------+----------------------------------+----+ | 1 | swinter | NT-Password | 0CB6948805F797BF2A82807973B89537 | := | +----+----------+-------------+----------------------------------+----+ Second: Empty set. Stefan -- Stefan WINTER Stiftung RESTENA - Réseau Téléinformatique de l'Education Nationale et de la Recherche Ingenieur Forschung & Entwicklung 6, rue Richard Coudenhove-Kalergi L-1359 Luxembourg E-Mail: stefan.winter@restena.lu Tel.: +352 424409-1 http://www.restena.lu Fax: +352 422473