mangos zero Hello and thank you, i'm having disconnect issues.

[Velzira]

As my title states I am so appreciative to have a place to ask for help.  I am a new Mangos user however I run an Emulated Everquest server and a few Minecraft servers,  I am also a college programming student if that provides any indication of my skill level.  I was able to get a Mangos Zero server running on a VPS with no problems whatsoever, I compiled from source instead of using a repack, that was until I had people signing on to play.  Current behavior is strange to capture because I don't have an error code so i will just explain as best I can, leave screenshots of my setup, and post my logs.  By the way I did extensive searching through your forums and I do not make new posts on disconnect issues lightly, i do not plan to waste your time.

I have about 10-15 players who can all connect with no issue at times and then can not connect at all at other times.  It seems there is a threshold wherein everything is fine until a certain amount of time running or something and then people trying to log in get disconnected once they hit the realm list.  If i restart the server that changes completely and they can all log in no problem until we hit this threshold.  People logged in do not get kicked out but if they log out they can not get back in either.

Things I have checked:

-Port forwarding, and using canyouseeme.org to confirm. Currently the firewall is just off for testing purposes.

-Configuration files. I have used the guides written by "Antz" (by the way wow what great guides thank you so much) and barring some odd rule or something I'm not sure anything is wrong.

-Realmlist settings, including those in the database and those in my users realmlist which is simply (set realmlist xxx.xx.xx.xxx). I will post my realmlist db settings in a screenshot to follow.

-For reference I used this wonderfully written guide: https://www.getmangos.eu/wiki/documentation/installation-guides/guideswindows/installing-mangos-on-windows-using-easybuild-r20064/

As you can see in the screenshot below I have what I believe to be a working setup.  Note that in the realmd log there it says I got it but I did not. So it feels like it's making the connection, getting to the realmlist and being booted back but there's no disconnect message or error. The other user had the same, he was already on the server and left to install and addons, came back and gets to the realmlist and disconnects.  I am really hoping this is something small I missed, but I am again so glad I found this forum and by extension your help.  I look forward to being a positive part of your community, and I anxiously await your responses!  If you need anything else in the way of logs let me know.

 

*note I have replaced my username and password with MYPASS and MYUSER, if that wasnt obvious. Also since writing this post I have fixed one issue, i changed "localaddress" in the realmlist db to my actual IP and not 127.0.0.1.  Still hasnt fixed the issue but i understand this is a better setup.

 

2017-03-10 17:09:55 21014 [realm-daemon]
2017-03-10 17:09:55 <Ctrl-C> to stop.

