How to Install FreeRADIUS and daloRADIUS on Ubuntu 20.04 LTS

FreeRADIUS-daloRADIUS.sh

#!/bin/sh

sudo apt-get update -y
sudo apt-get upgrade -y

#Install Apache
sudo apt-get install apache2

#Install PHP
sudo apt-get install php libapache2-mod-php php-gd php-common php-mail php-mail-mime php-mysql php-pear php-db php-mbstring php-xml php-curl

#Install MariaDB
sudo apt -y install mariadb-server mariadb-client


#Configure Database for FreeRADIUS
sudo mysql_secure_installation

Enter current password for root (enter for none): Just press the Enter
Set root password? [Y/n]: Y
New password: Enter password
Re-enter new password: Repeat password
Remove anonymous users? [Y/n]: Y
Disallow root login remotely? [Y/n]: Y
Remove test database and access to it? [Y/n]:  Y
Reload privilege tables now? [Y/n]:  Y

sudo mysql -u root -p
CREATE DATABASE radius CHARACTER SET UTF8 COLLATE UTF8_BIN;
CREATE USER 'radius'@'%' IDENTIFIED BY 'G@s%w&rJ';
GRANT ALL PRIVILEGES ON radius.* TO 'radius'@'%';
QUIT;


#Install FreeRADIUS
sudo apt policy freeradius
sudo apt -y install freeradius freeradius-mysql freeradius-utils

#Once installed, import the freeradius MySQL database schema with the following command:
sudo su -
sudo mysql -u root -p radius < /etc/freeradius/3.0/mods-config/sql/main/mysql/schema.sql
sudo  mysql -u root -p -e "use radius;show tables;"

#Create a soft link for sql module under
sudo ln -s /etc/freeradius/3.0/mods-available/sql /etc/freeradius/3.0/mods-enabled/

#Run the following commands to create the Certificate Authority (CA) keys:
cd /etc/ssl/certs/
sudo openssl genrsa 2048 > ca-key.pem
sudo openssl req -sha1 -new -x509 -nodes -days 3650 -key ca-key.pem > ca-cert.pem

#Make the following changes as per your database:
sudo nano /etc/freeradius/3.0/mods-enabled/sql

