Rg100a-aa-openwrt+nginx+php+mysql

RG100A-AA memory is 32m,flash to 16M, the clock is 300MHZ, small memory and low frequency, which determines the hardware conditions must be considered when setting up the server. The Lighttpd+php5+mysql standard tutorial says that the minimum memory is 64M, which clearly does not meet the existing hardware requirements. It is therefore necessary to look for a less expensive solution. You can refer to the http://www.right.com.cn/forum/thread-89216-1-1.html and http://tieba.baidu.com/p/2950214737 scenarios to try the configuration.

RG100A-AA equipped with Openwrt-dreambox 20120201 configuration nginx+php5+mysql steps:

1. Install related packages:

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 mysql-server nginx spawn-fcgi Zoneinfo-core Zoneinfo-asia Shadow-groupadd shadow-useradd

Problems encountered:

Unknown package ' Php5-mod-zip ', Unknown package ' Zoneinfo-core ', Unknown package ' Zoneinfo-asia ';

Collected Errors:

* Opkg_install_cmd:cannot Install package php5-mod-zip.

* Opkg_install_cmd:cannot Install package Zoneinfo-core.

* Opkg_install_cmd:cannot Install package Zoneinfo-asia.

This is because the source of the package has not been updated for a long time, you need to replace the package source and find a package source address that is the same as this processor model. In the/etc/opkg.conf

root@dreambox:/# vi/etc/opkg.conf

#src/GZ Packages Http://downloads.openwrt.org.cn/backfire/10.03.1/brcm63xx/packages

SRC/GZ Packages Http://downloads.openwrt.org/attitude_adjustment/12.09/brcm63xx/generic/packages

Dest Root/

Dest Ram/tmp

Lists_dir ext/var/opkg-lists

Option Overlay_root/overlay

The red font is the original package source address, the green font is the new source address, comment out the red configuration line, save and then re-execute opkg update;opkg install Php5-mod-zip zoneinfo-core zoneinfo-asia.

2. Establish Operation user

Mkdir/html

Groupadd www
Useradd-g www www
Chown-r www:www/html

3. Create a database folder

Mkdir-p/mnt/data/mnt/data/mysql/mnt/data/tmp

4. Create a default database

/usr/bin/mysql_install_db--force

Error: Installing MySQL system tables ...

/usr/bin/mysqld:can ' t resolve symbol ' Pthread_setschedprio '

Installation of system tables failed! Examine the logs in

/mnt/data/mysql/for more information.

This error is installed Mysql-server has a small bug, the introduction of this bug in Http://bugs.mysql.com/bug.php?id=4 2599 is described in detail.

Workaround:

(1) Uninstall mysql-server:opkg remove mysql-server;

(2) Replace the opkg source, cancel opkg.conf The first line of comments, comment on the second line.

(3) opkg update;opkg install Mysql-server

(4)/usr/bin/mysql_install_db--force

The following green font appears, indicating that the correct mysql-server has been installed.

Installing MySQL system tables ...

Ok

Filling Help Tables ...

Ok

(5) Starting mysqld:/etc/init.d/mysqld start

5, start MySQL, and create the root password, the password is set to 123, if really used, it is recommended to set the password of complex points:

/usr/bin/mysqladmin-u Root Password 123456

6. After connecting to MySQL, create the database:

MySQL > CREATE database discuz;

To view the currently available databases:

MySQL > show databases;

To view the database status:

MySQL > \s;

7, modify/etc/nginx/nginx.conf:

User www;

Worker_processes 1;

#error_log Logs/error.log;

#error_log Logs/error.log Notice;

#error_log Logs/error.log Info;

#pid Logs/nginx.pid;

Events {

Worker_connections 1024;

}

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;

Sendfile on;

#tcp_nopush on;

#keepalive_timeout 0;

Keepalive_timeout 65;

#gzip on;

server {

Listen 88;

server_name localhost;

#charset Koi8-r;

#access_log Logs/host.access.log Main;

Location/{

root HTML;

Index index.php index.html index.htm;

}

#error_page 404/404.html;

# REDIRECT Server error pages to the static page/50x.html

#

Error_page 502 503 504/50x.html;

Location =/50x.html {

root HTML;

}

# 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/html$fastcgi_script_name;

Include Fastcgi_params;

}

}

8, modification,/etc/php.ini

Short_open_tag = On

#doc_root = "/html"

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

}

9, start the spawn-fcgi (if you need to run automatically, you can add commands to/etc/rc.local)

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

10. Start Nginx

/etc/init.d/nginx start

11. Build PHP test file in/html directory:

#cd/html

#touch test.php

#chown www:www test.php

#vi test.php

Phpinfo ();

?>

You can see the configuration information of PHP by typing 192.168.1.11:88/test.php on the browser.

12, can download ya black probe to/html directory, ya black probe php file named tz.php, in the browser input 192.168.1.11:88/tz.php can see the configuration details of the Web server.

13. Establishment of DISCUZ Forum

