ubuntu8.04.2ÏÂApache+Resin+Mysql°²×°+ÐéÄâÖ÷»úÅäÖÃ
Ò» Apache°²×°
# tar zxvf httpd-2.2.14.tar.gz(½âѹ)
# cd httpd-2.2.14(½øÈë½âѹºóµÄĿ¼)
# ./configure --prefix=/usr/local/apache2 --enable-so --enable-mods-shared=all
(ÃüÁî#./configure --help¿ÉÒԲ鿴configureµÄÅäÖòÎÊý
--prefix=°²×°Â·¾¶
--enable-so //´ò¿ª DSO Ö§³ÖµÄ apache ºËÐÄÄ£¿é
--enable-mods-shared=all //½«È«²¿µÄÄ£°å±àÒë³ÉDSO£¬¶ÔÓÚ²»ÐèÒªÎÒÃÇ¿ÉÒÔÔÚhttpd.confÈ¥µô
)
# make
# make install
configureʱ³öÏÖ±àÒë´íÎóÌáʾΪûC±àÒ빤¾ß£¬½â¾ö·½·¨£º
°²×°GCC
#sudo apt-get install build-essential
³öÏÖ¹ØÓÚzlibµÄ´íÎó£¬ÔÒòÊÇȱÉÙzlib
linuxϱàÒë°²×°zlib
zlib¹Ù·½ÍøÕ¾£º
http://www.zlib.net
ÉÏÏÂÔØÔ´ÂëÀ´°²×°zlibÈí¼þ°ü¡£
Ä¿Ç°×îа汾zlibÊÇzlib1.2.3£¬°²×°¿ªÊ¼£»
# wget http://www.zlib.net/zlib-1.2.3.tar.gz
# tar -xvzf zlib-1.2.3.tar.gz
# cd zlib-1.2.3.tar.gz
# ./configure
# make
# sudo make install
Æô¶¯Apache(rootÓû§²ÅÄÜ)
# /usr/local/apache2/bin/apachectl start
²é¿´±àÒë½øapacheµÄÄ£¿é
# /usr/local/apache2/bin/httpd -l
¿ª»úÆô¶¯Apache
# cp /usr/local/apache2/bin/apachectl /etc/init.d/apachectl
# sysvconfig(ÊÇͼÐνçÃ棬½«apachectlÑ¡ÖÐ)
=======================================================================================================================
¶þ Mysql°²×°
# tar zvxf mysql-5.1.39.tar.gz
# cd mysql-5.1.39
# ./configure --prefix=/usr/local/mysql --with-charset=utf8 --with-collation=utf8_bin --with-extra-charsets=big5,ascii,gb2312,gbk,utf8,latin1
//ĬÈϵÄ×Ö·û¼¯È±Ê¡Îªlatin1¡£
//ÆäÖУ¬utf8¶ÔÓ¦¿ÉÓõÄcollationֵΪ£ºutf8_bin¡¢utf8_general_ci¡¢utf8_unicode_ci
//extraÖ§³ÖÒ²¿ÉÒÔʹÓà "--with-extra-charsets=all"¡£
//ĬÈÏconfigure²ÎÊýϲ»»á°²×°gbk±àÂë
ÅäÖóɹ¦»áÌáʾ£º
MySQL has a Web site at [URL="http://www.mysql.com/"][COLOR=#000000]http://www.mysql.com/[/COLOR][/URL] whic
Ïà¹ØÎĵµ£º
»·¾³ rhel5.4
×°ºÃgcc ºÍÏàÓ¦µÄ¿â¡£ÎÒÕâ±ßÓöµ½curses¡£DebianϵͳµÄ»°Ðè°²×°apt-get install libncurses5-dev¡£
ÏÂÔØmysqlÔ´Âë°ü£¬ÎÒ×Ô¼ºÔÚmyslq¹Ù·½ÍøÕ¾ÉÏÏÂÁËÒ»¸ö“mysql-5.0.87.tar.gz”
cd /usr/local/src/
½â°ü tar zxvf mysql-5.0.87.tar.gz
cd mysql-5.0.87
./configure --prefix=/usr/local/servic ......
try
{
string _conStr = "Driver={MySQL ODBC 3.51
Driver};server=localhost;database=test;uid=test;password=1;option=3";
& ......
ÔÚ MySQLÏ£¬ÔÚ½øÐÐÖÐÎÄÄ£ºý¼ìË÷ʱ£¬¾³£»á·µ»ØһЩÓëÖ®²»Ïà¹ØµÄ¼Ç¼£¬Èç²éÕÒ "%a%" ʱ£¬·µ»ØµÄ¿ÉÄÜÓÐÖÐÎÄ×Ö·û£¬È´Ã»ÓÐa×Ö·û´æÔÚ¡£±¾ÈËÒÔÇ°Ò²ÔøÓöµ½¹ýÀàËÆÎÊÌ⣬¾ÏêϸÔĶÁMySQLµÄManual£¬·¢ÏÖ¿ÉÒÔÓÐÒ»ÖÖ·½·¨ºÜ·½±ãµÄ½â¾ö²¢µÃµ½ÂúÒâµÄ½á¹û¡£
¡¡¡¡Àý×Ó£º
¡¡¡¡Ï£Íûͨ¹ý“±êÌ┶ÔÐÂÎÅ¿â½øÐмìË÷£¬¹Ø¼ü×Ö¿ÉÄÜ°üº¬Ê ......
1¡¢¿´»úÆ÷ÅäÖã¬Ö¸Èý´ó¼þ£ºcpu¡¢ÄÚ´æ¡¢Ó²ÅÌ
2¡¢¿´mysqlÅäÖòÎÊý
3¡¢²éϵmysqlÐÐ״̬£¬¿ÉÒÔÓÃmysqlreport¹¤¾ßÀ´²é¿´
4¡¢²é¿´mysqlµÄÂý²éѯ
ÒÀ´Î½â¾öÁËÒÔÉÏÎÊÌâÖ®ºó£¬ÔÙÀ´²éÕÒ³ÌÐò·½ÃæµÄÎÊÌâ
my.cnf»º´æÓÅ»¯
ÔÚ my.cnf ÖÐÌí¼Ó/ÐÞ¸ÄÒÔÏÂÑ¡Ïî:
#È¡ÏûÎļþϵͳµÄÍⲿËø
skip-locking
#²»½øÐÐÓòÃû·´½âÎö,×¢Òâ ......
1.linuxÏÂÆô¶¯mysqlµÄÃüÁ
mysqladmin start
/ect/init.d/mysql start (Ç°ÃæΪmysqlµÄ°²×°Â·¾¶)
2.linuxÏÂÖØÆômysqlµÄÃüÁ
mysqladmin restart
/ect/init.d/mysql restart (Ç°ÃæΪmysqlµÄ°²×°Â·¾¶)
3.linuxϹرÕmysqlµÄÃüÁ
mysqladmin shutdown
/ect/init.d/mysql&nbs ......