Information

Piwigo ¹⁾
Bootstrap Darkroom Theme ²⁾
Realm of Espionage
https://media.realmofespionage.xyz

Prerequisites

Dependencies

su -

pkg install git-lite php85-exif php85-gd php85-mysqli php85-mbstring

Download Source

su -

git clone --branch 'master' --depth '1' --recurse-submodules 'https://github.com/Piwigo/Piwigo.git' '/usr/local/www/media' && chown -R 'www':'www' '/usr/local/www/media'

git clone --branch 'master' --depth '1' --recurse-submodules 'https://github.com/Piwigo/piwigo-bootstrap-darkroom.git' '/usr/local/www/media/themes/bootstrap_darkroom' && chown -R 'www':'www' '/usr/local/www/media'

Database

su -

mariadb

CREATE DATABASE piwigo;

CREATE USER piwigo@localhost IDENTIFIED BY 'x';

GRANT ALL PRIVILEGES ON piwigo.* to piwigo@localhost;

FLUSH PRIVILEGES;EXIT;

nginx + PHP-FPM Configuration

PHP-FPM Socket

su -

ee '/usr/local/etc/php-fpm.d/media.conf' && service 'php_fpm' reload

[media]

; User/Group
user = www
group = www

; Socket
listen = 127.0.0.1:9003
listen.allowed_clients = 127.0.0.1

; Process Management
pm = ondemand
pm.max_children = 4
pm.process_idle_timeout = 30

; General
php_value[date.timezone] = "America/New_York"
php_value[max_execution_time] = "200"
php_value[memory_limit] = "512M"
php_value[post_max_size] = "100M"
php_value[upload_max_filesize] = "20M"
php_value[max_file_uploads] = "100"

; Errors
php_value[error_reporting] = "~E_ALL"
php_value[display_errors] = "Off"

; End

FastCGI

su -

ee '/usr/local/etc/freenginx/default.d/media.conf'

location ~ \.(php|phar)(/.*)?$ {
    fastcgi_split_path_info ^(.+\.(?:php|phar))(/.*)$;
    fastcgi_intercept_errors on;
    fastcgi_index index.php;
    include fastcgi_params;
    fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
    fastcgi_param PATH_INFO $fastcgi_path_info;
    fastcgi_param HTTPS on;
    fastcgi_pass 127.0.0.1:9003;
}

# End

Server Block

su -

ee '/usr/local/etc/freenginx/vhosts.d/media.conf' && service 'nginx' reload && sync

server {
    listen '443' 'ssl';
    http2 'on';
    server_name 'media.realmofespionage.xyz';
    root '/usr/local/www/media';
    index 'index.php';

    include '/usr/local/etc/freenginx/default.d/media.conf';
    include '/usr/local/etc/freenginx/default.d/headers.conf';

#    access_log  /var/log/nginx/media-access.log;
#    error_log  /var/log/nginx/media-error.log;

    location / {
        index index.php;
        try_files $uri $uri/ @rewrite;
    }

    location @rewrite {
        rewrite ^/picture((/|$).*)$ /picture.php$1 last;
        rewrite ^/index((/|$).*)$ /index.php$1 last;
        rewrite ^/i((/|$).*)$ /i.php$1 last;
    }
}

# End

Initial Setup

https://media.realmofespionage.xyz

Settings

Using a long password with symbols passed setup fine, but failed to log-in later; use less-complex password
Use a relay or bogus email address during account creation to protect against potential spam ³⁾
Disable Allow user registration immediately under Configuration → Options → General → Permissions
Seemingly have to enable Activate comments in order to prevent broken CSS on the bottom of image pages, but can uncheck Comments for all so that nobody public can leave comments
Activate Boostrap Darkroom theme

Page Banner

<p>Tech, hardware, food, nature, and gaming pictures and videos!</p>

config.inc.php

su -

su -m 'www' -c "ee '/usr/local/www/media/local/config/config.inc.php'"

<?php

// nginx Rewrite
$conf['question_mark_in_urls'] = false;
$conf['php_extension_in_urls'] = false;

// Minimal Logging
$conf['log_level'] = 'EMERGENCY';

// Hide PHP Warnings
$conf['show_php_errors'] = '0';

// Header Links
$conf['links'] = array(
  'https://realmofespionage.xyz' => 'Realm of Espionage',
  'https://wiki.realmofespionage.xyz' => 'RoE | Wiki',
  'https://blog.realmofespionage.xyz' => 'RoE | Blog',
  'https://wiki.realmofespionage.xyz/user:espionage724' => 'Webmaster Info',
  'https://wiki.realmofespionage.xyz/servers:bsd:nginx:piwigo' => 'Instance Configuration Notes',
  );

// Video Uploading
$conf['upload_form_all_types'] = true;
$conf['file_ext'] = array_merge(
  $conf['picture_ext'],
  array('tiff', 'tif', 'mpg','zip','avi','mp3','ogg','pdf','webm','mp4')
  );

// End
?>

Scripts

Updater

mkdir -p ~/'.local/scripts/www/media' && ee ~/'.local/scripts/www/media/updater.sh' && chmod +x ~/'.local/scripts/www/media/updater.sh'

#!/bin/sh

