openwrt php fpm,OPENWRT安装nginx+php+mysql

软件安装

1.安装php

opkg update

opkg install php5 php5-mod-gd php5-mod-session php5-mod-pdo php5-mod-pdo-mysql php5-mod-mysql php5-mod-mcrypt php5-mod-mbstring php5-fastcgi php5-cgi php5-mod-xml php5-mod-ctype php5-mod-curl php5-mod-exif php5-mod-ftp php5-mod-iconv php5-mod-json php5-mod-sockets php5-mod-sqlite3 php5-mod-tokenizer php5-mod-zip

2.安装mysql

opkg install mysql-server

3.安装nginx及其他

opkg install nginx spawn-fcgi zoneinfo-core zoneinfo-asia

opkg install shadow-groupadd shadow-useradd

groupadd www

useradd -g www www

chown -R www:www /mnt/sda1/web

4.配置

datadir                = /mnt/sda1/data/mysql/

tmpdir                = /mnt/sda1/data/tmp/

mkdir -p /mnt/sda1/data /mnt/sda1/data/mysql /mnt/sda1/data/tmp

/usr/bin/mysql_install_db --force

/etc/init.d/mysqld start

/usr/bin/mysqladmin -u root password 123456

mysql -u root -p

create database abcd

\g

show databases

\g

退出mysql

quit

修改/etc/nginx/nginx.conf

user www www;

worker_processes  1;

pid        /var/run/nginx.pid;

error_log  /var/log/nginx_error.log;

events {

use epoll;

worker_connections  1024;

}

http {

include mime.types;

default_type application/octet-stream;

sendfile on;

tcp_nopush on;

#keepalive_timeout 0;

keepalive_timeout 65;

gzip on;

access_log   off;

include       vhost.conf;

}

修改/etc/nginx/fastcgi_params，解决Nginx文件类型错误解析漏洞

if ($request_filename ~* (.*)\.php) {

set $php_url $1;

}

if (!-e $php_url.php) {

return 403;

}

fastcgi_param  QUERY_STRING       $query_string;

fastcgi_param  REQUEST_METHOD     $request_method;

fastcgi_param  CONTENT_TYPE       $content_type;

fastcgi_param  CONTENT_LENGTH     $content_length;

fastcgi_param  SCRIPT_NAME        $fastcgi_script_name;

fastcgi_param  REQUEST_URI        $request_uri;

fastcgi_param  DOCUMENT_URI       $document_uri;

fastcgi_param  DOCUMENT_ROOT      $document_root;

fastcgi_param  SERVER_PROTOCOL    $server_protocol;

fastcgi_param  GATEWAY_INTERFACE  CGI/1.1;

fastcgi_param  SERVER_SOFTWARE    nginx/$nginx_version;

fastcgi_param  REMOTE_ADDR        $remote_addr;

fastcgi_param  REMOTE_PORT        $remote_port;

fastcgi_param  SERVER_ADDR        $server_addr;

fastcgi_param  SERVER_PORT        $server_port;

fastcgi_param  SERVER_NAME        $server_name;

# PHP only, required if PHP was built with --enable-force-cgi-redirect

fastcgi_param  REDIRECT_STATUS    200;

添加/etc/nginx/vhost.conf

server {

listen       80;

server_name  localhost;

root  /mnt/sda1/web;

index  index.html index.htm index.php default.php;

error_page   500 502 503 504  /50x.html;

location = /50x.html {

root html;

}

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;

}

}

修改/etc/php.ini

short_open_tag = on

#doc_root = "/mnt/www"

extension=ctype.so

extension=curl.so

extension=gd.so

extension=mbstring.so

extension=mcrypt.so

extension=mysql.so

extension=pdo.so

extension=pdo_mysql.so

extension=session.so

extension=sockets.so

extension=tokenizer.so

extension=xml.so

[Date]

date.timezone = Asia/Shanghai

[MySQL]

mysql.default_socket = /var/run/mysqld.sock

启动spawn-fcgi(如需开机自动运行，可将命令添加到/etc/rc.local)

对于Nginx服务的开启有点麻烦。首先要开启fastcgi服务：

/usr/bin/spawn-fcgi -a 127.0.0.1 -p 9000 -C 2 -f /usr/bin/php-cgi

如果要开机启动，将上述指令放置到/etc/rc.local脚本之下

如果rc.local 中有exit 0 ，记得注释掉，不然就不会开始监听9000端口。

启动nginx

/etc/init.d/nginx enable

/etc/init.d/nginx star

亲测有效。

OK：Nginx+PHP+MySQL开发环境就成功移植到Openwrt平台上了。