[2026-03-13 09:18:58] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:status] Request masuk | {"method":"GET","action":"status","perusahaan_id":1,"post":[],"get":{"action":"status","client_id":"1337"}}
[2026-03-13 09:18:58] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:status] Cek STATUS untuk client_id: 1337
[2026-03-13 09:18:58] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:status] STATUS: tidak ada sesi aktif untuk client_id 1337
[2026-03-13 09:18:59] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Request masuk | {"method":"POST","action":"create","perusahaan_id":1,"post":{"action":"create","client_id":"1337","modem_port":"80"},"get":[]}
[2026-03-13 09:18:59] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Mulai CREATE remote session | {"client_id":1337,"modem_port":80}
[2026-03-13 09:18:59] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] Klien ditemukan | {"nama":"WULUH - ANJIK","pppoe":"anjikwlh3550@dbn.id"}
[2026-03-13 09:18:59] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Mengambil IP aktif PPPoE: anjikwlh3550@dbn.id
[2026-03-13 09:18:59] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] Koneksi ke Mikrotik ISP: vpn.dbeen.my.id:8966:8728
[2026-03-13 09:19:00] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] IP aktif klien: 10.2.10.6
[2026-03-13 09:19:00] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Membersihkan sesi lama untuk client_id 1337
[2026-03-13 09:19:00] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] cleanupClientSessions: tidak ada sesi lama untuk client_id 1337
[2026-03-13 09:19:00] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Menggunakan CHR: Server Utama (103.191.92.234)
[2026-03-13 09:19:00] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] allocatePort: range 2000, 0 port terpakai
[2026-03-13 09:19:00] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] Port eksternal dialokasikan: 1001
[2026-03-13 09:19:00] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Membuat DST-NAT: 103.191.92.234:1001 → 10.2.10.6:80
[2026-03-13 09:19:00] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] connectChr: berhasil ke 103.191.92.234
[2026-03-13 09:19:00] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] createDstNat raw response | {"result":"*95"}
[2026-03-13 09:19:00] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] DST-NAT berhasil dibuat, rule_id: 
[2026-03-13 09:19:00] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] CREATE berhasil | {"session_id":172,"client_id":1337,"pppoe":"anjikwlh3550@dbn.id","client_ip":"10.2.10.6","ext_port":1001,"url":"http:\/\/103.191.92.234:1001","expires_at":"2026-03-13 11:19:00"}
[2026-03-13 09:20:58] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:delete] Request masuk | {"method":"POST","action":"delete","perusahaan_id":1,"post":{"action":"delete","client_id":"1337","session_id":"172"},"get":[]}
[2026-03-13 09:20:58] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:delete] Mulai DELETE | {"client_id":1337,"session_id":172}
[2026-03-13 09:20:58] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:delete] Sesi ditemukan, menghapus NAT rule: 0 | {"session_db_id":172,"ext_port":1001,"client_ip":"10.2.10.6"}
[2026-03-13 09:20:58] [WARNING] ⚠️  [user:2] [ip:36.78.116.195] [action:delete] Tidak ada CHR/rule_id, skip hapus NAT | {"chr":"ok","rule_id":"0"}
[2026-03-13 09:20:58] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:delete] DELETE selesai | {"session_db_id":172,"nat_deleted":1}
[2026-03-13 09:21:17] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:status] Request masuk | {"method":"GET","action":"status","perusahaan_id":1,"post":[],"get":{"action":"status","client_id":"1650"}}
[2026-03-13 09:21:17] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:status] Cek STATUS untuk client_id: 1650
[2026-03-13 09:21:17] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:status] STATUS: tidak ada sesi aktif untuk client_id 1650
[2026-03-13 09:21:18] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Request masuk | {"method":"POST","action":"create","perusahaan_id":1,"post":{"action":"create","client_id":"1650","modem_port":"80"},"get":[]}
[2026-03-13 09:21:18] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Mulai CREATE remote session | {"client_id":1650,"modem_port":80}
[2026-03-13 09:21:18] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] Klien ditemukan | {"nama":"WULUH - BU_DUWI","pppoe":"buduwiwlh4809@dbn.id"}
[2026-03-13 09:21:18] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Mengambil IP aktif PPPoE: buduwiwlh4809@dbn.id
[2026-03-13 09:21:18] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] Koneksi ke Mikrotik ISP: vpn.dbeen.my.id:8966:8728
[2026-03-13 09:21:19] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] IP aktif klien: 10.2.11.241
[2026-03-13 09:21:19] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Membersihkan sesi lama untuk client_id 1650
[2026-03-13 09:21:19] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] cleanupClientSessions: tidak ada sesi lama untuk client_id 1650
[2026-03-13 09:21:19] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Menggunakan CHR: Server Utama (103.191.92.234)
[2026-03-13 09:21:19] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] allocatePort: range 2000, 0 port terpakai
[2026-03-13 09:21:19] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] Port eksternal dialokasikan: 1001
[2026-03-13 09:21:19] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Membuat DST-NAT: 103.191.92.234:1001 → 10.2.11.241:80
[2026-03-13 09:21:19] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] connectChr: berhasil ke 103.191.92.234
[2026-03-13 09:21:19] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] createDstNat raw response | {"result":"*96"}
[2026-03-13 09:21:19] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] DST-NAT berhasil dibuat, rule_id: 
[2026-03-13 09:21:19] [CRITICAL] 🔥 [user:2] [ip:36.78.116.195] [action:create] FATAL ERROR: Uncaught mysqli_sql_exception: Duplicate entry '1001-1' for key 'unique_port_perusahaan' in /home/dbeenapp/kas.dbeenapp.my.id/menu/koneksi.php:72
Stack trace:
#0 /home/dbeenapp/kas.dbeenapp.my.id/menu/koneksi.php(72): mysqli_stmt->execute()
#1 /home/dbeenapp/kas.dbeenapp.my.id/menu/remote_access.php(193): SyncStatement->execute()
#2 /home/dbeenapp/kas.dbeenapp.my.id/menu/remote_access.php(95): handleCreate()
#3 {main}
  thrown in /home/dbeenapp/kas.dbeenapp.my.id/menu/koneksi.php line 72
