MaNGOSR2
Would you like to react to this message? Create an account in a few clicks or log in to continue.
MaNGOSR2

MangosR2 is a free, open source MMORPG framework, derived from MaNGOS project


You are not connected. Please login or register

MaNGOSR2 » Info/Docs/Информация/Документация » I have some problem with running mangosd.exe,please help me.

I have some problem with running mangosd.exe,please help me.

2 posters

Go down  Message [Page 1 of 1]

ctrobot



In the first,the problem is realmd.exe told me:realmd.sql is out of date(version:10008),because I can't find any update files for realmd.sql,so I simply rewrite the content of realmd.sql,changed the "10008_01_XXXX" to"12112_01_realmd_account_access"，ok，realmd.exe no longer bother me since then.It works.

But when I run the mangosd.exe,it told me as follow:
Microsoft Windows [Version 6.1.7601]
All Rights Reserved (c) 2009 Microsoft Corporation。

C:\Users\robot>C:\GAMES\MaNGOS\bin\mangosd.exe
BOOT: [world-daemon] MangosR2/0.17 (Revision 2952), http://github.com/mangosR2/m
angos
BOOT: [world-daemon] mangosR2 branch (* * R2 Revision 2952 commit *) for Win32 (
little-endian)
BOOT: Please, visit to github branch or forum https://mangosr2.forumotion.com for r
eport bugs
BOOT: Using configuration file C:/GAMES/MaNGOS/etc/mangosd.conf.
BOOT: Using OpenSSL 1.0.0d 8 Feb 2011 (Library: OpenSSL 1.0.0d 8 Feb 2011)
BOOT: Using ACE 5.8.3
BOOT: World Database total connections: 2
BOOT: Connected to MySQL database root@127.0.0.1:3306/mangos
BOOT: MySQL client library: 5.1.49
BOOT: MySQL server ver: 5.1.50-community-log
BOOT: MySQL autocommit succesfully enabled
BOOT: MySQL successfully turned on MYSQL_OPT_RECONNECT.
BOOT: Connected to MySQL database root@127.0.0.1:3306/mangos
BOOT: MySQL client library: 5.1.49
BOOT: MySQL server ver: 5.1.50-community-log
BOOT: MySQL autocommit succesfully enabled
BOOT: MySQL successfully turned on MYSQL_OPT_RECONNECT.
BOOT: Character Database total connections: 2
BOOT: Connected to MySQL database mangos@127.0.0.1:3306/characters
BOOT: MySQL client library: 5.1.49
BOOT: MySQL server ver: 5.1.50-community-log
BOOT: MySQL autocommit succesfully enabled
BOOT: MySQL successfully turned on MYSQL_OPT_RECONNECT.
BOOT: Connected to MySQL database mangos@127.0.0.1:3306/characters
BOOT: MySQL client library: 5.1.49
BOOT: MySQL server ver: 5.1.50-community-log
BOOT: MySQL autocommit succesfully enabled
BOOT: MySQL successfully turned on MYSQL_OPT_RECONNECT.
BOOT: Login Database total connections: 2
BOOT: Connected to MySQL database root@127.0.0.1:3306/realmd
BOOT: MySQL client library: 5.1.49
BOOT: MySQL server ver: 5.1.50-community-log
BOOT: MySQL autocommit succesfully enabled
BOOT: MySQL successfully turned on MYSQL_OPT_RECONNECT.
BOOT: Connected to MySQL database root@127.0.0.1:3306/realmd
BOOT: MySQL client library: 5.1.49
BOOT: MySQL server ver: 5.1.50-community-log
BOOT: MySQL autocommit succesfully enabled
BOOT: MySQL successfully turned on MYSQL_OPT_RECONNECT.
BOOT: Realm running as realm ID 1
BOOT: Using World DB: YTDB_0.14.7_R641_cMaNGOS_R12539_SD2_R2913_ACID_R310_RuDB_R
63
BOOT: Using creature EventAI: ACID 3.1.0 'Another Wild Adventure' - Full Release
for CMaNGOS-WOTLK (3.3.5a Client)
BOOT: Using DataDir C:\games\mangos\Data/
BOOT: VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1
BOOT: VMap data directory is: C:\games\mangos\Data/vmaps
BOOT: mmap pathfinding enabled
BOOT: reset duel area disabled

Loading MaNGOS strings...
Loading texts from mangos_string
=>> Loaded 864 MaNGOS strings from table mangos_string00%


Initialize data stores...
===================================================== 102%
>> Initialized 97 data stores

Using enUS DBC Locale as default. All available DBC locales: enUS

Loading opcodes for realm (client build 12340)...
SQL: SELECT `name`, `value`, `flags` FROM `opcodes` WHERE `version`= 12340
query ERROR: Table 'mangos.opcodes' doesn't exist

