Gameserver doesn't appear to function for me

[tagban]

Thanks I did get it to work a few times though it just seems like maybe my connect client software isn't receiving the packets? Is there a possibility I need to open MORE ports than noted? I actually yesterday, went and moved the server to my mom's house so I can remotely access it easier, it worked once, then I turned OFF intro movies, and RESET the Char/account db, (because it wasn't logging in properly, getting that same message).

Anyway I'll keep messing around, server is now set to ffxi.dyndns.org if anyone wants to test, it really could just be my client, I'm using mXI Darkstar version.

[tagban]

Okay went thru and totally rebuilt the db, seems to have fixed my issue.. Not sure why though. Whats the best way to backup the database? obviously all of the chars/accounts tables should be backed up, does navicat allow for just those to be backed up though? originally I was having NPC text being completely the wrong text: IE entering mog house in Jeuno would give me a message about auction houses.

[biboy]

Whats the best way to backup the database? obviously all of the chars/accounts tables should be backed up, does navicat allow for just those to be backed up though? originally I was having NPC text being completely the wrong text: IE entering mog house in Jeuno would give me a message about auction houses.

backing up is not that hard, normally I'd just dump sql file using navicat, then rename it with the current svn revision. Save that in a different directory though, so when you clean all the server folder, it don't get deleted. I do this before I update to a new rev. If I want to just migrate my characters to new build, I'd dump sql file the ff: accounts, char_effects, char_equip, chr_exp, char_inventory, char_jobs, char_look, char_points, char_profile, char_skills, char_stats, char_storage, char_vars and lastly chars.sql then save that somewhere else for reuse later when building a new db. Execute this .sql after you have executed all the .sql files in your \sql folder when building a new db. You can hold down ctrl key and just click all of those table in navicat, then right click the highlighted tables and click Dump .sql files to save your characters. I do compress all the backup db to save space. I hope this helps you maintain your server. by the way, if new revisions modified these tables (and it is part of progress) you will have to toss out all your characters and just creater new ones.. no harm done, just part of progress. We are all testers so never consider anything final.

[Fenrir]

So a few things, I did manage to get into the server, but now I'm having crashes randomly, now I'm seeing messages on my server log screen" [Warning] Client cannot receive packet or key is invalid: Bazinga (for my char).

The same thing seems to eventually give me the FFXI-3001 Error. This has been random, when I reset my chars/accounts list, it seems to work for me for a while, othertimes it doesn't..

I have another friend that was able to connect with my server no problem *he uses RETAIL version of FFXI*, but when he kills Mandy's outside of town, he crashes right after killing the mandy, but its from ffxi-boot, mXI_9_1-Darkstar.

Just wondering if anyone has suggestions. I did get the IP address issue straightened out, thanks a lot! Now that I can login to the server I'm happy, And was even able to kill stuff myself (But I reverted my files to the "July" patch as recommended in another post, so I'm guessing thats what my friend's trouble is).

If anyone wants to check it out, I wouldn't mind some ideas (if you packet log and can tell what I'm doing wrong: 75.75.172.72

Can you share what you did? I'm having the same problem. Login/lobby server works fine, I can create characters just fine, but when I try to log in I get stuck at "Downloading data" and the game server appears to be doing nothing.

[bluekirby0]

Check your zoneip setting in the database.

[Fenrir]

Check your zoneip setting in the database.

ZoneIP seems fine, I've use the calculator tool and verified it's set properly in the database.

EDIT: Server IP is 99.89.104.44 and zoneip in the database is set to 1666803756 per the tool. I'm hosting the server on a different machine within my own network, and I'm able to connect internally and externally from my home network, but I get stuck at "Downloading Data" and I'm not sure where to go from there.

EDIT2: Nevermind, I found the footnote that said the IP tool is wrong and you need to input your IP in reverse. I'm able to connect to the server but getting Invalid Key errors now.

[atom0s]

Check your zoneip setting in the database.

ZoneIP seems fine, I've use the calculator tool and verified it's set properly in the database.

EDIT: Server IP is 99.89.104.44 and zoneip in the database is set to 1666803756 per the tool. I'm hosting the server on a different machine within my own network, and I'm able to connect internally and externally from my home network, but I get stuck at "Downloading Data" and I'm not sure where to go from there.

EDIT2: Nevermind, I found the footnote that said the IP tool is wrong and you need to input your IP in reverse. I'm able to connect to the server but getting Invalid Key errors now.

That tends to happen randomly. Just let yourself time out and try connecting again after a few minutes. Might take upto 3 tries to connect. (Issues with the blowfish encryption.)