Connectivity Issue

Xavius · #1 08-01-2007, 12:38 AM

Hi, I've spent some time browsing through and trying different things but not yet been able to resolve the issue of having other people log into my public server. I can see the server listed, but when selecting it I get thrown back to User Name/Password screen.

I'm using PEQ's database following the guide on the wikki: http://www.eqemulator.net/wiki/wikka...ka=ws992mysql5

I am on a home network and behind a router and have forwarded ports on both tcp and udp:
3306
5998
5999
7000:7005

My router static ip is 192.168.241.101
The computer ip is 81.146.63.111

Here is my eqmu_config.xml:

<?xml version="1.0">
<server>
<world>
<shortname>Elysium</shortname>
<longname>[Elysium] (Semi-Legit - Development)</longname>


<address>192.168.241.101</address>
<localaddress>127.0.0.1</localaddress>


<loginserver>
<host>eqemulator.net</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>


<key>some long random string</key>


<http port="9080" enabled="true" mimefile="mime.types" />
</world>


<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>*********</password>
<db>peq</db>
</database>
</server>

Here is my World.exe log:

[Debug] Starting Log: logs/eqemu_debug_world_5688.log
[Debug] [WORLD__INIT] Loading server configuration..
[Debug] [WORLD__INIT] Log settings loaded from log.ini
[Debug] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[Debug] [WORLD__INIT] Connecting to MySQL...
[Status] Starting Log: logs/eqemu_world_5688.log
[Status] Using database 'peq' at localhost:3306
[Debug] [WORLD__INIT] Starting HTTP world service...
[Debug] [WORLD__HTTP] Loaded mime types from mime.types
[Debug] [WORLD__INIT] Loading variables..
[Debug] [WORLD__INIT] Loading zones..
[Debug] [WORLD__INIT] Clearing groups..
[Debug] [WORLD__INIT] Clearing temporary merchant lists..
[Debug] [WORLD__INIT] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=54307
[Debug] [WORLD__INIT] Loading guilds..
[Debug] [RULES__CHANGE] Loading rule set 'default' (2)
[Debug] [WORLD__INIT] Loaded default rule set 'default'
[Debug] [WORLD__INIT] Loading EQ time of day..
[Debug] [WORLD__INIT] Loading launcher list..
[Debug] [WORLD__INIT] Reboot zone modes ON
[Debug] [WORLD__INIT] Deleted 0 stale player corpses from database
[Debug] [WORLD__INIT] Deleted 0 stale player backups from database
[Debug] [WORLD__INIT] Zone (TCP) listener started.
[Debug] [WORLD__INIT] Client (UDP) listener started.
[Debug] [NET__IDENTIFY] Registered patch 6.2
[Debug] [NET__IDENTIFY] Registered patch Titanium
[Debug] [NET__IDENTIFY] Registered patch Live
[Debug] [WORLD__LS] Connecting to login server...
[Debug] [WORLD__LS] Connected to Loginserver: eqemulator.net:5998
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:2333
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:2333
[Debug] [WORLD__LAUNCH] Adding pending launcher 1
[Debug] [WORLD__LAUNCH] Launcher Identified itself as 'zone'. Loading zone list.

[Debug] [WORLD__LAUNCH] Removing pending launcher 1. Adding zone to active list.

[Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:2335
[Debug] [WORLD__CONSOLE] New zoneserver #1 from 127.0.0.1:2335
[Debug] [WORLD__ZONE] [1] Zone started with name dynamic_01 by launcher zone
[Debug] [WORLD__ZONE] [1] Auto zone port configuration. Telling zone to use por
t 7000
[Debug] [WORLD__LAUNCH] zone: dynamic_02 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:2337
[Debug] [WORLD__CONSOLE] New zoneserver #2 from 127.0.0.1:2337
[Debug] [WORLD__ZONE] [2] Zone started with name dynamic_02 by launcher zone
[Debug] [WORLD__ZONE] [2] Auto zone port configuration. Telling zone to use por
t 7001
[Debug] [WORLD__LAUNCH] zone: dynamic_03 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:2339
[Debug] [WORLD__CONSOLE] New zoneserver #3 from 127.0.0.1:2339
[Debug] [WORLD__ZONE] [3] Zone started with name dynamic_03 by launcher zone
[Debug] [WORLD__ZONE] [3] Auto zone port configuration. Telling zone to use por
t 7002
[Debug] [WORLD__LAUNCH] zone: dynamic_04 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:2341
[Debug] [WORLD__CONSOLE] New zoneserver #4 from 127.0.0.1:2341
[Debug] [WORLD__ZONE] [4] Zone started with name dynamic_04 by launcher zone
[Debug] [WORLD__ZONE] [4] Auto zone port configuration. Telling zone to use por
t 7003
[Debug] [WORLD__LAUNCH] zone: dynamic_05 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:2343
[Debug] [WORLD__CONSOLE] New zoneserver #5 from 127.0.0.1:2343
[Debug] [WORLD__ZONE] [5] Zone started with name dynamic_05 by launcher zone
[Debug] [WORLD__ZONE] [5] Auto zone port configuration. Telling zone to use por
t 7004
[Debug] [WORLD__LAUNCH] zone: dynamic_06 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:2345
[Debug] [WORLD__CONSOLE] New zoneserver #6 from 127.0.0.1:2345
[Debug] [WORLD__ZONE] [6] Zone started with name dynamic_06 by launcher zone
[Debug] [WORLD__ZONE] [6] Auto zone port configuration. Telling zone to use por
t 7005

Initially when I followed the guide on the wikki I had these lines commented out and like this I could connect through another computer on my network, but nobody else could from outside the network:



As well when I do comment out those two lines I do get the additional line in my world.exe which is missing when I specify my router IP (192.xxxxx) in the above xml file right before I have to press enter on the first window to continue:
[Debug] [WORLD__LS] Loginserver provided 81.146.46.75 as world address

I'm no expert on networks and routers, but can usually follow an instruction through, like I mention, I've opened the ports on both software firewall and on the router as well, just hoping its something obvious that I'm missing

Damilis · #2 08-01-2007, 01:02 AM

Quote:

My router static ip is 192.168.241.101
The computer ip is 81.146.63.111

Um, I am confused as these numbers sound backward. Are you saying:

A) that your router obtains the IP: 192.168.241.101 from your ISP and your computer obtains the IP: 81.146.63.111 from your router?

B) Or is it backward and your routers WAN IP is 81.146.63.111 and your computers LAN IP is 192.168.241.101 ?

If I am guessing correctly and B is true then you should make your .xml:

Quote:

<address>81.146.63.111</address>
<localaddress>192.168.241.101</localaddress>

....

<database>
<host>192.168.241.101</host>

Xavius · #3 08-01-2007, 01:17 AM

ok, checked my router again, here are the numbers it shows:

WAN IP Address: 81.146.46.75 (but this one keeps changing when I reboot the router, but it is the one shown to me on 'whatismyip')

Static IP Address: 192.168.241.101 displayed by router on WAN page

Trying to figure out if I can get a static ip address for the computer, confused at the moment

When I do a ipconfig /all at the command prompt I get ip address of 10.0.0.3 ??? Anyone help me try and figure this out pls?

Damilis · #4 08-01-2007, 02:39 AM

Okay, to clairfy a few points for ya. Your routers IP as the rest of the world sees it is:

81.146.46.75

Now, your router also needs an IP address on your LAN side of the router and, for you, that is:

192.168.241.101

To keep things simplistic, think of your router as a wall with an airlock that has two doors, the outer one labeled 81.146.46.75 and the inner is 192.168.241.101.

Any info coming INTO your LAN has to reference the 81.146.46.75 IP while everything going OUT of your LAN needs to use 192.168.241.101 as its gateway.

From a DOS prompt, enter IPCONFIG
You should get something like this:

Code:

 
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
 
C:\>ipconfig
Windows IP Configuration

Ethernet adapter Local Area Connection:
        Connection-specific DNS Suffix  . :
        IP Address. . . . . . . . . . . . : 192.168.1.10
        Subnet Mask . . . . . . . . . . . : 255.255.255.0
        Default Gateway . . . . . . . . . : 192.168.1.1
C:\>

This tells me that my COMPUTER's IP address is 192.168.1.10 and that the gateway (aka routers LAN side IP) is 192.168.1.1

For a EQEmu server that wants people to be able to connect from outside your LAN, then try these xml settings, replacing YOUR_COMPUTERS_IP_ADDRESS_HERE with the actual IP of the server machine (not the routers LAN IP).

Code:

 
<!-- Only specify these two if you really think you need to. -->
<address>81.146.63.111</address>
<localaddress>YOUR_COMPUTERS_IP_ADDRESS_HERE</localaddress>

....

<database>
<host>YOUR_COMPUTERS_IP_ADDRESS_HERE</host>

Xavius · #5 08-01-2007, 03:11 AM

Problem I find is when I do IPCONFIG I get the following:

Ethernet adapter Wireless Network Connection:

Connection-specific DNS Suffix . :
IP Address. . . . . . . . . . . . : 10.0.0.14
Subnet Mask . . . . . . . . . . . : 255.0.0.0
Default Gateway . . . . . . . . . : 10.0.0.2

