Realm server not showing realms...

Hm is the realmid correct in the mangosd.conf and is the correct version number being shown in the realms table for that realm?

Yes. It worked a few months ago but I have not changed anything nor have I added accounts, until now. First thing I did was check my configuration files, followed by the database. This one has me.

@Xenithar - Could you post you Realmist entry here, i'll try applying it to my server to try and get to the bottom of it

Sorry, I replied in our thread. I will post it here with my server name and address hidden for my own security reasons.
[code]
'1', 'HiddenName', 'my.hostname.com', '8085', '1', '64', '2', '0', '0.0625', '5875 6005 6141 '
[/code]
Also, note that when starting the realm server in debug, a thread starts and exits instantly. Seems odd and may be the issue. I will debug this for a while tonight because it is a real show-stopper. If I figure it out I will report back.
[code]
Reading symbols from /home/---/zero/bin/realmd...done.
(gdb) run
Starting program: /home/---/zero/bin/realmd
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/i386-linux-gnu/i686/cmov/libthread_db.so.1".
[New Thread 0xb765eb70 (LWP 3076)]
[Thread 0xb765eb70 (LWP 3076) exited]
20003 [realm-daemon]
to stop.

Using configuration file ../etc/realmd.conf.
Login Database total connections: 2
MySQL client library: 5.5.38
MySQL server ver: 5.5.38-0+wheezy1
MySQL client library: 5.5.38
MySQL server ver: 5.5.38-0+wheezy1
[New Thread 0xb765eb70 (LWP 3078)]
Added realm id 1, name 'HiddenName'
[/code]

*UPDATE*

