vscode中的Oracle NoSQL数据库连接器出现NoSQLUnauthorized错误

cld4siwp  于 2022-12-11  发布在  Oracle
关注(0)|答案(1)|浏览(261)

获取表时出错:无SQL授权错误:[REQUEST_TIMEOUT]授权错误:[操作超时]:登录kvstore失败。操作超时,请查看原因

8wigbo56

8wigbo561#

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.

相关问题