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

• FreeBSD 15.0
• freenginx + PHP + PHP-FPM
• Let's Encrypt
• MariaDB

• https://piwigo.org/guides/install/requirements
• https://github.com/Piwigo/piwigo-videojs/wiki/How-to-add-videos
• https://github.com/Piwigo/piwigo-videojs/wiki/Synchronize#requirement

su -

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

• https://github.com/Piwigo/Piwigo/commits/master/
• https://github.com/Piwigo/piwigo-bootstrap-darkroom/commits/master/

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'

su -

mariadb

CREATE DATABASE piwigo;

CREATE USER piwigo@localhost IDENTIFIED BY 'x';

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

FLUSH PRIVILEGES;EXIT;

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

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

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

• https://media.realmofespionage.xyz

• 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

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

• nginx Rewrite source
• Video Uploading source
• More Settings

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
?>

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'

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'

• 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'

su -

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

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

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

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

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

• Initial set-up

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

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

su -

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

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