Guest User

Untitled

a guest
Feb 12th, 2019
152
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.37 KB | None | 0 0
  1. function connect() {
  2.  
  3. // server-ca.pem ファイルの中身
  4. // 改行コード含め文字列として渡す必要あるので注意(以下同じ)
  5. var serverSslCertificate = '\
  6. -----BEGIN CERTIFICATE-----\n\
  7. MIIDITCCAgmgAwIBAgIBADANBgkqhkiG9w0BAQUFADBIMSMwIQYDVQQDExpHb29n\n\
  8. ... 略
  9. CwcD7q+e5Nc5nFpvBsoWraAsWt4nvxSfhWjbnYF3wDvuSb/42npxBs+j2BZeCNpi\n\
  10. pSqi9kL5hemLugiSUs/UJgFIf2vtJcUhlzX0IcuglFBdcQdxwQ==\n\
  11. -----END CERTIFICATE-----';
  12.  
  13. // client-cert.pem ファイルの中身
  14. var clientSslCertificate = '\
  15. -----BEGIN CERTIFICATE-----\n\
  16. MIIDNTCCAh2gAwIBAgIEWVYQpjANBgkqhkiG9w0BAQUFADBZMTQwMgYDVQQDDCtH\n\
  17. ... 略
  18. cQaJKC2ta94A4lDnmbUYQAwMXGQUL8Ru+Gqt+uYgkKrhby3dmPDSbOTMfKiZj5mg\n\
  19. XQmz2Wb9CYOn\n\
  20. -----END CERTIFICATE-----';
  21.  
  22. // client-key.pem ファイルの中身
  23. var clientSslKey = '\
  24. -----BEGIN RSA PRIVATE KEY-----\n\
  25. MIIEowIBAAKCAQEAiK74B7qslJH2AhWpOPu4J+oWO5e/bwM54TPYaVPnjmAi23a/\n\
  26. ... 略
  27. yg24rvs+F2+2zeBlgPtTrtSN6NZ3CAcC12hFCeBHZpbQenRF9Y0C/o7oo1YAsXqD\n\
  28. uRpjsPKziUon4Ao4U3eq/m5LpmZ52vyAFXhtBa7DZM2HFqnYzy9s\n\
  29. -----END RSA PRIVATE KEY-----';
  30.  
  31. var url = 'jdbc:mysql://xx.xxx.xx.xx/yourdb?useSSL=true';
  32. var connInfo = {
  33. user: 'root',
  34. password: 'pass',
  35. _serverSslCertificate: serverSslCertificate,
  36. _clientSslCertificate: clientSslCertificate,
  37. _clientSslKey: clientSslKey
  38. }
  39. var conn = Jdbc.getConnection(url, connInfo);
  40. return conn;
  41. }
Add Comment
Please, Sign In to add comment