[Guide] Mangos Windows Setup

[zx2010]

Please i need help, i use mangos 7838 and psdb 208. I have a VPS in SiliconTower. I installed .net framework 3.5 and Visual c++ 2008 redistibutable x86. My vps is a Windows Server 2003 x64 and when i execute mangosd.exe i have the following error:

Revision: * * 7838 *

Date 1:7:2009. Time 22:50

//=====================================================

*** Hardware ***

Processor: Intel Xeon CPU E5420 2.5 Ghz

Number Of Processors: 8

Physical Memory: 393216 KB (Available: 0 KB)

Commit Charge Limit: 393212 KB

*** Operation System ***

Microsoft Windows Server 2003 Enterprise Edition Service Pack 2 (Version 5.2, Build 3790)

//=====================================================

Exception code: E06D7363

Fault address: 7D4E237E 01:0001237E C:\\WINDOWS\\syswow64\\kernel32.dll

Registers:

EAX:002DEB40

EBX:78486056

ECX:00000000

EDX:00000000

ESI:002DEBC8

EDI:002DF274

CS:EIP:FFFF0023:7D4E237E

SS:ESP:7D62002B:002DEB3C EBP:002DEB90

DS:7D61002B ES:2D002B FS:2D0053 GS:7D61002B

Flags:00000206

CRITICAL ERROR.

Couldn't initialize the symbol handler for process.

Error [Not enough storage is available to process this command.

].

Call stack:

Address Frame Function SourceFile

7D4E237E 00000000 0001:0001237E C:\\WINDOWS\\syswow64\\kernel32.dll

7857DBF9 00000000 0001:0005CBF9 C:\\WINDOWS\\WinSxS\\x86_Microsoft.VC90.CRT_1fc8b3b9a1e18e3b_9.0.30729.1_x-ww_6F74963E\\MSVCR90.dll

78583B9D 00000000 0001:00062B9D C:\\WINDOWS\\WinSxS\\x86_Microsoft.VC90.CRT_1fc8b3b9a1e18e3b_9.0.30729.1_x-ww_6F74963E\\MSVCR90.dll

784851C5 00000000 0001:000041C5 C:\\WINDOWS\\WinSxS\\x86_Microsoft.VC90.CRT_1fc8b3b9a1e18e3b_9.0.30729.1_x-ww_6F74963E\\MSVCP90.dll

78485921 00000000 0001:00004921 C:\\WINDOWS\\WinSxS\\x86_Microsoft.VC90.CRT_1fc8b3b9a1e18e3b_9.0.30729.1_x-ww_6F74963E\\MSVCP90.dll

7848606D 00000000 0001:0000506D C:\\WINDOWS\\WinSxS\\x86_Microsoft.VC90.CRT_1fc8b3b9a1e18e3b_9.0.30729.1_x-ww_6F74963E\\MSVCP90.dll

78486107 00000000 0001:00005107 C:\\WINDOWS\\WinSxS\\x86_Microsoft.VC90.CRT_1fc8b3b9a1e18e3b_9.0.30729.1_x-ww_6F74963E\\MSVCP90.dll

78486366 00000000 0001:00005366 C:\\WINDOWS\\WinSxS\\x86_Microsoft.VC90.CRT_1fc8b3b9a1e18e3b_9.0.30729.1_x-ww_6F74963E\\MSVCP90.dll

784873AF 00000000 0001:000063AF C:\\WINDOWS\\WinSxS\\x86_Microsoft.VC90.CRT_1fc8b3b9a1e18e3b_9.0.30729.1_x-ww_6F74963E\\MSVCP90.dll

007F9742 00000000 0001:003F8742 C:\\zxserver\\mangosd.exe

0057BDE1 00000000 0001:0017ADE1 C:\\zxserver\\mangosd.exe

0063D70E 00000000 0001:0023C70E C:\\zxserver\\mangosd.exe

004339B3 00000000 0001:000329B3 C:\\zxserver\\mangosd.exe

0043387C 00000000 0001:0003287C C:\\zxserver\\mangosd.exe

00438D5B 00000000 0001:00037D5B C:\\zxserver\\mangosd.exe

7D4E7D42 00000000 0001:00017D42 C:\\WINDOWS\\syswow64\\kernel32.dll

Call stack:

Address Frame Function SourceFile

7D61D6E4 00000000 0001:0000D6E4 C:\\WINDOWS\\system32\\ntdll.dll

002DDBA8 00000000 0000:00000000

FF50D845 FFFFFFFF

******************************************************************************************************************************************************************

***************************************************************************************

Before install Visual C++ 2008 redistributable I got the following error in mangosd.exe:

2009-06-30 08:08:03 Table `creature` have creature (GUID: 890015 Entry: 17830) with `creature_template`.`RegenHealth`=1 and low current health (1000), `creature_template`.`minhealth`=2400.

