Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 01-28-2019, 03:09 PM
Techungry
Fire Beetle
 
Join Date: Jan 2019
Location: Georgia
Posts: 25
Default 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.dllNSAPI.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 (19: 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 (28: __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: 77273AB
[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: 77273A8
[01-28-2019 :: 13:59:12] [Crash] 77273A88 (ntdll): (filename not available): RtlAreBitsSet
Reply With Quote
  #2  
Old 01-28-2019, 03:28 PM
phantomghost
Hill Giant
 
Join Date: May 2015
Posts: 126
Default

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.
Reply With Quote
  #3  
Old 01-28-2019, 03:41 PM
kokey98
Hill Giant
 
Join Date: Dec 2012
Location: terra firma
Posts: 131
Default

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.
Reply With Quote
  #4  
Old 01-28-2019, 07:56 PM
Techungry
Fire Beetle
 
Join Date: Jan 2019
Location: Georgia
Posts: 25
Default

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.
Reply With Quote
  #5  
Old 01-28-2019, 08:15 PM
Techungry
Fire Beetle
 
Join Date: Jan 2019
Location: Georgia
Posts: 25
Default

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).
Reply With Quote
  #6  
Old 01-28-2019, 08:44 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

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.
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #7  
Old 01-29-2019, 01:49 PM
Techungry
Fire Beetle
 
Join Date: Jan 2019
Location: Georgia
Posts: 25
Default

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?
Reply With Quote
  #8  
Old 01-31-2019, 07:35 PM
Techungry
Fire Beetle
 
Join Date: Jan 2019
Location: Georgia
Posts: 25
Default

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.
Reply With Quote
  #9  
Old 01-31-2019, 07:53 PM
chrsschb's Avatar
chrsschb
Dragon
 
Join Date: Nov 2008
Location: GA
Posts: 905
Default

Mine is working, but only for external connections. Judging by my console I'm having the same issue as you (or at least similar).



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




Besides the obvious internal vs external, I noticed the keys are different on the internal test: 0F0 vs 010
Reply With Quote
  #10  
Old 01-31-2019, 09:02 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

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.
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #11  
Old 01-31-2019, 09:59 PM
chrsschb's Avatar
chrsschb
Dragon
 
Join Date: Nov 2008
Location: GA
Posts: 905
Default

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.
Reply With Quote
  #12  
Old 01-31-2019, 11:53 PM
spiritchaser
Fire Beetle
 
Join Date: Jan 2019
Posts: 29
Default

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.
Reply With Quote
  #13  
Old 02-01-2019, 11:59 AM
Techungry
Fire Beetle
 
Join Date: Jan 2019
Location: Georgia
Posts: 25
Default

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.dllNSAPI.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
Reply With Quote
  #14  
Old 02-01-2019, 12:53 PM
Techungry
Fire Beetle
 
Join Date: Jan 2019
Location: Georgia
Posts: 25
Default

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);
Reply With Quote
  #15  
Old 02-01-2019, 01:22 PM
spiritchaser
Fire Beetle
 
Join Date: Jan 2019
Posts: 29
Default

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)
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 09:56 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3