Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function connect() {
- // server-ca.pem ファイルの中身
- // 改行コード含め文字列として渡す必要あるので注意(以下同じ)
- var serverSslCertificate = '\
- -----BEGIN CERTIFICATE-----\n\
- MIIDITCCAgmgAwIBAgIBADANBgkqhkiG9w0BAQUFADBIMSMwIQYDVQQDExpHb29n\n\
- ... 略
- CwcD7q+e5Nc5nFpvBsoWraAsWt4nvxSfhWjbnYF3wDvuSb/42npxBs+j2BZeCNpi\n\
- pSqi9kL5hemLugiSUs/UJgFIf2vtJcUhlzX0IcuglFBdcQdxwQ==\n\
- -----END CERTIFICATE-----';
- // client-cert.pem ファイルの中身
- var clientSslCertificate = '\
- -----BEGIN CERTIFICATE-----\n\
- MIIDNTCCAh2gAwIBAgIEWVYQpjANBgkqhkiG9w0BAQUFADBZMTQwMgYDVQQDDCtH\n\
- ... 略
- cQaJKC2ta94A4lDnmbUYQAwMXGQUL8Ru+Gqt+uYgkKrhby3dmPDSbOTMfKiZj5mg\n\
- XQmz2Wb9CYOn\n\
- -----END CERTIFICATE-----';
- // client-key.pem ファイルの中身
- var clientSslKey = '\
- -----BEGIN RSA PRIVATE KEY-----\n\
- MIIEowIBAAKCAQEAiK74B7qslJH2AhWpOPu4J+oWO5e/bwM54TPYaVPnjmAi23a/\n\
- ... 略
- yg24rvs+F2+2zeBlgPtTrtSN6NZ3CAcC12hFCeBHZpbQenRF9Y0C/o7oo1YAsXqD\n\
- uRpjsPKziUon4Ao4U3eq/m5LpmZ52vyAFXhtBa7DZM2HFqnYzy9s\n\
- -----END RSA PRIVATE KEY-----';
- var url = 'jdbc:mysql://xx.xxx.xx.xx/yourdb?useSSL=true';
- var connInfo = {
- user: 'root',
- password: 'pass',
- _serverSslCertificate: serverSslCertificate,
- _clientSslCertificate: clientSslCertificate,
- _clientSslKey: clientSslKey
- }
- var conn = Jdbc.getConnection(url, connInfo);
- return conn;
- }
Add Comment
Please, Sign In to add comment