Can't connect to game

[azafaraht]

I'm currently on r2909.

First problem I encountered was exactly after updating to r2909. I was able to log on and I was inside my mog house. I noticed that my char had hume gear on (appearance) instead of what I had on last time I was playing. So I decided to read forums and/or check files/update client. Second problem was that the command /shutdown wasn't working. Anyhow, I shutdown the game and proceeded to update my client.

After updating client, I tried connecting again. On the character selection screen I was still appeared with hume gear. After selecting my character, I get a message that there was no response on the server. My dsgame log shows:

Code: Select all

[13:17:14][Info] mapsession:192.168.1.102:54090 is coming to world...
[13:17:14][Fatal Error] Sql_NextRow: SQL_ERROR
[13:17:14][Info] parse: 00A | 0001 0000 2E from user: Azafaraht
[13:17:16][Info] parse: 00A | 0002 0000 2E from user: Azafaraht
[13:17:16][Warning] Client cannot receive packet or key is invalid: Azafaraht
[13:17:18][Info] parse: 00A | 0003 0000 2E from user: Azafaraht
[13:17:18][Warning] Client cannot receive packet or key is invalid: Azafaraht
[13:17:20][Info] parse: 00A | 0004 0000 2E from user: Azafaraht
[13:17:20][Warning] Client cannot receive packet or key is invalid: Azafaraht
[13:17:22][Info] parse: 00A | 0005 0000 2E from user: Azafaraht
[13:17:22][Warning] Client cannot receive packet or key is invalid: Azafaraht
[13:17:24][Info] parse: 00A | 0006 0000 2E from user: Azafaraht
[13:17:24][Warning] Client cannot receive packet or key is invalid: Azafaraht
[13:17:26][Info] parse: 00A | 0007 0000 2E from user: Azafaraht
[13:17:26][Warning] Client cannot receive packet or key is invalid: Azafaraht
[13:17:28][Info] parse: 00A | 0008 0000 2E from user: Azafaraht
[13:17:28][Warning] Client cannot receive packet or key is invalid: Azafaraht
[13:17:30][Info] parse: 00A | 0009 0000 2E from user: Azafaraht
[13:17:30][Warning] Client cannot receive packet or key is invalid: Azafaraht
[13:17:32][Info] parse: 00A | 000A 0000 2E from user: Azafaraht
[13:17:32][Warning] Client cannot receive packet or key is invalid: Azafaraht
[13:17:34][Info] parse: 00A | 000B 0000 2E from user: Azafaraht
[13:17:34][Warning] Client cannot receive packet or key is invalid: Azafaraht
[13:17:36][Info] parse: 00A | 000C 0000 2E from user: Azafaraht
[13:17:36][Warning] Client cannot receive packet or key is invalid: Azafaraht
[13:17:38][Info] parse: 00A | 000D 0000 2E from user: Azafaraht
[13:17:38][Warning] Client cannot receive packet or key is invalid: Azafaraht
[13:17:40][Info] parse: 00A | 000E 0000 2E from user: Azafaraht
[13:17:40][Warning] Client cannot receive packet or key is invalid: Azafaraht
[13:17:42][Info] parse: 00A | 000F 0000 2E from user: Azafaraht
[13:17:42][Warning] Client cannot receive packet or key is invalid: Azafaraht
[13:17:44][Info] parse: 00A | 0010 0000 2E from user: Azafaraht
[13:17:44][Warning] Client cannot receive packet or key is invalid: Azafaraht
[13:17:46][Info] parse: 00A | 0011 0000 2E from user: Azafaraht
[13:17:46][Warning] Client cannot receive packet or key is invalid: Azafaraht
[13:17:48][Info] parse: 00A | 0012 0000 2E from user: Azafaraht
[13:17:48][Warning] Client cannot receive packet or key is invalid: Azafaraht
[13:17:50][Info] parse: 00A | 0013 0000 2E from user: Azafaraht
[13:17:50][Warning] Client cannot receive packet or key is invalid: Azafaraht
[13:17:52][Info] parse: 00A | 0014 0000 2E from user: Azafaraht
[13:17:52][Warning] Client cannot receive packet or key is invalid: Azafaraht
[13:18:53][Debug] map_cleanup: Azafaraht timed out, session closed
[13:18:53][Debug] CZone:: Residential_Area DecreaseZoneCounter <0> Azafaraht
[13:18:56][Debug] map_close_session: session closed

My dsconnect log shows:

Code: Select all

