Verified
Status Update
No update yet.
Comments
bg...@hofmangroup.com
Getting the same error. Also, using Google Cloud SQL (MySQL).
Apps Script programs seem to connect just fine if the function is manually ran from a script. Functions called from a trigger or an Apps Script hosted webapp fail every time. Can also connect just fine from MySQL Workbench and other tools.
The Cloud SQL error log notes "Bad handshake"
Apps Script programs seem to connect just fine if the function is manually ran from a script. Functions called from a trigger or an Apps Script hosted webapp fail every time. Can also connect just fine from MySQL Workbench and other tools.
The Cloud SQL error log notes "Bad handshake"
ma...@article.com
I'm experiencing the same error. In my case the SQL instance is managed through AWS RDS. According to logs the issue began May 9, 2021.
On the AWS side, the error that comes through says "Got an error reading communication packets". I know that is quite vague. I'll report back if AWS support is able to retrieve any more information.
On the AWS side, the error that comes through says "Got an error reading communication packets". I know that is quite vague. I'll report back if AWS support is able to retrieve any more information.
da...@rockitcoin.com
I have the same issue connecting to Google Cloud SQL (MySQL). I previously had been getting this error when running in the new Script Editor (legacy editor worked fine).
Today I am unable to run ANY scripts in the legacy editor. If I move the scripts to Runtime V8 and use the NEW editor, the scripts run, but I get the SQL error.
This seems to be a problem with the migration to V8 and the new editor.
Today I am unable to run ANY scripts in the legacy editor. If I move the scripts to Runtime V8 and use the NEW editor, the scripts run, but I get the SQL error.
This seems to be a problem with the migration to V8 and the new editor.
bh...@shoot2sell.net
We are getting the same database connection error. No changes and everything was running fine till yesterday (mid-morning?). Today, all of them give us this error? Any suggested work-arounds?
We are connecting to mySQL database running on a Google Compute Engine via jdbc calls
We are connecting to mySQL database running on a Google Compute Engine via jdbc calls
r....@anasystems.co.jp
Comment has been deleted.
jt...@grupoelcerezo.com
Same error, can´t connect to MySql. I try to connect difente database but i can´t
"Failed to establish a database connection. Check connection string, username and password"
"Failed to establish a database connection. Check connection string, username and password"
ga...@google.com
Hi there!
Thank you for your report, this has been reported internally.
Many thanks!
ga...@google.com
jo...@rentokil-initial.com
Greetings,
//Please see example of code that produces the error:
var address = 'dbAddress';
var user = 'userCredentials';
var userPwd = 'userPassword';
var db = 'dbName';
var dbUrl = 'jdbc:mysql://' + address + '/' + db;
var conn = Jdbc.getConnection(dbUrl, user, userPwd);
Error: Failed to establish a database connection. Check connection string, username and password.
//Please see example of code that produces the error:
var address = 'dbAddress';
var user = 'userCredentials';
var userPwd = 'userPassword';
var db = 'dbName';
var dbUrl = 'jdbc:mysql://' + address + '/' + db;
var conn = Jdbc.getConnection(dbUrl, user, userPwd);
Error: Failed to establish a database connection. Check connection string, username and password.
[Deleted User] <[Deleted User]>
Hello,
We are in exactly the same situation...
Please let me know what should I do!
Thank you
We are in exactly the same situation...
Please let me know what should I do!
Thank you
jo...@rentokil-initial.com
Greetings,
This workaround seems to be stable. From Google's developer documentation:
https://developers.google.com/apps-script/guides/jdbc
// CloudSql connection name (located in GCP)
var connectionName = 'connectionName ';
var user = 'userCredentials';
var userPwd = 'userPwd';
var db = 'db';
var instanceUrl = 'jdbc:google:mysql://' + connectionName;
var dbUrl = instanceUrl + '/' + db;
var conn = Jdbc.getCloudSqlConnection(dbUrl, user, userPwd);
This workaround seems to be stable. From Google's developer documentation:
// CloudSql connection name (located in GCP)
var connectionName = 'connectionName ';
var user = 'userCredentials';
var userPwd = 'userPwd';
var db = 'db';
var instanceUrl = 'jdbc:google:mysql://' + connectionName;
var dbUrl = instanceUrl + '/' + db;
var conn = Jdbc.getCloudSqlConnection(dbUrl, user, userPwd);
lu...@nextories.com
Hi,
Same issue connecting to an AWS MySQL instance (MySQL 5.7).
It used to work fine before today, and I can successfully connect to the database via any other tool.
Let us know if you find any workaround, that not only works for Google Cloud :)
Thanks!
Same issue connecting to an AWS MySQL instance (MySQL 5.7).
It used to work fine before today, and I can successfully connect to the database via any other tool.
Let us know if you find any workaround, that not only works for Google Cloud :)
Thanks!
vf...@zalando.de
Same issue here. We have ben running smoothly for ages and issue started happening on May 10 and is now affecting almost all google sheets connected to our Cloud SQL instance
sa...@in.g4s.com
Hello,
Since today morning, we are also facing the same issue with the Cloud MySql connection, getting the message " Message: Failed to establish a database connection. Check connection string, username, and password. File: "
At the start, we were facing this issue with triggers but now the front end also got stuck.
Since today morning, we are also facing the same issue with the Cloud MySql connection, getting the message " Message: Failed to establish a database connection. Check connection string, username, and password. File: "
At the start, we were facing this issue with triggers but now the front end also got stuck.
al...@savings-united.com
Hey,
Same problem for us. All of our scripts crash with the same error. All the obvious checks made.
The connection is made successfully using third-party tools with the same connection data.
Thanks!
Same problem for us. All of our scripts crash with the same error. All the obvious checks made.
The connection is made successfully using third-party tools with the same connection data.
Thanks!
fe...@savings-united.com
Same issue, started yesterday.
Thank you
Thank you
la...@bondcliq.com
All our scripts with database connections are now failing. Yesterday was intermittent. This is really impacting our work now. Please escalate this right away. (And it is impacting so many other people)
ro...@gmail.com
I'm getting this error too. Started happening yesterday.
Scripts that have been running for years are now breaking with the error, "Exception: Failed to establish a database connection. Check connection string, username and password."
Can connect to the database without issue outside of Apps Script.
Scripts that have been running for years are now breaking with the error, "Exception: Failed to establish a database connection. Check connection string, username and password."
Can connect to the database without issue outside of Apps Script.
la...@bondcliq.com
I realize that the issue is Severity S2 and Priority P2. Please escalate this. Our business is completely impacted by this. We have business critical processes that depend on some app scripts connecting to the database.
As others are mentioning, we have been using these for years!
As others are mentioning, we have been using these for years!
ro...@gmail.com
I agree. This is critically affecting our business processes.
Please escalate this to P1 or higher. If using a non-Google SQL database, there is no workaround.
Please escalate this to P1 or higher. If using a non-Google SQL database, there is no workaround.
la...@bondcliq.com
Note that we are using a Google SQL using mySQL. Is there a workaround for this? I tried these and that did not help:
var instanceUrl = 'jdbc:google:mysql://' + connectionName;
var dbUrl = instanceUrl + '/' + db;
var conn = Jdbc.getCloudSqlConnection(dbUrl, user, userPwd);
PLEASE ESCALATE. Thanks
Note: Actually jdbc:goole seems to work now, as of 8:52 AM EST. Still checking.
var instanceUrl = 'jdbc:google:mysql://' + connectionName;
var dbUrl = instanceUrl + '/' + db;
var conn = Jdbc.getCloudSqlConnection(dbUrl, user, userPwd);
PLEASE ESCALATE. Thanks
Note: Actually jdbc:goole seems to work now, as of 8:52 AM EST. Still checking.
br...@gmail.com
Same issue, please escalate.
pl...@oncologosdeloccidente.co
we have the same problem in all applications, please escalate
jt...@grupoelcerezo.com
please escalate, The problem is affecting the operation of our services.
th...@gmail.com
Same problem, it took me hours to check for the issue. It works for ages, but now suddenly stop working. I got this issue when upgrading to v8 engine, but I'm running in Legacy mode with same error. Please look into this ASAP.
pe...@empirisys.io
Same issue, please escalate
ad...@sportsforms.club
Priority 1 - Business DOWN! Please escalate.
ch...@gmail.com
Escalate please. All scripts have failed hourly triggers today
da...@empirisys.io
Used the following as a workaround, this link provided all the information - https://developers.google.com/apps-script/guides/jdbc
*** NOTE that this only works with GCP MySQL instances***
var connectionName = 'Instance_connection_name'; //from MySQL instance page.
var user = 'user_name'; // var USERNAME = ' ';
var userPwd = 'user_password'; // var PASSWORD = ' ';
var db = 'database_name'; //var DATABASE = ' ';
var dbUrl = 'jdbc:google:mysql://' + connectionName + '/' + db;
// above is the replacement for your previous connection string variables.
and then, replace each of your conn objects with the following
var conn = var conn = Jdbc.getCloudSqlConnection(DBURL, USERNAME, PASSWORD);
Then
conn.createStatement(foo)...
*** NOTE that this only works with GCP MySQL instances***
var connectionName = 'Instance_connection_name'; //from MySQL instance page.
var user = 'user_name'; // var USERNAME = ' ';
var userPwd = 'user_password'; // var PASSWORD = ' ';
var db = 'database_name'; //var DATABASE = ' ';
var dbUrl = 'jdbc:google:mysql://' + connectionName + '/' + db;
// above is the replacement for your previous connection string variables.
and then, replace each of your conn objects with the following
var conn = var conn = Jdbc.getCloudSqlConnection(DBURL, USERNAME, PASSWORD);
Then
conn.createStatement(foo)...
ro...@gmail.com
This workaround does not work for non-Google SQL databases. There is no alternative fix.
Please escalate.
Please escalate.
ka...@verifieddms.com
Escalate please, the above is not working for us. All scripts are failing.
st...@ryanrestaurantcorp.com
Same issue here. So far, I tried reverting from V8 and whitelisting all IPs, but nothing changed. I can query access database from Google Cloud Console and mySQL Workbench, but just not from Google Scripts.
me...@girlfridayvs.com
Escalate Please. All scripts are non functional.
vf...@thoughtworks.com
Same issue here
ma...@ballotpedia.org
Comment has been deleted.
st...@ryanrestaurantcorp.com
I've had success with appending the URL with '?useSSL=false'
ka...@verifieddms.com
Awesome! Ryan Restaurant solution worked for us. Thanks!
ma...@gmail.com
'?useSSL=false' did not work in my case
vf...@thoughtworks.com
It did not work for me either
th...@gmail.com
?useSSL=false is working for me, url = 'jdbc:mysql://' + ip_address + '/' + db_name + '?useSSL=false';
ad...@nextgenleads.com
Thanks RyanRestaurantcorp, appending `?useSSL=false` appears to have fixed our connection issue to AWS's MySQL
st...@ryanrestaurantcorp.com
FYI, I'm also rolling all my apps back from V8. I've noticed huge problems in performance lately, and I noticed this morning that dropping V8 largely fixes this. Have to refactor some code, unfortunately, but worth the effort.
ad...@nextgenleads.com
We tried V8 for about one day and noticed JDBC would timeout long connections. This JDBC.getConnection issue affected us even while using "DEPRECATED_ES5"
ma...@gmail.com
Hi all, I did speak too soon, "?useSSL=false" was indeed the fix here. Are there security implications to this?
hc...@exertsrl.com.ar
PLEASE Escalate. All scripts are failing.
ad...@gmail.com
var subname = 'INSTANCE_CONNECTION_NAME/DATABASE';
var url = 'jdbc:google:mysql://'+subname;
var quickfix = '?useSSL=false';
url = url + quickfix;
var info = { password: pwd, user: uid };
var conn = Jdbc.getCloudSqlConnection(url, info);
Adding '?useSSL=false' is not working for me (using 'jdbc:google:mysql')
This connection DOES work (without the quickfix) on "DEPRECATED_ES5"
However, I can't run any scripts in the legacy editor as of yesterday, and I can't debug ES5 in the new editor. So the only way to make this work is to use ES5, new editor, and NOT debug - just let it fly in production and hope for the best.
var url = 'jdbc:google:mysql://'+subname;
var quickfix = '?useSSL=false';
url = url + quickfix;
var info = { password: pwd, user: uid };
var conn = Jdbc.getCloudSqlConnection(url, info);
Adding '?useSSL=false' is not working for me (using 'jdbc:google:mysql')
This connection DOES work (without the quickfix) on "DEPRECATED_ES5"
However, I can't run any scripts in the legacy editor as of yesterday, and I can't debug ES5 in the new editor. So the only way to make this work is to use ES5, new editor, and NOT debug - just let it fly in production and hope for the best.
so...@gmail.com
Comment has been deleted.
ha...@effektivaltruisme.no
We are also experiencing this issue.
ha...@effektivaltruisme.no
The ?useSSL=false worked for us, but it's a bad fix. Might this have something to do with certificates? We do not have a valid SSL certificate for our server residing on a VPS outside of google cloud infrastructure.
ha...@effektivaltruisme.no
Also, mysql reports [bad handshake] when using SSL in the error logs.
ji...@mkzbooks.com
I am also experiencing this issue. Need a fix asap.
ji...@hedgehoghs.com
We are experiencing this same issue. Our production system is down. Please escalate.
an...@gmail.com
Experiencing the same issue here since around 09:30 PDT 2021-05-10. The '?useSSL=false' workaround did not work for us. We are not using V8.
ji...@mkzbooks.com
In case it helps someone else... the "useSSL" workaround worked for me:
var dbUrl = "jdbc:mysql://" + IP + ":3306/" + DBNAME + "?useSSL=false";
function connectionTest() {
var conn = Jdbc.getConnection(dbUrl, user, userPwd);
conn.close();
}
var dbUrl = "jdbc:mysql://" + IP + ":3306/" + DBNAME + "?useSSL=false";
function connectionTest() {
var conn = Jdbc.getConnection(dbUrl, user, userPwd);
conn.close();
}
[Deleted User] <[Deleted User]>
@Google any news on this subject? This issue has had a huge impact on Apps Script applications
er...@madwire.com
We are also experiencing this issue. All of our database scripted reports are down (Since yesterday 5/10). Please escalate!
de...@madwire.com
Same issue here. This affects business operations. Please escalate.
All of our Jbdc mysql connected database scripts have stopped running as of 12:00 AM MST today.
Error - "Failed to establish a database connection. Check connection string, username and password."
All of our Jbdc mysql connected database scripts have stopped running as of 12:00 AM MST today.
Error - "Failed to establish a database connection. Check connection string, username and password."
np...@fye.com
Same issue and just started yesterday.
au...@gmail.com
Hi, I have the same issue.
I have several Apps Scripts that connect to MySQL databases. They were all working for the past few years, but today they all stopped working at the same time, with the following error message:
"Failed to establish a database connection. Check connection string, username and password."
I have several Apps Scripts that connect to MySQL databases. They were all working for the past few years, but today they all stopped working at the same time, with the following error message:
"Failed to establish a database connection. Check connection string, username and password."
el...@gmail.com
Same issue here. Please escalate. Thank you.
r....@anasystems.co.jp
Hello.
In addition to changing theCloudSql connection, it seems necessary to add role members of Cloud SQL Client to IAM.
var instanceUrl = 'jdbc:google:mysql://' + connectionName;
var dbUrl = instanceUrl + '/' + db;
var conn = Jdbc.getCloudSqlConnection(dbUrl, user, userPwd);
mi...@datacompusa.com
Same issue here. "?useSSL=false" allows the connection but is not acceptable security wise. Has anybody tested with a publicly signed certificate, because mine is self signed.
kh...@grutto.com
same issue here!
gl...@ifirma.be
Same issue here, with all of our MySQL connections using Jdbc.getConnection.
?useSSL=false did fix the issue
?useSSL=false did fix the issue
ko...@gmail.com
Same error connecting to remote (not Google) MySQL.
Script that was working without problem for 2 years stopped with error 11/05
Script that was working without problem for 2 years stopped with error 11/05
ko...@gmail.com
Just run script and it worked again!!!
Together we stand!
Together we stand!
ko...@gmail.com
I confirm that Google fixed issue
vf...@thoughtworks.com
It's working now
al...@gmail.com
Tengo el mismo problema, no me deja conectarme a la base de datos y me aparece el siguiente mensaje: ¨Exception: No se ha podido establecer una conexión con la base de datos. Comprueba la contraseña, el nombre de usuario y la cadena de conexión.¨
ad...@gmail.com
This still is not working for me on V8.
However, I am able to run it on ES5 again. Yesterday all scripts were failing on ES5 (not just JDBC scripts) and JDBC was failing on V8.
So, the JDBC scripts are working now for me on ES5, but it seems like a rollback, and not an actual fix.
However, I am able to run it on ES5 again. Yesterday all scripts were failing on ES5 (not just JDBC scripts) and JDBC was failing on V8.
So, the JDBC scripts are working now for me on ES5, but it seems like a rollback, and not an actual fix.
ad...@frostysquirrel.ca
6 Hours Google. I spent 6 hours trying to get this nightmare to work yesterday.
I want my 1/4 of the day back! But I will settle with you fixing this sooner than later, or simply incorporate this into Sheets as a Database Type Function so I can go back to being lazy. :D
I want my 1/4 of the day back! But I will settle with you fixing this sooner than later, or simply incorporate this into Sheets as a Database Type Function so I can go back to being lazy. :D
ry...@gmail.com
This is still not working for me on either V8 our Rhino, new editor or legacy editor.
N.B.: Our MySQL 5.7 database is not hosted on Google Cloud SQL. Jdbc.getConnection had been working fine prior to this issue.
N.B.: Our MySQL 5.7 database is not hosted on Google Cloud SQL. Jdbc.getConnection had been working fine prior to this issue.
ga...@google.com
Hi there!
A change was recently made which may have resolved this issue, can you please confirm if you are still experiencing the behaviour?
ad...@frostysquirrel.ca
Still a no for me on either getConnection or getCloudSqlConnection. Hopefully someone else has better luck.
ad...@gmail.com
Still does not work for me on V8. I CAN make very quick SQL calls. Very basic, fast queries do seem to work (less than 1 second, maybe half a second). As others have said, it seems to be a timeout issue.
All queries (long and short) work on the old Rhino/ES5.
I am using:
Jdbc.getCloudSqlConnection(url, info)
And using Cloud SQL so my URL looks like:
var url = 'jdbc:google:mysql://'+subname;
All queries (long and short) work on the old Rhino/ES5.
I am using:
Jdbc.getCloudSqlConnection(url, info)
And using Cloud SQL so my URL looks like:
var url = 'jdbc:google:mysql://'+subname;
be...@gmail.com
I'm having the same issue. And the useSSL=false doesn't always work. It works sometimes only.
se...@google.com
Hello,
Can you confirm it is still happening to you?
Thank you!
be...@gmail.com
Hello,
Yesterday it was still happening, but today it looks like it works.
Thank you
Yesterday it was still happening, but today it looks like it works.
Thank you
mi...@datacompusa.com
For me, I experienced the original problem on May 11 which was fixed in a day or two. The problem returned last week and is still not working.
be...@gmail.com
Again today the problem is back.
ga...@google.com
Another change has been made, can you confirm please if you still see the same behaviour?
be...@gmail.com
I'm still having the issue at least on one google sheet
in...@gmail.com
i'm still having the issue on ES5 but V8 is working but slowly and timeout sometime.
pa...@visma.com
started to experience the same behavior since yesterday 15:30 CET . we are using a Google Apps Add-on which connects from Google Sheet to an Azure SQL server instance.
It was all working well until yesterday 15:30 CET. Please advice.
Thank you.
It was all working well until yesterday 15:30 CET. Please advice.
Thank you.
eb...@frazerbilt.com
We are experiencing the same issue since early this morning.
regards,
EAB
regards,
EAB
wc...@gmail.com
We have been experiencing this as well over the last couple of days. It seems to be affecting both ES5 and V8.
[Deleted User] <[Deleted User]>
Also heavily affected by this. SSL workaround is not working. Also using Azure SQL Server instance on our side but I'm unsure if that's relevant
is...@gmail.com
We're on the same boat. Experiencing issues in every script that makes use of jdbc (+90% of our scripts). Tried one workaround that worked for about 10 hours and then it randomly stopped again. Nothing we've tried is working anymore, and the matter is pressing.
Can anyone from google at least make a suggestion of a temporary fix?
Can anyone from google at least make a suggestion of a temporary fix?
[Deleted User] <[Deleted User]>
As a general update to this thread, I contacted Google Workspace support who is in the process of redirecting me to GCP/Apps Script support. I was told I would receive a callback within 24 hours, so we'll see how that goes. In the meantime just wanted to let everybody know that I will (hopefully) be able to escalate this directly via phone soon.
ro...@alo-group.com
Same issue here and the ssl workaround did not work.
ke...@barronltg.com
the issue began yesterday for us at 8:00am MST. We are connecting to SQL Server.
ju...@gmail.com
Same issue with SQL Server, no connection can be established. Please escalate! Thank you
ed...@parcelpickup.co.uk
I'm connecting to our MSSQL server and everything had been running perfectly for years until this morning. Has anyone found a solution that works with a connection to an MSSQL server?
We hold the credentials for all the other external service we integrate with in this db so almost none of our other app scripts work any more!
Many thanks
We hold the credentials for all the other external service we integrate with in this db so almost none of our other app scripts work any more!
Many thanks
ms...@gmail.com
seeing the same issue with MS SQL server
ma...@benicomp.com
We are having this issue with connecting from Google Sheets scripting to a MSSQL located in AWS. The '?useSSL=false' trick didn't work.
hu...@gmail.com
Need google help wwith mssql
vi...@gmail.com
Need help with mssql
[Deleted User] <[Deleted User]>
Hi, our scripts have been running fine for the past 2 years and we have received this error today:
Exception: Failed to establish a database connection. Check connection string, username and password.
var conn = Jdbc.getConnection("jdbc:sqlserver://;user=;password=;databaseName=");
var stmt = conn.createStatement();
Is this a temporary issue that can be fixed? thanks
Exception: Failed to establish a database connection. Check connection string, username and password.
var conn = Jdbc.getConnection("jdbc:sqlserver://;user=;password=;databaseName=");
var stmt = conn.createStatement();
Is this a temporary issue that can be fixed? thanks
r....@gmail.com
I am having the same issue over my connection with a sheet
se...@barecotton.com
Same issue herewith MSSQL. Please fix it ASAP!
we...@jervoisventures.com
same issue here with mssql...
te...@antiseptol.com
We are also having this issue. Connection isn't even hitting our firewalls...
re...@gmail.com
Hi. I am having same issue here. It was working fine for many months and suddenly it stopped working as of today. I used the same connection parameters from my PC and I can connect to the MSSQL server. I made sure all the IP addresses are whitelisted.
I'm using jdbc:sqlserver:// via AppScript
Any workaround is appreciated. Feel free to reach out to me if you need more information.
I'm using jdbc:sqlserver:// via AppScript
Any workaround is appreciated. Feel free to reach out to me if you need more information.
ar...@abipa.lt
Comment has been deleted.
va...@titan.co.in
Our applications have stopped working from today, because of the connection issue. Please fix this issue ASAP.
jo...@igmonline.nl
Started on 5th of july at around 14:00 GTM+1. Connection to MSSQL which worked without issues and without changes started giving the Exception: Failed to establish a database connection. Check connection string, username and password.
ga...@gmail.com
same issue here with mssql...
this needs to be looked at asap
its a very imp bug
this needs to be looked at asap
its a very imp bug
sh...@gmail.com
same issue here with mssql
ja...@gmail.com
same issue here with mssql
ma...@gmail.com
Facing the same issue here with mssql. Please look into this asap. This is a huge bug.
pd...@gmail.com
facing same issue here with mssql.. pl look into it asap
ha...@gmail.com
same issue here with mssql...
this needs to be looked at asap
its a very imp bug
this needs to be looked at asap
its a very imp bug
dh...@gmail.com
same issue here with mssql...
this needs to be looked at asap
this needs to be looked at asap
ni...@flexproltd.com
Been long with so many comments and still no support!! need this issue resovled with mssql asap!!! so many products stuck!
n2...@gmail.com
need resolution!!!
dm...@gmail.com
Same issue with mssql. Please help!!!!
aa...@gmail.com
Same issue with mssql!
nm...@gmail.com
I am facing this exact issue with mySQL connection and this needs to be looked into ASAP
ra...@gmail.com
Same issue with mssql. Please resolve!
sp...@gmail.com
Same issue with MySQL. Please resolve it.
nm...@gmail.com
same issue here with mssql...
this needs to be looked at asap
this needs to be looked at asap
ji...@gmail.com
facing the same issue with MSSql
ne...@gmail.com
Yes, same issue with Ms SQL as well.
Could you please look into it at earliest. It would really help us proceed further.
Could you please look into it at earliest. It would really help us proceed further.
ch...@gmail.com
Yes, same issue here with mssql...
this needs to be looked at asap..
Thanks
this needs to be looked at asap..
Thanks
dk...@gmail.com
same issue here with mssql
please look into this
please look into this
se...@gmail.com
mssql connection is not even hitting reaching my firewall!!
don't know where the issue lies!
don't know where the issue lies!
ad...@gmail.com
I am facing the same issue. Please resolve this at the earliest.
bi...@gmail.com
We are facing this issue as well. It’s critical we have this resolved ASAP. Please fix it right away.
ma...@imerys.com
I'm having this same problem in AppScripts, get a message "Failed to establish a database connection. Please check the connection string, username and password."
Has anyone managed to solve this ?? Which solution please??
Thanks
Mauro
Has anyone managed to solve this ?? Which solution please??
Thanks
Mauro
he...@gmail.com
I am facing the same issue with mssql.
Please help & fix this bug. It's very critical.
Please help & fix this bug. It's very critical.
su...@gmail.com
Facing a lot of issues due to this. Pls resolve asap
te...@gmail.com
Any update team, our system is not working.
ma...@benicomp.com
As of the writing of this comment, my scripts are now completing their queries and stored procedure calls from Google Sheets to MSSQL in AWS.
di...@gmail.com
I am facing the same issue with mssql. It's very critical for me to get the resolution. Please fix this bug asap.
[Deleted User] <[Deleted User]>
ge...@gmail.com
same issue here with mssql...
this needs to be looked at asap
this needs to be looked at asap
jo...@igmonline.nl
Issues are resolved on my end.
ni...@gmail.com
Same issue here with MSSQL. Please fix it ASAP!
ed...@parcelpickup.co.uk
Great! Mine is working again...
mi...@google.com
Hello!
There has been a recent change which may have resolved this. Is anyone still experiencing this behavior?
re...@gmail.com
Yup, seems to work fine since the change was made. Much appreciated!
[Deleted User] <[Deleted User]>
Hi,
ke...@barronltg.com
Hello. The issue has come back today intermittently and is continuing into the evening.
mi...@google.com
Thank you for your reports, I communicated this internally.
mi...@tamedia.ch
Comment has been deleted.
mu...@google.com
Hello everyone,
A fix has been pushed and you should be able to make the connection successfully. Can you confirm this?
al...@gmail.com
Hello, I have been affected since yesterday. Same thing, the code has been running perfectly for several years, and yesterday it is failing to connect. What is the cause? And when will it get fixed?
Also I had to disable SSL, which is not an acceptable solution. Please fix. Thanks
Also I had to disable SSL, which is not an acceptable solution. Please fix. Thanks
mu...@google.com
Hello everyone,
I can confirm that the issue has now been fixed and everything is working as expected.
Best regards
tf...@gmail.com
Same issue with mySQL connection, not working.
ma...@gmail.com
Given how long this issue has persisted and how disruptive it is for the apps affected, could there be some kind of postmortem describing what happened here and what the chances are that it will happen again?
[Deleted User] <[Deleted User]>
Is this problem back again for the third time in the last two months? We're having issues once again.
jm...@aptuscr.com
Comment has been deleted.
ck...@gmail.com
Are people having issues with this again? I wrote a script yesterday that worked, and now it's not connecting. No changes have been made.
ju...@gmail.com
Is anybody else having this issue again as of a few days ago? Scripts still run on occasion, but getting this error "Failed to establish a database connection. Check connection string, username and password." around 30% of the time.
ro...@alo-group.com
I have the same issue, getting this error "Failed to establish a database connection. Check connection string, username and password." around 30% of the time.
ka...@ismena.com
Having same issue
ch...@gmail.com
Check out this ticket, you may have to patch/upgrade your SQL Server to support TLS 1.2 to fix this issue: https://issuetracker.google.com/issues/210491249
it...@klehospital.org
var server = 'rptserver\kleslive';
var port = 1433;
var dbName = 'Hospital';
var username = 'SA';
var password = '';
var url = 'jdbc:sqlserver://'+server+':'+port+'/'+dbName;
function readData() {
var conn = Jdbc.getConnection(url, username, password);
var stmt = conn.createStatement();
var results = stmt.executeQuery('SELECT * FROM cd_dcd where typ= 33');
var metaData=results.getMetaData();
var numCols = metaData.getColumnCount();
var spreadsheet = SpreadsheetApp.getActive();
var sheet = spreadsheet.getSheetByName('Sheet1');
sheet.clearContents();
var arr=[];
for (var col = 0; col < numCols; col++) {
arr.push(metaData.getColumnName(col + 1));
}
sheet.appendRow(arr);
while (results.next()) {
arr=[];
for (var col = 0; col < numCols; col++) {
arr.push(results.getString(col + 1));
}
sheet.appendRow(arr);
}
results.close();
stmt.close();
sheet.autoResizeColumns(1, numCols+1);
}
12:20:58 PM Error
Exception: Failed to establish a database connection. Check connection string, username and password.
readData @ Code.gs:8
var port = 1433;
var dbName = 'Hospital';
var username = 'SA';
var password = '';
var url = 'jdbc:sqlserver://'+server+':'+port+'/'+dbName;
function readData() {
var conn = Jdbc.getConnection(url, username, password);
var stmt = conn.createStatement();
var results = stmt.executeQuery('SELECT * FROM cd_dcd where typ= 33');
var metaData=results.getMetaData();
var numCols = metaData.getColumnCount();
var spreadsheet = SpreadsheetApp.getActive();
var sheet = spreadsheet.getSheetByName('Sheet1');
sheet.clearContents();
var arr=[];
for (var col = 0; col < numCols; col++) {
arr.push(metaData.getColumnName(col + 1));
}
sheet.appendRow(arr);
while (results.next()) {
arr=[];
for (var col = 0; col < numCols; col++) {
arr.push(results.getString(col + 1));
}
sheet.appendRow(arr);
}
results.close();
stmt.close();
sheet.autoResizeColumns(1, numCols+1);
}
12:20:58 PM Error
Exception: Failed to establish a database connection. Check connection string, username and password.
readData @ Code.gs:8
lo...@gmail.com
This is still happening sporadically as of today, 2022-8-7
ch...@bingologistics.com
Same here, using Jdbc.getConnection() (not the getCloudSqlConnection()) also has same problem sporadically.
The very unstable database connection is a killer using google cloud.
The very unstable database connection is a killer using google cloud.
ap...@eastwestseed.com
I am facing same issue today in one of my application. Can you please help me on this urgently?
[Deleted User] <[Deleted User]>
I created a new issue here: https://issuetracker.google.com/issues/241819492
Please star and follow that ticket if you are still experiencing the JDBC connection issues.
Please star and follow that ticket if you are still experiencing the JDBC connection issues.
pa...@eastwestseed.com
Issue connecting database, please help to resolve as soon as possible
Error 1 :
Failed to establish a database connection. Check connection string, username and password.
Error 2 :
www.google.com refused to connect.
Error 1 :
Failed to establish a database connection. Check connection string, username and password.
Error 2 :
ro...@accepty.co.uk
Hi, I'm getting this issue:
Exception: Failed to establish a database connection. Check connection string, username and password.
Exception: Failed to establish a database connection. Check connection string, username and password.
[Deleted User] <[Deleted User]>
Hello, I'm currently having the same issue intermitently, all scripts worked fine until last week
Exception: Failed to establish a database connection. Check connection string, username and password.
Can connect via any other means and my scripts some times runs fine, some times doesn't run with this error.
I also tried disabling SSL but didn't work.
I'm connecting to a 5.7 mysql Aurora 2.10.2 on AWS
Can you please verify it?
Exception: Failed to establish a database connection. Check connection string, username and password.
Can connect via any other means and my scripts some times runs fine, some times doesn't run with this error.
I also tried disabling SSL but didn't work.
I'm connecting to a 5.7 mysql Aurora 2.10.2 on AWS
Can you please verify it?
al...@gmail.com
I am having issues with several google apps script saying: Failed to establish a database connection. Check connection string, username and password.
Credentials are correct, its intermittent.. connects on some script runs, and on some runs it throws an error...
This is happening to several scripts.. It started yesterday.
Credentials are correct, its intermittent.. connects on some script runs, and on some runs it throws an error...
This is happening to several scripts.. It started yesterday.
jr...@gmail.com
Have also had this issue for about three weeks. Azure SQL. Had been working well for 2+ years on a scheduled daily run but now fails 30-60% of attempts, manual or triggered.
aw...@bingologistics.com
same here, suddenly a script connecting to aws rdb is broken. Script log: Failed to establish a database connection. Check connection string, username and password., mysql server registered 'bad handshake';
sa...@gmail.com
el mismo error AppScripts get a "Failed to establish a database connection. Check connection string, username and password. por que razon alguna ayuda
jr...@gmail.com
This is closely connected to https://issuetracker.google.com/issues/241819492#comment35 for our resolution steps using Azure SQL Server.
ea...@gmail.com
I followed the mysql-instance created during the tutorial. I've tried both the connection name, and the IP. I tried appending ?useSSL=false. Here's the StackOverflow question:
ar...@trbls.com
this will solve your problem. Make sure all IP ranges are added to your firewall rules
'In order to create a database connection using the Apps Script JDBC service, in your database settings you must authorize IP ranges from this data source.'
https://www.gstatic.com/ipranges/goog.txt
'In order to create a database connection using the Apps Script JDBC service, in your database settings you must authorize IP ranges from this data source.'
Description
Our appscripts which connect to Google cloud mySQL, which have been running for months, are getting a "Failed to establish a database connection. Check connection string, username and password." error now. Every now and then. Same code works fine when the next (or the following) trigger runs.
Happens sporadically in a bunch of appscripts. (In Javascript)
Is there a system wide issue?
What steps will reproduce the problem?
1. Just trigger runs of appscript
2.
3.
What is the expected output? What do you see instead? If you see error messages, please provide them.
Please provide any additional information below.