Doc_chelvyn/MTT/Infra/MTT — Server Dev & Deploy.md

210 lines
9.3 KiB
Markdown
Raw Permalink Normal View History

---
proyek: MTT (Mitra Tours and Travel)
modul: mtt, advance_budget, payment_request_v2, accounting_advance, base_module, inventory_advance
odoo: "18.0 Enterprise"
kategori: Infra
periode: 2026-10-23
status: ✅ Server dev jalan · DB MTT ter-restore & ter-upgrade (-u base) · ⏳ filestore belum · ⚠️ bug CSV fresh install
sumber: setup langsung via SSH ke vps-116044 + repo SINERKA/mtt_dev branch develop
tags:
- mtt
- infra
- docker
- deploy
- restore
---
> Index: [[MTT — Index]] · Kategori: **Infra**
>
> Server dev MTT dipindah ke **vps-116044** (`103.25.223.128`). Kode diambil dari repo
> `SINERKA/mtt_dev` branch **`develop`**, di-clone di Mac lalu di-rsync ke server lengkap
> dengan `.git`. Database `MTT` di-restore dari dump `pg_dump 18` lalu di-upgrade `-u base`.
> Dokumen ini berisi struktur server, cara deploy, cara restore, dan catatan yang perlu diketahui tim.
# MTT — Server Dev & Deploy
## Ringkasan
| | |
|---|---|
| **Server** | `vps-116044` · `103.25.223.128` · Ubuntu 24.04 · 4 CPU · RAM 7.8 GB · disk 193 GB |
| **SSH** | `ssh mtt` (root, port **8288**, key `SINERKA/key/mtt_deploy`) |
| **Folder** | `/opt/mtt-dev` |
| **URL** | http://103.25.223.128:8069 · login: `/web/login?db=MTT` |
| **Odoo** | image `odoo:18.0` (`18.0-20261015`) + Enterprise `addons_e` (661 modul, commit 2025-06-27) |
| **PostgreSQL** | 15 (container `db`, port tidak di-publish ke host) |
| **DB user** | `snkmttodoo` (password di `/opt/mtt-dev/.env`) |
| **Master password** | lihat `admin_passwd` di `/opt/mtt-dev/config/odoo.conf` |
| **Repo** | `https://repo.sinerka.id/SINERKA/mtt_dev.git` · branch **`develop`** |
| **Clone lokal** | `~/developer/SINERKA/snk_mtt/mtt_dev` |
| **Script deploy** | `~/developer/SINERKA/snk_mtt/deploy/deploy.sh` |
| **Satu server dengan** | `dev_snk_hr` (port 8018) · `eka-dev` (port 8090) — jangan sentuh tag `odoo:18.0` / `postgres:15` sembarangan |
---
## Alur Deploy (`deploy.sh`)
```mermaid
flowchart TD
A["./deploy.sh [-u DB] [-m modul] [--no-pull]"] --> B{"--no-pull?"}
B -- "tidak" --> C{"clone lokal di<br/>branch develop?"}
C -- "bukan develop" --> X1["exit 1<br/>'mtt_dev ada di branch ...'"]
C -- "ya" --> D["git pull --ff-only origin develop<br/>(di Mac, pakai kredensial Mac)"]
D -- "gagal (non fast-forward / auth)" --> X2["exit — server tidak tersentuh"]
D -- "ok" --> E
B -- "ya" --> E["rsync mtt_dev → /opt/mtt-dev/addons<br/>--delete, termasuk .git & __pycache__"]
E --> F["rsync docker-compose.yml"]
F --> G{".env & config/odoo.conf<br/>sudah ada di server?"}
G -- "belum" --> H["generate di server:<br/>password DB acak (openssl), chown odoo.conf ke user odoo"]
G -- "sudah" --> I["dipakai apa adanya<br/>(tidak pernah ditimpa dari lokal)"]
H --> J["docker compose up -d db"]
I --> J
J --> K{"-u DB diisi?"}
K -- "ya" --> L["stop web → odoo -u MODUL<br/>--stop-after-init --no-http"]
K -- "tidak" --> M
L --> M["docker compose up -d --force-recreate web"]
M --> N["✅ http://103.25.223.128:8069"]
class N ok
class X1,X2 err
classDef ok fill:#d1fae5,stroke:#059669,color:#064e3b
classDef err fill:#fee2e2,stroke:#dc2626,color:#7f1d1d
```
Keterangan warna: 🟩 hijau = sukses · 🟥 merah = berhenti / gagal.
**Kenapa dari Mac, bukan `git pull` di server?** Server belum punya kredensial ke
`repo.sinerka.id`. `git branch` / `git log` / `git status` di server tetap jalan karena `.git`
ikut tersalin, tapi `git pull` langsung dari server akan gagal sampai kredensial dipasang.
### Perintah
```bash
# update kode develop + restart web
~/developer/SINERKA/snk_mtt/deploy/deploy.sh
# update kode + upgrade module mtt di DB MTT
~/developer/SINERKA/snk_mtt/deploy/deploy.sh -u MTT
# upgrade semua module (base) di DB MTT
~/developer/SINERKA/snk_mtt/deploy/deploy.sh -u MTT -m base
# sync tanpa git pull (mis. sedang di branch lain)
~/developer/SINERKA/snk_mtt/deploy/deploy.sh --no-pull
```
Cek kondisi git di server:
```bash
ssh mtt 'cd /opt/mtt-dev/addons && git branch && git log -1 --oneline && git status -s'
```
---
## Struktur Folder & Mount
```
/opt/mtt-dev/
├── docker-compose.yml ← dari snk_mtt/deploy/
├── .env ← generate di server (600) — ODOO_PORT, POSTGRES_USER, POSTGRES_PASSWORD
├── config/odoo.conf ← generate di server (600, owner user odoo)
├── addons/ ← repo mtt_dev (develop) + .git
├── addons_e/ ← Odoo 18 Enterprise, disalin sekali dari server lama exabytes
└── extra/ ← expiration_date, disalin sekali dari server lama exabytes
```
| Folder host | Mount di container | Isi |
|---|---|---|
| `addons_e/` | `/mnt/addons_e` | Odoo 18 Enterprise (661 modul) |
| `addons/accounting_advance/` | `/mnt/accounting_advance` | accounting_advance, asset_number, cash_request, giro_and_check, multicurrency_revaluation, payment_request, … |
| `addons/base_module/` | `/mnt/base_module` | base_tier_validation, bi_sql_editor, ir_attachment_s3, session_redis, snk_ezmaterai |
| `addons/inventory_advance/` | `/mnt/inventory_advance` | inventory_advance, cost_price_per_batch, stock_no_negative_value |
| `addons/` | `/mnt/extra-addons` | mtt, advance_budget, payment_request_v2, relational_field_control |
| `extra/` | `/mnt/extra` | expiration_date |
Isi `odoo.conf` (tanpa secret):
```ini
addons_path = /mnt/addons_e,/mnt/accounting_advance,/mnt/base_module,/mnt/inventory_advance,/mnt/extra-addons,/mnt/extra
data_dir = /var/lib/odoo
db_host = db
db_user = snkmttodoo
dbfilter = .*
list_db = True
limit_memory_hard = 2684354560
limit_memory_soft = 2147483648
limit_time_cpu = 60000000
limit_time_real = 120000000
```
---
## Restore Database `MTT` (2026-10-23)
```mermaid
flowchart TD
A["Downloads/MTT_2026-10-23_03-28-54.dump<br/>123 MB · custom format v1.16<br/>pg_dump 18.1 · sumber PG 12.22"] --> B{"pg_restore 15<br/>bisa baca v1.16?"}
B -- "tidak (maks v1.14)" --> C["pakai container postgres:17<br/>sebagai client pg_restore"]
C --> D["createdb MTT (template0, UTF8)<br/>pg_restore -h db --no-owner --no-privileges -j 4"]
D --> E["736 tabel · 78 user · 146 modul · 1.5 GB<br/>2 error di-skip (kemungkinan SET transaction_timeout)"]
E --> F["odoo -u mtt → 0 ERROR"]
F --> G["odoo -u base → 146 modul, 81 detik, 0 ERROR"]
G --> H["✅ login /web/login?db=MTT"]
H -.-> I["restore filestore → filestore/MTT<br/>(belum dikerjakan)"]
class H ok
class I todo
classDef ok fill:#d1fae5,stroke:#059669,color:#064e3b
classDef todo fill:#f3f4f6,stroke:#9ca3af,color:#374151,stroke-dasharray:4 3
```
Keterangan warna: 🟩 hijau = sukses · ⬜ abu putus-putus = belum dikerjakan.
Perintah yang dipakai (dijalankan di server, password diambil dari `.env` tanpa ditampilkan):
```bash
cd /opt/mtt-dev
docker compose stop web
docker compose exec -T db sh -c 'createdb -U $POSTGRES_USER --template=template0 --encoding=UTF8 MTT'
docker run --rm --network mtt-dev_default --env-file .env -v /opt/mtt-dev/restore:/r:ro postgres:17 \
sh -c 'PGPASSWORD=$POSTGRES_PASSWORD pg_restore -h db -U $POSTGRES_USER -d MTT --no-owner --no-privileges -j 4 /r/<file>.dump'
docker compose run --rm --no-deps web odoo -c /etc/odoo/odoo.conf -d MTT -u base --stop-after-init --no-http
docker compose up -d web
```
> [!warning] DB tidak di-neutralize
> Cron dari `mtt/data/odoo_cron.xml` dan cron bawaan Odoo **aktif** di server dev ini.
> Kalau ada mail server keluar yang terkonfigurasi di DB, email bisa terkirim ke user asli.
---
## Akses SSH
- Key khusus: `~/developer/SINERKA/key/mtt_deploy` (comment `mtt-deploy`), terpasang di `/root/.ssh/authorized_keys`.
- Alias di `~/.ssh/config`:
```
Host mtt
HostName 103.25.223.128
User root
Port 8288
IdentityFile /Users/chelvynkleden/developer/SINERKA/key/mtt_deploy
IdentitiesOnly yes
```
- Cabut akses: hapus baris `mtt-deploy` di `/root/.ssh/authorized_keys` server.
---
## Catatan & Temuan
| # | Temuan | Dampak | Status |
|---|---|---|---|
| 1 | `mtt/security/ir.model.access.csv` baris 71 & 73 **dobel**: `access_snk_rab_list` (masuk lewat merge `c8b61b5`, 2026-01-01) | **Fresh install `mtt` di DB baru gagal**: `ON CONFLICT DO UPDATE command cannot affect row a second time`. Upgrade di DB yang sudah ada tetap jalan | ⚠️ Belum diperbaiki di repo — cukup hapus baris 73 |
| 2 | `bi_sql_editor` butuh `sql_request_abstract`, tidak ada di repo maupun server lama | Hanya masalah kalau `bi_sql_editor` mau di-install | ℹ️ Info |
| 3 | `addons_e` (2025-06-27) jauh lebih tua dari image Odoo (2026-10-15) | Belum ada error, tapi rawan kalau Enterprise memanggil fungsi community yang sudah berubah | ℹ️ Pantau |
| 4 | Warning upgrade: `unknown parameter 'tracking'` di `snk.budget.line` (2 field), `selection overrides existing selection` di beberapa field `state`, label kembar `state` / `parent_state` di `account.move.line` | Bukan kegagalan, hanya warning kode | ℹ️ Rapikan kapan-kapan |
| 5 | Filestore DB `MTT` belum dimasukkan | Lampiran / gambar tampil kosong | ⏳ Menunggu file |
| 6 | Server menampilkan `*** System restart required ***` | Reboot ikut mematikan `dev_snk_hr` & `eka-dev` | ℹ️ Koordinasi dulu sebelum reboot |
| 7 | `git pull` dari server belum bisa (tidak ada kredensial `repo.sinerka.id`) | Update kode harus lewat `deploy.sh` dari Mac | ℹ️ Pasang kredensial di server kalau mau pull langsung |