首页 > 代码库 > CentOS 6.8 LAMP 安装配置
CentOS 6.8 LAMP 安装配置
1.远程系统拒绝了连接:
需要关闭防火墙
/etc/rc.d/init.d/iptables stop
service iptables stop
chkconfig iptables off
setenforce 0
vi
/etc/sysconfig/selinux
SELINUX=disabled
#enforcing改为disabled
yum -y
install
gcc gcc-c++ autoconf libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc glibc-devel glib2 glib2-devel
bzip2
bzip2
-devel ncurses ncurses-devel curl curl-devel e2fsprogs e2fsprogs-devel krb5 krb5-devel libidn libidn-devel openssl openssl-devel openldap openldap-devel openldap-clients openldap-servers
make
libtool* git tree bison pcre-devel perl gd gd-devel
安装libiconv(支持编码转换为函数)
wget https://ftp.gnu.org/gnu/libiconv/libiconv-1.14.tar.gz
tar
xf libiconv-1.14.
tar
.gz
cd
libiconv-1.14/
.
/configure
--prefix=
/usr/local/libconv/
make
&&
make
install
tar xf libmcrypt-2.5.8.tar.gz
cd libmcrypt-2.5.8
./configure
make && make install
cd libltdl/
./configure --enable-ltdl-install #加载动态库
make && make install
tar
xf mhash-0.9.9.9.
tar
.bz2
cd
mhash-0.9.9.9
.
/configure
make
&&
make
install
vim
/etc/ld
.so.conf
/usr/local/lib/
ldconfig
cd
/usr/local/src
tar
zxvf mcrypt-2.6.8.
tar
.gz
cd
mcrypt-2.6.8/
export
LD_LIBRARY_PATH=
/usr/local/lib
:$LD_LIBRARY_PATH
#暂时生效
.
/configure
make
&&
make
install
tar
xf cmake-3.4.1.
tar
.gz
cd
cmake-3.4.1
.
/bootstrap
make
&&
make
install
新增mysql用户
1
2
|
groupadd -r mysql useradd -r -g mysql mysql |
新建MySQL所需目录
1
2
|
mkdir -p /usr/local/mysql mkdir -p /data/mysqldb |
编译安装
1
2
3
4
|
wget http://pkgs.fedoraproject.org/repo/pkgs/community-mysql/mysql-5.6.23.tar.gz/md5/60344f26eae136a267a0277407926e79/mysql-5.6.23.tar.gz
tar xf mysql-5.6.23. tar .gz cd mysql-5.6.23 cmake -DCMAKE_INSTALL_PREFIX= /usr/local/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1-DMYSQL_DATADIR= /data/mysqldb -DMYSQL_TCP_PORT=3306 -DENABLE_DOWNLOADS=1-DSYSCONFDIR= /etc -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_LIBWRAP=0 make && make install |
修改mysql目录权限
1
2
3
4
|
cd /usr/local/mysql chown -R mysql:mysql . cd /data/mysqldb chown -R mysql:mysql . |
初始化mysql数据库
1
2
|
cd /usr/local/mysql . /scripts/mysql_install_db --user=mysql --datadir= /data/mysqldb |
编译修改/etc/my.cnf (这里可能因为mysql 默认root用户也只有读和执行的权限,所以要chmod 644 my.conf)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
|
[mysql] # CLIENT # port = 3306 socket = /data/mysqldb/mysql .sock [mysqld] # GENERAL # user = mysql default-storage-engine = InnoDB socket = /data/mysqldb/mysql .sock pid- file = /data/mysqldb/mysql .pid # MyISAM # key-buffer-size = 32M myisam-recover = FORCE,BACKUP # SAFETY # max-allowed-packet = 16M max-connect-errors = 1000000 # DATA STORAGE # datadir = /data/mysqldb/ # BINARY LOGGING # log-bin = /data/mysqldb/mysql-bin expire-logs-days = 14 sync -binlog = 1 # REPLICATION # skip-slave-start = 1 relay-log = /data/mysqldb/relay-bin slave-net-timeout = 60 # CACHES AND LIMITS # tmp-table-size = 32M max-heap-table-size = 32M query-cache- type = 0 query-cache-size = 0 max-connections = 500 thread-cache-size = 50 open -files-limit = 65535 table-definition-cache = 4096 table- open -cache = 4096 # INNODB # innodb-flush-method = O_DIRECT innodb-log-files- in -group = 2 innodb-log- file -size = 64M innodb-flush-log-at-trx-commit = 1 innodb- file -per-table = 1 innodb-buffer-pool-size = 592M # LOGGING # log-error = /data/mysqldb/mysql-error .log log-queries-not-using-indexes = 1 slow-query-log = 1 slow-query-log- file = /data/mysqldb/mysql-slow .log |
同时,这个时候可能会出现报错:
在my.conf中加入
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
explicit_defaults_for_timestamp=true
复制MySQL启动文件及其命令加入PATH
1
2
3
4
5
|
cp support-files /mysql .server /etc/init .d /mysqld vim /etc/profile .d /mysql .sh PATH= /usr/local/mysql/bin : /usr/local/mysql/lib :$PATH export PATH source /etc/profile .d /mysql .sh |
启动MySQL并增加启动项
1
2
|
service mysqld start chkconfig mysqld on |
设置MySQL登录权限
1
2
3
4
|
drop user ‘‘ @localhost; drop user ‘‘ @ hostname ; update mysql.user set password=password( ‘*******‘ ); flush privileges; |
四、Nginx编译安装
新增nginx用户
1
2
|
groupadd -r nginx useradd -g nginx -r nginx |
创建所需要目录
1
|
mkdir -pv /var/tmp/nginx/client |
编译安装nginx
1
2
3
4
|
tar xf nginx-1.9.14. tar .gz cd nginx-1.9.14 . /configure --prefix= /usr/local/nginx --sbin-path= /usr/local/nginx/sbin/nginx --conf-path= /etc/nginx/nginx .conf --error-log-path= /var/log/nginx/error .log --http-log-path= /var/log/nginx/access .log --pid-path= /var/run/nginx/nginx .pid --lock-path= /var/lock/nginx .lock --user=nginx --group=nginx --with-http_ssl_module --with-http_flv_module --with-http_stub_status_module --with-http_gzip_static_module --http-client-body-temp-path= /var/tmp/nginx/client/ --http-proxy-temp-path= /var/tmp/nginx/proxy/ --http-fastcgi-temp-path= /var/tmp/nginx/fcgi/ --http-uwsgi-temp-path= /var/tmp/nginx/uwsgi --http-scgi-temp-path= /var/tmp/nginx/scgi --with-pcre make && make install |
编辑启动脚本
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
|
vim /etc/rc .d /init .d /nginx #!/bin/sh # # nginx - this script starts and stops the nginx daemon # # chkconfig: - 85 15 # description: Nginx is an HTTP(S) server, HTTP(S) reverse \ # proxy and IMAP/POP3 proxy server # processname: nginx # config: /etc/nginx/nginx.conf # config: /etc/sysconfig/nginx # pidfile: /var/run/nginx.pid # Source function library. . /etc/rc .d /init .d /functions # Source networking configuration. . /etc/sysconfig/network # Check that networking is up. [ "$NETWORKING" = "no" ] && exit 0 nginx= "/usr/local/nginx/sbin/nginx" prog=$( basename $nginx) NGINX_CONF_FILE= "/etc/nginx/nginx.conf" [ -f /etc/sysconfig/nginx ] && . /etc/sysconfig/nginx lockfile= /var/lock/subsys/nginx make_dirs() { # make required directories user=`nginx -V 2>&1 | grep "configure arguments:" | sed ‘s/[^*]*--user=\([^ ]*\).*/\1/g‘ -` options=`$nginx -V 2>&1 | grep ‘configure arguments:‘ ` for opt in $options; do if [ ` echo $opt | grep ‘.*-temp-path‘ ` ]; then value=http://www.mamicode.com/` echo $opt | cut -d "=" -f 2` if [ ! -d "$value" ]; then # echo "creating" $value mkdir -p $value && chown -R $user $value fi fi done } start() { [ -x $nginx ] || exit 5 [ -f $NGINX_CONF_FILE ] || exit 6 make_dirs echo -n $ "Starting $prog: " daemon $nginx -c $NGINX_CONF_FILE retval=$? echo [ $retval - eq 0 ] && touch $lockfile return $retval } stop() { echo -n $ "Stopping $prog: " killproc $prog -QUIT retval=$? echo [ $retval - eq 0 ] && rm -f $lockfile return $retval } restart() { configtest || return $? stop sleep 1 start } reload() { configtest || return $? echo -n $ "Reloading $prog: " killproc $nginx -HUP RETVAL=$? echo } force_reload() { restart } configtest() { $nginx -t -c $NGINX_CONF_FILE } rh_status() { status $prog } rh_status_q() { rh_status > /dev/null 2>&1 } case "$1" in start) rh_status_q && exit 0 $1 ;; stop) rh_status_q || exit 0 $1 ;; restart|configtest) $1 ;; reload) rh_status_q || exit 7 $1 ;; force-reload) force_reload ;; status) rh_status ;; condrestart|try-restart) rh_status_q || exit 0 ;; *) echo $ "Usage: $0 {start|stop|status|restart|condrestart|try-restart|reload|force-reload|configtest}" exit 2 esac |
设置开机启动并启动服务
1
2
3
4
|
chmod +x /etc/rc .d /init .d /nginx chkconfig --add nginx chkconfig nginx on service nginx start |
五、PHP编译安装
解决php安装的库依赖关系
1
2
3
4
5
|
cp -frp /usr/lib64/libjpeg .* /usr/lib cp -frp /usr/lib64/libpng * /usr/lib cp -frp /usr/lib64/libldap * /usr/lib/ echo /usr/local/mysql/lib >> /etc/ld .so.conf.d /mysql-x86_64 .conf ldconfig - v |
编译安装php
1
2
3
4
5
|
tar xf php-5.6.17. tar .gz cd php-5.6.17 . /configure --prefix= /usr/local/php --with-mysql= /usr/local/mysql --with-mysqli= /usr/local/mysql/bin/mysql_config --with-iconv- dir = /usr/local --with-openssl -- enable -mbstring --with-freetype- dir --with-jpeg- dir --with-png- dir --with-zlib --with-libxml- dir = /usr -- enable -xml --disable-rpath -- enable -bcmath -- enable -shmop -- enable -sysvsem -- enable -inline-optimization -- enable -mbregex -- enable -mbstring --with-gd -- enable -gd-native-ttf --with-mhash -- enable -pcntl -- enable -sockets --with-mcrypt --with-ldap --with-ldap-sasl--with-xmlrpc -- enable -zip -- enable -soap --with-bz2 --with-config- file -path= /etc -- enable -fpm --with-config- file -scan- dir = /etc/php .d -- enable -maintainer-zts make ZEND_EXTRA_LIBS= ‘-liconv‘ make install |
复制PHP配置文件
1
|
cp php.ini-production /etc/php .ini |
复制php-fpm配置文件
1
|
cp /usr/local/php/etc/php-fpm .conf.default /usr/local/php/etc/php-fpm .conf |
设置php-fpm启动脚本并开机启动
1
2
3
4
5
|
cp sapi /fpm/init .d.php-fpm /etc/rc .d /init .d /php-fpm chmod +x /etc/rc .d /init .d /php-fpm chkconfig --add php-fpm chkconfig php-fpm on service php-fpm start |
六、web功能基本实现
nginx,php功能整合
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
vim /etc/nginx/nginx .conf #location ~ \.php$ { # root html; # fastcgi_pass 127.0.0.1:9000; # fastcgi_index index.php; # fastcgi_param SCRIPT_FILENAME /scripts$fastcgi_script_name; # include fastcgi_params; #} #修改为 location ~ \.php$ { fastcgi_pass 127.0.0.1:9000; fastcgi_index index.php; fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; include fastcgi_params; } |
增加LNMP测试页面
1
2
3
4
5
6
7
8
9
10
|
vim /usr/local/nginx/html/test .php <?php $link = mysql_connect( ‘127.0.0.1‘ , ‘root‘ , ‘you_passwd‘ ); if ($link) echo "It‘s OK,Frank" ; else echo "Failed,Frank" ; mysql_close; phpinfo(); ?> |
nginx重载
1
|
service nginx reload |
访问 http://ip/test.php,LNMP测试成功。
httpd安装
安装apr
1
2
3
4
|
tar xf apr-1.5.2. tar .gz cd apr-1.5.2 . /configure --prefix= /usr/local/apr make && make install |
安装apr-util
1
2
3
4
|
tar xf apr-util-1.5.4. tar .gz cd apr-util-1.5.4 . /configure --prefix= /usr/local/apr-util --with-apr= /usr/local/apr make && make install |
安装httpd
1
2
3
|
cd httpd-2.4.18 . /configure --prefix= /usr/local/apache --sysconfdir= /etc/httpd -- enable -so -- enable -ssl -- enable -cgi -- enable -rewrite --with-zlib --with-pcre --with-apr= /usr/local/apr --with-apr-util= /usr/local/apr-util -- enable -modules=most -- enable -mpms-shared=all --with-mpm=event make && make install |
编译安装部分参数说明
1
2
3
4
5
6
7
8
9
10
11
12
|
-- enable -so #支持DSO动态装载模块 -- enable -ssl #要编译启用ssl模块(前提是需要安装openssl-devel) -- enable -cgi #启用CGI模块(默认就启用) -- enable -rewrite #URL重写(支持URL重写) --with-zlib #这是一个压缩库(专用于网络传输) --with-pcre #使用增强的perl正则表达式分析工具(使用这项需要安装pcre-devel,pcre:正则表达式分析器) --with-apr= /usr/local/apr #指明apr的目录(若apr在特殊路径下) --with-apr-util= /usr/local/apr-util/ #指明apr-util路径(若apr-util在特殊路径下 ) -- enable -mpms-shared=all #把所有的mpm模块都编译进来而且是共享模块 --with-mpm=work #默认使用的mpm模块 -- enable -modules=most(all) #还有很多其他模块,其他的动态可装载模块需要 |
测试httpd配置是否正常
1
|
/usr/local/apache/bin/apachectl -t |
设置httpd服务和开机启动项
1
2
3
4
5
6
|
cp /usr/local/apache/bin/apachectl /etc/rc .d /init .d /httpd vim /etc/rc .d /init .d /httpd #chkconfig: 35 61 61 #description:Apache chkconfig --add httpd chkconfig httpd on |
三、php编译安装
前期准备(补充安装,--with-xsl使用)
1
|
yum install libxslt-devel |
安装php
1
2
3
4
5
|
tar xf php-5.6.17. tar .gz cd php-5.6.17 . /configure --prefix= /usr/local/php --with-mysql= /usr/local/mysql --with-apxs2= /usr/local/apache/bin/apxs --with-mysqli= /usr/local/mysql/bin/mysql_config --with-iconv- dir = /usr/local --with-openssl -- enable -mbstring --with-freetype- dir --with-jpeg- dir --with-png- dir --with-zlib --with-libxml- dir = /usr -- enable -xml --disable-rpath -- enable -bcmath -- enable -shmop -- enable -sysvsem -disable-inline-optimization -- enable -mbregex -- enable -mbstring --with-gd -- enable -gd-native-ttf --with-mhash -- enable -pcntl -- enable -sockets --with-mcrypt --with-ldap --with-ldap-sasl --with-xmlrpc -- enable -zip -- enable -soap --with-bz2 --with-config- file -path= /etc --with-config- file -scan- dir = /etc/php .d -- enable -maintainer-zts --with-xmlrpc=shared --with-xsl make ZEND_EXTRA_LIBS= ‘-liconv‘ make install |
编译安装部分参数说明(很多加载项用途不明,从别处抄袭,前几位参数还是特别重要的,比如--with-apsx2,httpd和php整合用使用)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
--with-mysql= /usr/local/mysql #MySQL安装目录,对mysql的支持 --with-mysqli= /usr/local/mysql/bin/mysql_config #mysqli扩展技术不仅可以调用MySQL的存储过程、处理MySQL事务,而且还可以使访问数据库工作变得更加稳定。 --with-apxs2= /usr/local/apache/bin/apxs #整合apache,apxs功能是使用mod_so中的LoadModule指令,加载指定模块到 apache,要求 apache 要打开SO模块 --with-iconv- dir = /usr/local # 选项指令,用于PHP编译时指定iconv在系统里的路径,否则会扫描默认路径(与ZEND_EXTRA_LIBS=‘-liconv‘)。 -- enable -maintainer-zts #编译成zts模块,event,worker模式使用 --with-freetype- dir #打开对freetype字体库的支持 --with-jpeg- dir #打开对jpeg图片的支持 --with-png- dir #打开对png图片的支持 --with-zlib- dir #打开zlib库的支持,用于http压缩传输 --with-libxml- dir #打开libxml2库的支持 --disable-rpath #关闭额外的运行库文件 -- enable -bcmath #打开图片大小调整,用到zabbix监控的时候用到了这个模块 -- enable -sysvsem #这样就使得你的PHP系统可以处理相关的IPC函数了。 -- enable -inline-optimization #优化线程 --with-curl #打开curl浏览工具的支持 --with-curlwrappers #运用curl工具打开url流 -- enable -mbregex -- enable -fpm #支持PHP-fpm,早期版本需要补丁后才有这个参数,CGI方式安装的启动程序 -- enable -mbstring #多字节,字符串的支持 --with-mcrypt #mcrypt算法扩展 --with-mhash #mhash算法扩展 --with-gd #打开gd库的支持 -- enable -gd-native-ttf #支持TrueType字符串函数库 --with-openssl #openssl的支持,加密传输https时用到的 -- enable -pcntl #freeTDS需要用到的,可能是链接mssql才用到 -- enable -sockets #打开sockets支持 --with-xmlrpc #打开xml-rpc的c语言 -- enable -zip #打开对zip的支持 -- enable - ftp #打开ftp的支持 --with-bz2 #打开对bz2文件的支持 --without-iconv #关闭iconv函数,字符集间的转换 --with-ttf #打开freetype1.*的支持,可以不加了 --with-xsl #打开XSLT文件支持,扩展了libXML2库,需要libxslt软件 --with-gettext #打开gnu的gettext支持,编码库用到 --with-pear #打开pear命令的支持,PHP扩展用的 -- enable -calendar #打开日历扩展功能 -- enable -exif #图片的元数据支持 -- enable -magic-quotes #魔术引用的支持 --disable-debug #关闭调试模式 --with-mime-magic= /usr/share/file/magic .mime #魔术头文件位置 #CGI方式安装才用的参数 -- enable -fastCGI #支持fastcgi方式启动PHP -- enable -force-CGI-redirect #重定向方式启动PHP --with-ncurses #支持ncurses屏幕绘制以及基于文本终端的图形互动功能的动态库 --with-gmp #应该是支持一种规范 -- enable -dbase #建立DBA作为共享模块 --with-pcre- dir = /usr/local/bin/pcre-config #perl的正则库案安装位置 --disable-dmalloc --with-gdbm #dba的gdbm支持 -- enable -sigchild -- enable -sysvshm -- enable -zend-multibyte #支持zend的多字节 -- enable -wddx -- enable -soap |
提供php配置文件
1
|
cp php.ini-production /etc/php .ini |
修改httpd.conf,使其支持php,并且可以识别index.php结尾作为首页
1
2
3
|
AddType application /x-httpd-php .php AddType application /x-httpd-php-source .phps DirectoryIndex index.php index.html |
四、PHP扩展
libevent编译安装(libevent是一个基于事件触发的网络库,memcached底层也是使用libevent库。)
1
2
3
4
5
6
|
tar xf libevent-2.0.22-stable. tar .gz cd libevent-2.0.22-stable . /configure --prefix= /usr/local/libevent make && make install echo "/usr/local/libevent/lib" > /etc/ld .so.conf.d /libevent .conf ldconfig |
memcached编译安装
1
2
3
4
|
tar xf memcached-1.4.25. tar .gz cd memcached-1.4.25 . /configure --prefix= /usr/local/memcached --with-libevent= /usr/local/libevent/ make && make install |
编译memcached开机启动项(部分设置均在服务脚本中)
1
|
vim /etc/rc .d /init .d /memcached |
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
|
#!/bin/bash # # Init file for memcached # # chkconfig: - 86 14 # description: Distributed memory caching daemon # # processname: memcached # config: /etc/sysconfig/memcached . /etc/rc .d /init .d /functions ## Default variables PORT= "11211" USER= "root" MAXCONN= "1024" CACHESIZE= "64" OPTIONS= "" RETVAL=0 prog= "/usr/local/memcached/bin/memcached" desc= "Distributed memory caching" lockfile= "/var/lock/subsys/memcached" start() { echo -n $ "Starting $desc (memcached): " daemon $prog -d -p $PORT -u $USER -c $MAXCONN -m $CACHESIZE RETVAL=$? echo [ $RETVAL - eq 0 ] && touch $lockfile return $RETVAL } stop() { echo -n $ "Shutting down $desc (memcached): " killproc $prog RETVAL=$? echo [ $RETVAL - eq 0 ] && rm -f $lockfile return $RETVAL } restart() { stop start } reload() { echo -n $ "Reloading $desc ($prog): " killproc $prog -HUP RETVAL=$? echo return $RETVAL } case "$1" in start) start ;; stop) stop ;; restart) restart ;; condrestart) [ -e $lockfile ] && restart RETVAL=$? ;; reload) reload ;; status) status $prog RETVAL=$? ;; *) echo $ "Usage: $0 {start|stop|restart|condrestart|status}" RETVAL=1 esac exit $RETVAL |
1
2
3
|
chmod +x /etc/rc .d /init .d /memcached chkconfig --add memcached service memcached start |
memcached部分参数说明
1
2
3
4
5
6
7
8
9
10
11
12
|
-l <ip_addr>:指定进程监听的地址; -d: 以服务模式运行; -u <username>:以指定的用户身份运行memcached进程; -m <num>:用于缓存数据的最大内存空间,单位为MB,默认为64MB; -c <num>:最大支持的并发连接数,默认为1024; -p <num>: 指定监听的TCP端口,默认为11211; -U <num>:指定监听的UDP端口,默认为11211,0表示关闭UDP端口; -t <threads>:用于处理入站请求的最大线程数,仅在memcached编译时开启了支持线程才有效; -f <num>:设定Slab Allocator定义预先分配内存空间大小固定的块时使用的增长因子; -M:当内存空间不够使用时返回错误信息,而不是按LRU算法利用空间; -n: 指定最小的slab chunk大小;单位是字节; -S: 启用sasl进行用户认证; |
freetds编译安装(用于php连接mssql)
1
2
3
4
5
6
7
8
|
tar xf freetds-1.00.11. tar .gz cd freetds-1.00.11 . /configure --prefix= /usr/local/freetds --with-tdsver=7.3 -- enable -msdblib --with-gnu-ld -- enable -shared -- enable -static make && make install cd /usr/local/src/php-5 .6.17 /ext/mssql/ /usr/local/php/bin/phpize . /configure --with-php-config= /usr/local/php/bin/php-config --with-mssql= /usr/local/freetds/ make && make install |
--with-tdsver=7.3说明,具体说明参照:
http://www.freetds.org/userguide/choosingtdsprotocol.htm#TAB.PROTOCOL.BY.PRODUCT
安装php支持memcache扩展模块
1
2
3
4
5
|
tar zxvf memcache-2.2.7.tgz cd memcache-2.2.7 /usr/local/php/bin/phpize . /configure -- enable -memcache --with-php-config= /usr/local/php/bin/php-config --with-zib- dir make && make install |
修改php.ini,增加freetds和memcache功能
1
2
3
4
|
extension_dir = "/usr/local/php/lib/php/extensions/no-debug-zts-20131226/" extension=mssql.so mssql.charset= "GBK" extension=memcache.so |
重启httpd使生效
1
|
service httpd restart |
编写php测试页面
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
<?php $link = mysql_connect( ‘ip address‘ , ‘user‘ , ‘passwd‘ ); if ( $link ) echo "MySQL Success..." ; else echo "MySQL Failure..." ; mysql_close(); $conn =mssql_connect( ‘ip address‘ , ‘user‘ , ‘passwd‘ ); if ( $conn ) echo "MSSQL Sucess..." ; else echo "MSSQL Failure..." ; mssql_close(); phpinfo(); ?> |
测试可正常使用.
CentOS 6.8 LAMP 安装配置