Raspberry Piに nginx + MySQL + PHP + Perl 構成の LEMP Webサーバを構築する方法

pi@raspberrypi:~ $ uname -a
Linux raspberrypi 4.9.41-v7+ #1023 SMP Tue Aug 8 16:00:15 BST 2017 armv7l GNU/Linux

pi@raspberrypi:~ $ lsb_release -a
No LSB modules are available.
Distributor ID: Raspbian
Description:    Raspbian GNU/Linux 9.1 (stretch)
Release:        9.1
Codename:       stretch

Raspberry Piに LLMP Lighttpd + MySQL + PHP + Perl 構成の Webサーバを構築する方法

Raspberry Piに LAMP構成の Apache MySQL PHP Perl phpMyAdminの Webサーバを構築する方法

Orange Pi PC 2を買ってみた、Allwinner H5 Cortex-A53 4core ARM64

#
sudo apt-get update

sudo apt-get -y install nginx

# http://{ラズパイの IPアドレス}/
# Welcome to nginx!

systemctl status nginx.service
# [q] to Quit

sudo apt install -y php-fpm

cat /etc/nginx/sites-available/default | grep index
cat /etc/nginx/sites-available/default | grep php

sudo nano /etc/nginx/sites-available/default

        # Add index.php to the list if you are using PHP
        index index.php index.html index.htm index.nginx-debian.html;


        # pass PHP scripts to FastCGI server
        #
        location ~ \.php$ {
                include snippets/fastcgi-php.conf;
        #
        #       # With php-fpm (or other unix sockets):
                fastcgi_pass unix:/var/run/php/php7.0-fpm.sock;
        #       # With php-cgi (or other tcp sockets):
        #       fastcgi_pass 127.0.0.1:9000;
        }

sudo sed -i -e "s/index index.html/index index.php index.html/g" /etc/nginx/sites-available/default

sudo sed -i -e "s/\#location ~ \\\\.php/location ~ \\\\.php/g" /etc/nginx/sites-available/default
sudo sed -i -e "s/\#\\s*include snippets\/fast/  include snippets\/fast/g" /etc/nginx/sites-available/default
sudo sed -i -e "s/\#\\s*fastcgi_pass unix/  fastcgi_pass unix/g" /etc/nginx/sites-available/default
sudo sed -i -e "s/:9000;$/:9000;\n        }/g" /etc/nginx/sites-available/default

sudo service nginx restart

# sudo nano /var/www/html/phpinfo.php
# phpinfo.php
echo "<?php phpinfo(); ?>">phpinfo.php
sudo cp phpinfo.php /var/www/html/

# http://{ラズパイの IPアドレス}/phpinfo.php

#========
# install spawn-fcgi fcgiwrap
sudo apt-get -y install spawn-fcgi fcgiwrap

# Edit /etc/nginx/sites-available/default file
sudo nano /etc/nginx/sites-available/default

        # Add index.php to the list if you are using PHP
        index index.php index.cgi index.html index.htm index.nginx-debian.html;

        # Perl FastCGI
        location ~ \.cgi$ {
            # gzip off;
            include /etc/nginx/fastcgi_params;
            fastcgi_pass unix:/var/run/fcgiwrap.socket;
            fastcgi_index index.cgi;
            # /var/www/cgi-bin/hoge.cgi
            fastcgi_param SCRIPT_FILENAME /var/www$fastcgi_script_name;

            # /var/www/html/cgi-bin/hoge.cgi
            # fastcgi_param SCRIPT_FILENAME /usr/lib$fastcgi_script_name;
            # /usr/lib/cgi-bin/hoge.cgi
            # fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
            # fastcgi_ignore_client_abort on;
            # 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;
        }

sudo sed -i -e "s/ index.html index.htm / index.cgi index.html index.htm /g" /etc/nginx/sites-available/default

sudo sed -i -e "s/^}$/\n  location ~ \\.cgi\$ {\n    include \/etc\/nginx\/fastcgi_params;\n    fastcgi_pass unix:\/var\/run\/fcgiwrap.socket;\n    fastcgi_index index.cgi;\n    fastcgi_param SCRIPT_FILENAME \/var\/www\$fastcgi_script_name;\n  }\n}\n/g" /etc/nginx/sites-available/default

