安装radius+mysql.docxVIP

安装freeradius+mysql+daloradius一、安装系统自带的mysql# yum update -y //更新yum源# yum install mysql-server //安装mysql服务# /etc/init.d/mysqld start //启动mysql服务# mysqladmin -u root -p password mzywx //修改mysql root用户默认密码Enter password: //原始密码为空，直接敲回车键# chkconfig --add mysqld //添加mysql服务# chkconfig mysqld on //开机自启动mysql服务# service mysqld status//查看mysql服务状态二、安装freeradius# yum install freeradius -y# yum install freeradius-mysql freeradius-perl freeradius-utils freeradius-ldap freeradius-python freeradius-devel -y# chown -R radiusd:radiusd /etc/raddb# chmod a+r /etc/raddb/dictionary# radiusd -X# sed -i s/#steve/steve/g /etc/raddb/users //或者执行vi +76 /etc/raddb/users取消注释生效：steve Cleartext-Password := testing# radtest steve testing localhost 1812 testing123 //注：另开启一个终端执行该命令出现Access-Accept字样说明成功。测试成功后把/etc/raddb/users改回去。# sed -i s/steve/#steve/g /etc/raddb/users //把/etc/raddb/users改回去三、freeradius和mysql的集成# mysql -uroot -pmzywx -ecreate database radius //创建radius数据库# mysql -uroot -pmzywx -eshow databases //查看是否创建成功+--------------------+| Database |+--------------------+| information_schema || mysql || radius || test |+--------------------+# mysql -uroot -pmzywx radius /etc/raddb/sql/mysql/schema.sql# mysql -uroot -pmzywx radius /etc/raddb/sql/mysql/nas.sql# mysql -uroot -pmzywx radius /etc/raddb/sql/mysql/ippool.sql# mysql -uroot -pmzywx radius /etc/raddb/sql/mysql/wimax.sql# mysql -uroot -pmzywxmysql GRANT SELECT ON radius.* TO radius@localhost IDENTIFIED BY radpass;mysql GRANT ALL on radius.radacct TO radius@localhost;mysql GRANT ALL on radius.radpostauth TO radius@localhost;进入radius数据库、先加入一些组信息:mysql use radius;mysql insert into radgroupreply (groupname,attribute,op,value) values (user,Auth-Type,:=,Local);mysql insert into radgroupreply (groupname,attribute,op,value) values (user,Service-Type,=,Framed-User);mysql insert into radgroupreply (groupname,attribute,op,value) values (user,Framed-IP