Post a reply

Before posting, please read how to report bug or request support effectively.

Bug reports without an attached log file are usually useless.

Options
Add an Attachment

If you do not want to add an Attachment to your Post, please leave the Fields blank.

(maximum 10 MB; please compress large files; only common media, archive, text and programming file formats are allowed)

Options

Topic review

martin

Thanks. Though I didn't find any clue. Did you check server-side logs for any hints, why it closes the connection?
rejish

. 2022-07-28 08:13:20.559 --------------------------------------------------------------------------
. 2022-07-28 08:13:20.560 WinSCP Version 5.21.1 (Build 12643 2022-06-24) (OS 10.0.22000 - Windows 10 Enterprise)
. 2022-07-28 08:13:20.560 Configuration: HKCU\Software\Martin Prikryl\WinSCP 2\
. 2022-07-28 08:13:20.560 Log level: Normal
. 2022-07-28 08:13:20.560 Local account: xxxx/xxxxxxxxxxxxxxxx
. 2022-07-28 08:13:20.560 Working directory: C:\Program Files (x86)\WinSCP
. 2022-07-28 08:13:20.560 Process ID: 12948
. 2022-07-28 08:13:20.573 Ancestor processes: explorer, ...
. 2022-07-28 08:13:20.573 Command-line: "C:\Program Files (x86)\WinSCP\WinSCP.exe"
. 2022-07-28 08:13:20.573 Time zone: Current: GMT+1, Standard: GMT+0 (GMT Standard Time), DST: GMT+1 (GMT Daylight Time), DST Start: 27/03/2022, DST End: 30/10/2022
. 2022-07-28 08:13:20.573 Login time: 28 July 2022 08:13:20
. 2022-07-28 08:13:20.573 --------------------------------------------------------------------------
. 2022-07-28 08:13:20.573 Session name: 10959795@mcklpln5v8k6gjwl2bjmvtlz81jm.ftp.marketingcloudops.com (Site)
. 2022-07-28 08:13:20.573 Host name: mcklpln5v8k6gjwl2bjmvtlz81jm.ftp.marketingcloudops.com (Port: 22)
. 2022-07-28 08:13:20.573 User name: 10959795 (Password: Yes, Key file: No, Passphrase: No)
. 2022-07-28 08:13:20.574 Tunnel: No
. 2022-07-28 08:13:20.574 Transfer Protocol: SFTP (SCP)
. 2022-07-28 08:13:20.574 Ping type: Off, Ping interval: 30 sec; Timeout: 15 sec
. 2022-07-28 08:13:20.574 Disable Nagle: No
. 2022-07-28 08:13:20.574 Proxy: None
. 2022-07-28 08:13:20.574 Send buffer: 262144
. 2022-07-28 08:13:20.574 Compression: No
. 2022-07-28 08:13:20.574 Bypass authentication: No
. 2022-07-28 08:13:20.574 Try agent: Yes; Agent forwarding: No; KI: Yes; GSSAPI: Yes
. 2022-07-28 08:13:20.574 GSSAPI: KEX: No; Forwarding: No; Libs: gssapi32,sspi,custom; Custom:
. 2022-07-28 08:13:20.574 Ciphers: aes,chacha20,blowfish,3des,WARN,arcfour,des; Ssh2DES: No
. 2022-07-28 08:13:20.574 KEX: ecdh,dh-gex-sha1,dh-group14-sha1,rsa,WARN,dh-group1-sha1
. 2022-07-28 08:13:20.574 SSH Bugs: Auto,Auto,Auto,Auto,Auto,Auto,Auto,Auto,Auto,Auto
. 2022-07-28 08:13:20.574 Simple channel: Yes
. 2022-07-28 08:13:20.574 Return code variable: Autodetect; Lookup user groups: Auto
. 2022-07-28 08:13:20.574 Shell: default
. 2022-07-28 08:13:20.574 EOL: LF, UTF: Auto
. 2022-07-28 08:13:20.574 Clear aliases: Yes, Unset nat.vars: Yes, Resolve symlinks: Yes; Follow directory symlinks: No
. 2022-07-28 08:13:20.574 LS: ls -la, Ign LS warn: Yes, Scp1 Comp: No; Exit code 1 is error: No
. 2022-07-28 08:13:20.574 SFTP Bugs: Auto,Auto
. 2022-07-28 08:13:20.574 SFTP Server: default
. 2022-07-28 08:13:20.574 Local directory: C:\Users\rejish.varghese\Documents, Remote directory: /Import/Automated_Reports, Update: Yes, Cache: Yes
. 2022-07-28 08:13:20.574 Cache directory changes: Yes, Permanent: Yes
. 2022-07-28 08:13:20.574 Recycle bin: Delete to: No, Overwritten to: No, Bin path:
. 2022-07-28 08:13:20.574 DST mode: Unix
. 2022-07-28 08:13:20.574 --------------------------------------------------------------------------
. 2022-07-28 08:13:20.621 Looking up host "mcklpln5v8k6gjwl2bjmvtlz81jm.ftp.marketingcloudops.com" for SSH connection
. 2022-07-28 08:13:20.674 Connecting to 68.232.201.173 port 22
. 2022-07-28 08:13:20.825 Connected to 68.232.201.173
. 2022-07-28 08:13:20.841 We claim version: SSH-2.0-WinSCP_release_5.21.1
. 2022-07-28 08:13:20.841 Connected to 68.232.201.173
. 2022-07-28 08:13:21.138 Remote version: SSH-2.0-7.9.0.0_openssh GlobalSCAPE
. 2022-07-28 08:13:21.139 Using SSH protocol version 2
. 2022-07-28 08:13:21.142 Have a known host key of type rsa2
. 2022-07-28 08:13:21.143 Have a known host key of type dss
. 2022-07-28 08:13:21.276 Doing Diffie-Hellman group exchange
. 2022-07-28 08:13:21.496 Doing Diffie-Hellman key exchange using 8192-bit modulus and hash SHA-256 with a server-supplied group
. 2022-07-28 08:13:43.990 Host key fingerprint is:
. 2022-07-28 08:13:43.991 ssh-rsa 3072 SHA256:bFCXgHdgCzL7mYTH8PZoSmYyiq0ryMDkYzk1Z2YfIeE
. 2022-07-28 08:13:44.057 Host key matches cached key
. 2022-07-28 08:13:44.059 Initialised AES-256 SDCTR (AES-NI accelerated) [aes256-ctr] outbound encryption
. 2022-07-28 08:13:44.059 Initialised HMAC-SHA-256 outbound MAC algorithm
. 2022-07-28 08:13:44.060 Initialised AES-256 SDCTR (AES-NI accelerated) [aes256-ctr] inbound encryption
. 2022-07-28 08:13:44.060 Initialised HMAC-SHA-256 inbound MAC algorithm
! 2022-07-28 08:13:44.196 Using username "10959795".
. 2022-07-28 08:13:47.837 Server offered these authentication methods: password
. 2022-07-28 08:13:47.837 Prompt (password, "SSH password", <no instructions>, "&Password: ")
. 2022-07-28 08:13:47.837 Using stored password.
. 2022-07-28 08:13:47.865 Sent password
. 2022-07-28 08:13:48.025 Access granted
. 2022-07-28 08:13:48.026 Opening main session channel
. 2022-07-28 08:13:48.158 Opened main channel
. 2022-07-28 08:13:48.290 Started a shell/command
. 2022-07-28 08:13:48.316 --------------------------------------------------------------------------
. 2022-07-28 08:13:48.316 Using SFTP protocol.
. 2022-07-28 08:13:48.316 Doing startup conversation with host.
> 2022-07-28 08:13:48.331 Type: SSH_FXP_INIT, Size: 5, Number: -1
< 2022-07-28 08:13:48.464 Type: SSH_FXP_VERSION, Size: 5, Number: -1
. 2022-07-28 08:13:48.464 SFTP version 3 negotiated.
. 2022-07-28 08:13:48.464 We believe the server has signed timestamps bug
. 2022-07-28 08:13:48.464 We will use UTF-8 strings until server sends an invalid UTF-8 string as with SFTP version 3 and older UTF-8 strings are not mandatory
. 2022-07-28 08:13:48.464 Changing directory to "/Import/Automated_Reports".
. 2022-07-28 08:13:48.464 Getting real path for '/Import/Automated_Reports'
> 2022-07-28 08:13:48.464 Type: SSH_FXP_REALPATH, Size: 34, Number: 6160
< 2022-07-28 08:13:48.600 Type: SSH_FXP_NAME, Size: 71, Number: 6160
. 2022-07-28 08:13:48.600 Real path is '/Import/Automated_Reports'
. 2022-07-28 08:13:48.600 Trying to open directory "/Import/Automated_Reports".
> 2022-07-28 08:13:48.600 Type: SSH_FXP_LSTAT, Size: 34, Number: 6407
< 2022-07-28 08:13:48.733 Type: SSH_FXP_ATTRS, Size: 21, Number: 6407
. 2022-07-28 08:13:48.733 Getting current directory name.
. 2022-07-28 08:13:48.813 Listing directory "/Import/Automated_Reports".
> 2022-07-28 08:13:48.813 Type: SSH_FXP_OPENDIR, Size: 34, Number: 6667
< 2022-07-28 08:13:48.950 Type: SSH_FXP_HANDLE, Size: 10, Number: 6667
> 2022-07-28 08:13:48.951 Type: SSH_FXP_READDIR, Size: 10, Number: 6924
< 2022-07-28 08:13:49.081 Type: SSH_FXP_NAME, Size: 987, Number: 6924
> 2022-07-28 08:13:49.082 Type: SSH_FXP_READDIR, Size: 10, Number: 7180
< 2022-07-28 08:13:49.212 Type: SSH_FXP_STATUS, Size: 28, Number: 7180
< 2022-07-28 08:13:49.212 Status code: 1
> 2022-07-28 08:13:49.212 Type: SSH_FXP_CLOSE, Size: 10, Number: 7428
. 2022-07-28 08:13:49.212 _gsdata_;d;0;2021-09-09T09:49:15.000Z;4;"user" [0];"group" [0];rwxrw-rw-;1
. 2022-07-28 08:13:49.213 ..;D;0;1899-12-30T00:00:00.000Z;0;"" [0];"" [0];---------;0
. 2022-07-28 08:13:49.263 Startup conversation with host finished.
martin

