Hello Lalit,

thank for your answer.

i used the same method.
But my issue, it' on the radcheck table. In my last setup, i used a default entry for my users in the users file. And i would like to do the same thing on mysql, instead of adding it manually

kinds regard

2014-09-24 14:30 GMT+02:00 Lalit Choudhary <lalitvc@gmail.com>:
Check this link new  Freeradius with mysql installation and configuration  http://lalitvc.wordpress.com/2014/07/03/freeradius-3-0-x-installation-and-configuration-with-mysql/

On Sep 24, 2014 5:25 PM, Lovasoa Razaka <zulzig@gmail.com> wrote:
>
> Hello all.
>
> I need helps with my setup.
>
> Currently, i set up a freeradius server. I only use the next files:
> eap.conf
> hints
> clients.conf
> users
> radiusd.conf
> sites-available/default
>
> My solution allow a host with a signed certificate to switch in a specific VLAN (802.1X).
> In my the users file.
>
> I added a DEFAULT entry
> DEFAULT Hint == "host/"
>                                         Auth-Type := "EAP",
>                                         Tunnel-type = "13",
>                                         Tunnel-Medium-Type = "6",
>                                          Fall-Through = Yes
> DEFAULT Hint == "host/"
>                                         Tunnel-Private-Group-ID = "100"
>                                          Fall-Through = Yes
>
> #DEFAULT Hint =="host/"
> #                                     Tunnel-Private-Group-ID = "200"
> #                                      Fall-Through = Yes
>
> DEFAULT Hint == "host/"
>                                          Auth-Type = "reject"
>
> I would like to migrate this solution on a mysql database, but i didn't understood, how i can use a default profil with Mysql.
>
> is it the best way to do ? Or mysql is not useful for my solution.
>
> thank a lot for your help