database [Solved] Segmentation Fault while running compiled binaries

[chnateag]

Hi guys,

I'm posting here because i'm not far from becoming crazy... It's been 3 days that i'm tring to build my server, and i'm stuck on this error !

I begun with a simple debian (wheezy 7.7) virtual machine (which i cloned once it was clean) to run my tests, and after i was right into the thing, that i compiled the server successfully, and checked everythink, I tried to run it all i've got is a beautifull segfault error at the begining of mangosd loading...

But it's okay, i'm not giving up ! So i did a lot of research but nothing. The few results i've got are german, and all i understand in german is "ich habe nicht verstanden", which mean "i didn't understand" so it didn't help me so mutch.

I also found a recent topic on zero but it was a rev problem, the guy took the 20 and it was solved, but i have been carefull and took the github so my sources are up to date.

i thought i did something wrong, so i started it all over again and redownload all (i had some libraries problem with libmpq and ACE so i wanted to be sure)

Exactly the same problem after compiling my core. So i started it all over again, on my physic server, the host of my VMs. Exactly the same problem again... the worse is that i could build game tools to extract map and vmap, and i ran it sucessfully...

MaNGOS One/ (* * Revision 2057 - *) for Linux_x64 (little-endian) [world-daemon]
<Ctrl-C> to stop.


 __  __      _  _  ___  ___  ___
