上节freeradius已经安装好了,并与openldap连接认证,本节学习与mysql的连接
在centos7 环境,freeradius和maridb都已经安装好了
1. 建库建表
create database radius;
grant all on radius.* to root@localhost identified by "123";
mysql -u root radius < /etc/raddb/mods-config/sql/main/mysql/schema.sql
2.建立用户组
insert into radgroupreply (groupname,attribute,op,value) values ('group1','Auth-Type',':=','Local');
insert into radgroupreply (groupname,attribute,op,value) values ('group1','Service-Type',':=','Framed-User');
insert into radgroupreply (groupname,attribute,op,value) values ('group1','Framed-IP-Address',':=','192.168.49.0');
insert into radgroupreply (groupname,attribute,op,value) values ('group1','Framed-IP-Netmask',':=','255.255.255.0');
3.建立测试用户
insert into rad