Search
Search

google script gives "failed to establish a connection, invalid connection string, username or password"

debugcn Published at Dev
10
chirag pathak

Instead hostname , I have used IP-Address, google script still gives "failed to establish a connection, invalid connection string, username or password", I have cross-checked data, and mysql port..everything is ok.. but still problem remains.

function DBWrite(){
var address ='202.47.118.131:3306';
var user = "root";
var pwd="";
var db= "smsbrn";
var cform=FormApp.getActiveForm();
var formId=cform.getId();  
var dbUrl='jdbc:mysql://' + address + '/' + db;

***var conn=Jdbc.getConnection(dbUrl, user, pwd);** //connection fails here.*

 }
erick barreat

Have you whitelisted the Google IP's on your firewall ?

64.18.0.0 - 64.18.15.255
64.233.160.0 - 64.233.191.255
66.102.0.0 - 66.102.15.255
66.249.80.0 - 66.249.95.255
72.14.192.0 - 72.14.255.255
74.125.0.0 - 74.125.255.255
173.194.0.0 - 173.194.255.255
207.126.144.0 - 207.126.159.255
209.85.128.0 - 209.85.255.255
216.239.32.0 - 216.239.63.255

Also does your MySQL Server allow remote access on that given user or any other user ? You can find how to do so here.

How do I enable Remote Access on a MySQL Server ?

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

formatDate() gives correct date -1 day (Google Apps Script)

From Dev

Google Sheets script to sort table gives error "Cell reference out of range"

From Dev

slurm script gives "command not found"

From Dev

Python script gives `: No such file or directory`

From Dev

Python script : gives no such file or directory

From Dev

This script gives me NaN in iPad

From Dev

ionCube shell script gives error

From Dev

rsync gives an error in shell script

From Dev

Running SQL script gives syntax error

From Dev

Clutter Script connect signals gives ValueError

From Dev

Makefile that gives permission to my python script?

From Dev

bash script - executing find command gives no output

From Dev

Any Bash script always gives Command not found

From Dev

Bash script to display directory listing gives error

From Dev

Elasticsearch array only gives uniques to aggregation script

From Dev

bash script - executing find command gives no output

From Dev

commands after read in shell script gives error

From Dev

Running SQL script gives syntax error

From Dev

how does google gives summary of the page

From Dev

Google PHP API Analytics gives strange userRateLimitExceeded

From Dev

Google Sheets VALUE function gives wrong result

From Dev

google tag manager gives "mixed content" error

From Dev

Google PHP API Analytics gives strange userRateLimitExceeded

From Dev

Use of computeDistanceBetween gives error : '"cannot resolve 'google'"

From Dev

Concatenate on Google docs gives bad date

From Dev

google not defined in google script - Error

From Dev

Google Script equal to date?

From Dev

Is google apps script synchronous?

From Dev

Call Google Apps Script

Related Related

  1. 1

    formatDate() gives correct date -1 day (Google Apps Script)

  2. 2

    Google Sheets script to sort table gives error "Cell reference out of range"

  3. 3

    slurm script gives "command not found"

  4. 4

    Python script gives `: No such file or directory`

  5. 5

    Python script : gives no such file or directory

  6. 6

    This script gives me NaN in iPad

  7. 7

    ionCube shell script gives error

  8. 8

    rsync gives an error in shell script

  9. 9

    Running SQL script gives syntax error

  10. 10

    Clutter Script connect signals gives ValueError

  11. 11

    Makefile that gives permission to my python script?

  12. 12

    bash script - executing find command gives no output

  13. 13

    Any Bash script always gives Command not found

  14. 14

    Bash script to display directory listing gives error

  15. 15

    Elasticsearch array only gives uniques to aggregation script

  16. 16

    bash script - executing find command gives no output

  17. 17

    commands after read in shell script gives error

  18. 18

    Running SQL script gives syntax error

  19. 19

    how does google gives summary of the page

  20. 20

    Google PHP API Analytics gives strange userRateLimitExceeded

  21. 21

    Google Sheets VALUE function gives wrong result

  22. 22

    google tag manager gives "mixed content" error

  23. 23

    Google PHP API Analytics gives strange userRateLimitExceeded

  24. 24

    Use of computeDistanceBetween gives error : '"cannot resolve 'google'"

  25. 25

    Concatenate on Google docs gives bad date

  26. 26

    google not defined in google script - Error

  27. 27

    Google Script equal to date?

  28. 28

    Is google apps script synchronous?

  29. 29

    Call Google Apps Script

HotTag

Archive