This problem was difficult to figure out. The cause was simple, but not obvious. Messages such as this were appearing in emails From July: In August: I had no idea why. My initial suspicion was the /etc/newsyslog.conf configuration for that file: [dan@knew:~] $ grep auth /etc/newsyslog.conf /var/log/auth.log root:logcheck 640 7 * @T00 JC [dan@knew:~] $ […]
Users and Roles in PostgreSQL are very similar. When I set up the FreshPorts database back in mid-2000, I was using PostgreSQL 7.0.3 (that’s my best guess based on my blog entry). I suspect roles were not available then and were introduced with PostgreSQL 8. I am positive someone will correct me if that’s wrong. […]
For future reference, this is the knew server. It runs a few jails, including Bacula regression testing services. This recent post outlines the modifications so it boots off a mirror of SSDs. File systems Paritions zpools /var/run/dmesg.boot
This is a work in progress. As I make more decisions and receive additional suggestions/advice, I will update this page. I live in an apartment. The Verizon FiOS ONT is outside on the ground floor. I live two floors up. I am considering moving the rack from the bedroom to 7x12ft locked room in the […]
This post is all about creating technical debt. If you accept that, go for it. I’m avoiding porting my FreshPorts scripts into SITEPERL. Why? I’ll migrate them to SITEPERL after BSDCan & PGCon. Right now, I need to get the servers upgraded from Perl 5.24 to Perl 5.26, because 5.24 is deprecated. FreshPorts uses Perl […]
As you read this post, keep in mind that my particular use case of notification on ssh login is not for everyone. It may not appeal to you. In fact, you might find this to be an absolutely ridiculous thing to do. I respect that. I suggest that somewhere within your network there is at […]
I don’t normally offer guest posts here, but on this rare occasion I couldn’t say no. Here’s a guest post from Michael W Lucas. What one of us finds delightful, another person might find loathsome. That’s human nature. I keep reminding myself of this every time people start babbling about the virtues of something I […]
Sometimes you want a user which can only dump the database, but nothing else. Fortunately, I searched, and found a solution. I’m writing it down so I only have to search this blog. I want the user rsyncer to have read-rights on the database freebsddiary.org, so it can run pg_dump. Similarly, I want the same […]
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 […]
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 […]