2009-06-30 08:08:40 >> Loaded 0 loot definitions. DB table `creature_loot_template` is empty.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 3 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 6 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 30 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 36 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 38 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 40 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 43 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 46 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 48 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 60 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 61 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 68 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 69 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 79 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 80 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 92 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 94 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 95 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 97 (creature entry) not exist but used as loot id in DB.

Please help me.

[no.human.being]

Is there a UDB available for MaNGOS Rev. 8110?

[Diablox]

No!!

Last UDB is for 8029

[davemm]

Is there a UDB available for MaNGOS Rev. 8110?

maybe ask at udbforums? as its them who make it?

[kageb0shi]

Please i need help, i use mangos 7838 and psdb 208. I have a VPS in SiliconTower. I installed .net framework 3.5 and Visual c++ 2008 redistibutable x86. My vps is a Windows Server 2003 x64 and when i execute mangosd.exe i have the following error:

the VS C++ redistibutable package is if your running the mangos server on a different machine than you compiled it. And if you compiled mangos for x64 build than you should be using x64 C++ redistributable, not x86.

And you got this:

2009-06-30 08:08:03 Table `creature` have creature (GUID: 890015 Entry: 17830) with `creature_template`.`RegenHealth`=1 and low current health (1000), `creature_template`.`minhealth`=2400.

2009-06-30 08:08:40 >> Loaded 0 loot definitions. DB table `creature_loot_template` is empty.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 3 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 6 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 30 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 36 (creature entry) not exist but used as loot id in DB....

which is a db problem and has nothing to do with mangos. mangos by itself, has empty databases. You will have to populate the databases from some other project(link in my signature), and if you are getting a problem related to a database then you need to post on that database project's forum, not on mangos forum.

[austinsattler]

I am getting this error when trying to run mangosd.exe and realmd.exe

C:\\mangos\\LIBEAY32.dll is either not designed to run on windows or contains an error. Try installing the program again using the original installation media or contact your system administrator or the software vendor for support.

Can any one help me with this?

[the mpc]

Great post m8

[Microgt83]

ok, I managed to get around the security thing by not changing the settings and then leaving the password spot in the SQLyog blank, still can't compile... re-downloaded the git and followed the directions, and still get massive errors in the ACE_wrappers project. The only erros I can find are all this

1>C:\\Program Files\\Microsoft Visual Studio 9.0\\VC\\include\\intrin.h(1040) : error C2733: second C linkage of overloaded function '_interlockedbittestandset' not allowed

1> C:\\Program Files\\Microsoft Visual Studio 9.0\\VC\\include\\intrin.h(1040) : see declaration of '_interlockedbittestandset'

1>C:\\Program Files\\Microsoft Visual Studio 9.0\\VC\\include\\intrin.h(1041) : error C2733: second C linkage of overloaded function '_interlockedbittestandreset' not allowed

1> C:\\Program Files\\Microsoft Visual Studio 9.0\\VC\\include\\intrin.h(1041) : see declaration of '_interlockedbittestandreset'

As for the libraries, could you list the ones that are needed so I can check to see if maybe one or two are missing?

Thanks for the help so far.

Im Haveing the Same problem but from some reason the board will not let me see any other page but the first one so i can see if there is a solution to the problem

just wanted to let others know that if you search for Microsoft Windows SDK for windows server 2008 and .net framework 3.5 it will fix the problem

you will then need to add the following paths as

C:/program Files/Microsoft SDKs/windows/v6.1/bin to Exe Tab

C:/program Files/Microsoft SDKs/windows/v6.1/Include to Include tab

C:/program Files/Microsoft SDKs/windows/v6.1/lib to libary Tab

Clean and build

Build Successfull with this fix

[o306336202]

Thanks!

somathing!

[Caskast]

Thanks really nice guide really helped me > hits the thanks button

[wildass]

Adding Databases

......

......

......

-Do the same, ......

"Same" what? I'm stuck there.

[kageb0shi]

"Same" what? I'm stuck there.

it means you're gonna create a total of 3 seperate databases and to follow same procedure for creating each database.

Adding Databases

-In the top left-hand side, right-click "root@(IP here)"

-Click "Create Database"

-For the database name type in "realmd"

-Do the same, except for two more databases named "mangos" and "characters"

[digitalni]

I compiled MaNGOS/0.14.0-DEV (* * Revision 8139 - *) and imported the UDB_0.11.5_Core_7681_SD2_1012

In my understanding, this UDB is for mangos 7681 and needs to be updated which mangos server log clearly confirms with this line:

2009-07-07 20:55:30 ERROR:Error in gameobject_template table, probably sql file format was updated (there should be 39 fields in sql).