su -m 'www' -c "git -C '/usr/local/www/media' reset --hard 'origin/master'"
su -m 'www' -c "git -C '/usr/local/www/media' pull 'origin' 'master' --rebase"

su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' reset --hard 'origin/master'"
su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' pull 'origin' 'master' --rebase"

# End

~/'.local/scripts/www/media/updater.sh'

su 'root' -c ~/'.local/scripts/www/media/updater.sh'

Maintenance

mkdir -p ~/'.local/scripts/www/media' && ee ~/'.local/scripts/www/media/maintenance.sh' && chmod +x ~/'.local/scripts/www/media/maintenance.sh'

#!/bin/sh

su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' gc --aggressive --prune='all'"
su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' fsck --full --strict"

su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' gc --aggressive --prune='all'"
su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' fsck --full --strict"

'/usr/local/bin/mariadb-check' -o -f -e --auto-repair 'piwigo'

# End

~/'.local/scripts/www/media/maintenance.sh'

su 'root' -c ~/'.local/scripts/www/media/maintenance.sh'

Git Fix

Set email for both user.email

mkdir -p ~/'.local/scripts/www/media' && ee ~/'.local/scripts/www/media/git-fix.sh' && chmod +x ~/'.local/scripts/www/media/git-fix.sh'

#!/bin/sh

su -m 'www' -c "rm -Rf '/usr/local/www/media/.git'"
su -m 'www' -c "git -C '/usr/local/www/media' init --initial-branch='master'"
su -m 'www' -c "git -C '/usr/local/www/media' add '.'"

##################################################
su -m 'www' -c "git -C '/usr/local/www/media' config 'user.email' 'espionage724@x'"
##################################################

su -m 'www' -c "git -C '/usr/local/www/media' commit --message='x'"

su -m 'www' -c "git -C '/usr/local/www/media' remote add 'origin' 'https://github.com/Piwigo/Piwigo.git'"
su -m 'www' -c "git -C '/usr/local/www/media' pull --depth '1' --recurse-submodules 'origin' 'master' --rebase"

su -m 'www' -c "git -C '/usr/local/www/media' reset --hard 'origin/master'"
su -m 'www' -c "git -C '/usr/local/www/media' gc --aggressive --prune='all'"
su -m 'www' -c "git -C '/usr/local/www/media' fsck --full --strict"

su -m 'www' -c "rm -Rf '/usr/local/www/media/themes/bootstrap_darkroom/.git'"
su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' init --initial-branch='master'"
su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' add '.'"

##################################################
su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' config 'user.email' 'espionage724@x'"
##################################################

su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' commit --message='x'"

su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' remote add 'origin' 'https://github.com/Piwigo/piwigo-bootstrap-darkroom.git'"
su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' pull --depth '1' --recurse-submodules 'origin' 'master' --rebase"

su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' reset --hard 'origin/master'"
su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' gc --aggressive --prune='all'"
su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' fsck --full --strict"

# End

~/'.local/scripts/www/media/git-fix.sh'

su 'root' -c ~/'.local/scripts/www/media/git-fix.sh'

cron

Updater

01:00AM Every day

su -

ee '/etc/cron.d/media-updater'

#
SHELL=/bin/sh

0 1 * * * root '/home/espionage724/.local/scripts/www/media/updater.sh'

# End

Backup

Folder

su -

tar -czf '/home/espionage724/piwigo-files-manual-'$(date +%Y-%m-%d)'.tar.gz' -C '/usr/local/www' 'media'

Database

mariadb-dump -u root -p --single-transaction --quick 'piwigo' -r '/home/espionage724/piwigo-database-manual-'$(date +%Y-%m-%d)'.sql'

scp

scp espionage724@192.168.1.152:~/'piwigo-files-'*'.tar.gz' espionage724@192.168.1.152:~/'piwigo-database-'*'.sql' ~/'Downloads' && sync

Restore

scp

scp ~/'Downloads/piwigo-files-'*'.tar.gz' ~/'Downloads/piwigo'*'.sql' espionage724@192.168.1.152:~

Folder

su -

rm -Rf '/usr/local/www/media'

tar -xzf '/home/espionage724/piwigo-files-'*'.tar.gz' -C '/usr/local/www' 'media' && chown -R 'www':'www' '/usr/local/www/media' && sync

Database

Initial set-up

mariadb -u 'root' -p --execute='CREATE DATABASE piwigo;'

cat ~/'piwigo'*'.sql' | mariadb -u 'root' -p 'piwigo'

MySQL Connection

su -

su -m 'www' -c "ee '/usr/local/www/media/local/config/database.inc.php'"

$conf['db_host'] = '127.0.0.1';

¹⁾

https://piwigo.org/

²⁾

https://github.com/Piwigo/piwigo-bootstrap-darkroom

³⁾

the webmaster URL in the footer shows the email in plaintext and looks tasty to bots

Table of Contents

Information

Prerequisites

Dependencies

Download Source

Database

nginx + PHP-FPM Configuration

PHP-FPM Socket

FastCGI

Server Block

Initial Setup

Settings

Page Banner

config.inc.php

Scripts

Updater

Maintenance

Git Fix

cron

Updater

Backup

Folder

Database

scp

Restore

scp

Folder

Database

MySQL Connection