Cannot get MySQL backend to work in Ubuntu 17.04

[Adam Bishop]

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.