Installing a server on Debian Linux (trying)

[Xelaan]

I think it is getting close now. I ran the queries above and added those fields back into the character_ table.

My friend just tried to logon while I watched the logs, this is the log entries from the eqemu_debug_world.log

29921 [05.18. - 16:54:12] [WORLD__CLIENT] Connection 67.82.63.141 PASSED banned IPs check.  Processing connection.
29921 [05.18. - 16:54:12] [WORLD__CLIENT] Koloth: Logged in. Mode=(CharSel)
29921 [05.18. - 16:54:12] [WORLD__CLIENT] Koloth: LS Account #132210
29921 [05.18. - 16:54:21] [WORLD__CLIENT] NOCLE: Client disconnected (not active in process)
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: Name approval request.  Name=Sarus, race=Human, class=Monk
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: Character creation request from Koloth LS#132210 (67.82.63.141:59639) :
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: Name: Sarus
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: Race: 1  Class: 7  Gender: 0  Deity: 210  Start zone: 4
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: STR  STA  AGI  DEX  WIS  INT  CHA    Total
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth:  85   85   90   90   75   75   75     575
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: Face: 7  Eye colors: 3 3
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: Hairstyle: 1  Haircolor: 17
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: Beard: 255  Beardcolor: 255
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Validating char creation info...
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Found 0 errors in character creation request
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: Current location: (null)  -807.00, -239.00, -10.25
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: Bind location: (null)  -807.00, -239.00, -10.25
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: Character creation successful: Sarus
29921 [05.18. - 16:55:25] [WORLD__CLIENT_ERR] Koloth: Zone not found in database zone_id=189, moveing char to arena character:Sarus
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: Entering zone (null) (189)

It seems to be having trouble finding the zone still. At least it no longer had the 1054 error. But still cannot logon.

[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.

[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!