File Manager

✏️ Edit File: /home/u625410797/domains/monothailand.com/public_html/smart_panel/api/v1/debug_db.php

<?php
// Smart_PanelDatabase Diagnostic Tool V2
// [SECURITY] API Key required — never expose DB config publicly
require_once '../../config.php';
Security::guard();

header('Content-Type: text/plain'); // Use plain text for clearer output

try {
    echo "--- Smart_PanelDB DIAGNOSTIC V2 ---\n";
    echo "Time: " . date('Y-m-d H:i:s') . "\n\n";
    
    // 1. Check if config.php exists
    if (!file_exists('../../config.php')) {
        die("ERROR: config.php not found at ../../config.php\n");
    }
    require_once '../../config.php';
    echo "[1] config.php loaded successfully.\n";

// 2. Check Environment Variables
    echo "[2] Database Configuration:\n";
    echo "    - HOST: " . DB_HOST . "\n";
    echo "    - NAME: " . DB_NAME . "\n";
    echo "    - USER: " . DB_USER . "\n";
    echo "    - PASS: " . (defined('DB_PASS') ? "DEFINED (" . strlen(DB_PASS) . " chars)" : "NOT DEFINED") . "\n";

// 3. Test Connection
    try {
        $dsn = "mysql:host=" . DB_HOST . ";dbname=" . DB_NAME . ";charset=utf8mb4";
        $options = [
            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
            PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
        ];
        $conn = new PDO($dsn, DB_USER, DB_PASS, $options);
        echo "[3] ✅ SUCCESS: Database connection established!\n\n";
        
        // 4. Test Table Existence
        echo "[4] Checking Tables:\n";
        $tables = ['users', 'device_slots', 'telemetry', 'sites', 'rooms', 'assets', 'devices'];
        foreach ($tables as $table) {
            $check = $conn->query("SHOW TABLES LIKE '$table'");
            if ($check->rowCount() > 0) {
                // Get row count
                $count = $conn->query("SELECT COUNT(*) FROM `$table`")->fetchColumn();
                echo "    ✅ Found Table: `$table` (Rows: $count)\n";
            } else {
                echo "    ❌ Table MISSING: `$table`\n";
            }
        }
        
        // 5. Check for System User
        echo "\n[5] Checking for System Auto-Staging User:\n";
        $stmt = $conn->prepare("SELECT id FROM users WHERE id = 'SYSTEM_AUTO_STAGING'");
        $stmt->execute();
        if ($stmt->fetch()) {
            echo "    ✅ User 'SYSTEM_AUTO_STAGING' found.\n";
        } else {
            echo "    ❌ MISSING: User 'SYSTEM_AUTO_STAGING' (Required for Auto-Provisioning)\n";
            echo "    Attempting to create system user...\n";
            try {
                $conn->prepare("INSERT INTO users (id, email, display_name, role) VALUES ('SYSTEM_AUTO_STAGING', 'system@Smart_Panel.local', 'System Staging', 'admin')")->execute();
                echo "    ✅ CREATED 'SYSTEM_AUTO_STAGING' user.\n";
            } catch (Exception $ex) {
                echo "    ❌ FAILED to create user: " . $ex->getMessage() . "\n";
            }
        }

} catch (PDOException $e) {
        echo "[3] ❌ CONNECTION FAILED:\n";
        echo "    - Error Code: " . $e->getCode() . "\n";
        echo "    - Message: " . $e->getMessage() . "\n";
    }

} catch (Exception $e) {
    echo "\n❌ CRITICAL ERROR:\n" . $e->getMessage();
}

Batal

