Stuck at connected / infinite loop / login issues / battle.net

[Lucian_by]

If client and srv on the same machine

then 127.0.0.1 127.0.0.1

if client and srv on other/different computers

then (addr in the same network as the server) 127.0.0.1

as example -- 192.168.1.5 127.0.0.1

in database table 'realm' & config files *.conf

also port forwarding ( srv in VirtualMashines or subnetworks, network boundaries)

[rockmaster007]

On 3/17/2020 at 1:47 PM, bnblood said:

Fantastic work!

Not sure what is going on - I tried just about everything I could think of.  Client does not indicate Trinity - ever.  Using 8.3.0.33528 - (with 8.2.0 it did indicate trinity, but never able to log in - endless loop).

Client matches core.  Compiling went great.  DB up to date and matches client / core.  Great instructions!  LAN - client and server on same machine - (Win10).  Firewall off.  
Not internet connected - don't ever plan to be.  Get message BLZ...1016 disconnected.

--------------------------------
MySQL - two mirror users / db (tried also with just one root user)

Realmlist auth table:
a.) Local Instance MySQL31, user: root, pass: *****, localhost:3306
'1', 'Trinity', '127.0.0.1', '127.0.0.1', '255.255.255.0', '3306', '0', '0', '1', '0', '0', '33528', '1', '1'

b.) Trinity, User: trinity, pass: trinity, 127.0.0.1:3306 

'1', 'Trinity', '127.0.0.1', '127.0.0.1', '255.255.255.0', '3306', '0', '0', '1', '0', '0', '33528', '1', '1'

also tried for both in the auth table: 
'1', 'Trinity', '127.0.0.1', '127.0.0.1', '255.255.255.0', '8085', '0', '0', '1', '0', '0', '33528', '1', '1'

----------------------------------------------------------------------
Client config.wtf:
SET portal "127.0.0.1"
SET realmList "127.0.0.1"

------------------------------------------------------
BNetServer:
LoginREST.Port = 8081
LoginREST.ExternalAddress=127.0.0.1
LoginREST.LocalAddress=127.0.0.1
LoginREST.TicketDuration=3600

MySQL 
LoginDatabaseInfo = "127.0.0.1;3306;trinity;trinity;auth"

(crashed when I tried 8081 or 8085)

It looks like it's working:
Using configuration file C:/Trinity/Build/bin/RelWithDebInfo/bnetserver.conf.
Using SSL version: OpenSSL 1.1.1d  10 Sep 2019 (library: OpenSSL 1.1.1d  10 Sep 2019)
Using Boost version: 1.66.0
Automatic database updates are disabled for all databases!
Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 5.6.47
MySQL server ver: 5.6.47-log
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.6.47
MySQL server ver: 5.6.47-log
Connected to MySQL database at 127.0.0.1
DatabasePool 'auth' opened successfully. 2 total connections running.
Started auth database connection pool.
Loading IP Location Database...
Login service bound to http://0.0.0.0:8081
Added realm "Trinity" at 127.0.0.1:8085.

------------------------------------------------------------------
WorldServer: (I have tried all combinations of this with all of the root\admin and all the port numbers - doing this does crash it completely.)

This works:

LoginDatabaseInfo     = "127.0.0.1;3306;trinity;trinity;auth"
WorldDatabaseInfo     = "127.0.0.1;3306;trinity;trinity;world"
CharacterDatabaseInfo = "127.0.0.1;3306;trinity;trinity;characters"
HotfixDatabaseInfo    = "127.0.0.1;3306;trinity;trinity;hotfixes"

WorldServerPort = 8085

InstanceServerPort = 8086

BindIP = "0.0.0.0"

World initialized in 2 minutes 21 seconds
TC>TrinityCore rev. unknown 1970-01-01 00:00:00 +0000 (Archived branch) (Win64, RelWithDebInfo, Static) (worldserver-daemon) ready...

------------------------------------------------------------------------

Thoughts?

Same here and looking at the wireshark, i see my client trying to connect to blizzard server with port 1119, even if the config.wtf is changed to 127.0.0.1 or 192.168.2.26.

[rockmaster007]

On 11/26/2019 at 4:21 AM, Sevy said:

Reinstalled again ( 3rd time ), new client, new extraction, new everything. Same Problem.
Exported a .pfx form .cert.pem .key.pem in bin directory and installed the certificate on the windows client.
Now I can connect correctly.
I'm not sure that the certificate fixed it... I'll try to check later.

Hi Sevy,

Same issue here, what fixed your issue?

 

Regards