[2026-03-13 09:21:22] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Request masuk | {"method":"POST","action":"create","perusahaan_id":1,"post":{"action":"create","client_id":"1650","modem_port":"80"},"get":[]}
[2026-03-13 09:21:22] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Mulai CREATE remote session | {"client_id":1650,"modem_port":80}
[2026-03-13 09:21:22] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] Klien ditemukan | {"nama":"WULUH - BU_DUWI","pppoe":"buduwiwlh4809@dbn.id"}
[2026-03-13 09:21:22] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Mengambil IP aktif PPPoE: buduwiwlh4809@dbn.id
[2026-03-13 09:21:22] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] Koneksi ke Mikrotik ISP: vpn.dbeen.my.id:8966:8728
[2026-03-13 09:21:22] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] IP aktif klien: 10.2.11.241
[2026-03-13 09:21:22] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Membersihkan sesi lama untuk client_id 1650
[2026-03-13 09:21:22] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] cleanupClientSessions: tidak ada sesi lama untuk client_id 1650
[2026-03-13 09:21:22] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Menggunakan CHR: Server Utama (103.191.92.234)
[2026-03-13 09:21:22] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] allocatePort: range 2000, 0 port terpakai
[2026-03-13 09:21:22] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] Port eksternal dialokasikan: 1001
[2026-03-13 09:21:22] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Membuat DST-NAT: 103.191.92.234:1001 → 10.2.11.241:80
[2026-03-13 09:21:22] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] connectChr: berhasil ke 103.191.92.234
[2026-03-13 09:21:22] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] createDstNat raw response | {"result":"*97"}
[2026-03-13 09:21:22] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] DST-NAT berhasil dibuat, rule_id: 
[2026-03-13 09:21:22] [CRITICAL] 🔥 [user:2] [ip:36.78.116.195] [action:create] FATAL ERROR: Uncaught mysqli_sql_exception: Duplicate entry '1001-1' for key 'unique_port_perusahaan' in /home/dbeenapp/kas.dbeenapp.my.id/menu/koneksi.php:72
Stack trace:
#0 /home/dbeenapp/kas.dbeenapp.my.id/menu/koneksi.php(72): mysqli_stmt->execute()
#1 /home/dbeenapp/kas.dbeenapp.my.id/menu/remote_access.php(193): SyncStatement->execute()
#2 /home/dbeenapp/kas.dbeenapp.my.id/menu/remote_access.php(95): handleCreate()
#3 {main}
  thrown in /home/dbeenapp/kas.dbeenapp.my.id/menu/koneksi.php line 72
