Server Setup 44DR1 - As of June 9th

[IADrako]

Follow these steps CAREFULLY! Don't skim, read it all!

1. Download http://bellsouthpwp.net/s/m/smit4973/eqemuu.zip and extract it into C:\eqemu. I'll refer to the directory it was installed into as C:\eqemu.

2. Write down your external ip.
-External ip can be found by going to www.whatismyip.com

3. Download and install mySQL to C:\mysql --- http://www.mysql.com/downloads/downl...mp;pick=mirror

4. Copy and paste the file spell_en.txt from your Everquest directory to C:\eqemu.

5. Copy and paste the file db.sql from C:\eqemu to C:\mysql\bin.

6. Copy and paste the file update44dr1.sql from C:\eqemu to C:\mysql\bin.

7. Download and extract the following files, then take all the txt files from each folder and paste them into C:\mysql\bin (
- http://edwardpinniger.bctalk.net/eq/worlddata1.1.zip
- http://edwardpinniger.bctalk.net/eq/itemsbooks.zip

8. Open the program winmysqladmin from C:\mysql\bin. You will be prompted to enter a Username and password. Write them down with your external ip. If you lose it and need it for future reference it can be located in the file my.ini. Send the program to the Taskbar by pressing "Hide Me"

9. Verify the Green light is ON.

10. Open C:\mysql\bin\mysql.exe

11. Type the following lines in. After each line hit enter and go on to the next. Do not type lines that begin with ### as this is commentary on what you just typed by me. Lets begin...

create database eq;

### This creates a database that holds all info for your eq server.

use eq

### This tells mysql this is where we want to source the files to.

source db.sql;

### Lines will scroll by indiciating info being sourced into the database.

source update44dr1.sql;

###More lines will scroll by and some will say "could not overwrite." Thats fine.

source reloaddb.sql;

### This is where we find out if your databases are compatible, which they should be provided you used the db.sql from the zip I listed at top. If you are spammed with errors about npcspells, missing columns of MR or other things like this. There is a conflict difference between the two databses. I suggest posting the error and the steps you followed or going to the irc chat room.

source books.sql;

source items.sql;

### Sourcing in book and items databases.

exit

12. Now open C:\eqemu

13. Open db.cfg (NOT .sql)

14. Add in the username / password you used when starting mySQL. You should have it written down along with your external ip address. Save and close the file.

15. Now open loginserver.cfg and goto the line
servername=
and enter your servername. Do not add "Server" to the end as it is added automatically.

16. Goto the line
worldserver=
and enter your external ip. Save and close the file.

17. Right click boot5zones.bat and select Edit. It will read in middle:

start zone . hosthere 7995 hosthere
start zone . hosthere 7996 hosthere
start zone . hosthere 7997 hosthere
start zone . hosthere 7998 hosthere
start zone . hosthere 7999 hosthere

Enter your external ip in the first host here.

Open mySQL from the taskbar and on the left side of the window will be a greyed out box with an ip address in it. If it is different that your external ip you are behind a router. We will work around this the best we can, but openeing the ports will be your responsibility.

Enter your ip (internal if applicable) in the 2nd host here section.

Notice that the ports continue to go up by 1. You can launch more than 5 zones by adding in the same lines again, just be sure to keep increasing 1 port number.

Save and close.

18. Now open world.exe. Then open boot5zones.bat.
Your done! You shouldn't have recieved any errors.

Troubleshooting

1. world.exe opens with several errors accessing database files.

- Check to make sure login in db.cfg matches up to login for mysql. Verify username for mysql in my.ini (Start->Search it)

2. I get errors when I:

source reloaddb.sql;

- Your datatbase files aren't matching up correctly. Try a different version of the db.sql and make sure your running all included versions of this post.

3. I can't login to my server but I have no errors and everything seems fine!

- This can be caused by you being behind a router. This situation can vary so much I can't help. Your goal is to open ports 9000, and 7995-7999 or however high you listed boot5zone.bat up to.

Good luck!