Error while running a restore ERROR: invalid input syntax for type timestamp with time zone: "202" COPY 4 Restore Command (I use docker but that isn't the problem) zcat ${RECOVERY_FILE} | docker run --env PGPASSWORD -i --rm \ postgres:14.5 psql -d ${DB_NAME} \ -h...
IT Tips
VS Code Killed by OOM ON UBUNTU VM
Problem: VS Code on Ubuntu 22.04 VM exits with "killed code 9" journalctl | grep -i oom May 17 12:58:03 tgn-vm-ln-02 kernel: Out of memory: Killed process 43215 (code) total-vm:1186602700kB, anon-rss:189300kB, file-rss:0kB, shmem-rss:36296kB, UID:1000 pgtables:1412kB...
Failed to execute ‘pushState’ on ‘History’
Uncaught (in promise) DOMException: Failed to execute 'pushState' on 'History': A history state object with URL 'http://example.com.au/dev/despatch' cannot be created in a document with origin 'https://example.com.au' and URL 'https://example.com.au/dev/despatch'. I...
Mysql wont Start
Ubuntu 22.04 with mysql-server 8.0.32-0ubuntu0.22.04.2 mysql wouldn't start with error sudo systemctl status mysql.service # output Error: 99 (Cannot assign requested address) Cause I was using Docker on this host and had added the the Docker network host IP Address...
Connect to postrgres with psql password Authentication
Connect to postgres DB and show the server version (full string and psql -U myuser-d mydb -h localhost Password for user myuser: mydb=# SELECT VERSION(); # output PostgreSQL 15.2 (Debian 15.2-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6)...
Business Name re-registration Opportunistic Businesses
Two Three examples of Australian businesses one Melbourne based, the other two in Sydney who scan the ASIC registry data and then send a notification letter via snail mail to renew a business name at a much inflated price. I tried to confirm the Registry company's...
Microsoft on an M1 Macbook Pro
I have a Microsoft Partner Action Pack Benefit which includes licenses to Microsoft Operating System licenses. Included is Windows 10 and 11 Pro on the ARM architecture Next step is paying a $99USD upgrade from VMWare Fusion Pro 12.x to 13.x which will run arm64...
App Center screen appears when logging into a computer with a gigabyte motherboard
Recently I joined a domain on my Windows 11 Pro PC which has a Gigabyte AC520I motherboard Since then everytime I logged in I saw an "App center" dialog box I couldn't close it from the GUI but could if I opened Task Manager and end tasked the "Gigabyte Download...
Stop Synology warning low disk space at 20% FREE SPACE
If you have a Synology NAS with 10TB and you get a warning of low disk space at 2TB remaining here is how to change the Low Capacity Notification Low Capacity Email Notification sent from a Synology NAS as seen on a Outlook for Mobile on Android Open Storage Manager...
Yesterday I Installed Arch Linux Now I feel the urge to grow a Kneck Beard
I have either tried or used in production Caldera, Redhat, CentOS, Debian, Mint, Ubuntu,Fedora,Suse and others but until now not Arch. So yesterday I installed Arch Linux in Hyper-V on Windows 11 Pro I can't remember all the steps but here are the high points Hyper-V...
Use TCPDUMP to view DHCP Traffic
tcpdump -i ens160 port 67 or port 68 -e -n -vv
Connecting to A Cisco ROUTER via SSH on WIndows 11
I got the following when trying to connect via SSH Unable to negotiate with 10.19.53.1 port 22: no matching key exchange method found. Their offer: diffie-hellman-group-exchange-sha1,diffie-hellman-group14-sha1 # fix ssh -oKexAlgorithms=+diffie-hellman-group14-sha1...
Cisco iterm2
I am using UGREEN USB to RJ45 Console Cable 1.5m 50773 It appears as the following under MacBook Pro Ventura 13.1 System Report. Create a new iterm Profile and use screen command as follows. screen /dev/cu.usbserial-AK08RSIW -f...
Can the OpenVPN Connect client be run as a non-admin user?
Yes! https://openvpn.net/client-connect-vpn-for-windows/ Deploy the OpenVPN Connect client as an Administrator Supply the user with an "inline" .ovpn file. Get them to open the app and import it. They can then connect as a standard user. Tested on versions 3.3.6 and...
Fedora Live ISO boots to Start PXE over IPv4 in Hyper-V
.\systeminfo Host Name: TGN-WS-01 OS Name: Microsoft Windows 11 Pro OS Version: 10.0.22621 N/A Build 22621 OS Manufacturer: Microsoft Corporation OS Configuration: Standalone Workstation OS Build Type: Multiprocessor Free Registered Organization: N/A Product ID:...
Cannot Load an Elegant Themes Layout to New NGINX / PHP-FPM Website
2023/02/24 00:01:59 [error] 7874#7874: *189 client intended to send too large body: 1969615 bytes, client: 110.174.134.221, server: www.test.toggen.com.au, request: "POST /wp-admin/admin-ajax.php HTTP/2.0", host: "www.test.toggen.com.au"...
PFSense WebConfigurator SSL Cert Expired when using auto-renewing Let’s Encrypt Certificate
Problem: When connecting to a pfsense firewall webConfigurator (admin page) configured to use Let's Encrypt certificates you find the certificate is expired. Cause: The webConfigurator site was not restared when the certificate was renewed Resolution: Configure the...
Connecting to Ancient Network Kit with SSH under Ubuntu 22.04
Just tried to connect to a couple of old Cisco Switches from Ubuntu 22.04 lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 22.04.2 LTS Release: 22.04 Codename: jammy The Problem - (I think this is a WS-C2960X) ssh 10.11.12.13 #...