Differences

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

--- servers:linux:games:mangos_zero_vanilla_localhost [2025/10/18 02:49] – Sean Rhone
+++ servers:linux:games:mangos_zero_vanilla_localhost [2025/10/18 21:25] (current) – [Settings] Sean Rhone
@@ Line 9: / Line 9: @@
   * [[linux:distros:opensuse_tumbleweed_xfce|openSUSE Tumbleweed (Xfce)]]
-  * [[servers:linux:mariadb|MariaDB]]
   * [[games:linux:wine:world_of_warcraft_1.12.1|World of Warcraft 1.12.1]]
@@ Line 16: / Line 15: @@
 ****
-  sudo zypper install git-core cmake clang libmariadb-devel
+  sudo zypper install git-core cmake clang mariadb libmariadb-devel
 ====== Download Source ======
@@ Line 23: / Line 22: @@
   cd ~ && mkdir -p ~/'Projects' && rm -Rf ~/'Projects/MaNGOS-Zero/src' && git clone --branch 'master' --depth '1' --recurse-submodules 'https://github.com/mangoszero/server.git' ~/'Projects/MaNGOS-Zero/src'
+====== Database ======
+===== Settings =====
+  rm -Rf ~/'Projects/MaNGOS-Zero/mariadb/database' && mkdir -p ~/'Projects/MaNGOS-Zero/mariadb/database' && nano ~/'Projects/MaNGOS-Zero/mariadb/custom.cnf'
+<code>
+[client]
+default-character-set = 'utf8mb4'
+[mariadb-client]
+default-character-set = 'utf8mb4'
+[mariadbd]
+character-set-client-handshake = 'FALSE'
+character-set-server = 'utf8mb4'
+collation-server = 'utf8mb4_unicode_ci'
+init-connect='SET NAMES utf8mb4'
+expire_logs_days = '7'
+max_binlog_size = '100M'
+skip-networking = 'On'
+table_definition_cache = '1400'
+# End</code>
+===== Initialize =====
+****
+  mariadb-install-db --datadir=$HOME/'Projects/MaNGOS-Zero/mariadb/database' --defaults-file=$HOME/'Projects/MaNGOS-Zero/mariadb/custom.cnf'
+===== Initial Setup =====
+==== Server Start ====
+****
+  '/usr/sbin/mariadbd' --datadir=$HOME/'Projects/MaNGOS-Zero/mariadb/database' --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock'
+==== Set-up ====
+  * Enter current password for root: ''(enter)''
+  * Switch to unix_socket authentication: ''Y''
+  * :!: 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 ======
@@ Line 28: / Line 80: @@
 ===== Connect =====
-  sudo systemctl start 'mariadb'
+  * 2 Terminal windows
+  '/usr/sbin/mariadbd' --datadir=$HOME/'Projects/MaNGOS-Zero/mariadb/database' --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock'
-  sudo mariadb
+  mariadb --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock' --user=$USER
 ===== Databases =====
@@ Line 84: / Line 138: @@
 ===== MMaps =====
-  * :!: ~10 minutes i5-8400H ((2025/10/08: ''746 seconds''))
+  * :!: ~10 minutes i5-8400H ((2025/10/18: ''568 seconds''))
   * '' --threads $(nproc)''
@@ Line 93: / Line 147: @@
 ****
-  RMDIR /S /Q "%UserProfile%\Projects\MaNGOS-Zero\server\Buildings"
+  rm -Rf ~/'Projects/MaNGOS-Zero/run/bin/Buildings'
 ====== World Database ======
@@ Line 103: / Line 157: @@
   * https://github.com/mangosone/database/commits/master/
-  "%ProgramFiles%\Git\bin\git.exe" clone --branch "master" --depth "1" --recurse-submodules "https://github.com/mangoszero/database.git" "%UserProfile%\Projects\MaNGOS-Zero\database"
+  cd ~ && rm -Rf ~/'Projects/MaNGOS-Zero/database-src' && git clone --branch 'master' --depth '1' --recurse-submodules 'https://github.com/mangoszero/database.git' ~/'Projects/MaNGOS-Zero/database-src'
 ==== Base Imports ====
@@ Line 774: / Line 828: @@
 ===== Restore =====
-  * [[#databases|Initial set-up]]
+****
-  "%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'
 ==== realmd ====
-  "%ProgramFiles%\MariaDB 12.1\bin\mariadb.exe" -u "root" -p --execute="CREATE DATABASE realmd"
+  mariadb --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock' --user=$USER --execute='CREATE DATABASE realmd0'
-  "%ProgramFiles%\MariaDB 12.1\bin\mariadb.exe" -u "root" -p "realmd" < "%UserProfile%\Downloads\localhost-realmd.sql"
+  mariadb --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock' --user=$USER 'realmd0' < ~/'Downloads/localhost-realmd0.sql'
 ==== character0 ====
-  "%ProgramFiles%\MariaDB 12.1\bin\mariadb.exe" -u "root" -p --execute="CREATE DATABASE character0"
+  mariadb --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock' --user=$USER --execute='CREATE DATABASE character0'
-  "%ProgramFiles%\MariaDB 12.1\bin\mariadb.exe" -u "root" -p "character0" < "%UserProfile%\Downloads\localhost-character0.sql"
+  mariadb --socket=$HOME/'Projects/MaNGOS-Zero/mariadb/mariadb.sock' --user=$USER 'character0' < ~/'Downloads/localhost-character0.sql'
 ====== Quick Commands ======
@@ Line 796: / Line 850: @@
 ****
-  "explorer.exe" "%UserProfile%\Projects\MaNGOS-Zero\server"
+  gio open ~/'Projects/MaNGOS-Zero/run/bin'
 ====== TODOs ======