Module: External Database Connector - Snowflake: impossible to connect with a privatekey and password

0
Hello, I'm encountering issues while connecting a Snowflake database to a Mendix application (version 10.12.1) using the External Database Connector module from the Mendix Marketplace (https://marketplace.mendix.com/link/component/219862?_gl=1*168nms5*_gcl_au*MTU4MTIyNTg2OS4xNzI1NTIxNzYw). I have all the necessary information to establish the connection, except for my PrivateKey which is in (.pem) format. When I paste my key into the module's connection interface using 'connection details' and 'Key Pair', I receive the error:   Error: Could not read private key with value passed in connection string. Error : incorrect private key value or private key format: use ‘\n’ for newlines and double the equals sign. SqlState:, VendorCode: 270052, QueryId:   I have attempted to reformat the key as a single line and replace newlines with '\n', as suggested in the error message and the documentation (https://docs.mendix.com/appstore/modules/snowflake/external-database-connector/). However, I continue to receive the same error.     My private key is of type RSA (Proc-Type: 4, ENCRYPTED).
asked
2 answers
1

I'm having the same problem as you Harold. I already used the website sent by Sharad, but I keep getting the same error message in Mendix. You can find more details on the link below:

 

https://community.mendix.com/link/space/snowflake/questions/140219

 

 

answered
0

Hi Harold,

you can use this website https://certlogik.com/decoder/ , just paste your private key and click on decode , it will format your private key

answered