EldoS | Feel safer!

Software components for data protection, secure storage and transfer

Connecting to FTP server (unsecured) via FTPS connection

Also by EldoS: Callback File System
Create virtual file systems and disks, expose and manage remote data as if they were files on the local disk.
#10667
Posted: 07/26/2009 19:39:23
by Tom Lee (Basic support level)
Joined: 07/26/2009
Posts: 5

Hi,
I'm evaluating your product to download files from a standard FTP server using SecureBlackbox FTPS Download task and FTPS Connection Manager in my SSIS package. I'm using my company's Web proxy server to connect to the FTP server over the internet.

Since I do not wish to use a secure connection I have "Use SSL/TLS" box unchecked in the FTPS Connection properties and the FTPS Download task throws this error.

[FTPS Download Task] Error: Connection failed: Control channel transfer error Stack: at SBSimpleFTPS.TElSimpleFTPSClient.ReadFromCtl(Boolean AllowZero) at SBSimpleFTPS.TElSimpleFTPSClient.GetReply(Boolean Wait) at SBSimpleFTPS.TElSimpleFTPSClient.Login() at SecureBlackbox.SqlServer.FTPS.FTPSClientConnection.Connect()

Log file attached.

I am not sure if this error occurs in our proxy server or the external FTP server..
I have tried enabling SSL/TLS and also setting various combinations of FTPS Settings like SSL Clear Command Channel, Clear Data Channel, Implicit SSL mode with no avail.

Could you help me please?.
Tom
#10668
Posted: 07/26/2009 23:35:54
by Tom Lee (Basic support level)
Joined: 07/26/2009
Posts: 5

Some more info on this issue.

The latest BizCrypto for SQL (7.1.0.160) returns throws the same error. the Test Connection button simply says

Connection failed (BizCrypto.SqlServer.Design)

------------------------------
Program Location:

at BizCrypto.SqlServer.FTPS.FTPSConnectionManagerForm.btnTestConnection_Click(Object sender, EventArgs e)

Thanks, Tom
#10669
Posted: 07/27/2009 02:31:33
by Eugene Mayevski (EldoS Corp.)

Unfortunately there's no log attached to the message.


Sincerely yours
Eugene Mayevski
#10674
Posted: 07/27/2009 18:22:43
by Tom Lee (Basic support level)
Joined: 07/26/2009
Posts: 5

Hi here's the log. thanks. tom
#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message
OnPreValidate,W30195964,PBS\leeto,Package,{5504420B-1411-45D4-8FA9-2D3EC4A64178},{E5778CF7-F3BA-4E8F-802A-9380095CE071},28/07/2009 9:28:21 AM,28/07/2009 9:28:21 AM,0,0x,(null)
OnPreValidate,W30195964,PBS\leeto,Package,{5504420B-1411-45D4-8FA9-2D3EC4A64178},{6037082B-A3D7-4AE5-B64B-7DC6CF0FF406},28/07/2009 9:28:23 AM,28/07/2009 9:28:23 AM,0,0x,(null)
OnPostValidate,W30195964,PBS\leeto,Package,{5504420B-1411-45D4-8FA9-2D3EC4A64178},{6037082B-A3D7-4AE5-B64B-7DC6CF0FF406},28/07/2009 9:28:23 AM,28/07/2009 9:28:23 AM,0,0x,(null)
PackageStart,W30195964,PBS\leeto,Package,{5504420B-1411-45D4-8FA9-2D3EC4A64178},{6037082B-A3D7-4AE5-B64B-7DC6CF0FF406},28/07/2009 9:28:23 AM,28/07/2009 9:28:23 AM,0,0x,Beginning of package execution.

Diagnostic,W30195964,PBS\leeto,Package,{5504420B-1411-45D4-8FA9-2D3EC4A64178},{6037082B-A3D7-4AE5-B64B-7DC6CF0FF406},28/07/2009 9:28:23 AM,28/07/2009 9:28:23 AM,0,0x,Based on the system configuration, the maximum concurrent executables are set to 4.

