If you run the query manually does it work?
Yup! MariaDB [radius]> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'c0rn3j' ORDER BY id; +----+----------+--------------------+-------+----+ | id | username | attribute | value | op | +----+----------+--------------------+-------+----+ | 1 | c0rn3j | Cleartext-Password | 123 | := | +----+----------+--------------------+-------+----+ 1 row in set (0.00 sec)
Did you intend to use groups? I actually don't know if I will need them, I do not think I will, which is why I didn't assign the user to a group or create any group. As far as I understand RADIUS I only want simple user auth, for which I don't need groups?
Thanks a lot for replying! On Mon, Apr 24, 2017 at 12:55 PM, Adam Bishop <Adam.Bishop@jisc.ac.uk> wrote:
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.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html