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...
James McDonald
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...
Cannot connect to the Docker daemon at unix:///var/run/docker.sock. Is the docker daemon running?
When running docker ps -a in the default WSL instance you see "Cannot connect to the Docker daemon at unix:///var/run/docker.sock. Is the docker daemon running?" Solution: Goto Resources WSL Integration and make sure Enable integration with my default WSL distro and...
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...
So many Email Scams
The internet is a waterhole and we are digital gazellesJames McDonald 2024 Look at the text below of 2 emails I received sent to two of my email aliases from two different From addresses I presume it just requires you to reply to the query and then they send some...
Unifi Dream Machine SE – Australian HFC Connection settings & Wireguard Full and Split Tunneling
Some notes from a Unifi USG SE and a UDM Making a note of this here because TPG HFC connections uses VLAN 2 TPG HFC NBN Connection - UDM Note the VLAN ID of 2 Exetel HFC NBN Connection All it needs is a PPPoE connection with the [ServiceNumber]@vic.exetel.com.au and...
Cannot provision an Azure Marketplace VM with Free Subscription
Problem: Trying to provision OpenVPN Access Server from the Marketplace and get: You cannot purchase reservation because required AAD tenant information is missing. Please ask your tenant admin to fill this form: https://aka.ms/orgprofile (Code: "AccountSetupError)"...
Meraki Open Source Licenses
Until today I assumed that Meraki was built in-house with only closed source software. But having a look at the Meraki-Firmware-Licenses bundle it is clear that like Unifi Cisco is using many Open Source packages to bring together it's offering: Having only just...
VEEAM FAILS
If you have Veeam backup failing with the Updating BCD failed with Cannot update SafeBoot flag and SentinelOne is installed. Try the following from a veeam forum post 29/11/2023 2:35:29 PM :: Processing TGN-HO-DC02 Error: VSSControl: -2147467259 Backup job failed....
Turn Remote Desktop Connection on using the registry
You need to be in an Administrative command prompt then run: reg.exe ADD "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server" /v fDenyTSConnections /t REG_DWORD /d 0 /f
Certbot Reload Nginx on cert renewal
https://github.com/toggenation/cert-checker Recently I created a Cert Expiry Checker so I can be notified when my and my clients SSL certs are 27 days from expiry. What is strange is I got notified that a client on Squarespace has an SSL cert within 27 days of expiry...
LastLogon using PowerShell
Get-ADUser -Filter {Enabled -eq $true} -Properties Name,Manager,LastLogon,DistinguishedName | Select-Object Name,samAccountName,DistinguishedName,@{n='LastLogon';e={[DateTime]::FromFileTime($_.LastLogon).ToString('g')}} | Export-Csv -NoTypeInformation -Path...