https://wiki.roman-halliday.com/ 2026-04-17T11:25:06+00:00 https://wiki.roman-halliday.com/ https://wiki.roman-halliday.com/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2025-04-02T09:49:08+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=server_configuration:apache&rev=1743587348&do=diff Apache2 Configuration The configuration is built from a DigitalOcean Droplet, preconfigured with LAMP and WordPress: * Droplet Information: <https://do.co/34TfYn8> * The WordPress One-Click Quickstart guide: <https://do.co/34TfYn8#start> Core configuration Note: If no site is “enabled” then a default entry seems to run hosting files under: text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=server_configuration:cron&rev=1743090145&do=diff The server comes with no crontab by default david@roman-halliday:~$ crontab -l no crontab for david david@roman-halliday:~$ sudo crontab -l no crontab for root text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=server_configuration:email&rev=1743090145&do=diff Mail Server One day, I'll be able to write this up for DigitalOcean, and get some credit for my account: Write For DigitalOcean Share Your Technical Expertise!. But that's gong to take too long! Why You May Not Want To Run Your Own Mail Server All I want (right now) is to be able to send emails (from applications), and to send/receive on my own address using text/html 2025-04-02T09:28:06+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=server_configuration:firewall&rev=1743586086&do=diff Firewall The firewall is already configured by DigitalOcean in my choice of droplet (Ubuntu 20.04 with WordPress). However if other services are to be added (in my case yes) the Ubuntu firewall needs to be configured. See below for some extra documentation links I referred to: text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=server_configuration:mysql&rev=1743090145&do=diff <https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql> CREATE USER 'davidrh'@'localhost' IDENTIFIED BY 'password'; ALTER USER 'davidrh'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; CREATE DATABASE david; GRANT ALL PRIVILEGES ON david.* TO 'davidrh'@'localhost' WITH GRANT OPTION; FLUSH PRIVILEGES; text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=server_configuration:postgres&rev=1743090145&do=diff PostgreSQL My main requirement was PostgreSQL for DaVinci Resolve (see below) which required an older version of PostgreSQL. But some general notes on PostgreSQL are here. General links: * <https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-20-04> * <https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-18-04> DigitalOcean Latest Version Installation If you don't want the included version, you can use the … text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=server_configuration:sftp&rev=1743090145&do=diff Everything was ready out the box... I did have fun as my configuration in my client application was set to point to an IP rather than the hostname. Some related notes: * SFTP: <https://linuxconfig.org/how-to-setup-sftp-server-on-ubuntu-20-04-focal-fossa-linux> * <https://www.howtogeek.com/50787/add-a-user-to-a-group-or-second-group-on-linux/> * <https://www.digitalocean.com/community/tutorials/how-to-use-sftp-to-securely-transfer-files-with-a-remote-server> * <https://wordpress.org/su… text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=server_configuration:squid&rev=1743090145&do=diff Squid Proxy squid is a popular proxy server, if one wishes to access the outside world pretending to be the droplet in wherever it is... Handy for various things. * Squid. The definitive guide - etutorials.org Install apt-get update && apt-get upgrade -y apt-get install squid3 # Backup original configuration to file named squid.conf.factory cp -v /etc/squid/squid.conf{,.factory} text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=server_configuration:video_notes&rev=1743090145&do=diff * Intro * Welcome * Overview * Title (pexels & title guide) * Body * Prepare * DNS * Backup Files * Backup WordPress * Install * Create Server * Core Configuration * ? * Migrate * Start WordPress * text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=server_configuration:wiki&rev=1743090145&do=diff Wiki Configuration Much of the relevant details sits under the notes on Apache2 Configuration. The latest versions of the wiki and Romanian wiki were configured by copying the old files in place. Mixed notes/links Old wiki pages (how the software was originally installed and configured):