[Linux] FreeRadius With SQL 3.0 On Ubuntu18.04
因為FreeRadius
已經更新到3.0了,所以試著重新做Radius。
Install Radius & MySQL
apt install freeradius freeradius-mysql freeradius-utils mysql-server mysql-client -y
Create Radius DB & Grant User & import table
mysql -u root -p
create databse radius;
grant all on radius.* to radius@localhost identified by "your_password";
\q
mysql -u root -p radius < /etc/freeradius/3.0/mods-config/sql/main/mysql/schema.sql
Add User In Table radcheck
mysql -u radius -p
use radius
INSERT INTO radcheck (UserName, Attribute, OP, Value) VALUES ('sqltest', 'Cleartext-Password', ':=', 'testpwd');
FreeRadius Conf
- Edit
/etc/freeradius/3.0/mods-available/sql
###---Change setting---###
driver = "rlm_sql_mysql"
dialect = "mysql"
server = "Your_Radius_DB_FQDN_OR_IP"
port = 3306
login = "radius"
password = "Your_password"
radius_db = "radius"
###---uncomment---###
read_clients = yes
- Edit
/etc/freeradius/3.0/sites-avaailable/default
authorize{
sql
}
accounting{
sql
}
session{
sql
}
post-auth{
sql
}
Link SQL File
cd /etc/freeradius/3.0/mods-enabled
ln -s ../mods-available/sql ./
Restart Service To Debug Mode
/etc/init.d/freeradius stop
freeradius -X &
Use radtest
Try It
radtest sqltest testpwd localhost 18120 testing123
If You Result These, It’s Means Your Server Build Done.
Received Access-Accept Id 26 from 127.0.0.1:1812 to 0.0.0.0:0 length 20