Question

Connecting from Node.js to MySQL managed database

Posted October 15, 2019 5.9k 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

edited by MattIPv4
2 comments
  • 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?

  • Hi,

    I have the same issue. No success. Could you please tell me if you were able to find the solution?

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
1 answer

Hello,

Looking at the error message it does seem like the issue might be around how the SSL is handled.

In your code if you set SSL mode to false do you still see this issue or add NODETLSREJECT_UNAUTHORIZED=‘0’ as an environment variable

Also as a reference the below URL has similar issue and workaround .

https://www.digitalocean.com/community/questions/can-t-connect-via-nodejs-error-self-signed-certificate-in-certificate-chain

Hope that this helps.
Regards,
Priyanka