How to connect to database with SSL in google apps script?

by

I can confirm that I can connect to a MySQL database with SSL within Google Apps Script.

It’s important to note useSSL=true is indeed necessary

I was able to get it working by following the example at https://issuetracker.google.com/issues/36761592#comment18 (relevant snippet repeated below):

var conn = Jdbc.getConnection('jdbc:mysql://<ip address>/<db name>?useSSL=true', { 
  user: '<user>', 
  password: '<pass>', 
  _serverSslCertificate: '-----BEGIN CERTIFICATE-----\n...\n-----END CERTIFICATE-----', 
  _clientSslCertificate: '-----BEGIN CERTIFICATE-----\n...\n-----END CERTIFICATE-----', 
  _clientSslKey: '-----BEGIN RSA PRIVATE KEY-----\n...\n-----END RSA PRIVATE KEY-----' 
});

If you’re using a Google Cloud SQL instance, you may want to consider using getCloudSqlConnection(). Presumably it’s encrypted as well (based on the fact that I can indeed get a connection when the corresponding instance has “Only secured connections are allowed to connect to this instance.” enabled), and, importantly, doesn’t require you to manage (i.e. not lose control of) the key and certs yourself.

More Related Contents:

  1. Google App Script – MySql 8 – JDBC Connection Failed
  2. How to generate a self-signed SSL certificate using OpenSSL?
  3. How do you sign a Certificate Signing Request with your Certification Authority?
  4. Are HTTPS URLs encrypted?
  5. node.js, socket.io with SSL
  6. Security consequences of disabling CURLOPT_SSL_VERIFYHOST (libcurl/openssl)
  7. How can I generate a self-signed certificate with SubjectAltName using OpenSSL? [closed]
  8. NGINX to reverse proxy websockets AND enable SSL (wss://)?
  9. WebSocket with SSL
  10. Docker container SSL certificates
  11. Import certificate as PrivateKeyEntry
  12. How do I restore a missing IIS Express SSL Certificate?
  13. CNAME SSL certificates
  14. Nginx configuration leads to endless redirect loop
  15. Enabling SSL with XAMPP
  16. How to Get SSL Certificate to Work With Localhost on Firefox
  17. pip always fails ssl verification
  18. kubectl unable to connect to server: x509: certificate signed by unknown authority
  19. Webpack Dev Server running on HTTPS/Web Sockets Secure
  20. Two-way SSL clarification
  21. PushSharp APNS production: The credentials supplied to the package were not recognized (development works fine though)
  22. Programmatically Configure SSL for Jetty 9 embedded
  23. Enable TLSv1.2 and TLS_RSA_WITH_AES_256_CBC_SHA256 Cipher Suite
  24. Why does Python requests ignore the verify parameter?
  25. How to install: OpenSSL + WAMP
  26. SSL Certificate add failed when binding to port
  27. Self-signed SSL Cert or CA? [closed]
  28. curl: Unknown error (0x80092012) – The revocation function was unable to check revocation for the certificate
  29. SSLHandshakeException: Received fatal alert: handshake_failure when setting ciphers on tomcat 7 server
  30. What is CA certificate, and why do we need it?

Leave a Comment