This is an old revision of the document!

Information

WIP

Resources

https://wiki.friendi.ca/docs/bbcode

Prerequisites

Dependencies

su -

pkg install git-lite php85-composer php85-curl php85-gd php85-gmp php85-pdo php85-mbstring php85-intl php85-mysqli php85-zip php85-fileinfo php85-posix php85-dom php85-iconv php85-simplexml

Download Source

https://github.com/friendica/friendica/commits/develop/

su -

git clone --branch 'develop' --depth '1' --recurse-submodules 'https://github.com/friendica/friendica.git' '/usr/local/www/social' && chown -R 'www':'www' '/usr/local/www/social'

Addons

https://github.com/friendica/friendica-addons/commits/develop/
Required for composer install even without any addons enabled

git clone --branch 'develop' --depth '1' --recurse-submodules 'https://github.com/friendica/friendica-addons.git' '/usr/local/www/social/addon' && chown -R 'www':'www' '/usr/local/www/social/addon'

Environment

Composer

su -

cd '/tmp' && su -m 'www' -c "cd '/tmp' && '/usr/local/bin/composer.phar' --working-dir='/usr/local/www/social' --no-cache install --no-dev"

Database

su -

mariadb

CREATE DATABASE friendica;

CREATE USER friendica@localhost IDENTIFIED BY 'x';

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

FLUSH PRIVILEGES;EXIT;

nginx + PHP-FPM Configuration

PHP-FPM Socket

su -

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

[social]

; User/Group
user = www
group = www

; Socket
listen = 127.0.0.1:9005
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"
php_value[register_argc_argv] = "On"

; End

FastCGI

su -

ee '/usr/local/etc/freenginx/default.d/social.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:9005;
}

# End

Server Block

su -

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

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

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

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

    location / {
        try_files $uri /index.php?pagename=$uri&$args;
    }

    location ^~ /.well-known/ {
        allow all;
        rewrite ^ /index.php?pagename=$uri;
    }

    location ~* \.(tpl|md|tgz|log|out)$ {
        deny all;
    }

    location ~ /\. {
        deny all;
    }
}

# End

Initial Setup

Initialize

Change --dbpass, and --admin to email

su -

cd '/usr/local/www/social' && su -m 'www' -c "'/usr/local/www/social/bin/console' autoinstall --dbhost 'localhost' --dbport '3365' --dbuser 'friendica' --dbdata 'friendica' --url 'https://social.realmofespionage.xyz' --dbpass 'x' --admin 'x'"

Website

https://social.realmofespionage.xyz
Be sure the email matches what was used on the above command

User

x is the nickname chosen at website registration, lower-case

su -

cd '/usr/local/www/social' && su -m 'www' -c "'/usr/local/www/social/bin/console' user password x"

Etc

cd '/srv/www/social' && '/usr/bin/php' '/srv/www/social/bin/console.php' -h

cd '/srv/www/social' && '/usr/bin/php' '/srv/www/social/bin/console.php' worker

cd '/srv/www/social' && '/usr/bin/php' '/srv/www/social/bin/console.php' dbstructure update --force

cd '/srv/www/social' && '/usr/bin/php' '/srv/www/social/bin/console.php' dbstructure drop --execute

cd '/srv/www/social' && '/usr/bin/php' '/srv/www/social/bin/console.php' postupdate

cd '/srv/www/social' && '/usr/bin/php' '/srv/www/social/bin/console.php' cache clear

cd '/srv/www/social' && '/usr/bin/php' '/srv/www/social/bin/console.php' clearavatarcache

nano '/srv/www/social/config/local.config.php'

exit

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

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/friendica-files-'*'.tar.gz' ~/'Downloads/friendica'*'.sql' espionage724@192.168.1.152:~

Folder

su -

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

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

Database

Initial set-up

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

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

MySQL Connection

su -

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

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

RoE | Wiki

Table of Contents

Information

Resources

Prerequisites

Dependencies

Download Source

Addons

Environment

Composer

Database

nginx + PHP-FPM Configuration

PHP-FPM Socket

FastCGI

Server Block

Initial Setup

Initialize

Website

User

Etc

Scripts

Updater

Maintenance

Git Fix

Backup

Folder

Database

scp

Restore

scp

Folder

Database

MySQL Connection