Databases
StackOverflow2013
Postsdbo
POPython - Transfer a file between two remote servers, excecuting a python script
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPython - Transfer a file between two remote servers, excecuting a python script
    primarykey
    data
    text
    <p>I am trying to copy a file between two servers from a <code>localServer</code>, say from <code>server-A</code> to <code>server-B</code>. I am using paramiko package in python.</p> <p>So there are three servers namely, <code>localServer</code>, <code>server-A</code> and <code>server-B</code>. Please see the below code, this is self explanatory and please let me know where I am going wrong.</p> <p>Algorithm I am using:</p> <ol> <li>I am trying to run <code>paramiko_test.py</code> file from <code>localServer</code>.</li> <li><code>paramiko_test.py</code> executes <code>copy.py</code> file in <code>server-A</code>.</li> <li><code>copy.py</code> copies file <code>source.txt</code> file in <code>server-A</code> to <code>server-B</code> using SFTP.</li> </ol> <p>When I run <code>copy.py</code> from <code>server-A</code>, it is working correct. But when I run <code>paramiko_test.py</code> from <code>localServer</code> (which indirectly executes <code>copy.py</code> in <code>server-A</code>), it is not working!</p> <p>From logs, I got to know that there is a successful connection from <code>server-A</code> to <code>server-B</code>, but after that the SFTP part is not working!</p> <p><strong>Question:</strong> Can we invoke a SFTP client within a SFTP client? Is there any better way to copy files between two servers?</p> <p>Please help me where I am going wrong.</p> <p><strong>server-A, file:copy.py:</strong></p> <pre><code>import paramiko ssh = paramiko.SSHClient() ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy()) ssh.connect('&lt;server-B-IP&gt;', username='serverB', password='passwd') print "connected successfully!" sftp = ssh.open_sftp() print sftp sftp.put('source.txt','/home/serverB/destination.txt' ) sftp.close() print "copied successfully!" ssh1.close() exit() </code></pre> <p><strong>localServer, paramiko_test.py:</strong></p> <pre><code>import paramiko ssh = paramiko.SSHClient() ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy()) ssh.connect('&lt;server-A-IP&gt;', username='serverA', password='passwd') print "connected successfully!" stdin, stdout, stderr = ssh.exec_command("python /home/username/copy.py") print stdout.readlines() print "copied successfully!" ssh.close() exit() </code></pre> <p>The output of <code>stderr.readlines()</code> is:</p> <pre><code>Traceback (most recent call last): File "/home/sitaram/sumanth/test_progs/copy.py", line 12, in &lt;module&gt; sftp1.put('./sumanth_temp.txt','/home/ncloudadmin/sumanth.txt' ) File "/usr/lib/pymodules/python2.6/paramiko/sftp_client.py", line 558, in put file_size = os.stat(localpath).st_size OSError: [Errno 2] No such file or directory: './sumanth_temp.txt' </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAlex L
    1. USSumanth Lingappa
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. POPython - Transfer a file between two remote servers, excecuting a python script
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POPython - Transfer a file between two remote servers, excecuting a python script
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    3. VO
      singulars
      1. POPython - Transfer a file between two remote servers, excecuting a python script
      1. USAlex Jordan
      1. VTFavorite
    1. COHave you looked at Fabric? It's a bit easier than Paramiko to [work with files](http://docs.fabfile.org/en/1.5/api/contrib/files.html) and can do things like [put a file on a remote server](http://docs.fabfile.org/en/1.5/api/core/operations.html#fabric.operations.put)
      singulars
      1. POPython - Transfer a file between two remote servers, excecuting a python script
      1. USAlex L
    2. COHi Alex, Thanks for your reply. I looked at Fabric, I didnt see anywhere Fabric supporting file transfer between two remote hosts, running script in another local Server. Or is it supported by Fabric?? Please help.
      singulars
      1. POPython - Transfer a file between two remote servers, excecuting a python script
      1. USSumanth Lingappa
    3. COCan you SSH into one of the remote servers, and then SFTP/SCP across? Are you getting anything in your `sterr`?
      singulars
      1. POPython - Transfer a file between two remote servers, excecuting a python script
      1. USAlex L
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload