Re: [google-appengine] Re: Second gen GAE Python 3.7 > Cloud SQL - MySQL

[Eric G]

No problem, thanks for your work.

On Monday, September 17, 2018 at 11:47:22 AM UTC-4, Steren Giannini wrote:
>
> Hi,
> Yes GAE second generation expose a /cloudsql socket to access Cloud SQL. 
> Sorry about the lack of docs, we are in the process of (better) documenting 
> it.
>
> Steren
> Product Manager
>
> On Sun, Sep 16, 2018 at 7:11 AM rahulrv via Google App Engine <
> google-a...@googlegroups.com > wrote:
>
>> You should be able to use any library which works with mysql or postgres 
>> to connect using the unix socket /cloudsql/
>>
>>
>> On Wednesday, September 12, 2018 at 8:00:08 AM UTC-7, Eric G wrote:
>>>
>>> Thanks for this. The second link is to the flex environment 
>>> documentation. Are you saying that App Engine standard 2nd gen uses the 
>>> same method of connecting to CloudSQL instances as flex, i.e. via the unix 
>>> socket  /cloudsql/INSTANCE_CONNECTION_NAME ?  If so, it would be 
>>> helpful to have those instructions/example on the first link (to standard 
>>> 2nd gen) as well.
>>>
>>> Personally, I would like to see an example that doesn't depend on 
>>> SQLAlchemy + Flask, otherwise people may think they have to use those. I 
>>> guess it's not hard to figure out but just some acknowledgement that you 
>>> can set your own environment variables and manually use them to connect 
>>> with pymysql or whatever adapter.
>>>
>>>
>>> On Tuesday, September 11, 2018 at 11:22:24 PM UTC-4, Olu wrote:

 There are different ways to connect to the CloudSQL instance depending 
 on the location from where you are connecting. If you are connecting from 
 an App Engine instance which is located in a project which is different 
 from the project which the CloudSQL instance resides, you must use a 
 service account to allow connection between the App Engine application and 
 the Cloud SQL as described in the link 
 
 .

 However, when connecting from your App Engine Application within the 
 same project, you simply have to configure your app.yaml with the user, 
 password, database, and instance connection name variables from Cloud SQL, 
 See the documentation 
 
 . 

 External applications have to connect to the Cloud SQL instances 
 directly through the public IP address and the IP addresses of the 
 connecting application have to be white listed in the Cloud SQL instance 
 on 
 the Authorization Tab of the Instance page.


 -- 
>> 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 google-appengi...@googlegroups.com .
>> To post to this group, send email to google-a...@googlegroups.com 
>> .
>> 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/469db80a-f980-4468-b56e-138eb5b6e731%40googlegroups.com
>>  
>> 
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
>

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
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/89e99ac8-bb12-415c-906a-db9935671325%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-appengine] Re: Second gen GAE Python 3.7 > Cloud SQL - MySQL

['Steren Giannini' via Google App Engine]

Hi,
Yes GAE second generation expose a /cloudsql socket to access Cloud SQL.
Sorry about the lack of docs, we are in the process of (better) documenting
it.

Steren
Product Manager

On Sun, Sep 16, 2018 at 7:11 AM rahulrv via Google App Engine <
google-appengine@googlegroups.com> wrote:

> You should be able to use any library which works with mysql or postgres
> to connect using the unix socket /cloudsql/
>
>
> On Wednesday, September 12, 2018 at 8:00:08 AM UTC-7, Eric G wrote:
>>
>> Thanks for this. The second link is to the flex environment
>> documentation. Are you saying that App Engine standard 2nd gen uses the
>> same method of connecting to CloudSQL instances as flex, i.e. via the unix
>> socket  /cloudsql/INSTANCE_CONNECTION_NAME ?  If so, it would be helpful
>> to have those instructions/example on the first link (to standard 2nd gen)
>> as well.
>>
>> Personally, I would like to see an example that doesn't depend on
>> SQLAlchemy + Flask, otherwise people may think they have to use those. I
>> guess it's not hard to figure out but just some acknowledgement that you
>> can set your own environment variables and manually use them to connect
>> with pymysql or whatever adapter.
>>
>>
>> On Tuesday, September 11, 2018 at 11:22:24 PM UTC-4, Olu wrote:
>>>
>>> There are different ways to connect to the CloudSQL instance depending
>>> on the location from where you are connecting. If you are connecting from
>>> an App Engine instance which is located in a project which is different
>>> from the project which the CloudSQL instance resides, you must use a
>>> service account to allow connection between the App Engine application and
>>> the Cloud SQL as described in the link
>>> 
>>> .
>>>
>>> However, when connecting from your App Engine Application within the
>>> same project, you simply have to configure your app.yaml with the user,
>>> password, database, and instance connection name variables from Cloud SQL,
>>> See the documentation
>>> 
>>> .
>>>
>>> External applications have to connect to the Cloud SQL instances
>>> directly through the public IP address and the IP addresses of the
>>> connecting application have to be white listed in the Cloud SQL instance on
>>> the Authorization Tab of the Instance page.
>>>
>>>
>>> --
> 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 google-appengine+unsubscr...@googlegroups.com.
> To post to this group, send email to google-appengine@googlegroups.com.
> 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/469db80a-f980-4468-b56e-138eb5b6e731%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
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/CANHKq5FayctViUR8hJr1NtnHD-NYg%2BL5wZq%3DYA1fxwbEu%3Dptxg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Re: Second gen GAE Python 3.7 > Cloud SQL - MySQL

