RVR-SF-RDBMS-305

1. Issue Summary

   • Error Code: RVR-SF-RDBMS-305 with the description "Failed to get the private key bytes" indicates an issue related to Key-Pair Authentication, possibly not retrieving or accessing the necessary private key bytes for the RDBMS (Relational Database Management System) data connector within Rivery.
   • This kind of error is typically associated with issues in properly handling or accessing the private key used for authentication, most likely in the context of a Snowflake database connection.

2. Action Steps:

   • Verify Key-Pair Configuration: Ensure that the private key file is correctly generated and formatted. Key-Pair authentication in Rivery requires a PEM format private key.
   • Generate Private Key:
     • On a compatible platform (Mac/Linux), generate an unencrypted private key using the command:

       openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -out rsa_key.p8 -nocrypt
       

     • Make sure the private key is accessible and correctly referenced in your Rivery connection configuration.
   • Assign Public Key: The public key derived from this private key should be set correctly in your Snowflake account using SQL commands such as:

     alter user <Username> set rsa_public_key='<public_key_content>';
     

   • Test Connection: Use the "Test Connection" feature in Rivery to verify that the connection attributes work correctly. This will help ensure that both the private and public key configurations are correct.
   • Re-upload and Reference the Key: Ensure the .p8 file (your private key) is correctly uploaded to Rivery and referenced in your Snowflake connection settings in Rivery.

3. External References:

   • Rivery Documentation on Key-Pair Authentication
   • Snowflake Documentation on Key-Pair Authentication

If the issue persists or you need further assistance, please open a ticket with Rivery support.