EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Tutorials/Howto's (https://www.eqemulator.org/forums/forumdisplay.php?f=619)
-   -   HOWTO: Setup an EQEmu server as of 06/01/2004 (https://www.eqemulator.org/forums/showthread.php?t=12337)

Jezebell 03-08-2004 01:55 PM

HOWTO: Setup an EQEmu server as of 06/01/2004
 
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 to open some of the files. If you have a router look here Router Guide, if you have a firewall it needs to be configured to allow access to the ports.

I highly recommend downloading MySQL-Front 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

Mangoo's Item Editor 1.9.1

capusr5's IEQ



FIRST STEP:

1. Download MySQL 4.0.18 , after that install the downloaded file

2. click 5.7-DR3

3. click EQEMu 5.6 Config and download EQEmu-0.5.6-Configuration.zip

4. Extract everything to C:\EQEmu

5. Download ProjectEQ.com Alpha 1 database

Download
Govtcheeze loot updates

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.

Code:

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:

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 MW_057DR2_alpha_1.sql;
Press Enter.

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

Code:

source loot_update.sql;
Press Enter.

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

Code:

source npc_types_update.sql;
Press Enter.

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

Code:

quit
Press Enter.


THIRD STEP:

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

Code:

[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:

Code:

[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:

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------------------------

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 03-08-2004 02:22 PM

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

nilar 03-08-2004 04:19 PM

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 03-09-2004 02:13 AM

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

Maulgak 03-09-2004 03:26 PM

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

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

themushygod 03-15-2004 04:57 PM

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

nilar 03-15-2004 05:09 PM

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 03-15-2004 05:28 PM

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

Code:


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

Code:


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 03-15-2004 05:30 PM

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

nilar 03-15-2004 05:40 PM

Also Worlddebug = World and Zonebug = Zone

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

themushygod 03-15-2004 05:41 PM

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

ill try re granting privliges

themushygod 03-15-2004 07:30 PM

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 03-15-2004 07:47 PM

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

Jezebell 03-15-2004 08:27 PM

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

themushygod 03-15-2004 09:03 PM

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 03-15-2004 09:30 PM

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

Code:

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

Code:

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

Code:

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 03-15-2004 10:06 PM

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 03-16-2004 12:27 AM

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

hamg 03-16-2004 04:45 AM

i have the same problem too

themushygod 03-16-2004 08:55 PM

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 03-17-2004 01:39 PM

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

Jezebell 03-17-2004 01:46 PM

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 03-17-2004 02:09 PM

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 03-17-2004 02:11 PM

Check the guide lol. It explains everything there

Jezebell 03-17-2004 02:23 PM

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

themushygod 03-17-2004 02:47 PM

like i said mines going i just crash

nothing in the guide bout that

darkshadows501 03-17-2004 03:30 PM

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

Code:


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

Code:


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 03-18-2004 10:49 AM

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 03-18-2004 11:24 AM

You need spells_us.txt too.

coregamer10 03-18-2004 05:59 PM

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 03-19-2004 04:46 AM

Server
 
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 03-19-2004 08:16 AM

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 03-19-2004 09:20 AM

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 03-19-2004 09:21 AM

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

coregamer10 03-19-2004 09:23 AM

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 03-19-2004 09:38 AM

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

samandhi 03-19-2004 09:45 AM

@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:
Quote:

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:
Quote:

# 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:
Code:

[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 03-19-2004 09:53 AM

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

Longear 03-19-2004 09:55 AM

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

Longear 03-19-2004 09:59 AM

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


All times are GMT -4. The time now is 12:53 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.