My ghost installation is hosted on an AWS EC2 machine and connects to a remote RDS database. It’s currently using password authentication but I’d like to switch to IAM role-based authentication. I have configured everything correctly and I am able to connect from the command line on the EC2 machine to the RDS database the mysql client.
However, I don’t know the next steps for making ghost connect like this. I ran `ghost config database.connection.password $TOKEN to set the password to the AWS token. $TOKEN is a stored connection token that I have fetched from RDS. I then restart ghost and it complains:
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
I’d like to know is this something that is even possible with Ghost? Has anyone accomplished this before?