The ramblings of a wannabe indiehacker!
Fixing "Authentication plugin 'caching_sha2_password' cannot be loaded" errors
As of MySQL 8.0, `caching_sha2_password` is now the default authentication plugin rather than `mysql_native_password` which was the default in previous versions. This means that clients (Sequel Pro, HeidiSQL etc) that rely on the `mysql_native_pa...
Connect to a private RDS instance using SSH & AWS SSM (Systems Manager)
You have an AWS RDS instance which is on a private subnet and therefore not publicly accessible and you wish to connect to this RDS instance remotely without installing a bastion server or having any public-facing ec2 instances.
What is an SSL certificate and why do I need one?
An SSL (Secure Socket Layer) certificate is a digital certificate used to provide a secure connection between a website and your web browser. Any information sent via this secure connection is only readable by you and the intended website. Does my...
Raw SQL from Doctrine Query Object – Revised
A few months ago I posted an article talking about how to get the raw SQL from a Doctrine Query Object but with the release of Symfony 1.3 and Symfony 1.4 it would appear that the code no longer works. As a result, I’ve updated the code to work w...