|
|
|
 |
|
|
 |
|
 |
 |
|
 |
 |
|
 |
|
| Support::Linux Servers Support forum for Linux EQEMu users. |
08-06-2014, 07:30 PM
|
 |
Legendary Member
|
|
Join Date: Apr 2002
Location: Seattle, WA
Posts: 506
|
|
Quote:
Originally Posted by hayward6
Success! I am going to have some fun now and see if there is anything else I missed.
This may sound dumb but I would add a line in the wiki about checking and running required updates. I had just assumed that the db was fully updated because it was a fresh download, but now I know different  I will continue to report any findings. |
No suggestions are dumb, my goal with my step by steps is to make it easy even as a non-linux guru. I'll probably hit this up when I get home late tonight. 
thanks for all your hard work hayward!
And thanks to all other developers with any tips they have about my build process. I took in your steps demonstar55 to ensure their implementation was included on mine. |
08-06-2014, 08:03 PM
|
 |
Administrator
|
|
Join Date: Feb 2009
Location: MN
Posts: 2,072
|
|
Yes, it is a serious goal to make getting a server setup easy and keep it easy. It is something I look to be addressing fairly soon here. So Shin's contribution to the Linux guide is amazing.
Thanks all
|
 |
|
 |
08-07-2014, 06:48 AM
|
|
Forum Guide
|
|
Join Date: Jul 2005
Posts: 473
|
|
So, now that internal things seem to be working properly. Here is a short list of the management issues I am having.
1. cannot access http to manage server. I have the 9080 port forwarded but it just doesn't seem to even acknowledge a listening application, so I never get to a login screen (I used to like this portal for a quick description of who is logged on and for the ability to lock and unlock the server remotely)
2. phpeditor is still messed up, but I just remembered that I never sourced in the new sql statement from the proper database.
3. everytime I zone I see a message in red about the chat channel being disconnected. This might be nothing, but I did see another thread that mentioned changing the address in the emu config from channel.eqemulator.net to the host address. I changed it to 127.0.0.1 and I haven't seen any change in that. Chat seems to be working fine though...
__________________
Sayin Silverwolf
Server Op of The Sandbox (Non-Legit)
|
 |
|
 |
|
|
|
08-07-2014, 04:42 PM
|
|
Legendary Member
|
|
Join Date: Apr 2002
Location: Seattle, WA
Posts: 506
|
|
1. I'm not familiar with the 9080 system, can you clarify this system? I wrote a preliminary instruction of setup on step 25 (Remote Web Management), it isn't binding the port properly however, maybe a dev can confirm it's setup? (Can't find it in windows setup instructions either).
2. Yeah, the phpeditor step in my instructions should get it working, I've been using it with the steps I noted.
3. ucs isn't started/configured with my setup, I can add that real quick.
I added step 24, which sets up Universal Chat Service (ucs). I didn't fully configure the general channels etc, but it at least starts up it appears.
When we get this all cleaned up and done, I'll rewrite that startup script you noted to include my config settings, and also how to auto start your server on server bootup, but waiting for all bugs to be found.
I'll also likely remake my videos once all instructions are done and solidified.
And I'm also planning to EXPLAIN each section soon, instead of just giving steps.
And lastly, I'll probably have a step talking about how to use iptables to increase security of what ports you're forwarding.
Let me know of any other issues, and if above helps you out.
|
|
|
|
|
|
|
08-08-2014, 02:48 AM
|
|
Legendary Member
|
|
Join Date: Apr 2002
Location: Seattle, WA
Posts: 506
|
|
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 |
|
|
|
08-08-2014, 07:18 AM
|
|
Forum Guide
|
|
Join Date: Jul 2005
Posts: 473
|
|
Quote:
Originally Posted by Shin Noir
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)
|
08-08-2014, 08:00 AM
|
|
Forum Guide
|
|
Join Date: Jul 2005
Posts: 473
|
|
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)
|
08-08-2014, 08:19 AM
|
|
Forum Guide
|
|
Join Date: Jul 2005
Posts: 473
|
|
Quote:
Originally Posted by hayward6
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)
|
08-08-2014, 08:56 AM
|
|
Forum Guide
|
|
Join Date: Jul 2005
Posts: 473
|
|
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)
|
08-08-2014, 04:58 PM
|
|
Administrator
|
|
Join Date: May 2013
Location: United States
Posts: 1,604
|
|
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. |
|
|
|
08-08-2014, 05:06 PM
|
|
Legendary Member
|
|
Join Date: Apr 2002
Location: Seattle, WA
Posts: 506
|
|
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 |
|
|
|
08-28-2014, 05:48 AM
|
 |
Discordant
|
|
Join Date: Apr 2014
Location: United Kingdom
Posts: 276
|
|
Ignore-Solved
Last edited by vsab; 08-28-2014 at 06:00 AM..
Reason: Solved
|
05-10-2015, 02:56 AM
|
|
Legendary Member
|
|
Join Date: Apr 2002
Location: Seattle, WA
Posts: 506
|
|
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.
|
05-10-2015, 09:06 AM
|
 |
Sarnak
|
|
Join Date: May 2010
Location: US
Posts: 87
|
|
That would be great.
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 11:14 AM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |
~Shin Noir
Linear Mode
