Oracle NoSQL Database connector in vscode gives NoSQLUnauthorized error

Question

Error fetching Tables : NoSQLAuthorizationError: [REQUEST_TIMEOUT] Authorization error: [operation timeout]: Failed to login to kvstore. Operation timed out, see the cause

Answer 1

In a secure mode, the proxy requires an SSL Certificate and private key. You need to provide the certificate in order to use the Oracle NoSQL Database connector in vscode

Without the good certificate, you will have the following error:

NoSQLAuthorizationError: [REQUEST_TIMEOUT] Authorization error: 
[operation timeout]: Failed to login to kvstore.  
Operation timed out, see the cause

We are supposed to use the certificate file text box to do it.

But it seems that it is not working in Windows. I am able to reproduce the issue described here.

In the meantime, could you test one of the following workarounds?

1. file -> Preferences -> Settings -> Application -> Proxy and in the "Proxy Support" menu select "off".
2. Add the self-signed certificate to the trusted root store in your Windows configuration (using Microsoft Management Console)
3. Set the following environment variable in your Windows configuration NODE_TLS_REJECT_UNAUTHORIZED=0

Note: When the HTTP Proxy is not running or you cannot reach it, you will have the same error

Error fetching Tables : NoSQLAuthorizationError: [REQUEST_TIMEOUT]
Authorization error: [operation timeout]: Failed to login to kvstore. 
Operation timed out, see the cause

It is only happening when using self-signed certificates.