Commit e082a9
2026-04-09 09:57:27 OtterWiki: Add CT119 AzerothCore WoW Realm documentation| /dev/null .. ct-119-azerothcore.md | |
| @@ 0,0 1,132 @@ | |
| + | # AzerothCore WoW Realm (CT 119) |
| + | |
| + | ## Übersicht |
| + | |
| + | | Parameter | Wert | |
| + | |-----------|------| |
| + | | CT-ID | 119 | |
| + | | Hostname | azeroth | |
| + | | IP | 192.168.178.89 | |
| + | | OS | Debian 12 Bookworm | |
| + | | CPU / RAM / Disk | 4 vCPU / 8 GB / 40 GB SSD | |
| + | | Realm | lscloud (WotLK 3.3.5a) | |
| + | | Installiert | April 2026 | |
| + | |
| + | ## Ports & Dienste |
| + | |
| + | | Port | Dienst | Sichtbar | |
| + | |------|--------|----------| |
| + | | 3724 TCP | AzerothCore Authserver | extern (DNAT) | |
| + | | 8085 TCP | AzerothCore Worldserver | extern (DNAT) | |
| + | | 7878 TCP | SOAP-Interface (Worldserver) | nur intern | |
| + | | 80 TCP | nginx + FusionCMS | intern → Caddy | |
| + | | 3306 TCP | MySQL 8.0 | nur intern | |
| + | |
| + | ## Dateipfade |
| + | |
| + | | Pfad | Inhalt | |
| + | |------|--------| |
| + | | `/opt/azerothcore/bin/` | authserver, worldserver Binaries | |
| + | | `/opt/azerothcore/etc/` | authserver.conf, worldserver.conf | |
| + | | `/opt/azerothcore/logs/` | Server-Logs (SSD, logrotate täglich) | |
| + | | `/opt/azerothcore/data/` | Client-Daten (bind mount, read-only) | |
| + | | `/var/lib/mysql/` | MySQL Daten (SSD) | |
| + | | `/var/www/fusioncms/` | FusionCMS Web-Panel | |
| + | | `/root/acore-credentials.txt` | Credentials (DB-Pass, Admin-Pass) | |
| + | |
| + | **Wichtig:** `/mnt/storage` (externe HDD) ist ausschließlich als read-only bind mount eingebunden. |
| + | Alle schreibenden Dienste (MySQL, Logs) laufen auf lokaler SSD. |
| + | |
| + | ## Credentials (Platzhalter) |
| + | |
| + | ``` |
| + | ACORE_DB_USER : acore |
| + | ACORE_DB_PASS : → /root/acore-credentials.txt |
| + | ADMIN_USER : admin (GM Level 3) |
| + | ADMIN_PASS : → /root/acore-credentials.txt |
| + | FUSIONCMS URL : https://panel.ls-cloud.biz |
| + | ``` |
| + | |
| + | ## Systemd Services |
| + | |
| + | ```bash |
| + | systemctl status acore-auth # Authserver (Port 3724) |
| + | systemctl status acore-world # Worldserver (Port 8085 + SOAP 7878) |
| + | systemctl status mysql # MySQL 8.0 |
| + | systemctl status nginx # nginx + FusionCMS |
| + | ``` |
| + | |
| + | ## WoW Client verbinden |
| + | |
| + | ``` |
| + | SET REALMLIST realm.ls-cloud.biz |
| + | ``` |
| + | → Dann normaler Login-Screen. Realm "lscloud" auswählen. |
| + | |
| + | **Externe DNS-Einträge (Cloudflare):** |
| + | - `realm.ls-cloud.biz` → Proxmox-Host-IP (TCP 3724 via DNAT) |
| + | - `wow.ls-cloud.biz` → Proxmox-Host-IP (TCP 8085 via DNAT) |
| + | - `panel.ls-cloud.biz` → Caddy auf Proxmox-Host → CT119:80 |
| + | |
| + | **Fritz!Box:** Ports 3724 + 8085 müssen auf Proxmox-Host (192.168.178.46) weitergeleitet sein. |
| + | |
| + | ## Admin-Commands (Worldserver-Console oder SOAP) |
| + | |
| + | ``` |
| + | # GM-Level vergeben |
| + | account set gmlevel <user> 3 -1 |
| + | |
| + | # Neuen Account erstellen |
| + | account create <user> <pass> |
| + | |
| + | # Server-Info |
| + | server info |
| + | |
| + | # Online-Spieler |
| + | online list |
| + | ``` |
| + | |
| + | ## SOAP via FusionCMS |
| + | |
| + | FusionCMS schickt GM-Commands über SOAP an `127.0.0.1:7878`. |
| + | Die Verbindung ist in der DB konfiguriert: |
| + | ```sql |
| + | mysql -u root fusioncms -e "SELECT console_username, console_port FROM realms;" |
| + | ``` |
| + | |
| + | ## Update-Prozedur |
| + | |
| + | ```bash |
| + | # 1. In CT119 als root |
| + | cd /root/azerothcore |
| + | |
| + | # 2. Neue Commits holen |
| + | git pull |
| + | |
| + | # 3. Neu kompilieren |
| + | cd build |
| + | cmake .. -DCMAKE_INSTALL_PREFIX=/opt/azerothcore -DCMAKE_C_COMPILER=/usr/bin/clang -DCMAKE_CXX_COMPILER=/usr/bin/clang++ |
| + | make -j$(nproc) && make install |
| + | |
| + | # 4. Services neustarten |
| + | systemctl restart acore-auth acore-world |
| + | |
| + | # DB-Updates werden beim nächsten Worldserver-Start automatisch importiert |
| + | ``` |
| + | |
| + | ## MySQL-Tuning (HDD-Schutz) |
| + | |
| + | Konfiguration in `/etc/mysql/mysql.conf.d/99-acore.cnf`: |
| + | - `expire_logs_days = 3` — Binary Logs automatisch rotieren |
| + | - `general_log = 0` — Query-Log deaktiviert |
| + | - `slow_query_log = 0` — Slow-Log deaktiviert |
| + | - `innodb_buffer_pool_size = 2G` |
| + | |
| + | ## Datenbanken |
| + | |
| + | | DB | Inhalt | |
| + | |----|--------| |
| + | | `acore_auth` | Accounts, Realmliste, GM-Rechte | |
| + | | `acore_characters` | Charakterdaten | |
| + | | `acore_world` | Weltdaten, Quests, NPCs | |
| + | | `fusioncms` | Web-Panel Daten | |