My server -- no spawns or targetable items

[zippyzee]

I decided to take the plunge and set up my own server (New Bedford), downloading rev 741. I had some issues getting it to work properly.

First, if I put in both my internal ip address and my external ip address in the vgemu-world.xml file, I could create a character on my server. However, when logging in I would get stuck on "Waiting for data..." and the world server console would go a little crazy, like this:

Code: Select all

15:53:33.063 I General  Starting VGOEmulator WorldServer v0.1 Alpha
15:53:33.067 I Database MySQL database connected to 192.168.1.109:3306
15:53:33.233 I Config   Successfully loaded 496 packet structs.
15:53:33.242 I Database Successfully loaded 388 character titles.
15:53:33.467 I Database Successfully loaded 1245 factions.
15:53:33.469 D Rules    Loaded 1 Rule Sets
15:53:33.483 I Database Successfully loaded 4 variables.
15:53:33.484 D NPC      Loading Spawns
15:53:33.484 D NPC      Loading NPCs
15:53:37.165 D NPC      Loaded 11807 NPCs.
15:53:37.616 D Object   Loaded 13380 PPOs.
15:53:37.685 D Music    Loaded 1365 Music files.
15:53:37.744 D Sound    Loaded 1991 Sounds.
15:53:37.745 D Unreal   Loaded 0 Movers.
15:53:37.747 I Database Successfully loaded 23 commands.
15:53:37.747 I LUA      Successfully loaded 0 spawn scripts.
15:53:37.748 I LUA      Successfully loaded 0 chunk scripts.
15:53:37.748 D Char     Setting all players offline
15:53:37.913 I Database Successfully loaded 123 emotes.
15:53:37.914 I Net      Server listening on 192.168.1.109:10100
15:53:38.051 I Net      Connected to login server login.vgoemulator.net:10102
15:54:00.424 I UDP      New client connected from 192.168.1.1:55664
15:54:00.424 I UDP      Received session request from 192.168.1.1:55664 with connection ID 502387742
15:54:00.491 I UDP      New client connected from 192.168.1.109:55664
15:54:00.497 I UDP      Client from 192.168.1.109:55664 set to disconnect : Application
15:54:01.797 I UDP      New client connected from 192.168.1.109:55664
15:54:01.803 I UDP      Client from 192.168.1.109:55664 set to disconnect : Application
15:54:03.229 I UDP      New client connected from 192.168.1.109:55664
15:54:03.231 I UDP      Client from 192.168.1.109:55664 set to disconnect : Application
15:54:04.994 I UDP      New client connected from 192.168.1.109:55664
15:54:05.002 I Net      New Session: Account ID: 65  Session ID: '4deg8b6vtvhhf6m9g3u18g32q6'
15:54:05.199 I UDP      Client from 192.168.1.109:55664 set to disconnect : Application
15:54:05.202 I UDP      New client connected from 192.168.1.109:55664
15:54:05.202 I UDP      Client from 192.168.1.109:55664 set to disconnect : Application
15:54:05.205 I UDP      New client connected from 192.168.1.109:55664
15:54:05.205 I UDP      Client from 192.168.1.109:55664 set to disconnect : Application
15:54:05.208 I UDP      New client connected from 192.168.1.109:55664
15:54:05.208 I UDP      Client from 192.168.1.109:55664 set to disconnect : Application
15:54:05.211 I UDP      New client connected from 192.168.1.109:55664
15:54:05.212 I UDP      Client from 192.168.1.109:55664 set to disconnect : Application
15:54:05.215 I UDP      New client connected from 192.168.1.109:55664
15:54:05.216 I UDP      Client from 192.168.1.109:55664 set to disconnect : Application
15:54:05.926 I UDP      Client from 192.168.1.109:55664 has been removed.
15:54:06.831 I UDP      New client connected from 192.168.1.109:55664
15:54:06.840 I Net      New Session: Account ID: 65  Session ID: '4deg8b6vtvhhf6m9g3u18g32q6'
15:54:06.926 I UDP      Client from 192.168.1.109:55664 has been removed.
15:54:07.036 I UDP      Client from 192.168.1.109:55664 set to disconnect : Application
15:54:07.040 I UDP      New client connected from 192.168.1.109:55664
15:54:07.040 I UDP      Client from 192.168.1.109:55664 set to disconnect : Application

