openbsd mysql_openbsd+nginx+php+mysql

#export PKG_PATH=ftp://ftp.openbsd.org/pub/OpenBSD/4.8/packages/amd64/

#pkg_add -r nginx-0.7.67 mysql-server-5.1.48 php5-fastcgi-5.2.13p0 php5-gd-5.2.13p0-no_x11 php5-mysql-5.2.13p0 spawn-fcgi-1.6.3p0

#vi /etc/rc.local:

-----------------------------------------------------

# Start MySQL

if [ -x /usr/local/bin/mysqld_safe ] ; then

echo -n 'Starting MySQL...'

su -c mysql root -c '/usr/local/bin/mysqld_safe >/dev/null 2>&1 &'

echo "DONE"

fi

# Start php-fastcgi

if [ -x /usr/local/bin/spawn-fcgi ] ; then

echo -n 'Starting php-fastcgi...'

/usr/local/bin/spawn-fcgi -a 127.0.0.1 -p 9000 -C 6 -u www -f /usr/local/bin/php-fastcgi > /var/run/fcgi.pid

echo "DONE"

fi

# Start nginx

if [ -x /usr/local/sbin/nginx ] ; then

echo -n 'Starting nginx...'

/usr/local/sbin/nginx

echo "DONE"

fi

-----------------------------------------------------

#ln -s /var/www/conf/modules.sample/php5.conf /var/www/conf/modules/php5.conf

#ln -s /var/www/conf/php5.sample/gd.ini /var/www/conf/php5/gd.ini

#ln -fs /var/www/conf/php5.sample/mysql.ini /var/www/conf/php5/mysql.ini

#vi /etc/nginx/nginx.conf

--------------------------------------------------------

location / {

root   /var/nginx/html;

index  index.php index.html index.htm;

}

location ~ \.php$ {

root           html;

fastcgi_pass   127.0.0.1:9000;

fastcgi_index  index.php;

fastcgi_param  SCRIPT_FILENAME  /var/nginx/html$fastcgi_script_name;

include        fastcgi_params;

}

--------------------------------------------------------

#vi /etc/sysctl.conf

-----------------------------------------------------------

kern.maxfiles=65535

-----------------------------------------------------------

#vi /etc/login.conf

-----------------------------------------------------------

#

# MySQL

#

mysql:\

:openfiles-cur=1024:\

:openfiles-max=2048:\

:tc=daemon:

-----------------------------------------------------------

#cap_mkdb /etc/login.conf

#/usr/local/bin/mysql_install_db

#/usr/local/bin/mysqladmin -u root password 'yourpassword'