RoE | Wiki

User Tools

Site Tools

Trace:
servers:games:pvpgn-pro

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
servers:games:pvpgn-pro [2016/11/25 12:21] – Sean Rhoneservers:games:pvpgn-pro [2016/11/25 14:09] (current) – Sean Rhone
Line 1: Line 1:
 +====== Information ======
  
 +  * PvPGN-PRO
 +  * Git ((https://github.com/pvpgn/pvpgn-server))
 +  * [[Information:Realm of Espionage]]
 +  * classic.realmofespionage.xyz ((Battle.net))
 +
 +===== Prerequisites =====
 +
 +  * [[distros:fedora_server | Fedora Server]]
 +  * [[servers:mariadb | MariaDB]]
 +
 +===== Notes =====
 +
 +  * Does not support Diablo II patch 1.14d yet
 +  * Notes unfinished
 +
 +====== Create Group and User ======
 +
 +****
 +
 +  sudo groupadd 'pvpgn' && sudo useradd -c 'PvPGN system account' -d '/var/lib/pvpgn' -g 'pvpgn' -m -r 'pvpgn'
 +
 +====== Dependencies ======
 +
 +****
 +
 +  sudo dnf install git cmake gcc-c++ compat-lua-devel
 +
 +====== Firewall ======
 +
 +  * 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
 +
 +====== Download Source ======
 +
 +****
 +
 +  sudo git clone -b 'master' 'https://github.com/pvpgn/pvpgn-server.git' '/srv/pvpgn/src' && sudo chown -R 'pvpgn':'pvpgn' '/srv/pvpgn' && sync
 +
 +====== Database ======
 +
 +  mysql -u root -p
 +
 +  CREATE DATABASE pvpgn;
 +
 +  GRANT ALL PRIVILEGES ON pvpgn.* to 'pvpgn'@'localhost' IDENTIFIED BY 'x';
 +
 +  FLUSH PRIVILEGES;
 +
 +====== Compile ======
 +
 +  * 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
 +
 +====== Settings ======
 +
 +===== bnetd =====
 +
 +  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
 +
 +===== worldserver =====
 +
 +  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
 +
 +====== Create GM Account ======
 +
 +  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)
 +
 +====== Other Settings ======
 +
 +===== Disable Console =====
 +
 +  * 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
 +
 +===== Realm Information =====
 +
 +  * 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;
 +
 +===== Two-Factor Authentication =====
 +
 +  * 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 ((this note came from older notes, no idea where these limitations came from or if they're still applicable TODO: Figure this out))
 +  * Add key to Authenticator app
 +
 +  mysql -u root -p
 +
 +  UPDATE `auth`.`account` SET `token_key` = 'x' WHERE `account`.`id` = 1
 +
 +====== Services ======
 +
 +===== PvPGN =====
 +
 +==== Service ====
 +
 +  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
 +
 +===== Updater =====
 +
 +==== Service ====
 +
 +  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'
 +
 +==== Timer ====
 +
 +  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
 +
 +===== Restarter =====
 +
 +==== Service ====
 +
 +  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'
 +
 +==== Timer ====
 +
 +  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
 +
 +===== Backup =====
 +
 +==== Database Auth ====
 +
 +  sudo -e '/var/lib/mysqlauth/pvpgn' && sudo chmod '600' '/var/lib/mysqlauth/pvpgn'
 +
 +  [mysqldump]
 +  user=pvpgn
 +  password=x
 +
 +==== Service ====
 +
 +  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'
 +
 +==== Timer ====
 +
 +  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
 +
 +====== Backup ======
 +
 +===== Server =====
 +
 +==== Stop Service ====
 +
 +****
 +
 +  sudo systemctl stop 'pvpgn'
 +
 +==== Backup Database ====
 +
 +  mysqldump --defaults-extra-file='/var/lib/mysqlauth/pvpgn' --single-transaction 'pvpgn' -r '~/'pvpgn-manual.sql' && sync
 +
 +===== Client =====
 +
 +==== Transfer File To Client ====
 +
 +****
 +
 +  scp espionage724@192.168.1.154:~/'pvpgn-manual.sql' ~/'Downloads' && sync'
 +
 +====== Restore ======
 +
 +===== Client =====
 +
 +==== Transfer File To Server ====
 +
 +****
 +
 +  scp ~/'Downloads/pvpgn-manual.sql' espionage724@192.168.1.154:~
 +
 +==== Remove File ====
 +
 +****
 +
 +  rm ~/'Downloads/pvpgn-manual.sql' && sync
 +
 +===== Server =====
 +
 +==== Stop Service ====
 +
 +****
 +
 +  sudo systemctl stop 'pvpgn'
 +
 +==== Drop Previous Database ====
 +
 +  mysql -u 'root' -p
 +
 +  DROP DATABASE pvpgn;
 +
 +  FLUSH TABLES;
 +
 +==== Re-create Database ====
 +
 +  mysql -u 'root' -p
 +
 +  CREATE DATABASE pvpgn;
 +
 +==== Restore Database ====
 +
 +****
 +
 +  mysql -u 'root' -p 'pvpgn' < ~/'pvpgn-manual.sql' && sync
 +
 +==== Reapply Permissions ====
 +
 +  mysql -u root -p
 +
 +  GRANT ALL PRIVILEGES ON pvpgn.* to 'pvpgn'@'localhost' IDENTIFIED BY 'x';
 +
 +  FLUSH PRIVILEGES;
 +
 +==== Start Service ====
 +
 +****
 +
 +  sudo systemctl start 'pvpgn'
 +
 +==== Remove Backup ====
 +
 +  * Verify that PvPGN-PRO works before running
 +
 +  rm ~/'pvpgn-manual.sql' && sync