Realmlist Loop (Mangos 1.12.1)

[methos0072001]

I've done everything that I can think of to try and fix this realm list loop problem, but it's still looping for me.

I have a computer that I control remotely that I run the server on, so in order to play on it anywhere I want, I had to make the server public with a DNS. I've looked around for guides on how to make it public, but I'm still having problems. Here are my configs:

Mangosd

# MaNGOS Configuration file
ConfVersion=2006082301

# RealmID must match the realmlist
RealmID = 1

# 0 NORMAL 1 PVP 4 NORMAL 6 RP 8 RPPVP
GameType = 1

# Data directory setting.
# Important: DataDir needs to be quoted, as it is a string which may
# contain space characters.
DataDir = "."

# Database connection settings for the world server.
# Default: hostname;port;username;password;database
#          .;somenumber;username;password;database - use named pipes at Windows
#                Named pipes: mySQL required adding "enable-named-pipe" to [mysqld] section my.ini
#          .;/path/to/unix_socket;username;password;database - use Unix sockets at Unix/Linux
#                Unix sockets: experimental, not tested
LoginDatabaseInfo = "XXXXX.game-server.cc;3306;root;pass;realmd"
WorldDatabaseInfo = "XXXXX.game-server.cc;3306;root;pass;mangos"

# Settings for maximum database-ping interval (minutes between pings)
MaxPingTime = 30

# Server console level of logging
# 0 = Minimum; 1 = Basic&Error; 2 = Detail; 3 = Full/Debug
# Default: 0
# recommend: 1
LogLevel = 3

# Logfile name
#    empty name disable creating log file: LogFile = 
# Default: ""
LogFile = "Server.log"

# Server file level of logging
# 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
# Default: 0
LogFileLevel = 0

# Packet logging for the worldserver
# Default: 0 (false)
#          1 (true)
LogWorld = 1

# Log filters
# 0 (default) - include in log if log level permit, 1 - not include with any log level
LogFilter_TransportMoves = 0
LogFilter_CreatureMoves = 0


# Color for messages (format "normal_color details_color debug_color error_color)
# Colors: 0 - BLACK, 1 - RED, 2 - GREEN,  3 - BROWN, 4 - BLUE, 5 - MAGENTA, 6 -  CYAN, 7 - GREY, 
#         8 - YELLOW, 9 - LRED, 10 - LGREEN, 11 - LBLUE, 12 - LMAGENTA, 13 - LCYAN, 14 - WHITE
# Default: "" - none colors
#          "13 7 11 9" - for example :)
LogColors = ""

# Log file of DB errors detected at server run.
# Default: ""
DBErrorLogFile = "DBErrors.log"

# Log file of gm commands
# Default: "" (Disable)
GmLogFile = ""

# Used processors mask for multi-processors system (Used only at Windows)
# Default: 0 (selected by OS)
#          number (bitmask value of selected processors)
UseProcessors = 0

# Process proirity setting (Used only at Windows)
#          0 (Normal)
# Default: 1 (HIGH)
ProcessPriority = 1

# Compression level for update packages sended to client (1..9)
# Default: 1 (speed) 
#          9 (best compression) 
Compression = 1


# Maximum number of players in the world. Excluding GM's
# Default: 100
PlayerLimit = 100

# Max level that can reached by player for expirience (in range from 1 to 255).
# Change not recommended
# Default: 60
MaxPlayerLevel = 60

# Ignore level requirement to enter instance
#        1 (true)
# Default: 0 (false)
IgnoreATLevelRequirement = 0

# Max count that player can learn the primary trade skill.
# Default: 2
# Max : 9 
MaxPrimaryTradeSkill = 2 

# Min signatures count to creating guild (0..9).
# Default: 9
MinPetitionSigns = 9

# Max distance to creature for group memeber to get XP at creature death.
# Default: 74
MaxGroupXPDistance = 74

# Max level different with creature for group member to get XP at creature death.
# Default: 10
MaxGroupXPLevelDiff = 10

# Allow or not accounts to create characters in the 2 teams in any game type.
# Defaullt: 0 (Not allowed)
#           1 (Allowed)
AllowTwoSide.Accounts = 0

# Allow or not common :chat(say,yell);channel(chat)group(join)guild(join);trade for players from different teams.
# Defaullt: 0 (Not allowed)
#           1 (Allowed)
AllowTwoSide.Interaction = 0

# Allow or not show player from both team in who list.
# Defaullt: 0 (Not allowed)
#           1 (Allowed)
AllowTwoSide.WhoList = 0

# Is GM accept whispers from player by default.
# Default: 0 (false)
#          1 (true) 
GM.WhisperingTo = 0


# Is GM showed in GM list (if visible) in non-GM state (.gmoff)
# Default: 0 (false)
#          1 (true) 
GM.InGMList = 1

# Is GM showed in who list (if visible).
# Default: 0 (false)
#          1 (true) 
GM.InWhoList = 0

# GM mode at login
#          0 (disable)
#          1 (enable) 
# Default: 2 (last save state)
GM.LoginState = 2

# Include GM trade and trade slot enchanting operations in GM log if it enable
#          0 (not include)
# Default: 1 (include)
GM.LogTrade = 1

# Group visibility modes
# Default: 0 (standard setting: only members from same group can 100% auto detect invisible player)
#          1 (raid members 100% auto detect invisible player from same raid)
#          2 (players from same team can 100% auto detect invisible player)
GroupVisibility = 0

# Message of the Day. Displayed at worldlogin for every user.
Motd = "Welcome to World of Warcraft - You can change the MOTD in mangos.conf"

# Health and power regeneration.
# Power1 - Mana; Power2 - Rage; Power3 - Focus (?).
Rate.Health = 1;
Rate.Power1 = 1;
Rate.Power2 = 1;
Rate.Power3 = 1;

