Getting Local Time based on Timezone in AirTable

If you’re using Airtable as a CRM and working with clients in different timezones. You might want to know what their local time is before actioning something perhaps when they’re awake or asleep 🙂 In your Airtable database, create a column called “Timezone” where you’ll put a supported Timezone for the SET_TIMEZONE function. You can … Read more

Synology Redirect Nginx HTTP to https + Allow Letsencrypt

You can follow this article pretty much all the way. https://techjogging.com/redirect-www-to-https-in-synology-nas-nginx.html However, it will fail if you use Letsencrypt to generate an SSL Certificate. So you simply need to add the following above the redirect line. Here’s how it should look. Of course after you make this change you will need to restart Nginx You … Read more

WHMCS Lightbox Loading Image in Footer (Cloudflare Issue)

You might have seen a loading image in the footer of your WHMCS admin page. If you inspect the page, you’ll see it’s got some tags for the lightbox. The issue is related to Cloudflare Rocket Loader, you can simply create a page rule to disable Rocket Loader on the admin pages or disable Rocket … Read more

CyberPower UPS and Management Card RCCARD100 Review

After purchasing the CyberPower CP1500PFCLCD UPS, I opted to purchase the RCCARD100 so that I could manage the UPS on the network. Unfortunately, the card did not work in the CP1500PFCLCD UPS. There were no lights at all while inserted, and no lights when an ethernet cable was plugged in from a switch. After digging … Read more

MySQL, Percona, MariaDB Error: Out of sort memory, consider increasing server sort buffer size!

There is a bug in MySQL 8.0.18, and above https://bugs.mysql.com/bug.php?id=103225 it was patched in 8.0.28 https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-28.html It looks as though Percona released version 8.0.28, which includes all features and bug fixes in MySQL. However, if you only do security updates, it’s possible you might have an older version of Percona based on your server’s deployment … Read more

Setting up Proxmox Email Alerts

Introduction You may not have known, but Proxmox does send out emails every so often. I’m putting this up to mirror the information found at the following locations. https://crepaldi.us/2021/03/07/configuring-e-mail-alerts-on-your-proxmox/ 1. Install the authentication library 2. Choose an SMTP Provider You can use a Gmail account and App Passwords, App Passwords is available when you enable … Read more

SynoCommunity “Invalid location” error

When trying to install the SynoCommunity to your Synology’s package manager, you might get the “Invalid location” error, as shown in the screenshot below. Excuse the location, this was from Google Images as I didn’t take a screenshot when the issue was occurring. You can find the cause of this issue on the SynoCommunity Github, … Read more

Synology Mail Server Fix “Enable User Name Service” Mirrored Content

If you’ve ever installed Synology Mail Server, you might have had the “Enable User Home Server” error pop-up. Even after enabling this setting and restarting, the error still comes up. I’m mirroring this page just incase https://community.synology.com/enu/forum/1/post/144970 How to fix “Enable User Home Service” or “The operation failed” if you try to disable User Home … Read more

Common Netdata Tasks

Update Netdata Renaming a Node You can change the node name in the Netdata web interface. Instead you can change hostname of the node directly on the node. Sometimes the node name doesn’t use the entire hostname, to override the hostname you can edit the /etc/netdata/netdata.conf and uncomment the hostname section and provide the correct … Read more