freebsd php 编译 mysql sql2005_FreeBSD7.0编译安装nginx+php+mysql

环境

系统：FreeBSD7.0

软件：mysql-5.0.51a,nginx-0.6.30,lighttpd-1.4.19,php-5.2.6

所有软件都安装到/usr/local/vhost，如果需要请自行修改

一、下载源代码

cd /usr/ports/databases/mysql50-server/

make fetch

cd /usr/ports/www/nginx-devel/

make fetch

cd /usr/ports/lang/php5

make fetch

cd /usr/ports/www/lighttpd

make fetch

二、编译安装

MySQL

cd /usr/ports/distfiles/

tar -jxf mysql-5.0.51a.tar.gz

cd mysql-5.0.51a

./configure --prefix=/usr/local/vhost/mysql --with-charset=utf8 --with-extra-charsets=all --with-big-tables --with-pthread

make &&make install

Nginx

cd /usr/ports/devel/pcre

make install clean

cd /usr/ports/distfiles/

tar -jxf nginx-0.6.30.tar.gz

cd nginx-0.6.30

./configure --prefix=/usr/local/vhost/nginx --with-http_ssl_module --with-http_gzip_static_module --with-http_stub_status_module --with-http_sub_module

make &&make install

Lighttpd

(安装lighttpd是为了得到启动fastcgi进程)

cd /usr/ports/distfiles/

tar -jxf lighttpd-1.4.19.tar.bz2

cd lighttpd-1.4.19

./configure --prefix=/usr/local/vhost/lighttpd

Php

cd /usr/ports/textproc/libxml2

make install clean

cd /usr/ports/ftp/curl

make install clean

cd /usr/ports/graphics/jpeg

make install clean

cd /usr/ports/graphics/png

make install clean

cd /usr/ports/devel/gettext

make install clean

cd /usr/ports/distfiles/

tar -jxf php-5.2.6.tar.bz2

cd php-5.2.6

./configure --prefix=/usr/local/vhost/php --with-mysql=/usr/local/vhost/mysql -enable-fastcgi --enable-sockets --enable-ftp --enable-zip --enable-mbstring --enable-mbregex --enable-calendar --with-curl=/usr/local/clude --with-curlwrappers --disable-debug --enable-inline-optimization --with-zlib --with-gd --with-kerberos --with-gettext --enable-force-cgi-redirect --with-jpeg-dir=/usr/inlocal/clude --with-png-dir=/usr/local/include --with-bz2 --enable-pcntl --with-iconv

make && make install

cp php.ini-dist /usr/local/vhost/php/lib/php.ini

三、配置

MySQL

cd /usr/local/vhost/mysql

pw adduser mysql -d /dev/null -s /sbin/nologin

bin/mysql_install_db

cp share/mysql/mysql.server ./

chmod +x mysql.server

chown -R mysql ./

启动

引用：/usr/local/vhost/mysql/mysql.server start

配置nginx

cd /usr/local/vhost/nginx/

pw adduser webuser -d /dev/null -s /sbin/nologin

cp /usr/local/vhost/lighttpd/bin/spawn-fcgi ./sbin/

rm -rf /usr/local/vhost/lighttpd

vi sbin/php.sh

#!/bin/sh

/usr/local/vhost/nginx/sbin/spawn-fcgi -a 127.0.0.1 -p 9000 -C 8 -u webuser -f /usr/local/vhost/php/bin/php-cgi

引用：chmod +x sbin/php.sh

启动php for fast-cgi

引用：sbin/php.sh

vi conf/enable_php

location ~ /.php$ {

root html;

fastcgi_pass 127.0.0.1:9000;

fastcgi_index index.php;

fastcgi_param SCRIPT_FILENAME /usr/local/vhost/nginx/html$fastcgi_script_name;

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;

}

vi conf/nginx.conf

user webuser webuser;

worker_processes 1;

events {

worker_connections 4096;

use kqueue;

}

http {

include mime.types;

default_type application/octet-stream;

#log_format main '$remote_addr - $remote_user [$time_local] $request '

# '"$status" $body_bytes_sent "$http_referer" '

# '"$http_user_agent" "$http_x_forwarded_for"';

#access_log logs/access.log main;

client_header_timeout 3m;

client_body_timeout 3m;

send_timeout 3m;

client_max_body_size 5m;

client_header_buffer_size 1k;

large_client_header_buffers 4 4k;

gzip on;

gzip_min_length 1100;

gzip_buffers 4 8k;

gzip_types text/plain;

output_buffers 1 32k;

postpone_output 1460;

sendfile on;

tcp_nopush on;

tcp_nodelay on;

send_lowat 12000;

keepalive_timeout 75 20;

server {

listen 80;

server_name localhost;

location / {

root html;

index index.php index.html index.htm;

}

if (-d $request_filename){

rewrite ^/(.*)([^/])$ http://$host/$1$2/ permanent;

}

location /nginx_status {

stub_status on;

access_log off;

}

include enable_php;

error_page 500 502 503 504 /50x.html;

location = /50x.html {

root html;

}

}

}

测试配置文件

引用：sbin/nginx -t

2008/05/08 11:50:19 [info] 3336#0: the configuration file /usr/local/vhost/nginx/conf/nginx.conf syntax is ok

2008/05/08 11:50:19 [info] 3336#0: the configuration file /usr/local/vhost/nginx/conf/nginx.conf was tested successfully

vi html/phpinfo.php

phpinfo();

?>

启动测试

引用：/usr/local/vhost/nginx/sbin/nginx

在浏览器里输入

引用：http://192.168.29.128/phpinfo.php

安装配置phpMyadmin

cd /usr/ports/databases/phpmyadmin/

make fetch

cd /usr/ports/distfiles

tar -jxf phpMyAdmin-2.11.6-all-languages.tar.bz2

mv phpMyAdmin-2.11.6-all-languages /usr/local/vhost/nginx/html/dbadmin

此时MySQL的root没有密码，如果一切正常可以用

http://192.168.29.128/dbadmin/index.php来管理MySQL了