OnPreExecute,W30195964,PBS\leeto,Package,{5504420B-1411-45D4-8FA9-2D3EC4A64178},{6037082B-A3D7-4AE5-B64B-7DC6CF0FF406},28/07/2009 9:28:23 AM,28/07/2009 9:28:23 AM,0,0x,(null)
OnInformation,W30195964,PBS\leeto,Package,{5504420B-1411-45D4-8FA9-2D3EC4A64178},{6037082B-A3D7-4AE5-B64B-7DC6CF0FF406},28/07/2009 9:28:24 AM,28/07/2009 9:28:24 AM,0,0x,Starting FTPS Download Task
OnInformation,W30195964,PBS\leeto,Package,{5504420B-1411-45D4-8FA9-2D3EC4A64178},{6037082B-A3D7-4AE5-B64B-7DC6CF0FF406},28/07/2009 9:28:24 AM,28/07/2009 9:28:24 AM,0,0x,Using SecureBlackbox.NET library 7.1.0.160
OnInformation,W30195964,PBS\leeto,Package,{5504420B-1411-45D4-8FA9-2D3EC4A64178},{6037082B-A3D7-4AE5-B64B-7DC6CF0FF406},28/07/2009 9:28:24 AM,28/07/2009 9:28:24 AM,0,0x,Setting BizCrypto license key
OnInformation,W30195964,PBS\leeto,Package,{5504420B-1411-45D4-8FA9-2D3EC4A64178},{6037082B-A3D7-4AE5-B64B-7DC6CF0FF406},28/07/2009 9:28:24 AM,28/07/2009 9:28:24 AM,0,0x,BizCrypto.SqlServer.Addons: Could not load file or assembly 'BizCrypto.SqlServer.Addons, Version=7.1.0.160, Culture=neutral, PublicKeyToken=5a62fa96d0ac431a' or one of its dependencies. The system cannot find the file specified.
OnInformation,W30195964,PBS\leeto,Package,{5504420B-1411-45D4-8FA9-2D3EC4A64178},{6037082B-A3D7-4AE5-B64B-7DC6CF0FF406},28/07/2009 9:28:24 AM,28/07/2009 9:28:24 AM,0,0x,Opening connection
OnInformation,W30195964,PBS\leeto,Package,{5504420B-1411-45D4-8FA9-2D3EC4A64178},{6037082B-A3D7-4AE5-B64B-7DC6CF0FF406},28/07/2009 9:28:24 AM,28/07/2009 9:28:24 AM,0,0x,Trying to Login
OnError,W30195964,PBS\leeto,Package,{5504420B-1411-45D4-8FA9-2D3EC4A64178},{6037082B-A3D7-4AE5-B64B-7DC6CF0FF406},28/07/2009 9:28:44 AM,28/07/2009 9:28:44 AM,0,0x,Connection failed: Control channel transfer error
OnInformation,W30195964,PBS\leeto,Package,{5504420B-1411-45D4-8FA9-2D3EC4A64178},{6037082B-A3D7-4AE5-B64B-7DC6CF0FF406},28/07/2009 9:28:44 AM,28/07/2009 9:28:44 AM,0,0x,Stack:
at SBSimpleFTPS.TElSimpleFTPSClient.ReadFromCtl(Boolean AllowZero)
at SBSimpleFTPS.TElSimpleFTPSClient.GetReply(Boolean Wait)
at SBSimpleFTPS.TElSimpleFTPSClient.Login()
at BizCrypto.SqlServer.FTPS.FTPSClientConnection.Connect()
OnInformation,W30195964,PBS\leeto,Package,{5504420B-1411-45D4-8FA9-2D3EC4A64178},{6037082B-A3D7-4AE5-B64B-7DC6CF0FF406},28/07/2009 9:28:44 AM,28/07/2009 9:28:44 AM,0,0x,FTPS Download Task finished
OnWarning,W30195964,PBS\leeto,Package,{5504420B-1411-45D4-8FA9-2D3EC4A64178},{6037082B-A3D7-4AE5-B64B-7DC6CF0FF406},28/07/2009 9:28:44 AM,28/07/2009 9:28:44 AM,-2147381246,0x,SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

