VERY EASY WoW 2.4.3 TBC Server (also with Hamachi/LAN)

[MortonM]

After many attempts and different repacks, I've found a decent repack that is easy to install and use over Hamachi or LAN. This has been tried and tested on 3 different computers so it definitely works! All repack credits go to 711.

First, you need to download the following:

Mangos Repack by 711

Navicat Lite

MySQL Server 5

Select your operating system then click "Pick a Mirror" for Windows Essentials and then click "No thanks, just take me to the downloads!" and then select a mirror.

Part One - Setting up the Server

1) Extract the Mangos repack to any folder as long as you remember where it is.

2) Install Navicat (just follow the on-screen instructions, nothing special to do here)

3) Install MySQL Server 5
- Select Typical install
- Make sure you tick the "Configure the MySQL Server now" box
- Click "Finish"
- Select "Standard Configuration"
- Make sure "Install as Windows Service" is ticked and that the service name is MySQL
- DO NOT tick "Launch the MySQL server automatically" or "Include BIN Directory in Windows PATH"
- Click "Next"

- Tick "Modify Security Settings" and put in the following information:
- current root password: LEAVE BLANK
- New root password: root
- Confirm: root
- Tick "Enable remote access" if you want to be able to edit the database from a different computer
- Click Next
- Click Execute

4) Copy the "Maps" folder and "ad.exe" from the Mangos folder to your WoW directory

5) Run ad.exe from your WoW directory. This will take quite a long time, but it's worth it!

6) When that's done, copy the Maps folder back into the Mangos folder where it was originally

7) Run "mysql.bat" then when that has loaded, run "restarter.exe"
- If mysql automatically shuts down, that means you are already running a SQL server. Go to the task manager, find mysql-nt.exe and click "End Task"

Open "realmlist.wtf" in Notepad. This is found in your WoW directory

9) Change the text so it just reads "set realmlist 127.0.0.1"

10) Run WoW and you can logon with either 0, 1, 2 or 3 as the username and password. The higher the number, the higher level of security you log in as (3 is admin, 2 is GM etc.)

11) You can make new accounts by clicking on RealmD that is running and typing "createaccount Username Password"
- To enable TBC, type "setbc Username Password 1"
- To make an account a GM or admin, type "setgm Username Password X" (X is a number 1-3 for the level of security)

Part Two - Setting up the Server for Hamachi or LAN play

1) Open mangosd.conf in Notepad and find the following lines:
RealmID = 1
DataDir = "."
LogsDir = ""
LoginDatabaseInfo = "127.0.0.1;3306;root;root;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;root;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;root;root;characters"
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"

Replace each "127.0.0.1" with either your Hamachi IP or the IP that your computer has on your network
So it should read:
RealmID = 1
DataDir = "."
LogsDir = ""
LoginDatabaseInfo = "Your IP;3306;root;root;realmd"
WorldDatabaseInfo = "Your IP;3306;root;root;mangos"
CharacterDatabaseInfo = "Your IP;3306;root;root;characters"
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"

2) Run mysql.bat then open Navicat

3) Click on "Connection" at the top left of the screen

4) Put the following into each of the fields:
Connection Name: Whatever you want to call it
Host name/IP address: Either your Hamachi IP or your LAN IP
Port: 3306
User name: root
Password: root

5) Click OK and double click on the connection you have just set up on the left hand side

6) Double click on realmd

7) In the middle pane, open the table called "realmlist"

Change the Name column to whatever you want to call your server

9) Change the address to your Hamachi IP or LAN IP

Note: If you want to remove the premade accounts (0, 1, 2 and 3) or change them, go into the account table and you can manually edit them there

10) Close Navicat and mysql.bat

11) Open realmlist.wtf in Notepad (This is found in your WoW directory)

12) Change it so it just reads: "set realmlist Your Hamachi/LAN IP" (e.g. set realmlist 192.168.0.1)

13) Run mysql.bat and restarter.exe

14) Get your friends to change their realmlist files to the same as yours (with your Hamachi IP or LAN IP)

15) Run WoW and enjoy!

If you have any questions or issues, please feel free to post here and I will respond as soon as possible. Hope you enjoy it!

By the way, a very good Mangos editor is Quice. This will allow you to add NPCs, quests, items etc.

