import paramiko

HOST = "135.125.102.180"
USER = "ubuntu"
PASS = "BotPascal2026!"
REMOTE_BASE = "/var/www/html/repondeur_mail_grok"

def main():
    try:
        ssh = paramiko.SSHClient()
        ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
        ssh.connect(HOST, username=USER, password=PASS)
        
        print("🔍 Vérification des problèmes...")
        
        # Check if credentials.php exists
        stdin, stdout, stderr = ssh.exec_command(f"ls -la {REMOTE_BASE}/config/credentials.php")
        result = stdout.read().decode()
        error = stderr.read().decode()
        
        print("\n📄 credentials.php:")
        if error and "No such file" in error:
            print("❌ MANQUANT - Le fichier credentials.php n'existe pas sur le VPS!")
        else:
            print(result)
        
        # Check permissions on data directory
        print("\n📂 Permissions data/:")
        stdin, stdout, stderr = ssh.exec_command(f"ls -la {REMOTE_BASE}/data/")
        print(stdout.read().decode())
        
        # Check send_queue.csv specifically
        print("\n📝 send_queue.csv:")
        stdin, stdout, stderr = ssh.exec_command(f"ls -la {REMOTE_BASE}/data/send_queue.csv")
        print(stdout.read().decode())
        
        # Fix permissions
        print("\n🔧 Application des permissions...")
        stdin, stdout, stderr = ssh.exec_command(f"sudo chmod -R 777 {REMOTE_BASE}/data")
        stdout.read()  # Wait for completion
        
        stdin, stdout, stderr = ssh.exec_command(f"sudo chown -R www-data:www-data {REMOTE_BASE}/data")
        stdout.read()  # Wait for completion
        
        print("✅ Permissions mises à jour")
        
        ssh.close()
        
    except Exception as e:
        print(f"❌ Error: {e}")

if __name__ == "__main__":
    main()