server_configuration

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
server_configuration [2021/02/01 17:57] – [Detail Pages] davidserver_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). 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. 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 15: Line 15:
 See: See:
  
-  * [[server_configuration:apache]] +  * [[server configuration:apache]] 
-  * [[server_configuration:firewall]] +  * [[server configuration:firewall]] 
-  * [[server_configuration:email]] +  * [[server configuration:email]] 
-  * [[server_configuration:cron]] +  * [[server configuration:cron]] 
-  * [[server_configuration:wiki]]+  * [[server configuration:wiki]]
   * [[server configuration:sftp]]   * [[server configuration:sftp]]
 +  * [[server configuration:postgres]]
 +  * [[server configuration:squid]]
 +
 +Also (for me):
 +  * [[server configuration:video notes]]
  
 ====== Server Migration ====== ====== Server Migration ======
Line 84: Line 89:
   * Backup old using a volume: [[https://www.digitalocean.com/docs/volumes/|DigitalOcean Volumes]]   * 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/   * 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 ===== ===== New Environment =====
 ==== Create New Droplet ==== ==== Create New Droplet ====
 +
 +=== preconfigured droplet ===
  
 Saving time (haha) by using a WordPress preconfigured droplet: Saving time (haha) by using a WordPress preconfigured droplet:
Line 92: Line 149:
   * Install & configure: The WordPress One-Click Quickstart guide: https://do.co/34TfYn8#start   * 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 ==== ==== Basic Configuration ====
 As root As root
Line 104: Line 166:
 <code bash> <code bash>
 # Update # Update
-sudo apt-get update && sudo apt-get upgrade+sudo apt-get update && sudo apt-get upgrade -y
 </code> </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 ==== ==== SFTP ====
Line 119: Line 191:
   * Ubuntu Documentation: [[https://ubuntu.com/server/docs/security-firewall|Ubuntu firewall]]   * 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 ==== ==== Configure Apache & WordPress ====
  
Line 139: Line 235:
   * https://help.servmask.com/2018/10/27/how-to-increase-maximum-upload-file-size-in-wordpress/   * https://help.servmask.com/2018/10/27/how-to-increase-maximum-upload-file-size-in-wordpress/
  
-The two values need to be larger than the file size ''post_max_size'' and ''upload_max_filesize''. In the inteface, the value which is shown as the "Maximum upload" is (for some reason) ''post_max_size''.+The two values need to be larger than the file size ''post_max_size'' and ''upload_max_filesize''. 
 + 
 +In the interface, the value which is shown as the "Maximum upload" is (for some reason) ''post_max_size''. 
 + 
 +Edit the ''.htaccess'' file, under: ''/var/www/roman-halliday.com/datablog''
  
-Under: ''/var/www/roman-halliday.com/datablog'' +<file txt .htaccess>
-<file .htaccess>+
 php_value upload_max_filesize 256M php_value upload_max_filesize 256M
 php_value post_max_size 200M php_value post_max_size 200M
  • server_configuration.1612202244.txt.gz
  • Last modified: 2025/03/27 15:42
  • (external edit)