[2026-03-13 09:21:23] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Request masuk | {"method":"POST","action":"create","perusahaan_id":1,"post":{"action":"create","client_id":"1650","modem_port":"80"},"get":[]}
[2026-03-13 09:21:23] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Mulai CREATE remote session | {"client_id":1650,"modem_port":80}
[2026-03-13 09:21:23] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] Klien ditemukan | {"nama":"WULUH - BU_DUWI","pppoe":"buduwiwlh4809@dbn.id"}
[2026-03-13 09:21:23] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Mengambil IP aktif PPPoE: buduwiwlh4809@dbn.id
[2026-03-13 09:21:23] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] Koneksi ke Mikrotik ISP: vpn.dbeen.my.id:8966:8728
[2026-03-13 09:21:24] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] IP aktif klien: 10.2.11.241
[2026-03-13 09:21:24] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Membersihkan sesi lama untuk client_id 1650
[2026-03-13 09:21:24] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] cleanupClientSessions: tidak ada sesi lama untuk client_id 1650
[2026-03-13 09:21:24] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Menggunakan CHR: Server Utama (103.191.92.234)
[2026-03-13 09:21:24] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] allocatePort: range 2000, 0 port terpakai
[2026-03-13 09:21:24] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] Port eksternal dialokasikan: 1001
[2026-03-13 09:21:24] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Membuat DST-NAT: 103.191.92.234:1001 → 10.2.11.241:80
[2026-03-13 09:21:24] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] connectChr: berhasil ke 103.191.92.234
[2026-03-13 09:21:24] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] createDstNat raw response | {"result":"*98"}
[2026-03-13 09:21:24] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] DST-NAT berhasil dibuat, rule_id: 
[2026-03-13 09:21:24] [CRITICAL] 🔥 [user:2] [ip:36.78.116.195] [action:create] FATAL ERROR: Uncaught mysqli_sql_exception: Duplicate entry '1001-1' for key 'unique_port_perusahaan' in /home/dbeenapp/kas.dbeenapp.my.id/menu/koneksi.php:72
Stack trace:
#0 /home/dbeenapp/kas.dbeenapp.my.id/menu/koneksi.php(72): mysqli_stmt->execute()
#1 /home/dbeenapp/kas.dbeenapp.my.id/menu/remote_access.php(193): SyncStatement->execute()
#2 /home/dbeenapp/kas.dbeenapp.my.id/menu/remote_access.php(95): handleCreate()
#3 {main}
  thrown in /home/dbeenapp/kas.dbeenapp.my.id/menu/koneksi.php line 72
