使用Python上传文件至SFTP服务器遇IOError问题求助

Hey there, let's figure out why you're running into that IOError while trying to upload your file via SFTP. Based on your code and common SFTP upload pitfalls, here are the most likely culprits and fixes:

Common Causes & Fixes #

1. Target Path is a Directory (Not a Full File Path) #

Your current destination is set to /home/local—this is a directory, not a complete file path. The paramiko SFTP put() method needs to know exactly what filename to use on the server. If you only specify a directory, the server won't know how to name the uploaded file, which often triggers an IOError.

Fix: Update the destination to include the filename, like:

destination = '/home/local/test.csv'

2. Target Directory Doesn't Exist on the Server #

If /home/local doesn't exist on the SFTP server, the upload will fail because the server can't write to a non-existent location.

Fix: Add code to check for the directory and create it if needed (make sure your user has permission to create directories):

target_dir = '/home/local'
try:
    ftp_client.stat(target_dir)  # Check if directory exists
except FileNotFoundError:
    ftp_client.mkdir(target_dir)  # Create it if missing

3. Insufficient Permissions #

Your SFTP user might not have write permissions to the /home/local directory. Without write access, the server will reject the upload request with an IOError.

Fix: Verify the directory permissions on the server (ask your server admin if you don't have access to check) and ensure your user has write privileges.

4. Local File Doesn't Exist or Path is Wrong #

Double-check that c:/test.csv actually exists on your local machine. Typos in the path (like missing a folder, wrong capitalization, or a typo in the filename) will cause the upload to fail before even reaching the server.

Modified Working Code #

Here's an updated version of your code that addresses these issues and includes error handling to make debugging easier:

import paramiko

hostname = 'host'
username='user'
password='password'
port=22  # Replace with your actual port (usually 22 for SFTP)
source = 'c:/test.csv'
destination = '/home/local/test.csv'

try:
    # Initialize SSH client
    client = paramiko.SSHClient()
    client.set_missing_host_key_policy(paramiko.AutoAddPolicy())
    client.connect(hostname=hostname, port=port, username=username, password=password)
    
    # Open SFTP session
    ftp_client = client.open_sftp()
    
    # Ensure target directory exists
    target_dir = '/home/local'
    try:
        ftp_client.stat(target_dir)
    except FileNotFoundError:
        ftp_client.mkdir(target_dir)
        print(f"Created target directory: {target_dir}")
    
    # Upload the file
    ftp_client.put(source, destination)
    print("File uploaded successfully!")
    
    # Clean up connections
    ftp_client.close()
    client.close()
except Exception as e:
    print(f"Upload failed with error: {str(e)}")

Final Notes #

• Always use full file paths for both source and destination to avoid ambiguity.
• Adding try/except blocks helps catch specific errors (like missing directories or permission issues) instead of a generic IOError.
• If you're still having issues, print the exact error message from the exception—it will give you more precise details about what's going wrong.

内容的提问来源于stack exchange，提问作者sam