Ubuntu 12.04 / 12.10 Install FreeRADIUS Server authenticating with a MySQL (MariaDB) Database

Assumptions

Minimal Ubuntu 12.04/12.10 installation
Completed Ubuntu 12.04 / 12.10 Server Preparation

Ports

Listening on authentication address * port 1812
Listening on accounting address * port 1813
Listening on authentication address 127.0.0.1 port 18120 as server inner-tunnel
Listening on proxy address * port 1814

Install the latest mariadb

add the repository

Import the GP key

Apt-Pinning the packages **all nodes**

Install MariaDB

New password for the MariaDB “root” user: yousecurepassword

Secure MariaDB

Enter current password for root (enter for none): yoursecurepassword
Change the root password? N
Remove anonymous users? Y
Disallow root login remotely? Y
Remove test database and access to it? Y
Reload privilege tables now? Y

Restart MariaDB (mysql server)

Confirm MariaDB is running

tcp 0 0 localhost:mysql *:* LISTEN 11878/mysqld

Install FreeRADIUS

Install Packages

Create the FreeRADIUS database user

Import the FreeRADIUS database tables

Configure FreeRADIUS
/etc/freeradius/sql.conf

Enable sql in /etc/freeradius/radiusd.conf
edit: /etc/freeradius/radiusd.conf
uncomment $INCLUDE sql.conf
uncomment $INCLUDE sql/mysql/counter.conf

Enable sql in /etc/freeradius/sites-available/default
edit: /etc/freeradius/sites-available/default
uncomment # sql in the following sections
authorize {
accounting {
session {

Randomise the secret

Add usage and rate limits to the FreeRADIUS Dictionary

Restart FreeRADIUS

FreeRADIUS Debugging

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *