Centos apache2.2.4 MySql5.6.X PHP5.5.3手記自己備查

看軟體安裝協助比什麼都重要!!!

*首先卸載乾淨以前的 apache mysql php aprapr-util 等

安裝PHP第三方擴充包

安裝jpeg6需要注意
首先看有沒有安裝libtool 及 libtool-ltdl-devel
rpm -qa | grep libtool
然後進入jpeg-6b的源碼目錄，然後執行以下步驟，切記！COPY到目前的目錄注意後面的點(.)
cp /usr/share/libtool/config.sub .
cp /usr/share/libtool/config.guess .
也就是把 libtool裡面的兩個設定檔拿來覆蓋掉jpeg-6b目錄下的對應檔案
make clean 再重新configure
沒有許可權的時候先建立對應的檔案夾，再次make install就行了

mkdir -p /usr/local/libxm2
mkdir -p /usr/local/libmcrypt
mkdir -p /usr/local/zlib
mkdir -p /usr/local/libpng
mkdir -p /usr/local/jpeg6
mkdir -p /usr/local/jpeg6/bin
mkdir -p /usr/local/jpeg6/lib
mkdir -p /usr/local/jpeg6/include
mkdir -p /usr/local/jpeg6/man/man1
mkdir -p /usr/local/pcre
mkdir -p /usr/local/apr
mkdir -p /usr/local/apr-util
mkdir -p /usr/local/gd
mkdir -p /usr/local/autoconf
mkdir -p /usr/local/freetype
mkdir -p /usr/local/libevent
mkdir -p /usr/local/libiconv
mkdir -p /usr/local/mhash
mkdir -p /usr/local/autoconf

./configure –prefix=/usr/local/pcre
./configure –prefix=/usr/local/apr
./configure –prefix=/usr/local/apr-util
./configure –prefix=/usr/local/libxm2
./configure –prefix=/usr/local/libmcrypt
./configure –prefix=/usr/local/zlib
./configure –prefix=/usr/local/libpng
./configure –prefix=/usr/local/jpeg6 -enable-shared -enable-static
./configure –prefix=/usr/local/gd -with-jpeg=/usr/local/jpeg6
./configure –prefix=/usr/local/autoconf
./configure –prefix=/usr/local/freetype
./configure –prefix=/usr/local/libevent
./configure –prefix=/usr/local/libiconv
./configure –prefix=/usr/local/mhash

安裝ZendOptimizer
注意:安裝ZendOptimizer 進入到 ZendOptimizer/data/5_2_x_comp 拷貝ZendOptimizer.so 到任意方便的地方

mysql 問題處理
/usr/local/mysql/scripts/mysql_install_db –user=mysql
/usr/local/mysql/bin/mysqld_safe & 添加&是後台運行

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’
上網查了下：
這種情況大多數是因為你的mysql是使用rpm方式安裝的，它會自動尋找 /var/lib/mysql/mysql.sock 這個檔案，
通過unix socket登入mysql。
常見解決辦法如下：
1、
建立/修改檔案 /etc/my.cnf，至少增加/修改一行
[mysql]
[client]
socket = /tmp/mysql.sock
#在這裡寫上你的mysql.sock的正確位置，通常不是在 /tmp/ 下就是在 /var/lib/mysql/ 下

2、
指定IP地址，使用tcp方式串連mysql，而不使用本地sock方式
#mysql -h127.0.0.1 -uuser -ppassword

3、
為 mysql.sock 加個串連，比如說實際的mysql.sock在 /tmp/ 下，則
#ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock即可

問題：
Starting MySQL..The server quit without updating PID file ([FAILED]/mysql/Server03.mylinux.com.pid).
解決：
修改/etc/my.cnf 中datadir,指向正確的mysql資料庫檔案目錄

問題：
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
解決：
建立一個連結或在mysql中加入-S參數，直接指出mysql.sock位置。
ln -s /usr/local/mysql/data/mysql.sock /tmp/mysql.sock
/usr/local/mysql/bin/mysql -u root -S /usr/local/mysql/data/mysql.sock

cmake 中文使用說明

http://www.blogjava.net/kelly859/archive/2012/09/04/387005.html

安裝 mysql
先安裝 cmake(mysql5.6.X)

注意小’-'必須有 這個是指定目錄安裝的
cmake -DCMAKE_INSTALL_PREFIX=/www/mysql
-DMYSQL_UNIX_ADDR=/www/mysql/mysql.sock
-DDEFAULT_CHARSET=utf8
-DDEFAULT_COLLATION=utf8_general_ci
-DWITH_MYISAM_STORAGE_ENGINE=1
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DWITH_MEMORY_STORAGE_ENGINE=1
-DWITH_READLINE=1
-DENABLED_LOCAL_INFILE=1
-DMYSQL_DATADIR=/www/mysql/data
-DMYSQL_USER=mysql 有的時候會出錯哦
-DMYSQL_TCP_PORT=3306

註：重新回合組態，需要刪除CMakeCache.txt檔案
rm -rf CMakeCache.txt
編譯
make && make install

許可權
chown -R mysql:mysql mysql
chmod -R 775 mysql

初始化
scripts/mysql_install_db –user=mysql –datadir=/data/mysqldb
設定檔
cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
vim /etc/my.conf
[mysqld]
basedir = /www/mysql
datadir = /www/mysql/data
port = 3306
# server_id = /www/mysql/data/65.pid
socket = /www/mysql/mysql.sock
user=mysql

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[client]
socket = /www/mysql/mysql.sock

複製mysql服務啟動指令碼及加入PATH路徑
cp support-files/mysql.server /etc/init.d/mysqld
vim /etc/profile
PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH
export PATH
source /etc/profile

啟動mysql服務並加入開機自啟動
service mysqld start
chkconfig –level 35 mysqld on

檢查mysql服務是否啟動
netstat -tulnp | grep 3306
mysql -u root -p
密碼為空白，如果能登陸上，則安裝成功。

修改MySQL使用者root的密碼
mysqladmin -u root password ’123456′

