• PvPGN-PRO
• Git ¹⁾
• Realm of Espionage
• classic.realmofespionage.xyz ²⁾

• Fedora Server
• MariaDB

• Does not support Diablo II patch 1.14d yet
• Notes unfinished

sudo groupadd 'pvpgn' && sudo useradd -c 'PvPGN system account' -d '/var/lib/pvpgn' -g 'pvpgn' -m -r 'pvpgn'

sudo dnf install git cmake gcc-c++ compat-lua-devel

• 6112/tcp is ?
• 6200/tcp is ?

sudo firewall-cmd --add-port='6112'/'tcp' --permanent && sudo firewall-cmd --add-port='6200'/'tcp' --permanent && sudo firewall-cmd --reload

sudo git clone -b 'master' 'https://github.com/pvpgn/pvpgn-server.git' '/srv/pvpgn/src' && sudo chown -R 'pvpgn':'pvpgn' '/srv/pvpgn' && sync

mysql -u root -p

CREATE DATABASE pvpgn;

GRANT ALL PRIVILEGES ON pvpgn.* to 'pvpgn'@'localhost' IDENTIFIED BY 'x';

FLUSH PRIVILEGES;

• The sed command solves https://github.com/pvpgn/pvpgn-server/issues/265

sudo su 'pvpgn' -s '/usr/bin/bash'

sed -i 's#'{SHARE_INSTALL_PREFIX}/man'#'{CMAKE_INSTALL_PREFIX}/man'#g' '/srv/pvpgn/src/cmake/Modules/DefineInstallationPaths.cmake'

rm -Rf '/srv/pvpgn/build' '/srv/pvpgn/run' && mkdir -p '/srv/pvpgn/build' '/srv/pvpgn/run' && cd '/srv/pvpgn/build' && cmake '/srv/pvpgn/src' -DCMAKE_INSTALL_PREFIX='/srv/pvpgn/run' -DWITH_MYSQL='1' -DWITH_LUA='1' -DCMAKE_CXX_FLAGS='-O3 -pipe -march=native' -DCMAKE_C_FLAGS='-O3 -pipe -march=native' && sync && make -j3 install && sync

sudo su 'pvpgn' -s '/usr/bin/bash'

cp '/srv/pvpgn/run/etc/pvpgn/bnetd.conf' '/srv/pvpgn/run/etc/pvpgn/bnetd-live.conf'

nano '/srv/pvpgn/run/etc/pvpgn/bnetd-live.conf'

storage_path = "sql:mode=mysql;host=localhost;name=pvpgn;user=pvpgn;pass=x;default=0;prefix=pvpgn_"

kick_old_login = false
hide_addr = true
passfail_count = 5

sync_on_logoff = true

location = "Pennsylvania"
description = "Realm of Espionage PvPGN Server"
url = "https://realmofespionage.xyz"
contact_name = "Espionage724"
contact_email = "espionage724@x.x"

servername = "RoE | PvPGN"
use_keepalive = false

sudo su 'trinity' -s '/usr/bin/bash'

cp '/srv/trinity/run/etc/worldserver.conf.dist' '/srv/trinity/run/etc/worldserver.conf'

nano '/srv/trinity/run/etc/worldserver.conf'

TODO

sudo su 'trinity' -s '/usr/bin/bash'

cd '/srv/trinity/run/bin' && '/srv/trinity/run/bin/worldserver'

account create Espionage724 x

account set gmlevel Espionage724 3 -1

server shutdown (TODO: Fix this; I'm pretty sure there's more to this command)

• To be done after creating the initial GM account
• Future console use should be done over telnet
• If worldserver is started as a systemd service, the console being enabled will cause logging spam

sudo su 'trinity' -s '/usr/bin/bash'

nano '/srv/trinity/run/etc/worldserver.conf'

Console.Enable = 0

• To be done after databases are initialized
• Applies to first realm

mysql -u root -p

UPDATE `auth`.`realmlist` SET `name` = 'RoE (WotLK)', `address` = 'wow.realmofespionage.xyz' WHERE `realmlist`.`id` = 1;

• To be done after databases are initialized
• Applies to first account
• token_key must not exceed 16 characters and cannot contain an 8 or a 9 ³⁾
• Add key to Authenticator app

mysql -u root -p

UPDATE `auth`.`account` SET `token_key` = 'x' WHERE `account`.`id` = 1

sudo -e '/etc/systemd/system/pvpgn.service' && sudo systemctl daemon-reload && sudo systemctl enable 'pvpgn' --now && sudo systemctl status 'pvpgn' -l

[Unit]
Description=PvPGN
Wants=network-online.target
After=network-online.target mariadb.service

[Service]
Type=simple
User=pvpgn
Group=pvpgn
WorkingDirectory=/srv/pvpgn/run/bin
ExecStart='/srv/trinity/run/bin/authserver' -c '/srv/trinity/run/etc/authserver.conf'
Restart=always
RestartSec=5

