EQEmulator Forums - OUTDATED:: HOWTO: Setup a server with EQEmu 5.X

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Tutorials::Needs work (https://www.eqemulator.org/forums/forumdisplay.php?f=631)

- - OUTDATED:: HOWTO: Setup a server with EQEmu 5.X (https://www.eqemulator.org/forums/showthread.php?t=10514)

ok so the binaries are where?

Quote:

Originally Posted by Ligghtning

ok so the binaries are where?

http://shawn319.eqemulator.net/cvs

ok extracted the binary to my eq folder and i still don't have any world.exe

ok so i finally found world.exe and now when i try to open it a cmd prompt window flashes and closes itself...any ideas or anything i missed?

Quote:

any ideas or anything i missed?

Other then the support forums and the search button?

This could be caused by a couple dozen issues, check out the support forms / search button. If you cant find your answer start a thread in the proper forum with all the steps you did and the issue you are having.

where did i go wrong

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.2
[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..

please disregard my above message as i have resolved that problem :D

It seems i am missing db.sql completely - its not in my mysql folder any ideas?

Quote:

It seems i am missing db.sql completely - its not in my mysql folder any ideas?

Which version of eqemu are you using? The 0.5.3 dr3 does not have a db.sql. You have to search around for an updated database source it in mysql using the command

Code:

use (XXX)*

source (YYY).sql

X = the name of your database and Y = the name of your .sql that you are sourcing. I'm sorry i do not know off the top of my head where you can get an updated database.sql.

It can be downloaded in the "EQEmu Release" folder in CVS on SourceForge. If you don't have a CVS client, use the CVS Repository and download via that.

Quote:

or is that an impossibility because running yer own server isn't that simple and you needa know what you're doing to keep one up?

That is fairly close, as it DOES take SOME know-how to set one up and maintain it.

ok heres a more constructive question,

where do i DL the latest eqemu server binaries?

i'm assuming this is the "db.sql" file talked about later in the tutorial

Server binaries, and DB files are two different animals. But one needs the other to fully function. You can get the latest binaries from a link on the homepage. http://www.eqemulator.net . It is 0.5.3, but it is a patch or two behind EQLive, so unless your client (read the game) is patched to before the patch on 2-10-04, then you wont be able to play on that version of the server... There is a newer server listed as 0.5.5 DR1, however, they are in source (no binaries) because it is NOT a release, and there is NO support for them whatsoever. So unless you know how to compile them, and can set it up by yourself, I would not recommend attempting the 0.5.5 DR1's for now..... Otherwise you will have to stick to playing on someone else's server till they are released....

Quick question..I got my server up and all that good stuff...but it's locked..If this was covered in another post plz let me know been trying to find something of that sort for about an hour now with no luck =/

btw...this is what I get: [Status] CURRENT_WORLD_VERSION:EQEMu 0.5.3-DR3
[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
You may already be a winner... of the darwin award.
TCP listening on: 192.168.2.2:9000
World server listening on: 192.168.2.2:9000
Connected to LoginServer: eqlogin1.eqemulator.net:5997

Quote:

[Error] Error: Could not load item data. But ignoring

Your database is NOT compatible for the version of EQEMu you are trying to run.. Look in the world building forum for links to the newest databases...

Re: HOWTO: Setup a server with EQEmu 5.X

Quote:

Originally Posted by Bearik

Step One: Before You Start

Once inside mysql type:

grant all privileges on *.* to username@localhost identified by 'password' with grant option;

Change underlined username and underlined password with the username/password you chose when you ran winmysqladmin for the first time.

http://home.comcast.net/~bearik/5.JPG

did as you said typed that but said error 1045: access denied to (my user name)@localhost identified by '(my password)' with grant option:
of coarse i didnt put parenthesis so what you think is wrong i did create my name and pass in that one program you said to run

and i did a search and nothing worked

I just recently got my server up, never really done anything with servers. Finally got bored and decided to make my own server. Haven't really found out how to look at my database itself heh, and haven't figured out how to edit items or anything lol. So, anyone who can help me with anything , that would be awesome :)

mysql> use eq;
Database changed
mysql> source db.sql;
ERROR:
Failed to open file 'db.sql', error: 2
mysql>

why dont you quit posting the same exact thing all over the freakin place and go read some responses to your other threads that are the same you stinkin genious......i dont know how the devs and admins do this...they have some serious patience and self control