I am seeing code in the main source file that is not being logged in my log-file.
[code]
DETAIL_LOG("%s (Library: %s)", OPENSSL_VERSION_TEXT, SSLeay_version(SSLEAY_VERSION));
if (SSLeay() {
DETAIL_LOG("WARNING: Outdated version of OpenSSL lib. Logins to server may not work!");
DETAIL_LOG("WARNING: Minimal required version [OpenSSL 0.9.8k]");
}
DETAIL_LOG("Using ACE: %s", ACE_VERSION);
[/code]
The log lines detailing my SSL and ACE libraries are not appearing in my log. This is under both 32bit and 64bit Debian.

Alright, calling it quits for the night. I have my day job tomorrow and I must get up at 0630hrs, so I need to sleep. I have tried the following so far, none of which worked.

[list]
[*]Rebuilding the realm and world servers
[*]Running the realm server as a daemon outside GDB
[*]Running the realm server normally outside of GDB
[*]Running the realm server as a daemon in GDB
[*]Running the realm server normally inside GDB
[*]Dropping and recreating the realmlist database
[*]Doing my configuration files from scratch
[/list]
I will sleep on it and try again tomorrow. Oh, and I checked my internal DNS server, my router, and everything else. The issue is in the realm server. I may start editing code on my end for testing purposes to find out what thread is starting and dying quickly. I also need to figure out why so many things are not being logged despite being coded to do so.

Alright, here we go! Information about my server. This still does not work in Linux.

Realm DB:
[code]
1, Yurak, , 8085, 1, 64, 2, 0, 0.1875, 5875 6005 6141
[/code]

Mangos configuration:
[code]
[MangosdConf]
ConfVersion=2015010201

RealmID = 1
DataDir = "/home/---/zero/"
LogsDir = "/home/---/zero/logs/"
LoginDatabaseInfo = "127.0.0.1;3306;zero;---;zp_realm"
WorldDatabaseInfo = "127.0.0.1;3306;zero;---;zp_world"
CharacterDatabaseInfo = "127.0.0.1;3306;zero;---;zp_characters"
ScriptDev2DatabaseInfo = "127.0.0.1;3306;zero;---;zp_world"
LoginDatabaseConnections = 1
WorldDatabaseConnections = 1
CharacterDatabaseConnections = 1
ScriptDev2DatabaseConnections= 1
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"

UseProcessors = 0
ProcessPriority = 1
Compression = 3
PlayerLimit = 32
SaveRespawnTimeImmediately = 1
MaxOverspeedPings = 2
GridUnload = 1
GridCleanUpDelay = 300000
MapUpdateInterval = 100
ChangeWeatherInterval = 600000
PlayerSave.Interval = 900000
PlayerSave.Stats.MinLevel = 0
PlayerSave.Stats.SaveOnlyOnLogout = 1
vmap.enableLOS = 1
vmap.enableHeight = 1
vmap.ignoreSpellIds = "7720"
vmap.enableIndoorCheck = 1
DetectPosCollision = 1
TargetPosRecalculateRange = 1.5
mmap.enabled = 1
mmap.ignoreMapIds = ""
UpdateUptimeInterval = 10
MaxCoreStuckTime = 0
AddonChannel = 1
CleanCharacterDB = 1

GameType = 1
RealmZone = 2
DBC.Locale = 0
DeclinedNames = 0
StrictPlayerNames = 1
StrictCharterNames = 0
StrictPetNames = 1
MinPlayerName = 2
MinCharterName = 2
MinPetName = 2
CharactersCreatingDisabled = 0
CharactersPerAccount = 50
CharactersPerRealm = 10
SkipCinematics = 0
MaxPlayerLevel = 60
StartPlayerLevel = 1
StartPlayerMoney = 0
MaxHonorPoints = 75000
StartHonorPoints = 0
MinHonorKills = 15
MaintenanceDay = 3
InstantLogout = 1
MountCost = 100000
TrainMountCost = 900000
MinTrainMountLevel = 40
EpicMountCost = 1000000
TrainEpicMountCost = 9000000
MinTrainEpicMountLevel = 60
AllFlightPaths = 0
AlwaysMaxSkillForLevel = 0
ActivateWeather = 1
CastUnstuck = 1
MaxSpellCastsInChain = 20
RabbitDay = 0
Instance.IgnoreLevel = 0
Instance.IgnoreRaid = 0
Instance.ResetTimeHour = 4
Instance.UnloadDelay = 1800000
Quests.LowLevelHideDiff = -1
Quests.HighLevelHideDiff = 7
Quests.IgnoreRaid = 0
Guild.EventLogRecordsCount = 100
TimerBar.Fatigue.GMLevel = 4
TimerBar.Fatigue.Max = 60
TimerBar.Breath.GMLevel = 4
TimerBar.Breath.Max = 180
TimerBar.Fire.GMLevel = 4
TimerBar.Fire.Max = 1
MaxPrimaryTradeSkill = 2
TradeSkill.GMIgnore.MaxPrimarySkillsCount = 4
TradeSkill.GMIgnore.Level = 4
TradeSkill.GMIgnore.Skill = 4
MinPetitionSigns = 9
MaxGroupXPDistance = 74
MailDeliveryDelay = 3600
MassMailer.SendPerTick = 10
PetUnsummonAtMount = 0
Event.Announce = 0
BeepAtStart = 1
ShowProgressBars = 1
WaitAtStartupError = 0
PlayerCommands = 0
[/code]

Realm daemon output on startup:
[code]
20006 [realm-daemon]
to stop.

Using configuration file ../etc/realmd.conf.
Login Database total connections: 2
MySQL client library: 5.5.38
MySQL server ver: 5.5.38-0+wheezy1
MySQL client library: 5.5.38
MySQL server ver: 5.5.38-0+wheezy1
Added realm id 1, name 'Yurak'
[/code]
Still not working. This build is from Monday this week, so it is recent.

Build from this morning. Some thread STILL simply quits when starting.
[code]
(gdb) run
Starting program: /home/---/zero/bin/realmd
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/i386-linux-gnu/i686/cmov/libthread_db.so.1".
[New Thread 0xb765eb70 (LWP 17691)]
[Thread 0xb765eb70 (LWP 17691) exited]
20006 [realm-daemon]
to stop.

Using configuration file ../etc/realmd.conf.
Login Database total connections: 2
MySQL client library: 5.5.38
MySQL server ver: 5.5.38-0+wheezy1
MySQL client library: 5.5.38
MySQL server ver: 5.5.38-0+wheezy1
[New Thread 0xb765eb70 (LWP 17692)]
Added realm id 1, name 'Yurak'
[/code]
Note that some thread starts and stops. Perhaps this is the issue, but there is nothing in the log indicating an error nor is there any error output elsewhere, so I cannot figure this out. I have been over the code a dozen times or more and it LOOKS correct, so why is the thread exiting?

Alright, I just updated the OS with a full upgrade, cloned and built the latest from the official repo, rebooted the box, started things, and same issue. Something is very wrong here but I am not sure what. The realm ID matches and things look OK, but it refuses to allow me to select a realm. Once again when I started the realm daemon a thread started and exited. I still believe this is our issue.

I understand this works on Ubuntu, but considering Debian is one of the three most-used distros out there and not Ubuntu, this should be important to us. I am now going to dig into the code again and see if I can figure out why that thread exits immediately and whether or not it is our problem.

*UPDATE*

I am still not having information logged which should be logged.
[code]
sLog.outString("%s [realm-daemon]", _FULLVERSION(REVISION_DATE, REVISION_TIME, REVISION_NR, REVISION_ID));
sLog.outString(" to stop.\n");
sLog.outString("Using configuration file %s.", cfg_file);
[/code]
Logging stops here for some reason. The following is in the sources but does not get logged OR displayed on-screen.
[code]
DETAIL_LOG("%s (Library: %s)", OPENSSL_VERSION_TEXT, SSLeay_version(SSLEAY_VERSION));
DETAIL_LOG("Using ACE: %s", ACE_VERSION);
sLog.outBasic("Max allowed open files is %d", ACE::max_handles());
[/code]
Also, the following code is what I believe the mystery thread is, but am not sure how to figure out why it is exiting.
[code]
#if defined (ACE_HAS_EVENT_POLL) || defined (ACE_HAS_DEV_POLL)
ACE_Reactor::instance(new ACE_Reactor(new ACE_Dev_Poll_Reactor(ACE::max_handles(), 1), 1), true);
#else
ACE_Reactor::instance(new ACE_Reactor(new ACE_TP_Reactor(), true), true);
#endif
[/code]
Aside from commenting this section, rebuilding, and seeing if the mystery thread is gone, is there a way to troubleshoot this more efficiently? I am not familiar at all with ACE. I normally use standard threading.

Still not working. I cannot see realms at all. The realmd process starts and says it added my realm with the id '1', but it does not show up in the client. When I put this on my laptop I had no way to select a realm. I was unable to join my own server until I manually added "realmname " to config.wtf in the WTF folder.

I have sometimes seen the realmflags field in the realmlist table changed to 6, which prevented me seeing the realm in the client

The flag of my testrealm was sometimes 26 and I had to change it manually until I changed it permanently in my mangosd.conf