Loading opcodes - current opcodes set is empty!
..\..\..\src\game\ObjectMgr.cpp:10299: Error: Assertion in ObjectMgr::LoadOpcode
s failed: false
Stack Trace:
CreatureEventAI::~CreatureEventAI()+0xa2e5 [0x0]
Movement::MoveSplineInit<GameObject *>::Path()+0x802 [0x0]
SqlStmtFieldData::toUint8()+0x1336 [0x0]
EventProcessor::Update()+0x2264a [0x0]
BaseThreadInitThunk()+0x12 [0x0]
RtlInitializeExceptionChain()+0x63 [0x0]
RtlInitializeExceptionChain()+0x36 [0x0]
Loading GameObject models...
Loading SpellDbc...
SQL: SELECT MAX(Id) FROM spell_dbc
query ERROR: Table 'mangos.spell_dbc' doesn't exist
Error loading spell_dbc table (not exist?)

C:\Users\robot>

I just merely compiled mangosR2(use project_setup.bat).For Scriptdev2,I put it under the mangos/src/bindings folder(before compile mangosR2), it does not compile separately. Am I right?
Besides I had upgraded mangos'  sql database,but didn't applied the Scriptdev2 sql patch to database.

rsa

rsa
Admin

your not correctly apply all SQL patches, also initial DB structure incorrect.
use /contrib/server_scripts/auto_update.sh
if cannot make this manually.

ctrobot



rsa wrote:your not correctly apply all SQL patches, also initial DB structure incorrect.
use /contrib/server_scripts/auto_update.sh
if cannot make this manually.
Thank you very much! Rsa.Because auto_update.sh report errors.So I need do this manually.
Do I need apply patches in "mangos\src\bindings\ScriptDev2\sql\updates" to database？（those patches’name begin with the letter “r”，not"mr".）
Besides,is the following installation sequence correct or not?
for database ScriptDev2:
/src/bindings/ScriptDev2/sql/scriptdev2_create_structure_mysql.sql
/src/bindings/ScriptDev2/sql/scriptdev2_script_full.sql
/src/bindings/ScriptDev2/sql_mr/custom_scriptdev2_bsw_table.sql
/src/bindings/ScriptDev2/sql/mangos_scriptname_full.sql(to mangos database)
then apply all mr*scriptdev2*sql in the folder"/src/bindings/ScriptDev2/sql_mr/"

and my mangos database install sequence is:
after install and update YTDB to newest then apply:
/sql_mr/custom_mangos_tables.sql
/sql_mr/custom_rerun_every_mangos_DB_update.sql
/src/bindings/ScriptDev2/sql_mr/last_mangos_sql_at_every_db_update.sql
then apply all mr*mangos*sql in both folder "mangos/sql_mr"and "mangos/src/bindings/ScriptDev2/sql_mr/"



Last edited by ctrobot on Sun Sep 22 2013, 07:49; edited 2 times in total (Reason for editing : complete the question)

rsa

rsa
Admin

for manual install requires next steps:
1. fill clean /sql/create_mysql.sql
2. fill all needed clean scriptdev2/sql/
3. fill last clean YTDB base
4. apply all needed clean updates (mangosR2/sql/updates scriptdev2/sql/updates)
5. apply all mangosR2/sql_mr/custom_* and scriptdev2/sql_mr/custom_*
6. apply all R2 updates step-by-step from /sql_mr/ folders (for core and SD2). some updates may be fail - this normal (included in custom_*).
7. rerun custom_rerun_every_mangos_DB_update.sql
enjoy.

ctrobot



Thank you for so detailed reply,I basically know how to install it,only not sure about step5:
Is the following sequence correct to fill these files?

F:\mangos\sql_mr\custom_mangos_masquerade_begin.sql
F:\mangos\sql_mr\custom_mangos_masquerade_end.sql
F:\mangos\sql_mr\custom_mangos_tables.sql
F:\mangos\sql_mr\custom_rerun_every_mangos_DB_update.sql

and when step6 is done,rerun custom_rerun_every_mangos_DB_update.sql.

Last question is:how about "last_mangos_sql_at_every_db_update.sql"'s setup order? (This file is at \ScriptDev2\sql_mr\)

Thank you very much,rsa.

rsa

rsa
Admin

last_mangos_sql_at_every_db_update.sql requires after NEW clean SQL update apply, not need after install.
*masquerade_* - special scripts for compartibility, used by auto_update.sh script.

ctrobot



I understand,thank you!

Sponsored content



Back to top  Message [Page 1 of 1]

MaNGOSR2 » Info/Docs/Информация/Документация » I have some problem with running mangosd.exe,please help me.

Permissions in this forum:
You cannot reply to topics in this forum