Re: SFTP to host fails with error as type 11

Can you post also log of the working session from your laptop?
rejish

SFTP to host fails with error as type 11

When I try to connect to mcklpln5v8k6gjwl2bjmvtlz81jm.ftp.marketingcloudops.com from SQL Server it fails and I am attaching log file below. I used the same version on my laptop and it works so that means the login details and password is correct. I tried FileZilla on the same SQL server and I am able to connect to the same host. Can you please help in solving this as I am struggling with this and don't want to manually upload 5 files 7 days a week?
. 2022-07-27 12:02:08.006 --------------------------------------------------------------------------
. 2022-07-27 12:02:08.022 WinSCP Version 5.21 (Build 12524 2022-06-15) (OS 6.3.9600 - Windows Server 2012 R2 Datacenter)
. 2022-07-27 12:02:08.022 Configuration: nul
. 2022-07-27 12:02:08.022 Log level: Normal
. 2022-07-27 12:02:08.022 Local account: xxxxxxxx\xxxxxxxxxxxxxxxxxx
. 2022-07-27 12:02:08.022 Working directory: B:\Apps\SKNManager\SL350_AppointmentsIn72Hrs\Files\BatchFile
. 2022-07-27 12:02:08.022 Process ID: 7324
. 2022-07-27 12:02:08.022 Ancestor processes: ...
. 2022-07-27 12:02:08.022 Command-line: "C:\Program Files (x86)\WinSCP\WinSCP.exe" /log="B:\Apps\SKNManager\SL350_AppointmentsIn72Hrs\Files\BatchFile\WinSCP.log" /ini=nul /script="B:\Apps\SKNManager\SL350_AppointmentsIn72Hrs\Files\BatchFile\AppointmentIn72Hrs_UploadFile.txt"
. 2022-07-27 12:02:08.022 Time zone: Current: GMT+1, Standard: GMT+0 (GMT Standard Time), DST: GMT+1 (GMT Daylight Time), DST Start: 27/03/2022, DST End: 30/10/2022
. 2022-07-27 12:02:08.022 Login time: 27 July 2022 12:02:08
. 2022-07-27 12:02:08.022 --------------------------------------------------------------------------
. 2022-07-27 12:02:08.022 Script: Retrospectively logging previous script records:
> 2022-07-27 12:02:08.022 Script: open sftp://10959795:***@mcklpln5v8k6gjwl2bjmvtlz81jm.ftp.marketingcloudops.com/ -hostkey="ssh-rsa 3072 bFCXgHdgCzL7mYTH8PZoSmYyiq0ryMDkYzk1Z2YfIeE"
. 2022-07-27 12:02:08.022 --------------------------------------------------------------------------
. 2022-07-27 12:02:08.022 Session name: 10959795@mcklpln5v8k6gjwl2bjmvtlz81jm.ftp.marketingcloudops.com (Ad-Hoc site)
. 2022-07-27 12:02:08.022 Host name: mcklpln5v8k6gjwl2bjmvtlz81jm.ftp.marketingcloudops.com (Port: 22)
. 2022-07-27 12:02:08.022 User name: 10959795 (Password: Yes, Key file: No, Passphrase: No)
. 2022-07-27 12:02:08.022 Tunnel: No
. 2022-07-27 12:02:08.022 Transfer Protocol: SFTP
. 2022-07-27 12:02:08.022 Ping type: Off, Ping interval: 30 sec; Timeout: 15 sec
. 2022-07-27 12:02:08.022 Disable Nagle: No
. 2022-07-27 12:02:08.022 Proxy: None
. 2022-07-27 12:02:08.022 Send buffer: 262144
. 2022-07-27 12:02:08.022 Compression: No
. 2022-07-27 12:02:08.022 Bypass authentication: No
. 2022-07-27 12:02:08.022 Try agent: Yes; Agent forwarding: No; KI: Yes; GSSAPI: Yes
. 2022-07-27 12:02:08.022 GSSAPI: KEX: No; Forwarding: No; Libs: gssapi32,sspi,custom; Custom:
. 2022-07-27 12:02:08.022 Ciphers: aes,chacha20,blowfish,3des,WARN,arcfour,des; Ssh2DES: No
. 2022-07-27 12:02:08.022 KEX: ecdh,dh-gex-sha1,dh-group14-sha1,rsa,WARN,dh-group1-sha1
. 2022-07-27 12:02:08.022 SSH Bugs: Auto,Auto,Auto,Auto,Auto,Auto,Auto,Auto,Auto,Auto
. 2022-07-27 12:02:08.022 Simple channel: Yes
. 2022-07-27 12:02:08.022 Return code variable: Autodetect; Lookup user groups: Auto
. 2022-07-27 12:02:08.022 Shell: default
. 2022-07-27 12:02:08.022 EOL: LF, UTF: Auto
. 2022-07-27 12:02:08.022 Clear aliases: Yes, Unset nat.vars: Yes, Resolve symlinks: Yes; Follow directory symlinks: No
. 2022-07-27 12:02:08.022 LS: ls -la, Ign LS warn: Yes, Scp1 Comp: No; Exit code 1 is error: No
. 2022-07-27 12:02:08.022 SFTP Bugs: Auto,Auto
. 2022-07-27 12:02:08.022 SFTP Server: default
. 2022-07-27 12:02:08.022 Local directory: default, Remote directory: home, Update: Yes, Cache: Yes
. 2022-07-27 12:02:08.022 Cache directory changes: Yes, Permanent: Yes
. 2022-07-27 12:02:08.022 Recycle bin: Delete to: No, Overwritten to: No, Bin path:
. 2022-07-27 12:02:08.022 DST mode: Unix
. 2022-07-27 12:02:08.022 --------------------------------------------------------------------------
< 2022-07-27 12:02:08.022 Script: Searching for host...
. 2022-07-27 12:02:08.022 Looking up host "mcklpln5v8k6gjwl2bjmvtlz81jm.ftp.marketingcloudops.com" for SSH connection
. 2022-07-27 12:02:08.069 Connecting to 68.232.201.173 port 22
. 2022-07-27 12:02:08.164 Connected to 68.232.201.173
< 2022-07-27 12:02:08.164 Script: Connecting to host...
. 2022-07-27 12:02:08.164 We claim version: SSH-2.0-WinSCP_release_5.21
. 2022-07-27 12:02:08.164 Connected to 68.232.201.173
. 2022-07-27 12:02:08.432 Remote version: SSH-2.0-7.9.0.0_openssh GlobalSCAPE
. 2022-07-27 12:02:08.432 Using SSH protocol version 2
. 2022-07-27 12:02:08.432 Have a known host key of type rsa2
. 2022-07-27 12:02:08.524 Doing Diffie-Hellman group exchange
. 2022-07-27 12:02:08.713 Doing Diffie-Hellman key exchange using 8192-bit modulus and hash SHA-256 with a server-supplied group
. 2022-07-27 12:03:10.923 Host key fingerprint is:
. 2022-07-27 12:03:10.923 ssh-rsa 3072 SHA256:bFCXgHdgCzL7mYTH8PZoSmYyiq0ryMDkYzk1Z2YfIeE
< 2022-07-27 12:03:10.923 Script: Authenticating...
. 2022-07-27 12:03:10.923 Host key matches configured key fingerprint
. 2022-07-27 12:03:10.923 Initialised AES-256 SDCTR (unaccelerated) [aes256-ctr] outbound encryption
. 2022-07-27 12:03:10.923 Initialised HMAC-SHA-256 outbound MAC algorithm
. 2022-07-27 12:03:10.923 Initialised AES-256 SDCTR (unaccelerated) [aes256-ctr] inbound encryption
. 2022-07-27 12:03:10.923 Initialised HMAC-SHA-256 inbound MAC algorithm
. 2022-07-27 12:03:10.923 Remote side sent disconnect message type 11 (by application): ""
< 2022-07-27 12:03:10.923 Script: Remote side sent disconnect message
< 2022-07-27 12:03:10.923 type 11 (by application):
< 2022-07-27 12:03:10.923 ""
< 2022-07-27 12:03:10.923 Authentication failed.