PCs gone

[msulli1355]

I tried using 1984's dsconnect with 2015's dsgame, dssearch and DB. It showed the same problem, so maybe the problem is in the database itself?

[whasf]

I dont know, it's gotta be something on your end. I haven't had any problems updating the test server or the development server...

[buttertoad]

Did you delete your tables or the database itself between upgrades? I had a similar problem with certain users not being allowed to log in. I dumped all the relevant tables and deleted the database. Sometimes newer versions make changes to the database tables but if you upgrade the SQL files will not overwrite what you have.

Now when I upgrade I dump all the user data I want to save and then drop all tables, and finally repopulate the new tables with the dump data.

I am SO thankful you guys support Linux

[msulli1355]

I went into mysql and MANUALLY dropped all the tables. I then resourced them using the scriptlet provided on http://forums.dspt.info/viewtopic.php?f=11&t=38. I then started the servers. I had the exact same problem as before. I created a character, tried to load him, failed with POL-3101, got dumped back at the dsconnect screen, only to have no characters available to log in with. I really don't see how this could be on my end.

[buttertoad]

Just a quick update.
I upgraded my server and I was able to login with a new database and with the old database after upgrading the tables. I'm running on Ubuntu Server 12.04.1 32bit.

Have you tried looking in the database while you are having issues?

Are you getting any SQL messages in your server output? It sounds like your server is having trouble talking to your database.

p.s. Just a thought, are your passwords and privileges for your database correct in your config files? If the server couldn't add characters to the database it might look like that.

[msulli1355]

This morning i completely wiped out my dsp files. I re-downloaded from svn. I re-created the db. I did everything the exact same way I've done 50+ times before. This time when I created Michael and tried to log in with him I got POL-3001. There are a bunch of errors in the screen containing dsgame.

[09:04:32][Info] parse: 00A | 0011 0000 2E from user:
[09:04:32][Warning] Client cannot receive packet or key is invalid:
[09:04:34][Info] parse: 00A | 0012 0000 2E from user:
[09:04:34][Warning] Client cannot receive packet or key is invalid:
[09:04:36][Info] parse: 00A | 0013 0000 2E from user:
[09:04:36][Warning] Client cannot receive packet or key is invalid:
[09:04:38][Info] parse: 00A | 0014 0000 2E from user:
[09:04:38][Warning] Client cannot receive packet or key is invalid:
[09:04:40][Info] parse: 00A | 0015 0000 2E from user:
[09:04:40][Warning] Client cannot receive packet or key is invalid:
[09:04:42][Info] parse: 00A | 0016 0000 2E from user:
[09:04:42][Warning] Client cannot receive packet or key is invalid:
[09:04:44][Info] parse: 00A | 0017 0000 2E from user:
[09:04:44][Warning] Client cannot receive packet or key is invalid:
[09:04:46][Info] parse: 00A | 0018 0000 2E from user:
[09:04:46][Warning] Client cannot receive packet or key is invalid:
[09:04:48][Info] parse: 00A | 0019 0000 2E from user:
[09:04:48][Warning] Client cannot receive packet or key is invalid:
[09:04:50][Info] parse: 00A | 001A 0000 2E from user:
[09:04:50][Warning] Client cannot receive packet or key is invalid:
[09:04:52][Info] parse: 00A | 001B 0000 2E from user:
[09:04:52][Warning] Client cannot receive packet or key is invalid:
[09:04:54][Info] parse: 00A | 001C 0000 2E from user:
[09:04:54][Warning] Client cannot receive packet or key is invalid:
[09:04:56][Info] parse: 00A | 001D 0000 2E from user:
[09:04:56][Warning] Client cannot receive packet or key is invalid:
[09:04:58][Info] parse: 00A | 001E 0000 2E from user:
[09:04:58][Warning] Client cannot receive packet or key is invalid:
[09:05:00][Info] parse: 00A | 001F 0000 2E from user:
[09:05:00][Warning] Client cannot receive packet or key is invalid:
[09:05:02][Info] parse: 00A | 0020 0000 2E from user:
[09:05:02][Warning] Client cannot receive packet or key is invalid:
[09:05:04][Info] parse: 00A | 0021 0000 2E from user:
[09:05:04][Warning] Client cannot receive packet or key is invalid:
[09:05:06][Info] parse: 00A | 0022 0000 2E from user:
[09:05:06][Warning] Client cannot receive packet or key is invalid:
[09:05:08][Info] parse: 00A | 0023 0000 2E from user:
[09:05:08][Warning] Client cannot receive packet or key is invalid:
[09:05:10][Info] parse: 00A | 0024 0000 2E from user:
[09:05:10][Warning] Client cannot receive packet or key is invalid:
[09:05:12][Info] parse: 00A | 0025 0000 2E from user:
[09:05:12][Warning] Client cannot receive packet or key is invalid:
[09:05:14][Info] parse: 00A | 0026 0000 2E from user:
[09:05:14][Warning] Client cannot receive packet or key is invalid:
[09:05:16][Info] parse: 00A | 0027 0000 2E from user:
[09:05:16][Warning] Client cannot receive packet or key is invalid:
[09:05:18][Info] parse: 00A | 0028 0000 2E from user:
[09:05:18][Warning] Client cannot receive packet or key is invalid:
[09:05:20][Info] parse: 00A | 0029 0000 2E from user:
[09:05:20][Warning] Client cannot receive packet or key is invalid:
[09:05:22][Info] parse: 00A | 002A 0000 2E from user:
[09:05:22][Warning] Client cannot receive packet or key is invalid:
[09:05:24][Info] parse: 00A | 002B 0000 2E from user:
[09:05:24][Warning] Client cannot receive packet or key is invalid:
[09:05:27][Info] parse: 00A | 002C 0000 2E from user:
[09:05:27][Warning] Client cannot receive packet or key is invalid:
[09:05:29][Info] parse: 00A | 002D 0000 2E from user:
[09:05:29][Warning] Client cannot receive packet or key is invalid:
[09:05:31][Info] parse: 00A | 002E 0000 2E from user:
[09:05:31][Warning] Client cannot receive packet or key is invalid:
[09:05:33][Info] parse: 00A | 002F 0000 2E from user:
[09:05:33][Warning] Client cannot receive packet or key is invalid:
[09:05:35][Info] parse: 00A | 0030 0000 2E from user:
[09:05:35][Warning] Client cannot receive packet or key is invalid:
[09:05:37][Info] parse: 00A | 0031 0000 2E from user:
[09:05:37][Warning] Client cannot receive packet or key is invalid:
[09:05:39][Info] parse: 00A | 0032 0000 2E from user:
[09:05:39][Warning] Client cannot receive packet or key is invalid:
[09:05:41][Info] parse: 00A | 0033 0000 2E from user:
[09:05:41][Warning] Client cannot receive packet or key is invalid:
[09:05:43][Info] parse: 00A | 0034 0000 2E from user:
[09:05:43][Warning] Client cannot receive packet or key is invalid:
[09:05:45][Info] parse: 00A | 0035 0000 2E from user:
[09:05:45][Warning] Client cannot receive packet or key is invalid:
[09:05:47][Info] parse: 00A | 0036 0000 2E from user:
[09:05:47][Warning] Client cannot receive packet or key is invalid:
[09:05:49][Info] parse: 00A | 0037 0000 2E from user:
[09:05:49][Warning] Client cannot receive packet or key is invalid:
[09:05:51][Info] parse: 00A | 0038 0000 2E from user:
[09:05:51][Warning] Client cannot receive packet or key is invalid:
[09:05:53][Info] parse: 00A | 0039 0000 2E from user:
[09:05:53][Warning] Client cannot receive packet or key is invalid:
[09:05:55][Info] parse: 00A | 003A 0000 2E from user:
[09:05:55][Warning] Client cannot receive packet or key is invalid:
[09:05:57][Info] parse: 00A | 003B 0000 2E from user:
[09:05:57][Warning] Client cannot receive packet or key is invalid:
[09:05:59][Info] parse: 00A | 003C 0000 2E from user:
[09:05:59][Warning] Client cannot receive packet or key is invalid:
[09:06:01][Info] parse: 00A | 003D 0000 2E from user:
[09:06:01][Warning] Client cannot receive packet or key is invalid:
[09:06:03][Info] parse: 00A | 003E 0000 2E from user:
[09:06:03][Warning] Client cannot receive packet or key is invalid:
[09:07:08][Debug] map_cleanup: timed out, session closed
[09:07:08][Debug] CZone:: Residential_Area DecreaseZoneCounter <0>
[09:07:11][Debug] map_close_session: session closed
[09:07:25][Debug] UpdateWeather Finished

