Unable to access Google Cloud SQL instance in dev_appserver with Django

Question

I recently updated my GAE SDK and soon after the update, it has started acting up. I am using Google Cloud SQL in backend with Django 1.4.3. On my local dev server, it gives the following error :

No valid OAuth 2.0 credentials. Before using the Google SQL Service backend on dev_appserver, you must first run "manage.py syncdb" and proceed through the given instructions to fetch an OAuth 2.0 token.

I have tried removing cacert.txt as well as removing google sql authentication from my home directory to re-obtain authentication via running python manage.py syncdb, but it does not help.

The same question has been raise here with a "patch" provided:

http://code.google.com/p/googleappengine/issues/detail?id=9006

I tried changing my server.py as per the patch. But no effect.

Any help ?

Is there a file ~/.googlesql_oauth2.dat as described in Django Support (developers.google.com/appengine/docs/python/cloud-sql/django) — Lee
– Lee, Commented Jul 13, 2014 at 1:05

Peter · Accepted Answer · 2014-09-07 20:09:06Z

1

I had the same problem, and this solved it for me:

copy the refresh_token from the google oauth .dat json file
added in app.yaml:

env_variables: GOOGLE_SQL_OAUTH2_REFRESH_TOKEN: "here the copied token"

answered Sep 7, 2014 at 20:09

Peter

1,81820 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

Unable to access Google Cloud SQL instance in dev_appserver with Django

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related