How to setup your Ascent/ArcUm Server from scratch

[Helarion]

Sorry if reposted.
Tired off all those repacks? So am i.
Sorry about the pictures, theyre hosted on my dedicated WoW Server, and sometimes (On server restarts), they will be gone
You will need:
If you have a 32 bit OS:
http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-5.0.67-win32.zip/from/http://mysql.mirrors.hoobly.com/ (MySQL)
and
http://downloads.sourceforge.net/tortoisesvn/TortoiseSVN-1.5.3.13783-win32-svn-1.5.2.msi?download (TortoiseSVN)
If you got a 64 bit OS:
http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-5.0.67-winx64.zip/from/http://mirror.x10.com/mirror/mysql/ (MySQL)
and
http://downloads.sourceforge.net/tortoisesvn/TortoiseSVN-1.5.3.13783-x64-svn-1.5.2.msi?download (TortoiseSVN)

You will also need Downloads
Search for C++ Express Edition
and you will need http://www.navicat.com/download.php?id=1
You need to install C++ Express Edition and Navicat yourself, its easy, not gonna explain.

Once you have downloaded them, open the TortoiseSVN installer
Press the Next button


U get to the next screen, Press "I Accept the tems in the License Agreement" and press Next.


Press Next.


Press Install. Wait till u get to this screen


Press Show Changelog, so it's not on. Now press Finish.


Last screen. Press No, we will restart it later.

[Helarion]

Now open up the MySQL installer. It's in a .zip file, unzipp it.
Press Setup.exe
Press Next.


Select Typical and press Next >


Now press Install.


Make sure the Configure button is enabled, and press Finish

Another should start. Press Next >


Make sure those 2 buttons are enabled, and press Next >


Type your password twice. In this example, we use "tutorial"
Make sure the "Enable root access from remote machines" is enabled. Press Next >


Now press Execute.


This message should come up. Press Finish.

Now, restart your computer. Remember to put this post in your favorites

[Helarion]

Make a folder somewhere on your computer. In this case, we name is WoW Source. Right click it, and press SVN Checkout


Now, if u want the ArcEmu source (Recommended), Do this:

svn - Revision 1076: /
For Ascent, its http://mmoforge.org/svn/ascent/trunk
Press OK

Now, go make a cup of coffee, watch some TV, make another cup of coffee, have dinner. Now it should be done. U will get something like this:


Arcemu:
Browse to D:\WoW Source\branches\extras\arcemu-windows-libraries
In case of Ascent, search the libraries on google or something.
Open ReadMe.txt, and do everything described there

Now thats all done, browse to D:\WoW Source\trunk\win
Or, in case of Ascent, D:\WoW Source\win
Open arcemuVC90.sln
Now, this pictures are taken from my dedicated server, because i didn't want to install a C++ compiler on this computer.

Make sure its set on Release, and for a 32bit OS: 32bits, and for a 64bit OS ofcourse, 64bit. Now press F7

Next image: When its all done u should have this

I censored it, it would be advertising

[Helarion]

Now you are almost done. Browse to D:/WoW Source/trunk/bin/Release/
You will see all the compiled files here

ArcEmu:
Open another Windows Explorer, and browse to D:/WoW Source/trunk/scr
Copy the Configs folder to your release folder.
You should have D:/WoW Source/trunk/bin/Release/configs

Ascent:
Open another Windows Explorer, and browse to D:/WoW Source/trunk/scr
Copy the .conf files to your release folder.
You should have D:/WoW Source/trunk/bin/Release/ , with all your .conf files in it



Open logon-arcemu.conf or logon-ascent.conf
Change this:

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

To

<LogonDatabase Hostname = "localhost"
Username = "root"
Password = "tutorial" # The password u entered at the MySQL installation
Name = "logon" # Name of logon database, default is logon
Port = "3306"
Type = "1">

Change
L

ogonServer RemotePassword = "change_me_logon"
AllowedIPs = "***MUST BE COMPLETED***"
AllowedModIPs = "***MUST BE COMPLETED***">

To

