[GUIDE] Setup ascent with WAMP

**mollusk** · 12-19-2007

Setting up ascent with WAMP

To start get Wamp here ---->Install PHP 5 Apache MySQL on Windows : WampServer

1.With wamp open, left click on the system try icon in the bottom right hand corner by your system clock in windows xp or vista.

2.Once you do that it should say at the bottom of the options menu put online.

3. after that left click on wamp icon just like you did in step one and hover your mouse cursor over mysql and choose MySQL Console.

4.Once the command box comes up type: SET PASSWORD FOR root@localhost=PASSWORD('your_password');

5.Where it says your_password between the quotes just enter the password you want then hit enter on your keyboard.

6.After that open up either navicat, sqlyog or heidisql. I use sqlyog.

7.Once sqlyog is open click new in the upper left corner of the connection window. Enter your password and in the databases box enter ascent2;logon2 It doesn't really matter what you name them as long as you execute the sql files in the right ones.

8.When you click connect after following step 7 sqlyog will ask you if you want to save this connection. Click yes.

9. Now you will notice to the left frame there it will list the databases you just connected to. At this point they don't exist.

10. In the same left frame you will notice at the top of that frame it says root@localhost.

11.Right click that and choose create database. Then enter ascent2 or the name of the database you have connected to. Do this again for the logon database.

12.Now right click on ascent2 and choose restore from SQL dump and then click the tiny button with the ... in it and find the ascent2.sql file you have saved on your computer wherever you may have put it. Once you find it double click it.

13.Now click execute and the sql file will then be entered into the ascent2 database. Do this step again for the logon2 database.

14. Then right click on root@localhost and select refresh object browser.

15.Now right click on logon2 and choose view data which is near the very bottom.

16.Now look to the right frame and you should see something like this

17.You need to make it look like this:

After your done save it which is shown in the image. This is your admin account. The gm row is set to az to enable admin powers.

18. Now your almost done but you need to configure your ascent and logonserver CONF files which are located in the folder called release which is where the SQL files were before in earlier steps. Once inside the release folder click on the ascent.

19.Once inside the ascent folder find the file called ascent.conf. If this is the first time you are doing this windows will not know how open the file. Click the file and when windows asks you how you want to open the file choose select a program from the list and press ok then look for notepad and use notepad to open it.

Once inside the ascent.conf look for where it says:

Then in the part where it says world database look for where it says Password = "ascent" and change it to whatever the mysql password you set from before. Next under the worlddatabase code you will see character database with the same Password = "ascent" change the password again. directly to the right of that you'll see it says Name = "ascent2" change this to logon2 then save the notepad.

20.Next while still inside the release folder find logonserver.conf and open it.

21.Once inside look for where it says:

Change where it says Password = "ascent" and yet again change it to what the mysql password you set before. Now save the file

22. Next inside the release folder you will see another file called realms.conf. Open and scroll to the very bottom. and look for this

Where is says <Realm1 Name = "Timmyvacc's Repack" is the name of the realm people will see and connect to. You can name this whatever you want. Make sure you dont erase the quotes. Now if you just want a personal server leave alone where it says Address = "127.0.0.1:8129" OR you can change this to your internet ip address which you can get from IP Chicken - Whats my IP address? ip address lookup
Be sure not to erase the :8129 part or else it wont connect to the port.

NOW YOUR DONE!!!!

Although you may need to port forward if you have a router. I know how to do this with linksys routers but not others. If you have a linksys router you can PM me and ask.

23. Now before you launch your server you may want a restarter? This can be done many ways but i prefer using batch files. I have premade batch files which you may get here -----> Filebeam - Free Fast File Hosting

The way this works is instead of clicking on the actual exe files you click on the batch files. If you want you can make shortcuts to them on your desktop. One thing I have found is if the server does actually crash it wont restart until the microsoft error reporting box is closed.

To turn this off right click on My Computer and select properties at the bottom of the options menu. Click on the advanced tab and look at the bottom of the window where it says error reporting and click it. Next check the dot next to disable error reporting and if you want uncheck the box next to "but notify me when errors occur" I am not sure if the actual error box that pops up stops the restart of the server or not so this is optional.

24.Next click my computer/local disc C:/program files/World of Warcraft and find the file called realmlist.wtf

25. Same as before, click the file choose program from the list and find note pad then click ok. You will notice inside realmlist.wtf is says

set realmlist us.logon.worldofwarcraft.com
set patchlist us.version.worldofwarcraft.com

Change the us.logon.worldofwarcraft.com to the ip you got from IP Chicken - Whats my IP address? ip address lookup and save the file.

and thats it you can now click your ascent.bat and logonserver.bat (which are the server restarters) and login using the admin account you set up earlier.

NOTE: If your IP address changes a lot you may want to head over to DynDNS -- Dynamic DNS, E-Mail Delivery and Other Services and get an IP host name so that you wont have to change all your ascent config files every time your ip changes. For help on that please PM me.

I hope this helped anyone who was confused. I find this way less of a hassle when i already have things such as a website running and do not want to shut it down to open a mysql service included in a repack. This way may take a little longer but I think it's worth the effort in the end.

If you find something wrong with this guide or are having problems please PM me.

Im sure this will be moved to somewhere else for I was not planning on making a guide just now but ended up continuing to type.

My goal in this was to make an easy noob proof guide so let me know if it worked.

Thanks, Mollusk
(A.K.A Silvernode)

P.S. You can use wamp or follow this guide for setting up any ascent server provided you have the actual SQL database files instead of a pre-packed mysql database.