[2026-03-13 09:21:28] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:status] Request masuk | {"method":"GET","action":"status","perusahaan_id":1,"post":[],"get":{"action":"status","client_id":"1337"}}
[2026-03-13 09:21:28] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:status] Cek STATUS untuk client_id: 1337
[2026-03-13 09:21:28] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:status] STATUS: tidak ada sesi aktif untuk client_id 1337
[2026-03-13 09:21:29] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Request masuk | {"method":"POST","action":"create","perusahaan_id":1,"post":{"action":"create","client_id":"1337","modem_port":"80"},"get":[]}
[2026-03-13 09:21:29] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Mulai CREATE remote session | {"client_id":1337,"modem_port":80}
[2026-03-13 09:21:29] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] Klien ditemukan | {"nama":"WULUH - ANJIK","pppoe":"anjikwlh3550@dbn.id"}
[2026-03-13 09:21:29] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Mengambil IP aktif PPPoE: anjikwlh3550@dbn.id
[2026-03-13 09:21:29] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] Koneksi ke Mikrotik ISP: vpn.dbeen.my.id:8966:8728
[2026-03-13 09:21:29] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] IP aktif klien: 10.2.10.6
[2026-03-13 09:21:29] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Membersihkan sesi lama untuk client_id 1337
[2026-03-13 09:21:29] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] cleanupClientSessions: tidak ada sesi lama untuk client_id 1337
[2026-03-13 09:21:29] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Menggunakan CHR: Server Utama (103.191.92.234)
[2026-03-13 09:21:29] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] allocatePort: range 2000, 0 port terpakai
[2026-03-13 09:21:29] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] Port eksternal dialokasikan: 1001
[2026-03-13 09:21:29] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Membuat DST-NAT: 103.191.92.234:1001 → 10.2.10.6:80
[2026-03-13 09:21:29] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] connectChr: berhasil ke 103.191.92.234
[2026-03-13 09:21:29] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] createDstNat raw response | {"result":"*99"}
[2026-03-13 09:21:29] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] DST-NAT berhasil dibuat, rule_id: 
[2026-03-13 09:21:29] [CRITICAL] 🔥 [user:2] [ip:36.78.116.195] [action:create] FATAL ERROR: Uncaught mysqli_sql_exception: Duplicate entry '1001-1' for key 'unique_port_perusahaan' in /home/dbeenapp/kas.dbeenapp.my.id/menu/koneksi.php:72
Stack trace:
#0 /home/dbeenapp/kas.dbeenapp.my.id/menu/koneksi.php(72): mysqli_stmt->execute()
#1 /home/dbeenapp/kas.dbeenapp.my.id/menu/remote_access.php(193): SyncStatement->execute()
#2 /home/dbeenapp/kas.dbeenapp.my.id/menu/remote_access.php(95): handleCreate()
#3 {main}
  thrown in /home/dbeenapp/kas.dbeenapp.my.id/menu/koneksi.php line 72
