Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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ÔçÒÑ¿¼Âǵ½ÁËÕâÒ»µã£©£


Ïà¹ØÎĵµ£º

mysqlÊý¾ÝÒÆÖ²


 
1.   ÔÚÆäËü»úÆ÷ÉÏÊ×ÏȰ²×°ºÃÐèÒªµÄmysql ºÍ¶ÔÓ¦µÄ¹ÜÀíÈí¼þ£¨ÉèÖõÄÃÜÂëºÍÔ´Êý¾Ý¿âÃÜÂëÒ»Ö£©
2.   ½«Ô´»úÆ÷ÉÏdataϵÄÊý¾Ý¿âÎļþ¼Ð£¨ÒÔÎҵĻúÆ÷ΪÀý£¬¾ÍÊÇrubberFactoryÎļþ¼Ð£¬ÆäÖУ¬
      Õâ¸öÎļþ¼ÐϵÄÊý¾ÝÎļþ¶¼ÊÇһЩ±í½á¹¹¶¨Ò壩¿½±´µ½Ä ......

Mysql£¬SqlServer£¬OracleÖ÷¼ü×Ô¶¯Ôö³¤µÄÉèÖÃ


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 ......

MySQL³£¼û×Ö·û´®º¯Êýѧϰ

1.reverse(str)º¯Êý: ·µ»Øµßµ¹×Ö·û˳ÐòµÄ×Ö·û´®str, ¸Ãº¯Êý¶Ô¶à×Ö½Ú¿É¿¿µÄ.
mysql> select * from user;
+----+------------------+
| id | name             |
+----+------------------+
|  1 | test      &nbs ......

mysqlÓÅ»¯×ܽá

Èç¹û´ó¼ÒÓÐÒìÒ飬¿ÉÒÔÔÚºóÃæ²¹³ä¡£ÎÒ»áËæÊ±¸üеġ£
ÏÖÔÚ´ó¸ÅÁгöÈçÏÂ:(Íû¸÷λ²¹³ä)
1.Êý¾Ý¿âµÄÉè¼Æ
¾¡Á¿°ÑÊý¾Ý¿âÉè¼ÆµÄ¸üСµÄÕ¼´ÅÅ̿ռä.
1).¾¡¿ÉÄÜʹÓøüСµÄÕûÊýÀàÐÍ.(mediumint¾Í±Èint¸üºÏÊÊ).
2).¾¡¿ÉÄ͍ܵÒå×Ö¶ÎΪnot null,³ý·ÇÕâ¸ö×Ö¶ÎÐèÒªnull.£¨Õâ¸ö¹æÔòÖ»ÊʺÏ×Ö¶ÎΪKEYµÄÇéÐΣ©
3).Èç¹ûûÓÐÓõ½±ä³¤×Ö¶ÎµÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