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