mangos two Unable to authenticate account sign in

[jerbookins]

I am trying to run Mangos Zero and Mangos One simultaneously.

I am using realmd.exe from Mangos One.

Mangos Zero is set to server #1 in config and database, is set to port 8085 in config and database, and works just fine.

Mangos One is set to server #2 in config and database, is set to port 8086 in config and database, and I get the error "The information you have entered is not valid." It says connecting, authenticating, handshaking, and then gives the error.

If I sign in as player, gamemaster, or administrator it says "This World of Warcraft account has been temporarily suspended."

Databases: mangos_realm, mangos_zero, mangos_zero_characters, mangos_one, mangos_one_characters

I have changed "expansion" in mangos_realm > account to "1".

[jerbookins]

2 hours ago, antz said:

@jerbookins - Are you upgrading an old db or installing a new character db fresh ?

The reason I ask is this...

If you have installed the MangosOne Database from fresh, you currently only need to apply Rel21_03_001_characters_pvpstats.sql
(This may change in the future)

I am installing fresh from the downloadable zip "MangosOne_Develop21_Release_x64_July2016". I have since corrected the error I mentioned above but I am still unable to successfully sign in to the Mangos One server.

2 hours ago, antz said:

I have just taken a look at file Rel21_2_1_match_client_limits.sql and I'm confused !

It doesn't contain the line "SET FOREIGN_KEY_CHECKS = ON;"

I upgraded my version of PHPmyadmin and the error went away. I think it was a mysql cache error of some kind.

[antz]

I would take a look in both the _banned tables and remove any entries found there

If you have warden enabled, it may be worth disabling it while getting set up

[Talendrys]

Do you get that error message when logging in or is it while entering the realm ?

Also, can you please tell us if you set up the correct build version number (check your client) into the realm database ?

[jerbookins]

On 2/1/2017 at 3:19 AM, antz said:

I would take a look in both the _banned tables and remove any entries found there

If you have warden enabled, it may be worth disabling it while getting set up

No accounts are listed in the ban tables. These are freshly installed servers. I have tried disabling and enabling Warden, it did not make a difference.

 

On 2/1/2017 at 8:11 AM, Talendrys said:

Do you get that error message when logging in or is it while entering the realm ?

Also, can you please tell us if you set up the correct build version number (check your client) into the realm database ?

Logging in.

Realm db build for Mangos One is 8606, my PC client build is 8606.

[jerbookins]

So I tried to just reinstall the entire server again, and I'm getting a character db update error.

When I first start the server i get this:

2017-02-02 20:16:37 You have not updated the core for few DB [World] updates!
2017-02-02 20:16:37 Current DB content is 71, core expects 8
2017-02-02 20:16:37 This is ok for now but should not last long.
2017-02-02 20:16:37 The table `db_version` indicates that your [Character] database does not match the expected structure!
2017-02-02 20:16:37 
2017-02-02 20:16:37   [A] You have database Version: 21
2017-02-02 20:16:37                       Structure: 1
2017-02-02 20:16:37                         Content: 0
2017-02-02 20:16:37                     Description: revision_refactor
2017-02-02 20:16:37 
2017-02-02 20:16:37   [B] You need database Version: 21
2017-02-02 20:16:37                       Structure: 2
2017-02-02 20:16:37                         Content: 1
2017-02-02 20:16:37                     Description: match_client_limits
2017-02-02 20:16:37 
2017-02-02 20:16:37 You must apply all updates after [A] to [B] to use MaNGOS with this database.
2017-02-02 20:16:37 These updates are included in the database/Character/Updates folder.

When I go to update the database, using ..mangos1/install/database/character/updates/rel21/Rel21_2_1_match_client_limits.sql", I get this error:

Error

Static analysis:

1 errors were found during analysis.

    Unrecognized keyword. (near "ON" at position 25)

SQL query: Edit Edit

SET FOREIGN_KEY_CHECKS = ON;

MySQL said: Documentation
#2014 - Commands out of sync; you can't run this command now

 

[antz]

@jerbookins - Are you upgrading an old db or installing a new character db fresh ?

The reason I ask is this...

If you have installed the MangosOne Database from fresh, you currently only need to apply Rel21_03_001_characters_pvpstats.sql
(This may change in the future)

[antz]

5 hours ago, jerbookins said:

When I go to update the database, using ..mangos1/install/database/character/updates/rel21/Rel21_2_1_match_client_limits.sql", I get this error:

Error

Static analysis:

1 errors were found during analysis.

    Unrecognized keyword. (near "ON" at position 25)

SQL query: Edit Edit

SET FOREIGN_KEY_CHECKS = ON;

MySQL said: Documentation
#2014 - Commands out of sync; you can't run this command now

 

I have just taken a look at file Rel21_2_1_match_client_limits.sql and I'm confused !

It doesn't contain the line "SET FOREIGN_KEY_CHECKS = ON;"

[Talendrys]

Can you please put the realmd & mangosd daemon logfiles to a more verbose one and provide us the messages ?

 

Thank you

[madmax]

On 2/3/2017 at 11:09 AM, jerbookins said:

I upgraded my version of PHPmyadmin and the error went away. I think it was a mysql cache error of some kind.

Glad you got this fixed. Going to mark this as resolved. Please open a new topic if you encounter further issues.