how to config SQL in freeradius package

[edicastro]

I tried to configure SQL in freeradius package but I dont has the sql schema of freeradius.

How to get SQL schema for pfsense freeradius config ?

[Gertjan]

You'll find it here
/usr/local/etc/raddb/mods-config/
Using sql, so enter sql/
Enter main/
And enter mysql/
where you find schema.sql
Check also .sql files for examples.

[edicastro]

@Gertjan work thank you, but users in table radcheck on database dont show in pfsense freeradius users tab. why?

[Gertjan]

@edicastro said in how to config SQL in freeradius package:

pfsense freeradius users tab. why?

Because the implementation of the "users" list in the pfSense Freeradius isn't storing this list in the database (MySQL in this case). It's using it's own flat file.
You could declare users in a SQL table (radcheck ?), but these won't het synced into this flat file.
(Free)Radius has a huge list of possible operation possibilities. The pfSense GUI just choose some of them, and hard coded the into the GUI

[edicastro]

@Gertjan said in how to config SQL in freeradius package:

SQL table (radcheck ?)

yes