Installing a server on Debian Linux (trying)

[Xelaan]

ok,

I loaded the Maps from the Debian Wiki into the Maps directory on my server.

I can bring my client up and see the Server listed on the eqemulator.net login server. (New Firiona Vie)

I have connected to it and created a character on my server. I checked the DB and everything created correctly.

I tried to logon to the server and I am getting a Zone not available error. When I looked in my logs I have an Error #1054 listed below. I think I am pretty close to operational. I am now pretty stuck though. This error is a bit beyond my ability to debug and work around. Any help is appreciated.

Error in instZOrgID query in database.cpp GetZoneName'SELECT instZOrgID FROM character_ WHERE instZflagNum=77' #1054: Unknown column 'instZOrgID' in 'field list'
Error in GetInstType query 'SELECT instZOrgID FROM character_ WHERE id=1' #1054: Unknown column 'instZOrgID' in 'field list'
Error in instZOrgID query in database.cpp GetZoneName'SELECT instZOrgID FROM character_ WHERE instZflagNum=77' #1054: Unknown column 'instZOrgID' in 'field list'

As listed above I downloaded and compiled everything today 5-19-2009 from the SVN. I also installed the DB from the SVN located at http://projecteqdb.googlecode.com/svn/trunk/

[leslamarch]

Make sure to use the updates in the update folder... I think the latest PEQ also is using the branch of the SVN

[Derision]

http://eqemulator.net/forums/showthr...ght=instzorgid

You could try to add the removed columns back to your DB

ALTER table character_ ADD column `instZflagNum` int(10) unsigned NOT NULL default '0';
ALTER table character_ ADD column `instZOrgID` int(11) NOT NULL default '0';

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

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