# Drop rates
# Default: 1
Rate.Drop.Items = 1
Rate.Drop.Money = 1

# XP rates
# Default: 1
Rate.XP.Kill    = 1
Rate.XP.Quest   = 1
Rate.XP.Explore = 1

# Creature Damage Rate.
# Examples: 2 - creatures will damage 2x, 1.7 - 1.7x.
Rate.Creature.Normal.Damage = 1
Rate.Creature.Elite.Elite.Damage = 1
Rate.Creature.Elite.RAREELITE.Damage = 1
Rate.Creature.Elite.WORLDBOSS.Damage = 1
Rate.Creature.Elite.RARE.Damage = 1

# Creature Health Ammount Modifier.
# Examples: 2 - creatures have 2x health, 1.7 - 1.7x.
Rate.Creature.Normal.HP = 1
Rate.Creature.Elite.Elite.HP = 1
Rate.Creature.Elite.RAREELITE.HP = 1
Rate.Creature.Elite.WORLDBOSS.HP = 1
Rate.Creature.Elite.RARE.HP = 1


# Resting points grow rates (1 - normal, 2 - double rate, 0.5 - half rate, etc) from standard values
Rate.Rest.InGame = 1
Rate.Rest.Offline.InTavernOrCity = 3
Rate.Rest.Offline.InWilderness = 1

# Damage after fall rate. (1 - standard, 2 - double damage, 0.5 - half damage, etc)
Rate.Damage.Fall = 0.5

# Skill chance values (0..100) 
# default: 100-75-25-0
SkillChance.Orange = 100
SkillChance.Yellow = 75
SkillChance.Green  = 25
SkillChance.Grey   = 0

#Aggro radius percent or off.
#          0   - off (0%)
# Default: 1   - 100% 
#          1.5 - 150%
Rate.Creature.Aggro = 1

# Default remote console port
Ra.Port = 3443

# Log remote console connections
Ra.Log = 1

# Minimum level that's required to login,3 by default
Ra.MinLevel = 3

# Kick client on wrong pass
Ra.Secure = 1

# Maximum overspeed ping count before player kick (minimum is 2, 0 used for disable check)
# Default: 10
MaxOverspeedPings = 10


# Unload grids (if you have lot memory you can disbale it to speed up player move to new grids second time)
#          0 (not unload grids)
# Default: 1 (unload grids)
GridUnload = 1;


# All times are in milliseconds.

# Default socket select time
SocketSelectTime = 10000

# Default grid clean up delay
GridCleanUpDelay = 300000

# Default map update interval
MapUpdateInterval = 100

# Default weather update interval
ChangeWeatherInterval = 600000

# Default PlayerSaveInterval
PlayerSaveInterval = 900000

# Default WorldServerPort
WorldServerPort = 8085


# Beep at mangosd start finished (mostly work only at Unix/Linux systems)
# Default: 1 
BeepAtStart = 1

Realmd

# MaNGOS realmd configuration file
ConfVersion=2006060401

# Database connection settings for the realm server.
# Default: hostname;port;username;password;database
#          .;somenumber;username;password;database - use named pipes at Windows
#                Named pipes: mySQL required adding "enable-named-pipe" to [mysqld] section my.ini
#          .;/path/to/unix_socket;username;password;database - use Unix sockets at Unix/Linux
#                Unix sockets: experimental, not tested
LoginDatabaseInfo = "XXXXX.game-server.cc;3306;root;pass;realmd"

# Settings for maximum database-ping interval (minutes between pings)
MaxPingTime = 30

# Default RealmServerPort
RealmServerPort = 3724

# Server console level of logging
# 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
# Default: 0
LogLevel = 0

# Logfile name 
#    empty name disable creating log file: LogFile = 
# Default: "Server.log" - not recommended.
LogFile = "Realmd.log"

# Server file level of logging
# 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
# Default: 0
LogFileLevel = 0

# Color for messages (format "normal_color details_color debug_color error_color)
# Colors: 0 - BLACK, 1 - RED, 2 - GREEN,  3 - BROWN, 4 - BLUE, 5 - MAGENTA, 6 -  CYAN, 7 - GREY, 
#         8 - YELLOW, 9 - LRED, 10 - LGREEN, 11 - LBLUE, 12 - LMAGENTA, 13 - LCYAN, 14 - WHITE
# Default: "" - none colors
#          "13 7 11 9" - for example :)
LogColors = ""

# Used processors mask for multi-processors system (Used only at Windows)
# Default: 0 (selected by OS)
#          number (bitmask value of selected processors)
UseProcessors = 0

# Process proirity setting (Used only at Windows)
#          0 (Normal)
# Default: 1 (HIGH)
ProcessPriority = 1

For privacy, I have censored the DNS with "XXXXX".

Additional notes:

• Ports 3306/3724/8085 are correctly forwarded (double checked with Open Port Check Tool)
• Hosts file is modified with the DNS and 127.0.0.1
• Realmd database IP is set at the DNS (XXXXX.game-server.cc)

Everything runs fine minus the realmlist loop problem.

Any suggestions or tips will greatly be appreciated, and I'd be more than happy to hit that +Rep button if the suggestion works.

[methos0072001]

Nearly 10 hours have gone by and no one knows anything? This makes me a sad sad panda. >

[Eleatha]

try this:

in mangosd.conf set your logindatabase- and worlddatabaseinfo to local:

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

in realmd.conf set your realmlist to local:

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

set your external ip or dnsname in your realmlist in your realm database
you can do this with an sql editor like Navicat

good luck

[methos0072001]

Thanks for the suggestion, it worked like a charm. Seems like every guide was telling me something different.

[Eleatha]

you're welcome, I like to see happy panda's