Elysium Core 1.12 Repack - Including MMaps and Optional Vendors

[dmicahd]

I need help...I've started the files in the correct order MySQL.bat -> realmd -> Mangos
I've tried placing MaNGOS in the C: Drive.
Set realmlist to 127.0.0.1, able to log in and see realm selection but clicking okay just returns to realm selection again

Is there something I'm missing?

EDIT: I solved my own problem. I was using a different 1.12.1 client than Lights Hope. Vanilla Gaming was the one that I had installed.
Also in the readme I needed to start apache.bat after mysql and then follow the normal sequence. Another thing I did wrong was trying to use the LITE version. ( no maps)

Hopefully I helped another scrub like myself.

[Zishy]

followed your guide to the letter and i end up having this happening

>> Loaded 33 areatrigger scripts
Loading event id script names...
SQL: SELECT datalong, datalong2, datalong3, datalong4 FROM creature_ai_scripts WHERE command=39
[1054] Unknown column 'datalong' in 'field list'
Your database structure is not up to date. Please make sure you have executed all the queries in the sql/updates folders.
/home/mangos/core/src/shared/Database/DatabaseMysql.cpp:182: Error: Assertion in HandleMySQLError failed: false
./mangosd(_ZN15MySQLConnection5QueryEPKc+0x62) [0xcf0972]
./mangosd(_ZN8Database6PQueryEPKcz+0x131) [0xce60a1]
./mangosd(_ZN9ScriptMgr23CollectPossibleEventIdsERSt3setIjSt4lessIjESaIjEE+0x28d) [0x67e17d]
./mangosd(_ZN9ScriptMgr18LoadEventIdScriptsEv+0x10 [0x683828]
./mangosd(_ZN5World23SetInitialWorldSettingsEv+0xade) [0x692fce]
./mangosd(_ZN6Master3RunEv+0x144) [0x6067a4]
./mangosd(main+0x339) [0x5e7b79]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf0) [0x7f4c80049830]
./mangosd(_start+0x29) [0x5f7249]

terminate called after throwing an instance of 'std::runtime_error'
what(): false
Aborted (core dumped)

[mightguru]

followed your guide to the letter and i end up having this happening

>> Loaded 33 areatrigger scripts
Loading event id script names...
SQL: SELECT datalong, datalong2, datalong3, datalong4 FROM creature_ai_scripts WHERE command=39
[1054] Unknown column 'datalong' in 'field list'
Your database structure is not up to date. Please make sure you have executed all the queries in the sql/updates folders.
/home/mangos/core/src/shared/Database/DatabaseMysql.cpp:182: Error: Assertion in HandleMySQLError failed: false
./mangosd(_ZN15MySQLConnection5QueryEPKc+0x62) [0xcf0972]
./mangosd(_ZN8Database6PQueryEPKcz+0x131) [0xce60a1]
./mangosd(_ZN9ScriptMgr23CollectPossibleEventIdsERSt3setIjSt4lessIjESaIjEE+0x28d) [0x67e17d]
./mangosd(_ZN9ScriptMgr18LoadEventIdScriptsEv+0x10 [0x683828]
./mangosd(_ZN5World23SetInitialWorldSettingsEv+0xade) [0x692fce]
./mangosd(_ZN6Master3RunEv+0x144) [0x6067a4]
./mangosd(main+0x339) [0x5e7b79]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf0) [0x7f4c80049830]
./mangosd(_start+0x29) [0x5f7249]

terminate called after throwing an instance of 'std::runtime_error'
what(): false
Aborted (core dumped)

