import paramiko
import sys
import os

HOST = "135.125.102.180"
USER = "ubuntu"
PASS = "BotPascal2026!"
LOCAL_SCRIPT = "scripts/verify_no_zimbra.php"
REMOTE_SCRIPT = "/tmp/verify_no_zimbra.php"

def main():
    try:
        ssh = paramiko.SSHClient()
        ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
        ssh.connect(HOST, username=USER, password=PASS, banner_timeout=30)
        
        # Upload
        print(f"Uploading {LOCAL_SCRIPT} -> {REMOTE_SCRIPT}")
        sftp = ssh.open_sftp()
        sftp.put(LOCAL_SCRIPT, REMOTE_SCRIPT)
        sftp.close()
        
        # Run
        print("--- EXECUTING VERIFICATION ---")
        stdin, stdout, stderr = ssh.exec_command(f"php {REMOTE_SCRIPT}")
        print(stdout.read().decode())
        err = stderr.read().decode()
        if err:
            print(f"STDERR: {err}")
            
        ssh.close()
    except Exception as e:
        print(f"Error: {e}")

if __name__ == "__main__":
    main()