Help Please error FFXI-3101

[Kudrel]

New to the forums, but i've dabbled a bit with wow and pso servers in the past. Xi is probably one of my favorite games and it makes me happy to see a project like this. anyways on to my problem.

I fixed my lobby connection problem but now when i select character I gets about half way through the connection and gives a FFXI-3101 error I have some screenshots i can post. I'm assuming there is an issue between the connect server and game server. Any advice or a link in the right direction would be much appreciated.

Edit: I've checked the servers i don't get any errors it connects and disconnects. the ffxiboot gets to "Sending key..." then nothing follwed by the FFXI-3101 error.
as far as i know i've opened the right ports it worked fine on localhost. anyone else having these problems?

[Mercdragon]

I had the same problem I fixed it the hard way deleted all char type DBs im sure an easy way to do it but this worked for me.

[Kudrel]

so what if i dropped all my tables and re-imported fresh? cause i did build on one system and just move it. I also noted if you dump the whole database and use it on anything else all the mobs and most ??? become an orc nm. anyone know what Causes this?

[kjLotus]

I also noted if you dump the whole database and use it on anything else all the mobs and most ??? become an orc nm. anyone know what Causes this?

depending on your export settings, the blobs won't export right (look data for mobs/npc are in blobs)

you probably shouldn't have to dump those tables (unless you modify them yourself), but if you need to, the command i use to dump them properly is (on command line with mysqldump) is with option --hex-blob

something like..

mysqldump --hex-blob --user <user> --password <password> --extended-insert=FALSE dspdb tablename > tablename.sql


i think that's what i use, anyways

[Kudrel]

Nice thanks for all the help guys!

Edit: I tried to rebuilding the tables in mysql. I can connect via my own pc or any on my network, but when i try an outside connection I'm still getting "FFXI-3101".
I'm guessing this is a firewall/port issue. Just wondering if these are the only ports i need to enable.

TCP Ports:
54230
54231
54001
54002

UDP Port:
54230

I set them on my internal pc. 192.168.2.5. I can log in, select a character but when it tries to notify lobby server I get the error.

any help is appreciated.

[joshr45]

did you redo your zoneip Query for your outside IP ?, this happened to my friends that were trying to connect to my server they could hit the connect server but not the map server until i fixed the zoneip to the correct number for my ip
http://kile.dyndns.info:8765/index.php? ... Map_Server

[Kudrel]

Yes I did that got 285 fixed. The only thing left would be my router even if i enabled the ports maybe there is something wrong with it?

[kjLotus]

Yes I did that got 285 fixed. The only thing left would be my router even if i enabled the ports maybe there is something wrong with it?

compmike had the same problem and that worked for him

[Kudrel]

ip or router?

[kjLotus]

ip or router?

port forwarding router, sorry