Ah man MariaDB (or MySQL cool person version) is up and running, finally, in a Proxmox VM. I tried a couple times in an LXC container but man, no thank you. Let’s just stick it in a VM (minimal performance loss it’s fiiine). I’m giving it 1 CPU, 2G of mem, and 32G disk space. We’ll see how that goes. I think it’ll be fine if it’s minimally used.

Mariadb image

Long story short, what a huge PITA only to find out there was a little bit of SQL that allowed remote hosts to actually connect.

UPDATE mysql.user SET HOST='%' WHERE User='ghost';
select User, Host FROM mysql.user;

Short story long, this all started because I wanted to run “Ghost”. If you don’t know, Ghost is an application that allows one to blog similarly to Medium, with seemingly the option to pay someone for their post? Idk tbh that’s kind of dumb but it seemed like a really nice, smooth structure to allow for easy blogging (though, if you’re here, you’re seeing that I’m just using a Hugo server with a nice theme thanks hello-friend-ng).

The command I wrote above simply sets the HOST that the user “Ghost” can connect from to be %, which is apparently just any host.

I trust my local network enough, there isn’t a way for an external host to connect to my mariadb without being inside my network. If they’re inside already, I’m screwed and it’s fiiiine.

Alright well the MariaDB instance is running, and I can connect to it, and the Ghost K8s pod can connect to it, but does it work through my Traefik load balancer? NOPE, NO IT DOES NOT.

Will continue somewhere down the line.

See ya next time.