sql {
driver = "rlm_sql_mysql"
dialect = "mysql"

        mysql {
                # If any of the files below are set, TLS encryption is enabled
                tls {
                        ca_file = "/etc/ssl/certs/ca-cert.pem"
                        ca_path = "/etc/ssl/certs/"
                        #certificate_file = "/etc/ssl/certs/private/client.crt"
                        #private_key_file = "/etc/ssl/certs/private/client.key"
                        cipher = "DHE-RSA-AES256-SHA:AES128-SHA"

                        tls_required = no
                        tls_check_cert = no
                        tls_check_cert_cn = no
                }

# Connection info:
server = "localhost"
port = 3306
login = "radius"
password = "G@s%w&rJ"

# Database table configuration for everything except Oracle
radius_db = "radius"
}

read_clients = yes
client_table = "nas"

#Save and close

#Set the proper permission
sudo chgrp -h freerad /etc/freeradius/3.0/mods-available/sql
sudo chown -R freerad:freerad /etc/freeradius/3.0/mods-enabled/sql

sudo systemctl restart freeradius
sudo systemctl status freeradius

#Install daloRADIUS
sudo apt -y install wget unzip
wget https://github.com/lirantal/daloradius/archive/master.zip
unzip master.zip
mv daloradius-master daloradius
cd daloradius


#Configuring daloradius
sudo mysql -u root -p radius < contrib/db/fr2-mysql-daloradius-and-freeradius.sql 
sudo mysql -u root -p radius < contrib/db/mysql-daloradius.sql

cd ..
sudo mv daloradius /var/www/html/

sudo chown -R www-data:www-data /var/www/html/daloradius/
sudo cp /var/www/html/daloradius/library/daloradius.conf.php.sample /var/www/html/daloradius/library/daloradius.conf.php
sudo chmod 664 /var/www/html/daloradius/library/daloradius.conf.php

sudo nano /var/www/html/daloradius/library/daloradius.conf.php

#Make the following changes that match your database:
sudo nano /var/www/html/daloradius/library/daloradius.conf.php

$configValues['CONFIG_DB_HOST'] = 'localhost';
$configValues['CONFIG_DB_PORT'] = '3306';
$configValues['CONFIG_DB_USER'] = 'radius';
$configValues['CONFIG_DB_PASS'] = 'G@s%w&rJ';
$configValues['CONFIG_DB_NAME'] = 'radius';

#Import the daloRAIUS MySQL tables to the FreeRADIUS database
cd /var/www/html/daloradius/
sudo mysql -u root -p radius < /var/www/html/daloradius/contrib/db/fr2-mysql-daloradius-and-freeradius.sql
sudo mysql -u root -p radius < /var/www/html/daloradius/contrib/db/mysql-daloradius.sql

sudo chown -R www-data:www-data /var/www/html/daloradius/

sudo systemctl restart freeradius.service apache2

#Visit: 
http://localhost/daloradius/login.php

Username: administrator
Password: radius

Hello
Can you help me setup Dalo RADIUS ?
I want to connect DaloRADIUS to the account creation server in OpenVPN

Hello Can you help me setup Dalo RADIUS ? I want to connect DaloRADIUS to the account creation server in OpenVPN

Yes, I can do it. Knock me on Skype: rakibul.islam643

Skype is also filtered in our country
Instagram and WhatsApp are also filters
Can I contact you by email?

Skype is also filtered in our country Instagram and WhatsApp are also filters Can I contact you by email?

yes, rakibulinux@gmail.com

Great post, i followed the instructions but after I enter the username and password for Dalo, it shows
"This page isn’t working right now"
HTTP ERROR 500

What could have gone wrong.
Thanks
Rudy

I have tried with Ubuntu 18/20/22 before it was working fine but from yesterday I noticed that after the installation no any header menu shows. What could be the reason please. Waiting for your kind reply & feedback. Thank You.

I'm having an issue with line 111, which copies files from daloradius/library. There is no library directory in the daloradius directory. I found the config daloradius.conf.php.sample file in another directory and tried copying it to library directory. However, when I try to pull the site, it shows my index of the daloradius/library and not the login page. TIA

I'm having the same problem of @larrygomeztx
Anyone knows how to fix this?

i found files in different location and also different login page:

sudo cp /var/www/html/daloradius/app/common/includes/daloradius.conf.php.sample /var/www/html/daloradius/app/common/includes/daloradius.conf.php

sudo chmod 664 /var/www/html/daloradius/app/common/includes/daloradius.conf.php

sudo vi /var/www/html/daloradius/app/common/includes/daloradius.conf.php

LOGIN:

http://localhost/daloradius/app/operators/login.php

i follow and do everything but
this error occur when i login to this website
#Visit:
http://localhost/daloradius/login.php

Username: administrator
Password: radius

how can i fix ?

Database connection error
Error Message: DB Error: extension not found

your method is correct but for old version of daloradius uploaded by lirantal, so when we try the updated version of daloradius includes app/common/ and operators and users ?
i have already installed the older version of daloradius Version 1.3 and it's working fine but now i want to shift to latest version

how to create a custom attribute for dell switch
having below attribute
testuser Cleartext-Password := "testpasswd"
Force10-avpair= "shell:role=sysadmin"

         Choose new

Create Name OS10-Radius
Click next
Add condition
Choose users groups
Add wanted user group to be allowed networking\domain admin
Click next
Ensure access granted is selected
Click next
Check "unencrypted Authentication (PAP, SPAP)
Click next
Click next on Constraints
On Settings leave standard with
Framed-protocol PPP
Service-type Framed
Vendor Specific
Select Vendor-Specific
Enter Vendor Code: 674
Yes. It conforms to Radius RFC
Configure Attribute
Vendor-assigned Attribute number: 2
Attribute format: string
Attribute value: sysadmin
Click next

i found files in different location and also different login page:

sudo cp /var/www/html/daloradius/app/common/includes/daloradius.conf.php.sample /var/www/html/daloradius/app/common/includes/daloradius.conf.php

sudo chmod 664 /var/www/html/daloradius/app/common/includes/daloradius.conf.php

sudo vi /var/www/html/daloradius/app/common/includes/daloradius.conf.php

LOGIN:

http://localhost/daloradius/app/operators/login.php

This URL worked for me too after copying from the "common" directory and modify the conf.php.
Thanks

I can't restart freeradius server. It says,
Job for freeradius.service failed because the control process exited with error code.
What o i do please?

j'ai un problème sur le ligne 117 à 123
il ne reconnait pas la commande
Que dois-je faire ?

Looking at your code and I am not really sure you need to have lines 125 and 104 since you created create the basic schema for radius in line 41. Also why are you running the same sql scripts 2 times.