Read a file from server with SSH using Python

Posted on

Question :

Read a file from server with SSH using Python

I am trying to read a file from a server using SSH from Python. I am using Paramiko to connect. I can connect to the server and run a command like cat filename and get the data back from the server but some files I am trying to read are around 1 GB or more in size.

How can I read the file on the server line by line using Python?

Additional Info: What is regularly do is run a cat filename command and store the result in a variable and work off that. But since the file here is quite big, I am looking for a way to read a file line by line off the server.

EDIT: I can read a bunch of data and split it into lines but the problem is that the data received in the buffer does not always include the complete lines. For eg, if buffer has 300 lines, the last line may only be half of the line on the server and the next half would be fetched in the next call to the server. I want complete lines

EDIT 2: what command can I use to print lines in a file in a certain range. Like print first 100 lines, then the next 100 and so on? This way the buffer will always contain complete lines.

Answer #1:

Paramiko’s SFTPClient class allows you to get a file-like object to read data from a remote file in a Pythonic way.

Assuming you have an open SSHClient:

sftp_client = ssh_client.open_sftp()
remote_file ='remote_filename')
    for line in remote_file:
        # process line
Answered By: Matt Good

Answer #2:

Here’s an extension to @Matt Good’s answer, using fabric:

from fabric.connection import Connection

with Connection(host, user) as c, c.sftp() as sftp,   'remote_filename') as file:
    for line in file:

old Fabric 1 answer:

from contextlib     import closing
from import connect

with closing(connect(user, host, port)) as ssh, 
     closing(ssh.open_sftp()) as sftp, 
     closing('remote_filename')) as file:
    for line in file:
Answered By: jfs

Answer #3:

#!/usr/bin/env python
import paramiko
import select
client = paramiko.SSHClient()
transport = client.get_transport()
channel = transport.open_session()
channel.exec_command("cat /path/to/your/file")
while True:
  rl, wl, xl =[channel],[],[],0.0)
  if len(rl) > 0:
      # Must be stdout
      print channel.recv(1024)
Answered By: g33kz0r

Answer #4:

What do you mean by “line by line” – there are lots of data buffers between network hosts, and none of them are line-oriented.

So you can read a bunch of data, then split it into lines at the near end.

ssh otherhost cat somefile | python | do_process_locally

Or you can have a process read a bunch of data at the far end, break it up, and format it line by line and send it to you.

scp otherhost
ssh otherhost python somefile |  do_process_locally

The only difference I would care about is what way reduces the volume of data over a limited network pipe. In your situation it may, or may not matter.

There is nothing wrong in general with using cat over an SSH pipe to move gigabytes of data.

Answered By: Joe Koberg

Answer #5:

It looks like back in Sept 2013 paramiko added the ability for these objects to support context managers natively, so if you want both Matt’s clean answer with jfs’s context manager, now all you need is:

with ssh_client.open_sftp() as sftp_client:
    with'remote_filename') as remote_file:
        for line in remote_file:
            # process line
Answered By: sql_knievel

Leave a Reply

Your email address will not be published.