Differences

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

--- servers:linux:games:mangos_zero_vanilla_localhost [2025/10/18 22:07] – 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 = ".;3306;realmd0;x;realmd0"
+LoginDatabaseInfo = ".;../../mariadb/mariadb.sock;realmd0;x;realmd0"
 LogsDir = ""
@@ 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
-DataDir = "../server"
+DataDir = "."
 LogsDir = ""
-LoginDatabaseInfo = ".;3306;realmd0;x;realmd0"
+LoginDatabaseInfo = ".;../../mariadb/mariadb.sock;realmd0;x;realmd0"
-WorldDatabaseInfo = ".;3306;mangos0;x;mangos0"
+WorldDatabaseInfo = ".;../../mariadb/mariadb.sock;mangos0;x;mangos0"
-CharacterDatabaseInfo = ".;3306;character0;x;character0"
+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 756: / Line 748: @@
   * 3 Command Prompt windows
+  * ''Ctrl + \'' to quit MariaDB
-  "%ProgramFiles%\MariaDB 12.1\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.1\data\my.ini"
+  '/usr/sbin/mariadbd' --datadir=$HOME/'Projects/MaNGOS-Zero/mariadb/database' --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock'
+  cd ~/'Projects/MaNGOS-Zero/run/bin' && ~/'Projects/MaNGOS-Zero/run/bin/realmd' -c ~/'Projects/MaNGOS-Zero/conf/realmd-localhost.conf'
+  cd ~/'Projects/MaNGOS-Zero/run/bin' && ~/'Projects/MaNGOS-Zero/run/bin/mangosd' -c ~/'Projects/MaNGOS-Zero/conf/mangosd-localhost.conf'
+==== One-liner ====
-  CLS && SET "OPENSSL_MODULES=%ProgramFiles%\OpenSSL-Win64\bin" && CD "%UserProfile%\Projects\MaNGOS-Zero\server" && "%UserProfile%\Projects\MaNGOS-Zero\server\realmd.exe" -c "%UserProfile%\Projects\MaNGOS-Zero\conf\realmd-localhost.conf"
+  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'"
-  CLS && SET "OPENSSL_MODULES=%ProgramFiles%\OpenSSL-Win64\bin" && CD "%UserProfile%\Projects\MaNGOS-Zero\server" && "%UserProfile%\Projects\MaNGOS-Zero\server\mangosd.exe" -c "%UserProfile%\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 785: / Line 784: @@
 ====== Extras ======
+  * :?: TODO: Quotes weren't accepted for ''.tele'' on Linux
 ===== Items =====
@@ Line 814: / 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 =====