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

[Bearik]

Outdated - information may be useful for future tutorials, but no information here should be used or trusted

Step One: Before You Start

1. Download and install MySQL 4.0.16 or MySQL 3.23.58

2. Download and extract the latest EQEmu server binaries to wherever you want.

Step Two: MySQL Setup

1. Run winmysqladmin from your mysql\bin folder, a window should open asking for a username and password, chose a username and password you can remember. Leave winmysqladmin running.

2. Run dos prompt (start,run,cmd) and type:
cd\mysql\bin

mysql -u root mysql
(this opens mysql fully enabled)

Once inside mysql type:

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

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



3. Type in:
create database eq;



4. Now you need to source in your SQL files into your database, So move db.sql from the EQEmu folder to mysql\bin

5. Type in:
use eq;
source db.sql;



Now alot of lines should appear saying Query OK, 1 row affected <0.00 sec>

6. Exit MySQL

Step Three: EQEmu Setup

Now you need to edit LoginServer.ini and db.ini only underlined text you need to modify

db.ini

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

Replace YourMysqlUsername with the username you chose and replace YourMysqlPassword with the password you chose (Duh)

LoginServer.ini

[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginport=5997
worldname=Your server name here
worldaddress=Your external IP Address here
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

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

Replace Your server name here with what you want your server to be called. (Note: Dont put server in your worldname)

Replace Your external IP Address here with your IP address, http://www.whatismyip.com/ can tell you what that is.

Step Four: Running EQEmu

1. Copy spells_en and spells_us from your EverQuest directory to your EQEmu directory

2. Right click on Boot5zones.bat and click edit. It will open up to something like this

@echo off

if NOT exist spells_en.txt goto NOSPELL

start zone . YourIP 7995 YourIP
start zone . YourIP 7996 YourIP
start zone . YourIP 7997 YourIP
start zone . YourIP 7998 YourIP
start zone . YourIP 7999 YourIP
exit
cls

You need to replace YourIP with you guessed it, your IP address. Again you can find out what your IP address is by going to http://www.whatismyip.com/

One effective way of doing this is pressing CTRL + H, a window will pop up that looks lke this (Note: CTRL + H doesnt work in all text editors, so just use notepad for this)



After Find what: Put in YourIP and after Replace With: Put your IP address



Then just keep hitting replace until it replaces all of the YourIPs

3. Start up world.exe If you didnt setup db.ini correctly it will give you a bunch of errors that it cant access the 'eq' database. If this happens make sure the database is running (check services running) or open up winmysqladmin.exe if its not. The last message you should see is it trying to post itself to the EQEmu login servers. It mail fail due to internet traffic, if so close it and try again. You should see this at the end signifying your server is being listed at EQEmu.

World server listening on: port 9000
Connected to LoginServer: eqlogin1.eqemulator.net:5997

4. Start up Boot5zones.bat, this will start 5 zone servers in 5 different windows.

5. Enjoy

Notes:

For now, make sure your firewalls are turned off, this includes the Windows XP/2k3 software firewall. Check Here for information on running behind a firewall

Right now the best 5.x compatible database is MWnpcmovDB, bytcsmyworld. For the latest release check the World Building forum.

If you want to compile your own server binaries with the latest dev releases check this topic Click Here

/End Guide Last updated: Monday, Dec 1, 2003

Big thanks to arkaria, shawn, mattmeck.

Any suggestions for the guide would be appreciated, and please tell me if something is incorrect.