[roadmaster]

I installed the 3.3.5 branch of trinitycore but im having problems connecting multiple clients.

I have 3 computers: Local, Lan and Internet

the Local Machine hosts both the trinitycore server and a copy of the wow client (realmlist set to 127.0.0.1)
a separate Lan Machine hosts a wow client (realmlist set to 10.0.0.163) which is the Lan ip of the above local machine.
my niece has a Machine at her house with a wow client that connects through the internet using (realmlist set to my.noip.dns)

The Local machine with the server installed, auth.realmlist address is set for my.noip.dns
ports 8085 and 3724 are port forwarded and working.

my problem is this:  i can get the local machine and the Lan machine to work at the same time with the auth.realmlist set to the lan ip of 10.0.0.163. or i can get the local machine
and my niece connected through the internet to work at the same time using the auth.realmlist set to my dns my.noip.dns. but i cant get all three to work at the same time.

can you run Local, Lan and Internet all three at the same time?

As i said the server runs and connections are possible, just not with all three at the same time. When i try to run all three, the Lan machine wont connect but instead runs the infinite realm loop.

[Aokromes]

6 hours ago, roadmaster said:

I installed the 3.3.5 branch of trinitycore but im having problems connecting multiple clients.

I have 3 computers: Local, Lan and Internet

the Local Machine hosts both the trinitycore server and a copy of the wow client (realmlist set to 127.0.0.1)
a separate Lan Machine hosts a wow client (realmlist set to 10.0.0.163) which is the Lan ip of the above local machine.
my niece has a Machine at her house with a wow client that connects through the internet using (realmlist set to my.noip.dns)

The Local machine with the server installed, auth.realmlist address is set for my.noip.dns
ports 8085 and 3724 are port forwarded and working.

my problem is this:  i can get the local machine and the Lan machine to work at the same time with the auth.realmlist set to the lan ip of 10.0.0.163. or i can get the local machine
and my niece connected through the internet to work at the same time using the auth.realmlist set to my dns my.noip.dns. but i cant get all three to work at the same time.

can you run Local, Lan and Internet all three at the same time?

As i said the server runs and connections are possible, just not with all three at the same time. When i try to run all three, the Lan machine wont connect but instead runs the infinite realm loop.

 

[roadmaster]

8 hours ago, Aokromes said:

 

I'm not sure if i'm understanding correctly your post in that thread on "Login into TrinityCore", i continue to have problems, all three pc's run on windows 10.

on my local Pc with the Server:  (is able to connect)
realmlist.wtf:  set realmlist winterwolf.ddns.net
hosts file: 10.0.0.163 winterwolf.ddns.net
auth.realmlist Values: (1,'Winterbeast','winterwolf.ddns.net','10.0.0.163','255.255.255.0',8085,0,0,2,0,0,12340)

on my Lan Pc: (is able to connect)
realmlist.wtf:  set realmlist winterwolf.ddns.net
hosts file:  10.0.0.163  winterwolf.ddns.net

my niece's Pc connecting through internet:  (Is 'NOT' able to connect) "she gets the realm loop issue.""
realmlist.wtf:  set realmlist winterwolf.ddns.net

in my router both ports 3724 and 8085 are forwarded to 10.0.0.163, and i have tested to make sure the ports are open.

Did i do something wrong in the above?

[roadmaster]

On 6/29/2020 at 12:44 PM, roadmaster said:

I'm not sure if i'm understanding correctly your post in that thread on "Login into TrinityCore", i continue to have problems, all three pc's run on windows 10.

on my local Pc with the Server:  (is able to connect)
realmlist.wtf:  set realmlist winterwolf.ddns.net
hosts file: 10.0.0.163 winterwolf.ddns.net
auth.realmlist Values: (1,'Winterbeast','winterwolf.ddns.net','10.0.0.163','255.255.255.0',8085,0,0,2,0,0,12340)

on my Lan Pc: (is able to connect)
realmlist.wtf:  set realmlist winterwolf.ddns.net
hosts file:  10.0.0.163  winterwolf.ddns.net

my niece's Pc connecting through internet:  (Is 'NOT' able to connect) "she gets the realm loop issue.""
realmlist.wtf:  set realmlist winterwolf.ddns.net

in my router both ports 3724 and 8085 are forwarded to 10.0.0.163, and i have tested to make sure the ports are open.

Did i do something wrong in the above?

As I understand in order for my Lan Pc's to connect to the Server Pc I have to have the Lan Ip of the Server Machine set as the "LocalAddress" value in the realmlist.

