Urgent help needed please! Google cloud SQL connection error

[Mohamed Karam]

Today, I started getting consistent " Failed to establish a database connection. Check connection string, username and password" when I try to connect to a Google cloud sql database. I am using the method Jdbc.getConnection. Everything was working jhust fine until yesterday. I tried authorizing all Google servers IP addresses, which didn't resolve the issue. Then I authorized  0.0.0.0/0, which should authorize all networks. Also, checked the release notes for cloud sql and couldn't find anything that may be causing the issue.

[Bauke de Kroon]

Hello Mohamed,

I had the same error message. I got this solved by using the Jdbc.getCloudSqlConnection method instead of Jdbc.getConnection. The Jdbc.getCloudSqlConnection is the recommended way as you don't have to authorise any Google server IPs. Hope this helps.

[Stephen Putman]

I'm having this same issue... I tried the Jdbc.getCloudSqlConnection, but have had no success so far.  All of cloud apps are shut down due to this.

[Stephen Putman]

I should note that I've so far been able to connect and run queries in the Google Cloud Shell and using mySQL Workbench

[gabriel...@thoughtworks.com]

Hi everyone, I'm facing the same issue.

Has anyone found out a solution?

[gabriel...@thoughtworks.com]

I just notice that there are some issues created on Google Issue Tracker:

https://issuetracker.google.com/issues/187750420
https://issuetracker.google.com/issues/187573928

[Stephen Putman]

I found appending the url with 

?useSSL=false

sovles the issue for now.

[Stephen Putman]

Hi Gabriel.  In Google Apps Script, it's the address to the database and table.  Example:

let dbUrl = 'jdbc:mysql://' + dbIpAddress + '/' + dbTable + '?useSSL=false';

  //ex:  jdbc:mysql://106.196.10.211/mytable?useSSL=false

let conn = Jdbc.getConnection(dbUrl, dbUser, dbPass);

On Tuesday, May 11, 2021 at 9:31:08 AM UTC-6 gabriel...@thoughtworks.com wrote:

Hi, Stephen.

Thank you. Which URL do you mean?

[gabriel...@thoughtworks.com]

Thank you Stephen!

[Stephen Putman]

👍 No problem... take care, Gabriel! 

[Stephen Putman]

I just wanted to share one more thing:   I've had problems with the speed of my apps lately.  When troubleshooting this morning, I noticed the performance of these apps improves greatly when I rolled them back from V8.  I'm refactoring all my apps today and dropping V8.