# server-connection — IT Operations Monorepo

Monorepo untuk aplikasi IT internal dan skrip infrastruktur **GIS Portal** (`gisportal.id`).

> **AI Agent & Developer baru:** Mulai dari [`docs/context-index.md`](docs/context-index.md) — peta navigasi seluruh dokumentasi.

---

## Aplikasi

| Folder | URL Produksi | Stack | Status |
|--------|-------------|-------|--------|
| `geonet-console/` | https://console.gisportal.id | Laravel 12 + PHP 8.3 | ✅ Production |
| `databaselist/` | https://databaselist.gisportal.id | Laravel (legacy) | ⚠️ Legacy → akan di-redirect ke geonet-console |
| `sqlservercheck/` | https://sqlservercheck.gisportal.id | PHP slim | ✅ Running |

---

## Quick Deploy

```powershell
# Deploy geonet-console (default)
.\scripts\deploy-geonet-console.ps1

# Deploy databaselist (legacy)
.\scripts\deploy-databaselist.ps1
.\scripts\deploy-databaselist.ps1 -NoBuild   # restart saja

# Deploy sqlservercheck
.\scripts\deploy-sqlservercheck.ps1
```

---

## Quick Start — Lokal Dev (geonet-console)

```powershell
# Clone & setup env
cd geonet-console
cp .env.example .env
# Edit .env — isi DB credentials, LDAP, OSS

# Build & jalankan di Docker
docker compose up -d --build

# Akses
# App: http://localhost:8091
# API: http://localhost:8091/api/v1
```

---

## Infrastruktur Server

| Role | IP | OS |
|------|----|----|
| **Reverse Proxy + Docker** | 10.100.1.24 | CentOS Linux 8 |
| **Database (PostgreSQL + SQL Server)** | 10.100.1.25 | Ubuntu 18.04 LTS |
| **Active Directory / LDAP** | 10.100.1.40 | Windows Server 2012 R2 |
| **NAS QNAP TS-932X** | 10.100.1.10 | QTS 5.2.9 |
| **Ollama AI VM** | 10.100.1.26 | Ubuntu 22.04 LTS |
| **Zabbix** | 10.100.1.42 | Ubuntu 22.04 LTS |
| **MikroTik CCR2004** | 10.100.1.1 | RouterOS 7.5 |

---

## Struktur Monorepo

```
server-connection/
├── geonet-console/         — Laravel 12 unified IT portal
├── databaselist/           — Legacy Laravel (akan di-deprecated)
├── sqlservercheck/         — Tool cek SQL Server koneksi
├── scripts/                — Deploy & SSH helper scripts
│   ├── deploy-geonet-console.ps1
│   ├── deploy-databaselist.ps1
│   ├── ssh-remote.ps1      — SSH ke reverse proxy
│   ├── ssh-mikrotik.ps1    — SSH ke MikroTik
│   ├── ssh-ollama.ps1      — SSH ke Ollama VM
│   └── ssh-qnap.ps1        — SSH ke QNAP NAS
├── server/                 — Audit server + MikroTik configs
├── docs/                   — Dokumentasi lengkap ⭐
├── .cursor/                — AI context (rules, me, context-index)
├── AGENTS.md               — Aturan AI agent
├── perintah.md             — Protokol sync + quick reference
└── readme.txt              — SSH commands cepat
```

---

## Dokumentasi Lengkap

Lihat [`docs/context-index.md`](docs/context-index.md) untuk peta dokumentasi.

| Topik | File |
|-------|------|
| Status proyek | `docs/project-status.md` |
| Arsitektur sistem | `docs/architecture/system-overview.md` |
| API geonet-console | `docs/api/overview.md` |
| Deploy guide | `docs/deployment.md` |
| Environment vars | `docs/environment.md` |
| Server & SSH | `docs/server.md` |
| Database | `docs/database.md` |
| Troubleshooting | `docs/troubleshooting.md` |