[Guide] Mangos Windows Setup

[Fyurie]

For the benefit of anyone else with the same problem, I'll put an answer here. The config files, from my experiences, won't accept a blank password. I don't know the technicalities behind it, so I won't begin to try and explain.

Basically, just be sure to set yourself a password when setting up MySQL.

[wagnus]

Yet that was the issue - now i have a new one:

My DB's are fucked - when i was updating them i got a ton of errors in characters and realmd also a new now and then in mangos.

I have tried twice now but i still get errors. Is there some magical MySQL dump with the latest updates so i can see if my mangos is build right.

[Fyurie]

Well, you could start by showing us the errors you're getting in MySQL. We can't help if we don't know what's up.

[thechiefrock]

Config mangosd.conf

DataDir = "data_dir"

LogsDir = "logs"

Put the maps,vpaps,dbc folders in data_dir directory.

Then config realmd.conf

LogsDir = "logs"

Logs folder is for logs from the server.

i did what you right, but i still get the same error

/maps/0004331.map' is non-compatible version (outdated?). Please, create new using ad.exe program.

[pitestinet]

i did what you right, but i still get the same error

/maps/0004331.map' is non-compatible version (outdated?). Please, create new using ad.exe program.

Copy ad.exe from source folder\\contrib\\extractor\\ to world of warcraft 3.3.2 folder and then run it. Let him finish the session . Another folder named maps will be created. Copy maps folder to mangos compiled folder in data_dir

[teotaker]

HI all,

i created successfully my own private server on lan in 3.3.0a version, but i don't understand why when i log in my game starts downloading an uptdate. Of course i'm not using the launcher but the wow.exe.

If someone get a solution i will be happy. Despite my efforts to browse any tables i didn't find why this happens.

thank for your helping.

[Fyurie]

Easiest thing I do to stop that is change my set patchlist in realmlist.wtf to:

set patchlist 127.0.0.1

Works most of the time.

[teotaker]

Doesn't work for me . That's weird, i'm supposed to be in Lan and I can't enter into my server. Everything works fine except that.

does it exist any command or any value needs to be change in table in DB in order to disable this?

[Unkle Nuke]

If that does not work, and you're using Windows, you can edit your HOSTS file to redirect any of the patch server IPs to the localhost or 127.0.0.1 loopback.

Downside to this is you would also be unable to connect to the company's patch servers if you were trying to download a patch through your web browser, as all attempts to do so are redirected back to your own computer, regardless of what software you're trying to connect with... not just the game.

[vladex]

i had that kind of problem 2 when i first entered to mangos but you can fix it by adding your IP or Dns adress to the realmd db and you should be able to connect with your dns adress to the server

also change BindIp line in mangosd.conf and realmd.conf

dont know if it will help but just a +info

[pitestinet]

[Guide] Compiling and installing Mangos on Windows: 27 February 2010

-MaNGOS now supports 3.3.2

-MaNGOS source version 0.16-dev1

What do you need:

-WoW client updated to 3.3.2

