Installing a server on Debian Linux (trying)

[Derision]

Looking back through the SQL changes, this looks like it may also be needed for the old instancing system:

ALTER TABLE `zone` ADD column `insttype` tinyint (1) zerofill unsigned NOT NULL default '0';

And:

INSERT INTO variables VALUES ('curInstFlagNum', 2000, 'Determines what instance flag will be handed out next', '2008-09-05 04:46:47');
INSERT INTO variables VALUES ('dfltInstZflag',1000, 'Used to determine if a zone is instanced, must be 1000 or greater', '2008-09-05 04:46:47');

[Xelaan]

That was already in the DB in the zone table. So I couldn't add it. It seems to be having trouble finding any zone. The zone tables are populated though, I can see the data.

[Xelaan]

The problem seems to be in the zones somehow.

30055 [05.18. - 17:12:35] [WORLD__CLIENT_ERR] Koloth: Zone not found in database zone_id=189, moveing char to arena character:Yunashen
30055 [05.18. - 17:12:35] [WORLD__CLIENT] Koloth: Attempting autobootup of (null) (189)

[Derision]

I edited my post to reflect a couple of variable table entries. If that doesn't work, I give up :(

[leslamarch]

if Derisions last edit does not work for you, the stock PEQ DB works just fine if you compile the branch instead of the trunk... Quick solution instead of tracking done all of the missed updates.

[Xelaan]

I have it working now. I added in Derisions SQL and then I loaded a different set of maps. I had used the maps listed in the wiki initially and just changed it out with the SVN http://code.google.com/p/eqemumaps/

Once I loaded the new maps everything started working, I assume either there was a missing map, or a corrupt map in the tarball listed in the wiki.

New Firiona Vie is now active on a dedicated Debian server and available through the eqemluator public login server. I am running an unmodified peq db (although I may make some minor changes as time progresses).

Thank you for all the help. I really appreciate the effort and I hope I will be able to provide some assistance back to others as I become more familiar with the system.

[KingMort]

This post should help out since we have just switched to Debian on a brand new dedicated.. Glad you got it figured out for the most part..

If I find any tips or help I will let you know..

King
www.raidaddicts.org

[WillowyLady]

Originally Posted by Derision

Looking back through the SQL changes, this looks like it may also be needed for the old instancing system:

ALTER TABLE `zone` ADD column `insttype` tinyint (1) zerofill unsigned NOT NULL default '0';

And:

INSERT INTO variables VALUES ('curInstFlagNum', 2000, 'Determines what instance flag will be handed out next', '2008-09-05 04:46:47');
INSERT INTO variables VALUES ('dfltInstZflag',1000, 'Used to determine if a zone is instanced, must be 1000 or greater', '2008-09-05 04:46:47');

Thanks Der, that cured the zone missing issue I had since updating to rev535.

Cheers.

Now that I know how to cure that one, will update binaries from SVN and hope it still works, if not at least can revert!