產考:““`
shell> groupadd mysql
shell> useradd -r -g mysql mysql
shell> cd /usr/local
shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz
shell> ln -s full-path-to-mysql-VERSION-OS mysql
shell> cd mysql
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> scripts/mysql_install_db –user=mysql
shell> chown -R root .
shell> chown -R mysql data
# Next command is optional
shell> cp support-files/my-medium.cnf /etc/my.cnf
shell> bin/mysqld_safe –user=mysql &
# Next command is optional
shell> cp support-files/mysql.server /etc/init.d/mysql.server
““““

scripts/mysql_install_db -user=mysql -datadir=/data/mysqldb

scripts/mysql_install_db –user=mysql –datadir=/data/mysqldb
安裝apache前
*首先卸載乾淨以前的 apache mysql php aprapr-util 等

yum install -y cups-php graphviz-php php-bcmath php-cli php-common php-dba
yum install -y php-devel php-embedded php-fpm php-gd php-imap php-intl
yum install -y php-ldap php-mbstring php-mysql php-odbc php-pdo php-pear
yum install -y php-pecl-apc php-pgsql php-process php-pspell php-recode
yum install -y php-snmp php-soap php-tidy php-xml php-xmlrpc
yum install -y php-zts rrdtool-php uuid-php
yum install -y php-enchant php-pecl-apc-devel php-pecl-memcache

安裝 apr apr-util unzip
a:解決apr not found問題>>>>>>

tar -zxf apr-1.4.5.tar.gz
cd apr-1.4.5
./configure –prefix=/usr/local/apr
make && make install

b:解決APR-util not found問題>>>>

tar -zxf apr-util-1.3.12.tar.gz
cd apr-util-1.3.12
./configure –prefix=/usr/local/apr-util -with-apr=/usr/local/apr/bin/apr-1-config
make && make install

c:解決pcre問題>>>>>>>>>

unzip -o pcre-8.10.zip
cd pcre-8.10
./configure –prefix=/usr/local/pcre
make && make install

apahce安裝

tar jvxf httpXXX
./configure –prefix=/www/apache #寫自己的目錄
–with-mysql=/usr/local/mysql
–with-apr=/usr/local/apr
–with-apr-util=/usr/local/apr-util/
–with-pcre=/usr/local/pcre
–enable-rewrite=shared
–enable-module=so
–enable-shared=max
make && make install

vim /usr/local/apache/conf/http.conf
開啟
ServerName IP:80
修改自己網站的路徑
#DocumentRoot “/usr/local/apache/htdocs”
#
添加 index.php
DirectoryIndex index.php index.html
找到 AddType後添加
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps
將所有“AllowOverride None”，改為：
AllowOverride All
找到 LoadModule 添加
LoadModule php5_module modules/libphp5.so

cp apache/bin/apachectl /etc/init.d/httpd

開啟 vi /etc/rc.d/init.d/httpd 添加(#!/bin/sh下面)
#chkconfig: 2345 10 90
#description: Activates/Deactivates Apache Web Server
chkconfig –add httpd
啟動
service httpd start
查看一下連接埠
netstat -an |grep 80
最後web瀏覽一下
如果不能訪問
方法一
停止防火牆
service iptables stop

安裝PHP

tar jvxf phpXXX

以下的配置都可以用:
1:
./configure
–prefix=/www/php
–with-mysql=/www/mysql
–with-apxs2=/www/apache/bin/apxs
–with-mcrypt
–enable-mbst

2:
./configure –prefix=/www/php –with-mysql=/www/mysql –with-apxs2=/www/apache/bin/apxs –with-mcrypt=/usr/local/libmcrypt –enable-mbst

3:
./configure
–prefix=/web/php
–bindir=/web/php/bin
–libdir=/web/php/lib
–includedir=/web/php/include
–libdir=/web/php/libexec
with-mysql=/usr/local/mysql
with-apxs2=/usr/local/apache/bin/apxs
with-mcrypt
enable-mbstr

4:
./configure
–prefix=/www/php
–with-config-file-path=/web/php/etc
–with-apxs2=/www/apache/bin/apxs
–with-mysql=/www/mysql
–with-libxml-dir=/usr/local/libxml2
–with-png-dir=/usr/local/libpng
–with-jpeg-dir=/usr/local/jpeg6
–with-freetype-dir=/usr/local/freetype
–with-gd=/usr/local/gd
–with-zlib-dir=/usr/local/zlib
–with-mcrypt=/usr/local/libmcrypt
–with-mysqli=/www/mysql/bin/mysql_config
–with-iconv-dir=/usr/local/libiconv
–with-mhash=/usr/local/mhash
–with-mysql-sock=/www/mysql/mysql.sock
–enable-soap
–enable-mbstring=all
–enable-sockets

# make && make install

以下是自動安裝:第三方擴充:
yum -y install yum-fastestmirror
yum -y install patch make flex bison tar
yum -y install libtool libtool-libs kernel-devel
yum -y install libjpeg libjpeg-devel libpng libpng-devel
yum -y install libtiff libtiff-devel gettext gettext-devel
yum -y install libxml2 libxml2-devel zlib-devel net-snmp
yum -y install file glib2 glib2-devel bzip2 diff* openldap-devel
yum -y install bzip2-devel ncurses ncurses-devel curl curl-devel e2fsprogs
yum -y install e2fsprogs-devel krb5 krb5-devel libidn libidn-devel
yum -y install openssl openssl-devel vim-minimal unzip
# 安裝PHP支援GD庫軟體包
yum -y install freetype freetype-devel png jpeg zlib gd php-gd*
# 安裝PHP 5.* 組件
yum -y install libiconv libevent mhash mcrypt
yum install ncurses-devel libxml2-devel bzip2-devel libcurl-devel curl-devel libjpeg-devel libpng-devel freetype-devel net-snmp-devel -y