I’m running the latest docker image of n8n.
The credentials setup for MySQL connection (and also Postgres) to execute queries in the MySQL node doesn’t seem to support SSL options and certificates upload (at least from the user interface).
The node.js driver MySQL2 seems to support this options in a sub-object ssl: { ... }
https://github.com/sidorares/node-mysql2/blob/master/examples/ssl/select-over-ssl.js
I also looked at the code in https://github.com/n8n-io/n8n/blob/master/packages/nodes-base/credentials/MySql.credentials.ts and the properties don’t seem to be implemented.
Is there a way to set this properties and attach certificates files? Editing the configuration directly in the database is not possible because, of course, credentials are encrypted.
Do I have to create a custom node to achieve this?
In our use case SSL certificates are mandatory on the database connections, if someone points me in the right direction on how to set sub-properties and file attachments using the configuration, i could also try to open a PR and add the feature to the official MySql.credentials.
Thanks!