What is FreeRADIUS mysql?
‘freeradius-mysql’ is a required freeradius module so we can communicate with the mysql server. The Mysql server will store the needed data so freeradius can authenticate the client machine. Next, we will need to edit the default file to change the AAA mechanism of freeradius from file system to sql server.
How do I start a RADIUS server?
Installing the RADIUS daemon
- Obtain and compile the RADIUS daemon.
- Install the Ascend RADIUS dictionary.
- Create and configure the clients file.
- Create the users file.
- Create the log file.
- Specify the MAX TNT unit’s name and IP address.
- Specify the RADIUS daemon’s authentication port.
How do I configure FreeRADIUS to use SQL?
Configuring FreeRADIUS to use SQL. Edit /etc/mods-available/sql module and enter the SQL dialect, driver, server, username and password details to connect to your SQL server and the RADIUS database. The database and table names should be left at the defaults if you used the default schema.
What happens if FreeRADIUS fails over to another MySQL server?
Note that if FreeRADIUS fails over to the second MySQL server and tries to update the accounting table (radacct), nasty things might possibly happen to your replication setup and database integrity as the first MySQL server won’t have got the updates…
What is’FreeRADIUS-MySQL’and how to use it?
‘freeradius-mysql’ is a required freeradius module so we can communicate with the mysql server. The Mysql server will store the needed data so freeradius can authenticate the client machine. Next, we will need to edit the default file to change the AAA mechanism of freeradius from file system to sql server.
How do I set up FreeRADIUS on a Cisco NAS?
Before starting with FreeRADIUS, please make sure your server is up and configured on your network, that you have your SQL server of choice (MySQL, Postgresql etc) installed and running, and that your NAS is configured to send RADIUS requests to your RADIUS server. We have some sample configs for Cisco NAS available here .