Differences

This shows you the differences between two versions of the page.

--- server_configuration [2021/02/02 08:19] – [Detail Pages] david
+++ server_configuration [2025/04/02 09:56] (current) – [Basic Configuration] david
@@ Line 5: / Line 5: @@
 Some useful notes from the first server are hidden away under [[server:initial_setup]] (access limited for security reasons).
-====== Hosting Provider ======
+===== Hosting Provider =====
 The host I chose to use is use [[https://m.do.co/c/bb281f2fae53|DigitalOcean]] I've been using them for some years and I'm very happy with the service and pricing. They have many options and allow you to scale to your requirements including hosting in many geographic locations.
@@ Line 21: / Line 21: @@
   * [[server configuration:wiki]]
   * [[server configuration:sftp]]
+  * [[server configuration:postgres]]
+  * [[server configuration:squid]]
 Also (for me):
@@ Line 87: / Line 89: @@
   * Backup old using a volume: [[https://www.digitalocean.com/docs/volumes/|DigitalOcean Volumes]]
   * Mount the volume: https://www.digitalocean.com/docs/volumes/how-to/mount/
+**What's running**
+<code bash>
+sudo service --status-all
+sudo ufw status
+</code>
+<code bash>
+################################################################################
+# MySQL : Backup
+################################################################################
+mkdir -p ~/backups/mysql_dbs
+# Backup databases from MySQL
+for DB_NAME in `echo "SHOW DATABASES;" | sudo mysql | grep -e '\|.*\|' | grep -v '^Database$'`; do echo "DB: ${DB_NAME}"; sudo mysqldump -u root "${DB_NAME}" > ~/backups/mysql_dbs/MySQL_DB-${DB_NAME}-`date +%F`.sql; done
+ll ~/backups/mysql_dbs
+################################################################################
+# PostgreSQL : Backup
+# https://www.postgresql.org/docs/current/backup.html
+################################################################################
+# sudo -i -u postgres psql -c "SELECT datname FROM pg_database WHERE datname <> ALL ('{template0,template1,postgres}')" --tuples-only
+# pg_dump dbname > dumpfile
+mkdir -p ~/backups/postgresql_dbs
+for DB_NAME in `sudo -i -u postgres psql -c "SELECT datname FROM pg_database WHERE datname <> ALL ('{template0,template1,postgres}')" --tuples-only` ; do echo "DB: ${DB_NAME}" ; sudo -i -u postgres pg_dump "${DB_NAME}" > ~/backups/postgresql_dbs/PostgreSQL_DB-${DB_NAME}-`date +%F`.sql; done
+ll ~/backups/postgresql_dbs
+################################################################################
+# Backup Files (Digital Ocean Volume)
+################################################################################
+cd /mnt/volume_lon1_01/
+# Suggested/my used locations to backup
+sudo cp -r /home .
+sudo cp -r /root .
+sudo cp -r /etc/apache2 .
+sudo cp -r /var/www .
+sudo cp -r /etc/letsencrypt .
+# Unmount (so it can be mounted to new host)
+sudo umount --verbose /mnt/volume_lon1_01
+</code>
 ===== New Environment =====
 ==== Create New Droplet ====
+=== preconfigured droplet ===
 Saving time (haha) by using a WordPress preconfigured droplet:
@@ Line 95: / Line 149: @@
   * Install & configure: The WordPress One-Click Quickstart guide: https://do.co/34TfYn8#start
+=== Build from scratch ===
+  * https://www.digitalocean.com/community/tutorials/how-to-install-wordpress-on-ubuntu-22-04-with-a-lamp-stack
+  * https://www.digitalocean.com/community/tutorials/initial-server-setup-with-ubuntu
+  * https://www.digitalocean.com/community/tutorials/how-to-install-lamp-stack-on-ubuntu
 ==== Basic Configuration ====
 As root
@@ Line 107: / Line 166: @@
 <code bash>
 # Update
-sudo apt-get update && sudo apt-get upgrade
+sudo apt-get update && sudo apt-get upgrade -y
 </code>
+<code bash>
+# SSH Access - once user access is sorted
+grep PermitRootLogin /etc/ssh/sshd_config
+sudo vi /etc/ssh/sshd_config
+# PermitRootLogin no
+</code>
 ==== SFTP ====
@@ Line 122: / Line 191: @@
   * Ubuntu Documentation: [[https://ubuntu.com/server/docs/security-firewall|Ubuntu firewall]]
+==== Postfix (email) ====
+Mostly check notes under [[server_configuration:email|Mail Server]]
+Migrate Old mail data (after completing step 3 from the guide [[https://www.digitalocean.com/community/tutorials/how-to-install-and-configure-postfix-on-ubuntu-20-04#step-3-installing-the-mail-client-and-initializing-the-maildir-structure|Step 3 — Installing the Mail Client and Initializing the Maildir Structure]])
+<code bash>
+################################################################################
+# Email/postfix
+################################################################################
+cd ~/
+sudo cp -R /mnt/volume_lon1_01/david/Maildir/ ~/.
+sudo cp -R /mnt/volume_lon1_01/david/Mail ~/.
+sudo cp -R /mnt/volume_lon1_01/david/mbox ~/.
+sudo cp -R /mnt/volume_lon1_01/david/sent ~/.
+sudo chown -R david:david ~/.
+sudo apt-get install postfix
+"Internet Site" -> roman-halliday.com
+sudo ufw allow Postfix
+</code>
 ==== Configure Apache & WordPress ====