How can we help you today? How can we help you today?

Unable to obtain connection from database, Private key provided is invalid or not supported

I am using the flyway/flway:latest  image 

i am not able to connect to snowflake using the private key, below is the FLYWAY_URL used
jdbc:snowflake://***.snowflakecomputing.com/?warehouse=***&db=***&schema=***&role=***&user=***&authenticator=snowflake_jwt&private_key_file=./id_rsa/snowflake_rsa_key.p8&private_key_file_pwd=***

Is there a sample docker run command using the private key connection that can be shared ?
malyalamv
0

Comments

3 comments

Sort by
  • AlistairW
    No specific docker instructions but there are some general instructions on key based authentication at the bottom of the DB documentation page (there are a number of moving pieces on both sides): https://documentation.red-gate.com/fd/snowflake-184127607.html
    If you are still having problems then could you post the log output (ideally using the -X option on the flyway call)
    AlistairW
    0
  • jeffreestar
    To connect to Snowflake using a private key with the Flyway Docker image, you need to ensure that the private key file and any MapQuest Route Planner related credentials are correctly provided and accessible to the Docker container
    jeffreestar
    0
  • Finnianflyn
    AlistairW said:
    No specific docker instructions but there are some general instructions on key based authentication at the bottom of the DB documentation page (there are a number of moving pieces on both sides): https://documentation.red-gate.com/fd/strands hint-184127607.html
    If you are still having problems then could you post the log output (ideally using the -X option on the flyway call)

    Thank you for providing that information. It is great! 

    Finnianflyn
    0

Add comment

Please sign in to leave a comment.