[Archive] Wow Server on Internal IP can log in but can't join Realm?
[Archive] Wow Server on Internal IP can log in but can't join Realm?
11-04-2025, 05:10 PM
Original source
mine are default nothing changed in the authserver.conf and worldserver.conf I messed around and did the above changes and then even tried to bind the ip to the lan ip.
rektbyfaith
11-04-2025, 05:10 PM #11Archived author: CraigShaw • Posted: 2025-11-04T18:10:32.291706
Original source
mine are default nothing changed in the authserver.conf and worldserver.conf I messed around and did the above changes and then even tried to bind the ip to the lan ip.
11-04-2025, 05:10 PM
Original source
Quote:JakeSpeed said:Don't forget to change the server ip in your mysql database. In the auth table under "realmlist" you have to change "address" to the ip, the server is running on. Not sure if you have to change "localAdress" aswell, though, but i don't think so.
mine are default nothing changed in the authserver.conf and worldserver.conf I messed around and did the above changes and then even tried to bind the ip to the lan ip.
Click to expand...
Also reading that some people have this issue with every repack they try, it is definitly something blocking the incoming connection. If everything fails, try to turn of the firewall temporarely and connect then. Also check if your anti-virus software is blocking any incoming connections. If you have this issue with every repack, it might not be the server causing issues, it might be your firewall or generally your computer.
rektbyfaith
11-04-2025, 05:10 PM #12Archived author: CraigShaw • Posted: 2025-11-04T18:10:32.291706
Original source
Quote:JakeSpeed said:Don't forget to change the server ip in your mysql database. In the auth table under "realmlist" you have to change "address" to the ip, the server is running on. Not sure if you have to change "localAdress" aswell, though, but i don't think so.
mine are default nothing changed in the authserver.conf and worldserver.conf I messed around and did the above changes and then even tried to bind the ip to the lan ip.
Click to expand...
Also reading that some people have this issue with every repack they try, it is definitly something blocking the incoming connection. If everything fails, try to turn of the firewall temporarely and connect then. Also check if your anti-virus software is blocking any incoming connections. If you have this issue with every repack, it might not be the server causing issues, it might be your firewall or generally your computer.
11-04-2025, 05:10 PM
Original source
Quote:Elvenlover said:Wow, thank you! That actually worked. I updated the address field in the emucoach-auth database, under the realmlist table, and it worked! I changed it from my local LAN IP address (i.e., 192.168.x.x) to my internet IP address. I didn't modify the localAddress field, and left it as my LAN IP address. I can't believe it actually worked! Such a simple thing, never thought to do it.
Don't forget to change the server ip in your mysql database. In the auth table under "realmlist" you have to change "address" to the ip, the server is running on. Not sure if you have to change "localAdress" aswell, though, but i don't think so.
Also reading that some people have this issue with every repack they try, it is definitly something blocking the incoming connection. If everything fails, try to turn of the firewall temporarely and connect then. Also check if your anti-virus software is blocking any incoming connections. If you have this issue with every repack, it might not be the server causing issues, it might be your firewall or generally your computer.
Click to expand...
When I logged in via the internet, it actually logged me in this time and I didn't get stuck at the realm listing (the realm listing didn't even show up).
The only thing I have to consider now is that my ISP will probably change my IP address pretty frequently, so I'm going to need to update this database cell pretty often. Does anyone know of a script or other program to automatically update a value in a MySQL database on Windows periodically (like a cronjob)? If not, I'll make one myself, but it'd be nice if one already exists.
Thanks again!
rektbyfaith
11-04-2025, 05:10 PM #13Archived author: CraigShaw • Posted: 2025-11-04T18:10:32.291706
Original source
Quote:Elvenlover said:Wow, thank you! That actually worked. I updated the address field in the emucoach-auth database, under the realmlist table, and it worked! I changed it from my local LAN IP address (i.e., 192.168.x.x) to my internet IP address. I didn't modify the localAddress field, and left it as my LAN IP address. I can't believe it actually worked! Such a simple thing, never thought to do it.
Don't forget to change the server ip in your mysql database. In the auth table under "realmlist" you have to change "address" to the ip, the server is running on. Not sure if you have to change "localAdress" aswell, though, but i don't think so.
Also reading that some people have this issue with every repack they try, it is definitly something blocking the incoming connection. If everything fails, try to turn of the firewall temporarely and connect then. Also check if your anti-virus software is blocking any incoming connections. If you have this issue with every repack, it might not be the server causing issues, it might be your firewall or generally your computer.
Click to expand...
When I logged in via the internet, it actually logged me in this time and I didn't get stuck at the realm listing (the realm listing didn't even show up).
The only thing I have to consider now is that my ISP will probably change my IP address pretty frequently, so I'm going to need to update this database cell pretty often. Does anyone know of a script or other program to automatically update a value in a MySQL database on Windows periodically (like a cronjob)? If not, I'll make one myself, but it'd be nice if one already exists.
Thanks again!
11-04-2025, 05:10 PM
Original source
Quote:JakeSpeed said:Yes, my config files were pretty much default as well; the only thing I changed was MaxPingTime and RealmsStateUpdateDelay, as suggested, and also BindIP. I think everything else was stock defaults. The only other thing I fiddled with was the port numbers, but I later changed those back to defaults as well as a sanity check, to make sure my issue wasn't the port numbers being blocked. So it seems like the config files weren't the issue (for me, at least).
mine are default nothing changed in the authserver.conf and worldserver.conf I messed around and did the above changes and then even tried to bind the ip to the lan ip.
Click to expand...
rektbyfaith
11-04-2025, 05:10 PM #14Archived author: CraigShaw • Posted: 2025-11-04T18:10:32.291706
Original source
Quote:JakeSpeed said:Yes, my config files were pretty much default as well; the only thing I changed was MaxPingTime and RealmsStateUpdateDelay, as suggested, and also BindIP. I think everything else was stock defaults. The only other thing I fiddled with was the port numbers, but I later changed those back to defaults as well as a sanity check, to make sure my issue wasn't the port numbers being blocked. So it seems like the config files weren't the issue (for me, at least).
mine are default nothing changed in the authserver.conf and worldserver.conf I messed around and did the above changes and then even tried to bind the ip to the lan ip.
Click to expand...
11-04-2025, 05:10 PM
Original source
Quote:Luminari said:Glad that this worked for you. Can't help on your auto-change thing tho.
Wow, thank you! That actually worked. I updated the address field in the emucoach-auth database, under the realmlist table, and it worked! I changed it from my local LAN IP address (i.e., 192.168.x.x) to my internet IP address. I didn't modify the localAddress field, and left it as my LAN IP address. I can't believe it actually worked! Such a simple thing, never thought to do it.
When I logged in via the internet, it actually logged me in this time and I didn't get stuck at the realm listing (the realm listing didn't even show up).
The only thing I have to consider now is that my ISP will probably change my IP address pretty frequently, so I'm going to need to update this database cell pretty often. Does anyone know of a script or other program to automatically update a value in a MySQL database on Windows periodically (like a cronjob)? If not, I'll make one myself, but it'd be nice if one already exists.
Thanks again!
Click to expand...
BTW changing MaxPingTime shouldn't really affect the problem. It was just something, that i remember from some years ago. From my understanding it just alters the time for the server to ping the mysql connection, to keep it alive. Might wanna put that back to 30, it could cause issues.
rektbyfaith
11-04-2025, 05:10 PM #15Archived author: CraigShaw • Posted: 2025-11-04T18:10:32.291706
Original source
Quote:Luminari said:Glad that this worked for you. Can't help on your auto-change thing tho.
Wow, thank you! That actually worked. I updated the address field in the emucoach-auth database, under the realmlist table, and it worked! I changed it from my local LAN IP address (i.e., 192.168.x.x) to my internet IP address. I didn't modify the localAddress field, and left it as my LAN IP address. I can't believe it actually worked! Such a simple thing, never thought to do it.
When I logged in via the internet, it actually logged me in this time and I didn't get stuck at the realm listing (the realm listing didn't even show up).
The only thing I have to consider now is that my ISP will probably change my IP address pretty frequently, so I'm going to need to update this database cell pretty often. Does anyone know of a script or other program to automatically update a value in a MySQL database on Windows periodically (like a cronjob)? If not, I'll make one myself, but it'd be nice if one already exists.
Thanks again!
Click to expand...
BTW changing MaxPingTime shouldn't really affect the problem. It was just something, that i remember from some years ago. From my understanding it just alters the time for the server to ping the mysql connection, to keep it alive. Might wanna put that back to 30, it could cause issues.
11-04-2025, 05:10 PM
Original source
Quote:Elvenlover said:Okay, thanks anyway. I'll try to write my own script to do this.
Glad that this worked for you. Can't help on your auto-change thing tho.
Click to expand...
Quote:Elvenlover said:Thanks for letting me know that. I'll probably go ahead and change it back to avoid any additional squirrelliness.
BTW changing MaxPingTime shouldn't really affect the problem. It was just something, that i remember from some years ago. From my understanding it just alters the time for the server to ping the mysql connection, to keep it alive. Might wanna put that back to 30, it could cause issues.
Click to expand...
rektbyfaith
11-04-2025, 05:10 PM #16Archived author: CraigShaw • Posted: 2025-11-04T18:10:32.291706
Original source
Quote:Elvenlover said:Okay, thanks anyway. I'll try to write my own script to do this.
Glad that this worked for you. Can't help on your auto-change thing tho.
Click to expand...
Quote:Elvenlover said:Thanks for letting me know that. I'll probably go ahead and change it back to avoid any additional squirrelliness.
BTW changing MaxPingTime shouldn't really affect the problem. It was just something, that i remember from some years ago. From my understanding it just alters the time for the server to ping the mysql connection, to keep it alive. Might wanna put that back to 30, it could cause issues.
Click to expand...
11-04-2025, 05:10 PM
Original source
Quote:CraigShaw said:To everyone, I had a very similar issue I spent hours trying to fix. Turns out, what I really needed was a guide to HeidiSQL, hope this helps someone else!
Hi all.
Hopefully someone can help. I'm trying to set up a private LAN server on an internal network without an internet connection (so can't use options that require the internet such as DNS). Everything needs to be locally controlled.
I've tried this is various different Repacks (Dev Apex MoP, EmuCoach Cataclysm to name two), but always get the same result.
Everything installs fine. The SQL database runs, authserver.exe and worldserver.exe run without issues.
I changed the realmlist in WTF/config.wtf (or enGB/realmlist.wtf for Cataclysm) to my internal IP: 192.168.8.100.
The clients start perfectly and I'm able to log in and play provided the client is running on the machine that is also running the server.
However, if I run the client from a different PC on the network (with realmlist pointing to 192.168.8.100), I can log in to the server - but then I get stuck on the select realm window. The realm shows but when clicking okay to join, it doesn't actually join the realm and just stays on the realm list. (So, I'm able to log into the server but can't actually join the realm to play when using another computer on the LAN.)
I've search Google and the forums here and the only solution I can find is to edit the table in the auth database and set the address to the internal IP. (The other solution relies on using a DNS but I'm trying to get the server working locally without needing the internet.)
However, even after setting the IP in the auth database to 192.168.8.100 (using HeidiSQL and then restarting MySQL), the clients on the network still can only log in but can't actually join the realm to play.
Is anyone able to help? Does anyone have a guide for setting this up on a LAN without having to connect to the internet and use DNS?
As far as I know, port forwarding shouldn't be neccessary (though I have set it up) on a local network and I've never had to port forward for any other LAN servers for other games - only when making them public and using a public IP.
I'm really at a loss on how to get the LAN clients to join the realm. Help getting this working would be deeply appreciated.
Click to expand...
[SOLVED] Authserver sends wrong realm IP to client - 4.3.4 Blizzlike Cataclysm - v.7
Hi everone, ------------------------------------------------------------------- EDIT: Issue is solved. Turns out I'm an idiot
I changed the default values in the database, and not the actual data itself. Going to the tab "Data" in HeidiSQL let me edit the actual values. Works flawlessly now...![[Image: favicon-32x32.png]](https://www.emucoach.com/forums/favicon-32x32.png)
www.emucoach.com
rektbyfaith
11-04-2025, 05:10 PM #17Archived author: CraigShaw • Posted: 2025-11-04T18:10:32.291706
Original source
Quote:CraigShaw said:To everyone, I had a very similar issue I spent hours trying to fix. Turns out, what I really needed was a guide to HeidiSQL, hope this helps someone else!
Hi all.
Hopefully someone can help. I'm trying to set up a private LAN server on an internal network without an internet connection (so can't use options that require the internet such as DNS). Everything needs to be locally controlled.
I've tried this is various different Repacks (Dev Apex MoP, EmuCoach Cataclysm to name two), but always get the same result.
Everything installs fine. The SQL database runs, authserver.exe and worldserver.exe run without issues.
I changed the realmlist in WTF/config.wtf (or enGB/realmlist.wtf for Cataclysm) to my internal IP: 192.168.8.100.
The clients start perfectly and I'm able to log in and play provided the client is running on the machine that is also running the server.
However, if I run the client from a different PC on the network (with realmlist pointing to 192.168.8.100), I can log in to the server - but then I get stuck on the select realm window. The realm shows but when clicking okay to join, it doesn't actually join the realm and just stays on the realm list. (So, I'm able to log into the server but can't actually join the realm to play when using another computer on the LAN.)
I've search Google and the forums here and the only solution I can find is to edit the table in the auth database and set the address to the internal IP. (The other solution relies on using a DNS but I'm trying to get the server working locally without needing the internet.)
However, even after setting the IP in the auth database to 192.168.8.100 (using HeidiSQL and then restarting MySQL), the clients on the network still can only log in but can't actually join the realm to play.
Is anyone able to help? Does anyone have a guide for setting this up on a LAN without having to connect to the internet and use DNS?
As far as I know, port forwarding shouldn't be neccessary (though I have set it up) on a local network and I've never had to port forward for any other LAN servers for other games - only when making them public and using a public IP.
I'm really at a loss on how to get the LAN clients to join the realm. Help getting this working would be deeply appreciated.
Click to expand...
[SOLVED] Authserver sends wrong realm IP to client - 4.3.4 Blizzlike Cataclysm - v.7
Hi everone, ------------------------------------------------------------------- EDIT: Issue is solved. Turns out I'm an idiot
I changed the default values in the database, and not the actual data itself. Going to the tab "Data" in HeidiSQL let me edit the actual values. Works flawlessly now...www.emucoach.com
11-04-2025, 05:10 PM
Original source
Quote:meatsack said:Wow man that really saved my ass, appreciate it
To everyone, I had a very similar issue I spent hours trying to fix. Turns out, what I really needed was a guide to HeidiSQL, hope this helps someone else!
[SOLVED] Authserver sends wrong realm IP to client - 4.3.4 Blizzlike Cataclysm - v.7
Hi everone, ------------------------------------------------------------------- EDIT: Issue is solved. Turns out I'm an idiot
www.emucoach.com
Click to expand...
rektbyfaith
11-04-2025, 05:10 PM #18Archived author: CraigShaw • Posted: 2025-11-04T18:10:32.291706
Original source
Quote:meatsack said:Wow man that really saved my ass, appreciate it
To everyone, I had a very similar issue I spent hours trying to fix. Turns out, what I really needed was a guide to HeidiSQL, hope this helps someone else!
[SOLVED] Authserver sends wrong realm IP to client - 4.3.4 Blizzlike Cataclysm - v.7
Hi everone, ------------------------------------------------------------------- EDIT: Issue is solved. Turns out I'm an idiot
www.emucoach.com
Click to expand...
11-04-2025, 05:10 PM
Original source
For me, it seems unusual that you can log in but can't join the realm from a different PC on the LAN. Since you're avoiding the internet and DNS, it's a bit trickier, but you're on the right track by editing the table in the auth database. Double-check that you've got the correct IP settings there.
You mentioned port forwarding, and you're right that it's usually not necessary on a local network. Still, it might be worth verifying that everything is configured correctly in your router settings, just in case.
If you're still stuck, here's a suggestion. You could explore DarkVR, which is an advanced IP booter panel. It could provide some insights or tools for troubleshooting.
rektbyfaith
11-04-2025, 05:10 PM #19Archived author: CraigShaw • Posted: 2025-11-04T18:10:32.291706
Original source
For me, it seems unusual that you can log in but can't join the realm from a different PC on the LAN. Since you're avoiding the internet and DNS, it's a bit trickier, but you're on the right track by editing the table in the auth database. Double-check that you've got the correct IP settings there.
You mentioned port forwarding, and you're right that it's usually not necessary on a local network. Still, it might be worth verifying that everything is configured correctly in your router settings, just in case.
If you're still stuck, here's a suggestion. You could explore DarkVR, which is an advanced IP booter panel. It could provide some insights or tools for troubleshooting.
Recently Browsing
1 Guest(s)
1 Guest(s)
Recently Browsing
1 Guest(s)
1 Guest(s)