But, on http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Updates/0.11.5_additions/,

there is nothing that updates from 7681 to a newer version, its updating from 7682 ?

That's where I get lost and keep diggin through UDB svn trying to find it...

I also noticed that after importing the data into a CLEAN DB from above mentioned UDB file, in table db_version says "UDB 0.11.0 (371) for MaNGOS 7681 with SD2 SQL for rev. 1012"

Now how the hell can it be udb 0.11.0 when I downloaded 0.11.5?

Also, when UDB says CORE, does mangos and the other servers now have the same core versions or something? Its unified, right?

Can someone please clear these things up for me, I dont want a step by step guide I just need a hint here and there

Thanks...

EDIT:

Nevermind, I found this on UDB forums:

In order to get from 0.11.0 (370) to 0.11.5 (371), apply these files:

* 371_corepatch_characters_7518_to_7681.sql <- apply to characters database

* 371_corepatch_realmd_7518_to_7681.sql <- apply to realmd database

* 371_corepatch_mangos_7518_to_7681.sql <- apply to mangos database

* 371_updatepack_mangos.sql <- apply to mangos database

These files are located in tags/0.11.0/Updates

Very freakin' logical / not.

[kageb0shi]

EDIT:

Nevermind, I found this on UDB forums:

In order to get from 0.11.0 (370) to 0.11.5 (371), apply these files:

* 371_corepatch_characters_7518_to_7681.sql <- apply to characters database

* 371_corepatch_realmd_7518_to_7681.sql <- apply to realmd database

* 371_corepatch_mangos_7518_to_7681.sql <- apply to mangos database

* 371_updatepack_mangos.sql <- apply to mangos database

These files are located in tags/0.11.0/Updates

Very freakin' logical / not.

its db related so you should post your query on udb's forums.

Not logical? Post your complaint on UDB's forums

[plunkos]

Hello World

this is my problem.

At the launch of the core

I have a warning that my open ssl and Depas

how to fix that:huh:

[Shadez]

Hello World

this is my problem.

At the launch of the core

I have a warning that my open ssl and Depas

how to fix that:huh:

Your SSL-library is outdated? So, update it

[plunkos]

yes but how to update

and how to

[scarfaze1]

Setting up the databases

-Run SQLyog

-Click the "New Connection" button at the top of the connection window somewhere

-Name the connection anything you like

-Fill out the fields as indicated below:

MySQL Host Address: This is "127.0.0.1" or "localhost" for playing singleplayer or LAN; if you want to put your server online, put this as the IP or DNS of the server that MaNGOS is being hosted on.

Username: Type in "root".

Password: This is the password you set up when you installed the MySQL Community Server.

Database(s): Leave this blank for now.

-Click "Connect"

Adding Databases

-In the top left-hand side, right-click "root@(IP here)"

-Click "Create Database"

-For the database name type in "realmd"

-Do the same, except for two more databases named "mangos" and "characters"

Once that's done...

-Click "File" in the menu at the top of SQLyog

-Click "New Connection"

-This time in the databases field, type:

realmd;mangos;characters

-When SQLyog asks if you'd like to save the changes, choose yes

-Click "Connect"

-Now, in the left-hand database list, right-click "realmd" and click "Restore from SQL Dump"

-Click "Browse", and select your MaNGOS source folder, then go into the "sql" folder and select realmd.sql

-Click "Execute"

Once that's done...

-Right-click "characters" and select "Restore from SQL Dump"

-Click "Browse", and select the characters.sql in the same sql folder

-Click "Execute"

Once that's done...

-Go here to download the newest UDB database (contains all the world stuff)

