Connecting from Node.js to MySQL managed database

October 15, 2019 387 views
DigitalOcean Managed MySQL Database

Hi,

We are trying to connect the MySQL managed database cluster from Node.js app, and DB configuration as follows,

export const databaseConfig: DatabaseConfig = {
    username: 'doadmin',
    password: 'xxxxxxxxx',
    database: 'xxxxxxxxx',
    host: 'xx-xx-xx-xxxx-xx-xxx-xxx-x.db.ondigitalocean.com',
    port: 25060,
    dialect: 'mysql',
    logging: true,
    force: true,
    timezone: '+00:00',
    pool: {
        max: 100,
        min: 0,
        idle: 200000,
        acquire: 1000000,
    },
    ssl: true,
    dialectOptions: {
        ssl: {
            ssl: true,
            cert: fs.readFileSync(process.env.INIT_CWD + '/server/config/' + 'glitra_mysql_ca-certificate.crt')
        }
    },

The .crt file is downloaded from DO database connection setting section, When we run the application we are getting “self signed certificate in certificate chain”.

Anybody tried connecting with from Nodejs to managed db and help us on this issue?

Thanks,
-SK

1 comment
  • Hi there @aalurdratek,

    Could you just confirm that you’ve placed the .crt file that you downloaded from DigitalOcean in the correct location, wherever process.env.INIT_CWD + '/server/config/' + 'glitra_mysql_ca-certificate.crt' resolves to?

Be the first one to answer this question.