[TrinityCore] Realm loop on external connects

[lunarpac]

Core: TrinityCore1 (2.4.3)
Core Revision: Rev: 595
Database: MySQL (wasn't really sure what you wanted here >_> apologies)
Database Revision: Rev: TDB-5
Repack you used (if any): Reaper-X Trinity - Revision:1

Hello!
I've been looking through the threads regarding realm loops on the internet, but none of the solutions provided has helped me.

I'm running the above setup, and have the core/db on the same machine as the client. Additionally, my brother is behind the same router as me, as well as some friends trying to connect from outside the router.
To summarize, I'd like to connect (from the same machine), my brother would like to connect (from LAN) and my friends would like to connect (external connections). How would I go about configuring that? I've come as far as me and my brother being able to connect, with the configuration listed below. My friends however get the realm loop.

I'm using 2 entries in the realmlist table in the database. 1 for local, and one for external connections (see below)

Here's the IP situation:
My LAN IP: 192.168.0.xxx
My external IP: 83.253.94.xxx
My DNS (hosting my external IP): xxx.game-host.org

My hosts file:
127.0.0.1 xxx.game-host.org

My brother's hosts file:
192.168.0.xxx xxx.game-host.org

My friend's realmlist:
set realmlist xxx.game-host.org

In the MySQL database, realmlist table, I have the following 2 entries:
ID: 1
Name: Dontneedtoknow
Address: xxx.game-host.org
Port: 8085

ID: 1
Name: Dontneedtoknow
Adress: 192.168.0.xxx
Port: 8085

In the trinitycore.conf, I have the following:
RealmID = 1
DataDir = "C:\xxx"
LogsDir = ""
LoginDatabaseInfo = "127.0.0.1;3306;root;xxxxxx;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;xxxxxx;world"
CharacterDatabaseInfo = "127.0.0.1;3306;root;xxxxxx;characters"
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"

In the trinityrealm.conf, I have the following:
LoginDatabaseInfo = "127.0.0.1;3306;root;xxxxxx;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

The following ports have been forwarded in the router and opened in the firewall:
8085, 3724

I have tried a lot of different methods I've found while browsing the internet (google,yay!), but none of them seems to solve my situation.
I would greatly appreciate any help, and will of course provide any information you will need to help me solve my problem. :-)
Thanks on beforehand!
// Lunarpac

[dffrntdnl]

ID: 1
Name: Dontneedtoknow
Adress: 192.168.0.xxx
Port: 8085

remove that second entry from you realmlist table. you don't need it there. Your friend on the lan should be able to connect through your dns hostname. just make sure that both you and him change your realmlists accordingly.

if that doesnt work, try setting your router to DMZ mode temporarily and test it again. If your friends can connect, the it's a router firewall issue (aka wrong ports open)

[lunarpac]

All realmlists (mine, my brother's and friend's) are set to:
set realmlist xxx.game-host.org

In the MySQL database realmlist table I removed one entry, and currently there's only this entry:
ID: 1
Name: Dontneedtoknow
Address: xxx.game-host.org
Port: 8085

I turned on DMZ for my ip 192.168.0.xxx.

Using this setup I get the following error message:

2010-02-23 16:13:00 Using configuration file trinityrealm.conf.
2010-02-23 16:13:00 Trinity (realm-daemon)
2010-02-23 16:13:00 <Ctrl-C> to stop.

2010-02-23 16:13:00 Database: 127.0.0.1;3306;root;xxxxxx;realmd
2010-02-23 16:13:00 MySQL client library: 5.0.56
2010-02-23 16:13:00 MySQL server ver: 5.1.44-community
2010-02-23 16:13:00 ERROR:No valid realms specified.

Any ideas on how to solve this? Seems trinity won't recognize the realm entry at all?
Thanks for the help so far.

[Kiev]

In your database ensure the table names is as its asking for in the config, "realmd".

