CSV Advanced - connection error - "Could not load known_hosts"
Hi,
I'm trying to setup a CSV Advanced connector to pull in data from a client.
The client has whitelisted the IP addresses per the documentation, provided a login ID/password, and provided the external URLs for the SFTP. I also have an exact file name I can choose the connector to look for.
I'm able to get the CSV Advanced connector to run, but keep getting this error: "Could not load known_hosts"
I've also tried the CSV-SFTP connector and got two different errors: "java.net.ConnectException: Connection refused (Connection refused)" and also "java.net.UnknownHostException: mpcftp.mgroupnet.com"
Anyone else have this error before? Was it due to the connector or due to the SFTP server?
Thank you!
Comments
-
@user08142 2 questions and you've probably already looked here but just a thought:
1. Have you tested the connection to the SFTP server with something other than Domo to ensure the credentials were valid?
2. Have you opened the csv file to ensure that it was saved as a csv and doesn't just look like one?
May not help as I've not run into this, just trying to think of what I would check.
Matt
0 -
@NewsomSolutions Thanks for offering your questions!
We are going to have to ask our client to add our own company IP (per DOMO's feedback). I've also noticed that there's IP addresses on this recent article (https://knowledge.domo.com/@api/deki/pages/5028/pdf/Whitelisting%2bIP%2bAddresses%2bfor%2bConnectors.pdf?stylesheet=default), but not in the CSV advanced documentation (https://knowledge.domo.com/Connect/Connecting_to_Data_with_Connectors/Configuring_Each_Connector/Connectors_for_File_Retrieval/CSV_Advanced_Connector).
Have you come across this discrepancy before by chance?
Also, the CSV file is definitely a csv. Our client sent a test back in March via email, so that shouldn't be the issue. Thank you!
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 98 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 713 Beast Mode
- 50 App Studio
- 39 Variables
- 669 Automate
- 170 Apps
- 447 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 104 Community Announcements
- 4.8K Archive