phpMyAdmin and CentOS and EC2 and RDS – fixed!

If you’re reading this and it matters to you.  I’m about to save you hours of go-nowhere research.  Nowhere else have i found the solution.  So here you go world.

I can describe the problem as this:  PHPMyAdmin apparently won’t work under Amazon’s EC2 instance of CentOS using RDS or some other TCP based SQL connection.

Maybe the problem description is too general in some places, and maybe too specific in others.  However, if you’ve “tried everything” and phpMyAdmin still won’t work for you, this is it.

Contine reading

Mail In a Box on EC2 with S3 backup script

I wanted to break free and set up my own email server on Amazon’s AWS cloud. After signing up for a one year free trial, creating my mailinabox server on a T2 Micro instance with Ubunut 14.04LTS, getting the externally hosted DNS settings up and running, and testing OK, it was now time to focus my attention on backing up our email. Amazon’s free tier provides you with 5GB of free S3 storage, which is more than enough to keep and restore the emails on the server i wish to retain. Here’s the procedure I used.

Contine reading