Are these db errors?

[whasf]

The first time you login you'll get that error. Disconnect your client and wait for your character to timeout from the game server. Log back in and you should be OK.

[msulli1355]

Not true. When I got that error last time I shut down ffxiboot. Now when I start it up, I have no characters, just like before. However, when I look in the db:

mysql> select * from chars;
+--------+-------+----------+--------+----------+--------------+---------+-------+-------+-------+----------+-----------+----------+--------+--------+--------+--------+----------+--------+----------+--------+--------+-------+----------+
| charid | accid | charname | nation | pos_zone | pos_prevzone | pos_rot | pos_x | pos_y | pos_z | boundary | home_zone | home_rot | home_x | home_y | home_z | merits | missions | quests | keyitems | spells | titles | zones | playtime |
+--------+-------+----------+--------+----------+--------------+---------+-------+-------+-------+----------+-----------+----------+--------+--------+--------+--------+----------+--------+----------+--------+--------+-------+----------+
| 21828 | 1000 | Michael | 1 | 235 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 |
+--------+-------+----------+--------+----------+--------------+---------+-------+-------+-------+----------+-----------+----------+--------+--------+--------+--------+----------+--------+----------+--------+--------+-------+----------+
1 row in set (0.00 sec)

[whasf]

Only thing I can think of is because it's running on linux... Do you have a Windows box you could try it on?

[buttertoad]

I have it running on Linux with no issues. Unless it's an older version of GCC or something like that.

When I've seen those errors before it was because either I had a problem with my database or the zoneip was set wrong.

I had forgotten to add 2 columns to one of my tables when I upgraded once and it looked like that. I've also seen that when I set my zoneip wrong which might make sense because in your SQL output it has null values for all home data. It really looks like it is unable to communicate with the map server OR the database is not triggering the correct default values when you create a character. When you recreated your database did you just read in the new *.sql files or did you actually drop the database and start over? Are you sure the privileges have been set correctly for your user? Have you triple checked your zoneip is set correctly?

If those things look good you could check to make sure you don't have any other processes using the ports your server needs.
TCP Ports:
54230
54231
54001
54002
UDP Port:
54230

Code: Select all

netstat -lnptu | egrep '54230|54231|54001|54002|54230'

Run that for each port after a fresh restart of your server. They should all say "LISTENING" except the UDP port 54230 and they should be owned by darkstar processes.

Edit for a better netstat command.