pg_dump: error: connection to server failed: fe_sendauth: no password supplied

2 Comments / Bacula, Open Source, PostgreSQL / By / /

FYI, this problem has been solved and described in I figured out why pg_dump was failing with PostgreSQL 15-16. This morning I encountered this error message: In this post: FreeBSD 13.2 PostgreSQL 12.16 (server – pg02) PostgreSQL 16.1 (client – dbclone) See also While restoring my PostgreSQL database to a new FreeBSD server, I discovered the wrong database server in a configuration file. The backstory: dbclone dumps the bacula database hosted on pg02. […]

pg_dump: error: connection to server failed: fe_sendauth: no password supplied Read More »

Jails with embedded, but not jailed, ZFS datasets – how to mount/umount – corrected

3 Comments / FreeBSD, Jails, ZFS / By /

This is a rewrite of Jails with embedded, but not jailed, ZFS datasets – how to mount/umount. First, this is not about jailed ZFS datasets. I use them for FreshPorts, but that’s not I’m going to talk about here. In this post: FreeBSD 13.2 This is my example: [22:25 r730-03 dvl ~] % zfs list | grep bacula-sd-04 data01/bacula-volumes 12.1T 4.18T 96K /jails/bacula-sd-04/usr/local/bacula/volumes data01/bacula-volumes/DiffFile 109G 915G 109G /jails/bacula-sd-04/usr/local/bacula/volumes/DiffFile data01/bacula-volumes/FullFile 4.00T 2.00T 3.89T /jails/bacula-sd-04/usr/local/bacula/volumes/FullFile

Jails with embedded, but not jailed, ZFS datasets – how to mount/umount – corrected Read More »

Moving 4x storage devices into a new home

Leave a Comment / Disks, FreeBSD, hardware, nvme, R730, ZFS / By /

Yesterday I did some scavenging of some servers which I’m going to dispose of. I managed to put together 4 x 1TB storage devices: 2 x NVMe sticks and 2 x SSDs. I also pulled a riser card from an R730 and relocated it to another host. The NVMe sticks are mounted on these PCIe cards, which I do not regret buying. They came with full height and low-profile brackets. More to the

Moving 4x storage devices into a new home Read More »

Preparing a server for sale – Supermicro 846 – 10 x 5TB HDD

Leave a Comment / Disks, File Systems, hardware, R730, ZFS / By /

FYI: This server has since gone to a new home. After powering off the server about 8 months ago, I took the first steps to selling it. I opened it up and took out 2x NVMe sticks (1TB each, ZFS mirrored, giving a 930G zpool) INTEL fiber NIC (Intel X540-AT2) I’ll be keeping those items. I also took an inventory of the drives still in the system: 10 x 5TB drives – all

Preparing a server for sale – Supermicro 846 – 10 x 5TB HDD Read More »

pg_dump: error: query failed: ERROR: permission denied for sequence cache_clearing_files_id_seq

Leave a Comment / Nagios, Open Source, PostgreSQL / By /

Skip to the end of this post for the lesson part of this blog post. This email arrived in my inbox yesterday at about 10:00 PM: This is the backup script for my database dumps on my server at home. I immediately recognized it as the follow-on from a table I had just added. It was late, I was headed to bed. I forgot about it. Until this morning. This morning This morning,

pg_dump: error: query failed: ERROR: permission denied for sequence cache_clearing_files_id_seq Read More »

Got a pkg vuln you can’t get rid of?

Leave a Comment / FreeBSD, Open Source, pkg / By /

I’ve been working on this for a while. [23:18 r730-01 dvl ~] % pkg audit curl-8.4.0 is vulnerable: curl — SOCKS5 heap buffer overflow CVE: CVE-2023-38545 WWW: https://vuxml.FreeBSD.org/freebsd/d6c19e8c-6806-11ee-9464-b42e991fc52e.html 1 problem(s) in 1 installed package(s) found. [23:18 r730-01 dvl ~] % The original vuxml entry got it wrong. This problem was fixed in 8.4.0 A subsequent commit fixed that. So why am I still having this problem 48 hours later? mtime. This Mastodon thread

Got a pkg vuln you can’t get rid of? Read More »

acm.esh key ’/var/db/acme/certs.int.unixathome.org.key’ is unreadable

Leave a Comment / Let's Encrypt, Security / By /

Today, while mucking about with a new cronjob and log file for acme.sh, I stumbled across these error messages: Why was I stumbling around? This email arrived after the daily cert renewal: Three skips. Three error messages. Let’s look at that file: [18:37 certs dan ~] % sudo ls -l /var/db/acme/certs.int.unixathome.org.key -rw-r—– 1 root acme 116 Oct 6 20:21 /var/db/acme/certs.int.unixathome.org.key That should be readable. I checked some ZFS snapshots from earlier this week.

acm.esh key ’/var/db/acme/certs.int.unixathome.org.key’ is unreadable Read More »

Use of K* file pairs for HMAC is deprecated – acme.sh

Leave a Comment / DNS, Let's Encrypt, named, nsupdate, Security / By /

On Wednesday Oct 6th, I was greeted by these log messages: This is the output from the cronjob run by the acme user in my jail called certs. This is the daily run to renew any certificates which are soon to expire. This is the job in question: [19:36 certs dan ~] % sudo crontab -l -u acme 44 16 * * * /usr/local/sbin/acme.sh –cron –home /var/db/acme/.acme.sh > /dev/null [19:44 certs dan ~]

Use of K* file pairs for HMAC is deprecated – acme.sh Read More »

Creating a Time Capsule instance using Samba, FreeBSD, and ZFS

Leave a Comment / Backups, FreeBSD, Jails, Open Source, samba / By /

I recently moved a Time Capsule instance from a FreeBSD host into a jail. Today, I’m going to create a new Time Capsule which uses Samba instead of AFP. Why? Samba seems to be the preferred solution because AFP has been deprecated. It still works, but let’s go Samba. Not covered in this post, but recommended: snapshot your datasets on a regular basis. I like using sanoid for that. That way, if your

Creating a Time Capsule instance using Samba, FreeBSD, and ZFS Read More »

Jails with embedded, but not jailed, ZFS datasets – how to mount/umount

Leave a Comment / FreeBSD, Jails, ZFS / By /

This approach did not work, because I used the wrong set of filesystems. See below for Error. This post has been replaced by Jails with embedded, but not jailed, ZFS datasets – how to mount/umount – corrected. NOTE: on yesterday’s (2023-10-04) reboot, the file systems did not properly mount. zfs get mounted said they were mounted, but the directories were empty. Stopping, then starting the jail resulted in a proper mount. I wonder

Jails with embedded, but not jailed, ZFS datasets – how to mount/umount Read More »

Scroll to Top