<LogonServer RemotePassword = "tutorial" # Your MySQL password
AllowedIPs = "xx.xxx.xx.xxx/24" # You need your external ip on those. Im sure you can find it on google (Whatsmyip.com)
AllowedModIPs = "xx.xxx.xx.xxx/24"> # Same
Now open arcemu-realms.conf or ascent-realms.conf

Change Code:

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

To

<LogonServer Address = "xx.xxx.xx.xxx" #External IP again
Port = "8093"
Name = "Default Logon"
RealmCount = "1">

Also change

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

To

<Realm1 Name = "Your realm name"
Address = "xx.xxx.xx.xxx:8129" # xx.xxx.xx.xxx = External IP again, leave the :8129 there
Icon = "PVP"
Population = "1.0"
TimeZone = "8">

Now open world-arcemu.conf, or world-ascent.conf
Change

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

To

<WorldDatabase Hostname = "xx.xxx.xx.xxx" Username = "root" Password = "tutorial" Name = "ascent" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "xx.xxx.xx.xxx" Username = "root" Password = "tutorial" Name = "logon" Port = "3306" Type = "1">

You know what i mean right?

You can configure everything yourself now.
For the database:
Make another folder, in our example we name it WoWDB
Use the SVN Checkout option again, use http://svn2.assembla.com/svn/WhyDB
Wait, wait, wait some more.

[Helarion]

Open up Navicat Lite.
Press Connection
Now fill in this stuff:




Also make a databse called Ascent

Now, open the Logon database. Do this.

Got it?
On the Batch File prompt, browse to D:\WoWDB\development\ascent_char\empty_logonserver .sql and press Execute
When its done, do the same with D:\WoWDB\development\ascent_char\empty_character.sql

Now open the Ascent Database, Execute batch file, and browse to D:\WoW Source\database\development\ascent_world
Execute ALL THE SQL's! Yes, i know its long.

We will now extract the map files.
Download enUS Map Extractor if your WoW client is enUS,
or enGB Map Extractor if your wow client is enGB
Place ad.exe into your World Of Warcraft directory, and make a folder in your World Of Warcraft directory called "maps".
Then run ad.exe and it will extract the maps. Move the Maps folder to your Release folder
DBC extractor
Download this DBC extractor and follow the instructions in the readme. Move the DBC folder to your Arcemu Release folder

Now you can start your server! Goto D:\WoW Source\Trunk\bin\Release\ for Arcemu, and D:\WoW Source\bin\Release for Ascent
Start arcemu-logonserver.exe, and arcemu-world.exe

Goto C:/Program Files/World of Warcraft/ , open Realmlist.wtf with notepad, and set it to:
Set Realmlist xx.xxx.xx.xxx , where xx is ofcourse your external ip. This way all your friends can connect!

Start flaming now

[nikey_007]

nice guide will use the empty db to create my own repack. +rep

[_DEFiANT]

Yes, this is nice. (Even though there has been a few posts before)
+Rep for contributing

[Helarion]

Thanks for your support

[ffdevil]

nice, understandable, complete. WTG & thanks

[Nick_Da_Maco]

Nice guide, might use it

i like how you have lots of pictures easy and simple to understand
Good Job,

[ffdevil]

fyi a link for new updated 2.4.3 maps - MEGAUPLOAD - The leading online storage and file delivery service (credit to frigger908 via master)
And from Nitt @ (another site)a link for ascent library in your read me/ascent-windows-libraries.rar - Filebeam - Free Fast File Hosting (Filebeam - Free Fast File Hosting)
And a personal guide fr it @ GUIDE → Installing Ascent Libraries - WoWps Forum
Like I said, Im a BIG NOOB so I dont know if this is ok to put here, but it goes well with your info, and I had probs with my maps.

[Nightmorder]

+Rep +Rep +Rep +Rep

[ffdevil]

do you have any idea why i cant extract my maps? it gets to about 560, then aborts process.

[stoneharry]

Well after 3 days of reading about C++ and looking through files, I managed to compile my own server with this guide and a couple on Arcemu.org, so +Rep x2

[Yah]

How can i find the pass for http://mmoforge.org/svn/ascent/trunk