安装radius+mysql

1、精品文档安装 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/开机自启动

2、 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/#s

3、teve/steve/g /etc/raddb/users /或者执行 vi +76/etc/raddb/users取消注释生效： steveCleartext-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

4、的集成# mysql -uroot -pmzywx -ecreate database radius /创建 radius 数据库# mysql -uroot -pmzywx -eshow databases/查看是否创建成功+-+| Database|+-+| information_schema | mysql| radius| test|+-+。1 欢迎下载精品文档# mysql -uroot -pmzywx radius /etc/raddb/sql/mysql/schema.sql# mysql -uroot -pmzywx radius /etc/raddb/sql/mysql/n

5、as.sql# mysql -uroot -pmzywx radius /etc/raddb/sql/mysql/ippool.sql# mysql -uroot -pmzywx 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;进入 radius数据库、先加入一些组信息:mysq

6、l 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-N

7、etmask,=,55);mysql insert into radgroupreply (groupname,attribute,op,value) values (user,Framed-IP-Netmask,:=,);然后加入用户信息：mysql INSERT INTO radcheck (UserName, Attribute, Value) VALUES (sqltest, Password, testpwd);然后把用户加到组里：mysql insert into radusergroup(username,groupname)v

8、alues(sqltest,user);mysql select * from radcheck where UserName=sqltest; +-+-+-+-+-+| id | username | attribute | op | value|+-+-+-+-+-+|1 | sqltest| Password| = | testpwd |+-+-+-+-+-+1 row in set (0.00 sec)mysql quitBye1.# sed -i s/#readclients = yes/readclients = yes/g /etc/raddb/sql.conf。2 欢迎下载精品

9、文档或者 编辑 /etc/raddb/sql.confmysql 用户名，密码根据自己的情况填写/这里不用进行修改第 88 行取消 readclients = yes前的注释2.# sed -i 170s/files/#files/ /etc/raddb/sites-enabled/default# sed -i 177s/#.*/sql/ /etc/raddb/sites-enabled/default# sed -i 406s/#.*/sql/ /etc/raddb/sites-enabled/default或者编辑 /etc/raddb/sites-enabled/default第 17

10、0 行 files 前加注释第 177 行取消 sql 前的注释第 406 行取消 sql 前的注释3.# sed -i 125s/files/#files/ /etc/raddb/sites-enabled/inner-tunnel# sed -i 132s/#.*/sql/ /etc/raddb/sites-enabled/inner-tunnel或者编辑 /etc/raddb/sites-enabled/inner-tunnel第 125 行 files 前加注释第 132 行取消 sql 前的注释4.# sed -i 30s/md5/peap/ /etc/raddb/eap.conf或

11、者编辑 /etc/raddb/eap.conf第 30 行 default_eap_type = md5改为 default_eap_type = peap5. 编辑 /etc/raddb/clients.conf,加入 / 这一步骤根据实际情况添加 IP 地址、设备型号client secret= tp-linkshortname= test6. 启用 radius的 sql 模块/注：这一步骤必须执行， 否则报错# sed -i 735s/#.*/$INCLUDE sql.conf/ /etc/raddb/radiusd.conf或者编辑 /etc/raddb/ra

12、diusd.conf第 735 行 # $INCLUDE sql.conf改为 $INCLUDE sql.conf /取消注释6. 测试# radtest sqltest testpwd localhost 1812 testing123。3 欢迎下载精品文档Sending Access-Request of id 138 to port 1812 User-Name = sqltestUser-Password = testpwdNAS-IP-Address = 03NAS-Port = 1812Message-Authenticator = 0x

13、00000000000000000000000000000000 rad_recv: Access-Accept packet from host port 1812, id=138, length=32Service-Type = Framed-UserFramed-IP-Netmask = 出现 Access-Accept 字样说明成功。四、安装 apache# yum install httpd -y/安装 apache# service httpd start/启动 apache 有警告Starting httpd: httpd: Coul

14、d not reliably determine the servers fullyqualified domain name, using 03 for ServerNameOK# chkconfig httpd on/设置开机自动启动 apache# hostname/查看主机名AY140718211848765e37Z# sed -i 276s/#.*/ServerName AY140718211848765e37Z/etc/httpd/conf/httpd.conf/修改 apache 的配置文件# service httpd restart/重启 apache

15、报错消失Stopping httpd:OKStarting httpd:OK# 本地浏览器访问，访问成功五、安装 PHP# yum install php -y/安装 PHP# yum install php-mysql -y/这个如果不安装，打开php+mysql 的程序会出错的# yum install php-pear-DB -y /这个如果不安装，打开daloradius会报错# service httpd restart/重启 apache。4 欢迎下载精品文档安装一下php 扩展程序。# wget /下载 php 扩展# php go-gear.phar/安装 php 扩展六、安装

16、 Daloradius# 下载地址： # tar zxvf daloradius-0.9-8.tar.gz -C /var/ww/html/daloradius# chown -R apache:apache /var/www/html/daloradius# cd /var/ww/html/daloradius# mysql -uroot -pmzywx radius contrib/db/mysql-daloradius.sql# mysql -uroot -pmzywx radius grant all privileges on radius.* to radius% identifi

17、ed by radpass;mysql flush privileges;测试配置好后在浏览器中打开，下面是默认登录用户名和密码http:/yourIP/daloradiuslogin ：administratorpassword：radius。5 欢迎下载精品文档可能出现的问题1、点击登录页面出错查看 http错误日志信息 /var/log/httpd/error_logMon Oct 14 15:44:51 2013 error client 5 PHP Warning: include_once(): Failed opening DB.php for inclusi

18、on (include_path=.:/usr/share/pear:/usr/share/php) in /var/www/html/daloradius/library/opendb.php on line 84, referer: 0/daloradius/login.phpMon Oct 14 15:44:51 2013 errorclient5PHPFatalerror:Class DB not found in /var/www/html/daloradius/library/opendb.php online 86, referer: 0/daloradius/login.php提示数据库连接失败。再次检查连接数据库文件，没有问题。解决：新版本的 daloradius 连接数据库，需要安装数据库连接模块。 php-pear-DB 没办法安装吧！ yum install php-pear-D