资源描述
CentOS 6:yum install freeradiusfreeradius-ldap freeradius-mysql freeradius-utils mysql-server -y(4)freeradius与mysql关连本人一开始对这部分也不了解,全是从网上找的,经过N将的试验才通过。 首先要启用mysql:#/etc/rc.d/init.d/mysqld status 查看mysql是否已启动,如果没有 #/etc/rc.d/init.d/mysqlstart 启动mysql,然后:(a)创建radius数据库#mysql -u root -p /默认没有密码 mysqlcreate database radius; mysqlexit;(b)将radius中的sql表导入到mysql的radius数据库中# mysql -u root -p radius /etc/raddb/sql/mysql/schema.sql# mysql -u root -p radius /etc/raddb/sql/mysql/nas.sql# mysql -u root -p radius GRANT SELECT ON radius.* TO radiuslocalhost IDENTIFIED BY radpass; mysql GRANT ALL on radius.radacct TO radiuslocalhost; mysql GRANT ALL on radius.radpostauth TO radiuslocalhost; (d)加入一些组信息: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-Netmask,=,255.255.255.255); mysql insert into radgroupreply (groupname,attribute,op,value) values (user,Framed-IP-Netmask,:=,255.255.255.0);(e)加入用户信息:mysql INSERT INTO radcheck (UserName, Attribute, Value) VALUES (azalea, Password, azalea);mysql INSERT INTO radcheck (UserName, Attribute, Value) VALUES (support, Password, sup123);(f)然后把用户加到组里:mysql insert into radusergroup(username,groupname) values(azalea,user); mysql insert into radusergroup(username,groupname) values(support,user); 使用命令:#mysql select * from radcheck 查看已创建的用户名及密码 mysql select * from radcheck;+-+-+-+-+-+| id | username | attribute | op | value |+-+-+-+-+-+| 1 | azalea | Password | = | azalea | 2 | support | Password | = | sup123 |+-+-+-+-+-+2 rows in set (0.00 sec)(g)修改mysql数据库的root用户密码为azalea#mysqladmin -u root -p password azalea Enter password: /此处是旧密码,默认为空
展开阅读全文