If I put in the external address for both internal and external, the world server would not function:

Code: Select all

19:34:17.956 I General  Starting VGOEmulator WorldServer v0.1 Alpha
19:34:17.959 I Database MySQL database connected to 192.168.1.109:3306
19:34:18.142 I Config   Successfully loaded 496 packet structs.
19:34:18.151 I Database Successfully loaded 388 character titles.
19:34:18.370 I Database Successfully loaded 1245 factions.
19:34:18.372 D Rules    Loaded 1 Rule Sets
19:34:18.387 I Database Successfully loaded 4 variables.
19:34:18.387 D NPC      Loading Spawns
19:34:18.387 D NPC      Loading NPCs
19:34:22.052 D NPC      Loaded 11807 NPCs.
19:34:22.502 D Object   Loaded 13380 PPOs.
19:34:22.572 D Music    Loaded 1365 Music files.
19:34:22.631 D Sound    Loaded 1991 Sounds.
19:34:22.632 D Unreal   Loaded 0 Movers.
19:34:22.633 I Database Successfully loaded 23 commands.
19:34:22.635 D Char     Setting all players offline
19:34:22.802 I Database Successfully loaded 123 emotes.
19:34:22.807 E Socket   Error binding UDP server socket on XX.XX.250.51:10100: The requested address is not valid in its context. //[XX for privacy].
19:34:22.807 I General  Shutting down
19:34:23.309 I General  Press any key to continue...

If I put in my internal address, and no external address, then I can find my character and enter my server.

However, nothing targetable spawns. No bank chests, no npc's, nothing targetable at all. The database seems to have sourced correctly; I can manually look through and find the spawns. The chunk messages indicate that no spawns are being loaded as the chunk loads:

Code: Select all

19:19:04.595 I General  Starting VGOEmulator WorldServer v0.1 Alpha
19:19:04.597 I Database MySQL database connected to 192.168.1.109:3306
19:19:04.750 I Config   Successfully loaded 496 packet structs.
19:19:04.760 I Database Successfully loaded 388 character titles.
19:19:04.992 I Database Successfully loaded 1245 factions.
19:19:04.994 D Rules    Loaded 1 Rule Sets
19:19:05.008 I Database Successfully loaded 4 variables.
19:19:05.008 D NPC      Loading Spawns
19:19:05.009 D NPC      Loading NPCs
19:19:08.624 D NPC      Loaded 11807 NPCs.
19:19:09.071 D Object   Loaded 13380 PPOs.
19:19:09.141 D Music    Loaded 1365 Music files.
19:19:09.200 D Sound    Loaded 1991 Sounds.
19:19:09.201 D Unreal   Loaded 0 Movers.
19:19:09.203 I Database Successfully loaded 23 commands.
19:19:09.204 D Char     Setting all players offline
19:19:09.369 I Database Successfully loaded 123 emotes.
19:19:09.371 I Net      Server listening on 192.168.1.109:10100
19:19:09.470 I Net      Connected to login server login.vgoemulator.net:10102
19:20:12.350 I UDP      New client connected from 192.168.1.109:60536
19:20:12.350 I UDP      Received session request from 192.168.1.109:60536 with connection ID 131535107
19:20:12.426 I Net      New Session: Account ID: 65  Session ID: '4deg8b6vtvhhf6m9g3u18g32q6'
19:20:16.398 D Char     Setting player online
19:20:16.405 D Chunk    Starting chunk 'Khal' (85)
19:20:16.406 D NPC      0 NPCs Loaded in Chunk ID: 85
19:20:16.407 D Object   0 PPOs Loaded in Chunk ID: 85
19:20:16.407 D NPC      31 Music Tracks Loaded in Chunk ID: 85
19:20:16.408 D NPC      37 Sounds Loaded in Chunk ID: 85
19:20:16.409 D NPC      0 Movers Loaded in Chunk ID: 85
19:20:16.425 I UDP      New client connected from 192.168.1.109:60537
19:20:16.425 I UDP      Received session request from 192.168.1.109:60537 with connection ID 200040439
19:20:16.501 I Chunk    New Session: Account ID: 65  Session ID: '4deg8b6vtvhhf6m9g3u18g32q6'
19:20:16.583 D Chunk     control_text='HELLO REVISION=0 MINVER=3151 VER=3186'
19:20:16.638 D Chunk     control_text='LOGIN'
19:20:18.416 D Chunk     control_text='JOIN'

