Recent content on darek.dk
If you’ve recently upgraded to PostgreSQL 17 and suddenly started seeing errors about colliculocale not existing, you’re not alone. This column was quietly renamed to colllocale in commit f696c0cd, breaking queries that relied on the old name.
Now, any code that referenced pg_collation.colliculocale throws errors because the column is just gone. Developers are left with two…
If your database stores user-generated content along with client IPs, you may need a way to detect and block abusive users. A common approach is to analyze database records to identify IPs with excessive activity, group them by subnet, and apply firewall rules to mitigate potential abuse.
First, we retrieve a list of IPs with multiple records over the past 21 days that exhibit patterns of…
If you are using dovecot and postfix with a SQLite backend you can easily add a new user account with just a few steps. If you are using a different database such as MySQL, the following steps should be easily transferrable. We are assuming this is a new user account for an already configured and existing domain name on your mail server.
First we’ll need to generate a new password using…
One of the critical components of hosting a mail server and ensuring that your emails get delivered to inboxes is DKIM. DomainKeys Identified Mail is an email authentication protocol that allows receiving mail servers to verify that the email message truly came from the domain that it claims to have arrived from.
DKIM uses public-key cryptography to enable senders to sign emails, and together…
In case you need to quickly ban a list of IP addresses from connecting to your server, iptables is perfect for the job.
iptables is a user-space firewall that can control incoming and outgoing connections with policies and filter rules.
Blocking ingress from a single IP is easily done with a single iptables rule. We can use this same command to automate the creation of many rules with a…
When running an Apache web server, you can find yourself in a situation where you need to capture and log POST data to do some analysis and perhaps to investigate a bad actor to determine a fingerprint pattern. This can be done with the mod_security module, which is a powerful web application firewall that also provides HTTP traffic monitoring, logging and analysis capabilities.
Although this…
The Tuya UFO-R1 is a smart infrared universal remote control from Tuya, a company known for mass production and distribution of smart devices under various brand names.
Inside the device is a TYWE3S Wi-Fi module, which is based on the ESP8266 microcontroller from Espressif Systems. This specific microchip comes with 1 MiB of built-in flash and a full TCP/IP stack. The low-cost and very few…
hello world I’m Darek and I love to build things.
This site is generated from static files manipulated with a simple text editor. To help facilitate the creation of these static files, jekyll, a ruby-based static blog-centric site generator, is tasked for the job.
Being in a Mac environment a few things are required to get going. You will need a recent version of ruby installed. You can install the latest version with brew or some other…