[09/Mar 13:16][Info] login_parse:<azafaraht> was connected
[09/Mar 13:16][Debug] lobbyview_parse:Incoming Packet:<26> from ip:<192.168.1.102>
[09/Mar 13:16][Debug] lobbyview_parse:Incoming Packet:<1f> from ip:<192.168.1.102>
[09/Mar 13:16][Debug] lobbydata_parse:Incoming Packet:<a1> from ip:<192.168.1.102>
[09/Mar 13:16][Debug] lobbyview_parse:Incoming Packet:<24> from ip:<192.168.1.102>
[09/Mar 13:17][Debug] lobbyview_parse:Incoming Packet:<7> from ip:<192.168.1.102>
[09/Mar 13:17][Debug] lobbydata_parse:Incoming Packet:<a2> from ip:<192.168.1.102>
[09/Mar 13:17][Info] lobbydata_parse: zoneid:(0),zoneip:(192.168.1.200),zoneport:(54230) for char:(21830)
[09/Mar 13:17][Status] lobbydata_parse: client 192.168.1.102 finished work with lobbyview
[09/Mar 13:18][Debug] lobbyview_parse:Incoming Packet:<26> from ip:<192.168.1.102>
[09/Mar 13:18][Debug] lobbyview_parse:Incoming Packet:<1f> from ip:<192.168.1.102>
[09/Mar 13:18][Debug] lobbydata_parse:Incoming Packet:<a1> from ip:<192.168.1.102>
[09/Mar 13:18][Debug] lobbyview_parse:Incoming Packet:<24> from ip:<192.168.1.102>
[09/Mar 13:18][Debug] lobbyview_parse:Incoming Packet:<7> from ip:<192.168.1.102>
[09/Mar 13:18][Debug] lobbydata_parse:Incoming Packet:<a2> from ip:<192.168.1.102>
[09/Mar 13:18][Info] lobbydata_parse: zoneid:(0),zoneip:(192.168.1.200),zoneport:(54230) for char:(21830)
[09/Mar 13:18][SQL] DB error - Duplicate entry '21830' for key 'PRIMARY'
[09/Mar 13:19][Info] lobbyview_parse: azafaraht shutdown the socket
[09/Mar 13:19][Info] login_parse:192.168.1.102shutdown socket...
[09/Mar 13:19][Info] lobbydata_parse: azafaraht shutdown the socket
[09/Mar 13:19][Info] lobbydata_parse: azafaraht's login_session_data is deleted

Regarding the duplicate entry message, I do not have two chars with the same charid in the chars table.

Note: While writing this post, I was checking FFXI files again, but there was nothing to fix or update.

[kjLotus]

"DB error - Duplicate entry '21830' for key 'PRIMARY'"

usually means the character with id 21830 already exists in the game world - ie: your character still hasn't timed out yet

(it is referring to accounts_sessions table, which should be empty if nobody is logged in)

[bluekirby0]

You can safely delete entries in the account_sessions table for characters that are not logged in. That is usually how you fix this issue. The @resetplayer GM command also does this, I believe.

[azafaraht]

Guys, thanks for your quick response. I wasn't able to access forums until today.

I verified my accounts_sessions and it was empty. I tried to log in, selected character (still looks like a hume with basic hume gear), and after waiting in the Downloading data screen I received the following message:

Error code: FFXI-3001
No response from the Final Fantasy XI server.
Connection timed out.
Press Ok to shut down.

My logs were basically the same as the ones in the OP, except there was no "duplicate key" message in the connection log.

[azafaraht]

Nothing as of yet:

Code: Select all

