Post a reply

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

I have sent you an email.
martin

geninfarun wrote:

What is is this line mean??

. 2011-11-08 08:34:34.923 We believe remote version has SSH-2 ignore bug.

That's actually a bug. Thanks for spotting this!
Added to tracker:
https://winscp.net/tracker/767

I do not think this is related though. Anyway, I'll send you build with fix, just in case.
geninfarun

What is is this line mean??

Looking up host "123.abc.com"
. 2011-11-08 08:34:34.794 Connecting to xxx.xxx.xxx.xxx port 22
. 2011-11-08 08:34:34.923 Server version: SSH-2.0-SSHD
. 2011-11-08 08:34:34.923 We believe remote version has SSH-2 ignore bug.
2011-11-08 08:34:34.923 Using SSH protocol version 2
. 2011-11-08 08:34:34.923 We claim version: SSH-2.0-WinSCP_release_4.3.5
. 2011-11-08 08:34:35.511 Using Diffie-Hellman with standard group "group14"
. 2011-11-08 08:34:35.511 Doing Diffie-Hellman key exchange with hash SHA-1
. 2011-11-08 08:34:35.714 Network error: Software caused connection abort
geninfarun

Problem is we dont control the server. Heres something more interesting. I created another schedule for the same job for 30 minutes later, and for the last 2 days, the first time the job always fails with connection closed and the second time, the job always works.
martin

Please check the server log file to see if you find a reason why the connection was closed.
geninfarun

I guess I spoke too soon. The job failed again, this time I was logged in but the server was locked, and it still failed. This is the message when it was scheduled;

2011-10-26 07:00:28.528 WinSCP Version 4.3.5 (Build 1463) (OS 6.0.6001 Service Pack 1)
. 2011-10-26 07:00:28.530 Configuration: C:\Program Files (x86)\WinSCP\WinSCP.ini
. 2011-10-26 07:00:28.530 Local account: xxxxxx.GOV\xxxxx
. 2011-10-26 07:00:28.530 Login time: Wednesday, October 26, 2011 7:00:28 AM
. 2011-10-26 07:00:28.530 --------------------------------------------------------------------------
. 2011-10-26 07:00:28.607 Session name: ftsqa (Stored session)
. 2011-10-26 07:00:28.607 Host name: xxx.xxx.com(Port: 22)
. 2011-10-26 07:00:28.607 User name: xxxxx (Password: Yes, Key file: No)
. 2011-10-26 07:00:28.607 Tunnel: No
. 2011-10-26 07:00:28.607 Transfer Protocol: SFTP (SCP)
. 2011-10-26 07:00:28.607 Ping type: -, Ping interval: 30 sec; Timeout: 600 sec
. 2011-10-26 07:00:28.607 Proxy: none
. 2011-10-26 07:00:28.607 SSH protocol version: 2; Compression: No
. 2011-10-26 07:00:28.607 Bypass authentication: No
. 2011-10-26 07:00:28.607 Try agent: Yes; Agent forwarding: No; TIS/CryptoCard: No; KI: Yes; GSSAPI: No
. 2011-10-26 07:00:28.607 Ciphers: aes,blowfish,3des,WARN,arcfour,des; Ssh2DES: No
. 2011-10-26 07:00:28.607 SSH Bugs: -,-,-,-,-,-,-,-,-
. 2011-10-26 07:00:28.607 SFTP Bugs: -,-
. 2011-10-26 07:00:28.607 Return code variable: Autodetect; Lookup user groups: Yes
. 2011-10-26 07:00:28.607 Shell: default
. 2011-10-26 07:00:28.607 EOL: 0, UTF: 2
. 2011-10-26 07:00:28.607 Clear aliases: Yes, Unset nat.vars: Yes, Resolve symlinks: Yes
. 2011-10-26 07:00:28.607 LS: ls -la, Ign LS warn: Yes, Scp1 Comp: No
. 2011-10-26 07:00:28.607 Local directory: default, Remote directory: home, Update: No, Cache: Yes
. 2011-10-26 07:00:28.607 Cache directory changes: Yes, Permanent: Yes
. 2011-10-26 07:00:28.608 DST mode: 1
. 2011-10-26 07:00:28.608 --------------------------------------------------------------------------
. 2011-10-26 07:00:29.037 Looking up host "xxx.xxx.com"
. 2011-10-26 07:00:29.194 Connecting to xxx.xxx.xxx.xxx 1 port 22
. 2011-10-26 07:00:29.327 Server version: SSH-2.0-SSHD
. 2011-10-26 07:00:29.327 We believe remote version has SSH-2 ignore bug
. 2011-10-26 07:00:29.327 Using SSH protocol version 2
. 2011-10-26 07:00:29.327 We claim version: SSH-2.0-WinSCP_release_4.3.5
. 2011-10-26 07:00:29.892 Using Diffie-Hellman with standard group "group14"
. 2011-10-26 07:00:29.892 Doing Diffie-Hellman key exchange with hash SHA-1
. 2011-10-26 07:00:30.038 Network error: Software caused connection abort



