On 24 Apr 2017, at 11:47, Martin Rys <spleefer90@gmail.com> wrote:
Here is everything I tried, step by step.
That's a little hard to follow. You included the debug output, which is what we need though. The relevant section is this - your SQL queries aren't returning data:
(1) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id (1) sql: --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'c0rn3j' ORDER BY id (1) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'c0rn3j' ORDER BY id (1) sql: EXPAND SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority (1) sql: --> SELECT groupname FROM radusergroup WHERE username = 'c0rn3j' ORDER BY priority (1) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = 'c0rn3j' ORDER BY priority (1) sql: User not found in any groups
If you run the query manually (SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'c0rn3j' ORDER BY id), does it return a user? Did you intend to use groups? Regards, Adam Bishop gpg: E75B 1F92 6407 DFDF 9F1C BF10 C993 2504 6609 D460 jisc.ac.uk Jisc is a registered charity (number 1149740) and a company limited by guarantee which is registered in England under Company No. 5747339, VAT No. GB 197 0632 86. Jisc’s registered office is: One Castlepark, Tower Hill, Bristol, BS2 0JA. T 0203 697 5800. Jisc Services Limited is a wholly owned Jisc subsidiary and a company limited by guarantee which is registered in England under company number 2881024, VAT number GB 197 0632 86. The registered office is: One Castle Park, Tower Hill, Bristol BS2 0JA. T 0203 697 5800.