-Make sure that your MaNGOS core is up-to-date with the database (check your core's revision number, then the compatible revision number within the file title of the UDB database)

-Download the latest UDB update packs here (if that link doesn't work, go here and find the updates folder in /trunk)

I am having problems here, when fixing the databases

I made mangos, realmd and characters

Then I executed mangos.sql, realmd.sql and characters.sql into the databases from my /sql folder

But now my problem is that when I log in evreything is gone, of course I understand that I have to download the 11.5 core and execute it into the database, but now I am getting compatibility issues? Can someone please help me? Maybe the updates for 11.5 or the CLEANINSTALL_ONLY folders should help?

Sorry I am noob at this, but I really want to get on with the C++

[Phenomenon]

I am having problems here, when fixing the databases

I made mangos, realmd and characters

Then I executed mangos.sql, realmd.sql and characters.sql into the databases from my /sql folder

But now my problem is that when I log in evreything is gone, of course I understand that I have to download the 11.5 core and execute it into the database, but now I am getting compatibility issues? Can someone please help me? Maybe the updates for 11.5 or the CLEANINSTALL_ONLY folders should help?

Sorry I am noob at this, but I really want to get on with the C++

Mangos.sql is a blank database. If you want content, you need to download a content database, such as UDB.

[sonata]

Mangos.sql is a blank database. If you want content, you need to download a content database, such as UDB.

Hey can you help me out then?

Mine says 8158 and the UDBs in the update folder only go up to 8029..

[scarfaze1]

Mangos.sql is a blank database. If you want content, you need to download a content database, such as UDB.

That was just what I was talking about, but I am wondering in what order I would have to execute? In the guide it says that I have to do the blank ones from my SQL folder first, then download and update? But I am having problems with that

I have tried first executing the blank ones, then the 11.5 core from UDB, then all the updates from 11.5, but when I update I get errors. So as I said, my question is in what order should I execute sql's into the database?

[Silvervanquished]

Hello

After much work i got my server up and working, I can do everything on the server through my client (wich is on the same pc as the server). But when i try connect from a different pc it doesnt work. Either it says the Log in Server is Down or when i rester the Log in Server, a bunch of Html code comes up.

I have tried 127.0.0.1 and my own IP in the realmlist, config files (mangos + realmd) and db reamlist. I have tried different variations of them with no luck.

Any advice?

[kageb0shi]

That was just what I was talking about, but I am wondering in what order I would have to execute? In the guide it says that I have to do the blank ones from my SQL folder first, then download and update? But I am having problems with that

I have tried first executing the blank ones, then the 11.5 core from UDB, then all the updates from 11.5, but when I update I get errors. So as I said, my question is in what order should I execute sql's into the database?

You need blank sql files, then UDB CleanInstall, then UDB updates 380 and 381 files, then udb update file, then mangos\\sql\\updates. Pay attention to table db_version, last column says required_xxxx_xx_mangos/characters/realmd for each database. Each update sql file, 380, 381 and mangos\\sql\\update will change that column. You will see in sql files ALTER TABLE db_version CHANGE COLUMN required_xxx_xx_mangos...

realmd database has table realmd_db_version you apply xxxx_xx_realmd to that db

mangos db has table db_version you apply xxxx_xx_mangos... to that

characters has table characters_db_version and you apply xxxx_xx_characters updates to that

but keep an eye on that last column in that table and compare that number with the number on the name of sql update file. any sql update file that has number greater than the number in the column you need to apply in sequential order. Though, this is partially UDB related, so you should check out their forums. Look at the Resources thread which is linked in my signature.

Hello

After much work i got my server up and working, I can do everything on the server through my client (wich is on the same pc as the server). But when i try connect from a different pc it doesnt work. Either it says the Log in Server is Down or when i rester the Log in Server, a bunch of Html code comes up.

I have tried 127.0.0.1 and my own IP in the realmlist, config files (mangos + realmd) and db reamlist. I have tried different variations of them with no luck.

Any advice?

127.0.0.1 does nothing but loopback. No other computer will ever be able to connect to server if your using 127.0.0.1. Only time for 127.0.0.1 is in conf files. In database look at realmd in table realmlist. It will show mangos realm as id 1, you will see column name address. enter lan ip address there. also, for more info there is a sticky on this forum nameed hosting behind router. read up in there.

[applepie231]

ok so i get everything fine and i connect to SQLyog and the get the DB up but realmd and mangos.exe open for a split second then close and i followed this exactly i have no idea whats wrong

also none of those sql updates work besides the mangos one...i just get errors for the realmd and characters

[scarfaze1]

You need blank sql files, then UDB CleanInstall, then UDB updates 380 and 381 files, then udb update file, then mangos\\sql\\updates. Pay attention to table db_version, last column says required_xxxx_xx_mangos/characters/realmd for each database. Each update sql file, 380, 381 and mangos\\sql\\update will change that column. You will see in sql files ALTER TABLE db_version CHANGE COLUMN required_xxx_xx_mangos...

realmd database has table realmd_db_version you apply xxxx_xx_realmd to that db

mangos db has table db_version you apply xxxx_xx_mangos... to that

characters has table characters_db_version and you apply xxxx_xx_characters updates to that

but keep an eye on that last column in that table and compare that number with the number on the name of sql update file. any sql update file that has number greater than the number in the column you need to apply in sequential order. Though, this is partially UDB related, so you should check out their forums. Look at the Resources thread which is linked in my signature.

127.0.0.1 does nothing but loopback. No other computer will ever be able to connect to server if your using 127.0.0.1. Only time for 127.0.0.1 is in conf files. In database look at realmd in table realmlist. It will show mangos realm as id 1, you will see column name address. enter lan ip address there. also, for more info there is a sticky on this forum nameed hosting behind router. read up in there.

Thanks to you, and I would send you cookies if that was possible, solved all of my problems