By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Lost connectivity to RDS

0

Hi I have a EC2 instance that is part of an elastic beanstalk setup. The instance runs a web server and a bespoke service I have created. They both connect to a RDS database.

Up until today all worked fine This morning the service has stopped resolving the IP of the database and I get a network connection error when running it in windows command prompt. The Webserver connects fine. Any ideas?

Thank you Mark

Topics
Compute
Tags
Windows
Language
English
MCFH
asked 2 years ago365 views
1 Answer
0

Have you changed the rules for RDS or EC2 security groups?
Have you changed the network ACL settings for the subnet you are using?

The following documents describe general troubleshooting methods, so please review them all from the top.
https://repost.aws/knowledge-center/rds-cannot-connect

What database are you using?
Depending on the database in use, there may be a setting that blocks the IP address after a certain number of failed connections.
For MySQL, this is "max_connect_errors".
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html

profile picture
EXPERT
Riku_Kobayashi
answered 2 years ago
profile picture
EXPERT
Hiroki Takahashi
reviewed 2 years ago
  • MCFH
    2 years ago

    Thanks - the strange thing is I haven't changed anything. Which is not to say Amazon has not of course. The database is SQL server and I can connect to it fine from outside AWS, from the webserver running on the VM, but not from the command prompt on that VM. I will have a look at the troubleshooting steps suggested

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content