OnPostExecute,W30195964,PBS\leeto,Package,{5504420B-1411-45D4-8FA9-2D3EC4A64178},{6037082B-A3D7-4AE5-B64B-7DC6CF0FF406},28/07/2009 9:28:44 AM,28/07/2009 9:28:44 AM,0,0x,(null)
PackageEnd,W30195964,PBS\leeto,Package,{5504420B-1411-45D4-8FA9-2D3EC4A64178},{6037082B-A3D7-4AE5-B64B-7DC6CF0FF406},28/07/2009 9:28:44 AM,28/07/2009 9:28:44 AM,1,0x,End of package execution.
#10676
Posted: 07/28/2009 00:54:26
by Ken Ivanov (EldoS Corp.)

The log says that the error occurs on authorization stage. Please re-check that the credentials (username and password) are valid. If they are, please set the EnableDebugOutput property of the download task to true and collect the connection log again. This might shed some light on the exact problem.
#10687
Posted: 07/28/2009 20:49:58
by Tom Lee (Basic support level)
Joined: 07/26/2009
Posts: 5

Hi thanks for the reply. I think EnableDebugOutput was enbabled and that's why the stack information is shown in the log above. I double checked FTP and proxy logon crendentials and they are correct.

Public FTP sites that allow annonymous access with no logon crendentials e.g. ftp.microsoft.com, can be accessed via my Internet Explorer with no problem but not via the BizCrypto FTP task.

When I click "Test Connection" button in FTPS Connection Settings window, after 20 seconds (transfer timeout time) it says "Connection failed (BizCrypto.SqlServer.Design) BizCrypto.SqlServer.FTPS.FTPSConnectionManagerForm.btnTestConnection_Click(Object sender, EventArgs e)"

Next question is which proxy type should I use? Our company uses BlueCoat proxy server. I tried all types but none works :(

None 0 no proxy
UserSite 1 user site proxy
Site 2 site proxy
Open 3 open proxy
Userpath 4 userpath proxy
Transparent 5 transparent proxy

Thanks,
Tom
#10688
Posted: 07/29/2009 01:11:57
by Ken Ivanov (EldoS Corp.)

Stack trace is always shown in the error log. EnableDebugOutput turned on makes the component dump detailed protocol information (a sequence of FTP commands along with the corresponding responses).

Quote
Public FTP sites that allow annonymous access with no logon crendentials e.g. ftp.microsoft.com, can be accessed via my Internet Explorer with no problem but not via the BizCrypto FTP task.

Anonymous sites use standard credentials which must be supplied:
Username: anonymous
Password: some non-empty character sequence (e.g., "password").

Can you please specify the exact BlueCoat product you are using (there's a dozen of proxy-like products available on their site)? An example of network configuration of some third-party application might help as well.
#10689
Posted: 07/29/2009 01:49:58
by Tom Lee (Basic support level)
Joined: 07/26/2009
Posts: 5

Hi there,

Quote
Anonymous sites use standard credentials which must be supplied:
Username: anonymous
Password: some non-empty character sequence (e.g., "password").


sorry I meant FTP that requires no user authentication. Should I leave the username and password fileds blank in that case?


Quote
Stack trace is always shown in the error log. EnableDebugOutput turned on makes the component dump detailed protocol information (a sequence of FTP commands along with the corresponding responses)


Yes it's turned ON. Where in SSIS can I find the debug information?

Thanks,
#10691
Posted: 07/29/2009 03:09:00
by Ken Ivanov (EldoS Corp.)

Quote
sorry I meant FTP that requires no user authentication. Should I leave the username and password fileds blank in that case?

Such servers are usually referenced as anonymous FTP. In most of the cases you should use the above scheme with "anonymous" username.

Quote
Yes it's turned ON. Where in SSIS can I find the debug information?

Debug events are reported to the system event log (as informational events).
Also by EldoS: CallbackFilter
A component to monitor and control disk activity, track file and directory operations (create, read, write, rename etc.), alter file data, encrypt files, create virtual files.

Reply

Statistics

Topic viewed 3909 times

Number of guests: 1, registered members: 0, in total hidden: 0




|

Back to top

As of July 15, 2016 EldoS Corporation will operate as a division of /n software inc. For more information, please read the announcement.

Got it!