2017-03-10 17:09:55 Using configuration file realmd.conf.
2017-03-10 17:09:55 OpenSSL 1.0.2j  26 Sep 2016 (Library: OpenSSL 1.0.2j  26 Sep 2016)
2017-03-10 17:09:55 Using ACE: 6.3.0
2017-03-10 17:09:55 Max allowed open files is 1024
2017-03-10 17:09:55 Login Database total connections: 2
2017-03-10 17:09:55 Connected to MySQL database [email protected]:3306/realmd
2017-03-10 17:09:55 MySQL client library: 5.7.16
2017-03-10 17:09:55 MySQL server ver: 5.6.35-log 
2017-03-10 17:09:55 AUTOCOMMIT SUCCESSFULLY SET TO 1
2017-03-10 17:09:55 Connected to MySQL database [email protected]:3306/realmd
2017-03-10 17:09:55 MySQL client library: 5.7.16
2017-03-10 17:09:55 MySQL server ver: 5.6.35-log 
2017-03-10 17:09:55 AUTOCOMMIT SUCCESSFULLY SET TO 1
2017-03-10 17:09:55 Updating Realm List...
2017-03-10 17:09:55 Added realm id 1, name 'Blood and Rank - Vanilla Server'
2017-03-10 17:09:55 realmd process priority class set to HIGH
2017-03-10 17:09:55 
2017-03-10 17:10:03 Accepting connection from 'xx.xx.xxx.x'
2017-03-10 17:10:03 [Auth] Received command 0, length 39
2017-03-10 17:10:03 Entering _HandleLogonChallenge
2017-03-10 17:10:03 [AuthChallenge] got header, body is 0x23 bytes
2017-03-10 17:10:03 [AuthChallenge] got full packet, 0x23 bytes
2017-03-10 17:10:03 [AuthChallenge] name(5): 'WINGO'
2017-03-10 17:10:03 [AuthChallenge] Account 'WINGO' is not locked to ip
2017-03-10 17:10:03 database authentication values: v='394DA65588D3F30D89CDDE75D55D44AB8ED806758B4B922B0E843EA70F9FDF4B' s='81D6DE1E866CC04BF95CF48E590E23B708D7FB0D3E740ADD003494B57DA159DB'
2017-03-10 17:10:03 [AuthChallenge] account WINGO is using 'enUS' locale (0)
2017-03-10 17:10:03 [Auth] Received command 1, length 75
2017-03-10 17:10:03 Entering _HandleLogonProof
2017-03-10 17:10:03 User 'WINGO' successfully authenticated
2017-03-10 17:10:03 [Auth] Received command 16, length 5
2017-03-10 17:10:03 Entering _HandleRealmList
2017-03-10 17:10:03 Updating Realm List...
2017-03-10 17:10:09 [Auth] Received command 16, length 5
2017-03-10 17:10:09 Entering _HandleRealmList
2017-03-10 17:10:11 Accepting connection from 'xx.xx.xxx.x'
2017-03-10 17:10:11 [Auth] Received command 0, length 41
2017-03-10 17:10:11 Entering _HandleLogonChallenge
2017-03-10 17:10:11 [AuthChallenge] got header, body is 0x25 bytes
2017-03-10 17:10:11 [AuthChallenge] got full packet, 0x25 bytes
2017-03-10 17:10:11 [AuthChallenge] name(7): 'KYDARIA'
2017-03-10 17:10:11 [AuthChallenge] Account 'KYDARIA' is not locked to ip
2017-03-10 17:10:11 database authentication values: v='7C2739BB1614D098F5CC086E73B1C7A9193D280D37DF5059CA44F2B8D208DD13' s='DF734754FD2AB756EC79AE10238C99ADF5BDFCD83749B01F82C3A056D17CB1E3'
2017-03-10 17:10:11 [AuthChallenge] account KYDARIA is using 'enGB' locale (0)
2017-03-10 17:10:12 [Auth] Received command 1, length 75
2017-03-10 17:10:12 Entering _HandleLogonProof
2017-03-10 17:10:12 [AuthChallenge] account KYDARIA tried to login with wrong password!
2017-03-10 17:10:14 Accepting connection from 'xx.xx.xxx.x'
2017-03-10 17:10:14 [Auth] Received command 0, length 38
2017-03-10 17:10:14 Entering _HandleLogonChallenge
2017-03-10 17:10:14 [AuthChallenge] got header, body is 0x22 bytes
2017-03-10 17:10:14 [AuthChallenge] got full packet, 0x22 bytes
2017-03-10 17:10:14 [AuthChallenge] name(4): 'DOOM'
2017-03-10 17:10:14 [AuthChallenge] Account 'DOOM' is not locked to ip
2017-03-10 17:10:14 database authentication values: v='50074776BEF8555C567D4CC155F0FF98800B1E81AE479C2BABD70D77E9334DC4' s='90F4587104983FC11D2A2C5C3660C7EDAF55A02FEE7C4D2A361BAC119CCA560F'
2017-03-10 17:10:14 [AuthChallenge] account DOOM is using 'enGB' locale (0)
2017-03-10 17:10:14 [Auth] Received command 1, length 75
2017-03-10 17:10:14 Entering _HandleLogonProof
2017-03-10 17:10:14 User 'DOOM' successfully authenticated
2017-03-10 17:10:14 [Auth] Received command 16, length 5
2017-03-10 17:10:14 Entering _HandleRealmList
2017-03-10 17:10:14 [Auth] Received command 16, length 5
2017-03-10 17:10:14 Entering _HandleRealmList
2017-03-10 17:10:19 [Auth] Received command 16, length 5
2017-03-10 17:10:19 Entering _HandleRealmList
2017-03-10 17:10:20 [Auth] Received command 16, length 5
2017-03-10 17:10:20 Entering _HandleRealmList
2017-03-10 17:10:25 [Auth] Received command 16, length 5
2017-03-10 17:10:25 Entering _HandleRealmList
2017-03-10 17:10:25 Updating Realm List...
2017-03-10 17:10:31 [Auth] Received command 16, length 5
2017-03-10 17:10:31 Entering _HandleRealmList
2017-03-10 17:10:36 [Auth] Received command 16, length 5
2017-03-10 17:10:36 Entering _HandleRealmList
2017-03-10 17:10:41 [Auth] Received command 16, length 5
2017-03-10 17:10:41 Entering _HandleRealmList
2017-03-10 17:10:42 Accepting connection from 'xx.xx.xxx.x'
2017-03-10 17:10:42 [Auth] Received command 0, length 39
2017-03-10 17:10:42 Entering _HandleLogonChallenge
2017-03-10 17:10:42 [AuthChallenge] got header, body is 0x23 bytes
2017-03-10 17:10:42 [AuthChallenge] got full packet, 0x23 bytes
2017-03-10 17:10:42 [AuthChallenge] name(5): 'VICAR'
2017-03-10 17:10:42 [AuthChallenge] Account 'VICAR' is not locked to ip
2017-03-10 17:10:42 database authentication values: v='650AD9D0A97C57AE5EF502272B98A8BDA2494D7A74A975C61B7AC993D7304467' s='D702D3D65D93A8FA07F2F141D40D6AC54B992F3D92330204BF73F428929B43F7'
2017-03-10 17:10:42 [AuthChallenge] account VICAR is using 'enUS' locale (0)
2017-03-10 17:10:43 [Auth] Received command 1, length 75
2017-03-10 17:10:43 Entering _HandleLogonProof
2017-03-10 17:10:43 User 'VICAR' successfully authenticated
2017-03-10 17:10:43 [Auth] Received command 16, length 5
2017-03-10 17:10:43 Entering _HandleRealmList
2017-03-10 17:10:46 [Auth] Received command 16, length 5
2017-03-10 17:10:46 Entering _HandleRealmList
2017-03-10 17:10:46 Updating Realm List...
2017-03-10 17:10:48 [Auth] Received command 16, length 5
2017-03-10 17:10:48 Entering _HandleRealmList
2017-03-10 17:11:13 Accepting connection from 'xx.xx.xxx.x'
2017-03-10 17:11:13 [Auth] Received command 0, length 41
2017-03-10 17:11:13 Entering _HandleLogonChallenge
2017-03-10 17:11:13 [AuthChallenge] got header, body is 0x25 bytes
2017-03-10 17:11:13 [AuthChallenge] got full packet, 0x25 bytes
2017-03-10 17:11:13 [AuthChallenge] name(7): 'KNIFTAR'
2017-03-10 17:11:13 [AuthChallenge] Account 'KNIFTAR' is not locked to ip
2017-03-10 17:11:13 database authentication values: v='55F4E98C8930F8A9F4019B425D8010770E02085077341ED5B641D449E26BD00D' s='DC868AD52B00BC890F328F98CD54EDB96DAFFFE93824CFC22CDF15B6595AB0D3'
2017-03-10 17:11:13 [AuthChallenge] account KNIFTAR is using 'enGB' locale (0)
2017-03-10 17:11:13 [Auth] Received command 1, length 75
2017-03-10 17:11:13 Entering _HandleLogonProof
2017-03-10 17:11:13 User 'KNIFTAR' successfully authenticated
2017-03-10 17:11:13 [Auth] Received command 16, length 5
2017-03-10 17:11:13 Entering _HandleRealmList
2017-03-10 17:11:13 Updating Realm List...
2017-03-10 17:11:25 Accepting connection from 'xx.xx.xxx.x'
2017-03-10 17:11:25 [Auth] Received command 0, length 39
2017-03-10 17:11:25 Entering _HandleLogonChallenge
2017-03-10 17:11:25 [AuthChallenge] got header, body is 0x23 bytes
2017-03-10 17:11:25 [AuthChallenge] got full packet, 0x23 bytes
2017-03-10 17:11:25 [AuthChallenge] name(5): 'WINGO'
2017-03-10 17:11:25 [AuthChallenge] Account 'WINGO' is not locked to ip
2017-03-10 17:11:25 database authentication values: v='394DA65588D3F30D89CDDE75D55D44AB8ED806758B4B922B0E843EA70F9FDF4B' s='81D6DE1E866CC04BF95CF48E590E23B708D7FB0D3E740ADD003494B57DA159DB'
2017-03-10 17:11:25 [AuthChallenge] account WINGO is using 'enUS' locale (0)
2017-03-10 17:11:25 [Auth] Received command 1, length 75
2017-03-10 17:11:25 Entering _HandleLogonProof
2017-03-10 17:11:25 User 'WINGO' successfully authenticated
2017-03-10 17:11:25 [Auth] Received command 16, length 5
2017-03-10 17:11:25 Entering _HandleRealmList

