Thread: [Guide] How to setup your arcemu server, Noob friendly tutorial with pic's

Well since there was that many complaints on my other guide, I updated to a brand new one and I tried to add the things you said me to. If you want anything more added I appreciate you send me a PM regarding this insted of flaming in the forums. This guide will show you have to setup your arcemu server with Windows server 2003 R2.

Programs needed:

• Tortoise SVN : [Only registered and activated users can see links. ]
• Microsoft Visual C++ : [Only registered and activated users can see links. ]
• .NET Framework 3.5 : [Only registered and activated users can see links. ] (Usually installed when installing C++)
• MySQL Server for Windows : [Only registered and activated users can see links. ]
• MySQL Database Manager : [Only registered and activated users can see links. ] or [Only registered and activated users can see links. ] (Not needed, but recommended)

Now I assume you have downloaded all the programs listed above. Run the wizard's thats following the programs, have any trouble installing this leave a reply!

Configure MySQL
When you are installing MySQL you will be asked if you want to configure the server now, choose yes. Now a new window called "MySQL Server Instance Configuration Wizard" open. You will get two options Detailed Configuration and Standar Configuration I suggest you choose standar.

Now we will get 3 options, you should know yourself what option that fits your server the best if you are unsure select server machine. Next you will get 3 more options choose multifunctional database. The next option you could just skip. Once more you will get 3 more options, this is not so important so if you are unsure what that suites you best choose the first option. The next option will let us configure the port mysql is gonna run on. Default is 3306 DO NOT EDIT THIS UNLESS YOU ARE AN ADVANCED USER! Comming up we will be able to choose the character set in the database here as the other options if you are unsure choose the first. Tip: if you want all the characters use the last option then utf8.(Only for detailed)

Now we are gonna choose the service name, default is MySQL. This option is critical, as this needs to be correct if not your server won't start. If you are unsure what to use here select MySQL501. Below that setting you will be asked for "Include Bin Directory in Windows PATH" check this and click next.

This option is the security part, this will be your MySQL password I suggest you set this to something that's hard to guess, in this guide I will only call it sqlpw. Remember to also check the "Enable root access from remote machines" if you want to connect to mysql from other desktops or you have an dedicated sql server. Next step is the finishing one click execute and wait for the wizard to complete if everything is right you will get something like this:



The mostly known error is that it couldnt start the service, if you get this go back the try change the service name to something else.

Obtaining the core:
For completing this step you need Tortoise or other svn clients to be installed. Remember to restart your computer / server after installing it. I will not go further in on how you do it, because it's mostly following the wizard and click next.

Now let's make a folder on your desktop named SVN Checkout, place it wherever you want.. Right click on the folder and choose SVN Checkout.



Change the "URL of repository" to svn://arcemu.info/svn/trunk and make sure the revision is set to head to get the latest version. Click OK to download the files, now this would take a while so be patient!

When this is done navigate to your SVN Checkout folder » win and open the file arcemuVC90.sln if you are asked about wich application you will open it in choose Visual Express C++. Let's configure the build options, in c++ select Build » Configuration Manager and change the Active Solution configuration to Release and click OK as shown on the picture:



Now we are ready to build the solution go Build » Build solution or push f7.
C++ will start working and after a while you will get this message:

Code:

========== Build: 6 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========

Make sure there isnt any errors when building, don't think off the warnings since they are not important. If you got any errors you did something wrong. Read the guide once more and double check the changes!

Configuration
I will only take you trough the basics / needed configs. First of all we need to get the config files, go to your SVN Checkout folder then move the configs folder to bin » Release as this is the folder where the project is builded.

arcemu-logonserver
Let's start off configuring the logon server open arcemu-logonserver.conf. Find these lines:

Code:

<LogonDatabase Hostname = "host"
               Username = "user"
               Password = "pass"
               Name     = "dbname"
               Port     = "3306"
               Type     = "1">

Hostname is the ip of the mysql server if the mysql server is located on the same desktop as your core this would be localhost. If you have followed this guide the Username will be root, following up with the password you sat before in this guide when innstalling mysql this would be sqlpw or whatever you choosed. Now we are going to decide the dbname, this is the database for your accounts! I choose to set this to arcemu_logon. Port is no needed to change if you not are an advanced user, default is 3306.

Code:

<Rates AccountRefresh = "600">

This will configure how often the server will refresh the accounts. Personaly this is set to 150 on my server because then the users dont have to wait too long before their account works.

Code:

<Client MinBuild = "9551"
        MaxBuild = "9551">

MinBuild is the minimum build the client is required to have installed to connect to the server and MaxBuild is the max revision.

Code:

<LogonServer RemotePassword = "change_me_logon"
             AllowedIPs = "127.0.0.1/24"
             AllowedModIPs = "127.0.0.1/24">

