Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Linux Servers
Reload this Page Debian Wiki Updates/Tweaks

Support::Linux Servers Support forum for Linux EQEMu users.

Reply
Page 4 of 4 123 4
 
Thread Tools Display Modes
  #1  
Old 08-08-2014, 02:48 AM
Shin Noir's Avatar
Shin Noir
Legendary Member
  
Join Date: Apr 2002
Location: Seattle, WA
Posts: 506
Default
I think latest is giving no NPC's.

I debugged with this:
$ tail -f ~/server/logs/zone-dynamic_05.log
Error loading NPCs from database. Bad query: #1054: Unknown column 'npc_types.ammo_idfile' in 'field list'

peqbeta_2014-07-23-02-01.tar.gz inside peqbeta*.sql file line 37124:
Code:
CREATE TABLE `npc_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `lastname` varchar(32) DEFAULT NULL,
  `level` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `race` smallint(5) unsigned NOT NULL DEFAULT '0',
  `class` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `bodytype` int(11) DEFAULT NULL,
  `hp` int(11) NOT NULL DEFAULT '0',
  `mana` int(11) NOT NULL DEFAULT '0',
  `gender` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `texture` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `helmtexture` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `size` float NOT NULL DEFAULT '0',
  `hp_regen_rate` int(11) unsigned NOT NULL DEFAULT '0',
  `mana_regen_rate` int(11) unsigned NOT NULL DEFAULT '0',
  `loottable_id` int(11) unsigned NOT NULL DEFAULT '0',
  `merchant_id` int(11) unsigned NOT NULL DEFAULT '0',
  `alt_currency_id` int(11) unsigned NOT NULL DEFAULT '0',
  `npc_spells_id` int(11) unsigned NOT NULL DEFAULT '0',
  `npc_spells_effects_id` int(11) unsigned NOT NULL DEFAULT '0',
  `npc_faction_id` int(11) NOT NULL DEFAULT '0',
  `adventure_template_id` int(10) unsigned NOT NULL DEFAULT '0',
  `trap_template` int(10) unsigned DEFAULT '0',
  `mindmg` int(10) unsigned NOT NULL DEFAULT '0',
  `maxdmg` int(10) unsigned NOT NULL DEFAULT '0',
  `attack_count` smallint(6) NOT NULL DEFAULT '-1',
  `npcspecialattks` varchar(36) NOT NULL DEFAULT '',
  `special_abilities` text NOT NULL,
  `aggroradius` int(10) unsigned NOT NULL DEFAULT '0',
  `assistradius` int(10) unsigned NOT NULL DEFAULT '0',
  `face` int(10) unsigned NOT NULL DEFAULT '1',
  `luclin_hairstyle` int(10) unsigned NOT NULL DEFAULT '1',
  `luclin_haircolor` int(10) unsigned NOT NULL DEFAULT '1',
  `luclin_eyecolor` int(10) unsigned NOT NULL DEFAULT '1',
  `luclin_eyecolor2` int(10) unsigned NOT NULL DEFAULT '1',
  `luclin_beardcolor` int(10) unsigned NOT NULL DEFAULT '1',
  `luclin_beard` int(10) unsigned NOT NULL DEFAULT '0',
  `drakkin_heritage` int(10) NOT NULL DEFAULT '0',
  `drakkin_tattoo` int(10) NOT NULL DEFAULT '0',
  `drakkin_details` int(10) NOT NULL DEFAULT '0',
  `armortint_id` int(10) unsigned NOT NULL DEFAULT '0',
  `armortint_red` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `armortint_green` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `armortint_blue` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `d_meele_texture1` int(10) unsigned NOT NULL DEFAULT '0',
  `d_meele_texture2` int(10) unsigned NOT NULL DEFAULT '0',
  `prim_melee_type` tinyint(4) unsigned NOT NULL DEFAULT '28',
  `sec_melee_type` tinyint(4) unsigned NOT NULL DEFAULT '28',
  `runspeed` float NOT NULL DEFAULT '0',
  `MR` smallint(5) NOT NULL DEFAULT '0',
  `CR` smallint(5) NOT NULL DEFAULT '0',
  `DR` smallint(5) NOT NULL DEFAULT '0',
  `FR` smallint(5) NOT NULL DEFAULT '0',
  `PR` smallint(5) NOT NULL DEFAULT '0',
  `Corrup` smallint(5) NOT NULL DEFAULT '0',
  `PhR` smallint(5) unsigned NOT NULL DEFAULT '0',
  `see_invis` smallint(4) NOT NULL DEFAULT '0',
  `see_invis_undead` smallint(4) NOT NULL DEFAULT '0',
  `qglobal` int(2) unsigned NOT NULL DEFAULT '0',
  `AC` smallint(5) NOT NULL DEFAULT '0',
  `npc_aggro` tinyint(4) NOT NULL DEFAULT '0',
  `spawn_limit` tinyint(4) NOT NULL DEFAULT '0',
  `attack_speed` float NOT NULL DEFAULT '0',
  `findable` tinyint(4) NOT NULL DEFAULT '0',
  `STR` mediumint(8) unsigned NOT NULL DEFAULT '75',
  `STA` mediumint(8) unsigned NOT NULL DEFAULT '75',
  `DEX` mediumint(8) unsigned NOT NULL DEFAULT '75',
  `AGI` mediumint(8) unsigned NOT NULL DEFAULT '75',
  `_INT` mediumint(8) unsigned NOT NULL DEFAULT '80',
  `WIS` mediumint(8) unsigned NOT NULL DEFAULT '75',
  `CHA` mediumint(8) unsigned NOT NULL DEFAULT '75',
  `see_hide` tinyint(4) NOT NULL DEFAULT '0',
  `see_improved_hide` tinyint(4) NOT NULL DEFAULT '0',
  `trackable` tinyint(4) NOT NULL DEFAULT '1',
  `isbot` tinyint(4) NOT NULL DEFAULT '0',
  `exclude` tinyint(4) NOT NULL DEFAULT '1',
  `ATK` mediumint(9) NOT NULL DEFAULT '0',
  `Accuracy` mediumint(9) NOT NULL DEFAULT '0',
  `slow_mitigation` smallint(4) NOT NULL DEFAULT '0',
  `version` smallint(5) unsigned NOT NULL DEFAULT '0',
  `maxlevel` tinyint(3) NOT NULL DEFAULT '0',
  `scalerate` int(11) NOT NULL DEFAULT '100',
  `private_corpse` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `unique_spawn_by_name` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `underwater` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `isquest` tinyint(3) NOT NULL DEFAULT '0',
  `emoteid` int(10) unsigned NOT NULL DEFAULT '0',
  `spellscale` float NOT NULL DEFAULT '100',
  `healscale` float NOT NULL DEFAULT '100',
  `no_target_hotkey` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `armtexture` tinyint(2) NOT NULL DEFAULT '0',
  `bracertexture` tinyint(2) NOT NULL DEFAULT '0',
  `handtexture` tinyint(2) NOT NULL DEFAULT '0',
  `legtexture` tinyint(2) NOT NULL DEFAULT '0',
  `feettexture` tinyint(2) NOT NULL DEFAULT '0',
  `light` tinyint(2) NOT NULL DEFAULT '0',
  `walkspeed` tinyint(2) NOT NULL DEFAULT '0',
  `peqid` int(11) NOT NULL DEFAULT '0',
  `unique_` tinyint(2) NOT NULL DEFAULT '0',
  `fixed` tinyint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=999216 DEFAULT CHARSET=latin1 PACK_KEYS=0;
ALTER TABLE `eq`.`npc_types` ADD COLUMN `ammo_idfile` INT NULL DEFAULT 0 AFTER `fixed`;


then got Error loading NPCs from database. Bad query: #1054: Unknown column 'npc_types.ranged_type' in 'field list'

so,
ALTER TABLE `eq`.`npc_types` ADD COLUMN `ammo_idfile` INT NULL DEFAULT 0 AFTER `fixed`;

Error loading NPCs from database. Bad query: #1054: Unknown column 'npc_types.Avoidance' in 'field list'

ALTER TABLE `eq`.`npc_types` ADD COLUMN `Avoidance` INT NULL DEFAULT 0 AFTER `fixed`;


And, now we are in business.. NPC's load. Obviously, this is because peqbeta's SQL tables doesn't have all the fields that the latest EQEMU is expecting
__________________

~Shin Noir
DungeonEQ.com
Reply With Quote
  #2  
Old 08-08-2014, 07:18 AM
hayward6
Forum Guide
  
Join Date: Jul 2005
Posts: 473
Default
Quote:
Originally Posted by Shin Noir View Post
I think latest is giving no NPC's....
To get the NPC's back all I had to do was source the required sql code from the utils/sql/required folder. It was the ncp_types one... I think we discussed that a page or two back. This thread is getting long
__________________
Sayin Silverwolf
Server Op of The Sandbox (Non-Legit)
Reply With Quote
  #3  
Old 08-08-2014, 08:00 AM
hayward6
Forum Guide
  
Join Date: Jul 2005
Posts: 473
Default
I'm not 100% certain, but I don't think anyone is able to play on my server. I have a bunch of empty accounts, and the few characters that are created are all at the same location in tutorialb. I am going to try and hit it from outside today and see what I get.
__________________
Sayin Silverwolf
Server Op of The Sandbox (Non-Legit)
Reply With Quote
  #4  
Old 08-08-2014, 08:19 AM
hayward6
Forum Guide
  
Join Date: Jul 2005
Posts: 473
Default
Quote:
Originally Posted by hayward6 View Post
I'm not 100% certain, but I don't think anyone is able to play on my server. I have a bunch of empty accounts, and the few characters that are created are all at the same location in tutorialb. I am going to try and hit it from outside today and see what I get.
Yeah, server disconnect after character selection. I have tried to create a character, and login as an established character and both disconnect after a few seconds of waiting. I am going to check my port forwarding since this is not an issue on my network.
__________________
Sayin Silverwolf
Server Op of The Sandbox (Non-Legit)
Reply With Quote
  #5  
Old 08-08-2014, 08:56 AM
hayward6
Forum Guide
  
Join Date: Jul 2005
Posts: 473
Default
This is weird... It seems that my router does not forward port ranges... It has a place for it, but any range I put in does not work. Adding the entire server to the DMZ for now and I am up and running. This is not related to the wiki. Looks like I need a better router
__________________
Sayin Silverwolf
Server Op of The Sandbox (Non-Legit)
Reply With Quote
  #6  
Old 08-08-2014, 04:58 PM
Kingly_Krab
Administrator
  
Join Date: May 2013
Location: United States
Posts: 1,604
Default
I use a Netgear WNR2000v4 and it allows ranges and I have no problem with port-forwarding, here's a link to a similar version.
Reply With Quote
  #7  
Old 08-08-2014, 05:06 PM
Shin Noir's Avatar
Shin Noir
Legendary Member
  
Join Date: Apr 2002
Location: Seattle, WA
Posts: 506
Default
I'd maybe check:
Do you have DMZ set? Some times DMZ screws with port range.
Do you have a single port forwarded that the port range includes? Some times, port range can be lesser priority than a single port.

And yeah, let us know the router details, there's wizards online.

To debug your setup, seeing if ports are being listened to on your server:
$ netstat -vatn
Here's how mine looks:
Code:
tcp        0      0 0.0.0.0:9000            0.0.0.0:*               LISTEN
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:111             0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN
tcp        0      0 127.0.0.1:25            0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:44258           0.0.0.0:*               LISTEN
tcp        0      0 127.0.0.1:59337         127.0.0.1:3306          ESTABLISHED
tcp        0      0 10.0.0.111:22           10.0.0.105:52937        ESTABLISHED
tcp        0      0 127.0.0.1:3306          127.0.0.1:59343         ESTABLISHED
tcp        0      0 127.0.0.1:40090         127.0.0.1:9000          ESTABLISHED
tcp        0      0 127.0.0.1:3306          127.0.0.1:59339         ESTABLISHED
tcp        0      0 127.0.0.1:3306          127.0.0.1:59179         ESTABLISHED
tcp        0      0 127.0.0.1:59345         127.0.0.1:3306          ESTABLISHED
tcp        0      0 127.0.0.1:3306          127.0.0.1:59332         ESTABLISHED
tcp        0      0 127.0.0.1:40100         127.0.0.1:9000          ESTABLISHED
tcp        0      0 127.0.0.1:40086         127.0.0.1:9000          ESTABLISHED
tcp        0      0 127.0.0.1:3306          127.0.0.1:59345         ESTABLISHED
tcp        0      0 127.0.0.1:59339         127.0.0.1:3306          ESTABLISHED
tcp        0      0 127.0.0.1:9000          127.0.0.1:40100         ESTABLISHED
tcp        0      0 127.0.0.1:9000          127.0.0.1:40090         ESTABLISHED
tcp        0      0 127.0.0.1:40092         127.0.0.1:9000          ESTABLISHED
tcp        0      0 127.0.0.1:3306          127.0.0.1:59337         ESTABLISHED
tcp        0      0 127.0.0.1:59179         127.0.0.1:3306          ESTABLISHED
tcp        0      0 127.0.0.1:40096         127.0.0.1:9000          ESTABLISHED
tcp        0      0 127.0.0.1:59180         127.0.0.1:3306          ESTABLISHED
tcp        0      0 127.0.0.1:9000          127.0.0.1:40086         ESTABLISHED
tcp        0      0 127.0.0.1:40088         127.0.0.1:9000          ESTABLISHED
tcp        0      0 127.0.0.1:9000          127.0.0.1:40098         ESTABLISHED
tcp        0      0 127.0.0.1:3306          127.0.0.1:59347         ESTABLISHED
tcp        0      0 127.0.0.1:9000          127.0.0.1:40092         ESTABLISHED
tcp        0      0 127.0.0.1:59343         127.0.0.1:3306          ESTABLISHED
tcp        0      0 127.0.0.1:59332         127.0.0.1:3306          ESTABLISHED
tcp        0     96 10.0.0.111:22           10.0.0.105:54820        ESTABLISHED
tcp        0      0 127.0.0.1:3306          127.0.0.1:59180         ESTABLISHED
tcp        0      0 10.0.0.111:22           10.0.0.105:61247        ESTABLISHED
tcp        0      0 127.0.0.1:59347         127.0.0.1:3306          ESTABLISHED
tcp        0      0 127.0.0.1:9000          127.0.0.1:40088         ESTABLISHED
tcp        0      0 127.0.0.1:40098         127.0.0.1:9000          ESTABLISHED
tcp        0      0 10.0.0.111:50612        66.55.145.2:5998        ESTABLISHED
tcp        0      0 127.0.0.1:9000          127.0.0.1:40096         ESTABLISHED
tcp6       0      0 :::111                  :::*                    LISTEN
tcp6       0      0 :::80                   :::*                    LISTEN
tcp6       0      0 :::22                   :::*                    LISTEN
tcp6       0      0 ::1:25                  :::*                    LISTEN
tcp6       0      0 :::52100                :::*                    LISTEN
and netstatus -vaun
Code:
Proto Recv-Q Send-Q Local Address           Foreign Address         State
udp        0      0 0.0.0.0:9000            0.0.0.0:*
udp        0      0 0.0.0.0:7000            0.0.0.0:*
udp        0      0 0.0.0.0:7001            0.0.0.0:*
udp        0      0 0.0.0.0:7002            0.0.0.0:*
udp        0      0 0.0.0.0:7003            0.0.0.0:*
udp        0      0 0.0.0.0:7004            0.0.0.0:*
udp        0      0 0.0.0.0:974             0.0.0.0:*
udp        0      0 127.0.0.1:1006          0.0.0.0:*
udp        0      0 0.0.0.0:9675            0.0.0.0:*
udp        0      0 0.0.0.0:7778            0.0.0.0:*
udp        0      0 0.0.0.0:40812           0.0.0.0:*
udp        0      0 0.0.0.0:68              0.0.0.0:*
udp        0      0 0.0.0.0:111             0.0.0.0:*
udp6       0      0 :::974                  :::*
udp6       0      0 :::111                  :::*
udp6       0      0 :::32999                :::*
udp6       0      0 :::59675                :::*
This will let you know if other people can connect to a port that should be followed:
http://www.subnetonline.com/pages/ne...rt-scanner.php
__________________

~Shin Noir
DungeonEQ.com
Reply With Quote
  #8  
Old 08-28-2014, 05:48 AM
vsab's Avatar
vsab
Discordant
  
Join Date: Apr 2014
Location: United Kingdom
Posts: 276
Default
Ignore-Solved
Last edited by vsab; 08-28-2014 at 06:00 AM.. Reason: Solved
Reply With Quote
  #9  
Old 05-10-2015, 02:56 AM
Shin Noir's Avatar
Shin Noir
Legendary Member
  
Join Date: Apr 2002
Location: Seattle, WA
Posts: 506
Default
Sorry for this necro post, but I'm just noting that I'm planning to make an easier, all-platform solution for getting eqemu up. The new setup will take as little as 5 steps.
__________________

~Shin Noir
DungeonEQ.com
Reply With Quote
  #10  
Old 05-10-2015, 09:06 AM
Rikon's Avatar
Rikon
Sarnak
  
Join Date: May 2010
Location: US
Posts: 87
Default
That would be great.
Reply With Quote
Reply
Page 4 of 4 123 4

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

   

All times are GMT -4. The time now is 01:39 AM.

EQEmulator - Archive - Top

 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3