Raspberry Pi４ WordPress構築

sudo raspi-config

sudo apt update
sudo apt upgrade
sudo reboot

sudo apt install apache2

pi@raspberrypi:~ $ apache2 -v
Server version: Apache/2.4.59 (Debian)
Server built:   2024-04-05T12:02:26
pi@raspberrypi:~ $

sudo apt install php

pi@raspberrypi:~ $ php -v
PHP 8.2.18 (cli) (built: Apr 11 2024 22:07:45) (NTS)
right (c) The PHP Group
Zend Engine v4.2.18, Copyright (c) Zend Technologies
    with Zend OPcache v8.2.18, Copyright (c), by Zend Technologies

sudo apt-get -y install php8.2-curl php8.2-mbstring php8.2-mysql php8.2-imagick php8.2-xml php8.2-zip php8.2-intl

sudo nano /etc/php/8.2/apache2/php.ini

mbstring.language = Japanese　コメントアウト解除
memory_limit = 128M　今回初めから128Mでした
post_max_size = 50M　　変更
upload_max_filesize = 50M　　変更

sudo apt-get install php8.2-fpm

～略
NOTICE: Not enabling PHP 8.2 FPM by default.
NOTICE: To enable PHP 8.2 FPM in Apache2 do:
NOTICE: a2enmod proxy_fcgi setenvif
NOTICE: a2enconf php8.2-fpm
NOTICE: You are seeing this message because you have apache2 package installed.
pi@raspberrypi:~ $

sudo systemctl restart apache2

$ sudo nano /var/www/html/test.php

<?php
        phpinfo();
?>

sudo a2enmod rewrite

sudo systemctl restart apache2

apache2ctl -t -D DUMP_MODULES | grep rewrite
有効化されていれば、rewrite_module (shared)と表示されます。

pi@raspberrypi:~ $ sudo vi /etc/apache2/apache2.conf
<Directory /var/www/>
        Options FollowSymLinks  <-- 「Indexes」を削除
        AllowOverride All  <-- 「All」に修正
        Require all granted
</Directory>

sudo apt update
sudo apt install -y mariadb-server

pi@raspberrypi:~ $ sudo mysql -u root -p
Enter password:　　<-- [Enter]を押します
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 32
Server version: 10.11.6-MariaDB-0+deb12u1 Debian 12
right (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>

$sudo mysql_secure_installation

Enter current password for root (enter for none):  <--何も押さずにEnter
Switch to unix_socket authentication [Y/n]:        <--n
Change the root password? [Y/n]:                   <--y
New password:                                      <--MariaDBのrootユーザー用パスワードを新規作成
Re-enter new password:                             <--同じパスワードを入力
Remove anonymous users? [Y/n]:                     <--y
Disallow root login remotely? [Y/n]:               <--n
Remove test database and access to it? [Y/n]:      <--y
Reload privilege tables now? [Y/n]:                <--y

pi@raspberrypi:~ $ mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 43
Server version: 10.11.6-MariaDB-0+deb12u1 Debian 12
right (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
MariaDB [(none)]> Ctrl-C -- exit!
Aborted
pi@raspberrypi:~ $

pi@raspberrypi:~ $ mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 44
Server version: 10.11.6-MariaDB-0+deb12u1 Debian 12
right (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> grant all privileges on *.* to root@"%" identified by  'password' with grant option;
Query OK, 0 rows affected (0.007 sec)
MariaDB [(none)]>

sudo systemctl restart mysql

pi@raspberrypi:~ $ wget https://ja.wordpress.org/latest-ja.tar.gz
--2024-06-25 21:45:21--  https://ja.wordpress.org/latest-ja.tar.gz
ja.wordpress.org (ja.wordpress.org) をDNSに問いあわせています... 198.143.164.252
ja.wordpress.org (ja.wordpress.org)|198.143.164.252|:443 に接続しています... 接続しました。
HTTP による接続要求を送信しました、応答を待っています... 200 OK
長さ: 25846701 (25M) [application/octet-stream]
`latest-ja.tar.gz' に保存中
latest-ja.tar.gz          100%[=====================================>]  24.65M  4.81MB/s 時間 5.8s
2024-06-25 21:45:28 (4.23 MB/s) - `latest-ja.tar.gz' へ保存完了 [25846701/25846701]
pi@raspberrypi:~ $

tar -xzvf latest-ja.tar.gz

pi@raspberrypi:~ $ ls -l
合計 25284
drwxr-xr-x 2 pi pi     4096  3月 16 00:05 Bookshelf
drwxr-xr-x 2 pi pi     4096  3月 16 00:12 Desktop
drwxr-xr-x 2 pi pi     4096  3月 16 00:12 Documents
drwxr-xr-x 2 pi pi     4096  3月 16 00:12 Downloads
drwxr-xr-x 2 pi pi     4096  3月 16 00:12 Music
drwxr-xr-x 2 pi pi     4096  3月 16 00:12 Pictures
drwxr-xr-x 2 pi pi     4096  3月 16 00:12 Public
drwxr-xr-x 2 pi pi     4096  3月 16 00:12 Templates
drwxr-xr-x 2 pi pi     4096  3月 16 00:12 Videos
-rw-r--r-- 1 pi pi 25846701  6月 25 05:16 latest-ja.tar.gz
drwxr-xr-x 5 pi pi     4096  6月 25 05:15 wordpress

mysql -u root -p

 CREATE DATABASE db_wordpress;

GRANT ALL PRIVILEGES ON db_wordpress.* TO "my_wp"@"localhost" IDENTIFIED BY "password";

FLUSH PRIVILEGES;

pi@raspberrypi:~ $  mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 31
Server version: 10.11.6-MariaDB-0+deb12u1 Debian 12
right (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> CREATE DATABASE db_wordpress;
Query OK, 1 row affected (0.001 sec)
MariaDB [(none)]>
MariaDB [(none)]> GRANT ALL PRIVILEGES ON db_wordpress.* TO "my_wp"@"localhost" IDENTIFIED BY "password";
Query OK, 0 rows affected (0.005 sec)
MariaDB [(none)]>  FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.002 sec)
MariaDB [(none)]> quit
Bye
pi@raspberrypi:~ $

sudo mkdir /var/www/html/mytest

sudo cp -R ./wordpress/* /var/www/html/mytest

sudo chown -R www-data:www-data /var/www/html/mytest

php_value upload_max_filesize 256M
php_value post_max_size 256M
php_value memory_limit 256M
php_value max_execution_time 300
php_value max_input_time 300

sudo nano /var/www/html/mytest/.htaccess