I've deployed a node.js-app to GAE and my SQL-db is on Google Cloud SQL.
It worked out fine, but when enabling SSL I get the following error message: Server does not support secure connection.
I have:
Any lead on what is going on is much appreciated.
connection
function getConnection () {
const options = {
user: 'root',
password: 'pwd',
database: 'dbname',
socketPath: '/cloudsql/project-name:us-central1:name',
ssl: {
ca: fs.readFileSync(__dirname + '/server-ca.pem'),
cert: fs.readFileSync(__dirname + '/client-cert.pem'),
key: fs.readFileSync(__dirname + '/client-key.pem')
}
};
From Handshake.js in npm mysql
Handshake.prototype['HandshakeInitializationPacket'] = function(packet) {
this._handshakeInitializationPacket = packet;
this._config.protocol41 = packet.protocol41;
var serverSSLSupport = packet.serverCapabilities1 & ClientConstants.CLIENT_SSL;
if (this._config.ssl) {
if (!serverSSLSupport) {
var err = new Error('Server does not support secure connection');
err.code = 'HANDSHAKE_NO_SSL_SUPPORT';
err.fatal = true;
this.end(err);
return;
}