Setting up local EQEMu Server v0.4.4-DR1
OK, this info. is pretty well covered in the EQEmu documentation, but since some people find certain writing styles easier to digest than others, I'll paste in below the step-by-step instructions I wrote up for myself & others for setting up a local server to host on a single computer. Bear in mind many of the steps included below reflect my own personal tastes (i.e. directory paths, database names, choice of database), since that is what I've found to give me the best results after much trial & error. So here goes:
Quote:
Remember to peruse the rest of these forums for a wealth of information on troubleshooting, updates, etc. I have found many handy tidbits buried in what would otherwise seem inconspicuous posts, so take a look around & use the search feature! :wink: EDIT: Merth Jul/28/2003 - Removed patcher instructions, as patcher is no longer used. |
Thank you
I bow before thee, oh siplicifier. My feeble brain could not grasp the simple intructions given to me, but your insiteful rewording has been somewhat of a godsend to someone such as me who was not blessed with brains.
Basically what I'm trying to say is, thanks for putting this into step-by-step instructions for big stupidheads like me. |
Thanks & a simple request
Thanks Galin Nytshade. :) I'm glad it has helped at least some people in solving their confusion/problems in getting this working. When I first came here, there was a lot to digest, & quickly felt overwhelmed by the complexity of it all. I tried reading all I could, but even still had questions when things went wrong. After getting no response to a few queries I'd made here on the boards & in IRC, I'd resolved to try & pass along what I'd learned to others who were probably every bit as confused as I was, once I'd gotten the hang of things.
I only ask that each person who this info. has helped please try to help at least one other person who comes here as lost as you once were, if you can. :) BTW, I'll be updating this info. (by editing the top post) as new information comes to light, including new databases, so don't be surprised if this info. has changed slightly if you come back to view it again. |
I appreciate the condensed version of the instructions. I finally got my lan server running with your help. Thanks! I only have one problem now, and I searched the forum and couldn't find any answers. Maybe I'm a total n00b and am failing at the obvious, but I can't get the in game commands to work. I have gm status, it says 200 by my name when I /who. But if I type--
/zone #zone /#zone !zone /!zone etc etc... nothing happens. I've tried about half of the commands, all from differnet levels and nada. I can't spawn anything. I can't summon items. I can't lvl myself. Do I need to type the commands in the dos window?? I tried and can't do that either while the game is running. Am I missing something simple, or is this just some weird bug? -y |
You might want to add what I posted on http://forums.eqemu.net/viewtopic.php?t=6969 to your guide, it helps a bit when it comes to setting it up on another comp.
- Xelnagan |
Nicely written.
|
ok I set up the minilogin and it works good no unexpected errors
but my problem lies inconnection to my minilogin I changed eqhost.txt to read [Registration Servers] { "24.102.211.196" } [Login Servers] { "24.102.211.196" } then tried to connect using eqemu patcher but it won't connect any and all help is welcome thank you |
Ok, I followed the walkthrough, but when i launch eqgame.exe patchme i login with a username and password that is different then what you gave (because i didnt use your user name), i login ok, but my server isnt in the list, infact the list is empty! Any suggestions? I am running win2000 server amd athlon xp 1500+ (1.33 ghz) i ran all of the servers you ran they all ran without error.
|
access denied
I followed all your steps..including the grant...and I am still getting that I am denied access to get into it...I am putting in the same user name and password that I put into mysql
|
Step 7. Download my original backup database from the attachment posted below (eqbackup00.zip) & install to the C:\MySQL\bin directory (overwrite = yes).
i cant find "eqbackup00.zip".. please give me a URL.. thisis driving me mad :P |
When the forums, Website, etc. went down this past week, all attachments to forum posts were temporarily made unavailable too, apparently. Now that things are back to normal, it looks like the attachments are back up, so you should again find the link to the database above. :)
|
enough is enough already... 1045 error is getting old...
OKAY!!! HERE GOES!!!
I've been working on getting this mess to work for days now. Currently i'm able to actually get onto the og in server and stuff, and i can even get all the way to the server select screen for eqemu but of course there's no servers up (at the moment i'm try to set up a server to be played from the same PC as described in your wonderful layout above.). NOW, i know it's because my "world.exe" isn't working right! I ALWAYS get this lame little: "Failed to connect to database: Error: #1045: Access denied for user 'sirpez@localhost' (Using password: YES) .... etc. etc....." SO, can't load up that sucker, let alone get the "world.exe flag eqemu 200" mess to stick. I've played around with just about every version of the "GRANT ALL PRIVILEGES..." commands i could find across these forums, and while it seems like they all get accepted by the 'mysql.exe' command thingy, i still get he same error over and over. FOR THE LUV OF GAWD SOME HELP ME I"M GIONG MAD!!! kk now for the various stuffz ya need for troubleshoots: -Using windows ME... -Using EQEmu version 0.4.4 DR1 with telmet blah blah... (the bin file thingy delvore has u download from his tutorials link up top there.) -Using the 'eqbackup00.zip' thing as my sourced sql for the db... (the one delvore provides up top under his sig.) ~~~EQEmu modified configs~~~ <<<<<Database.ini thingy:>>>>>>>>>>> [Database] host=localhost user=<mysqlusername> password=<mysqlpassword> database=eq compression=off <<<<<<LoginServer.ini thingy:>>>>>>>>>>>>> [LoginServer] loginserver=localhost loginserver2=localhost loginport=5999 loginport2=5999 worldname=Pez World worldaddress=localhost locked=false account= password= [WorldServer] Defaultstatus= Unavailzone= [LoginConfig] ServerMode=Standalone ServerPort=5999 UplinkAddress= UplinkPort= UplinkAccount= UplinkPassword= <<<<<<<<<MinyLogAccount s thingy>>>>>>>>>>>> localhost eqemu eqemu <<<<<<<<< Boot5zones thingy >>>>>>>>>>> (and i've alreayd copied the spell_en thing to the EQEmu dir too...) start zone . localhost 7995 localhost start zone . localhost 7996 localhost REM: start zone . localhost 7997 localhost REM: start zone . localhost 7998 localhost REM: start zone . localhost 7999 localhost exit cls <<<<<<<<< eqhost text file>>>>>>>>>>>> [Registration Servers] { "localhost:5999" } [Login Servers] { "localhost:5999" } <<<<<<<<< datarate text file >>>>>>>>>>> 10.0 __________________________________________________ ___ If ya need anything else yell at me an i'll toss it up here asap -- this mess is ridiculous!!! |
Finding the sweet spot
Well, your config files appear to be in order. First off, are you making sure to have the MySQL Admin Tool running in the system tray at all times? This isn't always necessary for everyone (I myself don't need to), but for some users it is.
While I know you said you played around with various GRANT ALL permutations, I have to ask if you tried what I included above: Quote:
If not (& you're sure of this), then I'd suggest doing something I had to do once to set things aright when I was having trouble. First shut down MySQL completely (this means to shut down the service through the right-click contect menu in the MySQL Admin tool usually running in the tray icon, then shut the tool itself down). Next, go into your ...\WINDOWS\ directory & hunt down that little my.ini file & delete it. Also look for a my.cnf file in your root C:\ directory & delete it too if present. Reboot, then enter in your user name & password again (exactly as typed in your db.ini file, making sure no trailing spaces, etc. are present in either). Try logging in again & see if this helps. If not, since I don't know what characters you're using in your MySQL user name & password, try changing them both to something simple involving only basic alphanumeric characters (no extended characters like _ or what have you) if you haven't already. Also try to limit them to 8 characters maximum in length each. I don't know if this is necessary, but these would be the very steps I'd be taking in trying to track down the source of the problem, via process of elimination. Last, but not least, did you try this: Quote:
I do know though that the steps I detailed above have worked not just for me, but many others as well, so there has to be something unusual in your setup, whether it be a simple typo, firewall or other conflicting network hardware/software, etc. It's just a matter of finding out what that something is & correcting it, if possible. |
"WHEN GOD WHEN!!? WHEN'S GUNNA BE MY CHANCE TO SEE THE SAILBOAT!!? WHAT THE HELLS WRONG WITH ME!?!"...
__________________________________________________ ___ anyways -- NEWS NEWS! kk so like i officially have access now and i think it was like dead space in the "db.ini" in the grand end of things. so HURRAH!!! -- world at least attempts to work for me now and i got my GM flag but (and isn't there always a 'but'...) i got a new error heheheh. Actually it' probably one i have been having i just hadn't noticed it yet way down there at the bottom of the "access died" read out. This is the complete read out i get when i try and to run the 'world.exe' : (also note the only thing i changed to the configs i have posted above is all instances of 'localhost' are now 127.0.0.1's and i guess i correctly entered the db info's with no dead space... on with the show) C:\Eqemu>world.exe Using database 'eq' at localhost [Status] CURRENT_WORLD_VERSION: EQEMu 0.4.4-DR1 [Error] CURRENT_WORLD_VERSION: EQEMu 0.4.4-DR1 Loading Variables, zone names & items... LoadEMuShareMemDLL::Load() failed error=120 Error: Could not load item data __________________________________________________ ___ Now i haven't scoured the boards for info about this little guy yet so i'll go do that -- heeh but i thought i should throw a progress report -- SOOOOO glad taht stupid access denied crap'o'la is over!!! |
having a little trouble
i am at the point where i start to write the mysql code and keep getting an error 1064 message after typing in ...
mysql.exe -f create database eq; anyone have any ideas why this might be happening |
try typing in
mysql.exe --user=root eq instead of mysql.exe -f ok soulchild? :) _______________________ my problem is that when i log into my minilogin setup, my server is not shown. any ideas on what may be wrong would be greatly appreciated. i have gone over a few readme files and how to's and they say that all my configuration files are up to par.. so im at a loss. |
access denied
I tried everything you said to do as far as the grant...and I deleted my ini file and rebooted etc...I am still getting the access denied error when I run world.exe flag eqemu 200...any ideas on how to fix this?
|
world.exe flag......
Step 16. Open command prompt in the C:\Games\EQEmu\ directory & type: world.exe flag eqemu 200
I get [Database] block not found in db.ini. Read Readme.txt... I ran the patch and everthing . I started the emu and i log in fine but there are no worlds there to choice from help please |
i have determined that there is a problem with my EMuShareMem.dll
the one i have is 277 kb does anyone know of an updated version i could download? i have not been able to find one as of yet. |
Ya, seems emushare.dll is the wrong one for 4.4
|
Ok i followed this guide step by step and im geting an error when i try and run the boot5zones file..this is what iv got
DB.ini [Database] host=localhost user=shaggy password=damnhell database=eq compression=off LogInServer.ini [LoginServer] loginserver=localhost loginserver2=localhost loginport=5999 loginport2=5999 worldname=MyWorld worldaddress=localhost locked=false account= password= [WorldServer] Defaultstatus= Unavailzone= [LoginConfig] ServerMode=Standalone ServerPort=5999 UplinkAddress= UplinkPort= UplinkAccount= UplinkPassword= MiniLoginAccounts.ini localhost eqemu eqemu Boot5Zones.bat @echo off if NOT exist spells_en.txt goto NOSPELL start zoneNT . localhost 7995 localhost start zoneNT . localhost 7996 localhost start zoneNT . localhost 7997 localhost start zoneNT . localhost 7998 localhost start zoneNT . localhost 7999 localhost exit cls :NOSPELL echo You did not copy the spells_en.txt from your everquest directory to this one. Please do so or zones will crash on startup. PAUSE And this is what im geting MiniLogin Msg LoginServer.ini read. MiniLoginAccounts.ini read. Server mode: Standalone Login server listening on port:5999 World Msg Using database 'eq' at localhost [Status] CURRENT_WORLD_VERSION:EQEMu 0.4.4-DR1 [Error] CURRENT_WORLD_VERSION:EQEMu 0.4.4-DR1 Loading Variables, zone names & items... EMuShareMem.dll loaded. Loading items from database... ...done. LoginServer.ini read. Loading guild ranks...done. Loading EQ time of day..."./eqtime.cfg" is NOT a vaild EQTime file. File version is 0; EQTime version is 1000 - failed. Deleted 0 stale player corpses from database. Deleted -1 stale player backups from database. Please don't make me a levelme server. :( TCP listening on: localhost:9000 World server listening on: localhost:9000 Connected to LoginServer: localhost:5999 Boot5Zones Msg....this is where i get the error that shuts it down C:\EqEmu>REM: ****Read this first!!!**** C:\EqEmu>REM: This file requires your real IP in the place of "hosthere" when yo u are connecting C:\EqEmu>REM: To the EQEmu Loginserver. C:\EqEmu>REM: When you are using minilogin, Replace all IP Addresses to say 127. 0.0.1 C:\EqEmu>REM: If you still get errors try using localhost instead of 127.0.0.1 C:\EqEmu>REM:--------------Start----------------------- The system cannot find the file zoneNT. The system cannot find the file zoneNT. and at this point i get this error msg...... Cannot find the file 'zoneNT' (or one of its components). Make sure the path and filename are correct and that all required libraries are available i click the ok button and it closes the Boot5Zones window Not sure what iv done wrong but i reread this thread a few times and tryed to reinstall and redo everything and i just cant get it to work, can anyone plz give me a hand at this? Yes i did run the 3 programs in the order that was given |
Pretty colors
|
try just start zone . localhost etc...
I put the NT in there at first to and it wouldn't work |
Not working for me
I follow all the instructions of the guide, and eventually got everything responding the way I would expect, however, after I do this:
C:\Games\EQEmu\EQGame\eqgame.exe patchme EQ front end runs, gets me to the login screen, I log in as eqemu/eqemu and get an EqEmu error : bad username/Pass. Any ideas? |
Godsend
This post 'truly' was a godsend.
Thanks. Off with a new error reading through search :P |
lordshaggy do you have MySQL up when you are trying to load everything up? If not that happened to me when I wasn't running MySQL and it worked when I ran it minimized.
|
I have my server up and running thanks to your guide, no problems there ;)
Lots of how to's for servers and the EQEmu clients but didn't see anything on LAN / WAN setups. Also, when my friends log into my server will there game use my database or do I have to update all of there databases anytime I make a change to mine? Only problem now is finding a fix for LAN / WAN with multiple accounts. Thanks for any help in advance :) Post for help can be found here. |
Cant Find it.
"Download my original backup database from the attachment posted below (eqbackup00.zip) & install to the C:\MySQL\bin directory (overwrite = yes). "
"(This database was built using Drawde's updated DB addon (worlddata1.1.beta5). For a brief explanation, or if you wish to download these files & build the database yourself, refer to his post here: http://forums.eqemu.net/viewtopic.php?t=6912&highlight=. My instructions to follow will assume you are using my eqbackup00 file. If you opt to utilize Drawde's quest files as well, you'll need to unzip the contents of his quests0.1.zip to your C:\Games\EQEmu\ directory, using folder names to extract). " Even when I go to this URL, I cant find the database you are talking about the "eqbackup00.zip" file. Please give me a URL. Thanks in advance. |
client disconnect
ok, followed everything as stated. it all works great right up until i select my created character and it starts loading then gives me a mixed reading of server not responding over the top of the error you have been disconnected. this always took me back to server select screen. any ideas? it would be greatly appreciated.
thanks |
me stoopid
:? ok, fixed that. for all those peeps out there haveing similar problems or other problems, the idea is to make sure everything....thats EVERYTHING........is correct. In this case for me, in boot5zones i had put in the localhost for IP but i didn't put it on both sides, I.E...it still said YourIP on the left side. Hence the aforementioned problem. It took a couple hours reading posts and scratching my head but i found it with the help of a somewhat unrelated post. Hope this helps anyone else who needs it.
:D |
WOW!! Thanks!!! This has been the most helpful post for idiot's such as myself. <--hehe just a joke there guys.
I got the server up and running with no problems following this guide. Well, I had a few minor setbacks, like MySQL still not letting me in, but I managed to work around it. I just had to thank you and everyone else who has put together these guides for us newbies. |
Thanks!!!!!!!!!!! :D :D
Works great now! |
how do u open command prompt in EQEmu folder?
|
i just want to say great job!!
i have completed all steps i cant flag the wrold.exe but not worry about that at the moment. i have logged in and have a server showing i can create a character but when i goto log in a iget the next picture just like you always do but after that i go back to server screen. any ideas on what might be causing this??? thanks in advance :lol: ok i figured my problem out!!!! ok not i cant zone it just kicks me back to the zone i was in and if i use #zone i get zone is not ready?? any ideas in advance?? |
What if you dont have ALL the expansions??
Just curious if this will still work in a modified manner, if I dont have all of the expansions. Let's just say I want to run it with the original game with no expansions, will this still work with the database suplied?
I did get it to work with the instructions given with expansions up to Shadows of Luclin, and a few more trips around the forums, to get the mysql commands right, just curious about not using all of my expansions, thats all. |
I used this to set up a server that appears on the list and it worked pretty well.
|
Re: Setting up local EQEMu Server v0.4.4-DR1
Im getting zoneboot5 errors every time for somr reason bad items or something?? can anyone help aim=samtheman677
email=sam_the_man67@yahoo.com |
Thanks a TON!
This guide worked nearly flawlessly. The only trouble was in your Grant Options. *.* would never work.
I changed to eq.* and started up fine. Just one more question remains. I posted at the following link, but perhaps you may be able to provide some insight better as I used your database. Thanks! http://forums.eqemu.net/viewtopic.php?t=8766 To all you people who can't get world.exe flag... to work. It won't until you get Grant Options to work as far as I can tell. Try "(databasename).*" instead of "*.*". In the case of this guide, mine was "eq.*" without the quotes. Thanks in advance Devlor! |
I wanted to post some usefull info.
I am close to getting my server working. Here are some problems and fixes that I have. I had problems with the access denied when trying grant privileges. One problem I noticed in the mYSQL startup info was that it said my.ini was missing. I searched my windows directory and found it./ I then pasted it into the c:\Mysql directory as well as c:\mysql\bin directory. It then was able to find the my.ini file in the startup info of mysql. So the usrname and password started working externally. I then noticed that when I dialed up I lost connectivity to MYSQL when running world.exe. I am running XP. First problem was the firewall which was running on a different network connection, but was nevertheless causing the disconnect from MYSQL. I ran a search on firewall in XP and fugured out how to turn it off on all network connections. Ohh also when connecting through dialup, all references to localhost stopped working. I changed them to 127.0.0.1 and they started working. this seems to be soem kind of DNS problem with my dialup-thats my best guess. Now world.exe runs fine and connects to the database. Boot5zones.bat comes up without error. Only problem I have now is that I cannot login to the server with the everquest gaem either through the local setup or the normal setup that connects to the eqemu servers. I shoudl have this nailed down pretty soon. I hope. /crosses fingers. I hope this was able to help anybody else out there. good luck |
When i go to start up world.exe i get the following message:
Failed to connect to database: Error: #1045: Access denied for user: 'MySQL_user@localhost' <using password: YES> [Status] CURRENT_WORLD_VERSION:EQEMu 0.4.4-DR1 [Error] CURRENT_WORLD_VERSION:EQEMu 0.4.4-DR1 Loading variables, zone names & items. . . Database Error: Lost connection, attempting to recover. . . . DB Query Error #2006: MySQL server has gone away Error in LoadVariables query 'SELECT varname, value, unix_timestamp<> FROM variables where unix_timestamp<ts> >= 0' #2006: MySQL server has gone away Database Error: Lost connection, attemption to recover. . . . DB Query Error #2006: MySQL server has gone away Error in LoadZoneNames query 'SELECT MAX<zoneidnumber> FROM zone' #2006: MySQL server has gone away EMushareMem.dll loaded. Database Error: Lost connection, attempting to recover. . . . DB Query Error #2006: MySQL server has gone away Error in GetItemsCount query 'SELECT MAX<id>, count<*> FROM items' #2006: MySQL server has gone away Error: Database::LoadItems<> <sharemem>: GetItemsCount<> returned -1 Error: Could not load item data ______________________________________ Any help would be nice on this plz. |
All times are GMT -4. The time now is 01:44 PM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.