Differences

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

--- servers:linux:games:mangos_zero_vanilla_localhost [2025/10/19 00:29] – [Servers] Sean Rhone
+++ servers:linux:games:mangos_zero_vanilla_localhost [2025/10/21 07:59] (current) – [One-liner] Sean Rhone
@@ Line 64: / Line 64: @@
 ==== Set-up ====
-  * Enter current password for root: ''(enter)''
+  * Separate Terminal window
-  * Switch to unix_socket authentication: ''Y''
+  * Change the root password: ''N''
-  * :!: Change the root password: ''N''
-  * Remove anonymous users: ''Y''
-  * Disallow root login remotely: ''Y''
-  * Remove test database and access to it: ''Y''
-  * Reload privilege tables now: ''Y''
   mariadb-secure-installation --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock' --user=$USER
-  mariadb-admin 'shutdown' --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock' --user=$USER
 ====== Databases ======
 ===== Connect =====
-  * 2 Terminal windows
   '/usr/sbin/mariadbd' --datadir=$HOME/'Projects/MaNGOS-Zero/mariadb/database' --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock'
@@ Line 173: / Line 164: @@
   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'
@@ Line 204: / Line 195: @@
 <code>
 [RealmdConf]
-ConfVersion=2025101801
+ConfVersion=2025102101
 LoginDatabaseInfo = ".;../../mariadb/mariadb.sock;realmd0;x;realmd0"
@@ Line 223: / Line 214: @@
 UseProcessors = 0
-ProcessPriority = 1
+ProcessPriority = 0
 WaitAtStartupError = 0
 RealmsStateUpdateDelay = 20
-WrongPass.MaxCount = 3
+WrongPass.MaxCount = 5
 WrongPass.BanTime = 0
 WrongPass.BanType = 0
@@ Line 244: / Line 235: @@
 <code>
 [MangosdConf]
-ConfVersion=2025101801
+ConfVersion=2025102101
 RealmID = 1
@@ Line 254: / Line 245: @@
 CharacterDatabaseInfo = ".;../../mariadb/mariadb.sock;character0;x;character0"
-LoginDatabaseConnections = 3
+LoginDatabaseConnections = 1
-WorldDatabaseConnections = 3
+WorldDatabaseConnections = 1
-CharacterDatabaseConnections = 3
+CharacterDatabaseConnections = 1
 MaxPingTime = 5
 WorldServerPort = 8085
 BindIP = "0.0.0.0"
 UseProcessors = 0
-ProcessPriority = 1
+ProcessPriority = 0
 Compression = 1
 PlayerLimit = 3
@@ Line 393: / Line 384: @@
 PetUnsummonAtMount = 0
 Event.Announce = 0
-BeepAtStart = 1
+BeepAtStart = 0
 ShowProgressBars = 0
 WaitAtStartupError = 0
@@ Line 630: / Line 621: @@
   * 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"
@@ Line 764: / Line 756: @@
   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'"
+==== 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' -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 =====
@@ Line 788: / Line 784: @@
 ====== Extras ======
+  * :?: TODO: Quotes weren't accepted for ''.tele'' on Linux
 ===== Items =====
@@ Line 817: / Line 815: @@
   '/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 =====