eap auth not working for realm database users

[Alan DeKok]

On Sep 1, 2019, at 9:20 AM, Guido Kostons <freeradius12345 at outlook.com> wrote:
> 
> What you are trying to do:
> I setup my home wifi hobby project based on this tutorial: https://codebeta.com/unifi-with-freeradius-part-1-setup-radius-with-mariadb-mysql-7b368d4f1f15
> This works very nice with dynamic vlans and everything. The next step is to roam my laptop/mobile phone between my location and a friends house. For us this is a learning hobby project.
> 
> Why you are trying to do it:
> To make a roaming ssid between my location and the house of a friend.
> 
> I added a test realm to proxy.conf
> realm somedomain.tld {
> }

  That's good.

> Wen I test to authenticate with eapol_test with test at somedomain.tld it does not work if i test again without the realm part the user does authenticate then it does work.
> 
> Last 2 weeks I read a lot about it, I read the comments in the configuration files again and again, I read most of the freeradius documentation because I didn't want to ask nobody for help. I read many mailing list posts. I tested numerous things but all comes down to the same problem over and over again.

  The issue is that you need to change the configuration for sql_user_name.  It's in /etc/freeradius/3.0/mods-config/sql/main/mysql/queries.conf

  This configuration is unfortunately somewhat hidden.  But once you have that set up, it should work perfectly.

  Alan DEKok.