php7 mysql nginx_ubuntu下mysql5.7+php7+nginx环境搭建

1 安装1.8.0版nginx

最新的稳定版本是1.8.0，官方网站推荐如下方法安装。(如果用ubuntu的源，安装得到的版本是1.4.6)

1.1 下载并添加nginx_signing.keywget http://nginx.org/keys/nginx_signing.key

sudo apt-key add nginx_signing.key

1.2 添加官方源sudo vim /etc/apt/sources.list

在末尾加上：deb http://nginx.org/packages/ubuntu/ trusty nginx

deb-src http://nginx.org/packages/ubuntu/ trusty nginx

然后更新源sudo apt-get update

1.3 更新nginx

因为之前安装过ubuntu的源的nginx1.4.6，所以用upgrade。sudo apt-get upgrade nginx

2 编译PHP7.0.0

参考文章How to install PHP 7…

2.1 下载wget http://cn2.php.net/distributions/php-7.0.0.tar.bz2

2.2 安装编译依赖的库sudo apt-get install libfcgi-dev libfcgi0ldbl libmcrypt-dev libssl-dev libc-client2007e libc-client2007e-dev libxml2-dev libbz2-dev libcurl4-openssl-dev libjpeg-dev libpng12-dev libfreetype6-dev libkrb5-dev libpq-dev libxml2-dev libxslt1-dev

2.3 解决configure错误

解决configure错误：Cannot find imap library (libc-client.a). Please check your c-client installation.sudo ln -s /usr/lib/libc-client.a /usr/lib/x86_64-linux-gnu/libc-client.a

2.4 configure & make./configure --prefix=/opt/php-7.0.0 --with-pdo-pgsql --with-zlib-dir --with-freetype-dir --enable-mbstring --with-libxml-dir=/usr --enable-soap --enable-calendar --with-curl --with-mcrypt --with-zlib --with-gd --with-pgsql --disable-rpath --enable-inline-optimization --with-bz2 --with-zlib --enable-sockets --enable-sysvsem --enable-sysvshm --enable-pcntl --enable-mbregex --enable-exif --enable-bcmath --with-mhash --enable-zip --with-pcre-regex --with-mysqli --with-pdo-mysql --with-mysqli --with-jpeg-dir=/usr --with-png-dir=/usr --enable-gd-native-ttf --with-openssl --with-fpm-user=www-data --with-fpm-group=www-data --with-libdir=/lib/x86_64-linux-gnu --enable-ftp --with-imap --with-imap-ssl --with-kerberos --with-gettext --with-xmlrpc --with-xsl --enable-opcache --enable-fpmmake

sudo make install

fengyh@vfyh-lab:~/tools/php-7.0.0$ sudo make install

[sudo] password for fengyh:

exit 0; -t /home/fengyh/tools/php-7.0.0/ext/json/php_json_scanner_defs.h --no-generation-date -bci -o /home/fengyh/tools/php-7.0.0/ext/json/json_scanner.c /home/fengyh/tools/php-7.0.0/ext/json/json_scanner.re

Installing shared extensions:     /opt/php-7.0.0/lib/php/extensions/no-debug-non-zts-20151012/

Installing PHP CLI binary:        /opt/php-7.0.0/bin/

Installing PHP CLI man page:      /opt/php-7.0.0/php/man/man1/

Installing PHP FPM binary:        /opt/php-7.0.0/sbin/

Installing PHP FPM config:        /opt/php-7.0.0/etc/

Installing PHP FPM man page:      /opt/php-7.0.0/php/man/man8/

Installing PHP FPM status page:      /opt/php-7.0.0/php/php/fpm/

Installing phpdbg binary:         /opt/php-7.0.0/bin/

Installing phpdbg man page:       /opt/php-7.0.0/php/man/man1/

Installing PHP CGI binary:        /opt/php-7.0.0/bin/

Installing PHP CGI man page:      /opt/php-7.0.0/php/man/man1/

Installing build environment:     /opt/php-7.0.0/lib/php/build/

Installing header files:          /opt/php-7.0.0/include/php/

Installing helper programs:       /opt/php-7.0.0/bin/

program: phpize

program: php-config

Installing man pages:             /opt/php-7.0.0/php/man/man1/

page: phpize.1

page: php-config.1

Installing PEAR environment:      /opt/php-7.0.0/lib/php/

--2015-11-22 17:27:17--  https://pear.php.net/install-pear-nozlib.phar

Resolving pear.php.net (pear.php.net)... 5.77.39.20

Connecting to pear.php.net (pear.php.net)|5.77.39.20|:443... connected.

HTTP request sent, awaiting response... 200 OK

Length: 3579275 (3.4M) [text/plain]