-MySQL server community edition (download here

-Mysql Administrator (for upload “ytdb database” on server in “mangos database”

(download aici

-Navicat client download here;

-GIT client (for download git repository)

download here

-TurtoiseSVN (to download Ytdb database)

32 bit edition - download here

64 bit edition - download here

-Microsoft Visual C++ 2008 Professional Edition.

Getting the MaNGOS source files

-Install your GIT client if you haven't already

-Once installed, make a folder anywhere and call it whatever you want (this will be your MaNGOS source folder so you might want to call it "MaNGOS" or something)

-Right click your new folder and select "Git GUI Here"

-When the GIT GUI window comes up, click on "Clone Existing Repository"

-Another window should pop up

-In the "Source Location" field, type in:

Code :

git://github.com/mangos/mangos.git

-In the "Target Directory" field, type in the filepath of your folder (e.g. C:\\MaNGOS)

-Click "Clone" and wait for it to finish

-Once it's done, close the GIT GUI

Getting the YTDB source files

-Install your TurtoiseSVN client if you haven't already

-Once installed, make a folder named “YTDB” somewhere (not in mangos source folder)

-Right click your new folder and select "SVN Checkout"

-Another window should pop up

-In the "Source Location" field, type in:

Code :

 [url]http://svn2.assembla.com/svn/ytdbase[/url]

-In the "Target Directory" field, type in the filepath of your folder (e.g. C:\\YTDB)

-Click "Ok" and wait for it to finish

-Once it's done, close the TurtoiseSVN Client

- You will find the last database and Updates on YTDB/R53/

-Extract the archive from R53 : YTDB_0.10.9_R530_MaNGOS_R9225_SD2_R1553_ACID_R302_RuDB_R34.8.rar

Compiling MaNGOS

-Go to your Mangos compile folder, then into the "win" folder

-Open the "VC80.sln" file, or for 2008 users "VC90.sln".

Mommentaly don’t support 2010 edition.

-Click "Build" in the menu and select "Configuration Manager"

-Click "Release" in the drop down box for "Active Solution Configuration"

-The "Active Solution Platform" should be set to "Win32"

-Then, click "Build" in the menu and select "Build Solution"

-If you get any errors, click "Build" in the menu and select "Clean Solution", then restart the compile

-Note: this WILL take a long time - You might get some warning messages...If you don’t have any error that is done and you can go to the next step.

Installing MaNGOS

- Mangos core folder will be in source folder/bin/win32_release/

 - Rename the file from src/mangosd/ mangosd.conf.dist.in to mangosd.conf

 - Rename the file from src/mangosd/ realmd.conf.dist.in to realmd.conf 

-Copy realmd.conf and mangosd.conf to core folder.

-Then copy all files from core folder to another folder named core-mangos(don’t place core-folder in the source folder)

Exracting maps and DBC files

-Go back into your MaNGOS source folder, then into the "contrib" folder, then into the "extractor" folder

-Place the "ad.exe" application in your World of Warcraft folder

-Run it and wait for it to finish (can take a while)

-Make two new folders in your MaNGOS core folder (note: not your source folder, the core folder is where you put all the .dll, .exe (etc.) files), one called "data_dir" and one called "logs" then create another ones in "data_dir" called "maps" and "dbc"

-Copy the extracted dbc files into the dbc folder and the maps into the maps folder.

Installing the MySQL server

-Run the setup file

-Choose "Typical" setup when asked

-When the installation is finished, you're going to be asked if you want to configure the server; make sure that's checked off

Configuring the MySQL server

-Choose "Standard Configuration" when asked

-Check off "Install as Windows Service" and "Launch MySQL Server Automatically" when asked (the name of the service should be "MySQL")

-Choose "Modify Security Settings" when asked

-Type in a password, make sure it's one you will remember (Note: Default server password is mangos, use that if you are not putting your server online for other players)

-If you plan on having a registration page on another machine, or plan on being able to access the database from another machine other than the one the databases are hosted on, check off "Enable Root Access from Remote Machines"

Setting up the databases

-Run Navicat

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

Creating databases

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

-Right click on your mysql database from connection and “Open database”

-Right click again but now use “New database”

-For the database name type in "realmd"

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

-Drop the database”test”.

Upload your databases

-To upload just right click on the database you want and "Open database"

-Now, in the left-hand database list, right-click "realmd" and click "Execute Batch File"

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

-Click "Start"

-Repeat same things for “mangos” and “characters” database.Upload all updates.

Upload YTDB database

- Install Mysql Administrator if you don’t installed first.

- Open Mysql Query Browser from the installed folder.

- One windows will appear and you will complete like this:

Server Host put localhost or server ip/address 

Username root

Password the password you put for database

- Then “Ok”

- Double click on mangos database on right.

- The menu “File” and “Open Script”

- Select from YTDB/R53/ YTDB_0.10.9_R530_MaNGOS_R9225_SD2_R1553_ACID_R302_RuDB_R34.8.sql

- Then “Execute” and wait until the operation will finish.

- At least close Mysql Administrator.

- Upload the updates from YTDB/R53/Uplates with navicat.

Configuring MaNGOS

-Go into your Mangos core folder

-Open mangosd.conf in Notepad

-Look for the part "DataDir ="

-Make sure it looks like the following:

Code :

Datadir="data_dir"

Code :

Logs="logs"

-Look for the following codes (and change them as necessary):

Code :

WorldDatabaseInfo = "localhost;3306;root;[sql password];mangos"
   LoginDatabaseInfo = "localhost;3306;root;[sql password];realmd"
   CharacterDatabaseInfo = "localhost;3306;root;[sql password];characters"

-Save, exit

-Go back into your Mangos core folder

-Open realmd.conf in Notepad

-Look for the following code (and change it as necessary):

Code :

  LoginDatabaseInfo = "[server IP];3306;root;[sql password];realmd"

  Logs = "logs”

-Save, exit

Setting up your client for use with your server

-Go into the folder where you installed WoW

-Go into your "data" folder

-Go into your locale folder (it's going to be named something like "enUS", "enGB", "frFR", "deDE", etc.)

-Open realmlist.wtf in Notepad and change the contents to the following:

Code :

set realmlist [server IP] or 127.0.0.1 for localhost.
   Running your server
   -Go into your MaNGOS core folder
   -Run mangosd.exe and realmd.exe
   -Everything should work fine unless you did something wrong

   Errors
   -If you get an error that says something like "sql was probably updated" or "# fields, # missing", then you need to update your database and possibly your entire core
   -If you get any map or dbc errors, make sure that the "datadir" field is set to "data_dir" (in mangos.conf) and that your dbc and map files are up-to-date with your client in your MaNGOS core folder

   Creating Accounts Without a Registration Page
   -Once everything in mangosd.exe has loaded, type-in the following (with some cores there is tons of text flooding the command prompt; not to worry, keep typing anyway, it doesn't matter) :

   Creating the actual account
   Code :
   [code]account create [username] [password]

Example:.account create Adminmangos 123

Enabling expansions for a user

Code :

account set addon [username] [1 for TBC, 2 for TBC and WotLK]

Example: .account set addon Adminmangos 2

Changing GM levels

Code :

account set gmlevel [username] [anything from 0 to 3, 3 being administrator, 0 being player]

Example:.account set gmlevel Adminmangos 3

Congratulations! You're now ready to play on your very own private server.

[sisole2]

i got a problem . i have installed all updates and i am 100% sure all is updated to max. i have see the db_version table for sure ,but when i am trying to start mangosd.exe or realmd.exe its start and clouse in 1 second . i dont have a server.log to see the error please help

[reddmachine82]

There should be a total of four log files where your mangos executables are: realmd, char, dberrors and server...hope this helps.

[sisole2]

i did not find anything about log for server crash ( btw is that normal my Mapts folder be 236 mb and dbc folder is 86 mb

[sisole2]

i dont find the log files but i have seen Extremly hardly the error .there is writen "cant find the realmd.conf. file" after that the server desapear..There is a realmd.conf. but why dont want to start ?

[Hubert]

There are an error:

- Rename the file from src/mangosd/ realmd.conf.dist.in to realmd.conf

the correct is

- Rename the file from src/realmd/ realmd.conf.dist.in to realmd.conf

Another question is that, with YTDB I have no NPCs (animals, quests, etc); only my character :confused:

[sisole2]

nothing helps ;((( . any other ideas ? Q_Q i am gonna kill myself

[Hubert]

sisole2: Check if your system (explorer) hide the extensions; if is that, you will see "realmd.conf" but really is "realmd.conf.in"

You can check it using the DOS shell or changing explorer' settings.

[sisole2]

THANK you very much ;( ;( i have tryed 2 days .. you are god .My leader god =D. every1 with this problem Hubert is the reason

[sisole2]

i gotta new error ;( .THe error with maps (0004331) i have readed all 30 topics for this error . everywhere problem is reason the old ad.exe. but i am with freshly new . i have tryed all ad.exe and nothing work ;( damnn

[Hubert]

Mm… Do you have the last version of WoW and all the patch applied? I have used the "ad.exe" from the "contrib\\extractor" path and worked well (+5000 files extracted). Then, I move ( manual cut&paste ) the directories "dbc" and "maps" to inside the path set at the "mangosd.conf" file, on the DataDir variable.

[sisole2]

yes my WoW are the latest patch 3.3.2 (11403) release . i have moved maps and dbc into folders into the server .. all right like the guide said.ad .exe is from this guide . i tryed many other from 10 topics but nothing succed

[tan99]

Hi,

i have use UDB as the mangos database. I update the database. But if i start mangos i get this:

2010-02-28 19:47:13 MaNGOS/0.16.0-DEV (* * Revision 9480 - *) for Win32 (little-endian) [world-daemon]

2010-02-28 19:47:13 <Ctrl-C> to stop.

MM MM MM MM MMMMM MMMM MMMMM

MM MM MM MM MMM MMM MM MM MMM MMM

MMM MMM MMM MM MMM MMM MM MM MMM

MM M MM MMMM MM MMM MM MM MMM

MM M MM MMMMM MM MMMM MMM MM MM MMM

MM M MM M MMM MM MMM MMMMMMM MM MM MMM

MM MM MMM MM MM MM MMM MM MM MMM

MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM

MM MM MM MMM MM MM MMMMMM MMMM MMMMM

MM MMM http://getmangos.eu

MMMMMM

2010-02-28 19:47:13 Using configuration file mangosd.conf.

2010-02-28 19:47:13 World Database: 127.0.0.1;3306;root;mickey;mangos

2010-02-28 19:47:13 MySQL client library: 5.0.56

2010-02-28 19:47:13 MySQL server ver: 5.1.41-community

2010-02-28 19:47:13 ERROR:SQL: SELECT required_9477_01_mangos_spell_proc_event FROM db_version LIMIT 1

2010-02-28 19:47:13 ERROR:query ERROR: Unknown column 'required_9477_01_mangos_spell_proc_event' in 'field list'

2010-02-28 19:47:13 ERROR:Table `db_version` have field `required_9310_01_mangos_spell_elixir` but expected `required_9477_01_mangos_spell_proc_event`! Not all sql updates applied?

What do i wrong??

greetz

Tan99

[pitestinet]

2010-02-28 19:47:13 ERROR:Table `db_version` have field `required_9310_01_mangos_spell_elixir` but expected `required_9477_01_mangos_spell_proc_event`! Not all sql updates applied?

man you dont upload all updates for mangos database.

[tan99]

do i have to apply all sql files in the folders: 0.5 0.6 0.7 0.8 0.9 0.10 0.11 0.12 0.13 0.14 0.15 ????