Error connecting Django to Google CloudSQL Postgres database in Google App Engine

Question

I'm evaluating using Google Cloud and Google App Engine for our company's new product. I'm trying to adapt this tutorial to use Postgres instead of MySQL:

https://cloud.google.com/python/django/flexible-environment

While I'm able to successfully connect to the database locally, when I try in production, I get the following 500 error:

OperationalError at /admin/login/
    could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/cloudsql/<project_name_hidden>:us-central1:<database_id_hidden>/.s.PGSQL.5432"?

To connect to Postgres, I made three changes to the sample project. I have this snippet in app.yaml:

beta_settings:
  cloud_sql_instances: <project_name_hidden>:us-central1:<database_id_hidden>

I have this snippet in settings.py:

# [START dbconfig]
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'polls',
        'USER': '<db_user_name_hidden>',
        'PASSWORD': '<db_password_hidden>',
        'PORT': '5432',
    }
}
# In the flexible environment, you connect to CloudSQL using a unix socket.
# Locally, you can use the CloudSQL proxy to proxy a localhost connection
# to the instance
DATABASES['default']['HOST'] = '/cloudsql/<project_name_hidden>:us-central1:<database_id_hidden>'
if os.getenv('GAE_INSTANCE'):
    pass
else:
    DATABASES['default']['HOST'] = '127.0.0.1'
# [END dbconfig]

and have this requirements.py:

Django==1.10.6
#mysqlclient==1.3.10
psycopg2==2.7.1
wheel==0.29.0
gunicorn==19.7.0

getting the same error. Haven't found any solution. I have created an issue on github: github.com/GoogleCloudPlatform/python-docs-samples/issues/870 — theguru42
– theguru42, Commented Mar 23, 2017 at 12:34

mathew · Accepted Answer · 2017-03-24 04:42:51Z

7

Never mind, seems like Google fixed something on their end and the service is working now. I'm trying to figure out what exactly changed...

answered Mar 24, 2017 at 4:42

mathew

9872 gold badges12 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nicko · Accepted Answer · 2018-08-05 15:35:11Z

0

I battled with this for hours and the only way to fix it was to create a new instance of Postgres. Brute force unfortunately, but it seems that sometimes instances on GCP can start off in a corrupt state and will never work.

answered Aug 5, 2018 at 15:35

Nicko

6694 silver badges8 bronze badges

Collectives™ on Stack Overflow

Error connecting Django to Google CloudSQL Postgres database in Google App Engine

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related