|  \/  |__ _| \| |/ __|/ _ \/ __|
| |\/| / _` | .` | (_ | (_) \__ \
|_|  |_\__,_|_|\_|\___|\___/|___/

                                      ___           Visit our website for support:       / _ \ _ _  ___ http:                                                                                                                               //getmangos.eu/               | (_) | ' \/ -_)                                      \___/|_||_\___| We love t                                                                                                                               he Burning Crusade



Using configuration file /home/mangos/servers/etc/mangosd.conf.
OpenSSL 1.0.1e 11 Feb 2013 (Library: OpenSSL 1.0.1e 11 Feb 2013)
Using ACE: 6.0.3
World Database total connections: 2
Connected to MySQL database [email protected]:3306/mangos
MySQL client library: 5.5.40
MySQL server ver: 5.5.40-0+wheezy1
AUTOCOMMIT SUCCESSFULLY SET TO 1
Connected to MySQL database [email protected]:3306/mangos
MySQL client library: 5.5.40
MySQL server ver: 5.5.40-0+wheezy1
AUTOCOMMIT SUCCESSFULLY SET TO 1
Character Database total connections: 2
Connected to MySQL database [email protected]:3306/characters
MySQL client library: 5.5.40
MySQL server ver: 5.5.40-0+wheezy1
AUTOCOMMIT SUCCESSFULLY SET TO 1
Connected to MySQL database [email protected]:3306/characters
MySQL client library: 5.5.40
MySQL server ver: 5.5.40-0+wheezy1
AUTOCOMMIT SUCCESSFULLY SET TO 1
Login Database total connections: 2
Connected to MySQL database [email protected]:3306/realmd
MySQL client library: 5.5.40
MySQL server ver: 5.5.40-0+wheezy1
AUTOCOMMIT SUCCESSFULLY SET TO 1
Connected to MySQL database [email protected]:3306/realmd
MySQL client library: 5.5.40
MySQL server ver: 5.5.40-0+wheezy1
AUTOCOMMIT SUCCESSFULLY SET TO 1
Realm running as realm ID 1
Using World DB: OneDatabase 1.0.0 for MaNGOSOne s1881+ and ScriptDevOne s2670+
Using creature EventAI: MaNGOSOne Artificial Creature Intelligence Database
Using DataDir ./data/
WORLD: VMap support included. LineOfSight:0, getHeight:1, indoorCheck:1
WORLD: VMap data directory is: ./data/vmaps
WORLD: mmap pathfinding disabled

Loading MaNGOS strings...
Loading texts from mangos_string
[>> Loaded 845 MaNGOS strings from table mangos_string00%


Initialize data stores...
[[color=#ff0000]Erreur de segmentation[/color]***************             ] 74%
root@:/home/mangos/servers/bin#

[color=#ff0000]Erreur de segmentation = segmentation fault[/color]

root@:/home/mangos/servers/bin# tail -5 /var/log/syslog

Jan 9 16:34:01 /USR/SBIN/CRON[27757]: (root) CMD (/usr/local/rtm/bin/rtm 56 > /dev/null 2> /dev/null)

Jan 9 16:35:01 /USR/SBIN/CRON[27836]: (root) CMD (/usr/local/rtm/bin/rtm 56 > /dev/null 2> /dev/null)

Jan 9 16:36:01 /USR/SBIN/CRON[27914]: (root) CMD (/usr/local/rtm/bin/rtm 56 > /dev/null 2> dev/null)

Jan 9 16:37:01 Aceyna /USR/SBIN/CRON[27992]: (root) CMD (/usr/local/rtm/bin/rtm 56 > /dev/null 2> /dev/null)

Jan 9 16:37:11 kernel: [2922506.133593] mangosd[28036]: segfault at 0 ip 0000000000589ca8 sp 00007fff026994e0 error 6 in mangosd[400000+796000]

I really spend time on research, and i don't know why i think i made a big mistake but i can't find when and where....

I use external ACE library, 6.0.3 from apt sources

Here is the output of my compilation atached to the post.

[ATTACH]171[/ATTACH]

Please help me guys ! and don't hesitate to insult me if did something wrong

other post :

https://www.getmangos.eu/general-help-amp-support/10221-segfault-scripts.html

Compiling.txt

[antz]

Did you get your server up and running ?

[chnateag]

Unfortunately not, i dig a little, but it wasn't working. I didn't menage to build the database, although the instructions are clear... Didn't understood completely the system, and did't take the time to finish for now.

But i think the problem would be solved.

[Foereaper]

What revision are you using?

[chnateag]

I'm sorry but i have no clue. On a google code i see it but not in github.

I thought a git clone --recursive git://github.com/mangosone/server.git was getting the last rev ?

EDIT :

/home/mangos/sources# git show
commit ca28008530cf5293fbe3b810e8d63d69c7292a34
Author: Antz <[email protected]>
Date:   Mon Oct 20 11:25:00 2014 +0100

   Update .travis.yml

   added Dev branch to travis

diff --git a/.travis.yml b/.travis.yml
index 4d7e426..41d8531 100644
--- a/.travis.yml
+++ b/.travis.yml
@@ -8,6 +8,7 @@ git:
branches:
  only:
    - master
+    - Rel19_Newbuild

# do not build with clang until fixed
compiler:

Is that what you're asking for ?

Should i download it from a svn ?

i followed more or less this wiki :

https://getmangos.eu/wiki/Installation%20Guides/Linux/Debianinstall.md

[Foereaper]

A simple git clone fetches Rel19. Rel20 is the latest development branch which has fixed a LOT of the issues seen in Rel19, I would suggest using that and seeing if this solves your issues.

git clone https://github.com/mangosone/server.git -b Rel20 --recursive

[chnateag]

Thank you very much ! Well same issue than the other guy finaly...

It's compiled, i took the rel20 of database too, and i'm now fighting with updates (i've got an error before the datastore load), never totally understood how it works but i saw a wiki on versionning system, so i've got some works to do.

Thank you again, i'll be back to add a [solved] really soon i hope

[Foereaper]

If I were you and this is your first server, I'd just drop your current database and run the database tool supplied with the database itself. Sets everything up for you with a couple easy clicks

[chnateag]

It's not my first but it's been at least 5 years and it was on windows. I did drop the database, and injected it once again, but i must have done something wrong... still looking for what

i've got :

SQL: SELECT required_20001_01_pvpstats FROM character_db_version LIMIT 1
query ERROR: Unknown column 'required_20001_01_pvpstats' in 'field list'
The table `character_db_version` in your [CHARACTER] database indicates that this dat                                                                                            abase is out of date!

 [A] You have: --> `19002_02_character_whispers.sql`

 [b] You need: --> `20001_01_pvpstats.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.

So i want to make the update after '19002_02_character_whispers.sql' but all i've got in the Rel19 dir is

root@:/home/mangos/database/Character/Updates/Rel20# l ../Rel19/
total 204K
-rw-r--r-- 1 root root  173 janv.  9 21:26 19000_Release_019_Initial.sql
-rw-r--r-- 1 root root  92K janv.  9 21:26 19001_dbdocs_Initial.sql
-rw-r--r-- 1 root root  194 janv.  9 21:26 19002_01_character_ticket.sql
-rw-r--r-- 1 root root  782 janv.  9 21:26 19002_02_character_whispers.sql
-rw-r--r-- 1 root root 100K janv.  9 21:26 19002_dbdocs_Update.sql

I tried to apply Rel20 after 19002_dbdocs_Update.sql

Status                  Required Version                           Found Version
* UPDATE SKIPPED *      required_19002_02_character_whispers    NULL

same message for 2000* updates

and i'm lost again. it's beginner error, but i used the tools provided :

mysql -u root -p < mangosdCreateDB.sql
   mysql -u root -p < mangosdCreateDB.sql
   mysql -u root -p mangos < mangosdLoadDB.sql
   mysql -u root -p mangos < full_db.sql
   mysql -u root -p characters < characterLoadDB.sql
   mysql -u root -p realmd < realmdLoadDB.sql

Digging in the wiki...

[Arkadus]

After you done git clone https://github.com/mangosone/server.git -b Rel20 --recursive and git clone https://github.com/mangosone/database.git -b Rel20 --recursive

All you have to do is start mysql if it isnt already then double click on InstallDatabases.bat

[chnateag]

I'm on debian dan't use a bat file, but thanks i'm going to look inside to do the same