RVR-RDBMS-202
Issue summary
- The error "Failed to ssh server" with Error Code: RVR-RDBMS-202 in the Data Integration platform indicates a failure in establishing an SSH connection required for accessing an RDBMS. This issue can arise due to a variety of connectivity issues, such as incorrect SSH configurations, networking issues, or firewall restrictions that block SSH communication between Data Integration and the server.
Action steps
To resolve the error, follow these steps:
- Verify SSH Configuration:
- Ensure that your SSH server is configured to accept connections from Data Integration IP addresses.
- Check that your SSH hostname, username, and private key path are correctly entered in the Data Integration SSH configuration settings.
- Network and Firewall Settings:
- Confirm that the firewall rules allow incoming and outgoing connections on the necessary SSH ports, typically port 22.
- Allowlist Data Integration’s IP addresses on your firewall to ensure packets from Data Integration are not blocked.
- SSH Keys and Authentication:
- Ensure that the public SSH key used by Data Integration is correctly added to the
authorized_keysfile on your server。 - Double-check the permissions of the
authorized_keysfile (should be readable and writable only by the user).
- Ensure that the public SSH key used by Data Integration is correctly added to the
- Test SSH Connection:
- Use an external SSH client to test the connection from outside your network using the same credentials to confirm that the issue is not specific to Data Integration.
External references
- For detailed guidance on setting up an SSH Tunnel using Data Integration, refer to the official documentation: Data Integration - SSH Tunnel Setup.
- General SSH connection troubleshooting: OpenSSH Manual.
note
If the issue persists or you need help, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.