As for the host files on your brothers, he dont need to change his host file to connect. If he did then emu would be full of so much editing for anyone wanting to connect xD

[lunarpac]

In your database ensure the table names is as its asking for in the config, "realmd".

As for the host files on your brothers, he dont need to change his host file to connect. If he did then emu would be full of so much editing for anyone wanting to connect xD

When I use 192.168.0.xxx (local IP) in the realmd/realmlist database TrinityRealm.exe loads the realm without problems, and both me and my brother (who's on LAN, inside the router so to speak) can connect fine.

As soon as I change to xxx.game-host.org, TrinityRealm.exe won't recognize the realm. "ERROR:No valid realms specified.".

Everything but that remains unchanged.
Any more ideas? I appreciate all ideas of solutions.

Side note: We changed the hostfile of my brother since I was under the impression he wouldn't be able to connect unless he associated my LAN ip (192.168.0.xxx) with the dns (xxx.game-host.org).

[Kiev]

Theres no need to change dont worry (:.

Try and change it in the database to your external ip and report back.

[lunarpac]

Theres no need to change dont worry (:.

Try and change it in the database to your external ip and report back.

Thanks for the reply Kiev!
I changed the ip in the realmd/realmlist database entry to 83.253.94.xx (external IP). Do I need a system reboot after every change just to make sure?
Because I get the same error even with the external IP in the realmd/realmlist.

[Kiev]

You shouldn't need too no, and you dont need to mask your IP on these forums dont worry Everyone here will not harm you. :P.

Something i cant work out is why it isn't registering... does it just not detect it?

[lunarpac]

You shouldn't need too no, and you dont need to mask your IP on these forums dont worry Everyone here will not harm you. :P.

Something i cant work out is why it isn't registering... does it just not detect it?

I'll continue masking, not because I don't trust you, but just because I want to.

I can't figure it out either, seems like it won't detect there's an actual realm on that ip (the external). As soon as I set it to the internal LAN IP the TrinityRealm.exe detects it perfectly. I really want to continue using TrinityCore, because I think it's the best core, but I just can't figure this out. Any ideas?

EDIT: I'm starting to suspect something's wrong with my TrinityRealm.exe. I changed the ip back to 192.168.0.xxx, and it won't recognize the server. Even though I use the same setup (although a single entry) as when it worked before (with 2 entries, 1 external and 1 for internal connections in the realmd/realmlist).

[Kiev]

Try and get a new repack/compile. As that might just be the issue.

[lunarpac]

Try and get a new repack/compile. As that might just be the issue.

Aww gee. I'm having trouble finding good repacks. Got any ideas for a good 2.4.3 repack, TrinityCore with boss/raid/instance scripts especially for ZA/Kara?
Sorry if it's a stupid question, I'll try to google some myself as well, but I'd like some advice on good repacks anyway, as you never know what kind of packs are out there.

Just another entry here: I removed the router and I am now running computer -> cablemodem only. Still won't work, so it's not the router.

EDIT: Been googling for 3 straight hours. I can't seem to find any repack that seems as good as this one is. x) I'll keep looking though, but I'd prefer we solved the issues at hand, anyone else have any ideas?

[Kiev]

First i would reccomend checking anything, so you can see if the issue is resolved with something else, if not then it might be a deeper lying issue.

[lunarpac]

I'm going to test either oregoncore or another repack of trinity this week.
Anyone else have any ideas I can try?
Thanks for the help so far.

[Kiev]

Typically just try a simple arcemu set up, if that connects, awesome.

Then go to MaNGOS, try that.

Etc.

[lunarpac]

Typically just try a simple arcemu set up, if that connects, awesome.

Then go to MaNGOS, try that.

Etc.

I'll be trying this repack on another system in another house this week. Let's hope it works (y).
The weird thing is it works great on my computer if I run 2 entries, one being my LAN ip and the other external, however external users get the loop. Beats me. xD