Bobcares

Connectivity issues between ECS tasks and the RDS database

PDF Header PDF Footer

Wondering how to fix connectivity issues between ECS tasks and RDS database? We can help you with this!

As a part of our AWS Support Services, we often receive similar requests from our AWS customers.

Today, let’s see the steps followed by our Support Techs to help our customers to fix the connectivity issues between ECS tasks and RDS database.

 

Connectivity issues between ECS tasks and RDS database

 

At first we need to check and verify the the network configuration and then we should verify the database connection parameters.
 

Check and verify network configuration

 
Let’s see the steps to verify if a Linux/Windows based container instance can establish a connection to the database.
 

Windows based container instance

 

1. We can use RDP to connect to the container instance where the task is placed.

2. Run the following telnet command to connect to the RDS database using Windows command prompt or Windows PowerShell:

$ telnet test.xy98cde7fg6.us-west-1.rds.amazonaws.com 3306

Note that we need to replace test.xy98cde7fg6.us-west-1.rds.amazonaws.com and the port 3306 with the database endpoint and database port respectively.

If the command results a blank page, it means the connection is established.

We will receive Connection Timed Out errors if the connection isn’t established.

Then we need to follow the below steps:

1. We need to check that the attached security groups allow access to the RDS database. We can use the Description tab for the selected instance in the EC2 console.

It is always better to create a security group that allows incoming traffic from the database port. Then, attach the security group to the database and container instance.

2. Then we should check if the network ACL and route table associated with the subnet allow access to the database.
 

Linux based container instance

 

1. Firstly, We can use SSH to connect to the container instance where the task is placed.

2. Then we need to run the following telnet command to connect to the RDS database

$ telnet test.xy98cde7fg6.us-west-1.rds.amazonaws.com 3306

Note that we need to replace test.xy98cde7fg6.us-west-1.rds.amazonaws.com and the port 3306 with the database endpoint and database port respectively.

For example, the output of the above telnet command gives the following result:

Trying 172.32.112.27
> Connected to test.xy98cde7fg6.us-west-1.rds.amazonaws.com
> Escape character is '^]'.

 

Check and verify the database connection parameters

 
Now let’s see the the steps to check and verify the RDS database connection parameters:

  1. Firstly, we need to securely pass the sensitive information like database endpoint, database port, and database access credentials as environment variables in the the environment section of container definition.

2. If this establish a connection with the database, but unable to authenticate due to incorrect parameters like database user name or password, then we need to reset the password.

3. Remove if any character spaces that in front or back of our connection parameters.

[Need help with more AWS queries? We’d be happy to assist]
 

Conclusion

 
To conclude, today we discussed the steps followed by our Support Engineers to help our customers to fix the connectivity issues between ECS tasks and RDS database.

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

GET STARTED

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

server management

Spend time on your business, not on your servers.

TALK TO US

Or click here to learn more.

Speed issues driving customers away?
We’ve got your back!

Privacy Preference Center

Necessary

Necessary cookies help make a website usable by enabling basic functions like page navigation and access to secure areas of the website. The website cannot function properly without these cookies.

PHPSESSID - Preserves user session state across page requests.

gdpr[consent_types] - Used to store user consents.

gdpr[allowed_cookies] - Used to store user allowed cookies.

PHPSESSID, gdpr[consent_types], gdpr[allowed_cookies]
PHPSESSID
WHMCSpKDlPzh2chML

Statistics

Statistic cookies help website owners to understand how visitors interact with websites by collecting and reporting information anonymously.

_ga - Preserves user session state across page requests.

_gat - Used by Google Analytics to throttle request rate

_gid - Registers a unique ID that is used to generate statistical data on how you use the website.

smartlookCookie - Used to collect user device and location information of the site visitors to improve the websites User Experience.

_ga, _gat, _gid
_ga, _gat, _gid
smartlookCookie
_clck, _clsk, CLID, ANONCHK, MR, MUID, SM

Marketing

Marketing cookies are used to track visitors across websites. The intention is to display ads that are relevant and engaging for the individual user and thereby more valuable for publishers and third party advertisers.

IDE - Used by Google DoubleClick to register and report the website user's actions after viewing or clicking one of the advertiser's ads with the purpose of measuring the efficacy of an ad and to present targeted ads to the user.

test_cookie - Used to check if the user's browser supports cookies.

1P_JAR - Google cookie. These cookies are used to collect website statistics and track conversion rates.

NID - Registers a unique ID that identifies a returning user's device. The ID is used for serving ads that are most relevant to the user.

DV - Google ad personalisation

_reb2bgeo - The visitor's geographical location

_reb2bloaded - Whether or not the script loaded for the visitor

_reb2bref - The referring URL for the visit

_reb2bsessionID - The visitor's RB2B session ID

_reb2buid - The visitor's RB2B user ID

IDE, test_cookie, 1P_JAR, NID, DV, NID
IDE, test_cookie
1P_JAR, NID, DV
NID
hblid
_reb2bgeo, _reb2bloaded, _reb2bref, _reb2bsessionID, _reb2buid

Security

These are essential site cookies, used by the google reCAPTCHA. These cookies use an unique identifier to verify if a visitor is human or a bot.

SID, APISID, HSID, NID, PREF
SID, APISID, HSID, NID, PREF