HOWTO: Setup an EQEmu server as of 06/01/2004

[Jezebell]

This guide assumes you are using Microsoft Windows and have basic knowledge of computers and Windows and how to create batch/text files. Nothing I post here is supported, but I will try to answer any questions. I am not a programmer and my knowledge of the MySQL databases is very limited but I am learning as I go along. Just a fyi, DR stands for Developers Release, which means it is not official. You will need WinRAR (http://www.rarlabs.com) to open some of the files. If you have a router look here Router Guide (http://www.eqemulator.net/forums/viewtopic.php?t=1645), if you have a firewall it needs to be configured to allow access to the ports.

I highly recommend downloading MySQL-Front (http://www.mysql-front.com) to manage your database.

Other third-party programs I recommend for managing your database such as items, loot, merchants, factions, etc.

Sandy's Loot Editor 1.2 (http://www.projecteq.net/files/sandy/LootEditor-1.2.zip)

Mangoo's Item Editor 1.9.1 (http://emu.fliphost.net/files/ItemEditor191.zip)

capusr5's IEQ (http://www.reporter.gr/thanos/files/zara/ieq.zip)



FIRST STEP:

1. Download MySQL 4.0.18 (http://dev.mysql.com/get/Downloads/MySQL-4.0/mysql-4.0.18-win.zip/from/pick#mirrors) , after that install the downloaded file

2. click 5.7-DR3 (http://www.customchemicalservices.com/5.7dr3.zip)

3. click EQEMu 5.6 Config (https://sourceforge.net/project/showfiles.php?group_id=41381) and download EQEmu-0.5.6-Configuration.zip

4. Extract everything to C:\EQEmu

5. Download ProjectEQ.com Alpha 1 database (http://middleearth.eqemulator.net/downloads/MW_057DR2_alpha_1.zip)

Download
Govtcheeze loot updates (http://govtcheeze.eqemulator.net/download/v0.4_govtcheeze_loot.rar)

Extract them to C:\mysql\bin

SECOND STEP:

1. Browse to C:\mysql\bin and run winmysqladmin.exe, enter a username and password.

2. Right-click the desktop, go to New > Text file, name it MySQL.bat, edit it to include this and then save it.

cd\mysql\bin
mysql -b -u root mysql

anytime you need to enter something in the MySQL command line just run MySQL.bat.

3. Run MySQL.bat and type:

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

(replace username/password with your winmysqladmin username//password)

Press Enter....type:

create database eq;

Press Enter....type:

use eq;

Press Enter....type:

source MW_057DR2_alpha_1.sql;

Press Enter.

Lots of stuff should fly by with no errors. Type:

source loot_update.sql;

Press Enter.

Lots of stuff should fly by with no errors. Type:

source npc_types_update.sql;

Press Enter.

Lots of stuff should fly by with no errors. Type:

quit

Press Enter.


THIRD STEP:

1. Open db.ini and make sure it looks like this:

[Database]
host=127.0.0.1
user=YourMysqlUsername
password=YourMysqlPassword
database=eq
compression=off

2. Open LoginServer.ini and make sure it looks like this:

[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginserver2=eqlogin2.eqemulator.net
loginserver3=eqlogin3.eqemulator.net
loginport=5997
loginport=5997
loginport=5997
worldname=Yourservername
worldaddress=YourexternalIPAddress
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

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

[ChatChannelServer]
ChatChannelServer=YourInternalIPAddress

Make sure there are NO SPACES at the end of any of the lines!!

You can find your External IP by going to http://www.whatismyip.com and your Internal IP by running the command prompt and typing IPCONFIG

3. Edit boot5zones.bat and make sure it looks like this:

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 . YourExternalIP 7995 YourInternalIP
start zone . YourExternalIP 7996 YourInternalIP
start zone . YourExternalIP 7997 YourInternalIP
start zone . YourExternalIP 7998 YourInternalIP
start zone . YourExternalIP 7999 YourInternalIP
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

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

4. Copy spells_en.txt and spells_us.txt from your EverQuest directory to C:\EQEmu

5. Close Everything, Browse to C:\EQEmu and run World.exe, after it is done, run boot5zones.bat and you are ready to go.

[nilar]

The 0.5.5 binaries are down atm because Rex's website banwith was exceeded. I will get them up again soon.

[nilar]

Here is the site to download the 0.5.5 DR1 binaries from

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

update it on the guide :D

[RexChaos]

I've updated the link at my site to point to your main page Nilar.

[Maulgak]

This is great.. gonna try it out tomorrow.
look out for an all gm server><

p.s i'll be watching :!: :?: :!: :?:

[themushygod]

hmm i dont have debugworld.exe or zonedebug.exe just going to skip that step see if it works any reson it shouldnt?

[nilar]

Yes rofl, thats a very important step.

You need World.exe and Zone.exe

If you have Worlddebug.exe and zonedebug.exe rename them world and zone.

[themushygod]

no i already have world and zone.exe but it says delete them and rename zonedebug and worlddebug

i do not have zonedebug or world debug

im trying to run world.exe and getting this error



Runtime errors:

MySQL Error #1405 or #2001 means your mysql server rejected the username and password you presented it. For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id
=1



also there a whole lot of text before it if you wont



Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.5-DR1
[Status] Loading variables..
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 varia
bles where unix_timestamp(ts) >= 0' #2006: MySQL server has gone away
[Status] Loading zones..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #2006: MySQL s
erver has gone away
[Status] Loading items..
[Status] EMuShareMem 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 s
erver has gone away
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
[Error] Error: Could not load item data. But ignoring
[Error] [WorldServer] block not found in ./LoginServer.ini
[Status] Loading guild ranks..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadGuilds query 'SELECT id, eqid, name, leader, minstatus, rank0title,
rank1, rank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, ran
k5, rank5title from guilds' #2006: MySQL server has gone away
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player corpses from database
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player backups from database
Breaking bards...done
TCP listening on: 211.29.136.12:9000
World server listening on: 211.29.136.12:9000
===============================



any suggestions

im sure my un and password are the same i used with winmysqladmin


peace

[nilar]

Redo the grant all privileges command in mysql. I get this error when I dont enter that command correctly.

[nilar]

Also Worlddebug = World and Zonebug = Zone

The guide is just saying to rename them if the are named with debug after them.

[themushygod]

so the whole debug renaming thing doesnt matter as mine are already renamed cool

ill try re granting privliges

[themushygod]

ok ive re granted the privliges sevrel times now

still getting the same errors

im also trying to set up a server with minilogon but i get the same error

[hamg]

i got the [loginserver] block not found in "./loginserver.ini"
after i run the world.exe

[Jezebell]

thats because you have a space at the end of one of your lines in the LoginServer.ini file

[themushygod]

wow im impressed thanks for the fiX

IM getting an error bout incorrect servername now though but i think i might know what to do :)

[themushygod]

ok i found the error there server name was too short

but now i can logon see my server up but whe i goto connect i get
a #1017 error

i should add this is using minilogin.exe for a localhost


i found this lil piece in world.exe when i exit eq


New client from ip: 127.0.0.1 port: 1913 127.0.0.1: Wrong name/pass: name='eqemu' Removing client from ip:127.0.0.1 port:1913


im not sure where it got eqemu but it might be when i added this account


INSERT INTO account (id, name, charname, packencrypt, sharedplat, password, status, lsaccount_id, gmspeed, revoked) VALUES (1, 'eqemu', '', '', 0, 'eqemu', 250, NULL, 0, 0);


i then added a second copy of that with the login info i wanted


INSERT INTO account (id, name, charname, packencrypt, sharedplat, password, status, lsaccount_id, gmspeed, revoked) VALUES (2, 'MYLOGIN', '', '', 0, 'MYPASSWORD', 250, NULL, 0, 0);


ive tried logging in with both accoutns

im going to try get my server online (not minilogin) later tonight or tommorow

i know im asking alot of questions :)

peace mushy

[smogo]

you get eqemu in world.exe from your miniloginaccounts.ini

It does not match the pass you set in the accounts table. Check that first line of MiniloginAccounts.ini has your client's ip adress, then a space, then eqemu, then a space, then the pass, then a space before end of line.

i hope it's of some help.

[themushygod]

ok tried that but i still get the erorr about it saying loss of conectivity

[hamg]

i have the same problem too

[themushygod]

ok i fixxed the connectivity error (see a post about minilogin problems a couple threads down)

now i can get in create a character and logong where after loading the game runs and crashes almost immeaditly

anyone know why

btw im running p4 2.6 ghz 256mb of ram

peace

[darkshadows501]

where are the db.ini and zoneserverlogin.ini at??

[Jezebell]

db.ini is in the 0.5.2 zip files and there is no zoneserverlogin.ini, if you mean LoginServer.ini it is in the 0.5.2 zip also.

[darkshadows501]

If the loginserver.ini and db.ini dont look the same do we edit them so they look the same and where it says your IP address and Mysqlname or mysqlpassword do we put in our mysql name and password and IP address?? thx for the help with my small confusions :D

[nilar]

Check the guide lol. It explains everything there

[Jezebell]

If you can't figure this guide out then honestly you shouldn't try to run a server, take my advice.

[themushygod]

like i said mines going i just crash

nothing in the guide bout that

[darkshadows501]

I am getting this error also when I run world.exe and I have done what nilar said to do to re grant privaliges in mysql and its not doing anything



Runtime errors:

MySQL Error #1405 or #2001 means your mysql server rejected the username and password you presented it. For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id
=1



also there a whole lot of text before it if you wont



Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.5-DR1
[Status] Loading variables..
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 varia
bles where unix_timestamp(ts) >= 0' #2006: MySQL server has gone away
[Status] Loading zones..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #2006: MySQL s
erver has gone away
[Status] Loading items..
[Status] EMuShareMem 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 s
erver has gone away
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
[Error] Error: Could not load item data. But ignoring
[Error] [WorldServer] block not found in ./LoginServer.ini
[Status] Loading guild ranks..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadGuilds query 'SELECT id, eqid, name, leader, minstatus, rank0title,
rank1, rank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, ran
k5, rank5title from guilds' #2006: MySQL server has gone away
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player corpses from database
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player backups from database
Breaking bards...done
TCP listening on: 211.29.136.12:9000
World server listening on: 211.29.136.12:9000
===============================



any suggestions


peace[/quote]

[kerosh]

I keep getting the error spells_en.txt was not copied to directory when I start up zones5boot, and, I did copy and paste it from EQ, but it still wont work? Am I supposed to put it in to another folder other than the main EQEmu folder?

Been working on trying to get my server up for 3 days now and I am almost there =)

[nilar]

You need spells_us.txt too.

[coregamer10]

I have finished my server and its unlocked its on the server selaction screen but when I try to log on it I get the error 1017 I have used search and found a bunch of things but I none of them seemed to work. :cry: I am using a cable connection, windows XP (the firewall is truned off). Would it be better using windows 98 or a dialup connection or does that not matter. This 1017 error is really starting to &#$# me :x off and I am just out of ideas and don't know what to do anymore. Any help would be great. thanks :D


p.s. Jezebell this is a very good guide :D

[Longear]

Everything worked perfect when i made it! good help here! but i cant log on to it from EQemu:P i get a 1017.. any suggestions? Thanks for answers =)

[samandhi]

Well, to start with you will need to provide us with more information for us to be able to help you... Please post your loginserver.ini, load5zones.bat, eqhost.txt files, and past the output of your world.exe and zone.exe when you try and log on and get this error...

[Longear]

Well, i get no errors, so here is my Db.ini:
# READ README.TXT!

[Database]
host=localhost
user=YourMysqlUsername
password=YourMysqlPassword
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.
And the boot5zones:
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 . YourIP 7995 localhost
start zone . YourIP 7996 localhost
start zone . YourIP 7997 localhost
start zone . YourIP 7998 localhost
start zone . YourIP 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

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

and the last:
### --- 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
loginport=5997
worldname=Tommy
worldaddress=Your external IP Address here
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=
All is like that, only my ip.. but is localhost really 10.0.0.3?

[Longear]

Then i run EQemu as usual, and get the 1017..

[coregamer10]

This what you needen Samandhi

Loginserver


[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginserver2=eqlogin2.eqemulator.net
loginserver3=eqlogin3.eqemulator.net
loginport=5997
loginport=5997
loginport=5997
worldname=[Testing] Shadow
worldaddress=65.28.234.135
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

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

[ChatChannelServer]
ChatChannelServer=192.168.1.100

db
[Database]
host=127.0.0.1
user=darkshadows
password=shadow
database=eq
compression=off

Boot5Zones
start zone . 65.28.234.135 7995 192.168.1.100
start zone . 65.28.234.135 7996 192.168.1.100
start zone . 65.28.234.135 7997 192.168.1.100
start zone . 65.28.234.135 7998 192.168.1.100
start zone . 65.28.234.135 7999 192.168.1.100
exit
cls

World.exe
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.5-DR1
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=26679, max id=68199
[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] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Liberating a country that despises us...
TCP listening on: 65.28.234.135:9000
World server listening on: 65.28.234.135:9000
Connected to LoginServer: eqlogin2.eqemulator.net:5997

Zone.exe
[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.5-DR1
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading loot tables
[Status] Loading doors
[Status] FileLoadSPDat() Loading spells from ./spells_us.txt
[Status] FileLoadSPDat() spells loaded: 5002
[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] 157 commands loaded
[Status] Entering sleep mode
Connected to worldserver: 192.168.1.100:9000

Hope this is what you needed :D

[Jezebell]

There is nothing wrong with any of that coregamer10 that I can see.

[samandhi]

@coregamer10
There are a couple of things to change here that may or may not solve the issue, but will help things later down the road.. The first thing (and this is PROBABLY what is causing your 1017), make your server name longer... Also in DB.ini change it to localhost (that probalby wont matter, but just in case it seems to like localhost better than 127.0.0.1 on some machines, go figure).

Are you using a dynamic IP or static? Are you using a router that needs to be configured to forward the ports needed by EQEMu? Do you have a firewall that needs to be disabled? If you do NOT know the answers to all of those questions, try this: Change all instances where you put your IP to say localhost and or 127.0.0.1 and see if you can connect...(except your world address) This will ensure that the only thing you HAVE to make sure works (internet-wise) is your connection to the loginserver, the rest will be read directly from your machine without looping back... Try these things, if they dont work post back here, and we'll see what we cant do...

@Longear
You have this:
start zone . YourIP 7995 localhost
start zone . YourIP 7996 localhost
start zone . YourIP 7997 localhost
start zone . YourIP 7998 localhost
start zone . YourIP 7999 localhost
exit
cls Try putting in your internal IP where you have localhost (if you have a router), if not then try putting in your IP in both columns....
This is the meat and potatoes of your problem (probably) you have this:
# READ README.TXT
[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginport=5997
worldname=Tommy
worldaddress=Your external IP Address here
locked=false When you SHOULD have this:
[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginserver2=eqlogin2.eqemulator.net
loginserver3=eqlogin3.eqemulator.net
loginport=5997
loginport=5997
loginport=5997
worldname=Tommy
worldaddress=Your external IP Address here
locked=false
But, also note, your server name it probably too short also.. try using something like "Tommy The EQ Connection", or something like that just to test...

Also, the questions I asked earlier DO apply to you too. Such as, do you have a router? Do you use a dynamic IP and so on...

[Longear]

lol, now nothing works:P starting from scratch with your ini's :)

[Longear]

one fact!: i have mysql in C: and eqemu in h: . . doews taht make a diff?

[Longear]

Samadhi: i have a broadband, with routers, and windows firewall is not up. ill try the longer name thing, and the ip :)

[Longear]

hmm, now World.exe is dead, 2 lines come up and poof :/

[samandhi]

one fact!: i have mysql in C: and eqemu in h: . . doews taht make a diff? No, as long as your DB that you sourced in is in you \mysql\bin directory...

hmm, now World.exe is dead, 2 lines come up and poof :/
Sounds like you have pooched server files. Try re-downloading the files and redoing it.. Leave the DB unchanged as you dont need to mess with that... Starting from scratch may just be easier anyhow and see what happens (except the DB of course). Or you could open up a dos prompt and change to the directory that contains your world.exe and run it.. This way you can see what it says and it wont close... :)

Samadhi: i have a broadband, with routers, and windows firewall is not up. ill try the longer name thing, and the ip Make sure that you forward the ports needed for your connection to the loginserver (at least). You may also try forwarding your zone ports, so you can use your external IP... Is your broadband IP static or dynamic? If it is dynamic, then that is your problem... It will change either daily, or when you turn off and then back on your machine. You will have to use something like DynDNS, a website where you can assign a NAME to your IP address, even if it changes, that way you can use the same thing over and over no matter what your IP is (as long as it is through your ISP that you sign up the account with on DynDNS)....

[coregamer10]

I am using Windows XP, Cabile connection, yes I am using a router, the Firewall is disabled, and I have no clue what kind of IP I am usen just usen what it gave me when I clicked on whatsmyip link and what the cammand prompt gave me when I did the ipconfig. thanks a ton for the help samandhi :D

[Longear]

think ive fixed most now, but still 1017 error, i think the major fault is the boot.bat, they get an 10057 error when someone comes in.

[Longear]

no, that was when i shut down world:P but i have svreenshots of world.exe, and zone.exe, but cant upload :/

[waternorth]

http://unc.dl.sourceforge.net/sourceforge/eqemu/EQEmu-0.5.2-Win32.zip

Does not work :(

[waternorth]

Oops, ignore that... its only THIS one that dosen't work. http://mwnpcmovdb.myftp.org/MW055_alpha_02.zip

[azzwip]

FIRST STEP:

1. click http://www.mysql.com/get/Downloads/MySQL-4.0/mysql-4.0.18-win.zip/from/http://mysql.orst.edu/ to download MySQL, after that install the downloaded file

2. click http://unc.dl.sourceforge.net/sourceforge/eqemu/EQEmu-0.5.2-Win32.zip

and http://www.rama.demon.co.uk/5.5DR1VSNETBinaries.zip

My computer has determined that file directly above contains a virus.

whether this is in fact correct or not, my comp wont let off on the virus warnings that its spamming me with: virus name : win95/coke 22231

make of it what you will, i just downloaded the newest files from shawn319's cvs files rather than listening to my computer continue to complain about it.

[RexChaos]

And what virus does it contain? Please share your knowledge with everyone...

I scanned that file and found nothing.

[Jezebell]

If you are talkign about:

http://www.rama.demon.co.uk/5.5DR1VSNETBinaries.zip

As far as I know the version I have does not have a virus because I am running Norton Anti-Virus 2004 with the latest virus definitions, I will redownload it tonight to see if it has a virus now but I would say it is unlikely.

[RexChaos]

He's full of it. I'm totally updated as of 2 seconds before I downloaded that file and scanned it again. There's no virus. Nice way for him to start off his legacy here...first post and he's full of crap. :evil:

[nilar]

My computer has determined that file directly above contains a virus.

Rofl I think thats his signature guys :D

[Jezebell]

Then what the heck did he post for? lol

[nilar]

thats what i was trying to figure out

[RexChaos]

There's no line above it. Notice everyone else's sig has a line above it?

[nilar]

This is true. Well he is full of himself because I have Norton Antivirus 2004 edition and I have yet to run into a virus on any of these files.

[MrJag]

sometimes i think the worst virus is the person at the keyboard

[RexChaos]

I think this is a nice way to sum up the last few comments...

http://coughbullshitcough.com/modules.php?name=News&file=article&sid=17

[Angelishes]

I was trying to follow this tutorial and set this all up i got this far

2. Right-click the desktop, go to New > Text file, name it MySQL.bat, edit it to include this and then save it.

Code:
cd\mysql\bin
mysql -u root mysql


anytime you need to enter something in the MySQL command line just run MySQL.bat.

3. Run MySQL.bat and type:

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


(replace username/password with your winmysqladmin username//password)

Press Enter....type:

Code:
create database eq;


Press Enter....type:

Code:
use eq;


Press Enter....type:

Code:
source MW055_alpha_02.sql;


Lots of stuff should fly by with no errors. Type:

Code:
quit

I right clicked the desktop make the text file named it that wrote cd\mysql\bin
mysql -u root mysql that in it saved it and then ughh my nooberness kicked in and i just got confused it says to run the file and type all that stuff in and ugh maybe im missing somthing but i dont understand it how do u run a text file do i just type all that stuff in there or isnt it suppost to be a text file anymore.. help please lol

P.S. can somone explain to me the diffrence between External IP and Internal IP .. and a fast way to figure out what both are.. i have Windows 98 SE and run dsl on my computer which is hooked up to a router with 4 other computers..

[khaasta]

how do i do this... i dont get it ...
Edit boot5zones.bat and make sure it looks like this:

Code:
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 . YourExternalIP 7995 YourInternalIP
start zone . YourExternalIP 7996 YourInternalIP
start zone . YourExternalIP 7997 YourInternalIP
start zone . YourExternalIP 7998 YourInternalIP
start zone . YourExternalIP 7999 YourInternalIP
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

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

and um, this link doesnt work for me atleast... it is the second site that u have to click on, the.... http://unc.dl.sourceforge.net/sourceforge < not all of link, but that lnik doesnt work for me

[Jezebell]

Angel, it is a .bat file, not a .txt file, did you read the directions?

[DrizztBanrae]

I ran the world.exe and the boot5zones.bat both flew by and appeared to do nothing..not sure what to do now (learning as I go) appreciate any help =)

[thedark2004]

2. click http://unc.dl.sourceforge.net/sourceforge/eqemu/EQEmu-0.5.2-Win32.zip

does not seem to work...keeps dumping me back to a PerfectNav Web search page...anyone know how to get rid of this now that I mentioned it?

[nilar]

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

Look at my post at the bottom. It will tell you how to get those files.

[penguindude589]

can i do this but play my own server by myself without internet connection? if so how would i do this?

[Jezebell]

this way http://www.eqemulator.net/forums/viewtopic.php?t=12644

[blinkish]

ive done verything on the list good ... except at the end when i load boo5zones.bat ... it loads all the commands , it says 148 commands loaded ... then it says
"worldserver.connect<> FAILED!"
[Status] Entering Sleep Mode.

Would like it if someone could help out ... ty

[blinkish]

Ok i think i fixed it ...
I first opened up world.exe and it connected ... i minized it and opened up boot5zones and it connected to localhost successfully ...
dunno what to do now tho )

[Monrezz]

Read the guides... :)

[blinkish]

well obviously im posting on one guide ...
after the boot5zones.bat it doesnt tell u how to name server or anything unless i have misread it 5 times

[blinkish]

NM lol sorry i got it up :) but its 5.2 ...
Anyway i can update it to 5.5 ?

[Monrezz]

Update Binaries

[blinkish]

and where do i get binaries and how do i update them .. sorry new at this

[molimo140]

Download the 5.5 DR-1 Binaries:

http://www.rama.demon.co.uk/5.5DR1VSNETBinaries.zip

Unzip that to your EQEmu folder..shoud be something like C:\EQEmu

Click YES TO OVERWRITE FILES when a window pops up.

That should do it.

[Sims]

I did the tutorial and got my server running, but I want to edit items, but cant find the db can anyone help me please?

[Monrezz]

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

Download, extract, source.

[Olam]

i Type in source MW055_alpha_02.sql and it says

Failed to open file 'MW055_alpha_02.sql' , error : 2

wat should i do to fiz this i beleive i followed it all right....

[Olam]

^^^^^^^^^^^^^ disregard my last post i fixed it i extracted it wrong

Do these lines that are "alot" ever end??????

[Olam]

how long do these many lines go on for lol its been some time

[Loosenut]

Sorry nvm, skipped a step on accident, Delete me.

[Olam]

umm after it connects to worldserver nothing happens wat do i do????

[Loosenut]

Error #1017 , i tried everything i read on this thread and im still stumped

OK , i seemd to fix it, here is what i did for further reference.....

When i turned off my Firewall, my external isp was changed. Doing so i had to go back and get my new changed isp with no firewalls and redid the db.ini,loginserver.ini,and boot5zones.bat

[nilar]

Guys....dont ask for support at the end of a guide your not gonna get much help. Make your own topic.

[Loosenut]

what eq.sql?

Move eq.sql from C:\EQEmu to C:\mysql\bin

[Jezebell]

ehhhh, db.sql i meant, fixed that.

[Loosenut]

How long about will the errors keep going? cause i get 1136 like forever...

Code:
source MW055_alpha1.sql;


Press Enter.

You will probably get errors, just let it keep going, it will finish eventually. Type:

ERROR 1136: Column count doesn't match value count at row 1 X1000 and still going =P

[govtcheeze]

hm, things are a lot more different than I thought...this could take a while :(

[sephiroth]

Ok i scrolled through the posts and i don't think anyone has asked anything about this yet. Just to let you know i am somewhat new to eqemu. Anyway, i did all that was said here and started my server up. Server shows up in the list of servers but it is LOCKED. How do i get it unlocked pls anyone?

I am sure this is something small i have overlooked.

btw my 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=[test] ramuhs_server
worldaddress=68.1.210.103
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

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

[ChatChannelServer]
ChatChannelServer=192.168.1.50

[Shawn319]

[ChatChannelServer]
ChatChannelServer=192.168.1.50


I'm not sure this is needed at all.. no-one has access to the (working) 'chat channel' servers. If you get an error saying something about this, ignore it.

[Loosenut]

ok I been getting this duplicate error since 6 hours ago!, is this how it suppose to take to source the alpha 1 file!?

[lewster32]

Getting same problem as above, with either of the two files. :/

[Loosenut]

i just exited, i cant wait for 12 hours to source a file =\

[nilar]

[ChatChannelServer]
ChatChannelServer=192.168.1.50


I'm not sure this is needed at all.. no-one has access to the (working) 'chat channel' servers. If you get an error saying something about this, ignore it.

When 0.5.5 DR1 first came out, this error was causing world.exe to not connect to Login Server. Not sure if we still have this problem but thats why its in there.

[sephiroth]

So does anyone know what i am doing wrong here? why my server is locked? any help would be greatly apreciated. =)

For loosenut, i am not sure if this is why it is taking so long but try running that the doing the "source db.sql" and all the other ones without mysql running. It seemed to help when i did it, but i am not positive on that, just worth a shot.

[lewster32]

I see the two world databases you need to source have been removed from the guide, I assume they're incompatible with 5.5 or something?

[Jezebell]

No, they are just not necessary to get a server running and people are complaining to much about having to wait for them to source.

[lewster32]

Well several hours of the same error and the PC speaker beeping constantly kinda gives people the idea that it's not working :) And since no-one has given a straight answer as to how long it usually takes, and if that's normal, you'll continue to get these silly questions.

[Loosenut]

Well several hours of the same error and the PC speaker beeping constantly kinda gives people the idea that it's not working And since no-one has given a straight answer as to how long it usually takes, and if that's normal, you'll continue to get these silly questions.

when i slept last night.. i wasnt sourcing any files.. but i still heard the beeping terror lol

[lewster32]

This is annoying, I've set up EQEmu in the past many times, having taken a break from it, I come back and I'm getting all the problems I've read about.

Re-following your guide and making the necessary adjustments for Minilogin, World.exe crashes as soon as I create a character, on subsequent re-login World.exe finds my 'bogus' character and deletes it. Also, I'm getting the "Error: Could not load item data. But ignoring." stuff which, having searched the forums, is apparently because the db.sql is incompatible.

I can paste in a full World.exe output if necessary. Any ideas?

BTW I'm posting here and not making a new thread because it seems pertinent to the topic.

[lewster32]

Answering my own question: Sourcing db.sql is the problem, if you skip that step and source MW055_alpha_02.sql directly after use eq; it works fine, takes a couple of minutes but everything works perfectly. Something must be wrong with the db.sql included with 5.5

[Jezebell]

Actually if you only source in Alpha_02 then you will be missing the Doors table update, thats the only reason I said to source the db.sql, but I see your point, i will try to find the Doors update and post it in the Tutorial. Btw, if you source the files in MySQL-Front it only takes 2.5 hours and there is no beeping :) I have done it uncountable times.

[DrizztBanrae]

Download lootdrop update by govtcheeze v0.2

This link seems to be broken..can we get a new one please?

[mikenune]

Well several hours of the same error and the PC speaker beeping constantly kinda gives people the idea that it's not working And since no-one has given a straight answer as to how long it usually takes, and if that's normal, you'll continue to get these silly questions.
I wasn't there when it stopped (I was at work), but on my system which has a fast processor (AMD XP 3000), lotsa RAM (1GB), and fast a Hard Drive (a pair of 10,000RPM ATA100 8MB cache drives in RAID 0), and it took me more than 14 hours. My guess is somewhere around 16 hours or so. And yes, it continues beeping ALL THROUGH THE NIGHT!!! All for only about 5k new records. . .

Also, Since I have access to web space, I'm gonna go ahead and upload my MySQL DB dump and post a link to it when it's done.

I'm updating my DB with the "npc_types_update.sql" file right now. I'll have the dump out as soon as it's done! :)

[mikenune]

Here it is! Careful though, it's a little over 5 MB.

You'll need to right-click on the link and choose "save as. . ." since this web server knows how to read GZipped files!

http://www.raskii.net/eqemu/eqemu055.sql.gz (http://www.raskii.net/eqemu/eqemu055.sql.gz)

The only thing NOT in here (that I'm aware of at least) are usernames and the like. :)

[m0oni9]

I posted this in another thread, but if you run mysql with the -b switch, it will not beep on errer. ie:
mysql -b -u root

[kipmon]

I turned off beeping, and alpha2 ran in under a few minutes - done.

[cybermax]

You'll need to right-click on the link and choose "save as. . ." since this web server knows how to read GZipped files!
Cant get this to work.. i right click and choose save-as, and it just poofs.. nothing happens. If i click on it as a normal link, i get a completely white webpage..

Dunno what i am doing wrong..

Btw.. i did follow the guide and i guess it took somewhere around 16-18 hours to do :(.. anyway.. is there no spawns in there? tried some "regular" spots like pofire, pov, bot.. all empty.. supposed to be this way? or?

[infernal]

Hey im having a problem with this:


When i started mysql server, it skiped my username pass that i was going to create.

And now when i run boot5zones.bat, it brings up the 6 windows with all the same error:....

:?

[Error] Loading npcs FAILED!
===============================
Runtime errors:

MySQL Error #1405 or $2001 means your mysql server rejected the username and password you presented it.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id=1

Hit any key to exit



.... Well The website link does not work and i am not sure where i can change the username and pass for this...

Also, Which username pass do i use? A new one? the EQemu server username pass? and which one is causing the error?
:?: :?: :?: :?:

[infernal]

Please check this out and tell me what im doing wrong?
http://www.eqemulator.net/forums/viewtopic.php?p=76810#76810
KeepHopeAlive

[tazzz1137]

I can not get doorupdate to source I have folllowed your guide to the T got all running but gett 1017 on world select .In another post I was told to change name to source.sql done that and still wont source any help .Before i go brain dead fighting it :shock:

[Monrezz]

If you can't find it it's either (a) Not in your mysql\bin folder (same folder as mysql.exe) or (b) You're typing the wrong filename.

Rename it to "a.sql" (can't be more simple than that), copy it to C:\mysql\bin (or whatever you have), than Strat => Run => cmd (Check to see it's pointing to bin directory - if not cd to it) and type in this into the mysql window:

mysql -u root -b eq
source a.sql;
exit;

If you still cant get this to work download Mysql front and right click on your EQ database, choose Import => From file and then source it that way.

[petersonz]

How come you mention downloading the lootdrop update, but not sourcing the .sql files into the eq database as a step?

Just curious.

[Jezebell]

its optional

[Deere75]

well after reading every post that i could i have finally figured the problem out. when sourcing in the db.sql it moved the directory to the mysql directory when i copied the data and moved it to the db directory everything worked. hope that this helps someone out there.

[fendulon]

i cant find winmysqladmin.exe

[Derision]

i cant find winmysqladmin.exe

It should be in C:\mysql\bin

[Monrezz]

C:\mysql\bin

[fendulon]

i ment to put them the other way but i still cant find it

[Derision]

Assuming you downloaded and installed mysql ( http://dev.mysql.com/downloads/mysql/4.0.html )

You could do start/run/cmd

then type

cd \
dir winmysqladmin.exe /s

That will search all directories on your C: drive and show you where it is installed.

[tearnevery1doown]

Hello, I followed your wonderfull walkthrough and found it very easy to get along with and only had a few errors which I think i worked out... I was having a problem with a 1017 error but i think i fixed that somehow.. now when i try to login to my server everquest stops responding.. this is my world.exe thing: [Status] CURRENT_WORLD_VERSION:EQEMu 0.5.6
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=26679, max id=68199
[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] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Liberating a country that despises us...
TCP listening on: 68.101.150.85:9000
World server listening on: 68.101.150.85:9000
Connected to LoginServer: eqlogin1.eqemulator.net:5997
35360 New TCP connection: 192.168.1.100:1862
35391 New TCP connection: 192.168.1.100:1863
New zoneserver: #1 192.168.1.100:1863
New zoneserver: #2 192.168.1.100:1862
35438 New TCP connection: 192.168.1.100:1864
35438 New TCP connection: 192.168.1.100:1865
New zoneserver: #3 192.168.1.100:1865
New zoneserver: #4 192.168.1.100:1864
Zoneserver SetConnectInfo: 192.168.1.100:1862: 68.101.150.85:7995
Zoneserver SetConnectInfo: 192.168.1.100:1863: 68.101.150.85:7997
35469 New TCP connection: 192.168.1.100:1866
New zoneserver: #5 192.168.1.100:1866
Zoneserver SetConnectInfo: 192.168.1.100:1864: 68.101.150.85:7999
Zoneserver SetConnectInfo: 192.168.1.100:1865: 68.101.150.85:7996
Zoneserver SetConnectInfo: 192.168.1.100:1866: 68.101.150.85:7998
83469 New client from ip: 192.168.1.1 port: 1869
Account Attempting to be created:band1t 0
Logged in: FirstLogin LS#52681: band1t
Client disconnected
Removing client from ip:192.168.1.1 port:1869
207.36.180.194:5997: TCPConnection::RecvData(): Error: 10054
Error: LoginServer::Connect: 'TCPConnection::Connect(): connect() failed. Error:
10060'
Connected to LoginServer: eqlogin3.eqemulator.net:5997
332422 New client from ip: 192.168.1.1 port: 1876
Logged in: FirstLogin LS#52681: band1t
Client disconnected
Removing client from ip:192.168.1.1 port:1876
207.36.180.194:5997: TCPConnection::RecvData(): Connection timeout
Connected to LoginServer: eqlogin3.eqemulator.net:5997
711125 New client from ip: 192.168.1.1 port: 1150
Logged in: FirstLogin LS#52681: band1t
Client disconnected
Removing client from ip:192.168.1.1 port:1150

..... I have all the ports listed in the router tutorial open and basicaly i opened any port i saw the program listening on as a precaution cos im stupid, uhm if you have any ideas why eq stops responding when i try to login to my server id appreciate it. i tried on 2 computers locally that are on my network. also my server name is bloody poway if anyone else wants to try to like get on it?

[bluejam]

first of all dowload this, right-click > save target as > copy to your eqemu folder

eqtime.cfg (http://www.rockel.de/tobias/files/eqtime.cfg)

at least that should fix those errors at the beginning.

[tearnevery1doown]

k added that time config file also on my zones it says shit like this
[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.6
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading loot tables
[Status] Loading doors
[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: 192.168.1.100:9000


when i boot it up i dunno if that matters just posting that too

[Cripp]

you need to add those commands to the addon.ini file.

[mikenune]

All those errors mean is that those commands (help, version, serversidename, loc, flag, and si) don't have a required level to be used and it's defaulting the level to "everyone who's logged in". This is only a problem if you are running a Legit, Custom-Legit, or Semi-Legit server and don't want people to use commands like si or flag. Normally I just ignore them but if you want, you can add the following lines to the bottom of your 'addon.ini' file to get rid of those errors (note this won't actually change who can/cannot use them, it will just remove the error message).

addon.ini

!help=0
!version=0
!serversidename=0
!loc=0
!flag=0
!si=0

[tearnevery1doown]

any idea why people get disconnected after creating a character.. and i cant even get to character creation eq just starts responding

[Valex]

The mysql 4.0 link DOES NOT WORK:)

[erb2k]

Hello Running world.exe right now. Everything goes fine up till I get to eq.variables and then I get the following error.

Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1146: Table 'eq.variables' doesn't exist'

Know why I'm getting this? I am supposed to have everything I need. /sigh :( talk about suckage :-) Hope you can help me out :-)

Erb2k

[Force]

all my servers are runnign perfectly but... how do i play? lol

[NarutoLegacy]

All of your servers? Are you trying to play or trying to run a server?

[oxiroxt]

(***NOTE*** sourcing MW055_alpha1.sql is OPTIONAL, if you source Alpha1 then Alpha_02 it will take hours to source in because of duplicate entries, but you will have a more complete database....if you do not want to wait hours for it to source only source in Alpha_02!!!)


So I went for the complete db... but...
You should have warned that everytime it finds a duplicate entry it makes the computer speaker BEEP!!!! :evil:
It's been beeping all the time now for 30mins. and I can feel my head is about to explode!!! :shock: :x :roll: :cry: :oops: (there are just not enough emoticons to represent how i feel right now)
Im going to the most apart room from this one now...
I was about to pull the speaker cord few time ago, but reconsidered after noticing the reset wire next to it.
And, NO, my comp. speaker control doesnt work.

Apart from that... Thank you for the tutorial. I've spent the whole night trying to get the server working, but seems that the guide on the main page is a lil outdated. Hope this one works. Thanks. :)

[valaerosilantix]

lol I found that out too.. took me 12 hours to finish... I had to disconect speaker :/

[oxiroxt]

lol I found that out too.. took me 12 hours to finish... I had to disconect speaker :/

Thanks for the telling the time it took you. Ive decided to finally pull out the cord. Its been like 6 hours now and still beeeping.
Done. Wow, what a silence. Its like relaxing. phew :D

[govtcheeze]

from the DOS prompt browse to mysql\bin and type:

mysql -f [database name] < [file name to source]

FOr instance, mine looked like the following:

C:\mysql\bin> mysql -f eq<tcsmw_055_alpha2.sql

No beeping and only errors are output. Thanks to someone else in another thread for pointing this out.

[mikenune]

erb2k, it looks like you don't have a complete database. As long as you don't have any custom items/spawns/loot tables/etc. then I'd suggest deleting your old eq DB and resourcing using this one (http://www.raskii.net/eqemu/eqemu056.zip). I've heard mixed reviews as to whether or not it works on a 5.7 server, but it should work fine on both versions 5.5 and 5.6. Just follow the directions in the packaged REATME.TXT file and you should be fine.

[CK-Jhev]

Download TCMyWorld's Alpha 1 database and TCMyWorld's Alpha 2 database

I tried downloading these, and I couldn't get either one. Does anyone know if the links still work, or where I can get them? Are they even necessary? Thanks!

[Aniron]

i wonder why it takes everyone so long to source both of those. It only took me about 30 minutes total for the two. Any idea's as to the varying difference in time (running a p4, 2.0 ghz)

[jamescr]

When I run the boot5zones I get

C;\mysql\eqemu>REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1

C:\mysql\eqemu>
C:\mysql\eqemu>REM: If you still get errors try using localhost instead of 127.0.0.1

C:\mysql\eqemu>
C:\mysql\eqemu>REM:-----------Start------------
Cannot find file 'zone' <or one of its components>. Check to ensure the path and filename are correct and that all required libraries are available.
Cannot find file 'zone' <or one of its components>. Check to ensure the path and filename are correct and that all required libraries are available.
Cannot find file 'zone' <or one of its components>. Check to ensure the path and filename are correct and that all required libraries are available.
Cannot find file 'zone' <or one of its components>. Check to ensure the path and filename are correct and that all required libraries are available.
Cannot find file 'zone' <or one of its components>. Check to ensure the path and filename are correct and that all required libraries are available.

[mikenune]

Looks like you need to rename ZoneDebug.exe to Zone.exe. Might have to do the same for World.exe.

This is assuming that C:\mysql\eqemu is the directory that you have your EQEMu server installed on. Is this where you have all your EQEMu stuff (including the cfg and other directories) at?

[jamescr]

they are already changed, still getting same error

[jamescr]

Ok my server is officially up, but it's locked heh, how do I unlock it? =)

[masteryoda]

Edit your loginserver.ini file, if you haven't already to read locked=false

[lockecole]

not sure why it takes so long. on my new PC, amd64 3200+ 2.0Ghz it took all of about 2 minutes to source both. also on my AMD duron 800mhz machine only took about 20 min to source both. 16 hours? what are you running?

[w1ntermute]

lol im sourcing all the DBs on an old sparcII.. i'll race you!

[Kikaro]

Great guide so far im doing good with it. However,

TCMyWorld's Alpha 2 database

The link you provided has a corrupt file. Is there anywhere else to get this? Im searching for it and I just cant find it.

[m0oni9]

Telling mysql client to be silent, and to turn off beeping, can speed things up a lot.

mysql --silent --no-beep

[Bumbee]

Ok, I used to host my server never quite had this problem...

I'm doing everything the walkthrough is saying, to the T. When I do source MW_057DR2_alpha_1.sql; everything is fine but one Beep at the end...
I then run source loot_update.sql; loaded with beeps, but we'll move on, source npc_types_update.sql; goes into an infinite loop it seems, I have a decent comp. (AMD athlon 3200+ 2.0 ghz). I let it run for hours on end, just keeps going, no beeps, or anything. so after too long I quit it, thought I check to see if world works, fixed db.ini, loginserver.ini boot5zones and all, but my server is still locked anyway... in Login server I have it to false... maybe some of the files in new walkthrough are corrupt? any info would be much appreciated I wanna get my server back up :cry:

[Jezebell]

Its normal for it to take hours and hours sourcing those updates, you just have to let it run, do it before you go to bed or something.

[Bumbee]

I have no idea why... but all my NPC guild trainers (original ones) arent GM's... they're just there, is there a way I can fix them? I sourced everything and they're messed up, heh, sorry for bothering again. :oops:

[cabtiz]

this will help you out with that.. keep in mind though that this will only work with the NPC's in the database you are using that have guildmast in their name

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

[antithott]

Hmm so ok i have a problem, I Have everything setup right, no erros in either World, or boot5zone, they load up fine, i have my external and internal ip put in, and i have put in the eqemu login info.

But the problem comes when my server dont show up on the list? Any idea what could cause this, or info on how i put up a private login setting

[SirThomasIV]

this is making NO sense! I used to be able to set this shit up all the time. I followed the directions step by step from numerous forum posts (mostly this one) numerous times. But when I try to load up world.exe it immediately closes. I noticed it says something so i held down enter to keep opening it and then took a screenshot. "[Database] block not found in DB.INI. Read README.TXT!"
here is what my db.ini says
[Database]
host=127.0.0.1
user=***********
password=********
database=eq
compression=off
^- with the normal username and pass of course for mysql
ok so yea, the db.ini is correct right? ok so I thought maybe it has to deal with the database on mysql, tried reinstalling mysql and doing the sources over again... nope, doesn't work.
Any help much appreciated.

[Jezebell]

make sure you don't have a space after [Database]

[SirThomasIV]

hehe, thanks dude. yea i was just looking around the forum and found out that was my problem for my eqhost file as well and came back here and yea, fixed the db.ini file too

[SirThomasIV]

moved as its own post

[Merq]

I can't get past the damn "Logging in to server. Please wait..." screen. Is it because I patched?

[tkd1991a]

ok i'm trying to just get started with this server set up, when I make the first text file MySQL.bat it just stays as a text file and nothing runs when I hit return etc.... help please

yes i'm retarded

[Darkdrizzt]

my servers up and running but when i click boot5zones they come up and dissapear really fast

[bwickes]

you need a newer compiled set

[DaCap]

i currently have
CURRENT_WORLD_VERSION:EQEMu 0.5.7-DR3

i fallowed everything and im getting this when i try to connect

1515870 New client from ip: 192.168.0.7 port: 1160
[Error] Expecting OP_SendLoginInfo, got 250
Removing client from ip:192.168.0.7 port:1160

any ideas?

and is there any precompiled dr4 binaries available?

[pitbull23701]

hmm ive done everything as said to be. checked double checked and triple checked even went over every forum threads i could find yet i still get this when i run world.exe (and when i check if its up it says locked)
C:\EqEmu>world
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.7-DR3
[Status] Loading variables..
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 varia
bles where unix_timestamp(ts) >= 0' #2006: MySQL server has gone away
[Status] Loading zones..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #2006: MySQL s
erver has gone away
[Status] Loading items..
[Status] EMuShareMem 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 s
erver has gone away
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
[Error] Error: Could not load item data. But ignoring
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadGuilds query 'SELECT id, eqid, name, leader, minstatus, rank0title,
rank1, rank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, ran
k5, rank5title from guilds' #2006: MySQL server has gone away
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player corpses from database
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player backups from database
Breaking linux compiles....
TCP listening on: 207.68.51.151:9000
World server listening on: 207.68.51.151:9000
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#2006: MySQL server has gone
away'
Connected to LoginServer: eqemulator.net:5995
Got signal 2

C:\EqEmu>

[jd255]

pitbull23701 make sure you edit you db.ini with correct info and check and make sure mysql server is running your world server can't login into the db
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away

[sum999]

everytime when i try to run world.exe, i keep getting this error says

error:emusharemem : DLLloaditems: ! cbDBLoaditems
[error] Error: Could not load item data. But ignoring
[status] ./logingserver .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

[LeoBreaker]

when i go to run the boot5zones.bat after running world.exe i get the error "Windows cannot find 'zone'. Make sure you typed the name in correctly, and then try again. To search for a file, click the Start button, and then click Search" What should i do to correct this problem

[aefon]

Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.7-DR4
[Status] Loading variables..
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 varia
bles where unix_timestamp(ts) >= 0' #2006: MySQL server has gone away
[Status] Loading zones..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #2006: MySQL s
erver has gone away
[Status] Loading items..
[Status] EMuShareMem 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 s
erver has gone away
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
[Error] Error: Could not load item data. But ignoring
Invalid worldname, please edit LoginServer.ini. Server name must be at least 10
characters.
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadGuilds query 'SELECT id, eqid, name, leader, minstatus, rank0title,
rank1, rank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, ran
k5, rank5title from guilds' #2006: MySQL server has gone away
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player corpses from database
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player backups from database
Formatting drive C:
TCP listening on: 68.200.24.158:9000
World server listening on: 68.200.24.158:9000
===============================
Runtime errors:

MySQL Error #1405 or #2001 means your mysql server rejected the username and pas
sword you presented it.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id
=1

Hit any key to exit

[Ryder]

where can i find this file its not on the the server that was hosting it

[mhtrim]

Are these 5.7-DR3 binaries available from an alternate location?

[bluejam]

@aefon: try to end the mysqladmin tasks through the task manager and restart the winmysqladmin.exe(or something like that) in the mysql/bin folder