Error setting up Mysql credentials on Linux - Apache - mysql

Questions
1

Problem: Error setting up Mysql credentials for Linux - Apache - Mysql server hosted on Azure.

Error: 282211E28D7F0000:error:0A000418:SSL routines:ssl3_read_bytes:tlsv1 alert unknown ca:…/deps/openssl/openssl/ssl/record/rec_layer_s3.c:1590:SSL alert number 48

Workflow: I’m very new to n8n, and just trying to get the Mysql credentials working. I haven’t done much with the workflows. I have copied what I believe to be the correct Certificate, Private Key, and Client Certificate files from the server to the credentials. We use Godaddy SSL.

Information on your n8n setup

  • n8n version:1.70.3
  • Database (default: SQLite):MySQL
    -We are using n8n from the cloud
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

hi @jsdrew

Welcome to the community! Can you share a bit more details here, you’re using cloud and are unable to set up your MySQL credentials if I understood correctly. Can you share the steps you took so far?

Thanks!

4

Hi Gualter, thanks for your reply. I’m sorry I missed the first one. Here is what I’ve done so far.

  1. Created a n8n account with a free trial. Version 1.70.3
  2. Went to the Overview Page and clicked Credentials
  3. Created a MySQL Account
  4. Entered in my Host, Database, user, Password, Port, Connection Time out, CA Certificate, Client Private Key and Client Certificate

I am receiving a “Cannot connect with these settings”,“self-signed certificate in certificate chain” error.

Our MySQL is on a LAMP stack ubuntu server on Microsoft Azure. MySQL Ver 8.0.36-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu)).

Our SSL is provided by Godaddy, so I contacted Godaddy support about how to find the CA Certificate and Client Certificate files. They said that the gd_bundle-g2-g1.crt file they provide has the CA Certificate and the other security certificate file they provide (It has a unique name) is the client certificate. I found the path to the Client Private Key file in my default.conf file in etc\apache2\sites-available path on my server. I have verified that this is the correct default.conf file. It is the one I update each year with the new SSL information, and I have verified that the SSL is working. I’m not sure Godaddy support knows the correct data for the CA Certificate, but I’m not sure where to go from here.
Thanks for your help.

5

Here is a little more info.
I think we are running n8n on the cloud, we are using the free trial. We certainly haven’t installed it anywhere else.
I don’t know what this is - * n8n EXECUTIONS_PROCESS setting (default: own, main):. But we are probably using whatever the default is.
I am using Edge on a Windows 11 PC.

6

Thank you for the extra details! are you using a proxy/VPN. I see this issue also reported for another API call here: HTTP Request / OpenSSL Error · Issue #9419 · n8n-io/n8n · GitHub

Can you try it locally or or another device? Thanks!

7

I am not using it on a VPN or a proxy

8

When you say, can you try it locally, do you mean setupn8n locally rather than using the clould?

9

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.