I have fiddled with the port forwarding, but that doesn't seem to make much difference.

I also rebuilt the world server project (which is, by the way, missing "combat.cpp, patchserver.cpp, masterspawnlist.cpp, and dialogutil.cpp" from its external source list) and it had no effect.

Any suggestions?
Zippyzee

[John Adams]

[quote="zippyzee"]I also rebuilt the world server project (which is, by the way, missing "combat.cpp, patchserver.cpp, masterspawnlist.cpp, and dialogutil.cpp" from its external source list) and it had no effect.[/quote]
Whoops! I forgot to move the proj files from our super secret dev SVN to public. I'll do that in the next push.

As for NPC loading, ensure your rule for LoadNPCData = 1, otherwise it just uses code to randomly generate 5 NPCs around your location. That's old code, and could probably be removed at some point.

Further, turn all your vgemu-world.xml loggers to Level="5" to see more spammy logging (except Database, leave that one at 0)

[zippyzee]

I get no random spawns, either. I'll update the loggers and see if I get anything helpful.

[zippyzee]

Looks pretty appropriate, overall:

Code: Select all

20:04:06.547 I Database MySQL database connected to 192.168.1.109:3306
20:04:06.710 I Database Successfully loaded 388 character titles.
20:04:06.934 I Database Successfully loaded 1245 factions.
20:04:06.934 D Rules    Loading Rule Sets...
20:04:06.935 D Rules    Loading rule set 'default_ruleset' (1)
20:04:06.936 D Rules    Setting rule category 'R_World', type 'DefaultStartingChunkID' to value: 1
20:04:06.937 D Rules    Setting rule category 'R_Dev', type 'LoadNPCData' to value: 1
20:04:06.937 D Rules    Setting rule category 'R_Player', type 'DefaultMovementSpeed' to value: 750.0
20:04:06.938 D Rules    Setting rule category 'R_Chunk', type 'ProcessThreadSleepMS' to value: 50
20:04:06.938 D Rules    Setting rule category 'R_Chunk', type 'RemoveSpawnDistance' to value: 17000
20:04:06.939 D Rules    Setting rule category 'R_Chunk', type 'MaxSendSpawnDistance' to value: 8500
20:04:06.939 D Rules    Setting rule category 'R_Chunk', type 'DefaultChunkShutdownTimer' to value: 300000
20:04:06.939 D Rules    Setting rule category 'R_World', type 'UseStartingLocations' to value: 1
20:04:06.940 D Rules    Setting rule category 'R_World', type 'ServerLocked' to value: 0
20:04:06.940 D Rules    Setting rule category 'R_Chunk', type 'HearChatDistance' to value: 8500
20:04:06.941 D Rules    Setting rule category 'R_Player', type 'DefaultTitlePrefix' to value: 600
20:04:06.941 D Rules    Setting rule category 'R_Player', type 'DefaultTitleSuffix' to value: 601
20:04:06.941 D Rules    Setting rule category 'R_Player', type 'DefaultTitleShow' to value: 1
20:04:06.942 D Rules    Setting rule category 'R_Player', type 'MaxMovementSpeed' to value: 3000
20:04:06.942 D Rules    Loaded 1 Rule Sets
20:04:06.943 D Rules    Loading Global Ruleset id 1
20:04:06.957 I Database Successfully loaded 4 variables.
20:04:06.957 D NPC      Loading Spawns
20:04:06.958 D NPC      Loading NPCs
20:04:10.783 D NPC      Loaded 11807 NPCs.
20:04:17.181 D Object   Loaded 13380 PPOs.
20:04:17.249 D Music    Loaded 1365 Music files.
20:04:17.308 D Sound    Loaded 1991 Sounds.
20:04:17.309 D Unreal   Loaded 0 Movers.
20:04:17.310 I Database Successfully loaded 23 commands.
20:04:17.312 D Char     Setting all players offline
20:04:17.479 I Database Successfully loaded 123 emotes.
20:04:39.544 D Char     Loading character 'Zippyb' (1) for account_id: 65
20:04:45.446 D Rules    Rule: R_Player:DefaultMovementSpeed, Value: 750.0
20:04:45.448 D Char     Setting player online
20:04:45.452 D Char     Character Name: Zippyb being Removed.
20:04:45.455 D Rules    Rule: R_Chunk:ProcessThreadSleepMS, Value: 50
20:04:45.456 D Rules    Rule: R_Chunk:RemoveSpawnDistance, Value: 17000
20:04:45.456 D Rules    Rule: R_Chunk:MaxSendSpawnDistance, Value: 8500
20:04:45.457 D Rules    Rule: R_Chunk:HearChatDistance, Value: 8500
20:04:45.457 D Chunk    Starting chunk 'Khal' (85)
20:04:45.458 D Rules    Rule: R_Dev:LoadNPCData, Value: 1
20:04:45.458 D NPC      0 NPCs Loaded in Chunk ID: 85
20:04:45.459 D Object   0 PPOs Loaded in Chunk ID: 85
20:04:45.459 D NPC      31 Music Tracks Loaded in Chunk ID: 85
20:04:45.460 D NPC      37 Sounds Loaded in Chunk ID: 85
20:04:45.461 D NPC      0 Movers Loaded in Chunk ID: 85
20:04:45.553 I Chunk    New Session: Account ID: 65  Session ID: '4deg8b6vtvhhf6m9g3u18g32q6'
20:04:45.628 D Chunk     control_text='HELLO REVISION=0 MINVER=3151 VER=3186'
20:04:45.690 D Chunk     control_text='LOGIN'
20:04:47.211 D Chunk     control_text='JOIN'
20:06:46.535 D Char     Character Zippyb Set to Offline
20:06:46.577 D Char     Character Zippyb Set to Offline
20:06:51.565 I Chunk    Starting chunk shutdown timer for Khal.

