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

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

Quote:

---

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

---

and

Quote:

---

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.

Quote:

---

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

---

Quote:

---

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.

http://img37.imageshack.us/img37/6720/424112312.jpg

TheRealMethuselah

Points you have what the next update brings

@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

Attachment 384

Then click realmd and double click on realmlist

Attachment 385

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

http://img17.imageshack.us/img17/3641/12312312ie.jpg

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

Try opening it with another program.

Quote:

---

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

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:
http://img820.imageshack.us/img820/4539/12467960.jpg

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:

http://img526.imageshack.us/img526/698/realmlistj.jpg

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)

http://img821.imageshack.us/img821/1239/pass.jpg

Username is root
Password is mangos

Then click Connect.

Quote:

---

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:
http://img820.imageshack.us/img820/4539/12467960.jpg

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:

http://img526.imageshack.us/img526/698/realmlistj.jpg

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)

http://img821.imageshack.us/img821/1239/pass.jpg

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.

Great job TRM but I have a problem

Imageshack - trm.png

I reinstalled the repack 3 times doing Exactly what you said:(
Or I'm a noob or my PC::confused:

later edit: I got it a proxy server installed net framework 2.0 I need 3.5:P


+repfor the great repack!!!