and in order for my Niece to connect from her home I have to have my domainName set as the "local" value.

from what I have done this allows me to connect from the server machine itself and from my other LAN machines, but it wont allow connecting externally.

 

I know that connecting externally works just not with the above settings and at the expense of the LAN Pc's not working instead.

 

Has anyone actually connected to their server machine through their client on the server, while someone else connected through the LAN network, and while a third individual connected externally?

Edited July 9, 2020 by roadmaster

[skipperheartbeat]

If your router is port forwarding correctly to your server, you shouldn't need a host file entry anywhere. Just set the realmlist.wtf to be winterwolf.ddns.net on all PC's that want to connect.

Make sure the Database Realmlist Auth table has your public IP address and you should be good.

Haven't done this for years though.

 

oh, and check any firewalls on the server to allow those ports

 

[roadmaster]

I was finally able to figure out how to set it up for what I had wanted.

fyi anyone who has the same issue here are the settings I ended up with in order to get all pc's working.

LAN PC 10.0.0.163: holding the TrinityCore Server and WoW Client.
realmlist.wtf = set realmlist 127.0.0.1

LAN PC 10.0.0.148: with WoW Client only, connecting to Server on LAN PC 10.0.0.163.
realmlist.wtf = set realmlist 10.0.0.163

External Client Connections to DNS "winterwolf.ddns.net" Through Internet.
set realmlist winterwolf.ddns.net

Database Auth.Realmlist 
(1,'Winterbeast','winterwolf.ddns.net','10.0.0.163','255.255.255.0',8085,0,0,2,0,0,12340)

Hostfile use: none

The Router/Port Forwarding were never the problem so I'm leaving that info out.

Thanks for your replies.

[Doomjoon]

I'm using 3.3.5, on Windows OS, and when I try to login, I get the error that the information I have entered is not valid, with log LOGIN_UNKNOWN_ACCOUNT (once I got that I "cannot login at this time, please try again later", with the log giving LOGIN_DBBUSY for failed login, but I cannot reproduce this). When I try to use a "test, pass:test" account, I get an error that this account has been closed.

 

Am I launching WoW the wrong way? How am I supposed to launch it? I'm using a client I downloaded, in it's own separate folder, on the same drive. The guide said to not run using the launcher, what's the launcher, is it Wow.exe?

 

EDIT: I changed realmlist.wtf to set realmlist 127.0.0.1, now it works.

Edited July 16, 2021 by Doomjoon

[Belitharian]

Hey guys,

 

My game is stuck at login in an infinite loop.

Looking at the WoW Packet Parser, it stucks with CMSG_PING and CMSG_PONG loop. I don't have any response from CMSG_AUTH_SESSION.

Last packet before the infinite loop is CMSG_ENTER_ENCRYPTED_MODE_ACK.

My sources (and launcher) are updated with the lastest versions / game build. Local server on 127.0.0.1.

 

First time using master branch.

Do you have some ideas ?

 

Thanks!

[Belitharian]

Hey back!

Shauren pushed a fix yesterday to solve this issue. It works

Commit link:

https://github.com/TrinityCore/TrinityCore/commit/2fe70e5fd67042e621e27b047f3e249f6fcfc371

[Gyver23]

On 10/28/2017 at 4:55 PM, rbliu said:

Thank you so much for the reply!

You are correct. Problem solved!

I know this is a really old thread, but it looks like you resolved the issue I am having. 

Can you explain how changing the default vs the realmlist table?  The changed my realmlist table like it shows in the Heidi SQL image, with my own LAN IP, which I assumed was the realmlist table.  I get the same COP_CONNECT error.  If you could resolve it, that would be really appreciated I'm in on this many hours.  Thanks in advance. 

[Eruweui]

Hello everyone.

Such a problem, I use the server version of Shadowlands 9.0.5 trinity, I set everything up, the server starts, I go to the client, I enter the data from my account, I log in, a window appears with a choice of the world, I select the world and the client gives the error "BLZ51900328".

