| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| servers:linux:games:mangos_zero_vanilla_localhost [2025/10/19 22:20] – Sean Rhone | servers:linux:games:mangos_zero_vanilla_localhost [2025/10/21 07:59] (current) – [One-liner] Sean Rhone |
|---|
| mariadb --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock' --user=$USER 'mangos0' < ~/'Projects/MaNGOS-Zero/database-src/World/Setup/mangosdLoadDB.sql' | mariadb --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock' --user=$USER 'mangos0' < ~/'Projects/MaNGOS-Zero/database-src/World/Setup/mangosdLoadDB.sql' |
| |
| rm -f ~/'Projects/MaNGOS-Zero/run/bin/world.sql' && cat ~/'Projects/MaNGOS-Zero/database-src/World/Setup/FullDB/'*'.sql' > ~/'Projects/MaNGOS-Zero/run/bin/world.sql' | rm -f ~/'Projects/MaNGOS-Zero/run/bin/world.sql' && mkdir -p ~/'Projects/MaNGOS-Zero/run/bin' && cat ~/'Projects/MaNGOS-Zero/database-src/World/Setup/FullDB/'*'.sql' > ~/'Projects/MaNGOS-Zero/run/bin/world.sql' |
| |
| mariadb --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock' --user=$USER 'mangos0' < ~/'Projects/MaNGOS-Zero/run/bin/world.sql' && rm -f ~/'Projects/MaNGOS-Zero/run/bin/world.sql' | mariadb --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock' --user=$USER 'mangos0' < ~/'Projects/MaNGOS-Zero/run/bin/world.sql' && rm -f ~/'Projects/MaNGOS-Zero/run/bin/world.sql' |
| * [[https://github.com/TrinityCore/TrinityCore/blob/3.3.5/src/server/authserver/authserver.conf.dist|Upstream authserver.conf.dist]] ([[https://raw.githubusercontent.com/TrinityCore/TrinityCore/3.3.5/src/server/authserver/authserver.conf.dist|raw]]) | * [[https://github.com/TrinityCore/TrinityCore/blob/3.3.5/src/server/authserver/authserver.conf.dist|Upstream authserver.conf.dist]] ([[https://raw.githubusercontent.com/TrinityCore/TrinityCore/3.3.5/src/server/authserver/authserver.conf.dist|raw]]) |
| * https://github.com/mangos/realmd/blob/master/realmd.conf.dist.in | * https://github.com/mangos/realmd/blob/master/realmd.conf.dist.in |
| * :!: TODO: ''127.0.0.1'' got IP banned after incorrect attempts (''.unban ip 127.0.0.1''; unban account didn't work) | |
| |
| mkdir -p ~/'Projects/MaNGOS-Zero/conf' && nano ~/'Projects/MaNGOS-Zero/conf/realmd-localhost.conf' | mkdir -p ~/'Projects/MaNGOS-Zero/conf' && nano ~/'Projects/MaNGOS-Zero/conf/realmd-localhost.conf' |
| <code> | <code> |
| [RealmdConf] | [RealmdConf] |
| ConfVersion=2025101801 | ConfVersion=2025102101 |
| |
| LoginDatabaseInfo = ".;../../mariadb/mariadb.sock;realmd0;x;realmd0" | LoginDatabaseInfo = ".;../../mariadb/mariadb.sock;realmd0;x;realmd0" |
| |
| UseProcessors = 0 | UseProcessors = 0 |
| ProcessPriority = 1 | ProcessPriority = 0 |
| WaitAtStartupError = 0 | WaitAtStartupError = 0 |
| RealmsStateUpdateDelay = 20 | RealmsStateUpdateDelay = 20 |
| |
| WrongPass.MaxCount = 3 | WrongPass.MaxCount = 5 |
| WrongPass.BanTime = 0 | WrongPass.BanTime = 0 |
| WrongPass.BanType = 0 | WrongPass.BanType = 0 |
| <code> | <code> |
| [MangosdConf] | [MangosdConf] |
| ConfVersion=2025101801 | ConfVersion=2025102101 |
| |
| RealmID = 1 | RealmID = 1 |
| CharacterDatabaseInfo = ".;../../mariadb/mariadb.sock;character0;x;character0" | CharacterDatabaseInfo = ".;../../mariadb/mariadb.sock;character0;x;character0" |
| |
| LoginDatabaseConnections = 3 | LoginDatabaseConnections = 1 |
| WorldDatabaseConnections = 3 | WorldDatabaseConnections = 1 |
| CharacterDatabaseConnections = 3 | CharacterDatabaseConnections = 1 |
| MaxPingTime = 5 | MaxPingTime = 5 |
| WorldServerPort = 8085 | WorldServerPort = 8085 |
| BindIP = "0.0.0.0" | BindIP = "0.0.0.0" |
| UseProcessors = 0 | UseProcessors = 0 |
| ProcessPriority = 1 | ProcessPriority = 0 |
| Compression = 1 | Compression = 1 |
| PlayerLimit = 3 | PlayerLimit = 3 |
| PetUnsummonAtMount = 0 | PetUnsummonAtMount = 0 |
| Event.Announce = 0 | Event.Announce = 0 |
| BeepAtStart = 1 | BeepAtStart = 0 |
| ShowProgressBars = 0 | ShowProgressBars = 0 |
| WaitAtStartupError = 0 | WaitAtStartupError = 0 |
| |
| * Shutdown order: ''mangosd'' -> ''realmd'' -> MariaDB | * Shutdown order: ''mangosd'' -> ''realmd'' -> MariaDB |
| | * TODO: Terminal window titles need named something recognizable at-glance |
| |
| MKDIR "%UserProfile%\Projects\MaNGOS-Zero\scripts" & "notepad.exe" "%UserProfile%\Projects\MaNGOS-Zero\scripts\localhost-server-start.bat" | MKDIR "%UserProfile%\Projects\MaNGOS-Zero\scripts" & "notepad.exe" "%UserProfile%\Projects\MaNGOS-Zero\scripts\localhost-server-start.bat" |
| ==== One-liner ==== | ==== One-liner ==== |
| |
| **** | kgx -T 'MariaDB' -e '/usr/sbin/mariadbd' --datadir=$HOME/'Projects/MaNGOS-Zero/mariadb/database' --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock' && sleep '2' && kgx -T 'Realm' -- '/usr/bin/bash' -c "cd ~/'Projects/MaNGOS-Zero/run/bin' && ~/'Projects/MaNGOS-Zero/run/bin/realmd' -c ~/'Projects/MaNGOS-Zero/conf/realmd-localhost.conf'" && kgx -T 'World' -- '/usr/bin/bash' -c "cd ~/'Projects/MaNGOS-Zero/run/bin' && ~/'Projects/MaNGOS-Zero/run/bin/mangosd' -c ~/'Projects/MaNGOS-Zero/conf/mangosd-localhost.conf'" |
| |
| xfce4-terminal -T 'MariaDB Server' -x '/usr/sbin/mariadbd' --datadir=$HOME/'Projects/MaNGOS-Zero/mariadb/database' --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock' && sleep '2' && xfce4-terminal -T 'realmd' -x '/usr/bin/bash' -c "cd ~/'Projects/MaNGOS-Zero/run/bin' && ~/'Projects/MaNGOS-Zero/run/bin/realmd' -c ~/'Projects/MaNGOS-Zero/conf/realmd-localhost.conf'" && xfce4-terminal -T 'mangosd' -x '/usr/bin/bash' -c "cd ~/'Projects/MaNGOS-Zero/run/bin' && ~/'Projects/MaNGOS-Zero/run/bin/mangosd' -c ~/'Projects/MaNGOS-Zero/conf/mangosd-localhost.conf'" | xfce4-terminal -T 'MariaDB' -x '/usr/sbin/mariadbd' --datadir=$HOME/'Projects/MaNGOS-Zero/mariadb/database' --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock' && sleep '2' && xfce4-terminal -T 'Realm' -x '/usr/bin/bash' -c "cd ~/'Projects/MaNGOS-Zero/run/bin' && ~/'Projects/MaNGOS-Zero/run/bin/realmd' -c ~/'Projects/MaNGOS-Zero/conf/realmd-localhost.conf'" && xfce4-terminal -T 'World' -x '/usr/bin/bash' -c "cd ~/'Projects/MaNGOS-Zero/run/bin' && ~/'Projects/MaNGOS-Zero/run/bin/mangosd' -c ~/'Projects/MaNGOS-Zero/conf/mangosd-localhost.conf'" |
| |
| ===== Create Account ===== | ===== Create Account ===== |
| '/usr/sbin/mariadbd' --datadir=$HOME/'Projects/MaNGOS-Zero/mariadb/database' --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock' | '/usr/sbin/mariadbd' --datadir=$HOME/'Projects/MaNGOS-Zero/mariadb/database' --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock' |
| |
| cd ~/'Downloads' && mariadb-dump --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock' --user=$USER --opt -r '$(date +%Y-%m-%d-%s)'-WoW-localhost-character0.sql' 'character0' | cd ~/'Downloads' && mariadb-dump --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock' --user=$USER --opt -r $(date +%Y-%m-%d-%s)'-WoW-localhost-character0.sql' 'character0' |
| |
| cd ~/'Downloads' && mariadb-dump --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock' --user=$USER --opt -r '$(date +%Y-%m-%d-%s)'-WoW-localhost-realmd0.sql' 'realmd0' | cd ~/'Downloads' && mariadb-dump --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock' --user=$USER --opt -r $(date +%Y-%m-%d-%s)'-WoW-localhost-realmd0.sql' 'realmd0' |
| |
| ===== Restore ===== | ===== Restore ===== |