General guidance on setting up web server / php / mysql [LINK]

Hi,

I've been working on getting a live server working on my Raspi and have been using this page that I have found.

http://www.lowendbox.com/blog/.....ink-1-vps/

It was written long before the rise of the Pi so is for guidance only, but so far has been very good at helping me get this up and running.

nginx and php5-fpm are a nice combo for this. It is often used in production by people I know.

I threw this together to show how to do a quick and nasty php and sql for education purposed or quick hacks. You would never do this in production. I have cut some corners to keep things brief.

You will need to wait until the Foundation is supplying Debian Wheezy for your Pi or build PHP5.4 yourself to get the builtin web server.

Quick RAMP

Here are some quick notes on setting up MySQL, nginx and PHP on the R-Pi.
This assumes you are at a command prompt logged in as root.

Code: Select all

>ifconfig

make a note of the IP address

Code: Select all

>aptitude install mysql-server mysql-client

when prompted enter the root password

Code: Select all

>aptitude install nginx

Code: Select all

>aptitude install php5-cgi php5-mysql php5-curl php5-gd php5-idn php-pear php5-imagick php5-imap php5-mcrypt php5-memcache php5-mhash php5-ming php5-pspell php5-recode php5-snmp php5-sqlite php5-tidy php5-xmlrpc php5-xsl

Code: Select all

>vi /etc/nginx/sites-available/default

here is an example config file to get you started..

Code: Select all

server {
        listen   80; ## listen for ipv4
        server_name  localhost;
        access_log  /var/log/nginx/localhost.access.log;

        location / {
                root   /var/www;
                index  index.php index.html index.htm;
        }

        ## Images and static content is treated different
        location ~* ^.+.(jpg|jpeg|gif|css|png|js|ico|xml)$ {
                access_log        off;
                expires           30d;
                root /var/www;
        }

        ## Parse all .php file in the /var/www directory
        location ~ .php$ {
                fastcgi_split_path_info ^(.+\.php)(.*)$;
                fastcgi_pass   backend;
                fastcgi_index  index.php;
                fastcgi_param  SCRIPT_FILENAME  /var/www$fastcgi_script_name;
                include fastcgi_params;
                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_intercept_errors        on;
                fastcgi_ignore_client_abort     off;
                fastcgi_connect_timeout 60;
                fastcgi_send_timeout 180;
                fastcgi_read_timeout 180;
                fastcgi_buffer_size 128k;
                fastcgi_buffers 4 256k;
                fastcgi_busy_buffers_size 256k;
                fastcgi_temp_file_write_size 256k;
        }

        ## Disable viewing .htaccess & .htpassword
        location ~ /\.ht {
                deny  all;
        }
}
upstream backend {
        server 127.0.0.1:9000;
}

Code: Select all

>echo "deb http://ftp.uk.debian.org/debian wheezy main" >> /etc/apt/sources.list

Code: Select all

>apt-get update

Code: Select all

>apt-get install php5-cli php5-common php5-suhosin

Code: Select all

>apt-get install php5-fpm php5-cgi

Code: Select all

>vi /etc/php5/fpm/pool.d/www.conf

change the line that sets listen...
from:

Code: Select all

listen = /var/run/php5-fpm.sock

to:

Code: Select all

listen = 127.0.0.1:9000

Code: Select all

>mkdir /var/www

Code: Select all

>groupadd www-data

Code: Select all

>/etc/init.d/nginx restart

Code: Select all

>/etc/init.d/php5-fpm restart

Code: Select all

>echo "<?php phpinfo(); ?>" >> /var/www/test.php

to test use a browser and go to http://[that IP you made a note of at the beginning]/test.php

@Spurious, nice guide!

Found that a root /var/www; line in the location ~ .php$ { section was missing.

Got FastCGI sent in stderr: "Primary script unknown" while reading response header from upstream errors.

With the root line added it works!

howdy!
big thanx for the many lines put together!
so far almost every stuff went up without shouting for anything. Only the suhosin patches were not found.


however success is still partial. With a localhost browser test it was able to display the htmls i've put into the www dir. but with phps it just bare says: file not found in the browser. its exactly next to the htmls. i pi chowned,755chmodded, still no luck

any idea what can be the reason/ how i could troubleshoot this?