UCS.exe crashes, and how to update binaries to most recent

Techungry · #1 02-01-2019, 11:59 AM

No joy on those changes to the json loginserver section resolving my issue. Still having UCS crashes. It seems to fail before or at the point of checking the key with the DB specifically in the Database::VerifyMailKey function. Enabled DB query logging and updated log below. In the DB the mailkey is shown as 7100000A0BA648B3.

[02-01-2019 :: 11:04:47] [MySQL Query] SELECT `value` FROM `variables` WHERE `varname` = 'RuleSet' (0 rows returned)
[02-01-2019 :: 11:04:47] [MySQL Query] SELECT ruleset_id FROM rule_sets WHERE name='default' (1 row returned)
[02-01-2019 :: 11:04:47] [MySQL Query] SELECT rule_name, rule_value FROM rule_values WHERE ruleset_id=1 (620 rows returned)
[02-01-2019 :: 11:04:47] [UCS Server] Loaded default rule set 'default'
[02-01-2019 :: 11:04:47] [UCS Server] Initialized dynamic dictionary entries
[02-01-2019 :: 11:04:47] [UCS Server] Expiring mail...
[02-01-2019 :: 11:04:47] [MySQL Query] SELECT COUNT(*) FROM `mail` (1 row returned)
[02-01-2019 :: 11:04:47] [UCS Server] There are 0 messages in the database.
[02-01-2019 :: 11:04:47] [MySQL Query] DELETE FROM `mail` WHERE `status`=4 AND `timestamp` < 1549037087 (0 rows affected)
[02-01-2019 :: 11:04:47] [UCS Server] Expired 0 trash messages.
[02-01-2019 :: 11:04:47] [MySQL Query] DELETE FROM `mail` WHERE `status` = 3 AND `timestamp` < 1517501087 (0 rows affected)
[02-01-2019 :: 11:04:47] [UCS Server] Expired 0 read messages.
[02-01-2019 :: 11:04:47] [MySQL Query] DELETE FROM `mail` WHERE `status`=1 AND `timestamp` < 1517501087 (0 rows affected)
[02-01-2019 :: 11:04:47] [UCS Server] Expired 0 unread messages.
[02-01-2019 :: 11:04:47] [UCS Server] Loading chat channels from the database.
[02-01-2019 :: 11:04:47] [MySQL Query] SELECT `name`, `owner`, `password`, `minstatus` FROM `chatchannels` (0 rows returned)
[02-01-2019 :: 11:06:08] [UCS Server] Connection type is Combined (RoF2)
[02-01-2019 :: 11:06:08] [UCS Server] Received login for user SOE.EQ.!The King's Lair (Solo Tuned EQEmu Server).Poka with key 0BA648B3
[02-01-2019 :: 11:06:08] [MySQL Query] SELECT `mailkey` FROM `character_data` WHERE `name`='Poka' LIMIT 1 (0 rows returned)
[02-01-2019 :: 11:06:08] [Crash] EXCEPTION_ACCESS_VIOLATION
[02-01-2019 :: 11:06:08] [Crash] SymInit: Symbol-SearchPath: '.;C:\EQEmuServer;C:\EQEmuServer;C:\WINDOWS;C:\WIN DOWS\system32;SRV*C:\websymbols*http://msdl.microsoft.com/download/symbols;', symOptions: 530, UserName: 'Giles King'
[02-01-2019 :: 11:06:08] [Crash] OS-Version: 6.2.9200 () 0x300-0x1
[02-01-2019 :: 11:06:08] [Crash] C:\EQEmuServer\ucs.exe:ucs.exe (000B0000), size: 1818624 (result: 0), SymType: 'PDB', PDB: 'C:\EQEmuServer\ucs.exe'
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\SYSTEM32\ntdll.dll:ntdll.dll (77210000), size: 1638400 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\ntdll.dll', fileVersion: 6.2.17134.471
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\KERNEL32.DLL:KERNEL32.DLL (73710000), size: 917504 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\KERNEL32.DLL', fileVersion: 6.2.17134.1
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\KERNELBASE.dll:KERNELBASE.dll (75DE0000), size: 1982464 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\KERNELBASE.dll', fileVersion: 6.2.17134.441
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\WS2_32.dll:WS2_32.dll (766F0000), size: 421888 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\WS2_32.dll', fileVersion: 6.2.17134.1
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\RPCRT4.dll:RPCRT4.dll (769E0000), size: 786432 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\RPCRT4.dll', fileVersion: 6.2.17134.471
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\SspiCli.dll:SspiCli.dll (73280000), size: 131072 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\SspiCli.dll', fileVersion: 6.2.17134.376
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\CRYPTBASE.dll:CRYPTBASE.dll (73270000), size: 40960 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\CRYPTBASE.dll', fileVersion: 6.2.17134.1
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\bcryptPrimitives.dll:bcryptPri mitives.dll (73CC0000), size: 360448 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\bcryptPrimitives.dll', fileVersion: 6.2.17134.471
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\sechost.dll:sechost.dll (76760000), size: 278528 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\sechost.dll', fileVersion: 6.2.17134.319
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\PSAPI.DLL:PSAPI.DLL (765D0000), size: 24576 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\PSAPI.DLL', fileVersion: 6.2.17134.1
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\USER32.dll:USER32.dll (73A80000), size: 1626112 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\USER32.dll', fileVersion: 6.2.17134.376
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\win32u.dll:win32u.dll (75FD0000), size: 94208 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\win32u.dll', fileVersion: 6.2.17134.1
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\GDI32.dll:GDI32.dll (75AD0000), size: 139264 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\GDI32.dll', fileVersion: 6.2.17134.285
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\gdi32full.dll:gdi32full.dll (76ED0000), size: 1458176 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\gdi32full.dll', fileVersion: 6.2.17134.471
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\msvcp_win.dll:msvcp_win.dll (76960000), size: 512000 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\msvcp_win.dll', fileVersion: 6.2.17134.1
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\ucrtbase.dll:ucrtbase.dll (735F0000), size: 1171456 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\ucrtbase.dll', fileVersion: 6.2.17134.319
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\ADVAPI32.dll:ADVAPI32.dll (73D20000), size: 491520 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\ADVAPI32.dll', fileVersion: 6.2.17134.471
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\msvcrt.dll:msvcrt.dll (73E00000), size: 782336 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\msvcrt.dll', fileVersion: 7.0.17134.1
[02-01-2019 :: 11:06:08] [Crash] C:\EQEmuServer\LIBMYSQL.dll:LIBMYSQL.dll (64530000), size: 2924544 (result: 0), SymType: '-exported-', PDB: 'C:\EQEmuServer\LIBMYSQL.dll'
[02-01-2019 :: 11:06:08] [Crash] C:\EQEmuServer\zlib1.dll:zlib1.dll (731A0000), size: 90112 (result: 0), SymType: '-exported-', PDB: 'C:\EQEmuServer\zlib1.dll', fileVersion: 1.2.11.0
[02-01-2019 :: 11:06:08] [Crash] C:\EQEmuServer\libsodium.dll:libsodium.dll (72570000), size: 307200 (result: 0), SymType: '-exported-', PDB: 'C:\EQEmuServer\libsodium.dll', fileVersion: 1.0.16.0
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\SYSTEM32\IPHLPAPI.DLL:IPHLPAPI.DLL (72DC0000), size: 196608 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\IPHLPAPI.DLL', fileVersion: 6.2.17134.1
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\SYSTEM32\USERENV.dll:USERENV.dll (720E0000), size: 135168 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\USERENV.dll', fileVersion: 6.2.17134.1
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\profapi.dll:profapi.dll (73CA0000), size: 98304 (result: 0), SymType: '-nosymbols-', PDB: 'C:\WINDOWS\System32\profapi.dll', fileVersion: 6.2.17134.1
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\SYSTEM32\VERSION.dll:VERSION.dll (73170000), size: 32768 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\VERSION.dll', fileVersion: 6.2.17134.1
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\SYSTEM32\VCRUNTIME140.dll:VCRUNTIME140. dll (72550000), size: 86016 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\VCRUNTIME140.dll', fileVersion: 14.13.26020.0
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\IMM32.DLL:IMM32.DLL (75C00000), size: 155648 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\IMM32.DLL', fileVersion: 6.2.17134.1
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\system32\napinsp.dll:napinsp.dll (72080000), size: 69632 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\napinsp.dll', fileVersion: 6.2.17134.1
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\system32\pnrpnsp.dll:pnrpnsp.dll (72060000), size: 90112 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\pnrpnsp.dll', fileVersion: 6.2.17134.1
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\system32\NLAapi.dll:NLAapi.dll (72040000), size: 77824 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\NLAapi.dll', fileVersion: 6.2.17134.1
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\mswsock.dll:mswsock.dll (73110000), size: 352256 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\mswsock.dll', fileVersion: 6.2.17134.1
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\SYSTEM32\DNSAPI.dll