[madmax]

1 minute ago, Velzira said:

Velzira#0737

Added

[Velzira]

So i spent a few hours with Madmax who got me all sorted out. From what we can tell nothing was technically wrong, we tried new files, new settings, all of that. In the end he cleared out my realmlist table and started it again from scratch.  I wish I could put out more of "this is how to fix xyz problem in the future" but we wouldn't really figure out what fixed it other than clearing out the realm table and starting over.  I want to say thank you to Madmax publicly, what an excellent help!  I have donated to the site as I hope others who gain help here will consider doing.  Thanks for the excellent community!

[Velzira]

An update: If a person logs in, and hangs out a few minutes and logs out they can not log back in. However, if i restart realmd.exe it will let them back in. For now i've just written a batch file to kill the process and restart it which is an ugly fix but one that works. I patiently look forward to finding the root of the cause!

[Talendrys]

Kind of weird, do you get the realm list still ? Or you got disconnected ?

The fact that idle client cannot reconnect is to be looked somewhere at the auth reconnect challenge.

[Foereaper]

Are you able to log into the realm yourself whenever others are not able to? Have tested this for about an hour myself locally but not experiencing the same issue, so we'll have to try to narrow it down some.

 

Edit:

 

The only off thing I can see in your log file is this specific line;

2017-03-10 17:45:13 database authentication values: v='' s=''