[Install]
WantedBy=multi-user.target

sudo -e '/etc/systemd/system/pvpgn-up.service'

[Service]
User=pvpgn
Group=pvpgn
Type=oneshot
WorkingDirectory=/srv/pvpgn/build
ExecStart='/usr/bin/git' -C '/srv/pvpgn/src' pull origin 'master'
ExecStart='/usr/bin/sed' -i 's#'{SHARE_INSTALL_PREFIX}/man'#'{CMAKE_INSTALL_PREFIX}/man'#g' '/srv/pvpgn/src/cmake/Modules/DefineInstallationPaths.cmake'
ExecStart='/usr/bin/cmake' '/srv/pvpgn/src' -DCMAKE_INSTALL_PREFIX='/srv/pvpgn/run' -DWITH_MYSQL='1' -DWITH_LUA='1' -DCMAKE_CXX_FLAGS='-O3 -pipe -march=native' -DCMAKE_C_FLAGS='-O3 -pipe -march=native'
ExecStart='/usr/bin/make' -j2 install
ExecStart='/usr/bin/sync'

sudo -e '/etc/systemd/system/pvpgn-up.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'pvpgn-up.timer' --now && sudo systemctl start 'pvpgn-up' && sudo systemctl status 'pvpgn-up' -l

[Unit]
Description=PvPGN Git Updater and Compiler
Wants=network-online.target
After=network-online.target

[Timer]
OnCalendar=*-*-* 01:35:00
Persistent=true

[Install]
WantedBy=timers.target

sudo -e '/etc/systemd/system/pvpgn-re.service'

[Service]
Type=oneshot
ExecStart='/usr/bin/systemctl' stop 'pvpgn'
ExecStart='/usr/bin/sync'
ExecStart='/usr/bin/systemctl' start 'pvpgn'

sudo -e '/etc/systemd/system/pvpgn-re.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'pvpgn-re.timer' --now && sudo systemctl start 'pvpgn-re' && sudo systemctl status 'pvpgn-re' -l

[Unit]
Description=PvPGN Restarter
Wants=network-online.target
After=network-online.target

[Timer]
OnCalendar=*-*-* 02:05:00
Persistent=true

[Install]
WantedBy=timers.target

sudo -e '/var/lib/mysqlauth/pvpgn' && sudo chmod '600' '/var/lib/mysqlauth/pvpgn'

[mysqldump]
user=pvpgn
password=x

mkdir -p ~/'backups' && sudo mkdir -p '/var/lib/mysqltmp' && sudo -e '/etc/systemd/system/pvpgn-b.service' && sudo sed -i 's/'CHANGEME'/'$USER'/g' '/etc/systemd/system/pvpgn-b.service'

[Service]
Type=oneshot
WorkingDirectory=/var/lib/mysqltmp
ExecStart='/usr/bin/mysqldump' --defaults-extra-file='/var/lib/mysqlauth/pvpgn' --single-transaction 'pvpgn' -r '/var/lib/mysqltmp/pvpgn.sql'
ExecStart='/usr/bin/gzip' -f '/var/lib/mysqltmp/pvpgn.sql'
ExecStart='/usr/bin/bash' -c '"/usr/bin/mv" "/var/lib/mysqltmp/pvpgn.sql.gz" "/home/CHANGEME/backups/pvpgn-"$$(date +%%Y-%%m-%%d)".sql.gz"'
ExecStart='/usr/bin/sync'

sudo -e '/etc/systemd/system/pvpgn-b.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'pvpgn-b.timer' --now && sudo systemctl start 'pvpgn-b' && sudo systemctl status 'pvpgn-b' -l

[Unit]
Description=PvPGN Database Backup
After=mariadb.service

[Timer]
OnCalendar=*-*-* 02:10:00
Persistent=true

[Install]
WantedBy=timers.target

sudo systemctl stop 'pvpgn'

mysqldump --defaults-extra-file='/var/lib/mysqlauth/pvpgn' --single-transaction 'pvpgn' -r '~/'pvpgn-manual.sql' && sync

scp espionage724@192.168.1.154:~/'pvpgn-manual.sql' ~/'Downloads' && sync'

scp ~/'Downloads/pvpgn-manual.sql' espionage724@192.168.1.154:~

rm ~/'Downloads/pvpgn-manual.sql' && sync

sudo systemctl stop 'pvpgn'

mysql -u 'root' -p

DROP DATABASE pvpgn;

FLUSH TABLES;

mysql -u 'root' -p

CREATE DATABASE pvpgn;

mysql -u 'root' -p 'pvpgn' < ~/'pvpgn-manual.sql' && sync

mysql -u root -p

GRANT ALL PRIVILEGES ON pvpgn.* to 'pvpgn'@'localhost' IDENTIFIED BY 'x';

FLUSH PRIVILEGES;

sudo systemctl start 'pvpgn'

• Verify that PvPGN-PRO works before running

rm ~/'pvpgn-manual.sql' && sync