Differenze tra le versioni di "Server/lessema/Technical documentation"

Versione attuale delle 15:21, 29 gen 2024

Unix users with sudo

Current enabled users with sudo:

civihost-samuele (💼 prr) - for CiviCRM development
civihost-stefano (💼 prr) - for CiviCRM development
civihost-alessio (💼 prr) - for CiviCRM development
emerald-stefano (💼 eme) - tu support CiviCRM
valerio-bozzolan (volunteer)
~~anylink-davide-cuteri~~ (💼 anylk) - in charge of operating system updates, backups, etc.

Password authentication is not allowed.

Add Unix user

Don't create Unix users with passwords.

Create Unix users with public SSH keys.

Shortcut:

/root/scripts/add-user.sh

Source code from Server/Setup

Important

After creation, mark the related user page in this website with:

Backups

On-site backup

At 23:00 an on-site copy of all databases and webserver files are saved in this location:

/var/backups/wmi/lessema.wikimedia.it

Note: the permissions of the parent directory MUST be set to 750 root:root to keep the backups not accessible by untrusted users (note: the www-data is considered not trusted).

The execution time can be edited with

crontab -e

Note: the backup script prevents duplicate executions caused by daylight saving or standard time changeover.

The backup instructions can be configured here:

/opt/micro-backup-script/backup-instructions.conf

This is the source code of our dummy backup script in use:

https://gitpull.it/source/micro-backup-script/

Off-site backups

The same script that does #On-site backup also push the backup on server ⚙️ horror in this position:

/var/backups/wmi/lessema.wikimedia.it

The users are authorized to access this location:

💼 Anylink (preferred professional contact)
💼 prr (another preferred professional contact)
💼 eme (secondary professional contact)
User:Valerio Bozzolan (emergency volunteer contact)

The exact data retention is documented on server ⚙️ horror.

Other on-site backups

There is also this location with additional backups handled by 💼 prr:

/mnt/backup/databases

Script:

/root/mysql_db_backup.sh

Usually they are executed at 11:00, 15:00, 18:00. If you notice slowness in the application in these hours, consider changing or disabling this backup entry.

@@ Riga 4: / Riga 4: @@
 Current enabled users with sudo:
-* civihost-samuele ({{Fornitore link|civih}}) - for CiviCRM development
+* civihost-samuele ({{Fornitore link|prr}}) - for CiviCRM development
-* civihost-stefano ({{Fornitore link|civih}}) - for CiviCRM development
+* civihost-stefano ({{Fornitore link|prr}}) - for CiviCRM development
-* civihost-alessio ({{Fornitore link|civih}}) - for CiviCRM development
+* civihost-alessio ({{Fornitore link|prr}}) - for CiviCRM development
 * emerald-stefano ({{Fornitore link|eme}}) - tu support CiviCRM
-* anylink-davide-cuteri ({{Fornitore link|Anylink}}) - in charge of operating system updates, backups, etc.
 * valerio-bozzolan (volunteer)
+* <s>anylink-davide-cuteri</s> ({{Fornitore link|anylk}}) - in charge of operating system updates, backups, etc.
 Password authentication is not allowed.
@@ Riga 63: / Riga 63: @@
 The users are authorized to access this location:
-* {{Fornitore link|civih}} (preferred professional contact)
+* {{Fornitore link|Anylink}} (preferred professional contact)
+* {{Fornitore link|prr}} (another preferred professional contact)
 * {{Fornitore link|eme}} (secondary professional contact)
 * [[User:Valerio Bozzolan]] (emergency volunteer contact)
@@ Riga 71: / Riga 72: @@
 === Other on-site backups ===
-There is also this location with additional backups handled by {{Fornitore link|civih}}:
+There is also this location with additional backups handled by {{Fornitore link|prr}}:
   /mnt/backup/databases