James McDonald

Access

Blog History

Cisco Router Wake On Lan

Haven't confirmed this to work yet but leaving here so I have a reference for later In the Cisco enable prompt Router# tclsh proc WakeOnLan {broadcastAddr macAddr} { set net [binary format H* [join [split $macAddr -:] ""]] set pkt [binary format c* {0xff 0xff 0xff...

read more

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

read more

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

read more

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

read more

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

read more

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

read more