See also mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces. I’m linking this because I use both articles on a regular basis. Sometimes you want a user which can only dump the database, but nothing else. Fortunately, I searched, and found a […]
Creating read-only PostgreSQL database users for pg_dump and pg_dumpall Read More »
I am adding IPv6 addresses to each of my servers. This post assumes the server is up and running FreeBSD 11.1 and you already have an IPv6 address block. This does not cover the creation of an IPv6 tunnel, such as that provided by HE.net. This assumes native IPv6. In this post, I am using
Adding IPv6 to an existing server Read More »
You have an old DNS server: tallboy.example.org You have a new DNS server: ns1.example.org You have a domain, example.com, for which you want to swap the old DNS server with the new DNS using nsupdate. NOTE: the domain is example.com The NS servers are in example.org (different domains). These are the commands you issue: update
Using nsupdate to change NS servers Read More »
Today I gave up on my attempt to allow relay via SSL certificate fingerprints. Instead, I will use sasl auth. Yesterday I wrote about my SMTP deliver test which broke when an SSL certificate was updated. Later that day, I finished writing scripts which delivered that fingerprint file to all hosts which needed it. Today,
No more certificate fingerprints – only sasl auth instead Read More »
Let’s Encrypt is an easy way to get free SSL certificates in an automated manner. You may never have to manually do another cert renewal again. Last night, I received this email: From: Cron Daemon To: dan@langille.org Subject: Cron /usr/local/bin/cert-puller Date: Fri, 23 Feb 2018 23:57:00 +0000 (UTC) /etc/rc.conf: 3: not found /etc/rc.conf: yr: not
Postfix suddenly starts rejecting email it had been accepting Read More »
Sometimes you just need that old version. So I installed it. FreeBSD 9.3 Sorry, but this article is light. I stopped taking notes after a bit…. We created a VM via VMware, put FreeBSD 11.1 on it, over ZFS. Then install iocage. This is what it looked like: What did it just install? This: $
Trying iocage to get an old version of FreeBSD Read More »
I have several old devices. Upgrading them is either impossible, they are unsupported, or I can’t be bothered upgrading the. Access is only via a dedicated VLAN within my home network. When stuck, I posted to Twitter and that led me to OpenSSH Legacy Options. This page describes what to do when OpenSSH refuses to
Connecting to old devices via ssh Read More »
NOTE: if you’re using something other than OSX, say, FreeBSD, then a previous blog post might be the solution you are looking for. I suggest skipping to the final paragraph before you implement any of what is below. You fire up your laptop, connect via WIFI, you get an IP address. You plug in an
Assigning static IP addresses via dhcp Read More »
World, please meet tape02. It’s been around for a while, but never properly introduced. For the record:
This morning I saw this weird popup / flag when I hovered over the Spam link on webpage. The text read: What is that? I had no idea, but it was persistent. Every time I hovered the mouse over the link, that popup appeared. It would not appear in screenshots, so I resorted to the
What’s this database connection in my Google / Calendar / Desktop? Read More »