test_auth_errors.py

import frappe
def run():
    frappe.init(site="erp.bespo.et", sites_path="/home/frappe/frappe-bench/sites")
    frappe.connect()
    
    logs = frappe.db.sql("""
        SELECT name, method, LEFT(error, 1000) 
        FROM `tabError Log` 
        WHERE error LIKE '%login%' OR error LIKE '%auth%' OR method LIKE '%login%' OR method LIKE '%auth%' OR error LIKE '%trigger%'
        ORDER BY creation DESC 
        LIMIT 10
    """, as_dict=True)
    
    if not logs:
        print("No auth/login/trigger error logs found recently.")
    else:
        for log in logs:
            print(f"--- {log.name} ---")
            print(f"Method: {log.method}")
            print(f"Error:\n{log.get('LEFT(error, 1000)')}\n")

if __name__ == "__main__":
    run()