sqltools-snowflake-driver icon indicating copy to clipboard operation
sqltools-snowflake-driver copied to clipboard

Key Pair didn't work - UNKNOWN_ALGORITHM

Open kardizzone opened this issue 2 years ago • 2 comments

It seems PKCS8 is not supported? It was the default suggested by Snowflake when following their instructions here: https://docs.snowflake.com/en/user-guide/key-pair-auth.html

Error output from VS Code is:

[1661205581755] INFO (ls): Connection instance created for SFKeyPair. ns: "conn-manager" [1661205581756] ERROR (ls): Connecting error: {"code":-32001,"data":{"driver":"Snowflake","driverOptions":{}},"name":"Error"} ns: "conn-manager" [1661205581757] ERROR (ext): ERROR: Error opening connection error:13000077:PKCS8 routines:OPENSSL_internal:UNKNOWN_ALGORITHM, {"code":-32001,"data":{"driver":"Snowflake","driverOptions":{}}} ns: "error-handler"

kardizzone avatar Aug 22 '22 22:08 kardizzone

I was able to work around this by converting my encrypted private key to an unencrypted version, and configuring the connection to use that:

openssl pkcs8 -in rsa_key.p8 -topk8 -out rsa_key_unencrypted.p8 -nocrypt

alexnorton avatar Apr 12 '23 11:04 alexnorton

When I try @alexnorton solution I get this other error:

Could not read key from my_rsa_key.p8 8045180501000000:error:1608010C:STORE routines:ossl_store_handle_load_result:unsupported:crypto/store/store_result.c:151: 8045180501000000:error:0308010C:digital envelope routines:inner_evp_generic_fetch:unsupported:crypto/evp/evp_fetch.c:341:Global default library context, Algorithm (PBKDF1 : 0), Properties ()

rmenendezm avatar Sep 20 '23 17:09 rmenendezm