Differences

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

--- debian_common [2021/07/14 10:12] – [Enable SSH] Júne Park
+++ debian_common [2024/03/19 11:30] – [Watchlist for backup] Júne Park
@@ Line 31: / Line 31: @@
 ----
 ===== Initial steps =====
+==== Watchlist for backup ====
+<code bash>
+/etc/nginx/sites-available/*
+/var/www/*
+/etc/transmission-daemon/
+/opt/scripts/
+</code>
+**update-motd**
+<code bash>
+/etc/update-motd.d/
+</code>
+**crontab**
+<code bash>
+sudo crontab -l
+sudo -u www-data crontab -l
+crontab -l
+</code>
+**MariaDB** ''per DATABASE''
+=== Backup MariaDB DATABASE ===
+<code bash>
+/usr/bin/mysqldump --single-transaction -h localhost -u root -p[database_passwd] [database_name] > /..(path)../.backup/[database_name]-sqlbkp_`date +"%Y%m%d"`.bak
+</code>
+----
+=== Backup using rsync command ===
+== Backup Nginx configuration files ==
+<code bash>
+sudo rsync -avh --progress /etc/nginx/sites-available/ /home/meson/.backup/nginx/nginx_config_`date +"%Y%m"`/
+</code>
+== Backup HTML source files ==
+<code bash>
+sudo rsync -avh --progress /var/www/ /home/meson/.backup/html/html_backup_`date +"%Y%m"`/
+</code>
+----
+=== Remote backup for webpages ===
+Rsync with ''[TARGET]'' using rsync from ''[SOURCE]''
+<code bash>
+sudo -u www-data rsync -azP --exclude '.ssh' -e 'ssh -p [port_number]' --rsync-path="sudo rsync" /var/www/ [user]@[TARGET]:"/[TARGET PATH]../../"
+</code>
+Put ''[SOURCE]'' public key in ''[TARGET]'' user's ''authorized_keys''
+----
+==== Configure log files ====
+Edit ''/etc/nginx/nginx.conf''
+<code nginx>
+        access_log /var/log/nginx/_access.log;
+        error_log /var/log/nginx/_error.log;
+</code>
+----
+==== Purge log files ====
+== Cleaning compressed log files ==
+<code bash>
+sudo find /var/log -name '*.gz' -exec rm {} \;
+</code>
+----
 ==== Enable SSH ====
@@ Line 62: / Line 131: @@
 </code>
-''-o'': Save the private-key using the new OpenSSH format
+  * ''-o'': Save the private-key using the new OpenSSH format
-''-a'': KDF (Key Derivation Function) rounds. Higher numbers result in slower passphrase verification, increasing the resistance to brute-force password cracking should the private-key be stolen.
+  * ''-a'': KDF (Key Derivation Function) rounds. Higher numbers result in slower passphrase verification, increasing the resistance to brute-force password cracking should the private-key be stolen.
-''-C'': An option to specify a comment
+  * ''-C'': An option to specify a comment
 ---
-=== Enable colorful terminal ===
+==== Enable colorful terminal ====
 Comment out **''force_color_prompt=yes''** in ''~/.bashrc''
@@ Line 77: / Line 146: @@
 </code>
+=== Time stamp prompt ===
+Edit ''~/.bashrc'' and change ''PS1'' line
+<code bash>
+if [ "$color_prompt" = yes ]; then
+    PS1='${debian_chroot:+($debian_chroot)}\[\033[01;32m\]\u@\h\[\033[00m\]: \[\033[01;33m\]\D{%T}\[\033[00m\] \[\033[01;37m\]\w\$\[\033[00m\] '
+else
+    PS1='${debian_chroot:+($debian_chroot)}\u@\h: \D{%T} \w\$ '
+fi
+</code>
+Save and load ''.bashrc''
+<code bash>
+source ~/.bashrc
+</code>
 ----
@@ Line 187: / Line 274: @@
 ----
+=== NO-IP with ddclient ===
+<code ini>
+  protocol=dyndns2
+  server=dynupdate.no-ip.com
+  login=your_login_id
+  password=your_password
+  your_domain.com
+</code>
+----
 === Google Domains with API ===