Cannot get MySQL backend to work in Ubuntu 17.04

[Martin Rys]

> 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 at jisc.ac.uk> wrote:
> On 24 Apr 2017, at 11:47, Martin Rys <spleefer90 at 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