Unable to connect aws RDS to django local

Question

I am trying to connect my local django application to amazon RDS (tried with both MySQL and PostgreSQL) but I am not able to connect as it shows the following errors, Currently seeking answer for PostgreSQL.

In my Settings.py:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'database_name',
        'USERNAME': 'my_username',
        'PASSWORD': 'my_password',
        'HOST': 'database-abc.xxx.us-region-yyy.rds.amazonaws.com',
        'PORT': '5432',
    }
}

In AWS database configuration:

I get this error:

django.db.utils.OperationalError: could not connect to server: Connection timed out (0x0000274C/10060)
Is the server running on host "database-abc.xxx.us-region-yyy.rds.amazonaws.com" (69.420.00.121) and accepting TCP/IP connections on port 5432?

I referred to all the available data but still am unable to resolve this issue!

Thanks in advance!

@Marcin My security group on rds is default VPC security group — Samyak Gupta, Jul 16 '21 at 09:19
Inbound Rules type is all traffic by default and source is custom, — Samyak Gupta, Jul 16 '21 at 10:47
I tried to edit inbound rules like specified in https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_VPC.Scenarios.html but it does not work still! — Samyak Gupta, Jul 16 '21 at 10:48
Are you able to connect with psql? Or maybe this question is already outdated? Did you found solution? — Alex Yu, Aug 06 '21 at 05:43
@Alex Yu I still have not found the solution and yes the problem exists with psql too! I am unable to connect with that too — Samyak Gupta, Aug 11 '21 at 01:00
@SamyakGupta First you need to ensure that connection is possble in principle. Use `psql` for that. Contact Amazon support if you can't. Then proceed to django — Alex Yu, Aug 11 '21 at 08:25
If you're still struggling check this https://stackoverflow.com/questions/16837806/cant-connect-to-rds-instance-from-ec2-instance — Kolo Safo, Oct 09 '22 at 20:35

score 2 · Answer 1 · answered Dec 07 '22 at 21:15

2

In the VPC security group go to inbound settings create a new rule with the Postgres connection type, not HTTP and make it available from every.

Note: don't forget to make accessibility to the database to be public.

answered Dec 07 '22 at 21:15

Mahmoud Nasser

805
3
16

Unable to connect aws RDS to django local

1 Answers1