Client logs:
12/16 21:34:00.416 Connection Initialize
12/16 21:34:56.088 Glue Start Login
12/16 21:34:56.088 BattleNet Attempt Logon
12/16 21:34:57.652 BattleNet Front Connected
12/16 21:34:57.840 BattleNet External Challenge
12/16 21:34:57.840 BattleNet Get Logon Form
12/16 21:34:59.162 BattleNet Logon Form
12/16 21:35:00.949 BattleNet Logon Complete
12/16 21:35:01.354 BattleNet Game Account Name
12/16 21:35:01.354 BattleNet Attempt Complete Login
12/16 21:35:01.571 BattleNet Realm List Ticket
12/16 21:35:01.790 BattleNet Sub Region List
12/16 21:35:02.004 BattleNet Last Played Char
12/16 21:35:02.222 BattleNet Realm List
12/16 21:35:05.969 BattleNet Join Realm
12/16 21:35:06.163 BattleNet Realm Join
12/16 21:35:06.163 Change Connection
12/16 21:35:06.163 Connect
12/16 21:35:27.343 Handle Cant Connect
12/16 21:35:27.343 Glue WoW Cant Connect
12/16 21:35:27.343 Glue WoW Disconnect
12/16 21:35:27.343 BattleNet Defer Disconnect
12/16 21:35:27.343 BattleNet Front Disconnecting
12/16 21:35:27.774 BattleNet Front Disconnected
12/16 21:35:34.199 Connection Destroy

Who can help, please help.
Contacts for communication:
Discord: Eruweui#2881

[Eruweui]

10 hours ago, Eruweui said:

Hello everyone.

Such a problem, I use the server version of Shadowlands 9.0.5 trinity, I set everything up, the server starts, I go to the client, I enter the data from my account, I log in, a window appears with a choice of the world, I select the world and the client gives the error "BLZ51900328".

Client logs:
12/16 21:34:00.416 Connection Initialize
12/16 21:34:56.088 Glue Start Login
12/16 21:34:56.088 BattleNet Attempt Logon
12/16 21:34:57.652 BattleNet Front Connected
12/16 21:34:57.840 BattleNet External Challenge
12/16 21:34:57.840 BattleNet Get Logon Form
12/16 21:34:59.162 BattleNet Logon Form
12/16 21:35:00.949 BattleNet Logon Complete
12/16 21:35:01.354 BattleNet Game Account Name
12/16 21:35:01.354 BattleNet Attempt Complete Login
12/16 21:35:01.571 BattleNet Realm List Ticket
12/16 21:35:01.790 BattleNet Sub Region List
12/16 21:35:02.004 BattleNet Last Played Char
12/16 21:35:02.222 BattleNet Realm List
12/16 21:35:05.969 BattleNet Join Realm
12/16 21:35:06.163 BattleNet Realm Join
12/16 21:35:06.163 Change Connection
12/16 21:35:06.163 Connect
12/16 21:35:27.343 Handle Cant Connect
12/16 21:35:27.343 Glue WoW Cant Connect
12/16 21:35:27.343 Glue WoW Disconnect
12/16 21:35:27.343 BattleNet Defer Disconnect
12/16 21:35:27.343 BattleNet Front Disconnecting
12/16 21:35:27.774 BattleNet Front Disconnected
12/16 21:35:34.199 Connection Destroy

Who can help, please help.
Contacts for communication:
Discord: Eruweui#2881

I have already found the reason and fixed it.

[balle11]

Currenly running master with some weird connectivity issue

enabling trace in logs gets:

[MYIP:58628] Accepted connection
[0 ms] SQL(p): DELETE FROM ip_banned WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()
[1 ms] SQL(p): SELECT unbandate > UNIX_TIMESTAMP() OR unbandate = bandate AS banned, NULL as country FROM ip_banned WHERE ip = 'MY IP'

 

and error BLZ51900003 but the login details are correct..

[PsychoEliteNZ]

Hey, Im having an issue with getting friends to connect to the server I've set up, he's getting the infinite server loop.

Im running 3.3.5a, I've forwarded all ports and I can connect to the server locally so I know its working,

The ports are exact, 3724 ,8085 ,1119, 8081, 8085, 8086. I even tried forwarding the master ports too but nothing works.

This happens on both the default ports and when I change them to completely different ports.

Edit: Fixed it after a few hours, I had set my "address" under the "table" rather than the "data" tab inside heidiSQL.

Edited April 11, 2022 by PsychoEliteNZ

[Critix]

On 4/11/2022 at 11:24 AM, PsychoEliteNZ said:

Hey, Im having an issue with getting friends to connect to the server I've set up, he's getting the infinite server loop.

Im running 3.3.5a, I've forwarded all ports and I can connect to the server locally so I know its working,

The ports are exact, 3724 ,8085 ,1119, 8081, 8085, 8086. I even tried forwarding the master ports too but nothing works.

This happens on both the default ports and when I change them to completely different ports.

Edit: Fixed it after a few hours, I had set my "address" under the "table" rather than the "data" tab inside heidiSQL.

You sir have saved my a**.

Thank you so much <3