Does the issue start happening prior to or after this I wonder?

 

Edit 2:

 

I just experienced somewhat the same thing, where I would log into a non-GM account and I was kicked back to the login screen. However when I tried to log back in again it worked, so it didn't kill the entire login server, that's for sure. Interesting enough though, it had issues with the database authentication values as well, as shown below:

http://prntscr.com/eim2o8

[Velzira]

8 hours ago, Talendrys said:

Kind of weird, do you get the realm list still ? Or you got disconnected ?

The fact that idle client cannot reconnect is to be looked somewhere at the auth reconnect challenge.

Hello and thanks for the reply!  Players sometimes hit the realmlist and get disconnected and other times are denied right off the get-go.

[Velzira]

5 hours ago, Foereaper said:

Are you able to log into the realm yourself whenever others are not able to? Have tested this for about an hour myself locally but not experiencing the same issue, so we'll have to try to narrow it down some.

 

Edit:

 

The only off thing I can see in your log file is this specific line;

2017-03-10 17:45:13 database authentication values: v='' s=''

Does the issue start happening prior to or after this I wonder?

 

Edit 2:

 

I just experienced somewhat the same thing, where I would log into a non-GM account and I was kicked back to the login screen. However when I tried to log back in again it worked, so it didn't kill the entire login server, that's for sure. Interesting enough though, it had issues with the database authentication values as well, as shown below:

http://prntscr.com/eim2o8

Well At least you found part of the problem, any idea how to fix that please and thank you?

edit: So i haven't experienced it until now but others apparently have, occasionally when you log in it will go to character select but no characters are shown there. You must log out completely, get a realmd restart, and try again.  I am so confused and I have wracked my brain against this for days.  From the blank character select screen if you click Realmlist you can see our server but when you click to go in you are disconnected.  Lastly, when we reset realmd.exe it will not allow players back in the first time, it says disconnected but on second try it goes just fine. I'm posting another screenshot of both of those login attempts, the first is disconnected and the second is allowed, hopefully it answers your question as those database authentication value lines show up before and after.   Thank you again for your help, we really appreciate it.

[Velzira]

I have been trying all day, so many different things. First I completely wiped the configuration files and started over. I tried running the db updater, i tried changing a ton of mysql settings, I tried changing the server to unique ports, it is sounding more like I need to recompile and hope. Posted here is a screenshot of one of our players consoles while the error occurred, though I'm not sure how much help that will be. I have scoured google up to the ninth page and every fix I find doesn't fix this issue. I really don't want to use a repack, I want to figure this out.  Thanks again for your help, we are grateful for the use of your software.

[Talendrys]

Well, you're describing a lot of symptoms that may or not be related. How does it work in WoW to authenticate ?

It uses a modified version of SRP6. s & v (displayed in console) should not be edited, they are the salt and the verifier values of that cryptographic algorithm. They are also part of the calculation to generate a symmetric session key that will be used later between the realm and the client.

In any case, if:

- That session key change on one side, or on the other (not updated between 2 login for instance), the communication is broken. It makes sense since all packets header are encrypted using this session key + some results of the previous packets.

- In the same idea, if server side a packet isn't handled, then the communication is broken as well for the same desync story.

 

This is the only reason I could see why it would fail.

Aside note:

The realm list display comes from the realmd/auth server and the character selection screen comes from the mangosd/game server. 

[madmax]

Hey,

I'd be willing to have a go at getting this working for you via teamviewer. Do you have a skype id or discord? I also have a teamspeak server if you'd rather use that. Let me know. I'm not a developer but have set a lot of these up and troubleshooted a lot.

[Velzira]

1 hour ago, madmax said:

Hey,

I'd be willing to have a go at getting this working for you via teamviewer. Do you have a skype id or discord? I also have a teamspeak server if you'd rather use that. Let me know. I'm not a developer but have set a lot of these up and troubleshooted a lot.

Oh I would be eternally greatful for your help! I don't use teamviewer, currently we just use rdp or vnc, but I'm willing to do whatever it takes to get this fixed. I use discord daily so I will include my username below, thank you so much for the offer to help I am really grateful!

Velzira#0737