因為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