⬅ Naik ke api 83 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁admin	dir	—	2026-04-30 04:28	📂 Buka
📁alerts	dir	—	2026-04-30 04:28	📂 Buka
📁auth	dir	—	2026-04-30 04:28	📂 Buka
📁dashboard	dir	—	2026-04-30 07:02	📂 Buka
📁industrial	dir	—	2026-07-06 17:04	📂 Buka
📁ota	dir	—	2026-04-30 04:28	📂 Buka
🐘active_ping.php	php	744 B	2026-04-30 09:54	✏️ Edit 👁️ View
🐘active_tracker.php	php	2.7 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘alert_history.php	php	4.8 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘analytics_engine.php	php	5.8 KB	2026-04-30 09:54	✏️ Edit 👁️ View
📝asset_fix_summary.txt	txt	805 B	2026-04-30 09:54	✏️ Edit 👁️ View
🐘audit_logs.php	php	1.7 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘backfill_energy.php	php	935 B	2026-04-30 09:54	✏️ Edit 👁️ View
🐘bind_hardware.php	php	4.4 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘bot_slots.php	php	2.3 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘check_serial.php	php	4.6 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘complete_command.php	php	2.8 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘control.php	php	13.5 KB	2026-05-01 01:53	✏️ Edit 👁️ View
🐘control_mass.php	php	1.6 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘control_route.php	php	2.9 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘db_explain.php	php	899 B	2026-04-30 09:54	✏️ Edit 👁️ View
🐘db_optimize.php	php	1.1 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘debug_cumulative.php	php	1.2 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘debug_db.php	php	3.1 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘debug_db_check.php	php	505 B	2026-04-30 09:54	✏️ Edit 👁️ View
🐘debug_energy.php	php	649 B	2026-04-30 09:54	✏️ Edit 👁️ View
🐘debug_slot.php	php	600 B	2026-04-30 09:54	✏️ Edit 👁️ View
🐘debug_wana.php	php	721 B	2026-04-30 09:54	✏️ Edit 👁️ View
🐘delete_node_permanent.php	php	6.2 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘delete_site.php	php	4.3 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘delete_slot.php	php	2.3 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘dump_debug.php	php	850 B	2026-04-30 09:54	✏️ Edit 👁️ View
🐘energy_anchor.php	php	1.8 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘energy_integration_engine.php	php	2.5 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘firmware_core.php	php	3.9 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘fix_gateway_schema.php	php	1.3 KB	2026-05-01 01:52	✏️ Edit 👁️ View
🐘fix_schema.php	php	6.4 KB	2026-05-01 01:52	✏️ Edit 👁️ View
🐘fleet_stats.php	php	4.2 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘geo_intelligence.php	php	3.8 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘get_commands.php	php	6.1 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘get_hidden_nodes.php	php	1009 B	2026-04-30 09:54	✏️ Edit 👁️ View
🐘get_hierarchy.php	php	16.6 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘health_analysis.php	php	6.2 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘history.php	php	13.6 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘history_new_bug.php	php	17.8 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘history_precision.php	php	9.4 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘history_v42.php	php	8.4 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘hive_core.php	php	5.9 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘inspect_db.php	php	1.6 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘inspect_schema.php	php	734 B	2026-04-30 09:54	✏️ Edit 👁️ View
🐘latest.php	php	17.3 KB	2026-05-01 01:52	✏️ Edit 👁️ View
🐘list_devices.php	php	271 B	2026-04-30 09:54	✏️ Edit 👁️ View
🐘list_slots.php	php	1.8 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘mass_command.php	php	5.2 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘mesh_sync.php	php	2.7 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘migrate_3phase.php	php	2.4 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘migrate_commands_signature.php	php	298 B	2026-04-30 09:54	✏️ Edit 👁️ View
🐘move_hardware.php	php	4.8 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘ota_manager.php	php	3.6 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘peek_data.php	php	452 B	2026-04-30 09:54	✏️ Edit 👁️ View
🐘peek_recent.php	php	407 B	2026-04-30 09:54	✏️ Edit 👁️ View
🐘push_structure.php	php	12.5 KB	2026-05-01 01:53	✏️ Edit 👁️ View
🐘register_hardware.php	php	2.8 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘room_status.php	php	4.9 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘security_digest.php	php	3.2 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘seed_admin.php	php	1.4 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘server_health.php	php	1.4 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘set_node_visibility.php	php	1.9 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘set_room_master.php	php	1.9 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘sharing.php	php	4.9 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘simulate_history.php	php	5.9 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘sync.php	php	8.1 KB	2026-05-01 01:52	✏️ Edit 👁️ View
🐘sync_location_slots.php	php	3.2 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘system_config.php	php	1.9 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘telemetry.php	php	49.8 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘telemetry_batch.php	php	17.4 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘telemetry_engine.php	php	5.9 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘telemetry_raw.php	php	6.1 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘telemetry_v2.php	php	11 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘unlink_device.php	php	2.1 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘update_sensor_config.php	php	3.2 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘update_user.php	php	4.1 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘user_manager.php	php	6.3 KB	2026-04-30 09:54	✏️ Edit 👁️ View