Wow It works now. Thanks a lot Alan. ________________________________ Van: Freeradius-Users <freeradius-users-bounces+freeradius12345=outlook.com@lists.freeradius.org> namens Alan DeKok <aland@deployingradius.com> Verzonden: zondag 1 september 2019 22:04 Aan: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Onderwerp: Re: eap auth not working for realm database users On Sep 1, 2019, at 9:20 AM, Guido Kostons <freeradius12345@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-... 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@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