How can I get it to show the actual IP?

Damilis · #6 08-01-2007, 03:14 AM

Quote:

Originally Posted by Xavius

Problem I find is when I do IPCONFIG I get the following:

Ethernet adapter Wireless Network Connection:

Connection-specific DNS Suffix . :
IP Address. . . . . . . . . . . . : 10.0.0.14
Subnet Mask . . . . . . . . . . . : 255.0.0.0
Default Gateway . . . . . . . . . : 10.0.0.2

How can I get it to show the actual IP?

Wow, um, dat dunt look right. Few more questions:
1) Are on a home computer or at work?
2) Do you have anyother network adapters on this machine?
3) Is this machine a laptop?
3) Do you know how to get the settings for the DHCP server on your router? If so, please post them!

Xavius · #7 08-01-2007, 03:29 AM

Umm here goes:

1) Home Computer, but use it for work as well
2) on this machine I have ethernet or wireless, but only wireless is connected at moment
3) this is a laptop, but I have the same results from IPCONFIG on my desktop as well (on same network)
4) The DHCP details on my router page show up on the LAN config section, it has:
IP Address: 10.0.0.2
Subnet Mask: 255.0.0.0
--------------------------------------
DHCP Server checkbox is checked
DHCP Address Pool Selection has two options:
System Allocated (selected)
User Defined (not selected)

User Defined Start Address: 10.0.0.4
User Defined End Address: 10.0.0.15
(but these look like its set to System Allocated anyway)
---------------------------------------
DHCP Gateway selection:
Automatic (selected)
User Defined (not selected)

User Defined Gateway address (box is left blank)
---------------------------------------

Thats about it for DHCP

Damilis · #8 08-01-2007, 03:33 AM

Hrm, okay, it looks like the DHCP server has an addy of 10.0.0.2 and is handing out IPs on your LAN in the range of 10.0.04 to 10.0.0.15....

As long as you are surfing the internet without issue then I guess it works! Try these settings then (assuming that your EQEmu server is on the 10.0.0.14 machine:

Code:

<!-- Only specify these two if you really think you need to. -->
<address>81.146.63.111</address>
<localaddress>10.0.0.14</localaddress>

....

<database>
<host>10.0.0.14</host>

Also, double check that the Ports are forwarded to 10.0.0.14

Damilis · #9 08-01-2007, 03:34 AM

....just dawned on me... are you running on DSL? If so what's the Make & Model of your DSL modem?

Xavius · #10 08-01-2007, 03:55 AM

Its Conexant MR4C, changed the settings and now world.exe flashes up and closes again before I can see anything in it.

Error message is:
[08.01. - 16:52:36] Failed to connect to database: Error: #1130: Host 'machine name' is not allowed to connect to this MySQL server

Damilis · #11 08-01-2007, 04:05 AM

LOL okay, open a dos command window and cd over to your eqemu directory. From the cmd window, try world.exe. The world.exe should launch & fail but keep the dos window open.

I suspect it has something to do with permissions.
Try changing the Database connection IP back to 127.0.0.1 or localhost.

Secondly, (and this is the third time I have seen a thread like this in as many days...wierd) you are having connection issues due to your DSL modem being a router in addition to your router being a router. You have two levels of NAT so here are your options:

Quote:

A) Use DSL as router and shift the Linksys over to act as a simple HUB, using the DHCP & Port forwarding on the DSL modem/router.

-or-

B) Shift the DSL modem/router over to Bridge mode, have the Linksys aquire an IP from your ISP via PPPoE and use the DHCP & port forwarding on the Linksys.

Personally, I prefer (and recommend) B as typically the COTS routers will have 10x more stability, throughput and features than the craptastic DSL modem/routers that come standard issue with most broadband packages. Not to mention that you can Flash the Firmware of Linksys's WRT54G with the 'unsupported Firmware' and make it into one hell of a router!

Xavius · #12 08-01-2007, 04:10 AM

Ok, well I shifted the database back to localhost and I managed to get my other computer connected now, all I need is someone to try and connect from outside my network, server name is Elysium if anyone wants to try and connect?

Xavius · #13 08-01-2007, 04:23 AM

Well thank you for all the help Damilis, would never have gotten there without you, server is up and I have external connections, now I gotta get to making customisations and setting things out in game

Thanks again

Xavius
Elysium

Damilis · #14 08-01-2007, 04:26 AM

Quote:

Originally Posted by Xavius

Well thank you for all the help Damilis, would never have gotten there without you, server is up and I have external connections, now I gotta get to making customisations and setting things out in game

Thanks again

Xavius
Elysium

/salute

Always available to help slay the network monsters!