#
cat /etc/init.d/fcgiwrap | grep FCGI_

# No need to Edit /etc/init.d/fcgiwrap
sudo nano /etc/init.d/fcgiwrap

# FCGI_APP Variables
FCGI_CHILDREN="1"
FCGI_SOCKET="/var/run/$NAME.socket"
FCGI_USER="www-data"
FCGI_GROUP="www-data"


# Restart cgi and nginx server
sudo /etc/init.d/fcgiwrap restart
sudo service nginx restart

ls -l /var/run/fcgiwrap.socket


# mkdir /var/www/cgi-bin/
sudo mkdir /var/www/cgi-bin/

# /var/www/cgi-bin/test_perl_cgi.cgi
echo '#!/usr/bin/perl'>test_perl_cgi.cgi
echo ''>>test_perl_cgi.cgi
echo 'print "Content-type:text/plain\n\n";'>>test_perl_cgi.cgi
echo 'print "Test Perl CGI";'>>test_perl_cgi.cgi
chmod +x test_perl_cgi.cgi
sudo cp test_perl_cgi.cgi /var/www/cgi-bin/
# http://{serverip}/cgi-bin/test_perl_cgi.cgi

# http://｛ラズパイの IPアドレス｝/cgi-bin/test_perl_cgi.cgi

# pdo_mysql PDO Driver for MySQL enabled
# Client API version mysqlnd 5.0.12-dev - 20150407
sudo apt-get -y install php-mysql
sudo service nginx restart

# MySQL MariaDB Server version: 10.1.23-MariaDB-9+deb9u1 Raspbian 9.0
sudo apt-get -y install mysql-server

# phpMyAdmin 4.6.6-4
sudo apt-get -y install phpmyadmin

ls -l -d /usr/share/phpmyadmin
# drwxr-xr-x 10 root root 4096 Aug 31 11:48 /usr/share/phpmyadmin

ls -l /var/www/html/
# drwxr-xr-x 2 root root 4096 Aug 29 15:44 cgi-bin
# -rw-r--r-- 1 root root 2890 Aug 30 13:57 hoge_pdo.php
# -rw-r--r-- 1 root root  612 Aug 29 15:24 index.nginx-debian.html
# -rw-r--r-- 1 root root   24 Aug 29 15:31 phpinfo.php

# Restart php7.0-fpm cgi
sudo service php7.0-fpm restart

# Restart nginx web server service
sudo systemctl stop nginx.service
sudo systemctl start nginx.service

# /var/www/html/phpmyadmin
# http://{serverip}/phpmyadmin
sudo ln -s /usr/share/phpmyadmin /var/www/html

# インストールの途中で質問のダイアログが表示されます。
# Web server to reconfigure automatically: - Apache2も lighthttpdも選択しない
# Configuring phpmyadmin - <Ok>
# Configure database - <Yes>
# MySQL application password for phpmyadmin: - パスワード（任意）
# Password confirmation: - 確認用パスワード（上で入力したの同じ）
# ※ phpMyAdminのユーザー名は phpmyadminです。
# http://{ラズパイの IPアドレス}/phpmyadmin/

ls -l /var/www/html/
# drwxr-xr-x 2 root root 4096 Aug 29 15:44 cgi-bin
# -rw-r--r-- 1 root root 2890 Aug 30 13:57 hoge_pdo.php
# -rw-r--r-- 1 root root  612 Aug 29 15:24 index.nginx-debian.html
# -rw-r--r-- 1 root root   24 Aug 29 15:31 phpinfo.php
# lrwxrwxrwx 1 root root   21 Aug 31 11:54 phpmyadmin -> /usr/share/phpmyadmin

$ cat /etc/php/7.0/fpm/php.ini | grep fix_
; cgi.fix_pathinfo provides *real* PATH_INFO/PATH_TRANSLATED support for CGI.  PHP's
;cgi.fix_pathinfo=1

# sudoで rootユーザーで mysqlにログインする
$ sudo mysql -u root
# Server version: 10.1.23-MariaDB-9+deb9u1 Raspbian 9.0

