search

ibmdb / vscode-extension

vscode extenstion for db2 as db2connect
7 stars 2 forks source link

Failed to connect to ip address/location: No available keyring backend found on osx arm64 #59

Closed netskink closed 1 year ago

netskink commented 1 year ago

Failed to connect to ip address/location: No available keyring backend found on osx arm64

Platform Info

Interesting the versions at the terminal are different from what is reported by viscode.?.?.!

Steps to Reproduce:

  1. Download openjdk tar file from openjdk.org
  2. unpack tar file
  3. copy jdk dir to /Library/Java/JavaVirtualMachines/ this creates a /Library/Java/JavaVirtualMachines/jdk-19.0.2.jdk with a /Library/Java/JavaVirtualMachines/jdk-19.0.2.jdk/Contents/Home/bin/java vm. Interesting is that even though I have another jvm setup, this setup on osx automatically picks the new java jvm. eg: 
    $  /Library/Java/JavaVirtualMachines/jdk-19.0.2.jdk/Contents/Home/bin/java --version
openjdk 19.0.2 2023-01-17
OpenJDK Runtime Environment (build 19.0.2+7-44)
OpenJDK 64-Bit Server VM (build 19.0.2+7-44, mixed mode, sharing)
$ which java
/usr/bin/java
$  /usr/bin/java --version
openjdk 19.0.2 2023-01-17
OpenJDK Runtime Environment (build 19.0.2+7-44)
OpenJDK 64-Bit Server VM (build 19.0.2+7-44, mixed mode, sharing)
  4. Install extension
  5. Modify extension @ext:IBM.db2forzosdeveloperextension > JAVA:Home to be /Library/Java/JavaVirtualMachines/jdk-19.0.2.jdk/Contents/Home
  6. setup a connection according to procedure documented here:
  7. click connection chain icon.

Result:

Failed to connect to 204.90.115.200/DALLASC: No available keyring backend found

Source: IBM Db2 for z/OS Developer Extension (Extension)
netskink commented 1 year ago

I tried another approach.

I made a dir in my home directory named savethis. I used finder to move the /Applications/Visual Studio Code icon to ~/savethis. Essentially uninstalling my original arm version of vscode.

I then used finder to launch the intel version of vscode in ~/Downloads. It runs with the same extensions as before and looks like my previous installation of vscode. However, it runs much slower. Much, much slower.

I navigated to the DB2 Developer Extension and attempted to connect to 204.90.115.200/Dallasc and got the same error as before.

Perhaps I need to move my ~/.vscode dir to remove my extensions. I'll try that.

netskink commented 1 year ago

Hmm. I closed the intel version of vscode. I moved my ~/.vscode dir to ~/savethis. I started the intel version again. It did not have any extensions installed.

I installed the IBM Db2 developer extension for z/OS. Oddly it already had my settings preserved from the previous install. The setting for JDK was already present. The Db2 for z/OS connection with 204.90.115.200/DALLASC was present. Attempting to connect to the host resulted in the same error. Failed to connect ...:No available keyring

bimalkjha commented 1 year ago

@netskink This repo is for IBM Db2 Connect extension : https://marketplace.visualstudio.com/items?itemName=IBM.Db2Connect and not for IBM Db2 developer extension for z/OS. So, you have opened issue against wrong repo. If you want to use our repo, then please install Db2Connect extension which provides connectivity to z/OS too. More details you can find here: https://community.ibm.com/community/user/datamanagement/blogs/sujan-ghosh1/2020/07/14/vs-code-extension-for-db2connect

netskink commented 1 year ago

Hmm. I am trying to find your extension in vscode. I searched for "IBM Db2 Connect" and the first one that pops up is "IBM Cloud Account". Is yours in the vscode extension marketplace?

Do you know the GitHub for the "IBM Db2 for z/OS Developers"?

netskink commented 1 year ago

Ahh, I found it via "Db2 Connect"

bimalkjha commented 1 year ago

@netskink You need to search for "Db2Connect" to find this extension. IBM Db2 for z/OS Developers is not open source and it can not be found on github. You need to contact IBM Support for it. Thanks.

netskink commented 1 year ago

Ahh, many thanks. I appreciate your help.