WoW 私服架設：常見問題與疑難排解完整指南

Cannot connect to database

# 檢查 MySQL 服務
systemctl status mariadb

# 確認資料庫存在
mysql -u acore -p -e "SHOW DATABASES;"

# 檢查連線設定
grep LoginDatabaseInfo /opt/wow/server/etc/authserver.conf

Segmentation fault (core dumped)

# 檢查資料檔案完整性
ls -la /opt/wow/server/data/

# 檢查記憶體
free -h

# 增加 swap
fallocate -l 4G /swapfile
mkswap /swapfile
swapon /swapfile

Map file './maps/000.map' does not exist

# 確認資料路徑
vim /opt/wow/server/etc/worldserver.conf
# DataDir = "/opt/wow/server/data"

# 重新下載資料檔
cd /opt/wow/server/data
wget [資料檔網址]
unzip data.zip

Access denied for user 'acore'@'localhost'

-- 重設密碼
ALTER USER 'acore'@'localhost' IDENTIFIED BY 'new_password';

-- 重新授權
GRANT ALL PRIVILEGES ON *.* TO 'acore'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Applying update "xxx.sql" FAILED

# 手動執行更新
mysql -u acore -p acore_world < update.sql

# 清理更新狀態
mysql -u acore -p acore_world -e "DELETE FROM updates WHERE name='xxx.sql';"

# 修復資料表
mysqlcheck -u acore -p --auto-repair --all-databases

# 從備份還原
mysql -u acore -p acore_characters < backup.sql

檢查 Data/enUS/realmlist.wtf
確認 IP 正確

# Linux 防火牆
iptables -I INPUT -p tcp --dport 3724 -j ACCEPT
iptables -I INPUT -p tcp --dport 8085 -j ACCEPT

ping 伺服器IP
telnet 伺服器IP 3724

# 檢查 authserver
ps aux | grep authserver

# 查看日誌
tail -f /opt/wow/server/logs/Auth.log

World server is full

# 編輯 worldserver.conf
PlayerLimit = 100  # 增加上限

# 檢查模組載入
grep PlayerBot /opt/wow/server/logs/worldserver.log

# 確認機器人帳號
mysql -u acore -p acore_auth -e "SELECT * FROM account WHERE username LIKE 'rndbot%';"

# 調整 AI 設定
AiPlayerbot.BotFollowDistance = 100
AiPlayerbot.ReactDelay = 100
AiPlayerbot.IterationsPerTick = 10

# 限制 CPU 使用
nice -n 10 ./worldserver

# 調整更新頻率
# worldserver.conf
MapUpdate.Threads = 2
MapUpdateInterval = 200

# 監控記憶體
watch -n 1 'ps aux | grep worldserver'

# 定期重啟
crontab -e
0 4 * * * /opt/wow/restart_server.sh

# 優化網路設定
Compression = 1
CompressionLevel = 6

# 減少視距
Visibility.Distance.Continents = 60

# 即時監控
tail -f /opt/wow/server/logs/worldserver.log

# 搜尋錯誤
grep ERROR /opt/wow/server/logs/*.log

# 分析崩潰
gdb /opt/wow/server/bin/worldserver core

#!/bin/bash
# auto_restart.sh

check_server() {
    if ! pgrep -x "worldserver" > /dev/null; then
        echo "Server down, restarting..."
        cd /opt/wow/server/bin
        screen -dmS wow-world ./worldserver
    fi
}

while true; do
    check_server
    sleep 60
done

#!/bin/bash
# daily_backup.sh

DATE=$(date +%Y%m%d)
BACKUP_DIR="/backup/wow"

# 備份資料庫
mysqldump -u acore -p acore_auth > $BACKUP_DIR/auth_$DATE.sql
mysqldump -u acore -p acore_characters > $BACKUP_DIR/char_$DATE.sql
mysqldump -u acore -p acore_world > $BACKUP_DIR/world_$DATE.sql

# 保留 7 天
find $BACKUP_DIR -name "*.sql" -mtime +7 -delete

-- 將角色傳送到主城
UPDATE characters SET 
    position_x = -8913.23,
    position_y = 554.633,
    position_z = 93.7944,
    map = 0
WHERE name = '角色名';

-- 清除角色任務
DELETE FROM character_queststatus WHERE guid = 角色GUID;

.instance unbind all player
.instance reset all

.pdump write [檔名] [角色名稱或GUID]
.pdump write MyCharBackup Painbow

pdump write MyCharBackup Painbow

.pdump load [檔名] [帳號名稱] [新角色名] [新GUID]
.pdump load MyCharBackup myaccount

pdump load MyCharBackup myaccount

#!/bin/bash
# backup_characters.sh

BACKUP_DIR="/opt/wow/character_backups"
DATE=$(date +%Y%m%d_%H%M%S)
CHARACTERS=("Painbow" "MyHealer" "MyTank")

mkdir -p $BACKUP_DIR

for char in "${CHARACTERS[@]}"; do
    echo "Backing up $char..."
    cd /opt/wow/azerothcore-wotlk/env/dist/bin
    ./worldserver --backup "$char" "$BACKUP_DIR/${char}_$DATE.pbd"
done

# 保留最近 30 天的備份
find $BACKUP_DIR -name "*.pbd" -mtime +30 -delete

echo "Character backup completed!"

-- 查看所有角色
SELECT 
    c.guid,
    c.name,
    c.level,
    c.race,
    c.class,
    a.username as account
FROM characters c
JOIN account a ON c.account = a.id
ORDER BY c.level DESC;

-- 轉移角色到其他帳號
UPDATE characters 
SET account = (SELECT id FROM account WHERE username = 'newaccount')
WHERE name = 'CharacterName';