eap auth not working for realm database users

[Guido Kostons]

Wow
It works now.
Thanks a lot Alan.

________________________________
Van: Freeradius-Users <freeradius-users-bounces+freeradius12345=outlook.com at lists.freeradius.org> namens Alan DeKok <aland at deployingradius.com>
Verzonden: zondag 1 september 2019 22:04
Aan: FreeRadius users mailing list <freeradius-users at lists.freeradius.org>
Onderwerp: Re: eap auth not working for realm database users

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.


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html