Need Some Help and Willing to Help others when I learn

[xeeman]

Hey guys and gals,

I finally decided to make my way over and setup an EMU after playing EQ for 3 years. FYI, I'm also the webmaster and do the "self installers" for the MySEQ Project (www.rexpage.com/myseq).

Anyway, I went through this tutorial and setup a server behind my router using DynDNS. I'm fwd'ing ports 5990 - 6000 and 9000-9100 to my server on my LAN. Those may be more than necessary but I didn't see a definitive post on the subject.

Thanks in advance,
Xeeman

Problems:
============
(1) I can see my server on the Server Select screen through EQ; however, when I try and create a character my world.exe crashes. I can post logs if necessary.

(2) After the setup do I need to populate the database with any other information? If so, where do I download this information?

(3) How do I manipulate characters? (ie create GM's etc)

[Derision]

This is the latest Tutorial from Jezebell for the latest code (5.5)

http://www.eqemulator.net/forums/viewtopic.php?t=13403

You need to post the output of your world.exe/zone.exe (boot5zones.bat) processes, and all your ini files, e.g. loginserver.ini, db.ini, boot5zones.bat, etc.

[Jezebell]

Make sure you have the newest binaries from the link above, that should fix your World.exe crashing.

The database is the worst part about running a server, its not hard but time consuming and you pretty much have to figure it out on your own. I recommend downloading MySQL-Front to edit the database.

You can set GM's through MySQL by command or MySQL-Front under the accounts table or in game with the #flag command, can also use flag on a command line by running world.exe.

[xeeman]

Here is the output as requested. I'm working on database population now.

As of today, I can see my server at the server select screen; however I get a 1017 error if I try to login. Any help is appreciated.

==============================
Boot5Zones.bat Process
==============================

[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.5
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
Error: EMuShareMem: DLLLoadItems: !ItemsMMF.IsLoaded() (timeout)
[Error] Loading items FAILED!
Failed. But ignoring error and going on...
[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
[Status] FileLoadSPDat() spells loaded: 5023
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] command_init(): Warning: Command 'help' defaulting to access level 0!
[Status] command_init(): Warning: Command 'version' defaulting to access level 0
!
[Status] command_init(): Warning: Command 'serversidename' defaulting to access
level 0!
[Status] command_init(): Warning: Command 'loc' defaulting to access level 0!
[Status] command_init(): Warning: Command 'flag' defaulting to access level 0!
[Status] command_init(): Warning: Command 'si' defaulting to access level 0!
[Status] 160 commands loaded
[Status] Entering sleep mode
Connected to worldserver: localhost:9000

==================================
World.exe Process
==================================
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.5
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=0, max id=0
[Error] DBLoadItems query 'SELECT gmflag,minstatus,unknown002,unknown005,unknown
107,unknown108,id,weight,norent,nodrop,size,itemcl ass,idfile,lore,slots,cost,nam
e,icon,unknown105,booktype,filename,bagtype,bagslo ts,bagsize,bagwr,augslot1type,
augslot2type,augslot3type,augslot4type,augslot5typ e,unknown018,unknown019,unknow
n020,casttime2,unknown061,unknown067,unknown069,un known070,unknown076,unknown077
,augtype,ldonpointtheme,ldonpointcost,unknown099,a str,asta,aagi,adex,awis,aint,a
cha,pr,mr,dr,fr,cr,skillmodvalue,skillmodtype,bane dmgamt,banedmgbody,banedmgrace
,magic,hasteproclvl,light,delay,effecttype,range,d amage,material,maxcharges,recl
evel,recskill,charmfile,factionmod1,factionmod2,fa ctionmod3,factionmod4,factiona
mt1,factionamt2,factionamt3,factionamt4,reqlevel,h p,mana,ac,color,classes,races,
spellid,casttime,focusid,itemtype,accuracy,avoidan ce,bardtype,bardvalue,combatef
fects,deity,elemdmgamt,elemdmgtype,sellrate,shield ing,spellshield,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
Please don't make me a levelme server. :(
TCP listening on: rexpage.homedns.org:9000
World server listening on: rexpage.homedns.org:9000
Connected to LoginServer: eqlogin2.eqemulator.net:5997
307873 New TCP connection: 127.0.0.1:1148
New zoneserver: #1 127.0.0.1:1148
Zoneserver SetConnectInfo: 127.0.0.1:1148: rexpage.homedns.org:7995

==================================
db.ini
==================================
# READ README.TXT!

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


### --- This file tells world.exe what computer mySQL is on. Host should
### --- be left "localhost" unless mysql is on a differant computer than world.exe.


==================================
Loginserver.ini
==================================
### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.

### --- Public Login is un-supported as is LAN playing. We recommend using the eqemulator.net Loginserver ALWAYS.

### --- NOTE: You can NOT use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automatically.

# READ README.TXT
[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginserver2=eqlogin2.eqemulator.net
loginserver3=eqlogin3.eqemulator.net
loginport=5997
loginport2=5997
loginport3=5997
worldname=XeeXEmuLive
worldaddress=rexpage.homedns.org
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

===========================================
Boot5Zones.bat
===========================================
REM: ****Read this first!!!****

REM: This file requires your real IP in the place of "YourIP" when you are connecting
REM: To the EQEmu Loginserver.

REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1

REM: If you still get errors try using localhost instead of 127.0.0.1

REM:--------------Start-----------------------
@echo off

if NOT exist spells_us.txt goto NOSPELL

start zone . rexpage.homedns.org 7995 localhost
start zone . rexpage.homedns.org localhost
start zone . rexpage.homedns.org localhost
start zone . rexpage.homedns.org localhost
start zone . rexpage.homedns.org localhost
exit
cls

:NOSPELL
echo You did not copy the spells_us.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE

REM:---------------END------------------------

[Monrezz]

Update your items database:

http://www.eqemulator.net/dumpeditems.sql.gz

[samandhi]

Until you get your DB sourced correctly, you will continue to get errors... :(

[xeeman]

Ok--thanks for the help everyone. After hours and hours of populating the database...hehehe....I'm almost ready.

I only have a few more questions and I'll be gtg.

(1) Eactly which ports need to be fwd'ed to the emu server?

I had 7990-7995 and 5999 fwd'ed but kept getting 1017 errors. I put my emu server as a DMZ and I'm now logged into Felwithe as a newbie!! WOOT!

(2) I'm going to search around but would someone be so kind as to point me towards how to make GM's, etc?

Again thanks for all the help and advice. As soon as I am more knowlegeable on the workings, I'll be glad to help out other newbies.

[Monrezz]

5997
5999
7995-8015 (depending on how many zone servers you run - they all require a unique port)
9000

2. #gm on (Need to have status, use #flag).

[xeeman]

Thanks Monrezz.

I'll setup those forwards now. I also downloaded the guide from www.eqemulator.net/guidebook and have started reading it. Nothing helps like actually reading the instructions.

Question:

(?) Does the initial server created act as a "test" server for connectivity, etc?

I was able to create a HIE Wizard and log into Felwithe but could not zone, etc.

[samandhi]

(?) Does the initial server created act as a "test" server for connectivity, etc?

I was able to create a HIE Wizard and log into Felwithe but could not zone, etc.

Now that you have logged in for the first time on your server, just click on start>run>type "cmd" (without the quotes), hit enter. Now, in the DOS command window type the following (hitting enter after each line):

cd c:\eqemu (assuming this is where you have world.exe, if not cd to where you put it).
world flag yourloginname 250

yourloginname is the account name you use to login to EQEMu servers. Now close the DOS command window and you now have server_op privileges...

This was all assuming that when you said:

I was able to create a HIE Wizard and log into Felwithe but could not zone, etc.

That you meant you could NOT use the #zone command and so-on..... Now that you have given yourself server_op status, you will have ALL commands... Just type #help in game to see the WHOLE list hehe... G'luck to you..

[Monrezz]

Make sure you have at least 2 zone servers running, too. :P

[xeeman]

That you meant you could NOT use the #zone command and so-on.....

Well I tried the "traditional" way of running through a zone line. Is that not possible in EQEmu?

I've printed out the EQEmu Server Guidebook v1.2 by Magick. I'll assume the information there with commands and such is still "current"?

Make sure you have at least 2 zone servers running, too.

I created the boot5zones.bat and used it. Is there another way to get the zones running?

[Monrezz]

What exactly happened? Did EQ crash, did you get disconnected, did world crash, did zone crash? Paste the output of world and zone servers, could help.

Yes, zoning normally is in EQEMu, otherwise we wouldn't be able to zone on legit servers

[xeeman]

I created a HIE Wiz which put me in Felwithe as my home city. When I tried to zone to GFay, I got a message that "...the zone was not ready to receive visitors.." I don't have it running atm the moment for the precise message, but that was it. It just kept me in Felwithe.

I also had a friend of mine login to the server. He tried to create a Berzerker but got an error that he needed the GoD expansion which he has. I then had him create a HIE to see if he could zone from Felwithe. We were able to see each in the zone fine, but he could not zone either.

I realize that it's something that I'm missing in setting this up so bear with me...

[Monrezz]

Which database are you using? You need to make sure you have the zone points and zone lines set up correctly, if you're wanting to create your own database I suggest you use the zone information from MyWorld - it is accurate and complete, should fix any issues you have.