Making Your Mangos Server Live (Noob Friendly)

[Dasket]

Whenever i try to start it up in mangos and realmd is says it's unable to connect

[zedicus10]

First of all I use the repack server from 711 it is easy to set up:

Step 1) Go to No-IP - Dynamic DNS, Static DNS for Your Dynamic IP

Step 2) Sign Up

Step 3) Sign In

Step 4) Click "Add" under "Hosts/Redirects" in the left hand column

Step 5) Fill in the "Hostname" field and nothing else

Step 6) Click "Create Host" at the bottom of the page

Step 7) Open up your MANGOS folder

Step Open up your Realmd.conf with Notepad

Step 9) Scroll down till you see :

LoginDatabaseInfo = "127.0.0.1;3306;root;root;realmd"

Step 10) Change the "127.0.0.1" to the host you made at no-ip.com(Ex:host.no-ip.biz)
Step 11) Open your Mangosd.conf with Notepad

Step 12) Scroll down till you see 3 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"

Step 13) Change the "127.0.0.1" in each line to your noip.com host
Example of this :

RealmID = 1
DataDir = "."
LogsDir = ""
LoginDatabaseInfo     = "host.no-ip.biz;3306;root;root;realmd"
WorldDatabaseInfo     = "host.no-ip.biz;3306;root;root;mangos"
CharacterDatabaseInfo = "host.no-ip.biz;3306;root;root;characters"
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"

Step 14) Start up your "Mysql" in your MANGOS Folder

Step 15) The Start up Navicat for mysql

***For those who don't have it here are steps to get it for FREE***
Go to YouTube - Navicat 8.0 MySQL Full Version For Free
and click more info on the left and download it
then follow his guide and when prompted by navicat click registeration
then type anything in the regristartion
and fill all the spaces in the key field
then click ok
*****

Step 16) Click Connection

Step 17) Fill in:
Connection Name: (Type Whatever)
Hostname/IP Address: localhost
Port: 3306
Username: root(or whatever this is for your server...usually root)
Password: root(or whatever this is for your server...usually root)
Save Pass : Yes

Step 1 Click Ok then Double Click the New Connection

Step 19) Double click the "Realmd" database on the drop down menu

Step 20) In the section to the right click the "Realmlist" table

Step 21) You'll see:
1...MANGOS...127.0.0.1...8085(in boxes not actually seperated by dots)

Step 22) Change the "127.0.0.1" again to your host you made
Example: 1...MANGOS...host.no-ip.biz...8085(no dots...boxes)

Step 23) Then Exit out of Navicat and your done...your server is live

ALSO: You can follow these same steps for hamachi

If you have questions ask I WILL CHECK AND ANSWER WHEN I GET ON

Didn't work for me. Also I couldnt even get on my own server from doing this. Not even with set realmlist 127.0.0.1

[Omahz]

Hey, thanks for this, very awesome.
But I have one problem, I'm trying to get my brother online to the server but he only gets stuck at 'Connection' for a while then he gets 'Unable to connect'. We have tried both the no-ip.biz thing as realmlist and the external IP.
When we changes the realmlist to the internal IP he comes online but he's stuck on 'Logging in to game server', he can't come to the character creation screen in other words.
We have the computers in the same house if that's to any help.
How do we solve this? :'(

[PitLordMastr]

Step 19) Double click the "Realmd" database on the drop down menu

Step 20) In the section to the right click the "Realmlist" table

Step 21) You'll see:
1...MANGOS...127.0.0.1...8085(in boxes not actually seperated by dots)

Step 22) Change the "127.0.0.1" again to your host you made
Example: 1...MANGOS...host.no-ip.biz...8085(no dots...boxes)

Step 23) Then Exit out of Navicat and your done...your server is live

I do not under stand this/these steps. What the Realmd database on the drop menu and where is it? Please help me! Thnx. I would give rep but I can not.

[Yamajee]

These steps, first open Navicat then make sure you're connected to the database so you get a lot of databases like Mangosd, Characters, realmd, etc. Right click Realmd and open the data base, then you'll see a table called Realmlist.. double click on it.. It will open a table with fields and then it's like 1 MaNGOS 127.0.0.1 8085

Change the 127.0.0.1 to your no-ip host for example, example.no-ip.biz

Exit navicat and voila!

[mrsparkles123]

HELP, well i did all that but this Error thing with an "X" keeps poping up spamming teh crap outa my computer...help please! "says Cannot Find The file MANGOS/.check...Anyone?

[mrsparkles123]

Says "Cannot Connect to MySQL database at (Ip Adress im not reveiling)root/root etc.. help please.

[robinelitenn]

but should this work if you don't have connect the server to the internet?? this is only to make it a no-ip right??

[mrsparkles123]

Wtf is cmd???

[spideysplat]

tried it step by step , dosn't work for me.

[l MPL l Destroyer]

same here says cannot connect to my no-ip

btw its nicksserver.no-ip.biz if that helps

[sunday!]

Hey guys, new to this forum. Just dropped by to say hi..

Anyways, awesome repack, tho i cant seem to get other clients to join. I keep getting the same Realm selection Relooping. Ive read up somewhere that it was due to an invalid IP or something. Anyones got any suggestions to resolve this? Thanks yeah..

[losten3rgy]

I did all of this but the server is still offline, if anybody could help that would be awesome

EDIT::: i got online but when i tried to help my friend get on we both get stuck at "Logging into game server"

[Deathtrooper]

I do not under stand this/these steps. What the Realmd database on the drop menu and where is it? Please help me! Thnx. I would give rep but I can not.

These steps, first open Navicat then make sure you're connected to the database so you get a lot of databases like Mangosd, Characters, realmd, etc. Right click Realmd and open the data base, then you'll see a table called Realmlist.. double click on it.. It will open a table with fields and then it's like 1 MaNGOS 127.0.0.1 8085

Change the 127.0.0.1 to your no-ip host for example, example.no-ip.biz

Exit navicat and voila!

Picture Reference!

[Yamajee]

Well, I'd recommend using Navicat since it's much easier to use and the Realmlist table is located in:
Localhost -> Realmd -> Realmlist.

Change the 127.0.0.1 to your External IP or your Dynamic IP Address.