[2026-03-13 09:46:21] [INFO] ℹ️  [user:11] [ip:114.5.242.73] [action:status] Request masuk | {"method":"GET","action":"status","perusahaan_id":1,"post":[],"get":{"action":"status","client_id":"1865"}}
[2026-03-13 09:46:21] [INFO] ℹ️  [user:11] [ip:114.5.242.73] [action:status] Cek STATUS untuk client_id: 1865
[2026-03-13 09:46:21] [INFO] ℹ️  [user:11] [ip:114.5.242.73] [action:status] STATUS: tidak ada sesi aktif untuk client_id 1865
[2026-03-13 09:52:46] [INFO] ℹ️  [user:22] [ip:202.58.72.108] [action:status] Request masuk | {"method":"GET","action":"status","perusahaan_id":1,"post":[],"get":{"action":"status","client_id":"1732"}}
[2026-03-13 09:52:46] [INFO] ℹ️  [user:22] [ip:202.58.72.108] [action:status] Cek STATUS untuk client_id: 1732
[2026-03-13 09:52:46] [INFO] ℹ️  [user:22] [ip:202.58.72.108] [action:status] STATUS: tidak ada sesi aktif untuk client_id 1732
[2026-03-13 09:55:50] [INFO] ℹ️  [user:16] [ip:202.58.72.108] [action:status] Request masuk | {"method":"GET","action":"status","perusahaan_id":1,"post":[],"get":{"action":"status","client_id":"1732"}}
[2026-03-13 09:55:50] [INFO] ℹ️  [user:16] [ip:202.58.72.108] [action:status] Cek STATUS untuk client_id: 1732
[2026-03-13 09:55:50] [INFO] ℹ️  [user:16] [ip:202.58.72.108] [action:status] STATUS: tidak ada sesi aktif untuk client_id 1732
[2026-03-13 10:02:37] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:status] Request masuk | {"method":"GET","action":"status","perusahaan_id":1,"post":[],"get":{"action":"status","client_id":"1367"}}
[2026-03-13 10:02:37] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:status] Cek STATUS untuk client_id: 1367
[2026-03-13 10:02:37] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:status] STATUS: tidak ada sesi aktif untuk client_id 1367
[2026-03-13 10:02:38] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Request masuk | {"method":"POST","action":"create","perusahaan_id":1,"post":{"action":"create","client_id":"1367","modem_port":"80"},"get":[]}
[2026-03-13 10:02:38] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Mulai CREATE remote session | {"client_id":1367,"modem_port":80}
[2026-03-13 10:02:38] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] Klien ditemukan | {"nama":"AKHTARA - ARI_SETIAWAN","pppoe":"arisetiawankhtr2108@dbn.id"}
[2026-03-13 10:02:38] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Mengambil IP aktif PPPoE: arisetiawankhtr2108@dbn.id
[2026-03-13 10:02:38] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] Koneksi ke Mikrotik ISP: vpn.dbeen.my.id:8966:8728
[2026-03-13 10:02:38] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] IP aktif klien: 10.2.11.21
[2026-03-13 10:02:38] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Membersihkan sesi lama untuk client_id 1367
[2026-03-13 10:02:38] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] cleanupClientSessions: tidak ada sesi lama untuk client_id 1367
[2026-03-13 10:02:38] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Menggunakan CHR: Server Utama (103.191.92.234)
[2026-03-13 10:02:38] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] allocatePort: range 2000, 0 port terpakai
[2026-03-13 10:02:38] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] Port eksternal dialokasikan: 1001
[2026-03-13 10:02:38] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Membuat DST-NAT: 103.191.92.234:1001 → 10.2.11.21:80
[2026-03-13 10:02:38] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] connectChr: berhasil ke 103.191.92.234
[2026-03-13 10:02:38] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] createDstNat raw response | {"result":"*9A","type":"string"}
[2026-03-13 10:02:38] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] Rule ID parsed: '*9A'
[2026-03-13 10:02:38] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] DST-NAT berhasil dibuat, rule_id: *9A
[2026-03-13 10:02:38] [CRITICAL] 🔥 [user:2] [ip:36.78.116.195] [action:create] FATAL ERROR: Uncaught mysqli_sql_exception: Duplicate entry '1001-1' for key 'unique_port_perusahaan' in /home/dbeenapp/kas.dbeenapp.my.id/menu/koneksi.php:72
Stack trace:
#0 /home/dbeenapp/kas.dbeenapp.my.id/menu/koneksi.php(72): mysqli_stmt->execute()
#1 /home/dbeenapp/kas.dbeenapp.my.id/menu/remote_access.php(193): SyncStatement->execute()
#2 /home/dbeenapp/kas.dbeenapp.my.id/menu/remote_access.php(95): handleCreate()
#3 {main}
  thrown in /home/dbeenapp/kas.dbeenapp.my.id/menu/koneksi.php line 72
[2026-03-13 10:02:41] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Request masuk | {"method":"POST","action":"create","perusahaan_id":1,"post":{"action":"create","client_id":"1367","modem_port":"80"},"get":[]}
[2026-03-13 10:02:41] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Mulai CREATE remote session | {"client_id":1367,"modem_port":80}
[2026-03-13 10:02:41] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] Klien ditemukan | {"nama":"AKHTARA - ARI_SETIAWAN","pppoe":"arisetiawankhtr2108@dbn.id"}
[2026-03-13 10:02:41] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Mengambil IP aktif PPPoE: arisetiawankhtr2108@dbn.id
[2026-03-13 10:02:41] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] Koneksi ke Mikrotik ISP: vpn.dbeen.my.id:8966:8728
[2026-03-13 10:02:41] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] IP aktif klien: 10.2.11.21
[2026-03-13 10:02:41] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Membersihkan sesi lama untuk client_id 1367
[2026-03-13 10:02:41] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] cleanupClientSessions: tidak ada sesi lama untuk client_id 1367
[2026-03-13 10:02:41] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Menggunakan CHR: Server Utama (103.191.92.234)
[2026-03-13 10:02:41] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] allocatePort: range 2000, 0 port terpakai
[2026-03-13 10:02:41] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] Port eksternal dialokasikan: 1001
[2026-03-13 10:02:41] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Membuat DST-NAT: 103.191.92.234:1001 → 10.2.11.21:80
[2026-03-13 10:02:41] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] connectChr: berhasil ke 103.191.92.234
[2026-03-13 10:02:41] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] createDstNat raw response | {"result":"*9B","type":"string"}
[2026-03-13 10:02:41] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] Rule ID parsed: '*9B'
[2026-03-13 10:02:41] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] DST-NAT berhasil dibuat, rule_id: *9B
[2026-03-13 10:02:41] [CRITICAL] 🔥 [user:2] [ip:36.78.116.195] [action:create] FATAL ERROR: Uncaught mysqli_sql_exception: Duplicate entry '1001-1' for key 'unique_port_perusahaan' in /home/dbeenapp/kas.dbeenapp.my.id/menu/koneksi.php:72
Stack trace:
#0 /home/dbeenapp/kas.dbeenapp.my.id/menu/koneksi.php(72): mysqli_stmt->execute()
#1 /home/dbeenapp/kas.dbeenapp.my.id/menu/remote_access.php(193): SyncStatement->execute()
#2 /home/dbeenapp/kas.dbeenapp.my.id/menu/remote_access.php(95): handleCreate()
#3 {main}
  thrown in /home/dbeenapp/kas.dbeenapp.my.id/menu/koneksi.php line 72
