[Release] TRM's 3.3.5.12213 Repack (32 and 64-bit versions)

**eliteplague** · 27-06-10, 05:18 PM

Does anyone know how I can make this server public just for myself and my brother (we share same IP adress). Would Hamachi work? Like would I be able to change mangosd and realmd to my hamachi IP? For example change these to my hamachi

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

and

LoginDatabaseInfo = "127.0.0.1;3306;root;mangos;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;mangos;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;root;mangos;characters"

Could I just change all those 127.0.0.1 defaults to my Hamachi IP to make it public for my brother? Who shares the same IP as me. Also is there anything else I would edit? Or only those 3.

› See More: [Release] TRM's 3.3.5.12213 Repack (32 and 64-bit versions)

**eliteplague** · 27-06-10, 05:52 PM

LoginDatabaseInfo = "5.139.193.10;3306;root;ascent;realmd"
LogsDir = ""
MaxPingTime = 30
RealmServerPort = 3724
BindIP = "0.0.0.0"
PidFile = ""
LogLevel = 0
LogTime = 0
LogFile = "Realmd.log"
LogTimestamp = 0
LogFileLevel = 0
LogColors = ""
UseProcessors = 0
ProcessPriority = 1
RealmsStateUpdateDelay = 20
WrongPass.MaxCount = 0
WrongPass.BanTime = 600
WrongPass.BanType = 0

RealmID = 1
DataDir = "."
LogsDir = ""
LoginDatabaseInfo = "5.139.193.10;3306;root;ascent;realmd"
WorldDatabaseInfo = "5.139.193.10;3306;root;ascent;mangos"
CharacterDatabaseInfo = "5.139.193.10;3306;root;ascent;characters"
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"

When I change 127.0.0.1 areas to 5.139.193.10 (my hamachi IP), the restarter isn't able to start my server. My realmlist for WoW has been changed from 127.0.0.1 to 5.139.193.10 also.

**~~ellenya~~** · 27-06-10, 06:12 PM

TheRealMethuselah

Points you have what the next update brings

**agamoose** · 27-06-10, 06:13 PM

@eliteplague First of all change both your realm.conf and mangos.conf back to the defaults. Load your mysql then use an sql editor eg. heidi sql

screeny 1..jpg

Then click realmd and double click on realmlist

screeny 2..jpg

Then change the address from 127.0.0.1 to your hamachi IP 5.139.193.10

Edit: to include screenies oops my bad lol

**eliteplague** · 27-06-10, 06:26 PM

What do I do here? I new with the SQL stuff. I get an error when I click open

**aribleach** · 27-06-10, 06:33 PM

Try opening it with another program.

**eliteplague** · 27-06-10, 06:40 PM

Originally Posted by aribleach

Try opening it with another program.

I tried navicat, same error

Anyone know how to fix the above error, I get the same with navicat

**CthulhuFtagn** · 27-06-10, 08:18 PM

If you are sharing an IP address and are on the same router you would use your internal IP address as the realmlist.wtf, example:

Type the Windows Key + R (or Start > Run)

Code:

cmd

Then in the console type

Code:

ipconfig /all

As in the below screenshot note your IPv4 address:

So, if someone on my network wanted to connect to me they would edit the realmlist.wtf file to be:

Code:

set realmlist 192.168.0.15
set patchlist 192.168.0.15
set realmlistbn ""
set portal us

My realmlist.wtf would be:

Code:

set realmlist 127.0.0.1
set patchlist 127.0.0.1
set realmlistbn ""
set portal us

All of my .conf files would stay default.

I would edit my realmd DB realmlist Table to reflect the new IP:

Once that's done he should be able to connect, unless your router requires you to forward certain ports (which it shouldn't for an internal network), but if it does forward the following ports:

80 - HTTP
3306 - WorldD
8085 - MySQL
3724 - RealmD

Navicat is not as user friendly as SQLYog: SQLyog-8.5.1-0Community.exe - sqlyog - SQLyog Community Edition - 8.51 - Project Hosting on Google Code

Install it and make sure you have MySQL.bat running, then load it up and click Continue, then make sure your connection looks like below:

(Click New to make a connection)

Username is root
Password is mangos

Then click Connect.

**eliteplague** · 27-06-10, 08:32 PM

Originally Posted by TheRealMethuselah

If you are sharing an IP address and are on the same router you would use your internal IP address as the realmlist.wtf, example:

Type the Windows Key + R (or Start > Run)

Code:

cmd

Then in the console type

Code:

ipconfig /all

As in the below screenshot note your IPv4 address:

So, if someone on my network wanted to connect to me they would edit the realmlist.wtf file to be:

Code:

set realmlist 192.168.0.15
set patchlist 192.168.0.15
set realmlistbn ""
set portal us

My realmlist.wtf would be:

Code:

set realmlist 127.0.0.1
set patchlist 127.0.0.1
set realmlistbn ""
set portal us

All of my .conf files would stay default.

I would edit my realmd DB realmlist Table to reflect the new IP:

Once that's done he should be able to connect, unless your router requires you to forward certain ports (which it shouldn't for an internal network), but if it does forward the following ports:

80 - HTTP
3306 - WorldD
8085 - MySQL
3724 - RealmD

Navicat is not as user friendly as SQLYog: SQLyog-8.5.1-0Community.exe - sqlyog - SQLyog Community Edition - 8.51 - Project Hosting on Google Code

Install it and make sure you have MySQL.bat running, then load it up and click Continue, then make sure your connection looks like below:

(Click New to make a connection)

Username is root
Password is mangos

Then click Connect.

THANKS! It worked, thank you for the very detailed easy to read guide, I appreciate it.