All content and data available on Realm of Espionage is available under the Creative Commons Attribution-ShareAlike 4.0 International license.
==== Custom CSS ====
* :!: This shrinks the footer height, and places it back at the bottom of the screen instead of floating half-way up the page when little content exists ([[https://www.joomlart.com/forums/topic/footer-on-bottom-of-screen-not-sticky/#post-898349|source 1]], [[https://www.joomlart.com/documentation/joomla-faqs/css-related-issues#footer-sticky|source 2]])
* Also replaces ThemeMagic for Brand Primary Color, Footer Background, and Footer Text Color
* Last tested: 2024/02/01 on Joomla 5.1.0-dev, T3 Framework 3.2.0, and Purity III 2.1.0
sudo -e '/var/www/main/templates/purity_iii/css/custom.css' && sudo chown 'nginx':'nginx' '/var/www/main/templates/purity_iii/css/custom.css'
html,
body {
height: 100%;
}
a {
color: #3D8BFF;
}
a:hover {
color: #196BE4;
}
.t3-mainnav {
background-color: #3D8BFF;
}
.logo a {
background: none;
}
.logo a:hover {
background: #196BE4;
}
.t3-wrapper {
position: relative;
min-height: 100%;
}
.t3-footer {
position: absolute;
bottom: 0;
left: 0;
right: 0;
background-color: #484848;
color: #FFFFFF;
}
.t3-copyright {
padding-top: 20px;
padding-bottom: 0px;
}
===== Articles =====
==== Home ====
* Toggle Editor for raw-HTML paste
Welcome! Realm of Espionage is my creative space online, and the umbrella name I provide my services under. RoE is entirely self-hosted, in-house, with free and open-source software, and fully-documented in my unique notes style on RoE | Wiki, my encyclopedia of technical notes and no-nonsense automation.
This domain serves as a landing page and provides links to the services I offer, some of my online profiles, and projects showcase. To view them, use the navigation bar (desktop) or the ≡ hamburger icon (mobile) at the top of the screen.
=== Temp ===
****
(website is under construction and there aren't any links in the nav bar yet; my wiki is far-more interesting! webmaster info, dev notes)
===== Offline Message =====
This site is being built behind-the-scenes, check back later!
In the meantime, check out my wiki: RoE | Wiki
===== Menus =====
* Main menu headers are: System Links -> URL -> ''#'' to allow tapping as-expected on mobile
* Icon sizes are 24x24
* Menu entries should be named normally before saving for a proper ''alias'', and then add a space on the title afterwards to make it look better with the icon
===== Global Configuration =====
==== Site Meta Description ====
****
Realm of Espionage is my creative space, and the umbrella name I provide my services under. RoE is self-hosted, with free and open-source software, and fully-documented in my unique notes style on "RoE | Wiki", my encyclopedia of technical notes and no-nonsense automation
==== Content Rights ====
****
Creative Commons Attribution-ShareAlike 4.0 International
==== Articles ====
* System -> Global Configuration -> Articles
* Show Title: Hide
* Show Category: Hide
* Show Author: Hide
* Show Publish Date: Hide
* Show Navigation: Hide
* Show Hits: Hide
==== Menu ====
* Menus -> Main Menu -> Home -> Link Type -> Display in Menu: No
* Menus -> Main Menu -> Home -> Page Display -> Show Page Heading: Hide
====== Services ======
===== Updater =====
==== Service ====
sudo -e '/etc/systemd/system/main-up.service'
[Service]
User=wwwrun
Group=www
Type=oneshot
Environment="COMPOSER_CACHE_DIR=/dev/null"
ExecStart='/usr/bin/git' -C '/srv/www/main' pull origin '5.4-dev'
ExecStart='/usr/bin/composer' --working-dir='/srv/www/main' --no-cache install --no-dev
ExecStart='/usr/bin/npm' --prefix '/srv/www/main' ci --logs-max='0'
ExecStartPost='/usr/bin/sync'
# End
==== Timer ====
* Every day at ''03:00:00''
sudo -e '/etc/systemd/system/main-up.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'main-up.timer' --now && sudo systemctl start 'main-up' && sudo systemctl status 'main-up' -l
[Unit]
Description=Joomla Git Updater
After=network-online.target
Wants=network-online.target
[Timer]
OnCalendar=*-*-* 03:00:00
Persistent=true
[Install]
WantedBy=timers.target
# End
===== Backup =====
==== Files ====
=== Service ===
mkdir -p ~/'backups' && sudo -e '/etc/systemd/system/main-fb.service' && sudo sed -i 's/CHANGEME/'$USER'/g' '/etc/systemd/system/main-fb.service'
[Service]
Type=oneshot
ExecStart='/usr/bin/bash' -c '"/usr/bin/tar" -czf "/home/CHANGEME/backups/joomla-files-auto-"$$(date +%%Y-%%m-%%d)".tar.gz" -C "/srv/www" "main"'
ExecStartPost='/usr/bin/sync'
# End
=== Timer ===
* ''01'' day of every month at ''03:15:00''
sudo -e '/etc/systemd/system/main-fb.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'main-fb.timer' --now
[Unit]
Description=Joomla Files Backup
[Timer]
OnCalendar=*-*-01 03:15:00
Persistent=true
[Install]
WantedBy=timers.target
# End
sudo systemctl start 'main-fb' && sudo systemctl status 'main-fb' -l
==== Database ====
=== Database Auth ===
sudo mkdir -p '/var/lib/mysql/auth' && sudo -e '/var/lib/mysql/auth/joomla' && sudo chown 'mysql':'mysql' '/var/lib/mysql/auth/joomla' && sudo chmod '0600' '/var/lib/mysql/auth/joomla'
[mariadb-dump]
user=joomla
password=x
# End
=== Service ===
mkdir -p ~/'backups' && sudo mkdir -p '/var/lib/mysql/tmp' && sudo -e '/etc/systemd/system/main-db.service' && sudo sed -i 's/'CHANGEME'/'$USER'/g' '/etc/systemd/system/main-db.service'
[Service]
Group=mysql
Type=oneshot
ExecStart='/usr/bin/bash' -c '"/usr/bin/mariadb-dump" --defaults-extra-file="/var/lib/mysql/auth/joomla" --single-transaction --quick "joomla_db" -r "/home/CHANGEME/backups/joomla-database-auto-"$$(date +%%Y-%%m-%%d)".sql"'
ExecStartPost='/usr/bin/sync'
# End
=== Timer ===
* ''01'' day of every month at ''03:10:00''
sudo -e '/etc/systemd/system/main-db.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'main-db.timer' --now && sudo systemctl start 'main-db' && sudo systemctl status 'main-db' -l
[Unit]
Description=Joomla Database Backup
After=mariadb.service
[Timer]
OnCalendar=*-*-01 03:10:00
Persistent=true
[Install]
WantedBy=timers.target
# End
===== Maintenance =====
==== Service ====
sudo -e '/etc/systemd/system/main-m.service'
[Service]
User=wwwrun
Group=www
Type=oneshot
ExecStart='/usr/bin/git' -C '/srv/www/main' reset --hard
ExecStart='/usr/bin/git' -C '/srv/www/main' gc --aggressive --prune='all'
ExecStart='/usr/bin/git' -C '/srv/www/main' fsck --full --strict
ExecStartPost='/usr/bin/sync'
# End
==== Timer ====
* ''01'' day of every month at ''03:30:00''
sudo -e '/etc/systemd/system/main-m.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'main-m.timer' --now
[Unit]
Description=Joomla Maintenance
After=network-online.target
Wants=network-online.target
[Timer]
OnCalendar=*-*-01 03:30:00
Persistent=true
[Install]
WantedBy=timers.target
# End
sudo systemctl start 'main-m' && sudo systemctl status 'main-m' -l
====== Backup ======
===== Files =====
****
sudo tar -czf ~/'joomla-files-manual-'$(date +%Y-%m-%d)'.tar.gz' -C '/srv/www' 'main'
===== Database =====
****
sudo mariadb-dump --single-transaction --quick 'joomla_db' -r ~/'joomla-database-manual-'$(date +%Y-%m-%d)'.sql'
===== scp =====
scp espionage724@192.168.1.152:~/'joomla-files-'*'.tar.gz' ~/'Downloads'
scp espionage724@192.168.1.152:~/'joomla-database-'*'.sql' ~/'Downloads'
====== Restore ======
===== scp =====
scp ~/'Downloads/joomla-files-'*'.tar.gz' espionage724@192.168.1.152:~
scp ~/'Downloads/joomla'*'.sql' espionage724@192.168.1.152:~
===== Stop nginx =====
****
sudo systemctl stop 'nginx'
===== Remove Existing Files =====
****
ls ~/'joomla-files-'*'.tar.gz' && sudo rm -Rf '/srv/www/main'
===== Restore Files =====
****
sudo tar -xzf ~/'joomla-files-'*'.tar.gz' -C '/srv/www' 'main' && sudo chown -R 'wwwrun':'www' '/srv/www/main' && sudo chmod -R '0755' '/srv/www/main'
===== Git Fix =====
* :!: Set email for ''user.email''
* :!: T3 + Purity III need reinstalled
sudo su 'wwwrun' -s '/bin/bash'
rm -Rf '/srv/www/main/.git'
git -C '/srv/www/main' init --initial-branch='5.4-dev'
git -C '/srv/www/main' add '.'
git -C '/srv/www/main' config 'user.email' 'espionage724@x'
git -C '/srv/www/main' commit --message='x'
git -C '/srv/www/main' remote add 'origin' 'https://github.com/joomla/joomla-cms.git'
git -C '/srv/www/main' pull --depth '1' --recurse-submodules 'origin' '5.4-dev' --rebase
git -C '/srv/www/main' reset --hard 'origin/5.4-dev'
git -C '/srv/www/main' gc --aggressive --prune='all'
git -C '/srv/www/main' fsck --full --strict
exit
===== Restore Database =====
* [[#database|Initial set-up]]
sudo mariadb --execute='DROP DATABASE joomla_db;'
sudo mariadb --execute='CREATE DATABASE joomla_db;'
sudo mariadb 'joomla_db' < ~/'joomla'*'.sql'
===== Start nginx =====
****
sudo systemctl start 'nginx'
===== Clean-up =====
****
rm -fv ~/'joomla-files-'*'.tar.gz' ~/'joomla'*'.sql'