[DiscordArchive] Very frustrating, right?
[DiscordArchive] Very frustrating, right?
Archived author: The Dot • Posted: 2021-07-12T22:14:02.315000+00:00
Original source
Okay just manged to fix it for myself
Archived author: The Dot • Posted: 2021-07-12T22:14:14.258000+00:00
Original source
Here are the steps I went through
Archived author: The Dot • Posted: 2021-07-12T22:14:22.349000+00:00
Original source
Turns out it was a SQL misconfigration
Archived author: The Dot • Posted: 2021-07-12T22:14:31.537000+00:00
Original source
<@!534397732543266836> Tell me if this helps
Archived author: The Dot • Posted: 2021-07-12T22:14:53.341000+00:00
Original source
First find the local address of the machine running on your network
Archived author: The Dot • Posted: 2021-07-12T22:15:03.087000+00:00
Original source
For me I set it to run on ```192.168.1.69```
Archived author: The Dot • Posted: 2021-07-12T22:15:34.363000+00:00
Original source
I went into the MYSQL database with ```sudo docker exec -it azerothcore-wotlk_ac-database_1 bash -l```
then I ran ```mysql -p```
default password is just password
Archived author: The Dot • Posted: 2021-07-12T22:16:16.990000+00:00
Original source
Afterwards I ran the following commands ```USE acore_auth;
SELECT * FROM realmlist; UPDATE realmlist SET address='192.168.1.69'; UPDATE realmlist SET localAddress='192.168.1.69'```
Archived author: The Dot • Posted: 2021-07-12T22:16:36.408000+00:00
Original source
I misconfigured this by first having 127.0.0.1 (the default) in both address and localAddress
Archived author: The Dot • Posted: 2021-07-12T22:17:11.896000+00:00
Original source
Afterwards I set the address and localAddress to be my public ip address, however, turned out that all I had to do was set the ip to the local address machine IP