Data source integration SFTP

Kanika4
Tera Contributor

We have a requirement to pull data from SFTP folder using SSH credentials.

Currently we created a SFTP data source put User and Password, server, port, path and its for working from the terminal.

 

But when trying to configure it from our serviceNow instance, we are getting the below error:

 

com.glide.db.impex.datasource.DataSourceException: java.io.IOException: SSH authentication failed, SSH connected, but user not authenticated

 

Has anyone faced this issue before or can guide us what can be the cause of this issue ?

3 REPLIES 3

Ratnakar7
Mega Sage
Mega Sage

Hi @Kanika4 ,

 

There could be several reasons for this issue. Here are some troubleshooting steps you can follow:

  1. Verify SSH credentials: Double-check the SSH username and password you provided in the ServiceNow SFTP data source configuration. Make sure they are correct and have the necessary permissions to access the SFTP server.

  2. Check SSH key-based authentication: If your SFTP server uses SSH key-based authentication instead of username/password authentication, you'll need to configure the data source accordingly. In the data source configuration, select the "SSH Key" option and provide the path to the private key file (.pem or .key) associated with the SSH user.

  3. Confirm SFTP server details: Ensure that the server address, port number, and path are correctly specified in the data source configuration. Double-check these details with your SFTP server administrator to ensure they are accurate.

  4. Test connectivity using a standalone SFTP client: Try connecting to the SFTP server using a standalone SFTP client tool (e.g., FileZilla, WinSCP) with the same credentials. This will help verify if the issue is specific to the ServiceNow integration or if there is a broader connectivity problem.

  5. Verify firewall and network settings: Ensure that the necessary network ports are open and accessible between your ServiceNow instance and the SFTP server. Consult with your network or firewall administrator to verify if any network restrictions or firewalls are blocking the connection.

  6. Review SFTP server logs: Check the logs on the SFTP server side for any additional error messages or clues about the authentication failure. The server logs may provide more specific details about the cause of the issue.

 

Thanks,

Ratnakar

WarremJardine
Giga Contributor

Hi Ratnakar7

 

Where do you find the "SSH Key" option to enter the path of the private key file ? The Data source form only provides options for username and password ?

 

  1. Check SSH key-based authentication: If your SFTP server uses SSH key-based authentication instead of username/password authentication, you'll need to configure the data source accordingly. In the data source configuration, select the "SSH Key" option and provide the path to the private key file (.pem or .key) associated with the SSH user.

Did you get an answer to this question?  I cannot find the SSH Key option either