Trying to connect PGAdmin 4 (pgadmin4-7.2-x86_64.dmg) on an M1 Macbook to a remote Postgres server using SSH tunnelling and SSH username/password auth and you get: Unable to connect to server: Failed to decrypt the SSH tunnel password. Error: 'ServerManager' object...
IT Tips
Turn XDebug Off in a Powershell Terminal
To turn off Xdebug in a Powershell terminal $env:XDEBUG_MODE = "off" To turn on Xdebug in a Powershell terminal $env:XDEBUG_MODE = "off" Windows 11 VSCode Terminal: XDebug output and then without when XDEBUG_MODE = "off"
Aruba APIN0305 Default Password
After a factory reset In the username section, enter 'admin.' In the password section, enter the serial number of your AP in uppercase. From here: https://info.pivitglobal.com/resources/aruba-ap-305-login-issues
NGINX + PHP-CGI + MYSQL On Windows 11
This is my setup to serve CakePHP from a virtual subdirectory on Windows 11 where http://localhost/subdir/ points to C:/dev/cake_test/webroot/ Run Terminal as Administrator then: Install chocolatey https://chocolatey.org/install Install MySQL, PHP and Nginx using...
CakePHP 4 + VSCode + DebugKit SETUP
There are three configurations this post covers Local Development Use the default if working locally If you are using CakePHP 4 and developing on the local file system (straight from Windows) use this: Debugger::setEditor('vscode'); If your project is in...
Postgres restore COPY Error
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...
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...