Re: Getting django.db.utils.OperationalError: (2005, "Unknown MySQL server host error with AWS

[prateek gupta]

Thanks, I will verify.

On Friday, June 15, 2018 at 7:55:10 PM UTC+5:30, Andréas Kühne wrote:
>
> As Jason stated you probably have an issue with security groups. Make sure 
> that your EC2 instance is in a security group that can access the mysql 
> server. Otherwise you won't be able to connect. And the error you have is 
> what you get when the security groups aren't correct.
>
> See here:
>
> https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/TUT_WebAppWithRDS.html
>
> Regards,
>
> Andréas
>
> 2018-06-15 15:11 GMT+02:00 Jason >:
>
>> have you checked your security settings in the aws console to make sure 
>> the port is open?
>>
>> also have you seen https://stackoverflow.com/a/45792248/214892
>>
>> -- 
>> You received this message because you are subscribed to the Google Groups 
>> "Django users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to django-users...@googlegroups.com .
>> To post to this group, send email to django...@googlegroups.com 
>> .
>> Visit this group at https://groups.google.com/group/django-users.
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/django-users/ff00ed62-d489-42b7-90de-a835e4f57da2%40googlegroups.com
>>  
>> 
>> .
>>
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/f5afb193-5ba0-4db2-907c-a1eba457a522%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Getting django.db.utils.OperationalError: (2005, "Unknown MySQL server host error with AWS

[prateek gupta]

Thanks Json, I will check this.

On Friday, June 15, 2018 at 6:41:42 PM UTC+5:30, Jason wrote:
>
> have you checked your security settings in the aws console to make sure 
> the port is open?
>
> also have you seen https://stackoverflow.com/a/45792248/214892
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/568b8f4f-5f07-4745-a72f-2652e8b7832b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Getting django.db.utils.OperationalError: (2005, "Unknown MySQL server host error with AWS

[Andréas Kühne]

As Jason stated you probably have an issue with security groups. Make sure
that your EC2 instance is in a security group that can access the mysql
server. Otherwise you won't be able to connect. And the error you have is
what you get when the security groups aren't correct.

See here:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/TUT_WebAppWithRDS.html

Regards,

Andréas

2018-06-15 15:11 GMT+02:00 Jason :

> have you checked your security settings in the aws console to make sure
> the port is open?
>
> also have you seen https://stackoverflow.com/a/45792248/214892
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To post to this group, send email to django-users@googlegroups.com.
> Visit this group at https://groups.google.com/group/django-users.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/django-users/ff00ed62-d489-42b7-90de-a835e4f57da2%40googlegroups.com
> 
> .
>
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CAK4qSCd1tNmwex0ezLoLDANWPdtiyozswtA-LxWdNXx45JrU8w%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: Getting django.db.utils.OperationalError: (2005, "Unknown MySQL server host error with AWS

[Jason]

have you checked your security settings in the aws console to make sure the 
port is open?

also have you seen https://stackoverflow.com/a/45792248/214892

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/ff00ed62-d489-42b7-90de-a835e4f57da2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Getting django.db.utils.OperationalError: (2005, "Unknown MySQL server host error with AWS

[prateek gupta]

Hi All,

I am trying to connect with AWS and when I run the server I get following 
error-
django.db.utils.OperationalError: (2005, "Unknown MySQL server 
host 'psdbuat.chmnxeoa2hhd.ap-southeast-1.rds.amazonaws.com' (0)")

I checked the connection in mysql workbench and details are fine.
My settings.py is as below-

DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'myschema',
'USER': 'admin',
'PASSWORD': 'aadmin',
'HOST': 'psdbuat.chmnxeoa2hhd.ap-southeast-1.rds.amazonaws.com',
'PORT': '3306',
}
}


I googled and found it is issue with AWS but did not find any solution.

Can anyone please share teh solution for it?

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/5558daa2-89c7-44aa-9553-a5441e904b71%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.