[2026-03-13 10:02:42] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Request masuk | {"method":"POST","action":"create","perusahaan_id":1,"post":{"action":"create","client_id":"1367","modem_port":"80"},"get":[]}
[2026-03-13 10:02:42] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Mulai CREATE remote session | {"client_id":1367,"modem_port":80}
[2026-03-13 10:02:42] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] Klien ditemukan | {"nama":"AKHTARA - ARI_SETIAWAN","pppoe":"arisetiawankhtr2108@dbn.id"}
[2026-03-13 10:02:42] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Mengambil IP aktif PPPoE: arisetiawankhtr2108@dbn.id
[2026-03-13 10:02:42] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] Koneksi ke Mikrotik ISP: vpn.dbeen.my.id:8966:8728
[2026-03-13 10:02:42] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] IP aktif klien: 10.2.11.21
[2026-03-13 10:02:42] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Membersihkan sesi lama untuk client_id 1367
[2026-03-13 10:02:42] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] cleanupClientSessions: tidak ada sesi lama untuk client_id 1367
[2026-03-13 10:02:42] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Menggunakan CHR: Server Utama (103.191.92.234)
[2026-03-13 10:02:42] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] allocatePort: range 2000, 0 port terpakai
[2026-03-13 10:02:42] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] Port eksternal dialokasikan: 1001
[2026-03-13 10:02:42] [INFO] ℹ️  [user:2] [ip:36.78.116.195] [action:create] Membuat DST-NAT: 103.191.92.234:1001 → 10.2.11.21:80
[2026-03-13 10:02:42] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] connectChr: berhasil ke 103.191.92.234
[2026-03-13 10:02:42] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] createDstNat raw response | {"result":"*9C","type":"string"}
[2026-03-13 10:02:42] [DEBUG] 🔍 [user:2] [ip:36.78.116.195] [action:create] Rule ID parsed: '*9C'
[2026-03-13 10:02:42] [SUCCESS] ✅ [user:2] [ip:36.78.116.195] [action:create] DST-NAT berhasil dibuat, rule_id: *9C
[2026-03-13 10:02:42] [CRITICAL] 🔥 [user:2] [ip:36.78.116.195] [action:create] FATAL ERROR: Uncaught mysqli_sql_exception: Duplicate entry '1001-1' for key 'unique_port_perusahaan' in /home/dbeenapp/kas.dbeenapp.my.id/menu/koneksi.php:72
Stack trace:
#0 /home/dbeenapp/kas.dbeenapp.my.id/menu/koneksi.php(72): mysqli_stmt->execute()
#1 /home/dbeenapp/kas.dbeenapp.my.id/menu/remote_access.php(193): SyncStatement->execute()
#2 /home/dbeenapp/kas.dbeenapp.my.id/menu/remote_access.php(95): handleCreate()
#3 {main}
  thrown in /home/dbeenapp/kas.dbeenapp.my.id/menu/koneksi.php line 72