{"id":1732,"date":"2019-05-06T11:00:39","date_gmt":"2019-05-06T11:00:39","guid":{"rendered":"https:\/\/draculaservers.com\/tutorials\/?p=1732"},"modified":"2021-11-14T20:36:23","modified_gmt":"2021-11-14T20:36:23","slug":"freeradius-centos-7-mysql","status":"publish","type":"post","link":"https:\/\/draculaservers.com\/tutorials\/freeradius-centos-7-mysql\/","title":{"rendered":"Install &#038; Configure FreeRADIUS on CentOS 7 with MySQL \/ MariaDB"},"content":{"rendered":"<h2 id=\"what-is-freeradius\">What is FreeRADIUS?<\/h2>\n<p>FreeRADIUS is the most popular open-source RADIUS server. It supports all common authentication protocols and supplies the AAA protocol ( Authentication, Authorization and Accounting ) for many companies around the world, including many Fortune-500 companies.<\/p>\n<p>It was developed in the dial-up era and used to manage users and keep track of bandwidth usage for billing purposes, however it is still going strong and used by a great deal of companies to this day. It&#8217;s commonly used with networking software such as OpenVPN, SoftEther, Squid Proxies and WiFi managing tools.<\/p>\n<blockquote class=\"note\"><p><small><strong>NOTE:<\/strong> If you&#8217;d like to set up <strong>FreeRADIUS on an Ubuntu 18.04<\/strong> machine, visit our other tutorial <a href=\"https:\/\/draculaservers.com\/tutorials\/freeradius-ubuntu-18-04-mysql\/\">Install and Configure FreeRADIUS on Ubuntu 18.04 with MySQL<\/a><\/small><\/p><\/blockquote>\n<blockquote class=\"note-blue\"><p><small><strong>Installing FreeRADIUS on CentOS 8:<\/strong> For an updated and more detailed guide (with Video) for installing FreeRADIUS on CentOS 8, you can check out <a href=\"https:\/\/bytexd.com\/freeradius-centos\/\" target=\"_blank\" rel=\"noopener noreferrer\">Install FreeRADIUS &amp; daloRADIUS on CentOS 8 + MySQL\/MariaDB on ByteXD.com<\/a>.<\/small><\/p><\/blockquote>\n\n<h2 id=\"how-to-set-up-a-radius-server\">How to set up a RADIUS server?<\/h2>\n<p>We present 2 methods of setting up FreeRADIUS:<\/p>\n<p>1. <strong>The hard way: <\/strong> Manually setting it up by connecting to your machine via SSH, as well as configuring it and troubleshooting. Depending on your end goal, this can take from 30 if you know what you&#8217;re doing, to several hours if you&#8217;re just getting started.<\/p>\n<p>2. <strong>The easy way: <\/strong> Deploying a server with FreeRADIUS + daloRADIUS + phpMyAdmin installed out of the box <strong>in just a few minutes<\/strong>. You can do this by ordering our FreeRADIUS VPS that comes with the software installed and also offers you the possibility to also order priority support, so you&#8217;ll have our assistance with any RADIUS related issue you have going forward. To proceed, check out our <a href=\"https:\/\/draculaservers.com\/freeradius.php\" target=\"_blank\" rel=\"noopener noreferrer\">FreeRADIUS Server Plans<\/a>.<\/p>\n<h2 id=\"method-1-the-easy-way-5-minutes\">Method 1 \u2014\u00a0The Easy Way &#8211; 5 minutes<\/h2>\n<p>Should you be pressed for time and need to deploy RADIUS servers fast and troubleshoot problems quickly, your best option may be an out of the box solution. As mentioned, you can also upgrade your service to receive <strong>Priority Support<\/strong>, should you find yourself tackling complex problems. To order, proceed to our <a href=\"https:\/\/draculaservers.com\/freeradius.php\" target=\"_blank\" rel=\"noopener noreferrer\">FreeRADIUS VPS Plans<\/a>.<\/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-the-hard-way\">Method 2 \u2014\u00a0The Hard Way<\/h2>\n<p>Prefer to do it yourself? Then this is the way to go. Moving forward, we&#8217;ll install FreeRADIUS along with daloRADIUS on a machine running a fresh installation of CentOS 7.<\/p>\n<h2 id=\"step-1-install-freeradius-additional-modules-on-centos-7\">Step 1 \u2013 Install FreeRADIUS &amp; Additional Modules on CentOS 7<\/h2>\n<p>Run the following command to update the system&#8217;s package index:<\/p>\n<pre><code>$ sudo yum -y update<\/code><\/pre>\n<p>We want to install the following packages:<\/p>\n<ul>\n<li>freeradius<\/li>\n<li>freeradius-utils<\/li>\n<li>freeradius-mysql<\/li>\n<li>freeradius-perl<\/li>\n<\/ul>\n<p>We normally can install the above mentioned packages from the CentOS YUM repository.<\/p>\n<p>With the following line we&#8217;ll perform a quick search for all the available <strong>freeRADIUS<\/strong> packages, to make sure they&#8217;re available:<\/p>\n<pre><code>$ sudo yum search all freeradius<\/code><\/pre>\n<p>The output should look something like this:<\/p>\n<pre><code>Loaded plugins: fastestmirror\nLoading mirror speeds from cached hostfile\n * base: ftpmirror.your.org\n * epel: mirror.layeronline.com\n * extras: ftpmirror.your.org\n * updates: ftpmirror.your.org\n============================================================================================================ Matched: freeradius =============================================================================================================\nfreeradius-devel.i686 : FreeRADIUS development files\nfreeradius-devel.x86_64 : FreeRADIUS development files\nfreeradius-doc.x86_64 : FreeRADIUS documentation\nfreeradius-krb5.x86_64 : Kerberos 5 support for freeradius\nfreeradius-ldap.x86_64 : LDAP support for freeradius\nfreeradius-mysql.x86_64 : MySQL support for freeradius\nfreeradius-perl.x86_64 : Perl support for freeradius\nfreeradius-postgresql.x86_64 : Postgresql support for freeradius\nfreeradius-python.x86_64 : Python support for freeradius\nfreeradius-sqlite.x86_64 : SQLite support for freeradius\nfreeradius-unixODBC.x86_64 : Unix ODBC support for freeradius\nfreeradius-utils.x86_64 : FreeRADIUS utilities\nfreeradius.x86_64 : High-performance and highly configurable free RADIUS server\nradcli-compat-devel.x86_64 : Development files for compatibility with radiusclient-ng and freeradius-client\npam_radius.x86_64 : PAM Module for RADIUS Authentication\nradcli.x86_64 : RADIUS protocol client library<\/code><\/pre>\n<p>Looking through the output we can see the packages we want to install are available so we can go through with the installation.<\/p>\n<pre><code>freeradius.x86_64 : High-performance and highly configurable free RADIUS server\nfreeradius-utils.x86_64 : FreeRADIUS utilities\nfreeradius-mysql.x86_64 : MySQL support for freeradius\nfreeradius-perl.x86_64 : Perl support for freeradius<\/code><\/pre>\n<p>With the following line we&#8217;ll install <code>freeradius<\/code>, <code>freeradius-utils<\/code>, <code>freeradius-mysql<\/code> and <code>freeradius-perl<\/code>:<\/p>\n<pre><code>$ sudo yum -y install freeradius freeradius-utils freeradius-mysql freeradius-perl <\/code><\/pre>\n<p>After the installation&#8217;s finished, start and enable <strong>freeRADIUS<\/strong> so it&#8217;s running and so it also starts up on boot:<\/p>\n<pre><code>$ systemctl start radiusd.service\n$ systemctl enable radiusd.service<\/code><\/pre>\n<p>Output for <code>enable radiusd.service<\/code>:<\/p>\n<pre><code>Created symlink from \/etc\/systemd\/system\/multi-user.target.wants\/radiusd.service to \/usr\/lib\/systemd\/system\/radiusd.service.<\/code><\/pre>\n<p>Check the status of <code>radiusd.service<\/code>:<\/p>\n<pre><code>$ systemctl status radiusd.service<\/code><\/pre>\n<p>Output:<\/p>\n<pre><code>\u25cf radiusd.service - FreeRADIUS high performance RADIUS server.\n   Loaded: loaded (\/usr\/lib\/systemd\/system\/radiusd.service; enabled; vendor preset: disabled)\n   Active: active (running) since Sat 2019-05-04 15:28:42 UTC; 1min 8s ago\n Main PID: 1687 (radiusd)\n   CGroup: \/system.slice\/radiusd.service\n           \u2514\u25001687 \/usr\/sbin\/radiusd -d \/etc\/raddb\n\nMay 04 15:28:42 dracula_backup systemd[1]: Starting FreeRADIUS high performance RADIUS.....\nMay 04 15:28:42 dracula_backup systemd[1]: Started FreeRADIUS high performance RADIUS .....\nHint: Some lines were ellipsized, use -l to show in full.<\/code><\/pre>\n<h3 id=\"configure-centos-7-firewall-for-freeradius\">Configure CentOS 7 Firewall for freeRADIUS<\/h3>\n<p>We&#8217;ll configure <strong>firewalld<\/strong> to allow <code>radius<\/code> and <code>httpd<\/code> packets.<\/p>\n<p>RADIUS server uses UDP ports 1812 and 1813. You can check this by issuing the following command:<\/p>\n<pre><code>$ cat \/usr\/lib\/firewalld\/services\/radius.xml<\/code><\/pre>\n<p>Output:<\/p>\n<pre><code><!--?xml version=\"1.0\" encoding=\"utf-8\"?-->\n\n  RADIUS\n  The Remote Authentication Dial In User Service (RADIUS) is a protocol for user authentication over networks. It is mostly used for modem, DSL or wireless user authentication. If you plan to provide a RADIUS service (e.g. with freeradius), enable this option.\n  \n  \n  \n  \n<\/code><\/pre>\n<ol>\n<li>Start, enable <strong>firewalld<\/strong> and check it&#8217;s status\n<pre><code>$ systemctl enable firewalld\n$ systemctl start firewalld\n$ systemctl status firewalld<\/code><\/pre>\n<p>Output of status check:<\/p>\n<pre><code>\u25cf firewalld.service - firewalld - dynamic firewall daemon\n   Loaded: loaded (\/usr\/lib\/systemd\/system\/firewalld.service; enabled; vendor preset: enabled)\n   Active: active (running) since Sat 2019-05-04 13:39:12 UTC; 8h ago\n     Docs: man:firewalld(1)\n Main PID: 1775 (firewalld)\n   CGroup: \/system.slice\/firewalld.service\n           \u2514\u25001775 \/usr\/bin\/python -Es \/usr\/sbin\/firewalld --nofork --nopid\n\nMay 04 13:39:10 guest systemd[1]: Starting firewalld - dynamic firewall daemon...\nMay 04 13:39:12 guest systemd[1]: Started firewalld - dynamic firewall daemon.<\/code><\/pre>\n<\/li>\n<li>Check to make sure <strong>firewalld<\/strong> is running\n<pre><code>$ firewall-cmd --state\nrunning<\/code><\/pre>\n<\/li>\n<li>Create permanent rules to default zone to allow <code>http<\/code>, <code>https<\/code> and <code>radius<\/code> services\n<pre><code>$ firewall-cmd --add-service={http,https,radius} --permanent<\/code><\/pre>\n<\/li>\n<li>Reload <strong>firewalld<\/strong> for the changes to take effect\n<pre><code>$ firewall-cmd --reload<\/code><\/pre>\n<\/li>\n<li>Confirm that the services were successfully added to default zone\n<pre><code>$ firewall-cmd --get-default-zone\npublic\n\n$ firewall-cmd --list-services --zone=public\ndhcpv6-client http https radius ssh<\/code><\/pre>\n<p>The services that we just allowed (<code>http<\/code>, <code>https<\/code> &amp; <code>radius<\/code>) are all listed in the output, which means we can proceed.<\/li>\n<\/ol>\n<h3 id=\"test-radius-server\">Test RADIUS Server<\/h3>\n<p>We&#8217;ll test the RADIUS server in debug mode, which means we&#8217;ll have to run the service. The problem is that the server&#8217;s already running from earlier, and running in debug mode will fail to bind ports, as such we&#8217;ll have to kill the radius service first:<\/p>\n<pre><code>$ pkill radius<\/code><\/pre>\n<p>Now run the RADIUS server in debug mode to check if everything&#8217;s working:<\/p>\n<pre><code>$ radiusd -X<\/code><\/pre>\n<p>You should see a long output ending in:<\/p>\n<pre><code>Listening 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 57424\nListening on proxy address :: port 44958\nReady to process requests<\/code><\/pre>\n<p>The basic installation of FreeRADIUS seems to have been successful.<\/p>\n<p>Now we&#8217;ll proceed with <strong>configuring our RADIUS server to use MariaDB or MySQL<\/strong> ( depending on which you prefer ).<\/p>\n<h2 id=\"step-2-install-configure-mariadb-10-on-centos-7\">Step 2 \u2013 Install &amp; Configure MariaDB 10 on CentOS 7<\/h2>\n<blockquote class=\"note\"><p><small><strong>NOTE:<\/strong> MariaDB 5.5 is the default database engine in CentOS at the time of writing. Installing MySQL should be somewhat similar. Should you want us to add instructions for MySQL, then just hit us up and we&#8217;ll add in the instructions for MySQL.<\/small><\/p><\/blockquote>\n<p>MariaDB 10 is not the default version on CentOS, as such we&#8217;ll add the official MariaDB repositories to our system.<\/p>\n<p>Create a new file, we&#8217;ll call it <code>\/etc\/yum.repos.d\/MariaDB.repo<\/code> using your favorite text editor:<\/p>\n<pre><code>$ nano \/etc\/yum.repos.d\/MariaDB.repo<\/code><\/pre>\n<p>Add the following content to it, and save and exit the file when you&#8217;re done:<\/p>\n<pre><code>[mariadb]\nname = MariaDB\nbaseurl = http:\/\/yum.mariadb.org\/10.1\/centos7-amd64\ngpgkey=https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB\ngpgcheck=1<\/code><\/pre>\n<p>Update the package index:<\/p>\n<pre><code>$ yum -y update<\/code><\/pre>\n<p>And install MariaDB:<\/p>\n<pre><code>$ yum install -y mariadb-server mariadb<\/code><\/pre>\n<p>After the installation is finished, start MariaDB and <code>enable<\/code> it so it runs on boot:<\/p>\n<pre><code>$ systemctl start mariadb\n$ systemctl enable mariadb<\/code><\/pre>\n<p>Check to make sure it&#8217;s running and enabled:<\/p>\n<pre><code>$ systemctl status mariadb\n$ systemctl is-enabled mariadb.service\nenabled<\/code><\/pre>\n<h3 id=\"securing-mariadb-mysql\">Securing MariaDB \/ MySQL<\/h3>\n<p>MariaDB\/MySQL comes with a script that helps you conveniently secure it and remove some insecure defaults. Some important things it allows you to do:<\/p>\n<ul>\n<li>set the root password<\/li>\n<li>remove anonymous users<\/li>\n<li>disallow remote login<\/li>\n<\/ul>\n<p>Run it with the following command and you&#8217;ll be guided through the process.<\/p>\n<pre><code>$ mysql_secure_installation<\/code><\/pre>\n<p>We recommend you proceed as follows:<\/p>\n<p><code>Enter current password for root (enter for none): ENTER<\/code><br \/>\n<code>Set root password? [Y\/n] y<\/code><br \/>\n<code>New password: Enter password<\/code><br \/>\n<code>Re-enter new password: Repeat password<\/code><\/p>\n<p>You\u2019ll also be prompted to answer some questions to remove\/keep some defaults:<\/p>\n<p><code>Remove anonymous users? [Y\/n]: Y<\/code><br \/>\n<code>Disallow root login remotely? [Y\/n]: Y<\/code><br \/>\n<code>Remove test database and access to it? [Y\/n]: Y<\/code><br \/>\n<code>Reload privilege tables now? [Y\/n]: Y<\/code><\/p>\n<h2 id=\"step-3-install-php-7-on-centos-7\">Step 3 \u2013 Install PHP 7 on CentOS 7<\/h2>\n<p>CentOS 7 ships with PHP 5.4 at the time of writing, which has been officially EOL for some time.<\/p>\n<p>By using PHP 7 applications will load faster and use up less resources.<\/p>\n<p>PHP 7.x is available from various repositories. For our purposes, we&#8217;ll use the <a href=\"https:\/\/rpms.remirepo.net\/\" target=\"_blank\" rel=\"noopener noreferrer\">Remi Repository<\/a>, which provides newer versions of applications.<\/p>\n<p>The Remi Repository depends on the EPEL repository. With the following line we&#8217;ll add both EPEL and Remi:<\/p>\n<pre><code>$ sudo yum install epel-release yum-utils\n$ sudo yum install http:\/\/rpms.remirepo.net\/enterprise\/remi-release-7.rpm<\/code><\/pre>\n<p>We&#8217;ll install PHP 7.3, which is the latest stable release at the time of writing.<\/p>\n<p>Enable the PHP 7.3 Remi repository:<\/p>\n<pre><code>$ sudo yum-config-manager --enable remi-php73<\/code><\/pre>\n<p>And run the following command to install PHP 7.3 along with some of the most common PHP modules:<\/p>\n<pre><code>$ sudo yum install php php-common php-opcache php-mcrypt php-cli php-gd php-curl php-mysqlnd<\/code><\/pre>\n<p>You may be asked during the installation if you&#8217;re ok with importing a GPG Key. Answer <code>y<\/code> and hit enter.<\/p>\n<p>With the following command we can check the PHP version, to make sure the installation was successful:<\/p>\n<pre><code>$ php -v<\/code><\/pre>\n<h2 id=\"step-4-configure-freeradius-to-use-mariadb-mysql\">Step 4 \u2013 Configure FreeRADIUS to use MariaDB\/MySQL<\/h2>\n<p>To configure FreeRADIUS to use MariaDB \/ MySQL, we&#8217;ll have to create a database with tables to be used by the FreeRADIUS server for finding RADIUS users and to store accounting data.<\/p>\n<p>The FreeRADIUS MySQL package ships with the necessary query to create these tables, making our job a lot easier.<\/p>\n<p>To begin, we&#8217;ll log into MariaDB or MySQL and create and configure a database that we&#8217;ll call <code>radius<\/code>:<\/p>\n<pre><code>$ mysql -u root -p<\/code><\/pre>\n<p>Enter your password at the prompt.<\/p>\n<p>Once you&#8217;re logged in, run the following commands to create and configure the database:<\/p>\n<pre><code>MariaDB [(none)]&gt; CREATE DATABASE radius;\nMariaDB [(none)]&gt; GRANT ALL ON radius.* TO radius@localhost IDENTIFIED BY \"radiuspassword\";\nMariaDB [(none)]&gt; FLUSH PRIVILEGES;\nMariaDB [(none)]&gt; quit;<\/code><\/pre>\n<p>Next import the RADIUS database scheme to populate the <code>radius<\/code> database:<\/p>\n<pre><code>$ mysql -uroot -pYOUR_PASSWORD radius &lt; \/etc\/raddb\/mods-config\/sql\/main\/mysql\/schema.sql<\/code><\/pre>\n<p>And create a soft link for SQL under <code>\/etc\/raddb\/mods-enabled<\/code>:<\/p>\n<pre><code>$ ln -s \/etc\/raddb\/mods-available\/sql \/etc\/raddb\/mods-enabled\/<\/code><\/pre>\n<p>Now we&#8217;ll configure the freeRADIUS server to use the database server. Do this by opening the configuration file <code>\/raddb\/mods-available\/sql<\/code> using your favorite text editor:<\/p>\n<pre><code>$ nano \/etc\/raddb\/mods-available\/sql<\/code><\/pre>\n<p>The <code>sql<\/code> section should look something like the following, although yours will be a longer document due to explanations and other lines that are commented out.<\/p>\n<pre><code>sql {\n\ndriver = \"rlm_sql_mysql\"\ndialect = \"mysql\"\n\n# Connection info:\n\nserver = \"localhost\"\nport = 3306\nlogin = \"radius\"\npassword = \"radiuspassword\"\n\n# Database table configuration for everything except Oracle\n\nradius_db = \"radius\"\n}\n\n# Set to \u2018yes\u2019 to read radius clients from the database (\u2018nas\u2019 table)\n# Clients will ONLY be read on server startup.\nread_clients = yes\n\n# Table to keep radius client info\nclient_table = \u201cnas\u201d<\/code><\/pre>\n<p>The steps to follow here are:<\/p>\n<ol>\n<li>Change <code>driver = \"rlm_sql_null\"<\/code> to <code>driver = \"rlm_sql_mysql\"<\/code><\/li>\n<li>Change <code>dialect = \"sqlite\"<\/code> to <code>dialect = \"mysql\"<\/code><\/li>\n<li>Uncomment <code>server<\/code>, <code>port<\/code>, <code>login<\/code> and <code>password<\/code> by removing <code>#<\/code> from the beginning of the line, as well as changing <code>password = \"radpass\"<\/code> to <code>password = \"radiuspassword\"<\/code>.To exemplify, here is how the lines look initially:\n<pre><code>#\tserver = \"localhost\"\n#\tport = 3306\n#   login = \"radius\"\n#   password = \"radpass\"<\/code><\/pre>\n<p>And here is how they look after:<\/p>\n<pre><code> \tserver = \"localhost\"\n \tport = 3306\n    login = \"radius\"\n    password = \"radiuspassword\"<\/code><\/pre>\n<\/li>\n<li>Uncomment the <code>read_clients = yes<\/code> line, by removing the <code>#<\/code> at the beginning of the line.<\/li>\n<li>The other lines should be already set up according to our needs, so you can save and close the file when you&#8217;re done. ( You can check to make sure that everything&#8217;s in order, however )<\/li>\n<\/ol>\n<p>Finally, change the group rights of <code>\/etc\/raddb\/mods-enabled\/sql<\/code> to <code>radiusd<\/code>:<\/p>\n<pre><code>$ chgrp -h radiusd \/etc\/raddb\/mods-enabled\/sql<\/code><\/pre>\n<p>Now let&#8217;s run FreeRADIUS in debug mode again, since we&#8217;ve made some changes.<\/p>\n<p>If the RADIUS server is running, first kill the deamon:<\/p>\n<pre><code>pkill radiusd<\/code><\/pre>\n<p>And run the server in debug mode:<\/p>\n<pre><code>radiusd -X<\/code><\/pre>\n<p>Output:<\/p>\n<pre><code>Listening 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 59387\nListening on proxy address :: port 51874\nReady to process requests<\/code><\/pre>\n<h2 id=\"step-5-gui-webpanel\">Step 5 \u2013 GUI WebPanel<\/h2>\n<p>There are a few freeRADIUS web panels available for easier user creation and management. We&#8217;re currently using daloRADIUS. You can follow our <a href=\"https:\/\/draculaservers.com\/tutorials\/freeradius-panel-daloradius-centos-7\/\">tutorial to installing daloRADIUS WebPanel on a RADIUS server on CentOS 7<\/a>, and then return to this page.<\/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=\"daloradius_preview\" 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<blockquote class=\"note\"><p><small><strong>NOTE:<\/strong> Should you be looking for a ready-made solution complete with FreeRADIUS + daloRADIUS installed, we offer <a href=\"https:\/\/draculaservers.com\/freeradius.php\" target=\"_blank\" rel=\"noopener noreferrer\">FreeRADIUS Servers<\/a> that you can deploy in a few minutes. Additionally you can opt, any time after you&#8217;ve ordered, for <strong>priority support<\/strong> which ensures you get help when you encounter issues.<\/small><\/p><\/blockquote>\n<h2 id=\"step-6-create-a-nas-client-user\">Step 6 \u2013 Create a NAS Client &amp; User<\/h2>\n<p>For other computers to connect to the RADIUS server, they need to be added to the <strong>NAS client table<\/strong> in the RADIUS database.<\/p>\n<p>First we need to add the <strong>NAS<\/strong>. Do this in daloRADIUS by 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\" title=\"Add New NAS daloRADIUS\" src=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2018\/12\/nas_dalo_radius.png\" alt=\"daloradius_create_nas_table\" 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>After adding the NAS, you can add new <strong>Users<\/strong> in daloRADIUS by going to <strong>Management &gt; Users &gt; New Users<\/strong>.<\/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\" title=\"Add New User daloRADIUS\" src=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2018\/12\/daloradius.jpg\" alt=\"daloradius_add_new_user\" 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 that you can set to users and user groups, however that is beyond the scope of this tutorial.<\/p>\n<p>Now that we&#8217;ve added a new NAS and new User, we should test them. Every time a new NAS is added, you&#8217;ll need to reload FreeRADIUS so it fetches the refreshed table. To test that everything is OK, <strong>stop the freeradius<\/strong> server and start it in debug mode and <strong>move on to the next step<\/strong>.<\/p>\n<p>First we&#8217;ll kill the daemon:<\/p>\n<pre><code>$ pkill radiusd<\/code><\/pre>\n<p>And start it in debug mode:<\/p>\n<pre><code>$ radiusd -X<\/code><\/pre>\n<h2 id=\"step-7-testing-with-ntradping\">Step 7 \u2013 Testing with NTRadPing<\/h2>\n<p>A great tool we can use to test our radius servers is NTRadPing. You can download it here: <a title=\"Download NTRadPing\" href=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2018\/12\/ntradping.zip\" target=\"_blank\" rel=\"noopener noreferrer\">ntradping<\/a>.<\/p>\n<p>Unzip and run the executable, and in fill out the fields with the credentials you created earlier when adding the new NAS and new User. Here&#8217;s how we fill it, according to the credentials we created in this tutorial. Also keep in mind that RADIUS users port <code>1812<\/code>, so that&#8217;s the port you want to fill in.<\/p>\n<p><strong>RADIUS Server\/port:<\/strong> <code>your_server_ip<\/code> \/ <code>1812<\/code><br \/>\n<strong>RADIUS Secret Key:<\/strong> <code>strongsecret!<\/code><br \/>\n<strong>Password:<\/strong> <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\" 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\" width=\"680\" height=\"427\" 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 <strong>Send<\/strong> and you should receive a reply that looks 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 for FreeRADIUS debug mode when a user is successfully authenticated 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=\"step-8-conclusion\">Step 8 \u2013 Conclusion<\/h2>\n<p>If you&#8217;ve made it this far then you should have your FreeRADIUS server up and running with daloRADIUS WebPanel on a CentOS 7 machine. Well done.<\/p>\n<p>Should you have issues with setting up RADIUS servers, then do keep in mind that we offer a solution for deploying <strong>instant FreeRADIUS Servers<\/strong>.<\/p>\n<p>Our servers come with FreeRADIUS + daloRADIUS + phpMyAdmin readily installed, and you can have them up in minutes! Additionally, you can opt for our <strong>Professional Support<\/strong> addon at a later time, should you find yourself needing priority support when things get more complex. To find out more info, please check our <a href=\"https:\/\/draculaservers.com\/freeradius.php\" target=\"_blank\" rel=\"noopener noreferrer\">FreeRADIUS Servers Offer<\/a>.<\/p>\n<hr \/>\n<p><strong>Additional tutorials you may be interested in:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/draculaservers.com\/tutorials\/radius-bandwidth-sqlcounter-profiles\/\" target=\"_blank\" rel=\"noopener noreferrer\">Creating Radius Profiles with Bandwidth Limits<\/a><\/li>\n<li>If you prefer to use <strong>FreeRADIUS on Ubuntu 18.04<\/strong>, then check out our tutorial on <a href=\"https:\/\/draculaservers.com\/tutorials\/freeradius-ubuntu-18-04-mysql\/\" target=\"_blank\" rel=\"noopener noreferrer\">installing FreeRADIUS with MySQL on Ubuntu 18.04<\/a><\/li>\n<\/ul>\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 the most popular open-source RADIUS server. It supports all common authentication protocols and supplies the AAA protocol ( Authentication, Authorization and Accounting ) for many companies around the world, including many Fortune-500 companies. It was developed in the dial-up era and used to manage users and keep track of bandwidth [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1760,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[72,64,87],"tags":[],"class_list":["post-1732","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-centos","category-open-source","category-radius"],"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-CentOS-7-with-MySQL-_-MariaDB.png",1024,512,false],"thumbnail":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-CentOS-7-with-MySQL-_-MariaDB-150x150.png",150,150,true],"medium":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-CentOS-7-with-MySQL-_-MariaDB-300x150.png",300,150,true],"medium_large":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-CentOS-7-with-MySQL-_-MariaDB-768x384.png",768,384,true],"large":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-CentOS-7-with-MySQL-_-MariaDB-1024x512.png",1024,512,true],"1536x1536":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-CentOS-7-with-MySQL-_-MariaDB.png",1024,512,false],"2048x2048":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-CentOS-7-with-MySQL-_-MariaDB.png",1024,512,false],"pk-small":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-CentOS-7-with-MySQL-_-MariaDB-80x80.png",80,80,true],"pk-thumbnail":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-CentOS-7-with-MySQL-_-MariaDB-300x225.png",300,225,true]},"post_excerpt_stackable_v2":"<p>What is FreeRADIUS? FreeRADIUS is the most popular open-source RADIUS server. It supports all common authentication protocols and supplies the AAA protocol ( Authentication, Authorization and Accounting ) for many companies around the world, including many Fortune-500 companies. It was developed in the dial-up era and used to manage users and keep track of bandwidth usage for billing purposes, however it is still going strong and used by a great deal of companies to this day. It&#8217;s commonly used with networking software such as OpenVPN, SoftEther, Squid Proxies and WiFi managing tools. NOTE: If you&#8217;d like to set up FreeRADIUS&hellip;<\/p>\n","category_list_v2":"<a href=\"https:\/\/draculaservers.com\/tutorials\/category\/centos\/\" rel=\"category tag\">CentOS<\/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":"16 comments","yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Install &amp; Configure FreeRADIUS on CentOS 7 with MySQL \/ MariaDB - 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\/freeradius-centos-7-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Install &amp; Configure FreeRADIUS on CentOS 7 with MySQL \/ MariaDB - Dracula Servers Tutorials\" \/>\n<meta property=\"og:description\" content=\"What is FreeRADIUS? FreeRADIUS is the most popular open-source RADIUS server. It supports all common authentication protocols and supplies the AAA protocol ( Authentication, Authorization and Accounting ) for many companies around the world, including many Fortune-500 companies. It was developed in the dial-up era and used to manage users and keep track of bandwidth [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/draculaservers.com\/tutorials\/freeradius-centos-7-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Dracula Servers Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-06T11:00:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-14T20:36:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-CentOS-7-with-MySQL-_-MariaDB.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=\"14 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/freeradius-centos-7-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/freeradius-centos-7-mysql\\\/\"},\"author\":{\"name\":\"Vlad\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#\\\/schema\\\/person\\\/931f7fa8b2126ace6edfb82775e0ec0e\"},\"headline\":\"Install &#038; Configure FreeRADIUS on CentOS 7 with MySQL \\\/ MariaDB\",\"datePublished\":\"2019-05-06T11:00:39+00:00\",\"dateModified\":\"2021-11-14T20:36:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/freeradius-centos-7-mysql\\\/\"},\"wordCount\":1841,\"commentCount\":16,\"publisher\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/freeradius-centos-7-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2019\\\/05\\\/Install-Configure-FreeRADIUS-on-CentOS-7-with-MySQL-_-MariaDB.png\",\"articleSection\":[\"CentOS\",\"Open-source\",\"Radius\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/freeradius-centos-7-mysql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/freeradius-centos-7-mysql\\\/\",\"url\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/freeradius-centos-7-mysql\\\/\",\"name\":\"Install & Configure FreeRADIUS on CentOS 7 with MySQL \\\/ MariaDB - Dracula Servers Tutorials\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/freeradius-centos-7-mysql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/freeradius-centos-7-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2019\\\/05\\\/Install-Configure-FreeRADIUS-on-CentOS-7-with-MySQL-_-MariaDB.png\",\"datePublished\":\"2019-05-06T11:00:39+00:00\",\"dateModified\":\"2021-11-14T20:36:23+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/freeradius-centos-7-mysql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/freeradius-centos-7-mysql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/freeradius-centos-7-mysql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2019\\\/05\\\/Install-Configure-FreeRADIUS-on-CentOS-7-with-MySQL-_-MariaDB.png\",\"contentUrl\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2019\\\/05\\\/Install-Configure-FreeRADIUS-on-CentOS-7-with-MySQL-_-MariaDB.png\",\"width\":1024,\"height\":512,\"caption\":\"freeradius_centos_7\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/freeradius-centos-7-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Install &#038; Configure FreeRADIUS on CentOS 7 with MySQL \\\/ MariaDB\"}]},{\"@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 & Configure FreeRADIUS on CentOS 7 with MySQL \/ MariaDB - 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\/freeradius-centos-7-mysql\/","og_locale":"en_US","og_type":"article","og_title":"Install & Configure FreeRADIUS on CentOS 7 with MySQL \/ MariaDB - Dracula Servers Tutorials","og_description":"What is FreeRADIUS? FreeRADIUS is the most popular open-source RADIUS server. It supports all common authentication protocols and supplies the AAA protocol ( Authentication, Authorization and Accounting ) for many companies around the world, including many Fortune-500 companies. It was developed in the dial-up era and used to manage users and keep track of bandwidth [&hellip;]","og_url":"https:\/\/draculaservers.com\/tutorials\/freeradius-centos-7-mysql\/","og_site_name":"Dracula Servers Tutorials","article_published_time":"2019-05-06T11:00:39+00:00","article_modified_time":"2021-11-14T20:36:23+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-CentOS-7-with-MySQL-_-MariaDB.png","type":"image\/png"}],"author":"Vlad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Vlad","Est. reading time":"14 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/draculaservers.com\/tutorials\/freeradius-centos-7-mysql\/#article","isPartOf":{"@id":"https:\/\/draculaservers.com\/tutorials\/freeradius-centos-7-mysql\/"},"author":{"name":"Vlad","@id":"https:\/\/draculaservers.com\/tutorials\/#\/schema\/person\/931f7fa8b2126ace6edfb82775e0ec0e"},"headline":"Install &#038; Configure FreeRADIUS on CentOS 7 with MySQL \/ MariaDB","datePublished":"2019-05-06T11:00:39+00:00","dateModified":"2021-11-14T20:36:23+00:00","mainEntityOfPage":{"@id":"https:\/\/draculaservers.com\/tutorials\/freeradius-centos-7-mysql\/"},"wordCount":1841,"commentCount":16,"publisher":{"@id":"https:\/\/draculaservers.com\/tutorials\/#organization"},"image":{"@id":"https:\/\/draculaservers.com\/tutorials\/freeradius-centos-7-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-CentOS-7-with-MySQL-_-MariaDB.png","articleSection":["CentOS","Open-source","Radius"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/draculaservers.com\/tutorials\/freeradius-centos-7-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/draculaservers.com\/tutorials\/freeradius-centos-7-mysql\/","url":"https:\/\/draculaservers.com\/tutorials\/freeradius-centos-7-mysql\/","name":"Install & Configure FreeRADIUS on CentOS 7 with MySQL \/ MariaDB - Dracula Servers Tutorials","isPartOf":{"@id":"https:\/\/draculaservers.com\/tutorials\/#website"},"primaryImageOfPage":{"@id":"https:\/\/draculaservers.com\/tutorials\/freeradius-centos-7-mysql\/#primaryimage"},"image":{"@id":"https:\/\/draculaservers.com\/tutorials\/freeradius-centos-7-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-CentOS-7-with-MySQL-_-MariaDB.png","datePublished":"2019-05-06T11:00:39+00:00","dateModified":"2021-11-14T20:36:23+00:00","breadcrumb":{"@id":"https:\/\/draculaservers.com\/tutorials\/freeradius-centos-7-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/draculaservers.com\/tutorials\/freeradius-centos-7-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/draculaservers.com\/tutorials\/freeradius-centos-7-mysql\/#primaryimage","url":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-CentOS-7-with-MySQL-_-MariaDB.png","contentUrl":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/05\/Install-Configure-FreeRADIUS-on-CentOS-7-with-MySQL-_-MariaDB.png","width":1024,"height":512,"caption":"freeradius_centos_7"},{"@type":"BreadcrumbList","@id":"https:\/\/draculaservers.com\/tutorials\/freeradius-centos-7-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/draculaservers.com\/tutorials\/"},{"@type":"ListItem","position":2,"name":"Install &#038; Configure FreeRADIUS on CentOS 7 with MySQL \/ MariaDB"}]},{"@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\/1732","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=1732"}],"version-history":[{"count":3,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/posts\/1732\/revisions"}],"predecessor-version":[{"id":2303,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/posts\/1732\/revisions\/2303"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/media\/1760"}],"wp:attachment":[{"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/media?parent=1732"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/categories?post=1732"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/tags?post=1732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}