EQEmulator Forums - Trouble with zones

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Trouble with zones (https://www.eqemulator.org/forums/showthread.php?t=39237)

Trouble with zones

So I just updated my source to the new version off of the repack. Everything is running smoothly aside from 1 thing. Zones are going to sleep when empty and not wanting to wake back up. People are having trouble getting into any 'empty' zone. I have updated by loaded zones from 5 to 10 now its up to 50 and it doesnt seem to be helping. Also Zserver keeps spitting out a bunch of random letters everytime I zone now. Any ideas as to what could be going on?

Constantly getting 'Zone is unavailable' message when trying to get in game.

You said you upped your zones, but did you forward those ports? The extra zones means nothing if the ports are not forwarded.

Yes,I have ports 7000-8000 open to cover any thing like this and only 5 playable zones,with a maximum of 50 So im not sure why its not letting anyone get in.

You need to check some of your zone logs, more than likely your evidence will be there.

Code:

[01.16. - 09:37:55] Client 'No name' was destroyed before reaching the connected state:

[01.16. - 09:37:55] Client sent initial zone packet, but we never got their player info from the database.

Thats the only thing I can notice that has any negative conantation,everything else appears to be fine. The Zone logs just says zones are sleeping and listening on ports(which are open)

The code above is from zone_debug.

Newest debug

Code:

[01.16. - 11:06:57] Client 'No name' was destroyed before reaching the connected state:

[01.16. - 11:06:57] Client has not sent us an initial zone entry packet.

I need the error log for the exact same zone.

Should I add a zone to the zone_launcher table? Im just not sure what happened everything was working fine then out of nowhere all this started.

Quote:

Originally Posted by provocating (Post 236927)

I need the error log for the exact same zone.

I dont see any logs on a zone by zone basis just eqemu_zone , eqemu_debug_zone , and zone-dynamic

Code:

---------------------------------------------

[01.16. - 11:45:13] Starting Log: logs/eqemu_zone_15020.log

[01.16. - 11:45:13] ---- Zone server steppes, listening on port:7049 ----

[01.16. - 11:45:16] Zone shutdown: going to sleep

[01.16. - 11:49:15] ---- Zone server steppes, listening on port:7049 ----

[01.16. - 11:49:18] Zone shutdown: going to sleep

[01.16. - 11:53:48] ---- Zone server steppes, listening on port:7049 ----

[01.16. - 11:53:51] Zone shutdown: going to sleep

[01.16. - 12:01:32] ---- Zone server steppes, listening on port:7049 ----

[01.16. - 12:01:37] Zone shutdown: going to sleep

[01.16. - 12:06:31] ---- Zone server steppes, listening on port:7049 ----

[01.16. - 12:06:34] Zone shutdown: going to sleep

[01.16. - 12:09:05] ---- Zone server steppes, listening on port:7049 ----

[01.16. - 12:09:24] Zone shutdown: going to sleep

[01.16. - 12:13:12] ---- Zone server steppes, listening on port:7049 ----

[01.16. - 12:13:15] Zone shutdown: going to sleep

[01.16. - 12:17:36] ---- Zone server steppes, listening on port:7049 ----

[01.16. - 12:17:41] Zone shutdown: going to sleep

[01.16. - 12:26:40] ---- Zone server steppes, listening on port:7049 ----

[01.16. - 12:26:43] Zone shutdown: going to sleep

Thats the return when attempting to zone in.

That does not look like the error log? Are you positive?

I cant find any error logs anywhere. Just eqemu_zone log and zone debug logs.

When you updated your source, did you complete the auto-db update menu options to continue starting world? If you do not run the required SQL and then exit that menu, world will not load and zones won't be able to connect to it which will cause the launcher to keep booting them I think. I assume you are running the server on Windows. What does your world command prompt window say in it after you start the server?

Also, you increased your zone count in your launcher table and forwarded the ports in your router, but did you also increase your port range in your server config file to match?

Quote:

Originally Posted by trevius (Post 236937)

Also, you increased your zone count in your launcher table and forwarded the ports in your router, but did you also increase your port range in your server config file to match?

Good call, it is also in your eqemu_config.xml file

Quote:

Originally Posted by trevius (Post 236937)

Also, you increased your zone count in your launcher table and forwarded the ports in your router, but did you also increase your port range in your server config file to match?

To add to that, once you ensure the following:

Code:

<!-- Sets port range for world to use to auto configure zones -->

<ports low="7000" high="7100"/>

</zones>

Port range allows for enough ports are open to match the number of zones being used (or planned to be used), I personally wouldn't forward any more ports than necessary. You stated you had set ports 7000-8000 in your port forwarding.. that's excessive, unless of course you plan to have 1000 zones open.

Reduce the security risk, 100 ports (i.e. open zones & instanced zones) should very likely be plenty. (7000-7099 for example)

my config has 400 ports set aside for zones

Code:

<!-- Sets port range for world to use to auto configure zones DO NOT EDIT RIGHT NOW-->

<!-- <ports low="7000" high="7100"/> -->

<ports low="7000" high="7400"/>

</zones>

Also will close un-needed ports when issue is resolved,mainly opened them to try to figure this out

World.exe said everything was up to date. Wife decided to restart the pc while I was sleeping and now I can No longer connect to mysql or load the server for whatever reason.

Ok fixed the DB connection issue,world.exe is saying the following upon boot up

Code:

[Status] Using database 'peq' at 127.0.0.1:3306



[MYSQL ERR] 1050: Table 'character_corpse_items' already exists [Query]:

CREATE TABLE `character_corpse_items` (   `corpse_id` int(11) unsigned NOT NULL,

                  `equip_slot` int(11) unsigned NOT NULL,         `item_id` int(

11) unsigned DEFAULT NULL,        `charges` int(11) unsigned DEFAULT NULL,

  `aug_1` int(11) unsigned DEFAULT '0',           `aug_2` int(11) unsigned DEFAU

LT '0',           `aug_3` int(11) unsigned DEFAULT '0',           `aug_4` int(11

) unsigned DEFAULT '0',           `aug_5` int(11) unsigned DEFAULT '0',

  `aug_6` int(11) unsigned DEFAULT '0',           `attuned` smallint(5) NOT NULL

 DEFAULT '0',  PRIMARY KEY(`corpse_id`, `equip_slot`)             ) ENGINE = Inn

oDB DEFAULT CHARSET = latin1;





[MYSQL ERR] 1050: Table 'character_corpses' already exists [Query]:

RENAME TABLE `player_corpses` TO `character_corpses`





[MYSQL ERR] 1054: Unknown column 'WasAtGraveyard' in 'character_corpses' [Query]

:

 ALTER TABLE `character_corpses`





 ADD COLUMN `is_locked`                    tinyint(11) NULL DEFAULT 0 AFTER `Was

AtGraveyard`,

 ADD COLUMN `exp`                              int(11) UNSIGNED NULL DEFAULT 0,





 ADD COLUMN `size`                  int(11) UNSIGNED NULL DEFAULT 0,



 ADD COLUMN `level`                 int(11) UNSIGNED NULL DEFAULT 0,



 ADD COLUMN `race`                  int(11) UNSIGNED NULL DEFAULT 0,



 ADD COLUMN `gender`                int(11) UNSIGNED NULL DEFAULT 0,



 ADD COLUMN `class`                 int(11) UNSIGNED NULL DEFAULT 0,



 ADD COLUMN `deity`                 int(11) UNSIGNED NULL DEFAULT 0,



 ADD COLUMN `texture`               int(11) UNSIGNED NULL DEFAULT 0,



 ADD COLUMN `helm_texture`          int(11) UNSIGNED NULL DEFAULT 0,



 ADD COLUMN `copper`                int(11) UNSIGNED NULL DEFAULT 0,



 ADD COLUMN `silver`                int(11) UNSIGNED NULL DEFAULT 0,



 ADD COLUMN `gold`                  int(11) UNSIGNED NULL DEFAULT 0,



 ADD COLUMN `platinum`              int(11) UNSIGNED NULL DEFAULT 0,



 ADD COLUMN `hair_color`            int(11) UNSIGNED NULL DEFAULT 0,



 ADD COLUMN `beard_color`           int(11) UNSIGNED NULL DEFAULT 0,



 ADD COLUMN `eye_color_1`           int(11) UNSIGNED NULL DEFAULT 0,



 ADD COLUMN `eye_color_2`           int(11) UNSIGNED NULL DEFAULT 0,



 ADD COLUMN `hair_style`            int(11) UNSIGNED NULL DEFAULT 0,



 ADD COLUMN `face`                  int(11) UNSIGNED NULL DEFAULT 0,



 ADD COLUMN `beard`                 int(11) UNSIGNED NULL DEFAULT 0,



 ADD COLUMN `drakkin_heritage`      int(11) UNSIGNED NULL DEFAULT 0,



 ADD COLUMN `drakkin_tattoo`        int(11) UNSIGNED NULL DEFAULT 0,



 ADD COLUMN `drakkin_details`       int(11) UNSIGNED NULL DEFAULT 0,



 ADD COLUMN `wc_1`                         int(11) UNSIGNED NULL DEFAULT 0,





 ADD COLUMN `wc_2`                         int(11) UNSIGNED NULL DEFAULT 0,





 ADD COLUMN `wc_3`                         int(11) UNSIGNED NULL DEFAULT 0,





 ADD COLUMN `wc_4`                         int(11) UNSIGNED NULL DEFAULT 0,





 ADD COLUMN `wc_5`                         int(11) UNSIGNED NULL DEFAULT 0,





 ADD COLUMN `wc_6`                         int(11) UNSIGNED NULL DEFAULT 0,





 ADD COLUMN `wc_7`                         int(11) UNSIGNED NULL DEFAULT 0,





 ADD COLUMN `wc_8`                         int(11) UNSIGNED NULL DEFAULT 0,





 ADD COLUMN `wc_9`                         int(11) UNSIGNED NULL DEFAULT 0,





 CHANGE COLUMN `zoneid` `zone_id`  smallint(5) NOT NULL DEFAULT 0 AFTER `charnam

e`,

 CHANGE COLUMN `instanceid` `instance_id`  smallint(5) UNSIGNED NOT NULL DEFAULT

 0 AFTER `zone_id`,

 CHANGE COLUMN `timeofdeath` `time_of_death`  datetime NOT NULL DEFAULT '0000-00

-00 00:00:00' AFTER `data`,

 CHANGE COLUMN `rezzed` `is_rezzed`  tinyint(3) UNSIGNED NULL DEFAULT 0 AFTER `t

ime_of_death`,

 CHANGE COLUMN `IsBurried` `is_buried`  tinyint(3) NOT NULL DEFAULT 0 AFTER `is_

rezzed`;







[MYSQL ERR] 1054: Unknown column 'WasAtGraveyard' in 'character_corpses' [Query]

:

 ALTER TABLE `character_corpses`





 CHANGE COLUMN `WasAtGraveyard` `was_at_graveyard`  tinyint(3) NOT NULL DEFAULT

0 AFTER `is_buried`





Pulling down automatic database upgrade script...



No update necessary

Perl Version is 5.12.3

Warning: Using a password on the command line interface can be insecure.

Warning: Using a password on the command line interface can be insecure.

Warning: Using a password on the command line interface can be insecure.

============================================================

           EQEmu: Automatic Database Upgrade Check

============================================================

        Operating System is: MSWin32

        (Windows) MySQL is in system path

        Path = C:\xampp\mysql\bin/mysql

============================================================

        Binary Database Version: (9066)

        Local Database Version: (9066)



        Database up to Date: Continuing World Bootup...

============================================================



[MYSQL ERR] 1932: Table 'peq.group_leaders' doesn't exist in engine [Query]:

DELETE from group_leaders



Unable to clear group leaders: #1932: Table 'peq.group_leaders' doesn't exist in

 engine

Was not getting the table errors before the DB connection issue so not sure what is going on there now. When I updated my source I did select option 3,two times once to check for updates then to update. That is all I did,was I suppose to source anything in? Everything was working fine when I first updated.

I am not sure what happened when you PC was restarted, but it looked like your DB has some major issues with missing tables and such. If you have a full DB backup from before the updates, I would suggest reverting to it. Otherwise, it may be a pain to get whatever is missing in your tables restored manually.

Would u suggest reudating after I revert to the old DB? Really dont wanna have to abandon ornaments and such.... Have done quit a good bit of db work that I would really prefer not to loose lol....didn't have any missing tables until I installed the repack (apearntly I had screwed up SQL somehow),installing a fresh repack fixed that problem but now the missing fields and the zone problem still remains.

Its just odd,when I check Heidi for the stuff that is claimed to be missing,i see all the rows and columns that are 'missing' so it seems its getting a miss connection somewhere. The initial cmd prompt (win32 -standard cmd prompt) Says something about a missing string in MariaDB or something,It just fades so fast its hard to get a copy before it poofs. So it appears,to my very very limited knowledge,to be a syncing issue or something of the sort.

Maybe you should try repairing the tables before going for a restore.

Issues getting worse,wont even let me source my latest backups,going to attempt to recover atleast a piece of the server will see what happens lol.

Did you run a repair on all the tables? I've found that often when the server can't "find" a table and it shows in other places as being there, it is broken and the server just can't get to it until it is repaired. That's why I suggested it above.

Got a ton of errors,says it wont allow command access.

Reran from different account now getting a few errors,stuff saying curropt or doesnt exist in engine,missing string,etc. Most files look fine though

Code:

SQL Error (1030): Got error 190 "Incompatible key or row definition between the MariaDB .frm file and the information in the storage engine. You have to dump an" from storage engine MyISAM

Code:

SQL Error (1932): Table 'peq.player_corpses' doesn't exist in engine

Seems those are the problems. Wont let me repair them either.