BLOG

Technical tips collected over several decades in IT

Squarespace Image Export

To gain continued access to your Squarespace website images after cancelling your subscription you have several options Wordpress.com Squarespace gives you the ability to export the site in Wordpress format XML. The resulting XML file doesn't contain any of the images...

MySQL 8.x GRANT ALL STATEMENT

-- CREATE CREATE USER 'tgnrestoreuser'@'localhost' IDENTIFIED BY 'AppleSauceLoveBird2024'; GRANT ALL PRIVILEGES ON tgndbrestored.* TO 'tgnrestoreuser'@'localhost'; -- RESTORE as below -- DELETE user and database DROP USER tgnrestoreuser@localhost; DROP DATABASE...

Exetel Opt-Out of CGNAT

If your port forwards and inbound and/or outbound site-to-site VPN's have failed when switching to Exetel due to their using CG-NAT their website says you will need to contact them to opt-out of CG-NAT: I phoned support and the quoted wait time was going to be 50...

Guy gone Dual Stack

FYI to myself. Today I've gone IPv4 / 6 dual stack on my Azure VM... nginx listen *:443 ssl http2;listen [::]:443 ssl http2; listen *:80;listen [::]:80;

Goodbye TPG due to no IPv6

Just had a client call from holidays in India who couldn't connect to an IPv4 RDS environment. The problem was the ISP connection there looked to be IPv6 and for some reason it couldn't connect to our RDS gateway. Having them go to https://whatismyipaddress.com showed...

Exetel IPv6

Exetel IPv6 learnings on Unifi UDM Exetel hands out a /60 by default Note: The IPv6 addresses below have been tweaked to hide the actual network prefix and host portion. Exetel by default hands out a prefix designation of /60 (see below on how to view that in the UDM...

Migrate a VM from Azure to XCP-NG

Just migrated an Azure Linux Ubuntu 22.04 VM to XCP-ng and got it running successfully Here are my rough steps: Create a snapshot of the VM in Azure (good idea to shut down the VM when you have a VM that writes data all the time) Convert the snapshot to a disk (Mine...

PHPSECLIB3 Client Algorithms

Recently our EDI supplier notified that they were changing their SFTP encryption and data integrity algorithms I use https://api.phpseclib.com/3.0/phpseclib3/Net/SFTP.html to talk to their SFTP gateway. So I to confirm the change would not cause an issue I had to...

Run 7-zip from powershell

The performance of both the Windows and Powershell Zip utilities is abysmal The following Powershell script enables a Zip operation on approximately 0.33GB of data consisting of around 59,000 files to go from minutes down to less than a minute using 7-Zip instead of...

Login

Blog History