IP of Map Server after PC got a new IP

[hakusho]

So last weekend I grabbed my PC and took it to my brother's place for a good old fashioned FFXI session.
My FFXI server is only configured for local play and I've only ever used the localhost address when configuring everything.
However, I was unable to log in after connecting my PC to my brother's network (192.168.1.0/24). I was able to select my character but received a timeout error when trying to log in. The Connect Server apparently tried to send me to the original IP of my PC (192.168.2.0/24 network) when sending me to the Map Server. I can't remember entering that IP anywhere in a config file or the database. I've rebuilt the servers, updated them and rebooted several times.
Configuring my PC to use the old IP address fixed the issue.
I'm wondering if the servers somehow cache the actual IP of the PC, even though everything is configured to use 127.0.0.1.
Can anyone tell me what I'm missing?

[PrBlahBlahtson]

Change the zoneip for all maps in the SQL table zone_settings.

Sample query:

Code: Select all

update zone_settings set zoneip = '1516374538';

The "zoneip" is determined using the following formula.

First octet + second octet^2 + third octet^3 + fourth octet^4

Example outputs:
251789322 = 10.0.2.15
1768032778 = 10.10.98.105
1516374538 = 10.10.98.90