You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Add to the main.js file under <home/user or root>node-red/node_modules/node-red-contrib-stackhero-mysql/src this code " ssl: {rejectUnauthorized: false},"
// Note: the connection is not done here
this.pool = mysql.createPool({
host: config.host,
port: config.port,
user: this.credentials.user,
password: this.credentials.password,
database: config.database,
waitForConnections: true,
connectionLimit: 5,
queueLimit: 0,
connectTimeout: 1000,
ssl: config.tls ? {} : false,
ssl: {rejectUnauthorized: false},
I got the idea from the documentation for the mysql node for node red and its drivers:
otherwise this might get problematic eventually (if tls turned off)
but it gave me an entry point for my problem ;)
Yet i would expect your ca-certificate doesn't cover the CN of the db. Make an internal one (if applicable) with openssl and pass it like
Any chance of getting rid of this via the plugin?
Would be great if we could provide the client keys and certs here too.
The text was updated successfully, but these errors were encountered: