Private Server - No zoneserver available

[Mizikezap]

I also see the tables launcher_zones and zone_server are empty

[Mizikezap]

I have seen something odd. I have created a character in the client screen but the server is down and I can't log in. That's what I know so far. Here is what I am finding odd.

I am using heidisql to view the database. I have the heidisql.exe in the EQEmuServer folder and I run it from that folder.

When I log into it, the Session Name is "Unnamed". The Network Type is "MySQL (TCP/IP)" and the Hostname/IP is "127.0.0.1".

Once I log into the database, I have checked all the tables and I can't find any reference to the character I created in the client screen. I have made multiple installation attempts and have multiple folders I have saved with each attempt I have made. I also copied all the files from an older attempt into this folder when I tried other adjustments.

Could the database my startup routines are referencing be different from the one I am viewing and editing with heidisql?

[GlassDeviant]

Hmm...

Just grasping at straws here, but do you have a different install of MySql on your system already?

[Uleat]

Open heidi and edit your `logsys_categories` table..

..set `World_Server`.`log_to_file` to 2 and try creating a character.

That enables some more in-depth logging and should help with troubleshooting.

(Post your world server log afterwards..)

[Mizikezap]

I checked the database and I don't have a start zone with an ID of 14.

[World Server] Checking Database Conversions..
[World Server] Loading variables..
[World Server] Purging expired data buckets...
[World Server] Loading zones..
[World Server] Clearing groups..
[World Server] Clearing raids..
[World Server] Clearing inventory snapshots..
[World Server] Loading items..
[World Server] Loading skill caps..
[World Server] Loading guilds..
[World Server] Loaded default rule set 'default'
[World Server] Loading EQ time of day..
[World Server] Loading launcher list..
[World Server] Reboot zone modes OFF
[World Server] Deleted 0 stale player corpses from database
[World Server] Loading adventures...
[World Server] Purging expired instances
[World Server] Loading char create info...
[World Server] Console (TCP) listener started.
[World Server] Server (TCP) listener started.
[World Server] Account (Admin) Logging(In) to character select :: LSID: 1
[World Server] Found 'TitaniumStartZoneID' rule setting: -1
[Status] SoF Start zone query: SELECT x, y, z, heading, start_zone, bind_id, bind_x, bind_y, bind_z FROM start_zones WHERE zone_id = 14 AND player_class = 11 AND player_deity = 206 AND player_race = 330

[World Server] Attempting autobootup of tutorialb (189:0)
[World Server] No zoneserver available to boot up.
[World Server] Attempting autobootup of tutorialb (189:0)
[World Server] No zoneserver available to boot up.
[World Server] Attempting autobootup of tutorialb (189:0)
[World Server] No zoneserver available to boot up.
[World Server] Attempting autobootup of tutorialb (189:0)
[World Server] No zoneserver available to boot up.
[World Server] Attempting autobootup of tutorialb (189:0)
[World Server] No zoneserver available to boot up.
[World Server] Attempting autobootup of tutorialb (189:0)
[World Server] No zoneserver available to boot up.
[World Server] Attempting autobootup of tutorialb (189:0)
[World Server] No zoneserver available to boot up.
[World Server] Attempting autobootup of tutorialb (189:0)
[World Server] No zoneserver available to boot up.
[World Server] Attempting autobootup of tutorialb (189:0)
[World Server] No zoneserver available to boot up.
[World Server] Attempting autobootup of tutorialb (189:0)
[World Server] No zoneserver available to boot up.
[World Server] Attempting autobootup of tutorialb (189:0)
[World Server] No zoneserver available to boot up.
[World Server] Attempting autobootup of tutorialb (189:0)
[World Server] No zoneserver available to boot up.
[World Server] Attempting autobootup of tutorialb (189:0)
[World Server] No zoneserver available to boot up.
[World Server] Attempting autobootup of tutorialb (189:0)
[World Server] No zoneserver available to boot up.
[World Server] Attempting autobootup of tutorialb (189:0)
[World Server] No zoneserver available to boot up.
[World Server] Attempting autobootup of tutorialb (189:0)
[World Server] No zoneserver available to boot up.
[World Server] Attempting autobootup of tutorialb (189:0)
[World Server] No zoneserver available to boot up.
[World Server] Attempting autobootup of tutorialb (189:0)
[World Server] No zoneserver available to boot up.
[World Server] Attempting autobootup of tutorialb (189:0)
[World Server] No zoneserver available to boot up.
[World Server] Attempting autobootup of tutorialb (189:0)
[World Server] No zoneserver available to boot up.
[World Server] Attempting autobootup of tutorialb (189:0)
[World Server] No zoneserver available to boot up.

[Mizikezap]

I think I am getting close. I notice I am not getting any server log files unless I manually run Zone.exe after my start.bat. I had expected this line would run the zone server and use the entry in the launcher table for zone.

start eqlaunch.exe zone

But it's not running zone.exe or starting any log files for the zone server.

I checked the launcher table and found the entry for zone
Name: zone
dynamics: 5

But I found no entry in the launcher_zones table. It is empty. Can you check to see if you have empty entries also?

start.bat
@echo off
shared_memory.exe
start loginserver.exe
start world.exe
echo Waiting for the world to finish loading before starting zones...
ping -n 10 127.0.0.1 > nul
start queryserv.exe
start ucs.exe
start eqlaunch.exe zone
exit

[Uleat]

I would recommend using t_start_server_with_login_server.bat for the time being..

..at least until we can rule out eqlaunch.exe as a problem.


I haven't used that in over a year and can not attest to its current functionality.

[Mizikezap]

Here are my log files after I use t_start_server_with_login_server.bat. I have adjusted some database entries to turn off tutorials and not log into any tutorial zones.

My query_server log file is empty.

I do see that it is created 30 duplicate Zone log files when I try to log in, each with a different log file number (exampe: zone_39128.log / zone_40664.log)

Zone log
[10-21-2018 :: 20:09:58] [Zone Server] CURRENT_VERSION: 1.1.3
[10-21-2018 :: 20:09:58] [Zone Server] Mapping Incoming Opcodes
[10-21-2018 :: 20:09:58] [Zone Server] Loading Variables
[10-21-2018 :: 20:09:58] [Zone Server] Loading zone names
[10-21-2018 :: 20:09:58] [Zone Server] Loading items
[10-21-2018 :: 20:09:58] [Zone Server] Loading npc faction lists
[10-21-2018 :: 20:09:58] [Zone Server] Loading loot tables
[10-21-2018 :: 20:09:58] [Zone Server] Loading skill caps
[10-21-2018 :: 20:09:58] [Zone Server] Loading spells
[10-21-2018 :: 20:09:58] [Zone Server] Loading base data
[10-21-2018 :: 20:09:59] [Zone Server] Loading guilds
[10-21-2018 :: 20:09:59] [Zone Server] Loading factions
[10-21-2018 :: 20:09:59] [Zone Server] Loading titles
[10-21-2018 :: 20:09:59] [Zone Server] Loading tributes
[10-21-2018 :: 20:09:59] [Zone Server] Loading corpse timers
[10-21-2018 :: 20:09:59] [Zone Server] Loading commands
[10-21-2018 :: 20:09:59] [Zone Server] 263 commands loaded
[10-21-2018 :: 20:09:59] [Zone Server] Loaded default rule set 'default'
[10-21-2018 :: 20:09:59] [Zone Server] Loading bot commands
[10-21-2018 :: 20:09:59] [Zone Server] 99 bot commands loaded
[10-21-2018 :: 20:09:59] [Zone Server] Loading bot spell casting chances
[10-21-2018 :: 20:09:59] [Zone Server] Loading Perl Event Export Settings...
[10-21-2018 :: 20:09:59] [Zone Server] Loading quests
[10-21-2018 :: 20:09:59] [Zone Server] Entering sleep mode


World Server Log
[10-21-2018 :: 19:59:25] [World Server] Checking Database Conversions..
[10-21-2018 :: 19:59:26] [World Server] Loading variables..
[10-21-2018 :: 19:59:26] [World Server] Purging expired data buckets...
[10-21-2018 :: 19:59:26] [World Server] Loading zones..
[10-21-2018 :: 19:59:26] [World Server] Clearing groups..
[10-21-2018 :: 19:59:26] [World Server] Clearing raids..
[10-21-2018 :: 19:59:26] [World Server] Clearing inventory snapshots..
[10-21-2018 :: 19:59:26] [World Server] Loading items..
[10-21-2018 :: 19:59:26] [World Server] Loading skill caps..
[10-21-2018 :: 19:59:27] [World Server] Loading guilds..
[10-21-2018 :: 19:59:27] [World Server] Loaded default rule set 'default'
[10-21-2018 :: 19:59:27] [World Server] Loading EQ time of day..
[10-21-2018 :: 19:59:27] [World Server] Loading launcher list..
[10-21-2018 :: 19:59:27] [World Server] Reboot zone modes OFF
[10-21-2018 :: 19:59:27] [World Server] Deleted 0 stale player corpses from database
[10-21-2018 :: 19:59:27] [World Server] Loading adventures...
[10-21-2018 :: 19:59:27] [World Server] Purging expired instances
[10-21-2018 :: 19:59:27] [World Server] Loading char create info...
[10-21-2018 :: 19:59:27] [World Server] Console (TCP) listener started.
[10-21-2018 :: 19:59:27] [World Server] Server (TCP) listener started.
[10-21-2018 :: 20:00:23] [World Server] Account (Admin) Logging(In) to character select :: LSID: 1
[10-21-2018 :: 20:01:01] [World Server] Attempting autobootup of felwithea (61:0)
[10-21-2018 :: 20:01:01] [World Server] No zoneserver available to boot up.

[Mizikezap]

I finally got it to work.

• I had to drop the PEQ database and do a fresh install.
• I had to change the Admin password in the table loginserver_server_accounts. For some reason, I had a problem logging in using either the values 'Password' or 'password'.
• I changed the long and short name of the Server in the table loginserver_world_server_registration
• I updated the value of the field ServerAdminID to the value of '1' for my server in the table loginserver_world_server_registration. '1' is the account 'Admin' found in table loginserver_server_admin_registration
• I changed all the IP addresses in the eqemu_config.json file to '127.0.0.1'. Everywhere it said IP, I changed the value.
• I changed the server name in the json file to match the updated servername in the database
• I removed the "loginserver1" section in the json file
• I changed the name of 'loginserver2' to just 'loginserver' in the json file
  

[Uleat]

I'm glad that you finally worked that out!

I had really reached a point of not having a clue :shrug: