centos 5.Freeradius2.1 mysql 5.0³É¹¦°²×°ÅäÖñʼÇ
(1)°²×° freeradius-server-2.1.1.tar.gz
[root@localhost freeradius-server-2.1.1]# tar zxvf freeradius-server-2.1.1.tar.gz
[root@localhost freeradius-server-2.1.1]# cd freeradius-server-2.1.1
[root@localhost freeradius-server-2.1.1]# ./configure
[root@localhost freeradius-server-2.1.1]# make
[root@localhost freeradius-server-2.1.1]# make install
------------------------------------------------------------------------------------
(1.1)°²×°µÄÎļþËùÔÚµÄϵͳĿ¼£º
1) /usr/local/sbin£º checkrad radiusd radmin radwatch rc.radiusd
2) /usr/local/bin£ºradlast radtest randpkt rlm_dbm_parser radclient radsniff radwho radeapclient radsqlrelay radzap rlm_dbm_cat
3) /usr/local/etc/raddb£º ÅäÖÃÎļþ
4) /usr/local/share/man£ºmanÊÖ²á
5) /usr/local/var/run/radiusd£ºÔËÐÐʱÉú³ÉµÄÎļþ´æ·ÅĿ¼
6) /usr/local/var/log/radius£ºÈÕÖ¾Îļþ´æ·ÅĿ¼
7) /usr/local/var/log/radius/radacct
8) /usr/local/share/freeradius£º´æ·Å¸÷¸öÊôÐÔ¶¨Òå
9) /usr/local/lib£º freeradiusʹÓõĿâÎļþ
------------------------------------------------------------------------------------------------------------------
£¨2£©²âÊÔfreeradiusÊÇ·ñÒѰ²×°³É¹¦
¡¡(2.1)²âÊÔÐèÒªÓû§£¬Òò´ËÏȽ«/etc/raddb/usersÎļþ´ò¿ª£¬´´½¨ÐµÄÓû§Ãû£¬Èç¹û²»»á´´½¨£¨freeradiusÔçÒÑ¿¼Âǵ½ÁËÕâÒ»µã£©£
Ïà¹ØÎĵµ£º
ÔÚaccessÖбíÖÐÊý¾Ýµ¼³öΪÎı¾Îļþµ½MySQLµÄÎÊÌ⣿
µ¼³öÎı¾Îļþʱºò£¬¿ÉÒÔÑ¡Ôñ×ֶηָô·û£¬À´°ÑÿһÁиô¿ª ºÍ Îı¾Ê¶±ð·û£¬À´°ÑcharÐÍÊý¾ÝÀ¨ÆðÀ´
ÎÒÏÖÔÚÓÓ£¬”×÷Ϊ×ֶηָô·û£¬²»Ê¹ÓÃÎı¾Ê¶±ð·û
Éú³ÉµÄÎı¾ÎļþÈçÏÂ
1£¬ÕÅÈý£¬ÄУ¬£¬Öйú ÉϺ££¬80501206
2£¬ÍõÎ壬Ů£¬Öйú ±±¾© ......
1. ¼ò½é
ÔÚWebÓ¦ÓóÌÐòÌåϵ¼Ü¹¹ÖУ¬Êý¾Ý³Ö¾Ã²ã£¨Í¨³£ÊÇÒ»¸ö¹ØÏµÊý¾Ý¿â£©ÊǹؼüµÄºËÐIJ¿·Ö£¬Ëü¶ÔϵͳµÄÐÔÄÜÓзdz£ÖØÒªµÄÓ°Ïì¡£MySQLÊÇĿǰʹÓÃ×î¶àµÄ¿ªÔ´Êý¾Ý¿â£¬µ«ÊÇMySQLÊý¾Ý¿âµÄĬÈÏÉèÖÃÐÔÄܷdz£µÄ²î£¬½ö½öÊÇÒ»¸öÍæ¾ßÊý¾Ý¿â¡£Òò´ËÔÚ²úÆ·ÖÐʹÓÃMySQLÊý¾Ý¿â±ØÐë½øÐбØÒªµÄÓÅ»¯¡£
ÓÅ»¯ÊÇÒ»¸ö¸´ÔÓµÄÈÎÎñ£¬±¾ÎÄÃèÊöMySQLÏ ......
´´½¨Êý¾Ý¿â£ºcreate database Êý¾Ý¿âÃû;
´´½¨±í£ºcreate table ±íÃû £¨ ÁÐÃû Êý¾ÝÀàÐÍ not null... £©;
²é¿´ÏµÍ³ÖÐËùÓеÄÊý¾Ý¿â£ºshow databases;
Ñ¡ÔñÒªÓ¦ÓõÄÊý¾Ý¿â£ºuse Êý¾Ý¿âÃû;
²é¿´Ä³¸öÊý¾Ý¿âϵÄËùÓÐ±í£ºshow tables;
²é¿´±í½á¹¹£ºdesc(describe) ±íÃû;
ÖØÃüÃû±íÃû£ºalter table ±íÃû rename as бíÃû
¸ ......
[root@pku-fan MySQL]# cat limbs.sql
CREATE DATABASE cookbook;
USE cookbook;
DROP TABLE IF EXISTS limbs;
CREATE TABLE limbs
(
thing VARCHAR(20), # what the thing is
legs INT, ......