[MariaDB][8][?][8]

Prevent pixie3 failing to connect.

/etc/mysql/mariadb.conf.d/50-server.cnf

[mysqld]
...
max_connect_errors = 10000

Verify with:

mysqld --help --verbose  | grep ^max-connect-errors

$[Get Code]9

squid-deb-proxy

Deploy as a replacement for apt-cacher-ng.

Server

apt-get install squid-deb-proxy
# allow cognomen repo
cat > /etc/squid-deb-proxy/mirror-dstdomain.acl.d/20-cognomen
cognomen.co.uk
^D
# allow raspbian and osmc repos
cat > /etc/squid-deb-proxy/mirror-dstdomain.acl.d/30-osmc
mirrordirector.raspbian.org
apt.osmc.tv
^D
# update iptables
echo "8000 squid-deb-proxy" >> /etc/iptables/ports\_in\_tcp_allow
# disable on startup, move cache, restart
systemctl disable squid-deb-proxy
cd /var/cache
mv squid-deb-proxy /mnt/md6-media/systems/cyclops/var/cache/
ln -s /mnt/md6-media/systems/cyclops/var/cache/squid-deb-proxy
systemctl start squid-deb-proxy

Allow access and caching of unofficial repos in /etc/squid-deb-proxy/squid-deb-proxy.conf:

#http_access deny !to_archive_mirrors
http_access allow !to_archive_mirrors

# don't cache domains not listed in the mirrors file
# uncomment the third and fourth line to cache any unlisted domains
#cache deny !to_archive_mirrors
cache allow !to_archive_mirrors

Client

/etc/apt/apt.conf.d/50apt-proxy

Acquire {
  Retries "0";
  HTTP { Proxy "http://media:8000"; };
};

SMTP and Postfix

Originally configured as local-only which meant it couldn't be used to submit mail for relaying. Reconfigured as Internet Site.

https://www.digitalocean.com/community/tutorials/how-to-install-and-configure-postfix-as-a-send-only-smtp-server-on-debian-9