Hi Tas,
I made the smae mistake and I spent some time solving it: in app.yaml file,
database connection name needs to be in strings like this:
beta_settings:
cloud_sql_instances: 'cm-platform-01:europe-west1:cm-db-develop'
I wrote recently blog post about running GAE Flex and Django, maybe some of
it will be helpful to
you. https://www.the-swamp.info/blog/google-app-engine-flexible/
Zdenko
On Wednesday, April 12, 2017 at 8:33:53 PM UTC+2, Tas Sóti wrote:
>
> Hello George,
>
> Thank you for the quick response. I was following the Running Django in
> the App Engine Flexible Environment
> <https://cloud.google.com/python/django/flexible-environment> tutorial
> and it does not say anything about the SQLALCHEMY_DATABASE_URI environment
> variable. Is it not meant for SQLAlchemy only? I am using Django's ORM. I
> actually have another instance running with the same app.yaml as described
> above and it is working. The difference is that that project (including
> both the App Engine and SQL instance) is in the us-central region and I
> deployed it a couple of months ago, when the App Engine Flexible was still
> in beta.
>
> So is now the SQLALCHEMY_DATABASE_URI variable meant for using with the
> Django ORM, too, and the old beta_settings is deprecated?
> I'll give it a try, it is just not very logical (at least for me), why the
> variable name includes "SQLAlchemy" if it is meant for any kind of
> python<->sql connection.
>
> Thank you in advance,
> Tas
>
> On Wednesday, April 12, 2017 at 8:08:24 PM UTC+2, George (Cloud Platform
> Support) wrote:
>>
>> Hello Tas,
>>
>> To allow your app to connect to your Cloud SQL instance when the app is
>> deployed, add the user, password, database, and instance connection name
>> variables from Cloud SQL to the related environment variables in the
>> app.yaml file:
>>
>> env_variables:
>>
>> # Replace user, password, database, and instance connection name with
>> the values obtained
>>
>> # when configuring your Cloud SQL instance.
>>
>> SQLALCHEMY_DATABASE_URI: >-
>>
>>
>>
>> mysql+pymysql://USER:PASSWORD@/DATABASE?unix_socket=/cloudsql/INSTANCE_CONNECTION_NAME
>>
>> It may be worthwhile to check in detail this information and the other
>> related steps in the “Using Cloud SQL for MySQL” document
>> <https://cloud.google.com/appengine/docs/flexible/python/using-cloud-sql>.
>> This solution, with relevant detail, is given in the “cloudsql databases
>> with django on 'new' flexible google app engine” question
>> <http://stackoverflow.com/questions/39034250/cloudsql-databases-with-django-on-new-flexible-google-app-engine>
>>
>> on Stackoverflow.
>>
>> The “Running Django in the App Engine Flexible Environment” documentation
>> page <https://cloud.google.com/python/django/flexible-environment> might
>> prove quite helpful for related details.
>>
>>
--
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/google-appengine.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-appengine/19c0cb7c-3894-4834-97ca-9d6718445aa9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
