More
Latest Stories

Free Portainer Business at home – Using docker with more features in homelab!

By Antti Hurme 12/03/2023 2 Comments 2 Min Read

I’ve started using docker as probably a lot of you, with just a Debian or Ubuntu server with the necessary binaries to get containers running. At one point, I discovered Portainer which made container management in a homelab environment a lot easier. I though about using Kubernetes, Rancher and other options like Tanzu. But they are all quite high maintenance to run a few containers at your home. If your…

Continue Reading

[Z3005] Zabbix PostgreSQL database upgrade failed

By Antti Hurme 07/03/2023 No Comments 1 Min Read

When upgrading your Zabbix Database, you might encounter the following error “[Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  permission denied for schema public”. The zabbix user you’ve created doesn’t normally need access to the database schema to work, so this would only be relevant when upgrading the zabbix version, for example between 6.2.x to 6.4.0. To fix the error, you need to give the zabbix database user access to modify the public…

Continue Reading

Unable to create VMware VMFS Datastore on disk

By Antti Hurme 04/03/2023 No Comments 2 Min Read

Encountered an issue I haven’t seen at work, caused by re-using disks in my homelab. The disks were previously in use on a Windows Server, and after transferring the disks to my main homelab server I couldn’t create a VMFS partition from the vSphere GUI. I received the error “Call HostDatastoreSystem.QueryVmfsDatastoreCreateOptions for object ha-datastoresystem on ESXi xxx.xxx.xxx.xx failed” and couldn’t format the disk. The solution it to overwrite any partition data on the disk with a…

Continue Reading

Backup PostgreSQL Database to Backblaze B2 object storage

By Antti Hurme 01/03/2023 No Comments 2 Min Read

I have a VM in an external datacenter, and I needed to backup my PostgreSQL database somewhere else. I use Backblaze as a Veeam B&R repository, so I decided to create a new bucket there for my database dumps. The below script can easily be modified for MySQL/MariaDB as well, if needed. The script has a few requirements that you need to meet for it to work: This is a…

Continue Reading
Load More Posts