IT Tips

-- 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...

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...

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;

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 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...

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...

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...

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...

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...

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...

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...

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)"...

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...

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....

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

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...

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...

CSV opened in Excel is showing   instead of a space between the DateTime and the period (am / pm) That is because it is being opened in Excel using CP-1252 instead of UTF-8 and thus rendering the NARROW NO-BREAK SPACE incorrectly...