When I get home and get some time, I'll go through all your topics and see if I can help you. Don't spend too much time debugging your challenges, just tell me your issues and I'll help resolve them if I can replicate them. :)

E.g. I didn't test buffs if they dropped during zone. If I can repeat it, no reason for you to debug it. If I can't repeat it, it may be isolated on the steps. :)

Here's my list:

• Every time I create a new character my client crashes and I have to login again to choose the character. I am using SOF. <-- I use UF, I have titanium and SOF, I'll test and see if I can repeat your challenge with my instance.
• "Check your utils/sql/git/required/ for any missing updates, yours sounds like this:"
  That might be the problem... I don't have a /source/utils/sql/git folder at all... I have an svn folder... Yep, the instructions is using svn copy. (This was based on the original debian one). I'll look into this more, and see which is newer/preferred (#1 Issue I have is there's a lot of deprecated code available online that isn't kept up to date)
• <host>eqemulator.net</host><port>5998</port> <-- should login.eqemulator.net for UF, I'll verify for SoF

I think I missed some topics, I'll review the comments when I get home. :)

It sounds like you're using old source with new DB, which will cause issues

@demonstar:
I was following
http://wiki.eqemulator.org/p?EQEmu_on_Debian_6_VM

For my new wiki, here:
http://wiki.eqemulator.org/p?EQEmu_o...n_7_Virtualbox

specifically,
$ svn co http://projecteqemu.googlecode.com/svn/ eqemu
$ svn co http://eqemu-maps.googlecode.com/svn/trunk/ maps

Looks like : https://code.google.com/p/projecteqemu/source/list is feb 17th 2013

Hmm, I need to change it to this I think: https://github.com/EQEmu/Server/

Right?

Yeah were on Git now, definitely not SVN.

That's a problem.

Yep, I'm writing revisions to the instructions. Give me a bit, hayward, i'm going to compile and do some testing.
To give an idea of what i'm adding:
<li>$ sudo apt-get install git </li>
<li>$ rm -rf ~/source/*</li>
<li>$ rm -rf ~/eqemu/</li>
<li>$ git clone git://github.com/EQEmu/Server.git eqemu</li>
<li>$ cd ~/eqemu/</li>
<li>sudo apt-get install libboost-dev</li>
<li>sudo apt-get install liblua5.1-dev</li>
<li>cmake .</li>
<li>make</li>


But I'm not 100% sure libboost-dev and liblua5.1-dev, they seem to make cmake happy.
libboost1.49-dev libicu48 <-- installed as default on deb7

If any dev wants to confirm that, it'd be neat. Trying to keep my process simple enough.

on underfoot, confirmed buffs stay after zoning.. I'll revise the instructions, and give a specific instruction for you hayward based on where you are right now.

I went through the wiki and did remedies to try to clean this up. I'm going to probably do another from-scratch to ensure I didn't miss any steps. And also make a new VM that has the maps stripped out, it'd be real small for akkadius. (Make a simple shell srcipt to get the maps later, since maps is 3.9 of the 5 gig image).

Looks like image is 1 gig. Let me see about tweaking the size.. Doing some final testing with my new steps, too, ensuring no other bugs.

http://bpaste.net/show/172372/ those are the notes I took last time I did a debian install (some of it is probably a bit out of date?)

As soon as the wiki is where you want it I will also run another bare metal install to see if we have it all worked out. The wiki is simple to follow so the only real time constraints are the downloads. I cloned my server at the point before adding anything directly emulator based as well, so I can always start there on a rebuild.

This is why I love this community! Last night my wife asked why I was still messing with my server when I can just play on another... I told her it's because I am trying to help where I can, I love it, and these guys are talented and amazing to work with!

Buffs are no longer dropping when I zone :) And the emulator is running much faster! Even the loading and zone times are drastically reduced!

...And I don't have any npc's :) It's so peaceful... I didn't even notice until track had no results. Going to restart the DB server and then just go from there all the way to a re-source.

I'm throwing in the towel for tonight. I just completed two complete database sources both times from new and separate downloads, and I simply don't have any npc's... I think maybe I have been at this for too long now. I have never had this problem before.

This is going to require a complete restart and I am just not feeling invested tonight.

Once again, this is a database related issue.

Did you do a database source from ProjectEQ's dump?

You're missing a SQL source that adds or changes a column in the npc_types table.

Are you also running the latest binaries from Git and not SVN ?

Yeah this was all correct as far as source and sql goes. I know it's db related, but I don't know where... Maybe now that I have the right db I should look for updates? Not one to walk away, I am going to spend a nit more time on it tonight :)

Well you should see what it barks about in the zone logs, it will specifically spit out the MySQL error.

Sure enough!

line after line of this...

Looks like my problem lies in the required updates in the git folder. I found this one that seems to be just what I need :)

== 07/10/2014 ==
Kayen: Updated table npc_spells to now support defensive and ranged procs.
Note: Proc rate modifier work as it does for spell effects (ie 200 = 200% baseline chance modifier)
Table is also now contains 12 AI spell casting variables that can be set to fine tune casting behaviors per spell set.
Global default rules have also been added that can further fine tune all content if no specific variables are set.

Descriptions of new AI casting fields in npc_spells
'fail_recast' AI spell recast time(MS) when an spell is cast but fails (ie stunned)
'engaged_no_sp_recast_min' AI spell recast time(MS) checked when no spell is cast while engaged in combat. (min time in random)
'engaged_no_sp_recast_max' AI spell recast time(MS) checked when no spell is cast while engaged in combat. (max time in random)
'engaged_b_self_chance' Chance during first AI Cast check to do a beneficial spell on self (ie check to heal self)
'engaged_b_other_chance' Chance during second AI Cast check to do a beneficial spell on others.(ie check to heal others)
'engaged_d_chance' 'Chance during third AI Cast check to do a determental spell on others (ie check to nuke others)
'pursue_no_sp_recast_min' AI spell recast time(MS) checked when no spell is cast while chasing target. (min time in random)
'pursue_no_sp_recast_max' AI spell recast time(MS) checked when no spell is cast while chasing target. (max time in random)
'pursue_d_chance' Chance while chasing target to cast a detrimental spell.
'idle_no_sp_recast_min' AI spell recast time(MS) checked when no spell is cast while idle. (min time in random)
'idle_no_sp_recast_max' AI spell recast time(MS) checked when no spell is cast while idle. (max time in random)
'idle_b_chance' Chance to cast a beneficial spell while idle (ie cast heal on self while out of combat).

Kayen: Updated table npc_types, adding field 'ranged_type' and 'ammo_idfile'
'ranged_type' Will set what skill / animation is used when NPC uses a ranged attacked (special ability 11)
'ammo_idfile' Will set what projectile graphic an NPC uses in a ranged attacked (special ability 11) Format IT#### (same as item 'idfile')
(*Set to IT11118 for some fun*)
Added parameters: SPECATK_RANGED_ATK = 11
Param0: Min Ranged distance (default: 25)
Param1: Max Ranged distance (default: 250)
Param2: Percent Chance to Hit modifier
Param3: Percent Total Damage modifier

Kayen: Updated to Chance to Hit code with how bonuses are applied to be consistent for all effects.
Added field to npc_types 'Avoidance' which will modify chance to avoid melee
Added rules to set max and min chance to hit from melee/ranged (Default 95% / 5%)

Required SQL: utils/sql/git/required/2014_07_10_npc_spells.sql
Optional SQL: utils/sql/git/optional/2014_07_10_AICastingRules.sql

You found it! You're the worlds greatest detective!

http://www.youtube.com/watch?v=enOHraf3LEk#t=180

In all seriousness, that's what it is all about.

Once you source in the update that corresponds with it you should be good to go sir.

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.

I think the issue is that cavedude can't always update the server so the DB might be missing an update sometimes :P

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.

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

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

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.

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:
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

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

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.

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

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.

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:
and netstatus -vaun
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

Ignore-Solved

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.

That would be great.