FreeRadius Installation with MySQL Integration on Ubuntu Linux

Would you like to learn how to perform a Freeradius installation with MySQL integration on Ubuntu Linux? In this tutorial, we are going to show you how to install Freeradius on Ubuntu Linux and how to access your radius server for the first time.

• Ubuntu 18.04
• Ubuntu 19.04
• FreeRadius 3.0.16

FreeRadius Tutorial:

On this page, we offer quick access to a list of Grafana tutorials.

Tutorial - FreeRadius Installation on Ubuntu Linux

On the Linux console, use the following commands to install the FreeRadius and the MySQL service.

# apt-get update
# apt-get install freeradius freeradius-mysql mysql-server mysql-client

After finishing the installation, use the following command to access the MySQL database server.

# mysql -u root -p

On the MySQl server console, we need to perform the following tasks:

• Create a database named radius.
• Create a MySQL user named radius.
• Give permission over the radius database to the radius user.

Copy to Clipboard

Locate the correct schema.sql file and the import radius database template inside MySQL.

Locate the correct setup.sql file and the import radius database template inside MySQL.

The system will request the password of the radius SQL user every time you try to import a file.

# updatedb
# locate main/mysql/schema.sql | grep freeradius
# mysql -u radius -p radius < /etc/freeradius/3.0/mods-config/sql/main/mysql/schema.sql

Create a symbolic link to enable the Freeradius MySQL module.

# ln -s /etc/freeradius/3.0/mods-available/sql /etc/freeradius/3.0/mods-enabled/

You have enabled the FreeRadius MySQL module successfully.

Freeradius Configuration - MySQL Authentication

Now, we need to configure FreeRadius and enable MySQL authentication.

Edit the SQL file inside the /etc/freeradius/3.0/mods-enabled directory.

# vi /etc/freeradius/3.0/mods-enabled/sql

Here is the content of the SQL file before our configuration.

Copy to Clipboard

Edit the SQL configuration file and insert the Radius MYSQL database information.

Here is the file after our configuration.

Copy to Clipboard

sql {
        driver = "rlm_sql_mysql"
        dialect = "mysql"
        server = "localhost"
        port = 3306
        login = "radius"
        password = "kamisama123"
        radius_db = "radius"
        acct_table1 = "radacct"
        acct_table2 = "radacct"
        postauth_table = "radpostauth"
        authcheck_table = "radcheck"
        groupcheck_table = "radgroupcheck"
        authreply_table = "radreply"
        groupreply_table = "radgroupreply"
        usergroup_table = "radusergroup"
        delete_stale_sessions = yes
        pool {
                start = ${thread[pool].start_servers}
                min = ${thread[pool].min_spare_servers}
                max = ${thread[pool].max_servers}
                spare = ${thread[pool].max_spare_servers}
                uses = 0
                retry_delay = 30
                lifetime = 0
                idle_timeout = 60
        }
        read_clients = yes
        client_table = "nas"
        group_attribute = "SQL-Group"
        $INCLUDE ${modconfdir}/${.:name}/main/${dialect}/queries.conf
}

After finishing the configuration, restart the Freeradius service.

# service freeradius restart

You have finished the FreeRadius server installation successfully.

Daloradius Installation on Ubuntu Linux

Now, we are going to install a web administration tool named Daloradius.

Use the following commands to install the Apache web server and the required modules.

# apt-get install apache2 php libapache2-mod-php php-mysql unzip
# apt-get install php-pear php-db php-mail php-gd php-common php-mail-mime

Download and extract the Daloradius software.

Move the Daloradius installation files inside the Apache web server root directory.

# mkdir /downloads/daloradius -p
# cd /downloads/daloradius
# wget https://github.com/lirantal/daloradius/archive/master.zip
# unzip master.zip
# mv daloradius-master /var/www/html/daloradius

Import the Daloradius database template inside MySQL.

Use the following commands to import the database template inside MySQL.

The system will request the password of the radius SQL user every time you try to import a file.

# cd /var/www/html/daloradius/contrib/db/
# mysql -u radius -p radius < fr2-mysql-daloradius-and-freeradius.sql
# mysql -u radius -p radius < mysql-daloradius.sql

Edit the file daloradius.conf.php configuration file.

# vi /var/www/html/daloradius/library/daloradius.conf.php

Configure the file to connect to your Radius MySQL database.

Here is the daloradius.conf.php file before our configuration.

Copy to Clipboard

Here is the daloradius.conf.php file with our configuration.

Copy to Clipboard

Set the correct file permission on the Daloradius folder.

Restart the Apache web server.

# chown www-data.www-data /var/www/html/daloradius/* -R
# service freeradius restart
# service apache2 restart

You have finished the DaloRadius installation successfully.

Accessing DaloRadius

Open your browser and enter the IP address of your web server plus /daloradius.

In our example, the following URL was entered in the Browser:

• http://35.162.85.57/daloradius

The Daloradius web interface should be presented.

On the login screen, use the default username and default password.

• Default Username: administrator
• Default Password: radius

After a successful login, you will be sent to the Daloradius Dashboard.

Congratulations! You were able to access the Daloradius web interface.

DaloRadius - Adding a User Account

Let's use Daloradius to create a new user account that will be stored on the MySQL database.

On the Daloradius dashboard, access the Management Menu and click on the New User option.

After finishing the configuration click on the Apply button.

Freeradius Authentication Test

Test your radius authentication locally on the Radius server using the following commands:

# radtest bruno boss123 localhost 0 testing123

Here is an example of a successful radius authentication:

Copy to Clipboard

We are using the Bruno username and the boss123 password to authenticate the user account.

The testing123 is a default device password included in the clients.conf file for local tests.

FreeRadius Installation with MySQL Integration on Ubuntu Linux