安裝radius+mysql

1、精品文檔安裝 freeradius+mysql+daloradius一、安裝系統(tǒng)自帶的 mysql# yum update -y /更新 yum源# yum install mysql-server /安裝 mysql 服務(wù)# /etc/init.d/mysqld start/啟動(dòng) mysql 服務(wù)# mysqladmin -u root -p password mzywx /修改 mysql root用戶默認(rèn)密碼Enter password:/原始密碼為空，直接敲回車(chē)鍵# chkconfig -add mysqld/添加 mysql 服務(wù)# chkconfig mysqld on/開(kāi)機(jī)自啟動(dòng)

2、 mysql 服務(wù)# service mysqld status/查看 mysql 服務(wù)狀態(tài)二、安裝 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 /或者執(zhí)行 vi +76/etc/raddb/users取消注釋生效： steveCleartext-Password := testing# radtest steve testing localhost 1812 testing123/注：另開(kāi)啟一個(gè)終端執(zhí)行該命令出現(xiàn) Access-Accept 字樣說(shuō)明成功。測(cè)試成功后把 /etc/raddb/users改回去。# sed -i s/steve/#steve/g /etc/raddb/users /把/etc/raddb/users改回去三、 freeradius和 mysql

4、的集成# mysql -uroot -pmzywx -ecreate database radius /創(chuàng)建 radius 數(shù)據(jù)庫(kù)# mysql -uroot -pmzywx -eshow databases/查看是否創(chuàng)建成功+-+| 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;進(jìn)入 radius數(shù)據(jù)庫(kù)、先加入一些組信息: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 用戶名，密碼根據(jù)自己的情況填寫(xiě)/這里不用進(jìn)行修改第 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,加入 / 這一步驟根據(jù)實(shí)際情況添加 IP 地址、設(shè)備型號(hào)client secret= tp-linkshortname= test6. 啟用 radius的 sql 模塊/注：這一步驟必須執(zhí)行， 否則報(bào)錯(cuò)# sed -i 735s/#.*/$INCLUDE sql.conf/ /etc/raddb/radiusd.conf或者編輯 /etc/raddb/ra

12、diusd.conf第 735 行 # $INCLUDE sql.conf改為 $INCLUDE sql.conf /取消注釋6. 測(cè)試# 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 = 出現(xiàn) Access-Accept 字樣說(shuō)明成功。四、安裝 apache# yum install httpd -y/安裝 apache# service httpd start/啟動(dòng) apache 有警告Starting httpd: httpd: Coul

14、d not reliably determine the servers fullyqualified domain name, using 03 for ServerNameOK# chkconfig httpd on/設(shè)置開(kāi)機(jī)自動(dòng)啟動(dòng) apache# hostname/查看主機(jī)名AY140718211848765e37Z# sed -i 276s/#.*/ServerName AY140718211848765e37Z/etc/httpd/conf/httpd.conf/修改 apache 的配置文件# service httpd restart/重啟 apache

15、報(bào)錯(cuò)消失Stopping httpd:OKStarting httpd:OK# 本地瀏覽器訪問(wèn)，訪問(wèn)成功五、安裝 PHP# yum install php -y/安裝 PHP# yum install php-mysql -y/這個(gè)如果不安裝，打開(kāi)php+mysql 的程序會(huì)出錯(cuò)的# yum install php-pear-DB -y /這個(gè)如果不安裝，打開(kāi)daloradius會(huì)報(bào)錯(cuò)# service httpd restart/重啟 apache。4 歡迎下載精品文檔安裝一下php 擴(kuò)展程序。# wget /下載 php 擴(kuò)展# php go-gear.phar/安裝 php 擴(kuò)展六、安裝

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;測(cè)試配置好后在瀏覽器中打開(kāi)，下面是默認(rèn)登錄用戶名和密碼http:/yourIP/daloradiuslogin ：administratorpassword：radius。5 歡迎下載精品文檔可能出現(xiàn)的問(wèn)題1、點(diǎn)擊登錄頁(yè)面出錯(cuò)查看 http錯(cuò)誤日志信息 /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提示數(shù)據(jù)庫(kù)連接失敗。再次檢查連接數(shù)據(jù)庫(kù)文件，沒(méi)有問(wèn)題。解決：新版本的 daloradius 連接數(shù)據(jù)庫(kù)，需要安裝數(shù)據(jù)庫(kù)連接模塊。 php-pear-DB 沒(méi)辦法安裝吧！ yum install php-pear-D