My server -- no spawns or targetable items
Moderator: Community Managers
My server -- no spawns or targetable items
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:
If I put in the external address for both internal and external, the world server would not function:
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:
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
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
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...
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 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
- Retired
- Posts: 4581
- Joined: Wed Aug 28, 2013 9:40 am
- Location: Phoenix, AZ.
- Contact:
Re: My server -- no spawns or targetable items
[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)
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)
Re: My server -- no spawns or targetable items
I get no random spawns, either. I'll update the loggers and see if I get anything helpful.
Re: My server -- no spawns or targetable items
Looks pretty appropriate, overall:
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.
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.
My client was up-to-date at sunset, as well. I have no troubles on New Telon.
Last edited by zippyzee on Fri Oct 24, 2014 5:16 pm, edited 1 time in total.
- John Adams
- Retired
- Posts: 4581
- Joined: Wed Aug 28, 2013 9:40 am
- Location: Phoenix, AZ.
- Contact:
Re: My server -- no spawns or targetable items
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.
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.
Re: My server -- no spawns or targetable items
Well, that is definitely going to be a problem. There are no entries in that table. I'll look into it.
Re: My server -- no spawns or targetable items
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...
Time to get working on it...
- John Adams
- Retired
- Posts: 4581
- Joined: Wed Aug 28, 2013 9:40 am
- Location: Phoenix, AZ.
- Contact:
Re: My server -- no spawns or targetable items
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.
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.
Re: My server -- no spawns or targetable items
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:
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!
Just add the line:
Code: Select all
mysql> set global max_allowed_packet=1000000000;
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
- Retired
- Posts: 4581
- Joined: Wed Aug 28, 2013 9:40 am
- Location: Phoenix, AZ.
- Contact:
Re: My server -- no spawns or targetable items
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
But, good to see you figured it out regardless