And, if I set LoadNPCData=0, I get the message in the log "Generating 5 random NPCs" but they don't appear, either.

My client was up-to-date at sunset, as well. I have no troubles on New Telon.

[John Adams]

Okay, one more thing to check. I see the NPCs loading at startup, so the data certainly should be there. Check these tables:

spawn -> spawn_npcs -> spawn_location_entry -> spawn_location_placements <== critical

That's kind of the heirarchy. If Placements has no data for chunk_id 85, that is why they are not loading. I've actually never seen data >not< load, though.

[zippyzee]

Well, that is definitely going to be a problem. There are no entries in that table. I'll look into it.

[zippyzee]

It is most likely due to the maximum packet size issue: viewtopic.php?f=44&t=948&p=7535&hilit=max+packet#p7535
Time to get working on it...

[John Adams]

Ahh yes, I never think about that because my MySQL servers have all been set to 100MB for years. Usually it craps out entirely though, unless you're doing it at the command line, then the spam just stops "MySQL server has gone away."

Btw, this is only because I use Bulk Inserts. When content dev starts at a normal pace, all content should be extended inserts to avoid complications.

[zippyzee]

I just had a heck of a time trying to work around it in the GUI. I gave up and rebuilt from the command line.

Just add the line:

Code: Select all

mysql> set global max_allowed_packet=1000000000;

somewhere in there and it will make it through.

In my case it just skipped over that section and went to the end, and I never scrolled up and saw the error. Everything is working great, now!

[John Adams]

Do you not have access to your own MySQL instance? If you edit the my.cnf (or my.ini) file, there should be a max_allowed_packet setting.

But, good to see you figured it out regardless