File Manager

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

<?php
header("Content-Type: application/json; charset=UTF-8");
header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: GET, POST, PUT, DELETE, OPTIONS');
header('Access-Control-Allow-Headers: Content-Type, Authorization, X-Api-Key');
// EcoTech Database 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 "--- ECOTECH DB 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@ecotech.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 106 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁admin	dir	—	2026-03-20 09:16	📂 Buka
📁alerts	dir	—	2026-03-20 06:33	📂 Buka
📁auth	dir	—	2026-02-05 17:53	📂 Buka
📁dashboard	dir	—	2026-04-24 01:53	📂 Buka
📁industrial	dir	—	2026-03-16 16:14	📂 Buka
📁ota	dir	—	2026-04-02 09:10	📂 Buka
📁programs	dir	—	2026-02-08 08:58	📂 Buka
🐘active_ping.php	php	995 B	2026-03-28 05:59	✏️ Edit 👁️ View
🐘active_tracker.php	php	1.9 KB	2026-06-30 07:22	✏️ Edit 👁️ View
🐘alert_history.php	php	5 KB	2026-03-27 03:50	✏️ Edit 👁️ View
🐘analytics_engine.php	php	6 KB	2026-02-28 12:46	✏️ Edit 👁️ View
🐘audit_logs.php	php	1.9 KB	2026-02-24 15:21	✏️ Edit 👁️ View
🐘backfill_energy.php	php	1.2 KB	2026-03-27 03:50	✏️ Edit 👁️ View
🐘bind_hardware.php	php	2.7 KB	2026-03-03 09:58	✏️ Edit 👁️ View
🐘bot_slots.php	php	2.5 KB	2026-02-21 07:20	✏️ Edit 👁️ View
🐘check_serial.php	php	4.9 KB	2026-02-23 09:27	✏️ Edit 👁️ View
🐘check_tz.php	php	427 B	2026-03-14 05:28	✏️ Edit 👁️ View
🐘complete_command.php	php	3.1 KB	2026-02-23 10:26	✏️ Edit 👁️ View
🐘control.php	php	14.1 KB	2026-06-30 07:04	✏️ Edit 👁️ View
🐘control_mass.php	php	1.9 KB	2026-03-14 07:35	✏️ Edit 👁️ View
🐘db_explain.php	php	1.1 KB	2026-03-27 07:12	✏️ Edit 👁️ View
🐘db_optimize.php	php	1.3 KB	2026-03-27 07:13	✏️ Edit 👁️ View
🐘debug_cumulative.php	php	1.5 KB	2026-03-27 03:49	✏️ Edit 👁️ View
🐘debug_db.php	php	3.4 KB	2026-02-23 10:27	✏️ Edit 👁️ View
🐘debug_db_check.php	php	757 B	2026-03-17 15:21	✏️ Edit 👁️ View
🐘debug_energy.php	php	901 B	2026-03-27 03:50	✏️ Edit 👁️ View
🐘debug_history_logic.php	php	1.7 KB	2026-03-14 05:28	✏️ Edit 👁️ View
🐘debug_product69.php	php	8.9 KB	2026-07-03 07:31	✏️ Edit 👁️ View
🐘debug_raw_data.php	php	1.7 KB	2026-03-14 05:28	✏️ Edit 👁️ View
🐘debug_slot.php	php	852 B	2026-03-09 09:10	✏️ Edit 👁️ View
🐘debug_wana.php	php	973 B	2026-03-27 07:04	✏️ Edit 👁️ View
🐘delete_node_permanent.php	php	6.3 KB	2026-03-27 03:51	✏️ Edit 👁️ View
🐘delete_program.php	php	2.8 KB	2026-02-21 07:21	✏️ Edit 👁️ View
🐘delete_site.php	php	4.5 KB	2026-02-21 07:22	✏️ Edit 👁️ View
🐘delete_slot.php	php	2.5 KB	2026-02-23 09:27	✏️ Edit 👁️ View
🐘dump_debug.php	php	1.1 KB	2026-02-21 07:22	✏️ Edit 👁️ View
🐘energy_anchor.php	php	2.1 KB	2026-06-30 07:04	✏️ Edit 👁️ View
🐘energy_integration_engine.php	php	4.6 KB	2026-06-30 07:04	✏️ Edit 👁️ View
🐘firmware_core.php	php	5.5 KB	2026-02-24 15:20	✏️ Edit 👁️ View
🐘fix_schema.php	php	4.7 KB	2026-06-29 03:03	✏️ Edit 👁️ View
🐘fleet_stats.php	php	4.4 KB	2026-02-24 01:33	✏️ Edit 👁️ View
🐘geo_intelligence.php	php	4.1 KB	2026-03-01 13:44	✏️ Edit 👁️ View
🐘get_commands.php	php	4.2 KB	2026-06-30 07:22	✏️ Edit 👁️ View
🐘get_commands_backup.php	php	1.8 KB	2026-02-21 07:23	✏️ Edit 👁️ View
🐘get_hidden_nodes.php	php	1.2 KB	2026-03-17 15:28	✏️ Edit 👁️ View
🐘get_hierarchy.php	php	15.4 KB	2026-03-18 02:23	✏️ Edit 👁️ View
🐘get_slot_program.php	php	2 KB	2026-02-21 07:24	✏️ Edit 👁️ View
🐘health_analysis.php	php	6.2 KB	2026-06-30 07:04	✏️ Edit 👁️ View
🐘history.php	php	30.5 KB	2026-07-03 06:29	✏️ Edit 👁️ View
🐘history_backup1.php	php	9.8 KB	2026-04-23 06:40	✏️ Edit 👁️ View
🐘history_day_OK.php	php	18.4 KB	2026-03-23 11:49	✏️ Edit 👁️ View
🐘history_new_bug.php	php	17.8 KB	2026-03-28 02:09	✏️ Edit 👁️ View
🐘history_precision.php	php	11.9 KB	2026-06-30 07:04	✏️ Edit 👁️ View
🐘history_precision_b1.php	php	4.5 KB	2026-03-27 05:32	✏️ Edit 👁️ View
🐘history_precision_b2.php	php	5.6 KB	2026-04-23 06:39	✏️ Edit 👁️ View
🐘history_precision_day_OK.php	php	10 KB	2026-03-23 11:49	✏️ Edit 👁️ View
🐘hive_core.php	php	6.1 KB	2026-02-21 07:24	✏️ Edit 👁️ View
🐘inspect_db.php	php	1.9 KB	2026-03-18 01:49	✏️ Edit 👁️ View
🐘inspect_schema.php	php	990 B	2026-02-21 07:24	✏️ Edit 👁️ View
🐘latest.php	php	26.2 KB	2026-06-30 07:22	✏️ Edit 👁️ View
🐘list_devices.php	php	527 B	2026-02-21 07:25	✏️ Edit 👁️ View
🐘list_slots.php	php	2 KB	2026-02-21 07:25	✏️ Edit 👁️ View
🐘mass_command.php	php	5.5 KB	2026-02-21 07:25	✏️ Edit 👁️ View
🐘mesh_sync.php	php	3 KB	2026-02-21 07:25	✏️ Edit 👁️ View
🐘migrate_3phase.php	php	2.6 KB	2026-03-27 05:19	✏️ Edit 👁️ View
🐘move_hardware.php	php	5 KB	2026-03-07 07:37	✏️ Edit 👁️ View
🐘ota_manager.php	php	3.8 KB	2026-02-21 07:26	✏️ Edit 👁️ View
🐘peek_data.php	php	708 B	2026-02-21 07:26	✏️ Edit 👁️ View
🐘peek_recent.php	php	663 B	2026-03-09 10:42	✏️ Edit 👁️ View
📊product69_2026-07-02.csv	csv	3.1 MB	2026-07-03 07:32	✏️ Edit 👁️ View
📄purge_lock.timestamp	timestamp	10 B	2026-07-07 11:37	✏️ Edit 👁️ View
🐘push_structure.php	php	12.2 KB	2026-03-01 13:45	✏️ Edit 👁️ View
🐘register_hardware.php	php	3 KB	2026-02-21 07:26	✏️ Edit 👁️ View
🐘reset_energy.php	php	1.6 KB	2026-03-27 04:26	✏️ Edit 👁️ View
🐘room_status.php	php	5.4 KB	2026-02-21 07:49	✏️ Edit 👁️ View
🐘save_program.php	php	7.9 KB	2026-02-21 07:27	✏️ Edit 👁️ View
🐘security_digest.php	php	3.5 KB	2026-02-21 07:27	✏️ Edit 👁️ View
🐘seed_admin.php	php	1.7 KB	2026-02-21 07:27	✏️ Edit 👁️ View
🐘server_health.php	php	1.6 KB	2026-03-27 07:21	✏️ Edit 👁️ View
🐘set_node_visibility.php	php	2.1 KB	2026-03-17 14:45	✏️ Edit 👁️ View
🐘set_room_master.php	php	2.1 KB	2026-02-21 07:27	✏️ Edit 👁️ View
🐘sharing.php	php	5.1 KB	2026-03-18 01:49	✏️ Edit 👁️ View
🐘simulate_history.php	php	6.1 KB	2026-03-18 02:16	✏️ Edit 👁️ View
🐘slot_resolver.php	php	8.4 KB	2026-06-30 07:22	✏️ Edit 👁️ View
🐘status_ping.php	php	11.1 KB	2026-06-30 07:22	✏️ Edit 👁️ View
📋status_ping_error.log	log	0 B	2026-06-25 07:13	✏️ Edit 👁️ View
🐘sync.php	php	9.5 KB	2026-06-26 04:56	✏️ Edit 👁️ View
🐘sync_location_slots.php	php	3.5 KB	2026-03-27 03:51	✏️ Edit 👁️ View
🐘system_config.php	php	2.1 KB	2026-02-21 07:28	✏️ Edit 👁️ View
🐘telemetry.php	php	55.9 KB	2026-06-30 07:22	✏️ Edit 👁️ View
🐘telemetry_back1.php	php	40.6 KB	2026-04-20 09:48	✏️ Edit 👁️ View
🐘telemetry_batch.php	php	15.1 KB	2026-06-30 07:22	✏️ Edit 👁️ View
📋telemetry_batch_error.log	log	628.5 KB	2026-07-07 04:59	✏️ Edit 👁️ View
🐘telemetry_engine.php	php	6.8 KB	2026-06-30 07:04	✏️ Edit 👁️ View
📋telemetry_error.log	log	92.7 MB	2026-07-07 07:46	✏️ Edit 👁️ View
📄telemetry_error.log.20260625_132649.bak	bak	1.3 GB	2026-06-25 06:26	✏️ Edit 👁️ View
📋telemetry_raw.log	log	1.3 MB	2026-06-26 05:11	✏️ Edit 👁️ View
📄telemetry_raw.log.20260625_132649.bak	bak	6.6 GB	2026-06-25 06:26	✏️ Edit 👁️ View
🐘telemetry_raw.php	php	5.9 KB	2026-06-30 07:04	✏️ Edit 👁️ View
🐘telemetry_v2.php	php	13.9 KB	2026-06-30 07:04	✏️ Edit 👁️ View
🐘test_dual_core.php	php	1.9 KB	2026-03-23 11:58	✏️ Edit 👁️ View
🐘test_write.php	php	541 B	2026-04-23 06:20	✏️ Edit 👁️ View
🐘unlink_device.php	php	2.3 KB	2026-04-02 08:11	✏️ Edit 👁️ View
🐘update_sensor_config.php	php	3.5 KB	2026-03-14 07:36	✏️ Edit 👁️ View
🐘update_user.php	php	4.3 KB	2026-02-21 07:30	✏️ Edit 👁️ View
🐘user_manager.php	php	6.5 KB	2026-02-23 08:15	✏️ Edit 👁️ View