server issues

[mrmagoo1077]

I have spent days trying to figure out this problem (research included). I understand these requests get old, but I am really at a loss here.

Trying to run a public 1.12.1 server for me and my friends using alterwow mangos repack.

realmlist (using heidi sql) is set to use my dynamic ip xxxxxxx.no-ip.biz on port 3306. Logging into sql with heidi is port 3306 and ip 127.0.0.1.
Host file has these lines added
127.0.0.1 xxxxxxx.no-ip.biz
192.168.0.9 xxxxxxx.no-ip.biz
xxx.xxx.xx.xx (external ip) xxxxxxx.no-ip.biz

Realmd settings:

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

mangosd settings:
RealmID = 1
DataDir = "."
LogsDir = ""
LoginDatabaseInfo = "127.0.0.1;3306;root;ascent;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;ascent;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;root;ascent;characters"
LoginDatabaseConnections = 1
WorldDatabaseConnections = 1
CharacterDatabaseConnections = 1
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"

On my router (actiontec c1000a with centurylink)
all ports listed above are forwarded for my internal ip and my friends internal ip (he is on my lan, renting a room from me) plus others suggested by

other guides.

The Problems: I, on the hosting computer, can connect to and play in my server with realmlist.wtf (client) set to "set realmlist xxxxxxx.no-ip.biz".
My freind cannot connect at all, it times out while connecting (does not make it to realmlist loop). Neither of us have firewalls on during test. If

i change realmlist in sql to my local lan ip (and he changes his realmlist.wtf to my local lan ip) he can log in but just realm loops.

I would prefer to be able to run public online for freinds but would be more than content with LAN only play and just do a lan party. Any ideas?

[jadethread]

Try disabling firewall / Av or anything and restarting server. Worked for me once. Also try compiling your own server