[18:14:30][Info] mapsession:192.168.1.102:54090 is coming to world...
[18:14:33][Fatal Error] Sql_NextRow: SQL_ERROR
[18:14:33][Info] parse: 00A | 0001 0000 2E from user: Azafaraht
[18:14:33][Info] parse: 00A | 0002 0000 2E from user: Azafaraht
[18:14:33][Warning] Client cannot receive packet or key is invalid: Azafaraht
[18:14:34][Info] parse: 00A | 0003 0000 2E from user: Azafaraht
[18:14:34][Warning] Client cannot receive packet or key is invalid: Azafaraht
[18:14:36][Info] parse: 00A | 0004 0000 2E from user: Azafaraht
[18:14:36][Warning] Client cannot receive packet or key is invalid: Azafaraht
[18:14:38][Info] parse: 00A | 0005 0000 2E from user: Azafaraht
[18:14:38][Warning] Client cannot receive packet or key is invalid: Azafaraht
[18:14:40][Info] parse: 00A | 0006 0000 2E from user: Azafaraht
[18:14:40][Warning] Client cannot receive packet or key is invalid: Azafaraht
[18:14:42][Info] parse: 00A | 0007 0000 2E from user: Azafaraht
[18:14:42][Warning] Client cannot receive packet or key is invalid: Azafaraht
[18:14:44][Info] parse: 00A | 0008 0000 2E from user: Azafaraht
[18:14:44][Warning] Client cannot receive packet or key is invalid: Azafaraht
[18:14:46][Info] parse: 00A | 0009 0000 2E from user: Azafaraht
[18:14:46][Warning] Client cannot receive packet or key is invalid: Azafaraht
[18:14:48][Info] parse: 00A | 000A 0000 2E from user: Azafaraht
[18:14:48][Warning] Client cannot receive packet or key is invalid: Azafaraht
[18:14:51][Info] parse: 00A | 000B 0000 2E from user: Azafaraht
[18:14:51][Warning] Client cannot receive packet or key is invalid: Azafaraht
[18:14:53][Info] parse: 00A | 000C 0000 2E from user: Azafaraht
[18:14:53][Warning] Client cannot receive packet or key is invalid: Azafaraht
[18:14:55][Info] parse: 00A | 000D 0000 2E from user: Azafaraht
[18:14:55][Warning] Client cannot receive packet or key is invalid: Azafaraht
[18:14:57][Info] parse: 00A | 000E 0000 2E from user: Azafaraht
[18:14:57][Warning] Client cannot receive packet or key is invalid: Azafaraht
[18:14:59][Info] parse: 00A | 000F 0000 2E from user: Azafaraht
[18:14:59][Warning] Client cannot receive packet or key is invalid: Azafaraht
[18:15:01][Info] parse: 00A | 0010 0000 2E from user: Azafaraht
[18:15:01][Warning] Client cannot receive packet or key is invalid: Azafaraht
[18:15:03][Info] parse: 00A | 0011 0000 2E from user: Azafaraht
[18:15:03][Warning] Client cannot receive packet or key is invalid: Azafaraht
[18:15:05][Info] parse: 00A | 0012 0000 2E from user: Azafaraht
[18:15:05][Warning] Client cannot receive packet or key is invalid: Azafaraht
[18:15:07][Info] parse: 00A | 0013 0000 2E from user: Azafaraht
[18:15:07][Warning] Client cannot receive packet or key is invalid: Azafaraht
[18:15:09][Info] parse: 00A | 0014 0000 2E from user: Azafaraht
[18:15:09][Warning] Client cannot receive packet or key is invalid: Azafaraht
[18:15:11][Info] parse: 00A | 0015 0000 2E from user: Azafaraht
[18:15:11][Warning] Client cannot receive packet or key is invalid: Azafaraht
[18:15:13][Info] parse: 00A | 0016 0000 2E from user: Azafaraht
[18:15:13][Warning] Client cannot receive packet or key is invalid: Azafaraht
[18:15:15][Info] parse: 00A | 0017 0000 2E from user: Azafaraht
[18:15:15][Warning] Client cannot receive packet or key is invalid: Azafaraht

Is there any information I can provide to help myself fix this?

Thanks, I appreciate your time, and I know everyone is extremely busy to be dealing with every situation like this. Most of the time the problem is the user, I'm just having trouble reaching a solution.

[kjLotus]

it's possible your client didn't update properly, as well

i'd delete a random small .DAT and re do file check

[PrBlahBlahtson]

Interestingly enough, I think I may have hit this bug while testing something completely unrelated. The character in question simply could not log in, even if account_sessions was empty.

I thought the problem was my own fault, since I was working on something that executes when a player logs in, so I didn't do much experimenting with it. It was fixed after I logged in from a second computer and used @resetplayer from a completely separate account. I'm not sure if a second computer was necessary, or a separate account, as I wasn't being patient about it and didn't want to wait for decreasezonecounter to run.

Edit:
Triggered this again via breakpoints that basically timed out the login before it was even finished. The character ends up in Zone 0 with Prevzone 0 at 192,0,0. It can't seem to resolve things from there. Again, @resetplayer straightens it out, or manually editing the chars table while the player isn't logging in to put them somewhere valid.

[azafaraht]

I apologize for not answering before. I made a new server, created a new player, but when trying to log in I get the same errors as in the OP. I tried the "logging in and out cleanly until it works" trick but no success.

[azafaraht]

When I first had this issue, I had the client on win7 on an iMac through Bootcamp and my servers were installed in Ubuntu through vbox.

Last week I tried again, reinstalling everything but on a different setup. Client on win7 on a MacBook Pro through Bootcamp and server on Raspbian in a raspberry pi.

Same problem occurred: I can create accounts and characters but I cannot log in.

Today I decided to try again, simply by installing the sever where I installed the client: win7 macbook. This worked, I was able to login into the game.

Is it save to assume the problem is related to building the server in Linux? I hope this information becomes valuable, as I'm more inclined to running the server on Linux and seperate to where I installed my client.

UPDATE: I logged out my char (\shutdown). Started the servers again, logged in, selected character and again stuck at the same error when "downloading data".

Client cannot receive packet or key is invalid

[azafaraht]

I'm able to "log into game" now. However, tried char by char, one by one, and no matter what zone I was in, I ended up in Residential Area, with zone and positions values cleared in the database.

What's going on with me?