For a deeper look into our DataScope Select REST API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
Lukasz Ossowski avatar image
22 ●4 ●4 ●9

Problems with DSS FTP connection with Client WinSCP or automated script.

I have been attempting to get our automated script to connect to our site hosted.datascope.reuters.com.

When I test the connection with the client, CoreFTP, I AM successful using

Server: hosted.datascope.reuters.com/reports/

Port: 22

User: r9025260

Pass: xxxxxx (obscured) and no private key


I am NOT successful if I use the Client WinSCP

OR my automated script.


What I get back as a return value from your server is as follows:


“<?xml version="1.0"?><FTPResults xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><Success>false</Success><Msg>Connection has been unexpectedly closed. Server sent command exit status 0.

Authentication log (see session log for details):

Using username "r9025260".

Access denied.


Authentication failed.</Msg><FileInfo><string xsi:nil="true" /></FileInfo></FTPResults>"


Can you please have someone look at the log for this user and see if it reveals why one way works and the other doesn’t? Each method should be presenting the same public key.

dss-rest-apidatascope-selectdssFTPsftp
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

zoya faberov avatar image   zoya faberov

Hello @Lukasz Ossowski,

Thank you for your participation in the forum.

Is one of the replies below satisfactory in resolving your query? If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

-AHS

2 Answers

· Write an Answer
Upvotes
Accepted
Gurpreet avatar image
22k ●58 ●14 ●21

Hi @Lukasz Ossowski,

I have tried with latest WinSCP and have been able to connect both FTP and SFTP.

Like OpenSSL, WinSCP uses its own certificate store and prompted me to accept the new certificate - the first time I connected.

I would recommend that you update to the latest version and clear your old cached certificates.


ahs1.png (35.9 KiB)
ahs2.png (59.0 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Gurpreet avatar image
22k ●58 ●14 ●21

Also, you can refer to this DSS ftp user guide.

Here is the same thing with CURL. You will need to manually import the RSA certificate into the OpenSSL trusted certificates list to avoid using the -k (insecure) switch.

>>>curl -k "sftp://hosted.datascope.reuters.com" --user "r999999:password"
drwxr-s---    6 109011672 30000           6 Mar 23  2017 .
drwxr-s---    6 109011672 30000           6 Mar 23  2017 ..
drwxrws---    2 101      30000          58 Sep 15 10:20 reports
drwxr-s---    3 101      30000           3 Sep 17  2018 feeds
drwx------    2 109011672 30000           2 Mar 23  2017 .ssh
drwxrws---    3 101      30000           3 Mar 23  2017 incoming
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.