Correct method to deploy a site to AWS and connect to RDS

First of all - thanks to George and the crew for this fine product.

Please excuse my ignorance, but I’ve tried to find a solution by viewing other users’ questions and Wappler’s tutorials. Unfortunately I’m stuck, so hopefully someone from within the Wappler community can point me in the right direction.

The Good

I have a localhost site which uses a remote mysql database on a shared hosting service. This works just fine. (Note, all my queries are based on the one Server Connect Connection, not a Direct Database Connection.)

Next, I set up an RDS instance on my free AWS account and imported the database into here. Using my database software (Navicat), I can see that it’s set up correctly.

I then deployed my site via docker remote to my AWS account, following this tutorial: https://docs.wappler.io/t/setup-aws-hosting-with-docker/23867. It correctly set up a new EC2 server.

The Not So Good

Unfortunately the site’s pages won’t load any dynamic data. So I’ve obviously got a fundamental problem with the way the EC2 server connects to the RDS instance.

I have made sure security levels are publicly accessible, as well as including all the correct RDS connection parameters within Wappler’s Project Settings for my remote target.

So my question is this:

Have I gone about this the correct way? Or is there an alternative method for me to deploy my site and database to AWS? Also, should I be using a Direct Database Connection?

Cheers,

Peter
Melbourne, Australia