{"action":"created","issue":{"url":"https://api.github.com/repos/postmanlabs/sails-mysql-transactions/issues/37","repository_url":"https://api.github.com/repos/postmanlabs/sails-mysql-transactions","labels_url":"https://api.github.com/repos/postmanlabs/sails-mysql-transactions/issues/37/labels{/name}","comments_url":"https://api.github.com/repos/postmanlabs/sails-mysql-transactions/issues/37/comments","events_url":"https://api.github.com/repos/postmanlabs/sails-mysql-transactions/issues/37/events","html_url":"https://github.com/postmanlabs/sails-mysql-transactions/issues/37","id":142514253,"number":37,"title":"SSL Support for connecting to MySQL","user":{"login":"guretno","id":8649113,"avatar_url":"https://avatars.githubusercontent.com/u/8649113?v=3","gravatar_id":"","url":"https://api.github.com/users/guretno","html_url":"https://github.com/guretno","followers_url":"https://api.github.com/users/guretno/followers","following_url":"https://api.github.com/users/guretno/following{/other_user}","gists_url":"https://api.github.com/users/guretno/gists{/gist_id}","starred_url":"https://api.github.com/users/guretno/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/guretno/subscriptions","organizations_url":"https://api.github.com/users/guretno/orgs","repos_url":"https://api.github.com/users/guretno/repos","events_url":"https://api.github.com/users/guretno/events{/privacy}","received_events_url":"https://api.github.com/users/guretno/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2016-03-22T00:55:32Z","updated_at":"2016-03-23T19:38:02Z","closed_at":null,"body":"Hi,\r\n\r\nI'm wondering if sails-mysql-transaction support SSL connection to the database. Using Mysql Client usually SSl connection is made through this command\r\n\r\n> mysql -h [db url] --ssl-ca=[full path ca cert] --ssl-verify-server-cert -u [username] -p\r\n\r\nAnd I try to set the ssl on the configuration file for sails-mysql-transaction\r\n...\r\nuser : db username\r\npassword :db password\r\ndatabase: db name\r\nssl: {\r\n            key: null,\r\n            cert: null,\r\n            ca: fs.readFileSync( full path to CA cert)\r\n        }\r\n\r\nthe connection is failing with the following error:\r\n\r\n`Encountered an unexpected error: {}\r\nError (E_UNKNOWN) :: Encountered an unexpected error\r\nCould not connect to MySQL:\r\nError: unable to verify the first certificate\r\n     at afterwards (.../node_modules/sails-mysql-transactions/node_modules/sails-mysql/lib/connections/spawn.js:72:13)\r\n     at .../node_modules/sails-mysql-transactions/node_modules/sails-mysql/lib/connections/spawn.js:40:7\r\n     at Handshake.onConnect (.../node_modules/sails-mysql-transactions/node_modules/mysql/lib/Pool.js:54:9)\r\n     at Handshake.Sequence.end (.../node_modules/sails-mysql-transactions/node_modules/mysql/lib/protocol/sequences/Sequence.js:96:24)\r\n     at .../node_modules/sails-mysql-transactions/node_modules/mysql/lib/protocol/Protocol.js:169:20\r\n     at TLSSocket.<anonymous> (.../node_modules/sails-mysql-transactions/node_modules/mysql/lib/Connection.js:292:7)\r\n     at TLSSocket.emit (events.js:104:17)\r\n     at TLSSocket._finishInit (_tls_wrap.js:460:8)\r\nDetails:  Error: Could not connect to MySQL:\r\nError: unable to verify the first certificate`\r\n\r\nAny ideas? Thanks a lot."},"comment":{"url":"https://api.github.com/repos/postmanlabs/sails-mysql-transactions/issues/comments/200512510","html_url":"https://github.com/postmanlabs/sails-mysql-transactions/issues/37#issuecomment-200512510","issue_url":"https://api.github.com/repos/postmanlabs/sails-mysql-transactions/issues/37","id":200512510,"user":{"login":"shamasis","id":232373,"avatar_url":"https://avatars.githubusercontent.com/u/232373?v=3","gravatar_id":"","url":"https://api.github.com/users/shamasis","html_url":"https://github.com/shamasis","followers_url":"https://api.github.com/users/shamasis/followers","following_url":"https://api.github.com/users/shamasis/following{/other_user}","gists_url":"https://api.github.com/users/shamasis/gists{/gist_id}","starred_url":"https://api.github.com/users/shamasis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shamasis/subscriptions","organizations_url":"https://api.github.com/users/shamasis/orgs","repos_url":"https://api.github.com/users/shamasis/repos","events_url":"https://api.github.com/users/shamasis/events{/privacy}","received_events_url":"https://api.github.com/users/shamasis/received_events","type":"User","site_admin":false},"created_at":"2016-03-23T19:38:02Z","updated_at":"2016-03-23T19:38:02Z","body":"Great. I'll take this up at the earliest. I'm still not sure why this is not working. I pass all configurations to sails-mysql. Will deep dive. Hope it's not urgent. "}}