[Solved] [ZERO] Installing Mangos Zero 0.19 on Ubuntu

[cabfever]

Hey folks!

I wanted to try the new mangos zero release but I'm not able to get the server compiled. I've read that cmake got an overhaul.

So I tried 3 different -official- and with the 0.18 version working tutorials and getting nonstop errors.

First error is when I try to use cmake:

mangos@test:~/mangos-zero/server/_build$ sudo cmake -DCMAKE_INSTALL_PREFIX=/opt/mangos-zero ..
-- The C compiler identification is GNU
-- The CXX compiler identification is GNU
-- Check for working C compiler: /usr/bin/gcc
-- Check for working C compiler: /usr/bin/gcc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Check for working CXX compiler: /usr/bin/c++
-- Check for working CXX compiler: /usr/bin/c++ -- works
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done

This script builds the MaNGOS server.
 Options that can be used in order to configure the process:
   CMAKE_INSTALL_PREFIX    Path where the server should be installed to
   PCH                     Use precompiled headers
   DEBUG                   Debug mode
   USE_STD_MALLOC          Use standard malloc instead of TBB
   ACE_USE_EXTERNAL        Use external ACE
   SOAP                    Enable use of SOAP, used for remote access and API's
 To set an option simply type -D<OPTION>=<VALUE> after 'cmake <srcs>'.
 Also, you can specify the generator with -G. see 'cmake --help' for more details
 For example: cmake .. -DDEBUG=1 -DCMAKE_INSTALL_PREFIX=/opt/mangos

-- Detected 64-bit platform.
-- Found BZip2: /usr/lib/x86_64-linux-gnu/libbz2.so 
-- Looking for BZ2_bzCompressInit in /usr/lib/x86_64-linux-gnu/libbz2.so
-- Looking for BZ2_bzCompressInit in /usr/lib/x86_64-linux-gnu/libbz2.so - found
-- Found Git: /usr/bin/git 
-- Using mysql-config: /usr/bin/mysql_config
-- Found MySQL library: /usr/lib/x86_64-linux-gnu/libmysqlclient_r.so
-- Found MySQL headers: /usr/include/mysql
-- Found OpenSSL library: /usr/lib/x86_64-linux-gnu/libssl.so
-- Found OpenSSL headers: /usr/include/openssl
-- Found ZLIB: /usr/lib/x86_64-linux-gnu/libz.so (found version "1.2.3.4")
-- MaNGOS-Core revision  : b913446f8cacca3f58f4dc5b4055d4c6095eb8a7
-- Install server to     : /opt/mangos-zero
-- Use PCH               : No
-- Build in debug-mode   : No  (default)
-- Configuring done
CMake Error at src/game/CMakeLists.txt:485 (add_library):
 Cannot find source file:

   LuaEngine/AuraMethods.h

 Tried extensions .c .C .c++ .cc .cpp .cxx .m .M .mm .h .hh .h++ .hm .hpp
 .hxx .in .txx


-- Build files have been written to: /home/mangos/mangos-zero/server/_build

Even when I add "-DWITH_MOD_LUA=0 -DWITH_MOD_SCRIPTDEV2=1" like it's mentioned in TheLuda's tutorial (this worked with 0.18).

And when I want to use make or make install, I get this error (worked also fine with 0.18):

make: *** No targets specified and no makefile found. Stop.

What am I doing wrong?

Where do I possibly find an updated install instruction which works with the new 0.19 core?

Edit: As I can see, the LuaEngine Folder seems to be empty. Is that correct?

[Rochet2]

No. It is not correct.

See getting source here:

https://www.getmangos.eu/frequently-asked-questions/9876-getting-compiling-setting-mangos-server.html

"-DWITH_MOD_LUA=0 -DWITH_MOD_SCRIPTDEV2=1"

Hmm .. looks like you are possibly using nonexistant settings?

[antz]

Please forget anything you did with 0.18, the build system had to be significantly changed again

- I believe the current wiki articles are already updated to support the new process

[cabfever]

@antz: They're sadly not updated. I found this on the Eluna github repo https://travis-ci.org/mangoszero/server and will try to do it this way.

[cabfever]

