Google Cloud SQL on App Engine - Connection String Outdated?

[lennrt]

Issue description

In the readme for this driver, the connection string for connecting to Google Cloud SQL on App Engine is given as:

user@cloudsql(project-id:instance-name)/dbname

While Google's cloudsql package documentation also affirms this for your driver, there are posts on Stack Overflow such as this one which claim that one needs to use projectid:regionname:instancename rather than projectid:instancename.

What is the correct connection string? Neither of these is currently working.

Example code

A more detailed post can be found here: http://stackoverflow.com/questions/39668672/trouble-connecting-to-google-cloud-sql-server-from-deployed-app

Error log

My server is returning a 500 response whenever I make a call to an endpoint that uses the Cloud SQL database. The database connection works fine when I am connecting to the server from a locally served version of my app.

I have tried a variety of connection strings, and here are some errors that were logged in the Google Cloud Console:

5447 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.

5447 [Warning] entry 'root'@'localhost' in mysql.user is ignored because it duplicates entry in mysql.system_user

14409 [Note] Aborted connection 14409 to db: 'User' user: 'root' host: 'xxx.xxx.xxx.xxx' (Got an error reading communication packets)

(No password was specified in the connection string because the documentation does not specify the need for a password. This post mentions that the connection password must be null when the app attempts to connect to the server using root@localhost.)

6170 [Note] Access denied for user 'root'@'cloudsqlproxy~xx.xxx.xxx.xx' (using password: NO) 

I also tried connecting with a user other than the root user (username: newuser):

5447 [Warning] 'user' entry 'newuser@localhost' ignored in --skip-name-resolve mode.

Configuration

Driver version (or git SHA): https://github.com/go-sql-driver/mysql/tree/3654d25ec346ee8ce71a68431025458d52a38ac0

Go version: go version go1.6.2 linux/amd64

Server version: The Google Cloud SQL instance is running MySQL 5.7

Server OS: From the Compute Engine tab, it looks like the server hosting the most recent version of my app is running Debian 7.11 (Wheezy)

[pjebs]

user@cloudsql(project-id:instance-name)/dbname
Is the old one. It still works because I still use it.

Recently gae started categorising the database into regions too hence the new format. If your cloudsql is categorised into a region, you'll need to use the new format

[pjebs]

Perhaps this driver doesn't properly parse the new format. That may be the issue

[lennrt]

In your case, are you running a second generation Cloud SQL server?

[pjebs]

No first gen

[pjebs]

I suspect the driver isn't parsing the new format. The code may need to change so that it takes the content before first colon and the content after first colon irrespective of the new colon present

[pjebs]

There is a pull request currently updating read me

[lennrt]

Thanks for the heads up. I just left a comment on that PR.
As a temporary workaround I will set up a first generation server until the driver issue is fixed.

[lennrt]

Update: It looks like there is an issue with the driver when a deployed Google App Engine application tries to connect to a second generation Google Cloud SQL Server.

I created a first generation Cloud SQL Server and I was able to successfully connect to the server using a deployed Google App Engine application with this connection string:

user@cloudsql(project-id:instance-name)/dbname

No region name was required.

[arnehormann]

Parsing shouldn't be a problem, the driver takes everything between the parens: https://github.com/go-sql-driver/mysql/blob/master/dsn.go#L282
It's only used in https://github.com/go-sql-driver/mysql/blob/master/driver.go#L65

Can someone with a cloudsql account please download the driver, edit https://github.com/go-sql-driver/mysql/blob/master/appengine.go#L14 and replace "appengine/cloudsql" with "google.golang.org/appengine/cloudsql", try it with the old and new version with and without the region and report what works? Thanks!

[benguild]

_Guys, for reference:_
The Google provided solution to connecting to 2nd generation is here:
http://stackoverflow.com/questions/38890022/tls-requested-but-server-does-not-support-tls-error-with-google-cloud-sql-2nd

Google's posted documentation was (and perhaps still is) wrong, but the correct solution is posted there. We're using 2nd generation Cloud SQL in production without issue.