Thank you! That solved the issue. David From: Matthew Newton via Freeradius-Users <freeradius-users@lists.freeradius.org> Date: Tuesday, 13 October 2026 at 11:45 To: freeradius-users@lists.freeradius.org <freeradius-users@lists.freeradius.org> Cc: Matthew Newton <mcn@freeradius.org> Subject: Re: Issue with SQL-Group On 13/10/2026 10:42, David Lake via Freeradius-Users wrote:
This is what I see when I change the module to be sql_read:
(55912) Tue Oct 13 06:28:24 2026: Debug: sql_read: EXPAND SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{SQL-Group}' ORDER BY id (55912) Tue Oct 13 06:28:24 2026: Debug: sql_read: --> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '' ORDER BY id
The difference is in the bold line
ASCII list, there's no bold text.
the response from sql_read no longer has the groupname set. Nothing has changed in the database.
What have I missed please?
See `group_attribute` in the SQL module config. You want the `group_attribute = "${.:instance}-SQL-Group"` version on the sql_read instance, then use `sql_read-SQL-Group`. -- Matthew - List info/subscribe/unsubscribe? See https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.freeradius.org%2Flist%2Fusers.html&data=05%7C02%7Cd.lake%40surrey.ac.uk%7Cc32dfd7405504675bcad08df29172531%7C6b902693107440aa9e21d89446a2ebb5%7C0%7C0%7C639274851546730208%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=h9sFnZBkwVUfoAI9gKxB9lZkkYTMRqbskvE6DUub0lA%3D&reserved=0<http://www.freeradius.org/list/users.html>