CODEWITHSUNDEEP
google-apps-script
Kevin
Kevin

Reputation: 335

SSL properties in URL parameter of JDBC connection in Google Apps Script

Jdbc.getConnection('jdbc:mysql://<ip-address>:<port>/<db>?user=<user>&password=<password>&useSSL=true');

I get the following error message when trying to make the above connection: "The following connection properties are unsupported: useSSL"

My hunch is that SSL is not supported at all for JDBC in GAS, but I just wanted to verify since there is nothing in the docs that describe using User and Password URL properties with the above type of syntax, even though it allows me to make connections like this (the above works without the useSSL property). I took the useSSL property from the MySQL Connector/J docs thinking there might be some sort of general standard for using JDBC drivers, even if not fully documented in GAS.

http://dev.mysql.com/doc/connector-j/en/connector-j-reference-configuration-properties.html

Somebody mentioned in another post (here) that the Java truststore wouldn't be accessible from Google Apps Script, "thus not enabling the ability to generate certificates". As far as I know, I can generate certificates and keys where ever, I just need a place to store them (possibly remotely when using GAS JDBC) and a way to point to them (url property that is valid).

Upvotes: 3

Views: 1784

Answers (2)

Ri&#235;l
Ri&#235;l

Reputation: 1321

Thank you Eric, created an issue here, to be starred.

https://code.google.com/p/google-apps-script-issues/issues/detail?id=3944

Upvotes: 2

Eric Koleda
Eric Koleda

Reputation: 12673

The only connection parameters currently supported are those listed in the "Advanced Parameters" section of the Jdbc.getConnection() docs.

We currently have a whitelist of connection parameters we support, and it's possible we could add support or useSSL. Please file a feature request on our issue tracker and we'll consider it.

Upvotes: 4

Related Questions