This will configure the permissions on what server that's allowed to connect to the logon server, I assume you have the world and the logon server placed on the same desktop so the only thing you have to change is change_me_logon this is the password for the logonserver. Not so important but it gotta match the one in the world config so let's call it logonpw or whatever you want.

arcemu_realms
Now we need to configure our realm options, to do this we start with open the config file called arcemu-realms.conf.

Code:

<LogonServer Address = "127.0.0.1"
    Port = "8093"
    Name = "Default Logon"
    RealmCount = "1">

First we need to configure the logon server not any needed changes but I recommend you change the Name if you want multiple realms.

Code:

<Realm1 Name = "Test Realm"
    Address = "127.0.0.1:8129" 
    Icon = "PVP"
    Population = "1.0"
    TimeZone = "1">

Realm1 Name is the name of your realm, change this to what you want the realm to be called. The only needed change here is the Address if the server is going public you need to change this to your extern ip, hamachi ip or whatever.

arcemu-world
Well let's finish it with the biggest configuration file of them all, open arcemu-world.conf and find:

Code:

<WorldDatabase Hostname = "host" Username = "username" Password = "passwd" Name = "database" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "host" Username = "username" Password = "passwd" Name = "database" Port = "3306" Type = "1">

This is the database details for your world and character database. The hostname by default will be localhost unless if you have an dedicated mysql. The username will be root and the password you defined several times earlier in the guide this will be sqlpw or whatever you called it. Now the name for the WorldDatabase will be arcemu_world or change it to what you want and the CharacterDatabase will be arcemu_char you could customize this as you want. Still the port is 3306 if nothing else is defined.

Code:

<LogonServer DisablePings = "0"
             RemotePassword = "change_me_world">

Change the RemotePassword to logonpw or what you defined in the arcmeu-logonserver.conf.

Code:

<scriptBackends LUA="1">

This would define if the server is gonna load the LUA scripts in the /scripts folder or not. 1 = Yes, and 0 = No.

This file let's you configure so much more, but it's not needed to get your server up so change it as you want. Remember to be careful when doing this and don't make any big changes the server may not start if you did something wrong!

Inserting the data
It's several options on how to do this the best way is to do this with cmd (command prompt). First of all we start off downloading a world database I recommend NCDB, [Only registered and activated users can see links. ]. Now that's download extract it to where you want, I will show you how to do this with navicat as that's the easiest way. Open Navicat and click "Connections" and fill in the information as you probably should know by now. Open the connection and create a database called arcemu_world or what you defined in the configs. Right click on it and choose Execute Batch file, browse and find your NCDB extracted file then push execute.

Now create a database for the accounts call this arcemu_logon or what you called in your configs, do it as the same way as you did on the world just change the file to SVN Checkout folder » sql » 1913_logon_structure.sql. Almost the same on the characters create an database called arcemu_char or what you defined in the configs and execute the file 1981_character_structure.sql.

Well now that's done we need to update all the database navigate to SVN Checkout folder » sql » utilities and run the ArcEmu DB Updater.bat. Fill out the info required as you should know by now. When it's done choose the option for innstalling all the updates!

That's a rough explenation as I'm getting pretty tierd of writing at this point, if you need any more help on how to do this checkout my video guide in the bottom of the thread.

Additional DLL files
If you are having issues running arcemu-world.exe or arcemu-logon.exe, then you may need to copy the following files into your Ascent directory ("C:\Arcemu") from /trunk/bin/release, (collision from /trunk/src/collision/)

• libmySQL.dll
• libea32.dll
• collision.dll

After having done so, you should be able to run the .exes sucessfuly. (The locations of the files are garunteed to atleast be in /trunk/ or one of its branching folders.)

How to compile the DBC and map files (from the wiki):
QUOTE
Required Programs

Ad.exe - [Only registered and activated users can see links. ] (Password is 'ascent', without quotes)
MPQE - [Only registered and activated users can see links. ] (Password is 'ascent', without quotes) [Only registered and activated users can see links. ]


You must have the Microsoft .NET Framework installed for MPQE to run, .NET Framework 3.0 is available for download here.
DBC Files

