[SOLVED] Using SFTP to transfer from linux to Windows

Turbocapitalist · 01-09-2017, 01:41 PM

Quote:

Originally Posted by trickydba

@Turbocapitalist.....Im sorry, your code seems a little confusing

And no password is needed, keys already installed

The first example is just copy/paste from the terminal. There is a Here Document showing the lines you added. You can use gedit, nano, vi, or any editor instead to create the file with the SFTP commands.

MensaWater · 01-09-2017, 01:43 PM

If you have keys that work for sshd they should work for both scp and sftp.

If so your one liner would be similar to what schneidz posted.
scp -p <pathtof/><localfile on linux> <windowsserver>:<pathto/><remotefile

You can leave off remotefile if you want it to be the same name as the localfile.

Doug G · 01-09-2017, 02:09 PM

A windows command-line pscp is included with putty. I've used in batch scripts it to automate scp from linux to windows.

trickydba · 01-09-2017, 02:20 PM

@Turbocapitalist..........I'm sorry, still a little confused. maybe I should show exactly what I need to be done in the script:

1. sftp username@hostname ----- no password needed, keys are used
2. cd MOVEFILEHERE ----- this is where the file will be written to
3. lchdir /dir1/dir2/dir3/ ----- this is the local directory where the file exists
4. put file.xlsx ----- to actually move the file

trickydba · 01-09-2017, 02:24 PM

@Mensawater.......I tried that and it didn't work. It gave the error:

exec request failed on channel 0
lost connection

Turbocapitalist · 01-09-2017, 02:24 PM

That's what I showed in #10 above. Please try some experiments with -b

Code:

echo -e "cd MOVEFILEHERE\nlchdir /dir1/dir2/dir3/\nput file.xlsx\n" | sftp -b - username@hostname

Or you can make a file with those three SFTP commands (2, 3, and 4) and use the file name instead of a dash.

trickydba · 01-09-2017, 02:37 PM

@Mensawater... Windows server only configured for sftp connections

trickydba · 01-09-2017, 02:42 PM

@Turbocapitalist.............PERFECT!!!! That works!!! Here's the suggested code:

echo -e "cd MOVEFILEHERE\nlchdir /dir1/dir2/dir3/\nput file.xlsx\n" | sftp -b - username@hostname

Thank you

Turbocapitalist · 01-10-2017, 12:49 AM

Hmm. You're welcome. For my edification, what was confusing about how it was written in #10?

trickydba · 01-10-2017, 09:05 AM

@Turbocapitalist.......Well I'm sort of a newbie. Which is why I always be in here! Also I thought when concerning the keys it's all done in the background and doesn't need to be mentioned in a script. I can confirm I can do this MANUALLY using sftp so the keys are configured right. I just want to move the file from linux to windows.

Turbocapitalist · 01-10-2017, 12:22 PM

Ok. Yeah if you have an agent (ssh-agent) running then it goes more or less automatically. Most if not all desktop environments start one for you these days. But when you start to have more than about six accounts to worry about, you start to have to point the SFTP client at a specific key. So I included that with the -i option.