Trying to setup a new server; Having problems.

[nutbuckle]

I figure that a good way to get help from you guys is to paste start to finish then go over errors.

So where we go...

eqemu@cree eqemu $ cvs -d:pserver:anonymous@cvs.sourceforge.net:/cvsroot/eqemu login
Logging in to :pserver:anonymous@cvs.sourceforge.net:2401/cvsroot/eqemu
CVS password:
eqemu@cree eqemu $


eqemu@cree eqemu $ cvs -d:pserver:anonymous@cvs.sourceforge.net:/cvsroot/eqemu -z3 co eqemu
cvs server: Updating eqemu
cvs server: Updating eqemu/EQEMu Release
U eqemu/EQEMu Release/.MySCMServerInfo
U eqemu/EQEMu Release/Boot5zones.bat
U eqemu/EQEMu Release/DoorUpdate.sql
U eqemu/EQEMu Release/EQUI_GUIDE.xml
...
U eqemu/NewSource/zone/zonedbasync.h
U eqemu/NewSource/zone/zonedump.h
eqemu@cree eqemu $
eqemu@cree eqemu $ cd eqemu/NewSource/
eqemu@cree NewSource $ cd EMuShareMem/
eqemu@cree EMuShareMem $ make
eqemu@cree EMuShareMem $ cp libEMuShareMem.so /usr/local/lib/
eqemu@cree EMuShareMem $ cd ../world/
eqemu@cree world $ make
eqemu@cree world $ mkdir ~/bin
eqemu@cree world $ cp world ~/bin/
eqemu@cree world $ cd ../zone/
eqemu@cree world $ make
eqemu@cree world $ cp zone ~/bin/
eqemu@cree world $ cd ..
eqemu@cree eqemu $ cd EQEMu\ Release/
eqemu@cree eqemu $ mysql -u root -p
eqemu@cree eqemu $ mysql> create database eq;
eqemu@cree eqemu $ mysql> use eq;
eqemu@cree eqemu $ mysql> source db.sql;
eqemu@cree eqemu $ mysql> source pets.sql;
eqemu@cree eqemu $ mysql> source boats.sql;
eqemu@cree eqemu $ mysql> quit;
eqemu@cree EQEMu Release $ cp *.ini ~/bin/
eqemu@cree EQEMu Release $ cp *.bat ~/bin/

Ok, so That about sums it up...

Now I'll paste the INIs
*snip*
[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginport=5997
worldname=nutbuckles_test_server
worldaddress=cree.nutbuckle.net
locked=false
*snip*

*snip*
[Database]
host=localhost
user=root
password=xxxxx
database=eq
compression=off
*snip*


so, now I load world and get this:
Failed to open log file: logs/eqemu_world.log
[Status] Using database 'eq' at localhost
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.0
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] libEMuShareMem.so loaded
[Status] Loading items from database: count=0, max id=0
Failed to open log file: logs/eqemu_error_world.log
[Error] DBLoadItems query 'SELECT gmflag,minstatus,unknown002,unknown005,unknown107, unknown108,id,weight,norent,nodrop,size,itemclass, idfile,lore,slots,cost,name,icon,unknown105,bookty pe,filename,bagtype,bagslots,bagsize,bagwr,augslot 1type,augslot2type,augslot3type,augslot4type,augsl ot5type,unknown018,unknown019,unknown020,casttime2 ,unknown061,unknown067,unknown069,unknown070,unkno wn076,unknown077,augtype,unknown097,unknown098,unk nown099,astr,asta,aagi,adex,awis,aint,acha,pr,mr,d r,fr,cr,skillmodvalue,skillmodtype,banedmgamt,bane dmgbody,banedmgrace,magic,hasteproclvl,light,delay ,effecttype,range,damage,material,maxcharges,recle vel,recskill,charmfile,factionmod1,factionmod2,fac tionmod3,factionmod4,factionamt1,factionamt2,facti onamt3,factionamt4,reqlevel,hp,mana,ac,color,class es,races,spellid,casttime,focusid,itemtype,accurac y,avoidance,bardtype,bardvalue,combateffects,deity ,elemdmgamt,elemdmgtype,sellrate,shielding,spellsh ield,strikethrough,stunresist,tradeskills FROM items ORDER BY id', #1054: Unknown column 'casttime2' in 'field list'
Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems
[Error] Error: Could not load item data. But ignoring
[Status] LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading addon.ini..
[Status] Loading EQ time of day..
[Error] Could not load EQTime file ./eqtime.cfg
[Error] Unable to load ./eqtime.cfg
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Abort/retry/cancel?
TCP listening on: cree.nutbuckle.net:9000
World server listening on: cree.nutbuckle.net:9000
Connected to LoginServer: eqlogin1.eqemulator.net:5997


The first error is ok because I don't have a logs dir but from what I've seen and can grasp of this.
the database is missing casttime2, which is being called from stuff in common/. I've seen nothing in any of the .sqls to update the table.

Could anyone give me any ideas?


many many thanks.

[Chrysm]

I don't know what the deal is with this stuff either. I can source in all the .sql files that come with the archive and still get errors. I can source in just db.sql and get errors! The only database that I have used so far to not get errors like that when I load world is the moving npc databse. Granted, there is information missing still such as raw_header type stuff but, I only get those errors when I use the 3rd Party Tools.

Beware the moving databse! I have a fairly decent computer 2.0GHz 1GB SDRAM etc etc and using that even in one zone, bog my system down really bad.

ANyways, look for the posts in world building section about DW moving database update etc. I believe they have 11/13 is the post with the entire database and 11/16 is the update.

Another note. When you source these make sure the database eq has nothing in it. Don't even source db.sql just create database eq; the source DWnpc_blah.sql;

That's how I got mine going.

[Chrysm]

sorry I thought this stuff word wrapped automagically

[kathgar]

The items problem is because you don't have the itemsdump we collected. The release contains an old version of items on accident. Just grab the latest dump from sourceforge.

[nutbuckle]

That seems to fix the world, but now zone is doing this when started:

[Status] Starting Log: logs/eqemu_zone.log
[Status] Using database 'eq' at localhost
[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.0
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] libEMuShareMem.so loaded
[Status] Loading npcs
[Status] Loading NPCTypes from database...
[Status] Loading npc faction lists
[Status] Loading NPC Faction Lists from database...
[Status] Loading loot tables
[Status] Loading Loot tables from database...
[Status] Loading doors
[Status] Loading Doors from database...
[Status] FileLoadSPDat() Loading spells from spells_us.txt
[Debug] Starting Log: logs/eqemu_debug_zone.log
[Debug] FileLoadSPDat() Highest spell ID:4497
Illegal instruction


what did i do wrong?

[Chrysm]

Hmm...
I haven't encountered this one before.

Try this:
Download this and source it http://mwnpcmovdb.kicks-ass.net/MWnpcdb_050_default0_3.zip

Then source the update your should already have 050_item_object_update.sql

and if that still doesn't work, download the EQEmu source not the cvs...

If that fails, all I can say is sorry, you're SOL until you can post the debug information and have it answered.

[Chrysm]

PS - Delete the database eq before sourcing these two files and don't forget to ./world adduser eqemu eqemu 200