And this is the message when I ran the job manually and it was successful;

. 2011-10-26 07:25:54.870 --------------------------------------------------------------------------
. 2011-10-26 07:25:54.870 WinSCP Version 4.3.5 (Build 1463) (OS 6.0.6001 Service Pack 1)
. 2011-10-26 07:25:54.872 Configuration: C:\Program Files (x86)\WinSCP\WinSCP.ini
. 2011-10-26 07:25:54.873 Local account: xxxxx.GOV\xxxx
. 2011-10-26 07:25:54.873 Login time: Wednesday, October 26, 2011 7:25:54 AM
. 2011-10-26 07:25:54.873 --------------------------------------------------------------------------
. 2011-10-26 07:25:54.873 Session name: ftsqa (Stored session)
. 2011-10-26 07:25:54.873 Host name: fts.xxxxx.com (Port: 22)
. 2011-10-26 07:25:54.873 User name: stxxx960 (Password: Yes, Key file: No)
. 2011-10-26 07:25:54.873 Tunnel: No
. 2011-10-26 07:25:54.873 Transfer Protocol: SFTP (SCP)
. 2011-10-26 07:25:54.873 Ping type: -, Ping interval: 30 sec; Timeout: 600 sec
. 2011-10-26 07:25:54.873 Proxy: none
. 2011-10-26 07:25:54.873 SSH protocol version: 2; Compression: No
. 2011-10-26 07:25:54.873 Bypass authentication: No
. 2011-10-26 07:25:54.873 Try agent: Yes; Agent forwarding: No; TIS/CryptoCard: No; KI: Yes; GSSAPI: No
. 2011-10-26 07:25:54.873 Ciphers: aes,blowfish,3des,WARN,arcfour,des; Ssh2DES: No
. 2011-10-26 07:25:54.873 SSH Bugs: -,-,-,-,-,-,-,-,-
. 2011-10-26 07:25:54.873 SFTP Bugs: -,-
. 2011-10-26 07:25:54.874 Return code variable: Autodetect; Lookup user groups: Yes
. 2011-10-26 07:25:54.874 Shell: default
. 2011-10-26 07:25:54.874 EOL: 0, UTF: 2
. 2011-10-26 07:25:54.874 Clear aliases: Yes, Unset nat.vars: Yes, Resolve symlinks: Yes
. 2011-10-26 07:25:54.874 LS: ls -la, Ign LS warn: Yes, Scp1 Comp: No
. 2011-10-26 07:25:54.874 Local directory: default, Remote directory: home, Update: No, Cache: Yes
. 2011-10-26 07:25:54.874 Cache directory changes: Yes, Permanent: Yes
. 2011-10-26 07:25:54.874 DST mode: 1
. 2011-10-26 07:25:54.874 --------------------------------------------------------------------------
. 2011-10-26 07:25:54.874 Looking up host "fts.xxxxxx.com"
. 2011-10-26 07:25:54.989 Connecting to xxx.xxx.xxx.xxx 2 port 22
. 2011-10-26 07:25:55.123 Server version: SSH-2.0-SSHD
. 2011-10-26 07:25:55.123 We believe remote version has SSH-2 ignore bug
. 2011-10-26 07:25:55.123 Using SSH protocol version 2
. 2011-10-26 07:25:55.123 We claim version: SSH-2.0-WinSCP_release_4.3.5
. 2011-10-26 07:25:55.188 Using Diffie-Hellman with standard group "group14"
. 2011-10-26 07:25:55.188 Doing Diffie-Hellman key exchange with hash SHA-1
. 2011-10-26 07:25:56.133 Host key fingerprint is:
. 2011-10-26 07:25:56.133 ssh-rsa 2048 ed:f3:71:f5:94:3e:d7:eb:cc:39:9d:98:9c:40:08:11
. 2011-10-26 07:25:56.151 Initialised AES-256 CBC client->server encryption
. 2011-10-26 07:25:56.151 Initialised HMAC-SHA1 client->server MAC algorithm
. 2011-10-26 07:25:56.199 Initialised AES-256 CBC server->client encryption
. 2011-10-26 07:25:56.199 Initialised HMAC-SHA1 server->client MAC algorithm
! 2011-10-26 07:25:56.264 Using username "st10960".
. 2011-10-26 07:25:56.330 Prompt (7, SSH password, , &Password: )
. 2011-10-26 07:25:56.331 Using stored password.
. 2011-10-26 07:25:56.332 Sent password
. 2011-10-26 07:25:56.503 Access granted
. 2011-10-26 07:25:56.567 Opened channel for session
. 2011-10-26 07:25:57.150 Started a shell/command
. 2011-10-26 07:25:57.150 --------------------------------------------------------------------------
. 2011-10-26 07:25:57.404 Using SFTP protocol.
. 2011-10-26 07:25:57.406 Doing startup conversation with host.
> 2011-10-26 07:25:57.461 Type: SSH_FXP_INIT, Size: 5, Number: -1
< 2011-10-26 07:25:57.527 Type: SSH_FXP_VERSION, Size: 5, Number: -1
. 2011-10-26 07:25:57.527 SFTP version 3 negotiated.
. 2011-10-26 07:25:57.527 We believe the server has signed timestamps bug
. 2011-10-26 07:25:57.527 We will use UTF-8 strings for status messages only
. 2011-10-26 07:25:57.527 Getting current directory name.
. 2011-10-26 07:25:57.527 Getting real path for '.'
> 2011-10-26 07:25:57.564 Type: SSH_FXP_REALPATH, Size: 10, Number: 16
< 2011-10-26 07:25:57.667 Type: SSH_FXP_NAME, Size: 51, Number: 16
. 2011-10-26 07:25:57.667 Real path is '/'
. 2011-10-26 07:25:57.667 Startup conversation with host finished.
< 2011-10-26 07:25:57.667 Script: Active session: [1] ftsqa
> 2011-10-26 07:25:57.667 Script: option confirm off
< 2011-10-26 07:25:57.667 Script: confirm off
> 2011-10-26 07:25:57.667 Script: get /outbound/*.csv c:\testpayment.csv
. 2011-10-26 07:25:57.668 Listing directory "/outbound".
> 2011-10-26 07:25:57.668 Type: SSH_FXP_OPENDIR, Size: 18, Number: 267
< 2011-10-26 07:25:57.752 Type: SSH_FXP_HANDLE, Size: 10, Number: 267
> 2011-10-26 07:25:57.752 Type: SSH_FXP_READDIR, Size: 10, Number: 524
< 2011-10-26 07:25:57.819 Type: SSH_FXP_NAME, Size: 513, Number: 524
> 2011-10-26 07:25:57.819 Type: SSH_FXP_READDIR, Size: 10, Number: 780
< 2011-10-26 07:25:57.885 Type: SSH_FXP_STATUS, Size: 17, Number: 780
< 2011-10-26 07:25:57.885 Status code: 1
> 2011-10-26 07:25:57.885 Type: SSH_FXP_CLOSE, Size: 10, Number: 1028
. 2011-10-26 07:25:57.907 File: "/outbound/EBR_PSO_2011_10_25.csv"
. 2011-10-26 07:25:57.907 Copying "/outbound/EBR_PSO_2011_10_25.csv" to local directory started.
. 2011-10-26 07:25:57.907 Binary transfer mode selected.
. 2011-10-26 07:25:57.932 Opening remote file.
> 2011-10-26 07:25:57.936 Type: SSH_FXP_OPEN, Size: 49, Number: 1283
< 2011-10-26 07:25:57.950 Type: SSH_FXP_STATUS, Size: 40, Number: 1028
. 2011-10-26 07:25:57.950 Discarding reserved response
< 2011-10-26 07:25:58.034 Type: SSH_FXP_HANDLE, Size: 10, Number: 1283
> 2011-10-26 07:25:58.034 Type: SSH_FXP_FSTAT, Size: 10, Number: 1544
> 2011-10-26 07:25:58.034 Type: SSH_FXP_READ, Size: 22, Number: 1797
< 2011-10-26 07:25:58.134 Type: SSH_FXP_ATTRS, Size: 37, Number: 1544
. 2011-10-26 07:25:58.134 Storing reserved response
< 2011-10-26 07:25:58.291 Status code: 1
. 2011-10-26 07:25:58.291 3 skipped SSH_FXP_WRITE, SSH_FXP_READ, SSH_FXP_DATA and SSH_FXP_STATUS packets.
> 2011-10-26 07:25:58.291 Type: SSH_FXP_CLOSE, Size: 10, Number: 2308
. 2011-10-26 07:25:58.291 Closing connection.
. 2011-10-26 07:25:58.291 Sending special code: 12
. 2011-10-26 07:25:58.291 Sent EOF message
geninfarun

Thank you. I figured it was because of user permissions but I didnt know there was such an option to use an ini. Also got the version updated to the latest.
geninfarun

SSIS job works when user is logged in but otherwise fails

I am running an ssis job to download a file from an sftp using a stored session but it only works if I am logged into the server running the ssis job. If I am logged out it fails with this error:

2011-10-24 07:00:24.071 Looking up host "abc.domain.com"
. 2011-10-24 07:00:24.216 Connecting to xxx.xxx.xxx.xxx port 22
. 2011-10-24 07:00:24.348 Server version: SSH-2.0-SSHD
. 2011-10-24 07:00:24.349 Using SSH protocol version 2
. 2011-10-24 07:00:24.349 We claim version: SSH-2.0-WinSCP_release_4.2.7
. 2011-10-24 07:00:24.695 Using Diffie-Hellman with standard group "group14"
. 2011-10-24 07:00:24.695 Doing Diffie-Hellman key exchange with hash SHA-1
. 2011-10-24 07:00:24.774 Server unexpectedly closed network connection

The help file says its probably a firewall issue.