Configure database connection for AmazonRDS MySQL DB

Configure database connection for AmazonRDS MySQL DB

  

I'm trying to setup a database connection to an AmazonRDS MySQL database. I'm an experienced OutSystems user, just trying to test connecting to an RDS DB.

I have the connection setup in Service Center with server, userid, pw.

The RDS DB is restricted by IP address. I tried doing a ping for my test site (<myname>.outsystemscloud.com), then adding that IP in the RDS Security Group.

But that doesn't work, just gives me a timeout when I click on the 'test' button in the connection setup page in Service Center.

Is there a better way to get the proper IP address?


Hello Peter,

You are trying that with a personal environment right? That should be the correct address alright. Just have in mind that the IP address might change over time.

Dear Peter,


Is the instance public accessible? 

Click on RDS instance > modify > public Accessible: yes



Thanks for replying. I appreciate the support!

I realize the IP is not static, just doing a Proof of Concept.

Yes, its public accessible. I'm able to access it via MySql Workbench from home after adding my home IP to the RDS instance Security Groups. However, it doesn't seem to like my personal environment's IP address.


Solution

This was resolved by removing the port from the URL that is used in the "Server" field of the connection string.

Solution