{"id":1794,"date":"2019-05-22T20:09:54","date_gmt":"2019-05-22T20:09:54","guid":{"rendered":"https:\/\/draculaservers.com\/tutorials\/?p=1794"},"modified":"2021-11-14T20:35:58","modified_gmt":"2021-11-14T20:35:58","slug":"install-freeradius-daloradius-debian-9-mysql","status":"publish","type":"post","link":"https:\/\/draculaservers.com\/tutorials\/install-freeradius-daloradius-debian-9-mysql\/","title":{"rendered":"Install and Configure FreeRADIUS &#038; daloRADIUS on Debian 9 with MySQL"},"content":{"rendered":"<h2 id=\"what-is-freeradius\">What is FreeRADIUS?<\/h2>\n<p>FreeRADIUS is very popular open-source RADIUS server. It&#8217;s been developed since the dial-up era, and it&#8217;s still going strong today, being used by a great deal of companies around the world, including many Fortune 500 companies.<\/p>\n<p>FreeRADIUS supports all of the authentication protocols and offers the AAA protocols ( Authentication, Authorization, and accounting). It&#8217;s typically used for managing users and keeping track of bandwidth usage, and it&#8217;s a popular solution for networking software such as OpenVPN, SoftEther, Squid Proxies and WiFi hotspots.<\/p>\n<p>In this tutorial we&#8217;ll install FreeRADIUS on a machine running Debian 9. We&#8217;ll also configure it to use MySQL, and we&#8217;ll install daloRADIUS which is an open-source control panel for managing your RADIUS server.<\/p>\n<p>Should you want to use a different operating system, do visit one of our other tutorials:<\/p>\n<ul>\n<li><a href=\"https:\/\/draculaservers.com\/tutorials\/freeradius-ubuntu-18-04-mysql\/\">Install and Configure FreeRADIUS on Ubuntu 18.04 with MySQL<\/a><\/li>\n<li><a href=\"https:\/\/draculaservers.com\/tutorials\/freeradius-centos-7-mysql\/\">Install &amp; Configure FreeRADIUS on CentOS 7 with MySQL \/ MariaDB<\/a><\/li>\n<\/ul>\n\n<h2 id=\"how-to-set-up-freeradius\">How to set up FreeRADIUS?<\/h2>\n<p>We present 2 methods to set up your RADIUS server:<\/p>\n<p>1. <strong>Manual FreeRADIUS Install<\/strong> &#8211; By following this tutorial you&#8217;ll be setting up FreeRADIUS on a Debian 9 machine. Along with other configurations you may need to make, this may take 30 minutes if you&#8217;re familiar with FreeRADIUS to several hours if you&#8217;re just starting.<\/p>\n<p>2. <strong>Instant FreeRADIUS Server Deployment<\/strong> &#8211; You can deploy your server instantly and it will have FreeRADIUS + MySQL + daloRADIUS set up in less than 5 minutes, by using our <a href=\"https:\/\/draculaservers.com\/freeradius.php\" target=\"_blank\" rel=\"noopener noreferrer\">FreeRADIUS KVM Servers<\/a>. Should you also need it, you can also opt for our priority support addon which will ensure that you receive our assistance with any RADIUS related issue from then on.<\/p>\n<h2 id=\"method-1-instant-freeradius-server-deloyment\">Method 1 &#8211; Instant FreeRADIUS Server Deloyment<\/h2>\n<p>If you need to set up RADIUS servers fast and don&#8217;t have time to learn the intricacies of the software, then you can rely on our <a href=\"https:\/\/draculaservers.com\/freeradius.php\" target=\"_blank\" rel=\"noopener noreferrer\">FreeRADIUS Server Plans<\/a>. All you have to do is choose one of the available packages, and one of our available addons if needed, and the server will be set up in less than 5 minutes. After which, you&#8217;ll see all your related credentials the first time you SSH onto the server.<\/p>\n<div class=\"container custom-content-block\" style=\"background-color: #282a36; border-radius: 3px; padding: 20px 25px 35px 25px !important; margin-top: 60px; margin-bottom: 60px;\">\r\n<div class=\"row\">\r\n<div class=\"col-lg-12\">\r\n<p style=\"color: #72f672; font-weight: bold !important; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important;\">Pre-Installed FreeRADIUS Servers<\/p>\r\n<p style=\"color: #72f672; font-weight: bold !important; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important;\"><span style=\"color: #ffffff; font-weight: 300;\">Automatic FreeRADIUS 3 + daloRADIUS Set Up<\/span><\/p>\r\n\r\n<\/div>\r\n<div class=\"col-lg-12\">\r\n<p style=\"color: #60709f; font-size: 1em; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important;\">Instantly deploy machines with FreeRADIUS + MySQL + daloRADIUS GUI Panel already set up, receive the credentials and take over from there! You also get our custom WHMCS Module to help you manage it from our dashboard.<\/p>\r\n\r\n<\/div>\r\n<div class=\"col-lg-12\">\r\n<p style=\"color: #ffffff; font-weight: bold !important; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important;\">Pick one of our FreeRADIUS KVM plans<\/p>\r\n\r\n<\/div>\r\n<div class=\"col-lg-12\"><a role=\"button\" aria-pressed=\"true\" class=\"btn btn-primary btn-lg\" style=\"background-color: #58689e; color: #ffffff; box-shadow: 0 2px 2px 0 #3F51B5, 0 3px 1px -2px #3F51B5, 0 1px 5px 0 #3F51B5; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important; font-weight: bold !important;\" href=\"https:\/\/draculaservers.com\/freeradius.php#choose-plan\" target=\"_blank\" rel=\"noopener\">Get started now<\/a><\/div>\r\n<\/div>\r\n\r\n<br \/>\r\n<p style=\"color: #ff5555; font-size: 0.9em; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important;\">P.S. We're available for hire, if you need help. <a href=\"https:\/\/draculaservers.com\/members\/submitticket.php\">Click here to contact us<\/a>.<\/p>\r\n<\/div>\n<h2 id=\"method-2-manual-freeradius-install\">Method 2 &#8211; Manual FreeRADIUS Install<\/h2>\n<p>Should you choose to install manually, then we&#8217;ve got you covered. Should you encounter any issues with following this tutorial, then hit us up and we&#8217;ll try to help solve the problem as soon as we can.<\/p>\n<p>Without further ado, let&#8217;s get to setting up our RADIUS server.<\/p>\n<h2 id=\"install-lamp-stack-on-debian-9\">Install LAMP Stack on Debian 9<\/h2>\n<blockquote class=\"note\"><p><small><strong>NOTE: <\/strong> If you already have LAMP Stack installed on your Dabian 9 machine, or don&#8217;t want to install the daloRADIUS FreeRADIUS GUI, then feel free to skip to the FreeRADIUS installation<\/small><\/p><\/blockquote>\n<p>Before anything else, make sure you update &amp; upgrade your system.:<\/p>\n<pre><code>$ apt update\n$ apt upgrade<\/code><\/pre>\n<h3 id=\"install-apache\">Install Apache<\/h3>\n<pre><code>$ apt install apache2<\/code><\/pre>\n<p>Apache should be running right away. To check it&#8217;s status run the following:<\/p>\n<pre><code>$ systemctl status apache2\n\u25cf apache2.service - The Apache HTTP Server\n   Loaded: loaded (\/lib\/systemd\/system\/apache2.service; enabled; vendor preset: \n   Active: active (running) since Thu 2019-05-16 19:05:47 UTC; 8s ago\n Main PID: 29784 (apache2)\n   CGroup: \/system.slice\/apache2.service\n           \u251c\u250029784 \/usr\/sbin\/apache2 -k start\n           \u251c\u250029786 \/usr\/sbin\/apache2 -k start\n           \u2514\u250029787 \/usr\/sbin\/apache2 -k start\n\nMay 16 19:05:47 debian_radius systemd[1]: Starting The Apache HTTP Server...\nMay 16 19:05:47 debian_radius apachectl[29773]: AH00558: apache2: Could not reli\nMay 16 19:05:47 debian_radius systemd[1]: Started The Apache HTTP Server.\n...<\/code><\/pre>\n<p>You can also check that Apache is running by visiting <code>http:\/\/your_server_ip_or_domain<\/code>, and should see something like the following screenshot:<\/p>\n<p><a href=\"https:\/\/draculaservers.com\/tutorials\/install-freeradius-daloradius-debian-9-mysql\/freeradius_debian_9_apache\/\" rel=\"attachment wp-att-1795\"><img loading=\"lazy\" decoding=\"async\" width=\"1252\" height=\"837\" class=\"aligncenter size-full wp-image-1795\" src=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/freeradius_debian_9_apache.png\" alt=\"apache-installed\" srcset=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/freeradius_debian_9_apache.png 1252w, https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/freeradius_debian_9_apache-300x201.png 300w, https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/freeradius_debian_9_apache-1024x685.png 1024w, https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/freeradius_debian_9_apache-768x513.png 768w, https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/freeradius_debian_9_apache-360x240.png 360w\" sizes=\"auto, (max-width: 1252px) 100vw, 1252px\" \/><\/a><\/p>\n<h3 id=\"install-mysql-on-debian-9\">Install MySQL on Debian 9<\/h3>\n<p>Install MySQL by running the following command:<\/p>\n<pre><code>$ apt install mysql-server<\/code><\/pre>\n<p>MySQL comes with a script that helps you change some insecure defaults, such as:<\/p>\n<ul>\n<li>setting root password<\/li>\n<li>removing anonymous users<\/li>\n<li>disallowing remote login<\/li>\n<li>removing test database<\/li>\n<\/ul>\n<p>Run the script with the command:<\/p>\n<pre><code>$ mysql_secure_installation<\/code><\/pre>\n<p>We recommend you answer the prompts as follows.<\/p>\n<p>First press enter when prompted for the <strong>root password<\/strong>:<\/p>\n<pre><code>Enter current password for root (enter for none): Enter<\/code><\/pre>\n<p>Confirm that you want to set the root password and then set a complicated password for MySQL.<\/p>\n<pre><code>Setting the root password ensures that nobody can log into the MariaDB\nroot user without the proper authorisation.\n\nSet root password? [Y\/n] Y\nNew password: S0me_Str0ng_Passw0rd\nRe-enter new password: S0me_Str0ng_Passw0rd\nPassword updated successfully!\nReloading privilege tables..\n ... Success!<\/code><\/pre>\n<p>Confirm removing anonymous users.<\/p>\n<pre><code>Remove anonymous users? [Y\/n] y\n ... Success!<\/code><\/pre>\n<p>Disallow root login remotely.<\/p>\n<pre><code>Disallow root login remotely? [Y\/n] y\n ... Success!<\/code><\/pre>\n<p>Remove the test database.<\/p>\n<pre><code>Remove test database and access to it? [Y\/n] y\n - Dropping test database...\n ... Success!\n - Removing privileges on test database...\n ... Success!<\/code><\/pre>\n<p>Reload privilege tables.<\/p>\n<pre><code>Reload privilege tables now? [Y\/n] y\n ... Success!\n\nCleaning up...<\/code><\/pre>\n<p>At this point, MySQL should be successfully set up on your Debian 9 machine.<\/p>\n<h3 id=\"install-php-on-debian-9\">Install PHP on Debian 9<\/h3>\n<p>Run the following command to install PHP and common extensions:<\/p>\n<pre><code>$ apt install php libapache2-mod-php php-mysql php-common php-gd php-mbstring php-curl php-xml<\/code><\/pre>\n<p>Now configure Apache so it processes PHP content. Do this by editing the file <code>\/etc\/apache2\/mods-available\/dir.conf<\/code> in your favorite text editor:<\/p>\n<pre><code>$ nano \/etc\/apache2\/mods-available\/dir.conf<\/code><\/pre>\n<p>To configure Apache to process PHP, add <strong>index.php<\/strong> as the first value of <code>DirectoryIndex<\/code>.<\/p>\n<pre><code>\n        DirectoryIndex index.php index.html index.cgi index.pl index.php index.$\n\n\n# vim: syntax=apache ts=4 sw=4 sts=4 sr noet<\/code><\/pre>\n<p>Save and close the file when you&#8217;re done.<\/p>\n<p>Finally restart Apache:<\/p>\n<pre><code>$ systemctl restart apache2<\/code><\/pre>\n<h2 id=\"install-freeradius-on-debian-9\">Install FreeRADIUS on Debian 9<\/h2>\n<p>Install FreeRADIUS and it&#8217;s dependencies:<\/p>\n<pre><code>$ sudo apt install -y freeradius freeradius-utils freeradius-mysql<\/code><\/pre>\n<p>Enable FreeRADIUS so it runs after you restart the system:<\/p>\n<pre><code>$ systemctl enable freeradius<\/code><\/pre>\n<p>For now stop FreeRADIUS so you can run it in debug mode and check if everything&#8217;s running correctly:<\/p>\n<pre><code>$ systemctl stop freeradius<\/code><\/pre>\n<p>Next, run FreeRADIUS in debug mode:<\/p>\n<pre><code>$ freeradius -X<\/code><\/pre>\n<p>If everything&#8217;s working OK, the output should be something like this:<\/p>\n<pre><code>...\nlisten {\n  \ttype = \"acct\"\n  \tipv6addr = ::\n  \tport = 0\n   limit {\n   \tmax_connections = 16\n   \tlifetime = 0\n   \tidle_timeout = 30\n   }\n}\nListening on auth address 127.0.0.1 port 18120 bound to server inner-tunnel\nListening on auth address * port 1812 bound to server default\nListening on acct address * port 1813 bound to server default\nListening on auth address :: port 1812 bound to server default\nListening on acct address :: port 1813 bound to server default\nListening on proxy address * port 37669\nListening on proxy address :: port 58519\nReady to process requests<\/code><\/pre>\n<p>Log into the MySQL console as <code>root<\/code>:<\/p>\n<pre><code>$ mysql -u root -p\nEnter Password: S0me_Str0ng_Passw0rd<\/code><\/pre>\n<p>Create a database and user for RADIUS:<\/p>\n<pre><code>create database radius;\ngrant all privileges on radius.* to radius@localhost identified by 'str0ng_radius_p@ssw0rd';\nflush privileges;\nquit<\/code><\/pre>\n<p>Next, import the FreeRADIUS database schema that shipped with FreeRADIUS &#8211; it&#8217;s located at <code>\/etc\/freeradius\/3.0\/mods-config\/sql\/main\/mysql\/schema.sql<\/code>:<\/p>\n<pre><code>$ mysql -u root -p radius &lt; \/etc\/freeradius\/3.0\/mods-config\/sql\/main\/mysql\/schema.sql\nEnter Password: S0me_Str0ng_Passw0rd<\/code><\/pre>\n<p>Enable the FreeRADIUS SQL module by creating a symbolic link to the <code>sql module<\/code> from <code>\/etc\/freeradius\/3.0\/mods-available\/<\/code> to <code>mods-enabled<\/code>:<\/p>\n<pre><code>$ ln -s \/etc\/freeradius\/3.0\/mods-available\/sql \/etc\/freeradius\/3.0\/mods-enabled\/<\/code><\/pre>\n<p>Open <code>\/etc\/freeradius\/3.0\/mods-available\/sql<\/code> with your favorite editor&#8230;<\/p>\n<pre><code>$ nano \/etc\/freeradius\/3.0\/mods-available\/sql<\/code><\/pre>\n<p>Change the following values, as well as uncommenting them by removing the <code>#<\/code> sign at the beginning of their lines:<\/p>\n<pre><code>dialect = \"mysql\"\n\nserver = \"localhost\"\nport = 3306\nlogin = \"radius\"\npassword = \"str0ng_radius_p@ssw0rd\"\n\nradius_db = \"radius\"<\/code><\/pre>\n<p>Look for the line locating <code>read_clients = yes<\/code>. You&#8217;ll probably see that it starts with a <code>#<\/code> sign, which means that it&#8217;s commented out. Delete the <code>#<\/code> sign to enable FreeRADIUS to read clients from the database. It should look like this after you&#8217;re done:<\/p>\n<pre><code>...\n        # Set to 'yes' to read radius clients from the database ('nas' table)\n        # Clients will ONLY be read on server startup.\n        read_clients = yes\n...<\/code><\/pre>\n<p>Save and exit the file when you&#8217;re done.<\/p>\n<p>Change the ownership and group for the SQL module to <code>freerad<\/code> with the following command:<\/p>\n<pre><code>$ chown -h freerad.freerad \/etc\/freeradius\/3.0\/mods-enabled\/sql<\/code><\/pre>\n<p>Restart FreeRADIUS:<\/p>\n<pre><code>$ systemctl restart freeradius<\/code><\/pre>\n<h2 id=\"install-daloradius-on-debian-9\">Install daloRADIUS on Debian 9<\/h2>\n<p><strong>daloRADIUS<\/strong> is an open-source, advanced RADIUS web control panel. It provides an easy interface for managing users, graphical reporting, accounting, a billing engine, and it integrates with Google Maps. Common uses for daloRADIUS are managing ISP deployments and hotspots.<\/p>\n<h3 id=\"prerequisites\">Prerequisites<\/h3>\n<p>First, install some required PHP extensions:<\/p>\n<pre><code>$ apt install php-mail php-mail-mime php-pear<\/code><\/pre>\n<p>Install the PHP Pear DB library:<\/p>\n<pre><code>$ pear install DB<\/code><\/pre>\n<h3 id=\"install-daloradius\">Install daloRADIUS<\/h3>\n<p>Download the latest version of daloRADIUS from the <a href=\"https:\/\/sourceforge.net\/projects\/daloradius\/\">daloRADIUS Project page on SourceForge<\/a>.<\/p>\n<p>The current latest version of daloRADIUS available there is daloRADIUS 0.9-9. To download it run the following command:<\/p>\n<pre><code>$ cd\n$ wget http:\/\/liquidtelecom.dl.sourceforge.net\/project\/daloradius\/daloradius\/daloradius0.9-9\/daloradius-0.9-9.tar.gz<\/code><\/pre>\n<p>Once downloaded, extract the archive using the following command:<\/p>\n<pre><code>$ tar -xzf daloradius-0.9-9.tar.gz<\/code><\/pre>\n<p>And move the daloRADIUS folder to the root directory of your server:<\/p>\n<pre><code>$ mv daloradius-0.9-9 \/var\/www\/html\/daloradius<\/code><\/pre>\n<p>Add the daloRADIUS SQL schema:<\/p>\n<pre><code>$ mysql -u root -p radius &lt; \/var\/www\/html\/daloradius\/contrib\/db\/fr2-mysql-daloradius-and-freeradius.sql\n$ mysql -u root -p radius &lt; \/var\/www\/html\/daloradius\/contrib\/db\/mysql-daloradius.sql<\/code><\/pre>\n<p>Change the owner of the daloRADIUS configuration files:<\/p>\n<pre><code>$ chown -R www-data:www-data \/var\/www\/html\/daloradius<\/code><\/pre>\n<p>Change the permissions of the main daloRADIUS configuration file to <code>664<\/code>:<\/p>\n<pre><code>$ chmod 664 \/var\/www\/html\/daloradius\/library\/daloradius.conf.php<\/code><\/pre>\n<p>Open the daloRADIUS configuration file and change the database connection parameters as follows:<\/p>\n<pre><code>$ nano \/var\/www\/html\/daloradius\/library\/daloradius.conf.php<\/code><\/pre>\n<pre><code>...\n$configValues['DALORADIUS_VERSION'] = '0.9-9';\n$configValues['FREERADIUS_VERSION'] = '2';\n$configValues['CONFIG_DB_ENGINE'] = 'mysqli';\n$configValues['CONFIG_DB_HOST'] = 'localhost';\n$configValues['CONFIG_DB_PORT'] = '3306';\n$configValues['CONFIG_DB_USER'] = 'radius';\n$configValues['CONFIG_DB_PASS'] = 'str0ng_radius_p@ssw0rd';\n$configValues['CONFIG_DB_NAME'] = 'radius';\n...<\/code><\/pre>\n<p>Do make sure you&#8217;ve changed <code>$configValues['CONFIG_DB_ENGINE'] = 'mysql';<\/code> to <code>$configValues['CONFIG_DB_ENGINE'] = 'mysqli';<\/code>, or else you may get an error when trying to log into daloRADIUS:<\/p>\n<pre><code>Error Message: DB Error: extension not found<\/code><\/pre>\n<p>Save and close the file when you&#8217;re finished, and restart freeRADIUS:<\/p>\n<pre><code>$ systemctl restart freeradius<\/code><\/pre>\n<h3 id=\"verifying-daloradius-installation\">Verifying daloRADIUS Installation<\/h3>\n<p>At this point daloRADIUS should be installed on your Debian 9 machine.<\/p>\n<p>To test and use it, visit <code>http:\/\/domain_or_server_IP\/daloradius<\/code> in your browser. In my case, I&#8217;m visiting:<\/p>\n<pre><code>http:\/\/my_server_ip\/daloradius<\/code><\/pre>\n<p><a href=\"https:\/\/draculaservers.com\/tutorials\/install-freeradius-daloradius-debian-9-mysql\/daloradius_debian_1\/\" rel=\"attachment wp-att-1796\"><img loading=\"lazy\" decoding=\"async\" width=\"1384\" height=\"604\" class=\"aligncenter size-full wp-image-1796\" src=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/daloradius_debian_1.png\" alt=\"daloradius_debian_1\" srcset=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/daloradius_debian_1.png 1384w, https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/daloradius_debian_1-300x131.png 300w, https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/daloradius_debian_1-1024x447.png 1024w, https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/daloradius_debian_1-768x335.png 768w\" sizes=\"auto, (max-width: 1384px) 100vw, 1384px\" \/><\/a><\/p>\n<p>The default login credentials are:<\/p>\n<p><code>Username:<\/code> Administrator<\/p>\n<p><code>Password:<\/code> radius<\/p>\n<p><a href=\"https:\/\/draculaservers.com\/tutorials\/install-freeradius-daloradius-debian-9-mysql\/daloradius_debian_dashboard\/\" rel=\"attachment wp-att-1797\"><img loading=\"lazy\" decoding=\"async\" width=\"1505\" height=\"958\" class=\"aligncenter size-full wp-image-1797\" src=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/daloradius_debian_dashboard.png\" alt=\"daloradius_debian_dashboard\" srcset=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/daloradius_debian_dashboard.png 1505w, https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/daloradius_debian_dashboard-300x191.png 300w, https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/daloradius_debian_dashboard-1024x652.png 1024w, https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/daloradius_debian_dashboard-768x489.png 768w\" sizes=\"auto, (max-width: 1505px) 100vw, 1505px\" \/><\/a><\/p>\n<h2 id=\"testing-freeradius\">Testing FreeRADIUS<\/h2>\n<p>FreeRADIUS and daloRADIUS should now be installed and configured. To make sure that the server works, we&#8217;ll create a user from the web panel and then send an Authentication request to the server.<\/p>\n<h3 id=\"create-nas-client-user\">Create NAS Client &amp; User<\/h3>\n<p>For another computer to connect to our RADIUS server, it needs to be added to the <strong>NAS Client Table<\/strong> in the RADIUS database.<\/p>\n<p>We&#8217;re just starting, so we&#8217;ll need to add a new NAS. Do this by first navigating to <strong>Management &gt; NAS &gt; New NAS<\/strong>.<\/p>\n<p><a href=\"https:\/\/draculaservers.com\/tutorials\/freeradius-ubuntu-18-04-mysql\/nas_dalo_radius\/\" rel=\"attachment wp-att-1105\"><img loading=\"lazy\" decoding=\"async\" width=\"743\" height=\"330\" class=\"aligncenter size-full wp-image-1105\" src=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2018\/12\/nas_dalo_radius.png\" alt=\"\" srcset=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2018\/12\/nas_dalo_radius.png 743w, https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2018\/12\/nas_dalo_radius-300x133.png 300w\" sizes=\"auto, (max-width: 743px) 100vw, 743px\" \/><\/a><\/p>\n<p>Now add a new <strong>User<\/strong> by navigating to <strong>Management &gt; Users &gt; New Users<\/strong> and filling the form similarly to the following:<\/p>\n<p><a href=\"https:\/\/draculaservers.com\/tutorials\/freeradius-ubuntu-18-04-mysql\/daloradius\/\" rel=\"attachment wp-att-1103\"><img loading=\"lazy\" decoding=\"async\" width=\"777\" height=\"383\" class=\"aligncenter size-full wp-image-1103\" src=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2018\/12\/daloradius.jpg\" alt=\"\" srcset=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2018\/12\/daloradius.jpg 777w, https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2018\/12\/daloradius-300x148.jpg 300w, https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2018\/12\/daloradius-768x379.jpg 768w\" sizes=\"auto, (max-width: 777px) 100vw, 777px\" \/><\/a><\/p>\n<p>There are more attributes you can add to users and groups, but that&#8217;s beyond the scope of this tutorial.<\/p>\n<p>Now we should test the NAS and User. Remember that every time a NAS is added, you need to restart FreeRADIUS so it fetches the updated table.<\/p>\n<p>To test our setup, we&#8217;ll have to run in <strong>debug mode<\/strong> to check out the output. However, FreeRADIUS is probably still running. So to run it in debug mode we&#8217;ll have to stop the running service and start it in debug mode using the <code>-X<\/code> flag:<\/p>\n<pre><code>$ service freeradius stop\n$ freeradius -X<\/code><\/pre>\n<p>You&#8217;ll see something like this:<\/p>\n<pre><code>...\nListening on auth address 127.0.0.1 port 18120 bound to server inner-tunnel\nListening on auth address * port 1812 bound to server default\nListening on acct address * port 1813 bound to server default\nListening on auth address :: port 1812 bound to server default\nListening on acct address :: port 1813 bound to server default\nListening on proxy address * port 46000\nListening on proxy address :: port 59411\nReady to process requests<\/code><\/pre>\n<h3 id=\"test-with-ntradping\">Test with NTRadPing<\/h3>\n<p>To test our server we can use a nice tool called NTRadPing. You can download it here: <a href=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2018\/12\/ntradping.zip\">ntradping<\/a>.<\/p>\n<p>To run it, just unzip the archive and run the executable. Fill it with the credentials you created earlier, while keeping in mind that the port RADIUS uses is <code>1812<\/code>:<\/p>\n<p>RADIUS Server\/port: <code>your_server_ip \/ 1812<\/code><br \/>\nRADIUS Secret Key: <code>strongsecret!<\/code><br \/>\nPassword: <code>Strongpassword<\/code><\/p>\n<p>And check the <code>CHAP<\/code> checkbox.<\/p>\n<p><a href=\"https:\/\/draculaservers.com\/tutorials\/freeradius-centos-7-mysql\/radius_test_ntradping\/\" rel=\"attachment wp-att-1745\"><img loading=\"lazy\" decoding=\"async\" width=\"680\" height=\"427\" class=\"aligncenter size-full wp-image-1745\" src=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/radius_test_ntradping.png\" alt=\"radius_test_ntradping\" srcset=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/radius_test_ntradping.png 680w, https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/radius_test_ntradping-300x188.png 300w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/a><\/p>\n<p>Now click send in <strong>NTRadPing<\/strong>. The output in NTRadPing should look something like this:<\/p>\n<pre><code>Sending authentication request to server xx.xx.xx.xx.:1812\ntransmiting Packet, code=1 id=2 length=50\nrecieved response from the server in 145 milliseconds\nreplay packet code=3 id=2 length=20\nresponse: Access-Accept\n-------------------attribute dump------------------<\/code><\/pre>\n<p>The output on the RADIUS server should look something like this:<\/p>\n<pre><code>(0) sql: SQL-User-Name set to 'test_user1'\n(0) sql: EXPAND INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{SQL-User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S')\n(0) sql:    --&gt; INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( 'test_user1', '0x61a8a6390c46259cf64b56697fd5d78ad5', 'Access-Accept', '2019-05-06 19:00:56.660290')\n(0) sql: Executing query: INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( 'test_user1', '0x61a8a6390c46259cf64b56697fd5d78ad5', 'Access-Accept', '2019-05-06 19:00:56.660290')\n(0) sql: SQL query returned: success\n(0) sql: 1 record(s) updated\nrlm_sql (sql): Released connection (6)\n(0)     [sql] = ok\n(0)     [exec] = noop\n(0)     policy remove_reply_message_if_eap {\n(0)       if (&amp;reply:EAP-Message &amp;&amp; &amp;reply:Reply-Message) {\n(0)       if (&amp;reply:EAP-Message &amp;&amp; &amp;reply:Reply-Message)  -&gt; FALSE\n(0)       else {\n(0)         [noop] = noop\n(0)       } # else = noop\n(0)     } # policy remove_reply_message_if_eap = noop\n(0)   } # post-auth = ok\n(0) Sent Access-Accept Id 3 from 108.61.203.68:1812 to 213.136.66.127:56372 length 0\n(0) Finished request\nWaking up in 4.9 seconds.\n(0) Cleaning up request packet ID 3 with timestamp +6110\nReady to process requests<\/code><\/pre>\n<h2 id=\"conclusion\">Conclusion<\/h2>\n<p>And that&#8217;s it. You&#8217;ve successfully installed FreeRADIUS + daloRADIUS with MySQL on Debian 9.<\/p>\n<p>Should you encounter any issues, don&#8217;t hesitate to get in touch with and we&#8217;ll do our best to be of assistance.<\/p>\n<div class=\"container custom-content-block\" style=\"background-color: #282a36; border-radius: 3px; padding: 20px 25px 35px 25px !important; margin-top: 60px; margin-bottom: 60px;\">\r\n<div class=\"row\">\r\n<div class=\"col-lg-12\">\r\n<p style=\"color: #72f672; font-weight: bold !important; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important;\">Pre-Installed FreeRADIUS Servers<\/p>\r\n<p style=\"color: #72f672; font-weight: bold !important; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important;\"><span style=\"color: #ffffff; font-weight: 300;\">Automatic FreeRADIUS 3 + daloRADIUS Set Up<\/span><\/p>\r\n\r\n<\/div>\r\n<div class=\"col-lg-12\">\r\n<p style=\"color: #60709f; font-size: 1em; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important;\">Instantly deploy machines with FreeRADIUS + MySQL + daloRADIUS GUI Panel already set up, receive the credentials and take over from there! You also get our custom WHMCS Module to help you manage it from our dashboard.<\/p>\r\n\r\n<\/div>\r\n<div class=\"col-lg-12\">\r\n<p style=\"color: #ffffff; font-weight: bold !important; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important;\">Pick one of our FreeRADIUS KVM plans<\/p>\r\n\r\n<\/div>\r\n<div class=\"col-lg-12\"><a role=\"button\" aria-pressed=\"true\" class=\"btn btn-primary btn-lg\" style=\"background-color: #58689e; color: #ffffff; box-shadow: 0 2px 2px 0 #3F51B5, 0 3px 1px -2px #3F51B5, 0 1px 5px 0 #3F51B5; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important; font-weight: bold !important;\" href=\"https:\/\/draculaservers.com\/freeradius.php#choose-plan\" target=\"_blank\" rel=\"noopener\">Get started now<\/a><\/div>\r\n<\/div>\r\n\r\n<br \/>\r\n<p style=\"color: #ff5555; font-size: 0.9em; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important;\">P.S. We're available for hire, if you need help. <a href=\"https:\/\/draculaservers.com\/members\/submitticket.php\">Click here to contact us<\/a>.<\/p>\r\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>What is FreeRADIUS? FreeRADIUS is very popular open-source RADIUS server. It&#8217;s been developed since the dial-up era, and it&#8217;s still going strong today, being used by a great deal of companies around the world, including many Fortune 500 companies. FreeRADIUS supports all of the authentication protocols and offers the AAA protocols ( Authentication, Authorization, and [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1798,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[67,64,87],"tags":[54],"class_list":["post-1794","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-debian","category-open-source","category-radius","tag-daloradius"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":6}},"featured_image_urls_v2":{"full":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-Debian-9-with-MySQL.png",1024,512,false],"thumbnail":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-Debian-9-with-MySQL-150x150.png",150,150,true],"medium":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-Debian-9-with-MySQL-300x150.png",300,150,true],"medium_large":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-Debian-9-with-MySQL-768x384.png",768,384,true],"large":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-Debian-9-with-MySQL-1024x512.png",1024,512,true],"1536x1536":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-Debian-9-with-MySQL.png",1024,512,false],"2048x2048":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-Debian-9-with-MySQL.png",1024,512,false],"pk-small":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-Debian-9-with-MySQL-80x80.png",80,80,true],"pk-thumbnail":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-Debian-9-with-MySQL-300x225.png",300,225,true]},"post_excerpt_stackable_v2":"<p>What is FreeRADIUS? FreeRADIUS is very popular open-source RADIUS server. It&#8217;s been developed since the dial-up era, and it&#8217;s still going strong today, being used by a great deal of companies around the world, including many Fortune 500 companies. FreeRADIUS supports all of the authentication protocols and offers the AAA protocols ( Authentication, Authorization, and accounting). It&#8217;s typically used for managing users and keeping track of bandwidth usage, and it&#8217;s a popular solution for networking software such as OpenVPN, SoftEther, Squid Proxies and WiFi hotspots. In this tutorial we&#8217;ll install FreeRADIUS on a machine running Debian 9. We&#8217;ll also configure&hellip;<\/p>\n","category_list_v2":"<a href=\"https:\/\/draculaservers.com\/tutorials\/category\/debian\/\" rel=\"category tag\">Debian<\/a>, <a href=\"https:\/\/draculaservers.com\/tutorials\/category\/open-source\/\" rel=\"category tag\">Open-source<\/a>, <a href=\"https:\/\/draculaservers.com\/tutorials\/category\/radius\/\" rel=\"category tag\">Radius<\/a>","author_info_v2":{"name":"Vlad","url":"https:\/\/draculaservers.com\/tutorials\/author\/vlad\/"},"comments_num_v2":"4 comments","yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Install and Configure FreeRADIUS &amp; daloRADIUS on Debian 9 with MySQL - Dracula Servers Tutorials<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/draculaservers.com\/tutorials\/install-freeradius-daloradius-debian-9-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Install and Configure FreeRADIUS &amp; daloRADIUS on Debian 9 with MySQL - Dracula Servers Tutorials\" \/>\n<meta property=\"og:description\" content=\"What is FreeRADIUS? FreeRADIUS is very popular open-source RADIUS server. It&#8217;s been developed since the dial-up era, and it&#8217;s still going strong today, being used by a great deal of companies around the world, including many Fortune 500 companies. FreeRADIUS supports all of the authentication protocols and offers the AAA protocols ( Authentication, Authorization, and [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/draculaservers.com\/tutorials\/install-freeradius-daloradius-debian-9-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Dracula Servers Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-22T20:09:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-14T20:35:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-Debian-9-with-MySQL.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vlad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vlad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/install-freeradius-daloradius-debian-9-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/install-freeradius-daloradius-debian-9-mysql\\\/\"},\"author\":{\"name\":\"Vlad\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#\\\/schema\\\/person\\\/931f7fa8b2126ace6edfb82775e0ec0e\"},\"headline\":\"Install and Configure FreeRADIUS &#038; daloRADIUS on Debian 9 with MySQL\",\"datePublished\":\"2019-05-22T20:09:54+00:00\",\"dateModified\":\"2021-11-14T20:35:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/install-freeradius-daloradius-debian-9-mysql\\\/\"},\"wordCount\":1390,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/install-freeradius-daloradius-debian-9-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2019\\\/05\\\/Install-Configure-FreeRADIUS-on-Debian-9-with-MySQL.png\",\"keywords\":[\"daloradius\"],\"articleSection\":[\"Debian\",\"Open-source\",\"Radius\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/install-freeradius-daloradius-debian-9-mysql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/install-freeradius-daloradius-debian-9-mysql\\\/\",\"url\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/install-freeradius-daloradius-debian-9-mysql\\\/\",\"name\":\"Install and Configure FreeRADIUS & daloRADIUS on Debian 9 with MySQL - Dracula Servers Tutorials\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/install-freeradius-daloradius-debian-9-mysql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/install-freeradius-daloradius-debian-9-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2019\\\/05\\\/Install-Configure-FreeRADIUS-on-Debian-9-with-MySQL.png\",\"datePublished\":\"2019-05-22T20:09:54+00:00\",\"dateModified\":\"2021-11-14T20:35:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/install-freeradius-daloradius-debian-9-mysql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/install-freeradius-daloradius-debian-9-mysql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/install-freeradius-daloradius-debian-9-mysql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2019\\\/05\\\/Install-Configure-FreeRADIUS-on-Debian-9-with-MySQL.png\",\"contentUrl\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2019\\\/05\\\/Install-Configure-FreeRADIUS-on-Debian-9-with-MySQL.png\",\"width\":1024,\"height\":512,\"caption\":\"install_freeradius_daloradius_mysql_debian_9\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/install-freeradius-daloradius-debian-9-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Install and Configure FreeRADIUS &#038; daloRADIUS on Debian 9 with MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#website\",\"url\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/\",\"name\":\"Dracula Servers Tutorials\",\"description\":\"Dedicated Servers\",\"publisher\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#organization\",\"name\":\"Dracula Servers\",\"url\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2016\\\/06\\\/dracula_full_logo_smaller.png\",\"contentUrl\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2016\\\/06\\\/dracula_full_logo_smaller.png\",\"width\":1625,\"height\":200,\"caption\":\"Dracula Servers\"},\"image\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#\\\/schema\\\/person\\\/931f7fa8b2126ace6edfb82775e0ec0e\",\"name\":\"Vlad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/499c7a24aa9727703300a291f8f69dfd1b01b8d6a19a4ae4fbe669b4b12b8cbe?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/499c7a24aa9727703300a291f8f69dfd1b01b8d6a19a4ae4fbe669b4b12b8cbe?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/499c7a24aa9727703300a291f8f69dfd1b01b8d6a19a4ae4fbe669b4b12b8cbe?s=96&d=mm&r=g\",\"caption\":\"Vlad\"},\"description\":\"Tech Support\",\"sameAs\":[\"https:\\\/\\\/draculaservers.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Install and Configure FreeRADIUS & daloRADIUS on Debian 9 with MySQL - Dracula Servers Tutorials","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/draculaservers.com\/tutorials\/install-freeradius-daloradius-debian-9-mysql\/","og_locale":"en_US","og_type":"article","og_title":"Install and Configure FreeRADIUS & daloRADIUS on Debian 9 with MySQL - Dracula Servers Tutorials","og_description":"What is FreeRADIUS? FreeRADIUS is very popular open-source RADIUS server. It&#8217;s been developed since the dial-up era, and it&#8217;s still going strong today, being used by a great deal of companies around the world, including many Fortune 500 companies. FreeRADIUS supports all of the authentication protocols and offers the AAA protocols ( Authentication, Authorization, and [&hellip;]","og_url":"https:\/\/draculaservers.com\/tutorials\/install-freeradius-daloradius-debian-9-mysql\/","og_site_name":"Dracula Servers Tutorials","article_published_time":"2019-05-22T20:09:54+00:00","article_modified_time":"2021-11-14T20:35:58+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-Debian-9-with-MySQL.png","type":"image\/png"}],"author":"Vlad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Vlad","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/draculaservers.com\/tutorials\/install-freeradius-daloradius-debian-9-mysql\/#article","isPartOf":{"@id":"https:\/\/draculaservers.com\/tutorials\/install-freeradius-daloradius-debian-9-mysql\/"},"author":{"name":"Vlad","@id":"https:\/\/draculaservers.com\/tutorials\/#\/schema\/person\/931f7fa8b2126ace6edfb82775e0ec0e"},"headline":"Install and Configure FreeRADIUS &#038; daloRADIUS on Debian 9 with MySQL","datePublished":"2019-05-22T20:09:54+00:00","dateModified":"2021-11-14T20:35:58+00:00","mainEntityOfPage":{"@id":"https:\/\/draculaservers.com\/tutorials\/install-freeradius-daloradius-debian-9-mysql\/"},"wordCount":1390,"commentCount":4,"publisher":{"@id":"https:\/\/draculaservers.com\/tutorials\/#organization"},"image":{"@id":"https:\/\/draculaservers.com\/tutorials\/install-freeradius-daloradius-debian-9-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-Debian-9-with-MySQL.png","keywords":["daloradius"],"articleSection":["Debian","Open-source","Radius"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/draculaservers.com\/tutorials\/install-freeradius-daloradius-debian-9-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/draculaservers.com\/tutorials\/install-freeradius-daloradius-debian-9-mysql\/","url":"https:\/\/draculaservers.com\/tutorials\/install-freeradius-daloradius-debian-9-mysql\/","name":"Install and Configure FreeRADIUS & daloRADIUS on Debian 9 with MySQL - Dracula Servers Tutorials","isPartOf":{"@id":"https:\/\/draculaservers.com\/tutorials\/#website"},"primaryImageOfPage":{"@id":"https:\/\/draculaservers.com\/tutorials\/install-freeradius-daloradius-debian-9-mysql\/#primaryimage"},"image":{"@id":"https:\/\/draculaservers.com\/tutorials\/install-freeradius-daloradius-debian-9-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-Debian-9-with-MySQL.png","datePublished":"2019-05-22T20:09:54+00:00","dateModified":"2021-11-14T20:35:58+00:00","breadcrumb":{"@id":"https:\/\/draculaservers.com\/tutorials\/install-freeradius-daloradius-debian-9-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/draculaservers.com\/tutorials\/install-freeradius-daloradius-debian-9-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/draculaservers.com\/tutorials\/install-freeradius-daloradius-debian-9-mysql\/#primaryimage","url":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-Debian-9-with-MySQL.png","contentUrl":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-Debian-9-with-MySQL.png","width":1024,"height":512,"caption":"install_freeradius_daloradius_mysql_debian_9"},{"@type":"BreadcrumbList","@id":"https:\/\/draculaservers.com\/tutorials\/install-freeradius-daloradius-debian-9-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/draculaservers.com\/tutorials\/"},{"@type":"ListItem","position":2,"name":"Install and Configure FreeRADIUS &#038; daloRADIUS on Debian 9 with MySQL"}]},{"@type":"WebSite","@id":"https:\/\/draculaservers.com\/tutorials\/#website","url":"https:\/\/draculaservers.com\/tutorials\/","name":"Dracula Servers Tutorials","description":"Dedicated Servers","publisher":{"@id":"https:\/\/draculaservers.com\/tutorials\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/draculaservers.com\/tutorials\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/draculaservers.com\/tutorials\/#organization","name":"Dracula Servers","url":"https:\/\/draculaservers.com\/tutorials\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/draculaservers.com\/tutorials\/#\/schema\/logo\/image\/","url":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2016\/06\/dracula_full_logo_smaller.png","contentUrl":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2016\/06\/dracula_full_logo_smaller.png","width":1625,"height":200,"caption":"Dracula Servers"},"image":{"@id":"https:\/\/draculaservers.com\/tutorials\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/draculaservers.com\/tutorials\/#\/schema\/person\/931f7fa8b2126ace6edfb82775e0ec0e","name":"Vlad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/499c7a24aa9727703300a291f8f69dfd1b01b8d6a19a4ae4fbe669b4b12b8cbe?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/499c7a24aa9727703300a291f8f69dfd1b01b8d6a19a4ae4fbe669b4b12b8cbe?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/499c7a24aa9727703300a291f8f69dfd1b01b8d6a19a4ae4fbe669b4b12b8cbe?s=96&d=mm&r=g","caption":"Vlad"},"description":"Tech Support","sameAs":["https:\/\/draculaservers.com"]}]}},"_links":{"self":[{"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/posts\/1794","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/comments?post=1794"}],"version-history":[{"count":2,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/posts\/1794\/revisions"}],"predecessor-version":[{"id":2153,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/posts\/1794\/revisions\/2153"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/media\/1798"}],"wp:attachment":[{"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/media?parent=1794"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/categories?post=1794"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/tags?post=1794"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}