Phenomenon

I should update this

Looks like I need to update the guide again, my host just kind of took a crap on itself...All the info should still be fine, though.

How about you tell us what the issue is?

Thank you bisonte, but now i have an other issue, how can I know a password of a account, cause is coded :-s

You aren't supposed to know what it is because that's a privacy issue. If you want to change a user's password however, you can do that in the mangosd.exe command window if I remember correctly.

I got mangos.exe running with no errors and realmd.exe as well but when i log into WOW it tells me that the realm is offline. Anyone have any suggestions?

Make sure that your realm is set to your WoW realmlist (so if you want to play locally, you need to set your realm's IP in your realmd database to 127.0.0.1 or localhost). Alternatively, it's possible that you have some kind of security blocking the connection to the realm such as a firewall or anti-virus.

I'm confused as to how to do this. I've queried the updatepacks and corepatch that was located in the updates folder I created previously. Also, I'm not sure if the MaNGOS>Source>sql>Update files matter in this case? If so, which update file should I start from because I think each update needs a previous update in order to work.

Look at the revision you downloaded (mangos database -> tables -> db_version), then look at the SQL updates. Apply every update after your db_version.

I seem to be having a strange issue...

When my config files have their IPs set to 127.0.0.1 Everything on the server starts up and works great, i can login and play from the server as well.

However when i try to login from another computer on my network i can login and see the MaNGOS server but it will not load.

If i change the IP to the local IP 192.168.0.103, the server closes almost immediately after starting.

Even though you're on a network, I believe you still need to forward the ports through your router. Don't quote me on that though, I'm no network expert

When I get to step 3 and right click the folder, It doesnt say Git Gui. Any suggestions?

Open GIT through the Start menu then.

Start -> Programs -> Git -> Git GUI

Right, I have everything nice and set up. When I got to the step to load the realmd.exe and mangosd.exe, the realmd works fine, but on the other hand, mangosd seems to just pop up for less than a second, and then close. I'm not sure what's causing this.

Edit: I quickly took a screenshot of what the mangosd.exe is telling me. It says:

query ERROR: Unknown column 'requred_9924_02_mangos_command' in field list'

[0 ms] SQL: SELECT * FROM db_version LIMIT 1

The table 'db_version' in your [WORLD] darabase indicates taht this database is out of date!

[A] You have: --> '9763_01_mangos_battleground_template.sql'

You need: --> '9924_02_mangos_command.sql'

You must apply all updates after [A] to to use mangos with this database.

These updates are included in the sql/updates folder. Etc.

Anyways, I guessed I need to run the query '9924_02_mangos_command.sql' on the mangos DB. I tried that, and the result contained something like 'Query : ALTER TABLE db_version CHANGE COLUMN blah blah'.

Edit2: Just for more info, when I was creating the SQL connection in SQLyog, the results from the queries contained a lot of errors.

Just because the MaNGOS CMD window tells you to do 1 update doesn't mean that it should fix everything on it's own. Check your MaNGOS revision and apply all the newest updates. If you're lazy, then go on UDB and grab some update packs.

Well , I've been trying to update my server with no succes.I Gui MaNGOS folder , Fetch from origin , and when I hit Local Merge i get this error :

ANy help ?

"fatal: bad revision '^'

fatal: bad revision '^'"

This is the source of your error. Something's up with the revision number. I can't tell from what you've posted, but it's possible that you're trying to update/merge from an older version of MaNGOS (just throwing that out there, I'm no git expert).

Means you've extracted your files from a version of world of warcraft that isn't the one supported by your mangos version

If your Mangos version is 3.3.3 build 17000 (random number), then you need to patch your world of warcraft client up to build 17000 and then extract the maps files

It wouldn't matter if his client was out of date , he would get individual map errors not an error for every single map.

My WoW-Client is up to date...

What I'm thinking is that you don't have the maps folder in the same place as your MaNGOS executables are. Once you extract the maps, you need to move the folder into your MaNGOS folder along with the dbcs. If you have done this, then I'm pretty sure that you have vmaps enabled when you didn't extract them. You can toggle vmaps in mangosd.conf.

this is the only error i get : , but I've added "9899_01_mangos_spell_bonus_data" and "9539_01_mangos_spell_bonus_data" in characters database in SQLyog and still get this error. Any help ?

You're most likely missing all the updates in between the two revisions that you're having issues with. Try applying the update packs on UDB and if your thing still doesn't work, apply individual updates from 9539 to the current revision. You can't skip updates, lol

Alright the new guide is up, hope everyone likes it

Just thought I'd let everyone know that there's some news on my original post; new guide coming soon.

I know this isn't mangos related, but I didn't know where else to turn to. I'm trying to port forward so that me and my friend can mess around on my server, but I can't seem to get it right. I've done research, tried tons of stuff, used port forwarding applications, etc. Nothing. Is. Working.