Now I used the commands which were used on Travis and I get this after ~5 mins

Libraries have been installed in:
  /home/mangos/mangoszero/server/_install/lib

If you ever happen to want to link against installed libraries
in a given directory, LIBDIR, you must either use libtool, and
specify the full pathname of the library, or use the `-LLIBDIR'
flag during linking and do at least one of the following:
  - add LIBDIR to the `LD_LIBRARY_PATH' environment variable
    during execution
  - add LIBDIR to the `LD_RUN_PATH' environment variable
    during linking
  - use the `-Wl,-rpath -Wl,LIBDIR' linker flag
  - have your system administrator add LIBDIR to `/etc/ld.so.conf'

See any operating system documentation about shared libraries for
more information, such as the ld(1) and ld.so(8) manual pages.
----------------------------------------------------------------------
Making install in SSL
Making install in bin
Making install in .
Making install in PerlACE
[  4%] Completed 'ACE_Project'
[  4%] Built target ACE_Project
make: *** [all] Error 2

[cabfever]

I got it working. There might be some missing dependencies on my machine. Installed them and now its building further.

[cabfever]

Okay, first time 5 hours ago it worked. Now I reinstalled ubuntu to get a fresh install and pulled the master branch again. Now I'm always getting this error:

In file included from /home/mangos/mangoszero/server/dep/libmpq/libmpq/common.c:29:0:
/home/mangos/mangoszero/server/dep/libmpq/libmpq/mpq-internal.h:69:2: error: #error "pack_begin.h may not be included twice!"
make[2]: *** [dep/libmpq/CMakeFiles/libmpq.dir/libmpq/common.c.o] Error 1
make[1]: *** [dep/libmpq/CMakeFiles/libmpq.dir/all] Error 2
make: *** [all] Error 2

[cabfever]

Things got fixed in the master branch how it seems. I got it compiled again.

But now I get SQL errors when I start the server:

SQL: SELECT required_20140607_Realm_Resync FROM realmd_db_version LIMIT 1
query ERROR: Unknown column 'required_20140607_Realm_Resync' in 'field list'
The table `realmd_db_version` in your [REALMD] database indicates that this database is out of date!

 [A] You have: --> `z2426_01_realmd_relations.sql`

 [b] You need: --> `20140607_Realm_Resync.sql`

You must apply all updates after [A] to [b] to use mangos with this database.
These updates are included in the sql/updates folder.
Please read the included [README] in sql/updates for instructions on updating.

I looked into the sql/updates/Rel19 folder and there is for example in characters:

ALTER TABLE character_db_version CHANGE COLUMN `required_z1794_s1350_11716_09_characters_auction` `required_19000_Release_019_Init
ial` bit;

But in my database there doesn't exist a column "character_db_version" so this sql update is not possible.

Do I also need all the Rel18 updates before? Even then, there won't be a column called "character_db_version".

[antz]

If you browse to the folder sql/updates/Rel19/Realm

- Thats where all the realm database updates are

Generally there are three databases used for mangos:

• Realm - Login Server
  
• Characters - Where all the character information is kept
  
• Mangos - The World Database, as of Rel19 the separate ScriptDev2 Database has been merged into this database
  

There is also scripts folder, these contain scripting updates to the world database and scripting database.

- These are still separate to the World folder due to the change being very new and people still having separate databases.

[cabfever]

I think I might need some step by step instruction for that.

I'm running a mangos server since a year or something.

But this time I'm all confused.

So, I'm doing it like this way:

$ cd /home/mangos/server/sql
$ mysql -u root -p < create_mysql.sql
$ mysql -u root -p realmd < realmd.sql
$ mysql -u root -p characters < characters.sql
$ mysql -u root -p mangos < mangos.sql

Then I fill the DB with content:

$ cd /home/mangos/database
$ bash make_full_db.sh
$ mysql -u root -p mangos < full_db.sql

So after this I should apply all updates from sql/updates/Rel19 ?

Tried that and got errors.

EDIT:

I should have read the db_version required table

Got the realmd starting so far. Now lets the the mangosd ... I'm kinda afraid!

Logged in! Thank you antz for the hint!

[antz]

brilliant, Glad I could help