Saving to: ‘pear/install-pear-nozlib.phar’

100%[=================================================>] 3,579,275   10.4KB/s   in 8m 58s

2015-11-22 17:36:20 (6.50 KB/s) - ‘pear/install-pear-nozlib.phar’ saved [3579275/3579275]

[PEAR] Archive_Tar    - installed: 1.4.0

[PEAR] Console_Getopt - installed: 1.4.1

[PEAR] Structures_Graph- installed: 1.1.1

[PEAR] XML_Util       - installed: 1.3.0

[PEAR] PEAR           - installed: 1.10.1

Wrote PEAR system config file at: /opt/php-7.0.0/etc/pear.conf

You may want to add: /opt/php-7.0.0/lib/php to your php.ini include_path

/home/fengyh/tools/php-7.0.0/build/shtool install -c ext/phar/phar.phar /opt/php-7.0.0/bin

ln -s -f phar.phar /opt/php-7.0.0/bin/phar

Installing PDO headers:          /opt/php-7.0.0/include/php/ext/pdo/

2.5 拷贝php.ini和php-fpm.conf

拷贝php.ini和php-fpm.conf到正确的目录。编译后，cd到源码跟目录，然后sudo cp php.ini-production /opt/php7.0.0/lib/php.ini

cd /opt/php-7.0.0/etc，然后sudo cp php-fpm.conf.default php-fpm.conf

cd /opt/php-7.0.0/etc/php-fpm.d，然后sudo cp www.conf.default www.conf

3 拷贝PHP7.0.0到云端使用

本地同样的系统，安装的目录是/opt/php7.0.0，打包拷贝到云端同样的目录

4 mysql更新

按照mysql官网的指南A Quick Guide to Using the MySQL APT Repository ，卸载原来的旧版本的mysql，安装最新的5.7。- 安装的时候配置mysql版本并apply，或者事后使用sudo dpkg-reconfigure mysql-apt-config配置发现5.7.9还有问题

mysql.user缺字段，导致grant命令报错。  mysqldump也报错。  text字段长度不够，同样的长度在mysql5.5没有问题

由于重新安装5.6会有问题，启动不了Mysql5.6。所以重新恢复服务器快照到干净实例。

4.1 下载和安装MySQL APT Repositorywget http://dev.mysql.com/get/mysql-apt-config_0.5.3-1_all.debsudo dpkg -i mysql-apt-config_0.5.3-1_all.deb

4.2 确认版本，或者更改版本：sudo dpkg-reconfigure mysql-apt-config

4.3 更新源并安装mysql-serversudo apt-get updatesudo apt-get install mysql-server

4.4 重启系统

发现刚安装完毕mysql服务器启动失败, 需要重新启动。

5 配置nginx+php7+mysqlphp-fpm.conf的pidsudo vim /opt/php-7.0.0/etc/php-fpm.conf

去掉语句pid = run/php-fpm.pid前的分号注释。[global]; Pid file; Note: the default prefix is /opt/php-7.0.0/var; Default Value: nonepid = run/php-fpm.pidwww.conf中的listen端口，默认9000，可以修改listen = 127.0.0.1:9000写service启动php-fpm的脚本/etc/init.d/php-7.0.0-fpm#! /bin/sh

### BEGIN INIT INFO

# Provides:          php-7.0.0-fpm

# Required-Start:    $all

# Required-Stop:     $all

# Default-Start:     2 3 4 5

# Default-Stop:      0 1 6

# Short-Description: starts php-7.0.0-fpm

# Description:       starts the PHP FastCGI Process Manager daemon

### END INIT INFO

php_fpm_BIN=/opt/php-7.0.0/sbin/php-fpm

php_fpm_CONF=/opt/php-7.0.0/etc/php-fpm.conf

php_fpm_PID=/opt/php-7.0.0/var/run/php-fpm.pid

php_opts="--fpm-config $php_fpm_CONF"

wait_for_pid () {

try=0

while test $try -lt 35 ; do

case "$1" in

'created')

if [ -f "$2" ] ; then

try=''

break

fi

;;

'removed')

if [ ! -f "$2" ] ; then

try=''

break

fi

;;

esac

echo -n .

try=`expr $try + 1`

sleep 1

done

}

case "$1" in

start)

echo -n "Starting php-fpm "

$php_fpm_BIN $php_opts

if [ "$?" != 0 ] ; then

echo " failed"

exit 1

fi

wait_for_pid created $php_fpm_PID

if [ -n "$try" ] ; then

echo " failed"

exit 1

else

echo " done"

fi

;;

stop)

echo -n "Gracefully shutting down php-fpm "

if [ ! -r $php_fpm_PID ] ; then