If you want to make your server high rate, just edit the values in mangosd.conf. You will find the rates towards the bottom of the document.

Again, this repack was NOT my work, all the credits for it go to 711.

[costel_gabitu]

Heres something Im getting: When everything is set as: 127.0.0.1 my frieds can connect through hamachi but they get stuck at the realm selection pane.

And when I change the configs and everything as you said to the hamachi IP my friends get the error: Unable to connect. Help pls... >.< I really suck at MaNGOS. This is the first Mangos server Ive ever tried.... >.<

Edit: Nevermind, solved.

[MortonM]

Did your friends set their realmlist to your hamachi IP?

[Glorianglorre]

Oh nice guide for a 2.4.3 server

[MortonM]

Thanks Glorianglorre

[Glorianglorre]

I had a puplic server before just ask me but i have never had mangos

[BlahBlahMonKey]

I have WOTLK 3.0.9 I wana make a server for that? how? email me solan . mark @ gmail .com

[Jay5231]

Thank you, It really help me

[lufias]

Alright I've gotten the ad.exe to run but now it won't let me log into the realm. Says it's offline. I followed the guide to the letter. Any ideas?

[711]

There is so much wrong with this thread.

First and foremost, the guide I posted for this repack has instructions of it's own that work just fine. http://www.mmowned.com/forums/mangos...ack-711-a.html

First, you need to download the following:
Navicat Lite
MySQL Server 5

Incorrect. You need neither mysql or navicat installed to install this repack.

2) Install Navicat (just follow the on-screen instructions, nothing special to do here)

3) Install MySQL Server 5
- Select Typical install
- Make sure you tick the "Configure the MySQL Server now" box
- Click "Finish"
- Select "Standard Configuration"
- Make sure "Install as Windows Service" is ticked and that the service name is MySQL
- DO NOT tick "Launch the MySQL server automatically" or "Include BIN Directory in Windows PATH"
- Click "Next"

- Tick "Modify Security Settings" and put in the following information:
- current root password: LEAVE BLANK
- New root password: root
- Confirm: root
- Tick "Enable remote access" if you want to be able to edit the database from a different computer
- Click Next
- Click Execute

None of this is necessary.

- If mysql automatically shuts down, that means you are already running a SQL server. Go to the task manager, find mysql-nt.exe and click "End Task"

This step IS however necessary with your guide, because you just told everyone to install Mysql, so of course another copy of it will be running. It isn't necessary if you don't install a second copy of mysql as your instructions say to.

11) You can make new accounts by clicking on RealmD that is running and typing "createaccount Username Password"
- To enable TBC, type "setbc Username Password 1"
- To make an account a GM or admin, type "setgm Username Password X" (X is a number 1-3 for the level of security)

Wrong again. You can't type commands into the realmd window, account editing commands are typed into the mangosd window. Not to mention that including the password in the "setbc" command will cause a syntax error. The correct command would read: setbc username 1.

Part Two - Setting up the Server for Hamachi or LAN play

1) Open mangosd.conf in Notepad and find the following lines:
RealmID = 1
DataDir = "."
LogsDir = ""
LoginDatabaseInfo = "127.0.0.1;3306;root;root;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;root;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;root;root;characters"
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"

Replace each "127.0.0.1" with either your Hamachi IP or the IP that your computer has on your network
So it should read:
RealmID = 1
DataDir = "."
LogsDir = ""
LoginDatabaseInfo = "Your IP;3306;root;root;realmd"
WorldDatabaseInfo = "Your IP;3306;root;root;mangos"
CharacterDatabaseInfo = "Your IP;3306;root;root;characters"
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"

Also wrong. Notice how each of these rows says "DatabaseInfo"? That means it's looking for the IP where the mysql databases are hosted, which will always be 127.0.0.1 if mangos and mysql are on the same computer. The DB IP's have absolutely nothing to do with making your server public, and will actually instead make it far less secure by allowing ANYONE with your IP address to edit your database.

all the credits for it go to 711.

Got this part right at least.

Long story short, this thread has absolutely no purpose except misinformation, and maybe as a beginner's guide to hamachi, hundreds of which already exist.


in reply to

Alright I've gotten the ad.exe to run but now it won't let me log into the realm. Says it's offline. I followed the guide to the letter. Any ideas?

There's your problem. You followed this guide to the letter, so you'll definitely be experiencing problems.