MangosZero Install - Debian
This howto will be on how to get MangosZero running on Debian in VirtualBox as Windows 7 64 Bit as the host
Installing VirtualBox
This part should be self-explanatory, I may recap on certain settings like BIOS and other default settings
Starting up Virtual box and Installing the base operating system
Create a new virtual machine, I'm going with a 64-bit install with Debian 7.2.0 ISOs. 512MB ram, create a 20GB dynamic partition. After the new virtual machine has been set up, give the server 12MB of video ram which is more than enough to run a server.
Start the server, and select your settings as you wish.
When installing packages, only install what you need because we want this server to be as trim as possible. No Desktop, XWindow or gui, just a straight server.
On the Software Selection screen, Unselect Everything but the standard system utilities.
Install the Grub boot loader
Setting up Build Environment for Mangos
Login as root, we need to install a few things first. After looking at top, I only have 58 processes total running and about 56k of RAM used. not bad at all. We want the OS to be as trim as possible, that is one of the goals for this article.
As root, type in:
apt-get install sudo
After install of sudo, edit the /etc/sudoers file and add your username
edit /etc/sudoers Add under 'User Privilege Section' underneath root username ALL=(ALL:ALL) ALL Exit and save
Now type in exit and go back to your username. You should have sudo rights now.
Type in these commands to establish a build environment
sudo apt-get install -y autoconf automake clang cmake gcc g++ libtool make patch sudo apt-get install -y cmake-curses-gui git-core
I had an issue with these commands not being found so I had to add the default repos in /etc/apt/sources.list
deb http://http.debian.net/debian wheezy main deb-src http://http.debian.net/debian wheezy main deb http://http.debian.net/debian wheezy-updates main deb-src http://http.debian.net/debian wheezy-updates main deb http://security.debian.org/ wheezy/updates main deb-src http://security.debian.org/ wheezy/updates main
Installing the Development headers
sudo apt-get install -y libace-dev libbz2-dev libmysqlclient-dev libncurses5-dev libreadline-dev libssl-dev zlib1g-dev
Installing the Database Server (MySQL)
sudo apt-get install -y libace-dev libbz2-dev libmysqlclient-dev libncurses5-dev libreadline-dev libssl-dev zlib1g-dev
Set the root password for the MySQL server
Creating and Setting Permissions for MySQL User
mysql -u root -p CREATE USER 'mangos'@'localhost' IDENTIFIED BY 'password';
for Password, use whatever you want and for user mangos, use whatever you want.
GRANT ALL PRIVILEGES ON `mangos\_%` . * TO 'mangos'@'localhost'; GRANT USAGE ON * . * TO 'mangos'@'localhost' IDENTIFIED BY 'password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
again for username and password, use whatever you want, just ensure they match
Creating the Mangos Databases
mysql -u root -p CREATE DATABASE `mZero_characters` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE DATABASE `mZero_realm` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE DATABASE `mZero_scripts` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE DATABASE `mZero_world` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; FLUSH PRIVILEGES ;
Downloading the Mangos-Zero Source from github and compiling
While you are in user mode and not root, create the mangos source directory
cd ~ mkdir mangos-source cd mangos-source git clone --recursive -b Rel20 https://github.com/mangoszero/server git clone --recursive -b Rel20 https://github.com/mangoszero/database
Be sure to use the --recursive so git will pull in everything, without this your compile will fail
Compiling Mangos
create the directories needed for build
sudo mkdir -p /opt/mangos-zero/ sudo mkdir -p /opt/mangos-zero/logs/mangos-zero/ sudo mkdir -p /opt/mangos-zero/share/mangos-zero/
cd server mkdir _build cd _build cmake -DCMAKE_INSTALL_PREFIX=/opt/mangos-zero -DCMAKE_BUILD_TYPE=Debug -DWITH_MOD_LUA=0 -DWITH_MOD_SCRIPTDEV2=1 ..
Now in the ~/mangos-source/server/_build directory
sudo make
After a successful compile run this.
sudo make install
Configuration of Mangos
cd /opt/mangos-zero/etc sudo cp ahbot.conf.dist ahbot.conf sudo cp mangosd.conf.dist mangosd.conf sudo cp realmd.conf.dist realmd.conf
sudo nano realmd.conf
The LoginDatabaseInfo Variable looks like this
LoginDatabaseInfo = "127.0.0.1;3306;mangos;mangos;realmd"
Change to
LoginDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_realm"
then for mangosd.conf
sudo nano mangosd.conf
The lines that need to be changed are:
LoginDatabaseInfo = "127.0.0.1;3306;mangos;mangos;realmd" WorldDatabaseInfo = "127.0.0.1;3306;mangos;mangos;mangos" CharacterDatabaseInfo = "127.0.0.1;3306;mangos;mangos;characters" ScriptDev2DatabaseInfo = "127.0.0.1;3306;mangos;mangos;mangos"
These lines should be changed to:
LoginDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_realm" WorldDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_world" CharacterDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_characters" ScriptDev2DatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_scripts"
Inserting Database Information
cd ~/mangos-source/server/sql mysql -u root -p mZero_realmd < realmd.sql mysql -u root -p mZero_characters < characters.sql mysql -u root -p mZero_mangos < mangos.sql cd ~/mangos-source/server/sql/scripts/ mysql -u root -p scripts < scriptdev2_create_structure_mysql.sql mysql -u root -p scripts < scriptdev2_script_full.sql
Inserting Table Information and Full DB
cd ~/mangos-source/database/_tools bash make_full_db.sh mysql -u root -p mZero_world < full_db.sql
Running the Server
Realmd (Realm Server)
go to /opt/mangos-zero/bin and run the realmd server
cd /opt/mangos-zero/bin sudo ./realmd
If after running realmd and you get and error
cd ~/mangos-source/server/sql/updates mysql -u root -p mZero_realm < update_the_SQL_file_it_was_screaming_for.sql
You should get realmd listening for connections at this time.