学习笔记：上网认证3 FreeRadius与mysql的连接

上节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