# hoge_userを作成する
MariaDB [(none)]> CREATE USER hoge_user;

# CREATE USER hoge_user IDENTIFIED BY [PASSWORD] 'hoge_pass';
# はエラーになります。

# hoge_userのパスワード hoge_passを設定する
MariaDB [(none)]> SET PASSWORD FOR 'hoge_user'=password('hoge_pass');

# 作成したユーザー情報を確認する
MariaDB [(none)]> SELECT user,host,password FROM mysql.user;
# +-----------+-----------+-------------------------------------------+
# | user      | host      | password                                  |
# +-----------+-----------+-------------------------------------------+
# | root      | localhost |                                           |
# | hoge_user | %         | *1234567890123456789012345678901234567890 |
# +-----------+-----------+-------------------------------------------+

# hoge_userにデータベース HOGE_DBに対する全ての権限を付与する
# ALL PRIVILEGES
MariaDB [(none)]> GRANT ALL PRIVILEGES ON `HOGE_DB`.* TO 'hoge_user'  IDENTIFIED BY 'hoge_pass';

# hoge_userにデータベース HOGE_DBを操作するだけの権限を付与する
# operate TABLE only
# MariaDB [(none)]> GRANT select,update,insert,delete ON `HOGE_DB`.* TO 'hoge_user' IDENTIFIED BY 'hoge_pass';

# hoge_userの権限を確認する
MariaDB [(none)]> SHOW GRANTS FOR 'hoge_user';

# hoge_userを削除する
# MariaDB [(none)]> drop user 'hoge_user'@'%';

<?php
$servername = "localhost";
$username = "hoge_user";
$password = "hoge_pass";

try {

    echo "==== PDO<br>";
    $pdo = new PDO("mysql:host=$servername", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    echo "PDO successfully<br><br>";

    echo "==== CREATE DATABASE<br>";
    $sql = "CREATE DATABASE IF NOT EXISTS HOGE_DB";
    $pdo->exec($sql);
    echo "CREATE DATABASE successfully<br><br>";

    echo "==== use DB<br>";
    $sql = "use HOGE_DB";
    $pdo->exec($sql);
    echo "use DATABASE successfully<br><br>";

    echo "==== CREATE TABLE<br>";
    $sql = "CREATE TABLE IF NOT EXISTS HOGE_TABLE (
                HOGE_ID int(11) AUTO_INCREMENT PRIMARY KEY,
                HOGE_TEXT varchar(32) NOT NULL)";
    $pdo->exec($sql);
    echo "CREATE TABLE successfully<br><br>";


    echo "==== SELECT<br>";
    $sql = "SELECT * FROM HOGE_TABLE";
    $stmt = $pdo->prepare($sql);
    $stmt->execute();
    while($result = $stmt->fetch(PDO::FETCH_ASSOC)){
        print($result['HOGE_ID']);
        print($result['HOGE_TEXT'].'<br>');
    }
    echo "SELECT successfully<br><br>";


    echo "==== DELETE<br>";
    $sql = "DELETE FROM HOGE_TABLE WHERE HOGE_ID = :id";
    $stmt = $pdo->prepare($sql);
    $stmt->bindValue(':id', 3, PDO::PARAM_INT);
    $stmt->execute();
    echo "DELETE successfully<br><br>";

    $sql = "DELETE FROM HOGE_TABLE WHERE HOGE_ID = :id";
    $stmt = $pdo->prepare($sql);
    $stmt->bindValue(':id', 5, PDO::PARAM_INT);
    $stmt->execute();
    echo "DELETE successfully<br><br>";

    echo "==== SELECT<br>";
    $sql = "SELECT * FROM HOGE_TABLE";
    $stmt = $pdo->prepare($sql);
    $stmt->execute();
    while($result = $stmt->fetch(PDO::FETCH_ASSOC)){
        print($result['HOGE_ID']);
        print($result['HOGE_TEXT'].'<br>');
    }
    echo "SELECT successfully<br><br>";

    echo "==== INSERT 1<br>";
    $sql = "INSERT INTO HOGE_TABLE (HOGE_ID, HOGE_TEXT) VALUES (:ID, :TEXT)";
    $stmt = $pdo -> prepare($sql);
    $id_val = 5;
    $hoge_text_val = "HOGE_VAL_5";
    $stmt->bindParam(':ID', $id_val, PDO::PARAM_INT);
    $stmt->bindParam(':TEXT', $hoge_text_val, PDO::PARAM_STR);
    $stmt->execute();
    echo "INSERT INTO 1 successfully<br><br>";

    echo "==== INSERT 2<br>";
    $stmt = $pdo -> prepare($sql);
    $stmt->bindValue(':ID', 3, PDO::PARAM_INT);
    $stmt->bindValue(':TEXT', "HOGE_PDO_3", PDO::PARAM_STR);
    $stmt->execute();
    echo "INSERT INTO 2 successfully<br><br>";


    echo "==== SELECT<br>";
    $sql = "SELECT * FROM HOGE_TABLE";
    $stmt = $pdo->prepare($sql);
    $stmt->execute();
    while($result = $stmt->fetch(PDO::FETCH_ASSOC)){
        print($result['HOGE_ID']);
        print($result['HOGE_TEXT'].'<br>');
    }
    echo "SELECT successfully<br><br>";

}
catch(PDOException $e)
{
    echo $sql . "<br>" . $e->getMessage();
}

