EQEmulator Forums
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   UCS.exe crashes, and how to update binaries to most recent (https://www.eqemulator.org/forums/showthread.php?t=42303)

Techungry 01-28-2019 03:09 PM
UCS.exe crashes, and how to update binaries to most recent
 
Hi everyone. I recently setup my first server using the Window's installer, and everything is generally working well with one exception. From the client I am getting errors about being unable to connect to the UCS server when running locally. In addition, it appears that UCS.exe is just repeatedly crashing over and over. I am fairly technically competent but I am not seeing anything that I can use here. Here is the error, and it seems like its something very basic like a dependency missing?

On that note, what is the general process for updating the DB and binaries from the installer for an already running server? Backup the DB and reinstall?

[01-28-2019 :: 13:57:13] [UCS Server] Loaded default rule set 'default'
[01-28-2019 :: 13:57:13] [UCS Server] Initialized dynamic dictionary entries
[01-28-2019 :: 13:59:11] [Crash] EXCEPTION_ACCESS_VIOLATION
[01-28-2019 :: 13:59:11] [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'
[01-28-2019 :: 13:59:11] [Crash] OS-Version: 6.2.9200 () 0x300-0x1
[01-28-2019 :: 13:59:11] [Crash] C:\EQEmuServer\ucs.exe:ucs.exe (010D0000), size: 1810432 (result: 0), SymType: 'PDB', PDB: 'C:\EQEmuServer\ucs.exe'
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [Crash] C:\EQEmuServer\libsodium.dll:libsodium.dll (73220000), size: 307200 (result: 0), SymType: '-exported-', PDB: 'C:\EQEmuServer\libsodium.dll', fileVersion: 1.0.16.0
[01-28-2019 :: 13:59:11] [Crash] C:\EQEmuServer\LIBMYSQL.dll:LIBMYSQL.dll (6ECC0000), size: 2924544 (result: 0), SymType: '-exported-', PDB: 'C:\EQEmuServer\LIBMYSQL.dll'
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [Crash] C:\EQEmuServer\zlib1.dll:zlib1.dll (62E80000), size: 139264 (result: 0), SymType: '-exported-', PDB: 'C:\EQEmuServer\zlib1.dll', fileVersion: 1.2.8.0
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [Crash] C:\WINDOWS\SYSTEM32\VCRUNTIME140.dll:VCRUNTIME140. dll (73200000), size: 86016 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\VCRUNTIME140.dll', fileVersion: 14.13.26020.0
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:11] [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
[01-28-2019 :: 13:59:12] [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
[01-28-2019 :: 13:59:12] [Crash] C:\WINDOWS\SYSTEM32\DNSAPI.dll:DNSAPI.dll (72A00000), size: 581632 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\DNSAPI.dll', fileVersion: 6.2.17134.441
[01-28-2019 :: 13:59:12] [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
[01-28-2019 :: 13:59:12] [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
[01-28-2019 :: 13:59:12] [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
[01-28-2019 :: 13:59:12] [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
[01-28-2019 :: 13:59:12] [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
[01-28-2019 :: 13:59:12] [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
[01-28-2019 :: 13:59:12] [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
[01-28-2019 :: 13:59:12] [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
[01-28-2019 :: 13:59:12] [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
[01-28-2019 :: 13:59:12] [Crash] c:\projects\eqemu\common\mysql_request_row.cpp (73): MySQLRequestRow::operator[]
[01-28-2019 :: 13:59:12] [Crash] c:\projects\eqemu\ucs\database.cpp (198): Database::VerifyMailKey
[01-28-2019 :: 13:59:12] [Crash] c:\projects\eqemu\ucs\clientlist.cpp (636): Clientlist::Process
[01-28-2019 :: 13:59:12] [Crash] c:\projects\eqemu\ucs\ucs.cpp (153): main
[01-28-2019 :: 13:59:12] [Crash] d:\agent\_work\2\s\src\vctools\crt\vcstartup\src\s tartup\exe_common.inl (288): __scrt_common_main_seh
[01-28-2019 :: 13:59:12] [Crash] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 73728484)
[01-28-2019 :: 13:59:12] [Crash] 73728484 (KERNEL32): (filename not available): BaseThreadInitThunk
[01-28-2019 :: 13:59:12] [Crash] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77273AB8)
[01-28-2019 :: 13:59:12] [Crash] 77273AB8 (ntdll): (filename not available): RtlAreBitsSet
[01-28-2019 :: 13:59:12] [Crash] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77273A88)
[01-28-2019 :: 13:59:12] [Crash] 77273A88 (ntdll): (filename not available): RtlAreBitsSet

phantomghost 01-28-2019 03:28 PM
As far as updating, run eqemu_server.pl and can choose to update there.

Not sure on the error. However, you could test your binary theory above as there is a prompt here for binaries.

This file does quite a bit ... Can move it to a new folder to create a new server... Just run it and look at prompts, mostly use assets and database.

kokey98 01-28-2019 03:41 PM
back it up for sure... mistakes are sometimes made, and this would avoid 99% of them that you cannot control.

binaries are only compiled occasionally.. no idea how to check. i'm sure they are located somewhere in the github repositories and you can check a date there.

you can compile on your own and still make use of the eqemu-server.pl. i make sure my binaries are always backed up in case the script (caused by me being stupid) replaces them. just copy over any accident and its fixed.

you can still use the script to update your db. under assets or database, if that word is visible, obivously look there first? check_db_updates etc... [sic]. if you have bots, you also want to do the bots update option too.

now, if by random chance any of these update scripts happen to be temporarily borked, you aren't screwed because of the backup. it'll be fixed at some point.

if you watch the fixes on github, just wait a day or three before updating.

no idea on error, but only dependencies mentioned are the libsodium and libmysql, and it seems they at least exist? are they the right versions? did it work before? etc... no idea what else to do to troubleshoot though.

Techungry 01-28-2019 07:56 PM
Thanks both! I just copied the Emu folder and did a binary update of both the server binaries and the dlls. Ill see what that does for me. There was for sure different versions pulled down than what I was running.

Techungry 01-28-2019 08:15 PM
That seemed to have an effect, and I don't see exceptions in the log any longer, but UCS still doesn't appear to actually do anything after this:

[01-28-2019 :: 16:30:49] [UCS Server] Loaded default rule set 'default'
[01-28-2019 :: 16:30:49] [UCS Server] Initialized dynamic dictionary entries

And I still get an error in the client, like when I go afk:

[Mon Jan 28 19:06:14 2019] You are now A.F.K. (Away From Keyboard).
[Mon Jan 28 19:06:14 2019] Please wait until we reconnect you with the Universal Chat service. Your request has not been sent.

How would one turn up the logging on UCS? I tried placing a log.ini file in the main EQEmu folder with various settings I found on old posts but still not seeing any detail at all in the log (literally get only the two lines above).

Uleat 01-28-2019 08:44 PM
Go into your database..

find the `logsys_categories` table..

find entry `UCS_Server`(id 31 most likely)..

ensure the `log_to_file` column has a value greater than '0' ('3' is most information)..

you can also set the `log_to_console` column the same way.

Techungry 01-29-2019 01:49 PM
Thanks, very helpful info on how to enable the logging to be higher, although I did get strange behavior related to it. I set the UCS level to 3 for console and logging and that that point I got more detail in console but now get no ucsxxx.log file at all even when i turn it back to 1 but I am still getting crash reports?? Anyway, I think this is coming down to an issue with the clients connecting or authenticating or similar. I still get a crash every time someone zones I think, with the above same crash report. When I try to join a chat channel I get the following:

[UCS Server] Starting EQEmu Universal Chat Server.
[UCS Server] Connecting to MySQL...
[UCS Server] Loaded default rule set 'default'
[UCS Server] Expiring mail...
[UCS Server] There are 0 messages in the database.
[UCS Server] Expired 0 trash messages.
[UCS Server] Expired 0 read messages.
[UCS Server] Expired 0 unread messages.
[UCS Server] Loading chat channels from the database.
[UCS Server] Received Opcode: 4000
[UCS Server] Player: Ssthis, Sent Message: [join king
[UCS Server] Client not found.

Given that, and the crash lines related to Clientlist::Process and Databse::VerifyMailKey I am out of ideas.
* I have placed my public DNS domain in the clients host file and am able to ping it.
* I am testing from the local lan on the same network as the server.
* I opened port 7778 (left the default) on the firewall of both the server and client in both directions for TCP and UDP.
* I tried port 10000 just in case with same results.
* Chat:EnableMailKeyIPVerification is true in DB, I haven't touched anything related to chat/mail in the DB.
* From the above there is clearly communication happening between the client and UCS since it responded to the join command with client not found.

What am I missing?

Techungry 01-31-2019 07:35 PM
Ok, I have now pulled both the latest and stable binaries using Akka's installer with the same results. I even tried running the ROF client on the server itself. I am convinced it's not me. Has anyone who pulled the binaries down anytime recently actually got UCS chat (/join) or email working?

I'm going to post on the Discord as well.

chrsschb 01-31-2019 07:53 PM
Mine is working, but only for external connections. Judging by my console I'm having the same issue as you (or at least similar).

https://i.imgur.com/dJNxnmB.png

This one is me logging into the same account but from my laptop (tethered to my phone, so external)

https://i.imgur.com/u3tBhBu.png


Besides the obvious internal vs external, I noticed the keys are different on the internal test: 0F0 vs 010

Uleat 01-31-2019 09:02 PM
This is mine from last night using current code:
Quote:
[01-30-2019 :: 19:13:06] [UCS Server] Received login for user SOE.EQ.Wonderland.Shalana with key 4602FF6A
[01-30-2019 :: 19:13:06] [UCS Server] DB key is [0100007F4602FF6A], Client key is [0100007F4602FF6A]
Not sure what is going on there...


EDIT: I'm on a localhost server.

chrsschb 01-31-2019 09:59 PM
For my issue at least, getting rid of loginserver2 and removing the 1 from the other loginserver fixed my issue. I don't know why a local login was messing up the mailkey but for anyone else who might run into this, this is the fix.

spiritchaser 01-31-2019 11:53 PM
I have a dual login setup for both local and private (external) without any issues at all. I hadn't tested out the mail system until I saw this post but it all seems to be working fine. I set the ucs logs to level 3 for both console and file and didn't get any errors or crashes with chat or mail. I used two seperate player accounts to successfully send/receive mail.

Techungry 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:DNSAPI.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 (198): 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 (288): __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: 77273AB8)
[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: 77273A88)
[02-01-2019 :: 11:06:09] [Crash] 77273A88 (ntdll): (filename not available): RtlAreBitsSet

Techungry 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::Detail, 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::Detail, Logs::UCS_Server, "Received login for user %s with key %s",
MailBox, Key);

spiritchaser 02-01-2019 01:22 PM
Mine works fine. This is what it looks like normally. Did you try deleting that poka character and creating a new one ? Bugs in your database can happen.
Code:
[02-01-2019 :: 11:16:02] [MySQL Query] SELECT `mailkey` FROM `character_data` WHERE `name`='Lumpoosa' LIMIT 1 (1 row returned)
[02-01-2019 :: 11:16:02] [MySQL Query] SELECT `id`, `account_id`, `level` FROM `character_data` WHERE `name` = 'Lumpoosa' LIMIT 1 (1 row returned)
[02-01-2019 :: 11:16:02] [MySQL Query] SELECT `id`, `name`, `level` FROM `character_data` WHERE `account_id` = 89733 AND `name` != 'Lumpoosa' (0 rows returned)
[02-01-2019 :: 11:16:02] [MySQL Query] SELECT `status`, `hideme`, `karma`, `revoked` FROM `account` WHERE `id` = '89733' LIMIT 1 (1 row returned)
[02-01-2019 :: 11:16:02] [MySQL Query] select `type`, `name` FROM `friends` WHERE `charid`=2 (0 rows returned)
[02-01-2019 :: 11:16:02] [MySQL Query] SELECT `id` FROM `character_data` WHERE `name`='Lumpoosa' LIMIT 1 (1 row returned)
[02-01-2019 :: 11:16:02] [MySQL Query] SELECT `msgid`,`timestamp`, `from`, `subject`, `status` FROM `mail` WHERE `charid`=2 (0 rows returned)
[02-01-2019 :: 11:16:19] [MySQL Query] SELECT `status`, `hideme`, `karma`, `revoked` FROM `account` WHERE `id` = '89732' LIMIT 1 (1 row returned)


All times are GMT -4. The time now is 11:37 PM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.