Install FreeRadius 3.0 & MariaDB on Debian 9 Stretch

// Install Freeradius & MariaDB
apt update
apt install freeradius freeradius-utils freeradius-mysql

// Config Freeradius
cd /etc/freeradius/3.0/mods-enabled
ln -s ../mods-available/sql sql

nano /etc/freeradius/3.0/sites-available/default
"Uncomment slq"

nano /etc/freeradius/3.0/sites-available/inner-tunnel
"Uncomment slq"

nano /etc/freeradius/3.0/mods-available/sql
------------- Edit --------------
driver = "rlm_sql_mysql"
dialect = "mysql"
server = "localhost"
port = 3306
login = "radius"
password = "radius1234"
radius_db = "radius"
read_clients = yes
client_table = "nas"
----------------------------------
chgrp -h freerad /etc/freeradius/3.0/mods-enabled/sql
pkill radius
freeradius -X
systemctl start freeradius
systemctl enable freeradius
systemctl status freeradius

// Add User
INSERT INTO radcheck VALUES (1, 'demo', 'Cleartext-Password', ':=', '12345');
INSERT INTO radcheck VALUES (2, 'test', 'Cleartext-Password', ':=', '54321');

// Testing
/etc/init.d/freeradius restart
radtest demo 12345 localhost 10 testing123
radtest test 54321 localhost 10 testing123

[azisaputra]

Kalau kaya gini kenapa yah min pas langkah
"// Add User
INSERT INTO radcheck VALUES (1, 'demo', 'Cleartext-Password', ':=', '12345');

[hendrasirait]

setelah freeradius-x Muncul error

Unable to check file "/etc/ssl/certs/my_ca.crt": No such file or directory
Failed parsing configuration item "ca_file"
Instantiation failed for module "sql"

[coinseller]

Setelah perintah freeradius -X muncul error ini om
Error reading or parsing

[irvingilv]

friend pass me the database script and setup.sql