Category: Servers

Forcing mysqldump to _really_ skip comments

I wanted to do a diff on two database structures, and one answer suggested running mysqldump on both databases and then doing diff on the resulting scripts. The problem is that comments will clutter the output and get in the way, and even explicit –compact, –skip-comments, –skip-set-charset etc. won’t help. You will still be getting… Continue reading Forcing mysqldump to _really_ skip comments

Migrate whole VPS to another server using rsync

Say you’re about to cancel a VPS, but first you need to copy its contents (source) over to another server (destination). We will be using rsync. Note: rsync will keep the original timestamps for both files and folders, so that’s good. General idea: rsync –params source destination Because we will copy the whole source VPS,… Continue reading Migrate whole VPS to another server using rsync

Have fail2ban block the whole range

You will have to make changes to /etc/fail2ban/action.d/iptables-multiport.conf. To have fail2ban block the whole /24 range on every ban: actionban = -I f2b- 1 -s /24 -j To go back to blocking a single IP instead of the whole subnet: actionban = -I f2b- 1 -s -j

Certbot standalone not able to bind to IPv4 and fails authorization procedure?

One way to run certbot would be standalone on a custom port, having Nginx receive the ACME verification on port 80 (standard and can not be changed) and proxy_pass it to that custom port. If you try that and get the following error, heads up: it may be misleading. Successfully bound to :8080 using IPv6… Continue reading Certbot standalone not able to bind to IPv4 and fails authorization procedure?