sysadmin
2021 10 posts
- Fail2ban jail to mitigate DoS attacks against Apache
Using a Fail2ban jail to mitigate simple DoS attacks against Apache.
- GitLab PostgreSQL Data Recovery
Recovering PostgreSQL data for GitLab by a full dump/restore.
- Automated Mail Client Configuration with email-autoconf
Automated mail client configuration using email-autoconf as automx2 replacement.
- Cleanup helper script to destroy old ZFS snapshots
A small helper script written in Python to destroy legacy ZFS snapshots.
- Restrict commands by SSH authorized_keys command option
Limit SSH access to specific commands by the lovely command option in authorized_keys.
- Secure External Backup with ZFS Native Encryption
How to set up a secure offsite and offline backup server solution based on snapshots and ZFS native encryption.
- MySQL FEDERATED Storage Engine and Replication
Use MySQL FEDERATED storage engine to store data on a remote MySQL server that acts as a replication master.
- Recursively fetch dependent rows with mysqldump
Ever wondered how to fetch a row from a MySQL database recursively, going through all foreign key (FK) constraints and fetch all dependent rows as well?
- Fail2ban persistent banning
Persistent IP banning using Fail2ban's recidive jail.
- Block email forwarding spam with Rspamd
Apply spam filtering to outgoing email forwardings with Rspamd.
2020 2 posts
- MySQL MyISAM to InnoDB Conversion
How to convert thousands of MySQL tables from MyISAM to InnoDB.
- Automated Bayesian Spam/Ham Training with Rspamd
Automated Bayes Spam/Ham training with Rspamd and Dovecot / IMAPSieve.
2018 2 posts
- Process hiding in LXC using hidepid capabilities of procfs
Hiding processes for other users using hidepid capabilities of procfs in an LXC container.
- Simple and Secure External Backup
Howto set up a simple and secure offsite and offline backup server solution based on rsync.
2013 2 posts
- Process hiding - hidepid capabilities of procfs
Hiding processes for other users using hidepid capabilities of procfs.
- Proxmox VE Restricting Web UI access
How to password protect the web UI of Proxmox VE.