IT Tips

PGAdmin4 on M1 Mac fails to connect

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

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

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

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