[rahulrv via Google App Engine]

You should be able to use any library which works with mysql or postgres to 
connect using the unix socket /cloudsql/

On Wednesday, September 12, 2018 at 8:00:08 AM UTC-7, Eric G wrote:
>
> Thanks for this. The second link is to the flex environment documentation. 
> Are you saying that App Engine standard 2nd gen uses the same method of 
> connecting to CloudSQL instances as flex, i.e. via the unix socket  
> /cloudsql/INSTANCE_CONNECTION_NAME ?  If so, it would be helpful to have 
> those instructions/example on the first link (to standard 2nd gen) as well.
>
> Personally, I would like to see an example that doesn't depend on 
> SQLAlchemy + Flask, otherwise people may think they have to use those. I 
> guess it's not hard to figure out but just some acknowledgement that you 
> can set your own environment variables and manually use them to connect 
> with pymysql or whatever adapter.
>
>
> On Tuesday, September 11, 2018 at 11:22:24 PM UTC-4, Olu wrote:
>>
>> There are different ways to connect to the CloudSQL instance depending on 
>> the location from where you are connecting. If you are connecting from an 
>> App Engine instance which is located in a project which is different from 
>> the project which the CloudSQL instance resides, you must use a service 
>> account to allow connection between the App Engine application and the 
>> Cloud SQL as described in the link 
>> 
>> .
>>
>> However, when connecting from your App Engine Application within the same 
>> project, you simply have to configure your app.yaml with the user, 
>> password, database, and instance connection name variables from Cloud SQL, 
>> See the documentation 
>> 
>> . 
>>
>> External applications have to connect to the Cloud SQL instances directly 
>> through the public IP address and the IP addresses of the connecting 
>> application have to be white listed in the Cloud SQL instance on the 
>> Authorization Tab of the Instance page.
>>
>>
>>

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
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/469db80a-f980-4468-b56e-138eb5b6e731%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Re: Second gen GAE Python 3.7 > Cloud SQL - MySQL

[Eric G]

Thanks for this. The second link is to the flex environment documentation. 
Are you saying that App Engine standard 2nd gen uses the same method of 
connecting to CloudSQL instances as flex, i.e. via the unix socket  
/cloudsql/INSTANCE_CONNECTION_NAME ?  If so, it would be helpful to have 
those instructions/example on the first link (to standard 2nd gen) as well.

Personally, I would like to see an example that doesn't depend on 
SQLAlchemy + Flask, otherwise people may think they have to use those. I 
guess it's not hard to figure out but just some acknowledgement that you 
can set your own environment variables and manually use them to connect 
with pymysql or whatever adapter.


On Tuesday, September 11, 2018 at 11:22:24 PM UTC-4, Olu wrote:
>
> There are different ways to connect to the CloudSQL instance depending on 
> the location from where you are connecting. If you are connecting from an 
> App Engine instance which is located in a project which is different from 
> the project which the CloudSQL instance resides, you must use a service 
> account to allow connection between the App Engine application and the 
> Cloud SQL as described in the link 
> 
> .
>
> However, when connecting from your App Engine Application within the same 
> project, you simply have to configure your app.yaml with the user, 
> password, database, and instance connection name variables from Cloud SQL, 
> See the documentation 
> 
> . 
>
> External applications have to connect to the Cloud SQL instances directly 
> through the public IP address and the IP addresses of the connecting 
> application have to be white listed in the Cloud SQL instance on the 
> Authorization Tab of the Instance page.
>
>
>

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
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/ee4e12f4-14f7-4373-863e-65b9ab34435c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Re: Second gen GAE Python 3.7 > Cloud SQL - MySQL

['Olu' via Google App Engine]

There are different ways to connect to the CloudSQL instance depending on 
the location from where you are connecting. If you are connecting from an 
App Engine instance which is located in a project which is different from 
the project which the CloudSQL instance resides, you must use a service 
account to allow connection between the App Engine application and the 
Cloud SQL as described in the link 

.

However, when connecting from your App Engine Application within the same 
project, you simply have to configure your app.yaml with the user, 
password, database, and instance connection name variables from Cloud SQL, 
See the documentation 

. 

External applications have to connect to the Cloud SQL instances directly 
through the public IP address 
<[3]https://cloud.google.com/sql/docs/mysql/connect-external-app#appaccessIP> 
and 
the IP addresses of the connecting application have to be white listed in 
the Cloud SQL instance on the Authorization Tab of the Instance page.


-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
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/cf94cce5-1f21-457b-b9b9-7e13a6f8dd73%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.