Seems like a world db issue. Try to drop the mangos database and recreate it. First, populate the db with the world.sql found in the repack sql/Base folder or the release branch from github (Note: the development branch from the github doesn't contain world.sql). Second, populate the mangos database with FULL_WORLD_DB_11_03_2018.sql. Third, populate mangos database with migrations, but first try to run ./mangosd without populating migrations to see which ones are missing.

[brotalnia]

You do not need to use the base world.sql, the full database release sql will create the tables and populate them with all the data.

You can find the latest world database here:
GitHub - brotalnia/database

And remember to apply migrations to it afterwards.

[Zishy]

got it running now on debian and another instance on ubuntu. local connections get accepted and its playable. but outside connections do not get accepted. port forwarding is properly configured tough.. this is driving me nuts

[mightguru]

got it running now on debian and another instance on ubuntu. local connections get accepted and its playable. but outside connections do not get accepted. port forwarding is properly configured tough.. this is driving me nuts

Are you behind NAT? Is your router configured properly?
check for open ports Open Port Check Tool - Test Port Forwarding on Your Router

[Zishy]

Are you behind NAT? Is your router configured properly?
check for open ports Open Port Check Tool - Test Port Forwarding on Your Router

both open. im going to change the ports tonight to +1 because i also have a wrath server running in a different vm. my issue with the configuration is basically.. if i set the realmlist IP to the internal one, i can connect from the local network just fine. if i set the ip to the outside wan ip i cant connect anymore and it seems nobody else can either. both ports are correctly forwarded and open

Yes, you can run this on Linux but first you need to compile it from source. To run the server on Linux requires at least basic knowledge in Linux(terminal) and SQL. I've successfully run this on Ubuntu Server 16.04 LTS using the Github repository and the maps data found in this repack.

I will assume that you are running Ubuntu Server 16.04 LTS Minimal as root (or at least have sudo) but will not cover the security implications of doing this as root user.

Before you start you will want to update your Ubuntu server with:

sudo apt-get update
sudo apt-get upgrade

Then you will need to get some tools to work with:

sudo apt-get install nano screen git wget p7zip-full unrar

At last you need to get the tools for compiling the server:

sudo apt-get install cmake gcc g++ libace-dev libssl-dev libtbb-dev libssl-dev libmysqlclient-dev mysql-server

To start getting the server files and compiling, create a directory to work with in the /home location:

cd /home
sudo mkdir mangos
cd mangos

Now you will have to download and extract the pack and then compile from the source inside or clone the server from the Github repository (for this purpose I will use github repo for compiling the server and use repack for the maps data and world database):

sudo git clone -b release https://github.com/lh-server/core
sudo wget http://link-to-brotalnias-repack-location/Lights+Hope+bropack+v9.rar

Change the address accordingly to point to the location of the repack. This may take some time to download and then extract it using:

sudo unrar x Lights+Hope+bropack+v9.rar

Create directory where you will compile the server

sudo mkdir build
cd build

Now its time to compile:

sudo cmake ../core -DCMAKE_INSTALL_PREFIX=/home/mangos/build
sudo make
sudo make install

(Alternatively to compile the repacks source:

7za x /home/mangos/MaNGOS/source/Repack\ 9\ Source.zip
sudo cmake ../MaNGOS/source/server -DCMAKE_INSTALL_PREFIX=/home/mangos/build
sudo make
sudo make install

)


Depending on your machine the make process will take a while to complete and we are done with compiling the server.

Next part is setting up server configuration files and the database.
Server configuration files should be located in /home/mangos/build/etc directory.

cd /home/mangos/build/etc
sudo cp realmd.conf.dist realmd.conf
sudo cp mangosd.conf.dist mangosd.conf

Changes must be made inside the two conf files to point the locations of the maps/logs and databases.
Create logs directory:

cd /home/mangos/
sudo mkdir logs

Open the realmd.conf file:

sudo nano /home/mangos/build/etc/realmd.conf

And change the two lines inside to:

LoginDatabaseInfo = "127.0.0.1;3306;mangos;mangos;realm"
LogsDir = "/home/mangos/logs"

Open the mangosd.conf file:

sudo nano /home/mangos/build/etc/mangos.conf

And change the lines inside to:

DataDir = "/home/mangos/MaNGOS/data"
LogsDir = "/home/mangos/logs"
LoginDatabase.Info              = "127.0.0.1;3306;mangos;mangos;realm"
WorldDatabase.Info              = "127.0.0.1;3306;mangos;mangos;mangos"
CharacterDatabase.Info          = "127.0.0.1;3306;mangos;mangos;characters"
LogsDatabase.Info               = "127.0.0.1;3306;mangos;mangos;logs"

Take note of the case sensitivity of directory locations.
Last part is setting up the databases:
Login to mysql

mysql -u root -p

Create user mangos and grant privileges:

create user 'mangos'@'localhost' identified by 'mangos';
grant all privileges on *.* to 'mangos'@'localhost';
flush privileges;

Create the databases:

create database realm;
create database mangos;
create database characters;
create database logs;

Use the following command to prevent getting an error when importing large databases:

set global max_allowed_packet=64*1024*1024;
quit

Now its time to populate the databases.
Basic SQL files should be found in /home/mangos/core/sql so:

cd /home/mangos/core/sql
mysql -u root -p realm < logon.sql
mysql -u root -p mangos < world.sql
mysql -u root -p characters < characters.sql
mysql -u root -p logs < logs.sql

The full world database can be found compressed in the repack directory which should be in /home/mangos/MaNGOS/sql/

cd /home/mangos/MaNGOS/sql/
7za x FULL_WORLD_DB_11_03_2018.7z
mysql -u root -p mangos < FULL_WORLD_DB_11_03_2018.sql

Last part is to populate migrations SQL files into the database. Migration sql files are located in /home/mangos/core/sql/migrations and in /home/mangos/Mangos/sql/Migrations. Migration files have the following format 201XXXXXXXXXXX_world.sql or 201XXXXXXXXXXX_character.sql and which ones to use depends on the error that is produced when running the server. This is a tricky part where missing migrations need to be noted and later on populated into the database.
Time to run the server and check for missing migrations:

cd /home/mangos/build/bin
screen
./realmd

to open a new screen window use Ctrl-a c

./mangosd

If while running the server it produces an error that some migrations are missing, navigate to migrations directory and put them into that database using

mysql -u root -p mangos < 201XXXXXXXXXXX_world.sql 

or

mysql -u root -p characters < 201XXXXXXXXXXX_characters.sql

To make the server public insert the following into the database (change the blue numbers to your public IP):

mysql -u root -p
use realm;
INSERT INTO `realmlist` (`id`, `name`, `address`, `localAddress`, `localSubnetMask`, `port`, `icon`, `realmflags`, `timezone`, `allowedSecurityLevel`, `population`, `gamebuild_min`, `gamebuild_max`, `flag`, `realmbuilds`) VALUES (1, 'MyRealm', '0.0.0.0\r\n', '127.0.0.1', '255.255.255.0', 8085, 1, 0, 1, 0, 0, 0, 0, 2, '5875 6005 6141 ');
quit

Make sure ports 3724, 8085, 3306 are open or disable the firewall using sudo ufw disable (NOT RECOMMENDED!).

Note: the code marked in red is not absolute and must be changed accordingly

in your how-to i wanted to point out some issues that lead to an incompatibility with the core and the DBs. do NOT use the github core. use the source from the package provided by OP. also i would not recommend using unrar to extract on the local vm. its very slow. just unpack it and push it over with winscp or something similar.
also when you use make to compile do make -j X (x being the threadcount of the vm to speed things up considerably)

[mightguru]

What I have working is the previous core (the one that is now shutdown on github) and the world database+maps from the repack8. When I wrote the how-to it is under assumption that the now moved repo should work with the world database+maps. I'm running the server on VPS so I have to unrar it there because my upload connection is slow for moving/uploading and the VPS has only 1 core so make -j X wont make any difference. However, thank you for pointing that out. Also, are you running the server on virtual machine?

[Zishy]

i run vms on an esxi host at home.

HLd8SiC.jpg

[REyeM]

Hey brotalnia. Do you know if theres a way to remove the server message at login? The thing that says patch 1.12.1 is now live.

[Zishy]

Hey brotalnia. Do you know if theres a way to remove the server message at login? The thing that says patch 1.12.1 is now live.

adjust it in the config files

[REyeM]

adjust it in the config files

I couldn't find anything in the config file. Perphaps you know? Btw I wasn't talking about motd = "welcome to...", I know how to change that, but the row below that one that says "Patch 1.12.1 (Drums of War) is now live!".

[brotalnia]

You have to recompile the core to change that. Its appended to the motd in World.cpp.

[REyeM]

You have to recompile the core to change that. Its appended to the motd in World.cpp.

Oh, okay, whatever. I guess its not that big of a deal

[521city]

I found a set of anti - cheating source code, but not packaged in the source code.
Please give me some advice. Hope to answer.
I want to pack it into the V9 source code Ask for help! What do I need to do?

Anticheat