Problems with Freeradius + Mysql pfSense 2.0.3 i386
-
Good morning, I wonder if any of you have already configured freeradius2 with Mysql in pfSense? I ask this, because'm trying configure the freeradius2 with the Mysql in pfSense 2.0.3; but not'm managing to do the Radius write in the database. I was in the SQL option and I enabled under this topic http://forum.pfsense.org/index.php/topic, 43675.msg235475.html # msg235475 that appears in the documentation, using the root user (mysql) and all other data correct, however when adding a NAS or else a user they are not written to the database, anyone know what it could be?
-
Good morning, I wonder if any of you have already configured freeradius2 with Mysql in pfSense? I ask this, because'm trying configure the freeradius2 with the Mysql in pfSense 2.0.3; but not'm managing to do the Radius write in the database. I was in the SQL option and I enabled under this topic http://forum.pfsense.org/index.php/topic, 43675.msg235475.html # msg235475 that appears in the documentation, using the root user (mysql) and all other data correct, however when adding a NAS or else a user they are not written to the database, anyone know what it could be?
Yes.
You misunderstood the mysql option on freeradius2 package. If you add a "User" or "NAS/client" this all will be written to plain text files on pfsense. If you configure mysql on freeradius you must have a mysql server somewhere on your network. The mysql configuration on freeradius GUI ist just to make the connection to a database but it does not contain any database.
So adding users, clients and so on needs to be done on the sql server.
Hopefully this will make things clear. :)