FTP SSL/TLS Problems

Toad for Oracle
1

I'm working with Automation Designer and FTP, We have a site that we send to that must have SSL/TLS utilized, and I was wondering if there was a way to enable this in Toad.
My setup is Windows 10 (64b), Toad for Oracle 12.9.0.71, Oracle instantclient_19_3.
Thanks

Dario

2

Hi Dario,

Have you tried checking the Secure FTP / SSH option in server settings when adding the host?

image
image.png532×550 28 KB

Mike

3

Yes Mike. If it is helpful I can post the error at toad log ..
thanks for your prompt response :wink:
Dario

4

I had to ask. :slight_smile:

Yes,the log might be helpful. Also, do you know what version of SSL/TLS you're running on the server?

Mike

5

Using another ftp client says Using TLSv1.2, cipher TLSv1/SSLv3... Dario

6

2.1 Date : Fri, 20 Sep 2019 15:58:52 -0300
2.2 Address : 0000000006E7571D
2.3 Module Name: Toad.exe - (Toad™ for Oracle®)
2.5 Type : Exception
2.6 Message : Logon to PADRON.FTP.XXXXX.XXX.AR:21 as 125707 failed: Socket error 0: A connection request that was already accepted could not be completed.
2.7 ID : 51380000
2.8 Count : 1
2.11 Sent : 0

7

Thank you for the information!

I've tested Toad for Oracle 12.9 with a public test ftp server (https://test.rebex.net/) which connects okay. I also spun up my own local SFTP server and I was able to connect to it as well.

Using the FTP window within Toad (Utilities > FTP) are you able to connect to the public server I mentioned above? I assume you'll be able to since another client connects to your personal server okay but better to verify than to not.

The test credentials are:
server - test.rebex.net
username - demo
password - password

8

Mike: I can use many other FTP without problems...
There is only one provider use "explicit" FTPS over TLS, see the attached image.ftp-tls

9

Ah, that sounds like the issue. Toad for Oracle currently supports only FTP and SFTP, not FTPS.

Mike

10

:cry:
Thanks a lot Mike! Is there a way to make a request or consult to the development team?

11

Sorry, I know that wasn't the answer you were looking for.

There is a way to request it though! https://forums.toadworld.com/c/toad-for-oracle/idea-pond

I'll make note of this as well but can't make any promises. FTPS is sort of on the outs with SFTP being the successor.

Mike

12

Thank you for all the info! You're great.