MySQL as a user store
FreeRADIUS can connect to an SQL database to retrieve a user's details. The FreeRADIUS SQL modules work in pairs. A generic SQL module makes use of a specific database module to interact with the database. This allows easy support for different databases.
Just as the files module uses the users file to retrieve information for authorization and authentication, so does the generic SQL module use the specific database module to retrieve the same type of information from a database.
MySQL is a very popular open source database. Despite speculation about its future under Oracle, it still remains a trustworthy database on which millions of people depend.
MySQL is easy to configure and most people are familiar with it. FreeRADIUS deployments with MySQL outnumber FreeRADIUS deployments with any other database. We are following this trend and will show you how to include a MySQL database as a user store.