$pdo = null;
?>

==== PDO
PDO successfully

==== CREATE DATABASE
CREATE DATABASE successfully

==== use DB
use DATABASE successfully

==== CREATE TABLE
CREATE TABLE successfully

==== SELECT
3HOGE_PDO_3
5HOGE_VAL_5
SELECT successfully

==== DELETE
DELETE successfully

DELETE successfully

==== SELECT
SELECT successfully

==== INSERT 1
INSERT INTO 1 successfully

==== INSERT 2
INSERT INTO 2 successfully

==== SELECT
3HOGE_PDO_3
5HOGE_VAL_5
SELECT successfully

Raspberry Piで Googleの Go言語 ＋ Gin Webフレームワークをインストールして Webアプリを作る

Raspberry Piで WebAPIモックサーバー JSON Serverを動かしてみるテスト

Raspberry Piに LAMP構成の Apache MySQL PHP Perl phpMyAdminの Webサーバを構築する方法

Raspberry Piに LLMP Lighttpd + MySQL + PHP + Perl 構成の Webサーバを構築する方法

Raspberry Piの Webサーバに PHP MySQL PDOを入れて PHP CGIから MySQLを操作する方法

Raspberry Pi 3 Model Bで CMSフレームワーク WordPressをセットアップする方法

Raspberry Pi3を Gitサーバとして設定する方法、Git単体と GitLabを使用する方法

Raspberry Pi3に Postfixメールサーバーを Gmailの SMTPをリレーとして立てる方法

Gitでリモートにプッシュした内容を完全に無かった事にする方法

Raspberry Piに Avahi Bonjourサービスを入れて、ホスト名で接続できる様にする方法

Raspberry Piや Jetson NANO等をネットワークに接続した場合の IPアドレスの便利ツール xfinder

Apache Webサーバを過剰なアクセスや DoS攻撃から守る modモジュールの紹介

Raspberry Pi Zero Wを海外通販の Pimoroni等での購入方法、購入できる通販ショップ一覧まとめ

Raspberry Pi 3で安定して使える相性の無い最適な microSDカードの種類のまとめ

Raspberry Pi 3 Model Bに専用カメラモジュール RaspiCamを接続する方法

Raspberry Pi 3の Linuxコンソール上で使用する各種コマンドまとめ

Raspberry Pi 3公式フォーラムの FAQの内容の日本語訳

ラズパイを意識した別物製品 Orange Pi Zeroを買ってみた、Allwinner H2+ Cortex-A7 4core

Orange Pi PC 2を買ってみた、Allwinner H5 Cortex-A53 4core ARM64

Espressif ESP8266 Arduino互換でスケッチが使える ESP-12Eモジュール基板

BangGood通販はドローン以外にも面白い商品がまだまだ有った（電子工作編）