Question
Connecting from Node.js to MySQL managed 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
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?