Authserver "Unable to connect" "Host xxxxx is not authorized" after changing the LAN installation IP

Question

Use the default Windows installation instructions on a bare metal Windows 10 installation. I got the server running. To reiterate: this only uses the default values ​​so far; no changes. I can log in from another machine using my existing 3.3.5 client, but cannot enter the realm. I can see it, but if I click on the realm it behaves as if it's connecting and then the realm list pops up again. repeatedly.

Then I remembered that I might need to change the IP number of the server in the database and/or conf file. I changed the login server ip in authserver.conf and the login, world and role database ips in worldserver.conf; all settings use 192.168.1.112. In the realm list, I used Heidi to change both IP settings to the same LAN IP used by the server machine, 192.168.1.112. Then I updated the data tab with the same IP and published the changes. I disconnected and exited Heidi.

Now when I try to start the authserver I get the error in the title:

Authserver.exe cannot connect to mysql, host 'nameofservercomputer' does not have permission to connect.

I found this problem in the docker installation problem, but it was caused by the real-time data table in Heidi not being updated. I've done this but still get the same error. I've found other clues that I need to edit the MySQL configuration to allow other connections outside of localhost, but so far they've all provided solutions that either assume more knowledge than I have or are for use I don't yet have Specific tools installed and not very familiar with.

Can anyone point me to some guidance on this issue? The goal is to set up 1 wow server on a LAN that can be accessed by all other computers on the LAN. I've done this once before with a trinitycore server, but that was a few years ago and I simply can't remember what I had to do.

Answer 1

Found the problem after searching online and reading carefully.

First note: This configuration is specifically for LAN use. If it's part of the solution for internet access or anything else, I don't know.

The authserver.conf and worldserver.conf files on a WoW server running Azerothcore need to be configured to the default localhost address of 127.0.0.1, where the installer seems to suggest changing the address to the server's LAN IP. I think this might only need to be done when accessing the internet. I'm not doing this. The only place in the server configuration where you need to change the IP number to a LAN number instead of 127.0.0.1 is in the reallist table of the auth database, using whatever mysql edit method you have installed and choose to use. I use Heidi. The local address is still 127.0.0.1; just change the Address field to the LAN IP of your WoW server.

Then, of course, on all the LAN computers, you need to change each computer's Realmlist file to point to the IP of the LAN computer. The realmlist file is located in the enGB folder, which is located in the DATA folder in the client folder...in my case this would be World of Warcraft 3.3.5a/DATA/enGB/

I hope this helps someone in the future. It works with TrinityCore, AzerothCore, and I'm sure other versions will work too.

Oh, to explain the error I got above, it was because I changed the ip numbers in the authserver and worldserver conf files, so basically the server was trying to make an external connection to the database instead of an internal one, which is secure by default The setting is against.