On 16 May 2010 19:25, bax...@gretschpages.com <mail.bax...@gmail.com> wrote:
> I know this is something stupid I'm missing, but I'm not getting it.
>
> I'm trying to run my Django from one cloud instance and the DB from
> another, to (hopefully) optimize each server for task and balance the
> load a bit.
>
> On the DB server, I have mysql installed and have a working database
> running on the default port 3306. I do not have a domain assigned to
> this server, only a raw IP.
>
> On the django side, I'm not sure what my settings should be to connect
> to it. So far, everything I've tried has resulted in
> _mysql_exceptions.OperationalError: (2005, "Unknown MySQL server host
> '< THE IP >' (1)")
>
> Settings.py looks like:
>
> DATABASES = {
> 'default': {
> 'ENGINE': 'django.db.backends.mysql',
> 'NAME': 'django',
> 'USER': '<MY USERNAME FOR THE DB>',
> 'PASSWORD': 'XXXXXXX',
> 'HOST': '< THE IP >',
> 'PORT': '3306',
> }
> }
>
> What am I missing?
Can you ping the db machine from the webserver?
Can you access the db machine from the webserver using a mysql client
such as Navicat or such like?
My 2p is on the db machine not having the right port open or denying
non-local connections.
HTH
Dan
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To post to this group, send email to django-us...@googlegroups.com.
> To unsubscribe from this group, send email to
> django-users+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/django-users?hl=en.
>
>
--
Dan Hilton
============================
www.twitter.com/danhilton
www.DanHilton.co.uk
============================
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
