Unable to add NocoDB Cloud credentials

Questions
1

Describe the problem/error/question

I am trying to add NocoDB cloud credentials in N8n but I do not succeed. i guess I am doing something wrong but what ?

I follow this steps : NocoDB credentials | n8n Docs

  1. I create my token
  2. I past it in n8n
  3. I set the host to https://app.nocodb.com

What is the error message (if any)?

When I hit Save, I have this error message: UNABLE_TO_GET_ISSUER_CERT_LOCALLY

Is the host correct?
Is this error linked to the n8n certificate? or the Nocodb certificate?
What am I missing?

Information on your n8n setup

  • n8n version: 1.57.0
  • Database: SQLite
  • n8n EXECUTIONS_PROCESS setting: own
  • Running n8n via: Docker
  • Operating system: Windows 10

Additional info

It could be interesting to add the NocoDB Cloud endpoint:

  1. In the documentation
  2. In the n8n Host field placeholder

NocoDB user token are now decrecated: It can be removed from the doc and the file

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

Hello @LucBerge ,

I trust all is well with you. I have checked your post here.

I quickly tried to use NocoDB and everything worked fine for me. I used Mac instead with latest n8n docker.

The error UNABLE_TO_GET_ISSUER_CERT_LOCALLY suggested that the certificates from app.nocodb.com have issues in being validated in your machine/docker.

Some considerations for you:

  • Check if your Windows update is on the latest. Specially for certificates.
  • For testing purpose, consider disable strict SSL checking: Open cmd as Admin and set ==> set NODE_TLS_REJECT_UNAUTHORIZED=0. After run n8n again.
  • Manually consider add the certificates from nocodb to your Windows certificate store:
  • Visit https://app.nocodb.com in a web browser (e.g., Chrome or Firefox).
  • Click the lock icon in the address bar and view the certificate details.
  • Export the root CA certificate.
  • Open the Microsoft Management Console (MMC) by typing mmc into the Windows start menu.
  • In MMC, go to File > Add/Remove Snap-In.
  • Add the Certificates snap-in for the local computer.
  • Right-click Trusted Root Certification Authorities and choose Import.
  • Import the root CA certificate you exported.
4

Hey,
I am happy to tell you I found the solution.
It looks like my VPN and proxy were messing up with this connector authentication process. Disabling VPN and proxy solved the issue.

6

@LucBerge ,

Great catch! Yes, how could I forgot about the dreadfuls Proxies :grinning:.
Always important to check if they are part of the equation and remove them for testing purpose, at least.

Thank you for sharing the solution with the overall community.