[Tutorials for Noobs] How to setup a private server and make it public(+ Extra's)

R3dW3r3W0lf · #1 (**permalink**) 10-28-2008, 05:25 AM

OK, There are most likely hundred's of tutorials out there but from my perspective, i can tell people what they can and what they can't change. In This tutorial, it will cover the following:

1. Putting up a server(Private)

2. Editing it

3. How to run it

4. The Equipment that would be useful

5. What makes a good server

6. How to make it public

7. Advertising

Now most people think it's the hardest thing in the world but In Fact, It's one of the easiest processes in the world. You Don't even need to practically lift up a pinky. Sure the editing and building is time consuming but once your server is fully public and people are flocking in, it will be worth it. Ok so lets get started shall we. One more thing, This Tutorial was fully typed by R3DW3R3W0LF along with Pictures. The pieces and everything in this tutorial wasn't made by me but i typed the tutoral, and i am the one who did the research. Just clarifiying the rep so lets get started.

Setting up a Private Server
In This Tutorial, We Will Cover how to start a private server just for you, nobody can't get on it or anything. Lets get started with that.

Downloads: AC Web Ultimate Repack - Rep Jargs

Winrar Downloads

Download the One for your computer.)
Windows - Winrar
Linux - Winrar
Mac - Winrar

Latest Rev and Database Thread - Faddix

Navicat

Again, Download your PC Version)
Windows - Navicat

Mac - Navicat
Linux - Navicat

1. First of all, were gonna install the AC Web Ultimate Repack Which is above.

