PPPOE+Freeradius+Mysql+phpmyadmin1Linux1.Linux&&Centos5.6scientificlinux6.0)2.ISODVDU3.UCentos5.61)4GUWINPEUWINPE2)Centos5.6copyU/isolinux/initrd.img/isolinux/vmlinuzU3)UGRUB,:kernel(hd0,0)/isolinux/vmlinuzinitrd(hd0,0)/isolinux/initrd.imgboot4)centos5)CentOS-Base.repo,#mv/etc/yum.repos.d/CentOS-Base.repo/etc/yum.repos.d/CentOS-Base.repo.bak163#wget)RPMforgeCentosRPMforge#yuminstallyum-priorities#wget://*.rpmyummakecache7)#yuminstallgccgcc-c++kernelkernel-develkernel-headers#yumupdate2Apache+PHP5+MySQLWEB1.mysql#yuminstallmysqlmysql-server#/sbin/chkconfig--addmysqldmysql#/sbin/chkconfigmysqldonmysql#/sbin/chkconfig--listmysqldlist3/4/5#/sbin/servicemysqldstartmysql#mysqladmin-urootpassword1234mysqlroot2.Apache2#yuminstallhttpd#chkconfighttpdonApache2#/etc/init.d/httpdstartApache2(documentroot)/var/();?PHPphpinfo()PHP://192.168.0.100/info.phpmysql6.phpMyAdminphpMyAdminPHPWeb-BaseMySQLMySQL()yumphpMyAdmin,CentOSphpMyAdminCentOSRPMforge,RPMforge#yuminstallphpmyadminphpMyAdminphpMyAdminphpMyAdmin/etc/httpd/conf.d/phpmyadmin.confDirectory/usr/share/phpmyadmin#vi/etc/httpd/conf.d/phpmyadmin.conf##WebapplicationtomanageMySQL##Directory/usr/share/phpmyadmin#OrderDeny,Allow#Denyfromall#Allowfrom127.0.0.1#/DirectoryAlias/phpmyadmin/usr/share/phpmyadminAlias/phpMyAdmin/usr/share/phpmyadminAlias/mysqladmin/usr/share/phpmyadminphpMyAdmincookiehttp#vi/usr/share/phpmyadmin/config.inc.php[...]/*Authenticationtype*/$cfg['Servers'][$i]['auth_type']='http';[...]:#yuminstallfreeradius2freeradius2-utilsfreeradius2-mysql3.yumfreeradius2MySQLfreeradius2usersyumfreeradius24.yumfreeradius2#yumerasefreeradius2freeradius2-utilsfreeradius2-mysql/etc/radbd5.freeradiusfreeradius:#wget:#tar-xzvffreeradius-server-2.1.10.tar.gz7.mysql-devel#yuminstallmysql-devel8.#cdfreeradius-server-2.1.10#./configure#make#makeinstall9.:1)/usr/local/sbincheckradradiusdradminradwatchrc.radiusd2)/usr/local/binadlastradtestrandpktrlm_dbm_parserradclientradsniffradwhoradeapclientradsqlrelayradzaprlm_dbm_cat3)/usr/local/etc/raddb4)/usr/local/share/manman5)/usr/local/var/run/radiusd6)/usr/local/var/log/radius7)/usr/local/var/log/radius/radacct8)/usr/local/share/freeradius9)/usr/local/libfreeradius10.freeradius1)/etc/raddb/usersfreeradiussteve#,steveCleartext-Password:=testingService-Type=Framed-User,Framed-Protocol=PPP,Framed-IP-Address=172.16.3.33,Framed-IP-Netmask=255.255.255.0,Framed-Routing=Broadcast-Listen,Framed-Filter-Id=std.ppp,Framed-MTU=1500,Framed-Compression=Van-Jacobsen-TCP-IPstevetesting,2)radius:#radiusd-XListeningonauthentication*:1812Listeningonaccounting*:1813Readytoprocessrequests.testing123/etc/raddb/clients.conflocalhost3)#radteststevetestinglocalhost1812testing123Access-Acceptsteve#/etc/raddb/users4Freeradiusmysql1.#mysqladmin-uroot-pcreateradius--radius#mysql-uroot-peetryradius/usr/local/etc/raddb/sql/mysql/schema.sql#mysql-uroot-peetryradius/usr/local/etc/raddb/sql/mysql/nas.sql#mysql-uroot-peetryradius/usr/local/etc/raddb/sql/mysql/ippool.sql#mysql-uroot-peetryradius/usr/local/etc/raddb/sql/mysql/wimax.sql2.#mysql-uroot-p#useradius–#mysqlGRANTSELECTONradius.*TO'radius'@'localhost'IDENTIFIEDBY'radpass';#mysqlGRANTALLonradius.radacctTO'radius'@'localhost';#mysqlGRANTALLonradius.radpostauthTO'radius'@'localhost';:mysqlinsertintoradgroupreply(groupname,attribute,op,value)values('user','Auth-Type','=','Local');mysqlinsertintoradgroupreply(groupname,attribute,op,value)values('user','Service-Type','=','Framed-User');mysqlinsertintoradgroupreply(groupname,attribute,op,value)values('user','Framed-IP-Netmask','=','255.255.255.255');mysqlinsertintoradgroupreply(groupname,attribute,op,value)values('user','Framed-IP-Netmask','=','255.255.255.0');mysqlINSERTINTOradcheck(UserName,Attribute,Value)VALUES('sqltest','Password','testpwd');mysqlmysqlselect*fromradcheckwhereUserName='sqltest';3./etc/raddb/sql.conf,mysql()/etc/raddb/sites-enabled/default152files159sql383sql/etc/raddb/radiusd.conf6