安裝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 服務狀態(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/注：另開啟一個終端執(zhí)行該命令出現 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 /創(chuàng)建 radius 數據庫# 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;進入 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 模塊/注：這一步驟必須執(zhí)行， 否則報錯# 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