Lan issue

[IsharuMatsu]

Hey Ive gone over quite a few of the tutorials on how to fix getting stuck in the world login however my issues rather different, I got my server up and running specifically for lan purposes. The computer running the server can login perfectly fine and run around however others on the local area network get the stuck at the world login, their account logs in fine but they cant seem to connect to the realm to play.

Anyone have any ideas on how to fix this I'd greatly appreciate it.

 

[IsharuMatsu]

Everytime the alternate pc tries to log in and gets caught at the realm list the console keeps saying refreshing realmlist

 

[timhimosc]

Same thing here. The outside person is just able to get to the Realmlist and no further, host is fine. I updated the realmlist ip, opened all ports, checked them with a port checker tool online. Peculiarly, there are NO errors.

 

[cliffsmits]

make sure you have changed the Database/auth/realmlist ip from 127.0.0.1 to your ip adress and your friend need to connect with your external ip adress .

i think aswell you need to edit your Hostfile.

# localhost name resolution is handled within DNS itself.
# 127.0.0.1 localhost
# myexternalipaddress

 

[timhimosc]

Just a few questions as I'm new to hosting.

I thought the # symbol commented out the line like in programming?

Will putting my external IP by itself on a line like that do anything? I thought the host file redirected one address to another.

Finally, does being able to log in and view the realmlist but not connect to the realm pinpoint it any further?

 

[IsharuMatsu]

Just to clarify i am trying to run it as a simple lan server not so much a Wan with a friend connecting via net. I mostly say that cause when i set the host to my ip i cant connect anymore myself

 

[Adriel]

simple lan server

you need to get you LAN IP of the server PC - command prompt run ipconfig to get it
it will be something like 192.168.x.x or 10.0.x.x

You want to go into your server configs and put the lan ip in as the BIND IP.
leave the mysql ip addresses 127.0.0.1
In your Mysql database = Auth and table > realmlist you need to set your servers lan IP in there also.

In you game client you need to edit your config for the realmlist to the servers IP

Start your auth server first then the world server assuming your MySQL server is running already.

Now you should be able to connect to your server.

the reason your getting hung up at login is you didnt set in the realmlist table values of your servers LAN IP. its by default 127.0.0.1 and should be changed to whatever your servers lan ip is.
I ran into this same issue a time ago and had to find the fix on my own as no one back then knew why or what to do..

Anytime you add a realm to your server cluster you need to add a line to the sql table > realmlist

 

[IsharuMatsu]

Thank you with your help i fixed the problem Adriel. Now we both can log in and spend countless hours wasting away playing it, i thank you from a gamer perspective and damn you from a human perspective

 

[ExO]

Awesome to hear that you have solved your problem!

Closing the thread.