2. Were gonna Download Win-rar(Note: if you already have it, Don't worry about it. Make sure you download your version)

3. Next Open AC Web Ultimate Repack with Winrar and the popup should look like this:

Don't do anything to the location and just hit install.

4. Now Once it's done, Hit Start and Run and put in this location:

C:\AC Web Ultimate Repack

5.Ok, Now Once you get there you should see these Folders:

Ok, Now go into The Folder Ascent and Delete everything in it.

6.Next go into the folder Server and Delete every folder until it looks like this:

Make sure you delete the apache.bat and apache_stop.bat.

7.Ok, Now Activate mysql.bat.

8. Next go to the link above and download the latest rev by faddix! Currently During this Tutorial, the Latest Rev that 1412 by Arcemu. The Rev is currently only for 2.4.3 but it will be 3.0.2 soon and if not, i'll change it but download that and put all the files into your ascent folder.

9. Now once your done with that, download a program called Navicat which is above as well.

Ok, Now once your done installing it open it and it should look like this:

For One Thing, It should have no connections on the side, i just use those connections. Just hit New connection which you will see on the top left.

10. It will come up with Some Info it wants you to put in, Here is your info and make sure your mysql is up:

Ip/Host: localhost
User: root
Password: ascent
Port: 3306

11. Now you should see the a bunch of databases from ascent to logon. Delete every Database except ascent, logon, mysql, and the other database. Just delete forums and joomla.

12. Next, Go back to the faddix update page and download the latest rev database. I'd recommend the whydb. Once you download it, you will see A .sql file of some kind. Extract it to your desktop.

12. Next once you put the sql onto the desktop. go into your navicat and go into your ascent database and delete all the tables like so:

Just right click and hit delete.

13. Next right click on ascent and hit execute batch file.

14. Next, Choose the whydb .sql file and hit start. It will take up to probably 10 minutes to upload. at that time, Go into Your Ascent folder which btw you can rename to your server name.

15. Next, Go into the configs files in ascent or whatever you renamed it.

16. Next, You need to edit the config file arcemu-logonserver.conf. and the settings in it should be changed to these:

Code:

<LogonDatabase Hostname = "localhost"
               Username = "root"
               Password = "ascent"
               Name     = "logon"
               Port     = "3306"
               Type     = "1">

Change that to this:

Code:

<LogonDatabase Hostname = "localhost"
               Username = "root"
               Password = "(put a pass here and make sure you remember it)"
               Name     = "logon"
               Port     = "3306"
               Type     = "1">

Next scroll down and change this:

Code:

<LogonServer RemotePassword = "ascent"
             AllowedIPs = "127.0.0.0/24"
             AllowedModIPs = "127.0.0.0/24">

Change it to this:

Code:

<LogonServer RemotePassword = "(Extreme pass and copy this)"
             AllowedIPs = "127.0.0.0/24"
             AllowedModIPs = "127.0.0.0/24">

Now hit file and save.

Next open up arcemu-world.conf and edit these:

Code:

<WorldDatabase Hostname = "localhost" Username = "root" Password = "chris15redjake15red" Name = "worlddb" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "chris15redjake15red" Name = "logondb" Port = "3306" Type = "1">

Change it to this:

Code:

<WorldDatabase Hostname = "localhost" Username = "root" Password = "(Whatever your pass you setup for logon is)" Name = "ascent" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "(Whatever you put as your pass for logon)" Name = "logon" Port = "3306" Type = "1">

Next Scroll down until you see this:

Code:

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

Change it to this:

Code:

<LogonServer DisablePings = "0"
             RemotePassword = "This is the extreme password you created from your logon server, not used above!)">

17. Now your Whydb upload should be done by now so once thats done, just startup logon.exe and world.exe and then just change your realmlist to 127.0.0.1 and logon with these:

admin1 - username
admin1 - password

logon and have fun. I'll start on the Second tutorial in a few minutes. Need a break from typing! :O

Edit: Oh and i almost forgot, Before you startup your Logon and World .exe's, you need to change the pass on your mysql. You Can do this by Going into navicat, Hitting manage accounts, And Right click on Root@localhost and then Change the pass to your main password in the configs! Thanks For Reminding me Everyone!

More Tutorials by Me:
[Tutorials for Noobs] How to setup a private server and make it public(+ Extra's) 2
[Tutorials for Noobs] How to setup a private server and make it public(+ Extra's) 3

Video Tutorial: (Coming Soon)

- R3DW3R3W0LF

manguerola · #2 (**permalink**) 10-28-2008, 07:18 AM

easy +rep any noob can make it

Tyrail · #3 (**permalink**) 10-28-2008, 08:58 AM

lol kk nice guide so in the 2nd tut it will cover the how to run it, useful items, public and advertise parts will it not?

cillian · #4 (**permalink**) 10-28-2008, 09:03 AM

Hmm.. Nice one. Really good tut, +rep.

R3dW3r3W0lf · #5 (**permalink**) 10-28-2008, 03:56 PM

Once i get back to school, I'm gonna type up how to make Custom Items, Quests, Everything and after that i'll teach you how to Run the server, then i'm gonna teach you how to make it public. The Customs Building part will take forever since I'm typing everything you can make custom! Thanks for the rep guys! :O

edit: I Phrased that wrong, I meant once i get back from school.

hleb · #6 (**permalink**) 11-01-2008, 06:34 PM

i know this is "noob guide" but i have some issuse with arcemu-word,im sure ive done all fine(1509 rev and whydb 231) and when i start it (yes i have turned on mysql)it says:connection failed due to : 'unknow database 'whydb'' could u pls help me :S

R3dW3r3W0lf · #7 (**permalink**) 11-01-2008, 07:14 PM

Your Supposed to go into your conf file for world and change the database that world uses from whydb to ascent because the Rev that he made comes with conf files and the conf for world says that its gonna use whydb for world, aka your server. Look above, you missed it!

OK... Making a Video Tutorial Now!

Heolo · #8 (**permalink**) 11-02-2008, 05:02 AM

Ok i must be the biggest noob on this site cause i messed this up. I keep getting an error that tells me the application configuration is incorrect. Someone please help me!

R3dW3r3W0lf · #9 (**permalink**) 11-02-2008, 05:26 AM

copy everything in each conf file and put them on here, I'll tell you if theres an error!

Stojkan · #10 (**permalink**) 11-02-2008, 05:52 PM

i have problem with this when i try to connect to MySql it says this

so can you Help me?

Heolo · #11 (**permalink**) 11-02-2008, 06:31 PM

Ok its true i win the biggest noob award i forgot about .net framework 3.5.
But that has not stopped me for as a noob i have yet again messed this up.
I cant create a character. ive let it sit on the create character page saying "creating character" for about 20 minutes and nothing. i have no idea how to fix it but i will continue to play with it until its fixed!

skaterneko · #12 (**permalink**) 11-02-2008, 06:45 PM

Quote:

Originally Posted by Stojkan

i have problem with this when i try to connect to MySql it says this

so can you Help me?

I really do hope you have MySQL running

tsume920 · #13 (**permalink**) 11-02-2008, 08:40 PM

I have a problem that when i run the logonserver it gives me an error saying connection failed due to: Access denied for user.........localhost ( using password :YES)

mjs96 · #14 (**permalink**) 11-02-2008, 11:36 PM

i need help! when i run the logon and world it gives me "using password: YES" then shuts itself off!!!

R3dW3r3W0lf · #15 (**permalink**) 11-02-2008, 11:51 PM

that means you messed up your passwords! It means that wrong pass so just go back through the tutorial.

Ok... If anyone has a problem with anything, just Join my vent and i'll help!

werewolfwow.game-server.cc
no pass
3784

mjs96 · #16 (**permalink**) 11-03-2008, 12:12 AM

i have made sure the passwords are exectly the same ... still fails! (i am also in the vent specified and u are no where to be found)

Shrios · #17 (**permalink**) 11-03-2008, 03:40 AM

Quote:

Originally Posted by mjs96

i have made sure the passwords are exectly the same ... still fails! (i am also in the vent specified and u are no where to be found)

I am having the same issue. I have double-triple-quadruple checked my passwords to ensure they are identical, and I am still encountering failures.

EDIT: Starting over from the top, maybe I messed up somewhere else.

Stojkan · #18 (**permalink**) 11-03-2008, 07:48 AM

I figure how do FIX that problem.Firs run MySQL.bat or Backgroud.bat you can find that in you server folder(Its depends on that which repack do you use).Afther you run that try again to connect to you MySQL server and its shall work.

mjs96 · #19 (**permalink**) 11-06-2008, 09:24 PM

ok i fixed my problem ... now i need to know why some of my GM commands arnt working (like recall and learn)

b0untymage · #20 (**permalink**) 11-07-2008, 02:42 AM

Hey thanks for the post but i have a problem at Step 7. When I open up mysql it says "MYSQL could not be started. Press any key to continue." Pleaes send me a personal message on how to fix this. Thanks