Everything is allowed through my firewall, anti-viruses aren't an issue, I'm on Windows 7, have a dynamic IP (I change everything as needed though) and have a DLink DIR-615.

Like I've said I've done tons of research, so what I'm starting to think is that I need help on MaNGOS port forwarding specifically since all the general help doesn't seem to be helping me.

Any help or even a point in the right direction is extremely appreciated, thanks

I haven't gone through the guide for a while, so if there are any mistakes please let me know via PM.

I know I can't prove this from where I am and you would be inclined to disagree anyway since I am still getting error messages, but I am very certain I followed the instructions to the letter. That being said I will go over them again. If I can't find a step that doesn't look familiar I will restart from the beginning. I'm not in a rush to get this all done, heh.

I cbf to look at your original reply to determine your problem, but if it's a database issue you'll most likely get better help from the database provider's site.

Thank you, I'll update it right now. Since I play retail WoW a lot, I actually haven't really been into private servers lately since Mangos doesn't yet have support for 3.2.

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.

I personally think that more information should be placed (don't ask me what, it just looks a little empty) but without making it look like a useless cluttered webpage.

I updated the guide a little bit, I noticed that MaNGOS now supports 3.1.3. Re-extract DBC/map/vmap files and update your core.

If this is mentioned any where in this forum i apologize, I just didn't see it in here. If I want to add in custom pieces like Auction House bot, or a GM island or something when and where do I add in the code to compile it... I have been searching for it a while and could never understand at what point it needs to be added to work right.

You apply the patch files to your downloaded source folder, then compile.

Guide last updated: April 1st 2009

-Added a missing step

-Fixed minor spelling mistakes

-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)

Updating your database with .sql batch files

-Open the .sql file you are going to use to update the database in Notepad

-Open SQLyog and connect to your server

-Select the database that is supposed to be updated

-In the textbox to the right of SQLyog at the top of the application (the query textbox), paste the contents of the .sql file

-Select all the text in the textbox, then press the play button in the toolbar at the top of SQLyog

-Parts of the application will become grayed, wait for the query to finish executing

[\\QUOTE=Phenomenon;67391]

I am not sure how to verify the database version and how to update the core. I think I have done so and when mangos starts it is able to connect to the mangos database but it errors out saying that it can not connect to MySQL database... I have checked that the password for MySQL server is the same as is in the .conf files (instead of mangos) yet I get the same error in starting realmd.exe and mangosd.exe... Please anyone I need help.. I have been trying to get this started for the last three days.

There's obviously an issue with your MySQL server configuration. Click Start > Programs > MySQL Server and use the reconfiguration tool to reset the pass. I'd use the default "mangos" for now until you get it all working. If you still have issues, try again but turn off your Firewall and any Anti-Viruses that may conflict with permissions. If you're using Vista, try running the reconfiguration as an administrator (right click > Run As Administrator).

man, do the f*ing thing b4 u talk:

http://github.com/mangos/mangos/tree/master

the

BIN FOLDER

is not there...this what u now get when git....

here is another image...

http://f.imagehost.org/0595/asdasdasdasdasdasda.jpg

Have you compiled VC90?

EDIT: Nevermind.

You need to compile as per OPs above. Do exactly what is there and you will get the exes.

The step about extracting the maps, vmaps and DBCs misses only that you get those extracted files and put on the apropriate folders on your server(Mangos one) sub-folders.

Thaonx Phenomenon for the great help.

Thank you, I added that part in.

Great guide so far, just having one problem, wehn I try to set up the configuration for the MySQL server, I get an error when it tries to apply the security settings.

The Error is:

Error Nr. 1045

Access denied for user'root'@'localhost' (using password: YES)

anyone have any problems with this before?

Also having problem with compiling,

12>Linking...

12>LINK : fatal error LNK1181: cannot open input file 'mangosd.lib'

12>Build log was saved at "file://k:\\MaNGos\\git\\win\\VC90\\script__Win32_Release\\BuildLog.htm"

12>script - 1 error(s), 0 warning(s)

any ideas? I have done the clean build and tried compiling twice now, both times end with these lines.

The security problem with the config is most likely due to a firewall and/or a virus scanner. Try turning them off, configuring the MySQL server, then turning them back on. It's also possible that you may not have the permissions to do it (you need admin permissions to configure the server).

As for your compile issue try redownloading the source. Also; make sure you have the Microsoft C++ 2008 libraries and maybe even 2005 if 2008 alone doesn't work. It's also possible that this is also a permissions issue, I'm not sure, I've never gotten that error before.

Hope that helps!

This guide is great but because im complete noob in this sort of things i messed up somewhere.

When i try to run mangosd and relamd files i get: Cannot connect to the world database/Couldnot connect to MySql databse.

MySql server is runing and im connected with sqlyog so idk where is prob

I know i messed smething up,pls help me if you can,and don't lol as i said im complete noob with database work

That would be an issue with your conf files, make sure you changed the info correctly (do not include the square brackets that I had shown in my example).