sequelize secure connection for azure mysql

Question

How can I connect to Azure MySQL using sequelize?

From Azure nodejs example:

const mysql = require('mysql2');

var config =
{
    host: 'myserver4demo.mysql.database.azure.com',
    user: 'myadmin@myserver4demo',
    password: 'your_password',
    database: 'quickstartdb',
    port: 3306,
    ssl: true
};

what is the configuration for sequelize:

I tried using ssl but not successful:

ssl: true,

I got this error:

Unable to connect to database: SequelizeConnectionError: SSL connection is required. Please specify SSL options and retry.

I got this work:

dialectOptions: {
      encrypt: true,
      ssl : {
        rejectUnauthorized: false
      }
    },

but where to find the cert?

"but not successful" is not a valid problem description. mention what fails, which error you get, etc — ThiefMaster
– ThiefMaster, Commented Aug 21, 2017 at 8:33
Unable to connect to database: SequelizeConnectionError: SSL connection is required. Please specify SSL options and retry. — Alvin
– Alvin, Commented Aug 21, 2017 at 8:41

oak · Accepted Answer · 2019-12-29 11:11:22Z

17

For us, the solution was to provider dialectOptions i.e

{
    "host":<hostname>,
    "port":<port>,         
    "user":<username>,
    "password":<password>,
    "port": 3306,
    "dialect": "mysql",
    "ssl": true,
    "dialectOptions": {
       "ssl": {
          "require": true
       }
     }
 }

answered Dec 29, 2019 at 11:11

oak

3,0243 gold badges36 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sheradil Over a year ago

I needed 3 days .... to realize that "ssl:true" does not work, but "ssl:{require:true}" does. I am so annoyed

Dom · Accepted Answer · 2019-12-15 14:33:06Z

6

The Sequelize documentation is lacking on the SSL front, and the accepted answer is not for Sequelize like the comments state.

I struggled to know how to add SSL options too, but finely found an issue on Github containing a snippet.

const config = {
   username: process.env["DB_USER"],
   password: process.env["DB_PASS"],
   host: process.env["DB_HOST"],
   dialect: "mysql",
   database: dbs[process.env["USE_DB"]],
   pool: {
       max: 5,
       idle: 30000,
       acquire: 60000
   },
   dialectOptions: {
       ssl: {
           ca: fs.readFileSync(__dirname + '/ssl/BaltimoreCyberTrustRoot.crt.pem')
       }
   }
}

The Github issue that helped me.

answered Dec 15, 2019 at 14:33

Dom

531 gold badge3 silver badges13 bronze badges

Comments

EMX · Accepted Answer · 2017-08-21 09:39:43Z

0

var conn = mysql.createConnection({
       host: 'myserver4demo.mysql.database.azure.com',
       user: 'myadmin@myserver4demo',
       password: 'your_password',
       database: 'quickstartdb',
       port: 3306,
       ssl: {
         key: fs.readFileSync('./certs/client-key.pem'),
         cert: fs.readFileSync('./certs/client-cert.pem')
       }
    });

Configure SSL connectivity in your application to securely connect to Azure Database for MySQL

answered Aug 21, 2017 at 9:39

EMX

6,2492 gold badges31 silver badges33 bronze badges

1 Comment

DesperateEi Over a year ago

While this answer is one way to connect to a MySQL DB via SSL with node.js it doesn't apply Sequelize like the question asked.

Collectives™ on Stack Overflow

sequelize secure connection for azure mysql

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related