NSAPI.dll (72A00000), size: 581632 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\DNSAPI.dll', fileVersion: 6.2.17134.441
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\NSI.dll:NSI.dll (73A70000), size: 28672 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\NSI.dll', fileVersion: 6.2.17134.1
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\winrnr.dll:winrnr.dll (72030000), size: 49152 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\winrnr.dll', fileVersion: 6.2.17134.1
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\wshbth.dll:wshbth.dll (72010000), size: 69632 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\wshbth.dll', fileVersion: 6.2.17134.1
[02-01-2019 :: 11:06:08] [Crash] C:\Windows\System32\rasadhlp.dll:rasadhlp.dll (729F0000), size: 32768 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\rasadhlp.dll', fileVersion: 6.2.17134.1
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\fwpuclnt.dll:fwpuclnt.dll (729A0000), size: 323584 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\fwpuclnt.dll', fileVersion: 6.2.17134.1
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\SYSTEM32\bcrypt.dll:bcrypt.dll (730A0000), size: 102400 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\bcrypt.dll', fileVersion: 6.2.17134.112
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\powrprof.dll:powrprof.dll (770D0000), size: 282624 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\powrprof.dll', fileVersion: 6.2.17134.1
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\System32\kernel.appcore.dll:kernel.appc ore.dll (75580000), size: 61440 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\kernel.appcore.dll', fileVersion: 6.2.17134.112
[02-01-2019 :: 11:06:08] [Crash] C:\WINDOWS\SYSTEM32\dbghelp.dll:dbghelp.dll (70070000), size: 1581056 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\dbghelp.dll', fileVersion: 6.2.17134.1
[02-01-2019 :: 11:06:08] [Crash] c:\projects\eqemu\common\mysql_request_row.cpp (73): MySQLRequestRow::operator[]
[02-01-2019 :: 11:06:09] [Crash] c:\projects\eqemu\ucs\database.cpp (19

: Database::VerifyMailKey
[02-01-2019 :: 11:06:09] [Crash] c:\projects\eqemu\ucs\clientlist.cpp (636): Clientlist::Process
[02-01-2019 :: 11:06:09] [Crash] c:\projects\eqemu\ucs\ucs.cpp (153): main
[02-01-2019 :: 11:06:09] [Crash] d:\agent\_work\2\s\src\vctools\crt\vcstartup\src\s tartup\exe_common.inl (28

: __scrt_common_main_seh
[02-01-2019 :: 11:06:09] [Crash] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 73728484)
[02-01-2019 :: 11:06:09] [Crash] 73728484 (KERNEL32): (filename not available): BaseThreadInitThunk
[02-01-2019 :: 11:06:09] [Crash] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77273AB

[02-01-2019 :: 11:06:09] [Crash] 77273AB8 (ntdll): (filename not available): RtlAreBitsSet
[02-01-2019 :: 11:06:09] [Crash] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77273A8

[02-01-2019 :: 11:06:09] [Crash] 77273A88 (ntdll): (filename not available): RtlAreBitsSet

Techungry · #2 02-01-2019, 12:53 PM

The actual characters name is "Pokay" in the database. It's read incorrectly before it ever gets to VerifyMailKey as you can see from:

[02-01-2019 :: 11:06:08] [UCS Server] Received login for user SOE.EQ.!The King's Lair (Solo Tuned EQEmu Server).Poka with key 0BA648B3

By the time we get to Database::VerifyMailKey the query only ends up searching "Poka". That query returns 0 results, and everything crashes and burns after that.

So I think there is at least a check missing somewhere if the query in Database::VerifyMailKey returns nothing to catch the exception case.

I think the problem is some place in clientlist.cpp around here. By the time it hits the log line at teh end 1 character has been striped off the char name.

VARSTRUCT_DECODE_STRING(MailBox, PacketBuffer);

if (strlen(PacketBuffer) != 9) {
Log(Logs:

etail, Logs::UCS_Server,
"Mail key is the wrong size. Version of world incompatible with UCS.");
KeyValid = false;
break;
}
ConnectionTypeIndicator = VARSTRUCT_DECODE_TYPE(char, PacketBuffer);

(*it)->SetConnectionType(ConnectionTypeIndicator);

VARSTRUCT_DECODE_STRING(Key, PacketBuffer);

std::string MailBoxString = MailBox, CharacterName;

// Strip off the SOE.EQ.<shortname>.
//
std::string::size_type LastPeriod = MailBoxString.find_last_of(".");

if (LastPeriod == std::string::npos)
CharacterName = MailBoxString;
else
CharacterName = MailBoxString.substr(LastPeriod + 1);

Log(Logs:

etail, Logs::UCS_Server, "Received login for user %s with key %s",
MailBox, Key);