NOTE: (This tutorial is made under a "enUS" client. If you have another client (like esES, enGB, frFR), change the "enUS" to your client's language)

NOTE: If you use the version from SVN, it includes a batch file that allows you to select your client locale at runtime.

* Create a directory for your .dbc files in the ArcEmu server directory. ("C:\arcemu\DBC")
* Extract the MPQE archive into your World of Warcraft data directory ("C:\World of Warcraft\data\enUS"). Then copy the 3 files (MPQE.exe, MPQE.vshost.exe and SFmpq.dll) in the ..\Data\enUS\MPQE directory to the ..\data\enUS directory.
* Open notepad and type in the following:

mpqe /p locale-enUS.MPQ DBFilesClient\*.dbc

* Save it as ("dbc.bat") in the WoW data directory ("C:\World of Warcraft\data\enUS") and then run it. (NOTE: YOU MUST SAVE IT AS A BATCH FILE (.bat) FOR THIS TO WORK
* mpqe will now extract the dbc files to a new directory in your client's data\lang directory called ...\enUS\MPQOUT\DBFilesClient. ("C:\World of Warcraft\data\enUS\MPQOUT\DBFilesClient")
o You should see it reference two or three files: "patch-enUS.MPQ", and "locale-enUS.MPQ" and most likely "patch-enUS-2.MPQ".
* When mpqe has completed, copy the content all of the .dbc files from the output directory listed in the previous step to your server's DBC directory ("C:\arcemu\DBC"). You should have 178 .dbc files, total filesize roughly 45 MB (183 files, ~43 MB after updating WoW to v2.4).
* If you run Linux you should place the DBC folder in the bin folder. Make sure that the directory name is uppercase; do not change the case of extracted files.
* You may now delete the client output directory ("C:\World of Warcraft\data\MPQOUT") if you wish.

Map Files

* Place ad.exe into the client's root directory. ("C:\World of Warcraft")
* Create a subdirectory called 'maps'. ("C:\World of Warcraft\maps")
* Launch ad.exe. This will begin the extraction of map files. (This can take a long time depending on your system, typically around 30 to 60 minutes.)
* When ad.exe has finished, move the folder "C:\World of Warcraft\maps" and paste it in your Ascent server directory ("C:\Arcemu"). So you should now have a "C:\Arcemu\maps" directory containing numerous .bin files.
* If you run Linux, the maps folder should be placed in the bin folder. Make sure that the directory name is lowercase.

Now that's done you need to copy or move all the files in bin » release folder to another folder (whatever). Now you got your own server run arcemu-world and arcemu-logon.exe if you get any errors doing this leave and reply.

Also feel free to correct me if I forgot something, or did anything wrong. But please don't flame this it's an hell of an work to write this entire guide, so I think you guys should be happy.

Updating the core

This is quite easy, if you know how to compile the source you almost know how to update it aswell. First of all we need to update from SVN. Go to your arcemu folder (the one you downloaded from SVN, the open source) right click and you will see something like this:



You will see something like this, choose the SVN Update as shown and a window similar like the one when you downloaded will appear.

When all the files are downloaded navigate to trunk»win and open the arcemuVC90.sln file, and rebuild solution. This will also take so time so be patient.

Now i assume you have done that you should navigate to the release folder if you don't remember it's trunk»bin»Release. Copy the arcemu-world.exe and arcemu-logon.exe and paste it in your main server directory. It will ask if you wanna overwrite existing files, then choose YES.

That's everything you have to do, but in some updates there are SQL update's aswell. Go to your trunk»sql folder and run the character_updates, logon_updates and world_updates, but only the one that's greater then your last revision.

character_updates and logon_updates should be placed in the chardb
world_updates should be placed in the worlddb

Tip: you should not download every revision, just if you see something critical or good has been changed. Make sure you read the [Only registered and activated users can see links. ] before you update.

Updating the revision
In most of the wow patche's they do nothing with the server core, so we can update our server easily without downloading anything, just follow my easy step's and you will be done in 1,2,3.

First we need to locate our logon config file, this is located in your server main folder/configs open it and find:
QUOTE
<Client MinBuild = "9100"
MaxBuild = "9551">

Min build : defines that the client need 9100 or higher
Max build : defines that the client can't have a greater build then 9551

Now only change the maxbuild to the current revision. This could easily be found when opening your wow client, look down in the left corner and you will see something like this: Version 3.0.9 (9551)(Release)

Version is the current patch and 9551 is the revision. When updating to the latest build just put 9551 or whatever that stands there into MaxBuild.

Some usefull builds:

Wotlk 3.0.8a : 9506
Wotlk 3.0.9 : 9551

I've followed your guide but at the end arcemu-world.exe says:"one or more DBC files missing" just after "loading DBC/achievement_category.dbc". I searched for that file and there isnt. so what do I have to do?
really good tut though. thx

Originally Posted by hornobster

I've followed your guide but at the end arcemu-world.exe says:"one or more DBC files missing" just after "loading DBC/achievement_category.dbc". I searched for that file and there isnt. so what do I have to do?
really good tut though. thx

You can download DBC files with newest compiles of ArcEmu here:

[Only registered and activated users can see links. ]

how do is start the servers

Originally Posted by gangboy70

how do is start the servers

Download fresh ArcEmu compile... you have link on upper post.

i'm stuck on the bit when u start with navicat, everything else is fine, but i just don't understand it when u reach navicat :S also it's my first time trying this so any help would really be appreciated, also where is the video of this?

thanks

Link is dead.

Originally Posted by jz007

Link is dead.

Which link is dead ?