[SOLVED] Using SFTP to transfer from linux to Windows

trickydba · 01-09-2017, 12:30 PM

How can I, in one line transfer a file from linux to Windows using SFTP?

suicidaleggroll · 01-09-2017, 12:34 PM

Well first you need an SFTP server on your Windows box with the necessary firewall exceptions added. After that, you need an sftp uploading tool on your Linux box since the built-in sftp won't let you do it all in one line (I don't think). There are many options, my preference is "lftp".

MensaWater · 01-09-2017, 12:36 PM

To initiate the sftp from the Linux side to the Windows side you'd have to setup an sshd to listen for sftp connections on the Windows side first. You can do this with Cygwin. Cygwin can be found at:
https://www.cygwin.com/
There are many articles on how to configure sshd for sftp in Cygwin - just do a web search.

To initiate the sftp from the Windows side to the Linux side there are various tools you can use including WinSCP. WinSCP can be found at:
https://winscp.net/eng/download.php
WinSCP uses an explorer style menu to drag files from one system to the other. There is also a WinSCP console you can run that gives you a command line interface to run sftp commands manually.

Turbocapitalist · 01-09-2017, 12:39 PM

I'd make the opposite assumption from the previous two posts. Since you wish to transfer a file from linux to Windows using SFTP, I'd say put the OpenSSH server on the Linux box. It will be many thousands of times easier. Then you'll still have to figure out a client for the Windows side of things, but at least the server will be done the easy way.

Either way, SFTP can 'put' as well as 'get'

michaelk · 01-09-2017, 12:50 PM

From the OP's previous threads there is a ssh server running on Windows and can use scp and smbclient to transfer files. What are you trying to accomplish with sftp?

trickydba · 01-09-2017, 12:52 PM

Well I was told that on the Winodws side they have Globescape EFT. I'm tricky to do this through the command line,. Here's my code:

sftp username@hostname
cd dir/dir
lchdir/export/home/fileishere/file.txt
put file.xlsx

I need to get this to work in one line. Is this possible?

Turbocapitalist · 01-09-2017, 12:56 PM

Quote:

Originally Posted by trickydba

I need to get this to work in one line. Is this possible?

If you use keys for authentication, you can use batch mode -b for that. Batch mode can take SFTP commands via stdin or via a file to be read.

schneidz · 01-09-2017, 12:58 PM

sftp was designed to prompt humans for detailes such as user name, password, local directory, remote directory, file name, ...

scp was designed for automated machines to transfer data among each other (as long as public key encryption is enabled).

regardless of client or server operating system, as long as the ssh client and server are configured correctly, the general syntax would be:

Code:

scp user1@host1:/whatever/floats/your/boat user2@host2:whatever/grinds/your/gears

trickydba · 01-09-2017, 01:10 PM

@Turbocapitaist..... Can you please give me an example

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

Here is an example using a file.

Code:

$ cat <<EOF > cmds.sftp
> cd /home/tc/Uploads/
> lcd /home/tc/
> put file.ods
> EOF
cd /home/tc/Uploads/
lcd /home/tc/
put file.ods

$ ssh-add ~/.ssh/some_key_rsa

$ sftp -b cmds.sftp -i ~/.ssh/some_key_rsa tc@server.example.com

If you use - instead of a file name it will read from stdin and then you can use echo via pipe.

Code:

$ ssh-add ~/.ssh/some_key_rsa

$ echo -e "cd /home/tc/Uploads/\nlcd /home/tc/\nput file.ods\n" \
        | sftp -b - -i ~/.ssh/some_key_rsa tc@server.example.com

Either way, you have to have the key set up so that it is in the agent if it has a passphrase (recommended) or without a passphrase (not recommended). Because batch mode only works when there is no interactive session.

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

Quote:

Originally Posted by schneidz

sftp was designed to prompt humans for detailes such as user name, password, local directory, remote directory, file name, ...

scp was designed for automated machines to transfer data among each other (as long as public key encryption is enabled).

Actually you can do sftp as well as scp with ssh trusts in place. Most of my automated scripts do sftp rather than scp.

trickydba · 01-09-2017, 01:29 PM

@Turbocapitalist............I was kinda hoping to get a one-liner that would handle moving a file from linux to windows. The destination server does not need a password

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

Quote:

Originally Posted by Turbocapitalist

Either way, you have to have the key set up so that it is in the agent if it has a passphrase (recommended) or without a passphrase (not recommended). Because batch mode only works when there is no interactive session.

ssh keys are definitely the most secure way to go and should always be what you try to get in place for automated processes.

However, there is a utility that allows you to send the password, called sshpass. Obviously this has a security risk as it requires you to store your password in clear text somewhere to be passed. But it does work well if you absolutely can't use keys for some reason and has simple syntax:
shpass -p <password> sftp <target server name or IP>
If you're using RHEL or CentOS you can find the package in Fedora's EPEL.

trickydba · 01-09-2017, 01:35 PM

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

And no password is needed, keys already installed

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

Both examples are from any non-Windows OS with the usual OpenSSH SFTP client to whatever SFTP server you have, as long as it follows the standards.

The stdin example is one line. The backslash is not necessary and is added for readability. The file-based example is also one line, but does need the file filled with SFTP commands. Both work as long as you can use keys for authentication. If you are using expect instead of keys then you are probably SOL.