echo "warning, no pid file found - php-fpm is not running ?"

exit 1

fi

kill -QUIT `cat $php_fpm_PID`

wait_for_pid removed $php_fpm_PID

if [ -n "$try" ] ; then

echo " failed. Use force-exit"

exit 1

else

echo " done"

echo " done"

fi

;;

force-quit)

echo -n "Terminating php-fpm "

if [ ! -r $php_fpm_PID ] ; then

echo "warning, no pid file found - php-fpm is not running ?"

exit 1

fi

kill -TERM `cat $php_fpm_PID`

wait_for_pid removed $php_fpm_PID

if [ -n "$try" ] ; then

echo " failed"

exit 1

else

echo " done"

fi

;;

restart)

$0 stop

$0 start

;;

reload)

echo -n "Reload service php-fpm "

if [ ! -r $php_fpm_PID ] ; then

echo "warning, no pid file found - php-fpm is not running ?"

exit 1

fi

kill -USR2 `cat $php_fpm_PID`

echo " done"

;;

*)

echo "Usage: $0 {start|stop|force-quit|restart|reload}"

exit 1

;;

esac

5.1 update-rc.d使脚本生效$ sudo chmod 755 /etc/init.d/php-7.0.0-fpm

$ sudo update-rc.d php-7.0.0-fpm defaults

Adding system startup for /etc/init.d/php-7.0.0-fpm ...

/etc/rc0.d/K20php-7.0.0-fpm -> ../init.d/php-7.0.0-fpm

/etc/rc1.d/K20php-7.0.0-fpm -> ../init.d/php-7.0.0-fpm

/etc/rc6.d/K20php-7.0.0-fpm -> ../init.d/php-7.0.0-fpm

/etc/rc2.d/S20php-7.0.0-fpm -> ../init.d/php-7.0.0-fpm

/etc/rc3.d/S20php-7.0.0-fpm -> ../init.d/php-7.0.0-fpm

/etc/rc4.d/S20php-7.0.0-fpm -> ../init.d/php-7.0.0-fpm

/etc/rc5.d/S20php-7.0.0-fpm -> ../init.d/php-7.0.0-fpm

$ sudo service php-7.0.0-fpm start

5.2 配置虚拟站点

配置虚拟站点www.geiliedu.com：* cd /etc/nginx/conf.d* cp default.conf www.geiliedu.com.conf* 然后将www.geiliedu.com.conf配置成如下的样子server {

listen       80;

server_name  www.geiliedu.com;

charset utf-8;

access_log  /var/log/nginx/log/www.geiliedu.com.access.log  main;

location / {

root   /home/fengyh/web/geiliedu/frontend/web;

index  index.php index.html index.htm;

if (!-e $request_filename){

rewrite ^/(.*) /index.php last;

}

}

error_page  404              /home/fengyh/web/geiliedu/404.html;

# redirect server error pages to the static page /50x.html

#

error_page   500 502 503 504  /home/fengyh/web/geiliedu/50x.html;

location = /50x.html {

root   /home/fengyh/web/geiliedu;

}

# proxy the PHP scripts to Apache listening on 127.0.0.1:80

#

#location ~ \.php$ {

#    proxy_pass   http://127.0.0.1;

#}

# pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000

#

location ~ \.php$ {

root           html;

fastcgi_pass   127.0.0.1:9000;

fastcgi_index  index.php;

fastcgi_param  SCRIPT_FILENAME  /home/fengyh/web/geiliedu/frontend/web$fastcgi_script_name;

include        fastcgi_params;

}

# deny access to .htaccess files, if Apache's document root

# concurs with nginx's one

#

#location ~ /\.ht {

#    deny  all;

#}

}配置php.ini，指出pdo.mysql的socket位置pdo_mysql.default_socket=/var/run/mysqld/mysqld.sock

6 部署www.geiliedu.cominit，选production

mysql -u root -p，然后创建数据库geiliedu_docs

grant all privileges on geiliedu_docs.*to ‘geiliedu_docs’@’localhost’ identified by ‘…密码…’;

发现上述语句在5.7中有问题，需要在mysql.user表中添加这个字段：alter table user add `password_expired` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N';修改common/config/main-local.php的数据库配置

migrations

./yii migrate - yii2模板自动的migrations

./yii migrate --migrationPath=@fengyh/mdmgr/migrations - yii2-mdmgr的migrations

7 在php5.6以上版本swiftmailer的问题

由于php5.6、php7对完全有所加强，所以导致一些库出‘Bug’：stream_socket_enable_crypto(): SSL operation failed with code 1. OpenSSL Error messages: error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed

以下解决方法下策，添加红框内的语句。有替代方案还是要尽量改进：