| Server configuration (config.local.json) | |
|---|---|
Settings specific to this server. Passwords are never shown, and the commands, file paths and server addresses can only be changed from the command line: a stolen administrator session must not be able to run commands on the server nor divert the organisers' credentials. Each save keeps the previous version (config.local.json.bak) and is logged. | |
| Server state | |
Read-only checks, drawn from real incidents on an ianseo server in production (details: Modules/Custom/AUTH/SERVEUR.md). Nothing is changed here: the fixes suggested are made from the command line on the server. | |
| ✔ MariaDB 10.11.14 | Engine not affected by the MySQL 8 trap on big sessions. |
| ⚠ Database connections | max_connections = 151, peak since the database started: 4. ianseo opens two connections per page (reading and writing): 150 PHP processes at most (MaxRequestWorkers, /etc/apache2/mods-enabled/mpm_prefork.conf) would ask for 300 at the peak of the load, beyond the limit.max_connections = 320
(file /etc/mysql/…/99-ianseo.cnf, template serveur/mysql/ianseo.cnf, then restart the database) |
| ✔ Database memory | innodb_buffer_pool_size = 128 MB for a database of 33 MB. |
| ℹ Slow query log off | It is what names the query at fault when the server slows down. Advised threshold: 2 s.sudo mysql -e "SET GLOBAL slow_query_log = 1; SET GLOBAL long_query_time = 2;"
(and in the .cnf to keep it at restart — template serveur/mysql/ianseo.cnf) |
| ⚠ Short PHP sessions | An idle session is erased after 24 min: the user is signed out and loses the open competition.session.gc_maxlifetime = 43200
(in /etc/php/8.3/apache2/php.ini, then restart Apache) |
| ⚠ Import size | PHP refuses uploads bigger than 8 MB: importing a big competition will fail.upload_max_filesize = 64M
post_max_size = 64M
(in /etc/php/8.3/apache2/php.ini, then restart Apache) |
| ✔ OPcache | On. |
| ✔ Size of the sessions | No session of more than 5000 places in the competitions under way or to come. |
| ⚠ System updates | Default time: around 6 am, with a random delay of one hour. They restart the database and Apache — on another ianseo server, three times in the middle of a competition in one semester.Templates serveur/apt (installation at 04:30, after the maintenance of 03:15) — SERVEUR.md § 4.1 |
| ℹ Restart after updates | needrestart is installed without the module's setting: depending on its configuration, it restarts the services as soon as an update is installed (in the daytime too, for an update caught up after the server was switched on) or only lists them.Templates serveur/needrestart/ianseo.conf, serveur/bin/ianseo-restart-services and serveur/cron/ianseo-restart — SERVEUR.md § 4.1 |
| ⚠ Server templates | System files the server cannot do without are missing. Commands below, to run on the server (each file in detail: serveur/README.md).
sudo install -m 0750 -o root -g root /opt/ianseohdf/Modules/Custom/AUTH/serveur/bin/ianseo-lock /usr/local/bin/
sudo install -m 0750 -o root -g root /opt/ianseohdf/Modules/Custom/AUTH/serveur/bin/ianseo-unlock /usr/local/bin/
sudo install -m 0750 -o root -g root /opt/ianseohdf/Modules/Custom/AUTH/serveur/bin/ianseo-maintenance-on /usr/local/bin/
sudo install -m 0750 -o root -g root /opt/ianseohdf/Modules/Custom/AUTH/serveur/bin/ianseo-maintenance-off /usr/local/bin/
sudo install -m 0750 -o root -g root /opt/ianseohdf/Modules/Custom/AUTH/serveur/bin/ianseo-restart-services /usr/local/bin/
sudo install -m 0750 -o root -g root /opt/ianseohdf/Modules/Custom/AUTH/serveur/bin/ianseo-restore /usr/local/bin/
sudo install -D -m 0644 -o root -g root /opt/ianseohdf/Modules/Custom/AUTH/serveur/apache/maintenance.html /var/www/maintenance/index.html
sudo install -D -m 0644 -o root -g root /opt/ianseohdf/Modules/Custom/AUTH/serveur/cron/ianseo-nightly /etc/cron.d/ianseo-nightly
sudo install -D -m 0644 -o root -g root /opt/ianseohdf/Modules/Custom/AUTH/serveur/cron/ianseo-restart /etc/cron.d/ianseo-restart
sudo install -D -m 0644 -o root -g root /opt/ianseohdf/Modules/Custom/AUTH/serveur/cron/ianseo-backup-live /etc/cron.d/ianseo-backup-live
sudo install -D -m 0644 -o root -g root /opt/ianseohdf/Modules/Custom/AUTH/serveur/cron/ianseo-licences /etc/cron.d/ianseo-licences
sudo install -D -m 0644 -o root -g root /opt/ianseohdf/Modules/Custom/AUTH/serveur/cron/ianseo-waitlist /etc/cron.d/ianseo-waitlist
sudo install -D -m 0644 -o root -g root /opt/ianseohdf/Modules/Custom/AUTH/serveur/cron/ianseo-trust /etc/cron.d/ianseo-trust
sudo install -D -m 0644 -o root -g root /opt/ianseohdf/Modules/Custom/AUTH/serveur/logrotate/ianseo /etc/logrotate.d/ianseo
sudo install -D -m 0644 -o root -g root /opt/ianseohdf/Modules/Custom/AUTH/serveur/apt/apt-daily.timer.conf /etc/systemd/system/apt-daily.timer.d/ianseo.conf
sudo install -D -m 0644 -o root -g root /opt/ianseohdf/Modules/Custom/AUTH/serveur/apt/apt-daily-upgrade.timer.conf /etc/systemd/system/apt-daily-upgrade.timer.d/ianseo.conf
sudo install -D -m 0644 -o root -g root /opt/ianseohdf/Modules/Custom/AUTH/serveur/apt/51ianseo-auto-reboot /etc/apt/apt.conf.d/51ianseo-auto-reboot
sudo install -D -m 0644 -o root -g root /opt/ianseohdf/Modules/Custom/AUTH/serveur/needrestart/ianseo.conf /etc/needrestart/conf.d/ianseo.conf
sudo install -D -m 0644 -o root -g root /opt/ianseohdf/Modules/Custom/AUTH/serveur/fail2ban/filter-ianseo-auth.conf /etc/fail2ban/filter.d/ianseo-auth.conf
sudo install -D -m 0644 -o root -g root /opt/ianseohdf/Modules/Custom/AUTH/serveur/fail2ban/jail-ianseo.conf /etc/fail2ban/jail.d/ianseo.conf
sudo install -D -m 0644 -o root -g root /opt/ianseohdf/Modules/Custom/AUTH/serveur/mysql/ianseo.cnf /etc/mysql/mariadb.conf.d/99-ianseo.cnf
sudo systemctl daemon-reload
sudo systemctl reload fail2ban |
| ⚠ Backups | No nightly backup in /var/backups/ianseo; no live copy (template serveur/cron/ianseo-backup-live). |
| Licensee files of foreign federations | |
| Files published by some federations (addresses kept by the ianseo team), downloaded each night: the archers of these countries create their account with their licence. A file holding fewer than 90 % of the licences of the day before is refused (cut short?); if the federation cleaned it on purpose, force it here, otherwise it stays blocked. | |
| CAN Canada | ℹ Never loaded: the archers of this country go through the manual entry. |
| BALT Estonia, Latvia, Lithuania | ℹ Never loaded: the archers of this country go through the manual entry. |
| ITA Italy | ℹ Never loaded: the archers of this country go through the manual entry. |
| SLO Slovenia | ℹ Never loaded: the archers of this country go through the manual entry. |
As each night: about a minute (several megabytes to download). | |
| Jobs journal | |
| Outcome of the scheduled jobs of the last 14 days (nightly maintenance, licences, foreign files…), newest first, with the detail of each error: the state of the server is followed from here, without a command line. | |
| No job recorded in the last 14 days. | |
| Backups (night + live copies) | |
The nightly backup is taken every night: site closed, just before the update, on a night when the ianseo core or a module is to be updated — it is what allows going back if a migration goes wrong — and site open the other nights, as a consistent snapshot that blocks nothing. The live copies (database only, site open, a few seconds without blocking anything) limit the loss to a few hours of data entry in case of disaster; they run when the task /etc/cron.d/ianseo-backup-live is installed (template serveur/cron/ianseo-backup-live). | |
| State | ✘ The folder does not exist and the web server cannot create it. To run once on the server: sudo install -d -o www-data -g www-data -m 0700 '/var/backups/ianseo'✔ mysqldump available – rclone not installed (online copy not possible) |
| Advanced editing (whole file) | |
|---|---|
Show the JSONPasswords appear as |