{
    "step1_database_connection": {
        "status": "SUCCESS",
        "server_info": "8.0.46-0ubuntu0.24.04.3",
        "mysql_version": 80046,
        "charset": "utf8mb4"
    },
    "step2_database_tables": {
        "all_tables": [
            "cdr",
            "login_attempts",
            "users"
        ],
        "users_table": {
            "exists": true,
            "columns": [
                {
                    "Field": "id",
                    "Type": "int",
                    "Null": "NO",
                    "Key": "PRI",
                    "Default": null,
                    "Extra": "auto_increment"
                },
                {
                    "Field": "username",
                    "Type": "varchar(50)",
                    "Null": "NO",
                    "Key": "UNI",
                    "Default": null,
                    "Extra": ""
                },
                {
                    "Field": "email",
                    "Type": "varchar(100)",
                    "Null": "NO",
                    "Key": "UNI",
                    "Default": null,
                    "Extra": ""
                },
                {
                    "Field": "password_hash",
                    "Type": "varchar(255)",
                    "Null": "NO",
                    "Key": "",
                    "Default": null,
                    "Extra": ""
                },
                {
                    "Field": "full_name",
                    "Type": "varchar(100)",
                    "Null": "NO",
                    "Key": "",
                    "Default": "User",
                    "Extra": ""
                },
                {
                    "Field": "extension",
                    "Type": "varchar(11)",
                    "Null": "NO",
                    "Key": "",
                    "Default": null,
                    "Extra": ""
                },
                {
                    "Field": "password",
                    "Type": "varchar(20)",
                    "Null": "NO",
                    "Key": "",
                    "Default": null,
                    "Extra": ""
                },
                {
                    "Field": "gatewayIP",
                    "Type": "varchar(100)",
                    "Null": "NO",
                    "Key": "",
                    "Default": null,
                    "Extra": ""
                },
                {
                    "Field": "status",
                    "Type": "enum('active','inactive','suspended')",
                    "Null": "NO",
                    "Key": "",
                    "Default": "active",
                    "Extra": ""
                },
                {
                    "Field": "created_at",
                    "Type": "timestamp",
                    "Null": "YES",
                    "Key": "",
                    "Default": "CURRENT_TIMESTAMP",
                    "Extra": "DEFAULT_GENERATED"
                },
                {
                    "Field": "last_login",
                    "Type": "timestamp",
                    "Null": "YES",
                    "Key": "",
                    "Default": null,
                    "Extra": ""
                },
                {
                    "Field": "is_active",
                    "Type": "tinyint(1)",
                    "Null": "YES",
                    "Key": "",
                    "Default": "1",
                    "Extra": ""
                },
                {
                    "Field": "failed_attempts",
                    "Type": "int",
                    "Null": "YES",
                    "Key": "",
                    "Default": "0",
                    "Extra": ""
                },
                {
                    "Field": "locked_until",
                    "Type": "timestamp",
                    "Null": "YES",
                    "Key": "",
                    "Default": null,
                    "Extra": ""
                }
            ],
            "sample_data": [
                {
                    "username": "azad",
                    "email": "azadbluesky@gmail.com",
                    "status": "active",
                    "created_at": "2025-09-28 12:40:03",
                    "password_hash": "1234",
                    "full_name": "Md. Abul Bashar Azad"
                }
            ],
            "available_columns": [
                "id",
                "username",
                "email",
                "password_hash",
                "full_name",
                "extension",
                "password",
                "gatewayIP",
                "status",
                "created_at",
                "last_login",
                "is_active",
                "failed_attempts",
                "locked_until"
            ],
            "total_count": "1"
        }
    },
    "step3_password_hashing": {
        "test_password": "12345678",
        "generated_hash": "$2y$10$DGgnCY3sTK8ZS9kFFSv3L.4JUlsiWEEu5DLvCjfnqXwLEACTPoNdW",
        "hash_verify": true,
        "php_version": "8.3.17",
        "available_algorithms": [
            "2y",
            "argon2i",
            "argon2id"
        ]
    },
    "step4_jwt_test": {
        "status": "SUCCESS",
        "test_token": "eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkI...",
        "token_length": 124
    },
    "step5_api_files": {
        "api-login.php": {
            "exists": true,
            "readable": true,
            "size": 17451,
            "modified": "2025-09-23 04:49:28"
        },
        "api-verify-token.php": {
            "exists": true,
            "readable": true,
            "size": 2968,
            "modified": "2025-09-22 17:58:23"
        }
    },
    "step6_server_environment": {
        "php_version": "8.3.17",
        "server_software": "Apache\/2.4.58 (Ubuntu)",
        "request_method": "GET",
        "document_root": "\/var\/www\/appdev.adnsmsgw.com",
        "script_filename": "\/var\/www\/appdev.adnsmsgw.com\/api\/debug-login.php",
        "mysql_extension": "available",
        "json_extension": "available",
        "openssl_extension": "available"
    },
    "summary": {
        "database_connection": "SUCCESS",
        "users_table_exists": true,
        "user_count": "1",
        "password_hashing_working": true,
        "jwt_working": true
    }
}