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ÔçÒÑ¿¼Âǵ½ÁËÕâÒ»µã£©£
Ïà¹ØÎĵµ£º
For SQL Server2008:
http://www.microsoft.com/downloads/details.aspx?FamilyID=0e6168b0-2d0c-4076-96c2-60bd25294a8e&displaylang=en
For SQL Server2005:
http://www.microsoft.com/downloads/details.aspx?familyid=C6F14640-DA22-4604-AAAA-A45DE4A0CD4A&displaylang=en ......
Mysql£¬SqlServer£¬OracleÖ÷¼ü×Ô¶¯Ôö³¤µÄÉèÖÃ
1¡¢°ÑÖ÷¼ü¶¨ÒåΪ×Ô¶¯Ôö³¤±êʶ·ûÀàÐÍ
ÔÚmysqlÖУ¬Èç¹û°Ñ±íµÄÖ÷¼üÉèΪauto_incrementÀàÐÍ£¬Êý¾Ý¿â¾Í»á×Ô¶¯ÎªÖ÷¼ü¸³Öµ¡£ÀýÈ磺
create table customers(id int auto_increment primary key not null, name varchar(15));
insert into customers(name) values("name1"),("nam ......
1.reverse(str)º¯Êý: ·µ»Øµßµ¹×Ö·û˳ÐòµÄ×Ö·û´®str, ¸Ãº¯Êý¶Ô¶à×Ö½Ú¿É¿¿µÄ.
mysql> select * from user;
+----+------------------+
| id | name |
+----+------------------+
| 1 | test &nbs ......
¼¸¸ö³£ÓÃÓÃÀý£º
1.µ¼³öÕû¸öÊý¾Ý¿â
mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql
2.µ¼³öÒ»¸ö±í
mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû ±íÃû> µ¼³öµÄÎļþÃû
mysqldump -u wcnc -p smgp_apps_wcnc users> wcnc_users.sql
3.µ¼³öÒ»¸öÊý¾Ý¿â½á¹¹
mysqldump ......
¹ØÓÚMySQLÊÂÎñ´¦Àíѧϰ¼Ç
START TRANSACTION, COMMITºÍROLLBACKÓï·¨
START TRANSACTION | BEGIN [WORK]
COMMIT [WORK] [AND [NO] CHAIN] [[NO] RELEASE]
ROLLBACK [WORK] [AND [NO] CHAIN] [[NO] RELEASE]
SET AUTOCOMMIT = {0 | 1}
START
TRANSACTION»òBEGINÓï¾ä¿ÉÒÔ¿ªÊ¼Ò»ÏîеÄÊÂÎñ¡£COMMIT¿ÉÒÔÌá½»µ±Ç°ÊÂÎñ ......