Log in

View Full Version : Up to 1 point... then boom


Tarnien
11-23-2003, 04:00 PM
I am using http://www.eqemu.net/Guide.htm

1.1) Go to www.eqemu.net and go to the Files section.

1.2 ) Scroll down to the "EQEMu Server" section. Download the latest EQEMu Win32 file. At the time of this writing EQEMu-0.4.4-Win32.zip was the latest.

1.3 ) Extract all the files in to C:\eqemu

Downloaded http://heanet.dl.sourceforge.net/sourceforge/eqemu/EQEmulator5.0Source.zip

Extracted all files into C:\EqEmu

2.1) Go to www.mysql.com and go to the downloads section.

2.2 ) Scroll down to Windows downloads and get the latest production MySQL (Scroll down to pick a mirror)

2.3 ) After it finishs downloading, install it. A reboot might be needed.

2.4) Go over to your MySQL directory ( C:\mysql ) and go to the Bin folder ( C:\mysql\bin )

2.5 ) Open " Winmysqladmin.exe " It will ask you for a username / password ( Choose a username / password that you will be able to remember)

-NOTE - - You have to have Winmysqladmin.exe running for EQEMu to work, so everything you want to run your server, reopen from the \bin directory winmysqladmin.exe.

Downloaded mysql-4.0.16-win.zip. Installed it. Rebooted.

Opened " Winmysqladmin.exe " and put in my username / password.

3.1 ) Go to your EverQuest directory and copy "spells_en.txt" (Right click , Copy) Then go to your EQEMu directory (C:\eqemu ) and paste it ( Ctrl V )

-Note -- You HAVE to have the latest spells_en file. Do this by patching EQ to latest.

3.2) Go to your EQEMu directory (C:\eqemu ) and copy " db.sql " . Move it to your MySQL bin directory ( C:\mysql\bin )

Copied "spells_en.text" and went to My Computer -> Local Disk(C: ) -> EqEmu and pasted.

Went back to C:\EqEmu and copied " db.sql " and pasted it in C:\mysql\bin.

3.3) Download Drawde's Worlddata 1.1 final (Its a DB containing spawns (npcs/monsters)) Unzip it and copy over all the files over to your Mysql bin directory ( C:\mysql\bin )

NOTE - When you finished unzipping , you have to copy/paste the FILES (not the folder!)

Downloaded Drawde's Worlddata 1.1 final and unzipped it. Copied over all the files NOT the folder to C:\mysql\bin

3.4) This part might be a little tricky for some, so read word-by-word.

- Go to your MySQL bin directory ( C:\mysql\bin ) and open " mysql.exe "

- Now type the following in this order ( Type one line, hit enter, move on to next)

create database eq;

use eq

source db.sql;

<A bunch of lines should pass by this is normal .>

< If your computer 'beeps' , just ignore it >

<Once it finishs(stop scrolling lines) Type the following>

source reloaddb.sql;

<More lines will scroll by, you might wanta go make some food at this point ,as this will take 10min plus to finish, again ignore the beeping. Then type >

GRANT ALL PRIVILEGES ON *.* to '%'@localhost IDENTIFIED BY '%';

After it finishs Type " Exit " . MySQL will close.

Well.. I guess it was a little bit tricky for me! I opened mysql.exe and this is copied and pasted from mysql.exe when I typed in create database eq;

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 3.23.58-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database eq;
ERROR 1044: Access denied for user: '@localhost' to database 'eq'
mysql>

:shock: What did I miss this time?

arkaria
11-23-2003, 04:43 PM
First off that guide is out dated. It does have everything in it you need to figure out how to get started but if you don't really know what your doing it you might not get all the info you need from it.

Downloaded http://heanet.dl.sourceforge.net/sourceforge/eqemu/EQEmulator5.0Source.zip

Don't get the source .zip unless you want to compile it. There is a .zip with the binaries. Get it.

2.3 ) After it finishs downloading, install it. A reboot might be needed.


I'm going to guess you didn't really follow the "install it" part all the way. If you did you would have followed the instalation instructions in the mysql package you got and would have setup the root user for mysql.

If you did infact setup the root user then you will need to login as the root user when you run mysql.exe "mysql.exe -u root -p" <enter pass when prompted>

Once logged in as root you will be able to create the eq db and source the db.sql. Then create a user for the eq DB using the grant command you listed.

a_Guest03
11-24-2003, 02:59 AM
I don't think Drawde's database is very recent. Search the worldbuilding forum for tcsmyworld's most recent one.

cybermax
11-24-2003, 03:23 AM
Afaik the Drawde's db does not work "out of the box" with 0.5.0 server..

This does tho : http://www.everquestserver.com/forums/viewtopic.php?t=10890

Be sure to get this as well : http://www.everquestserver.com/forums/viewtopic.php?t=11161

wolfy99
11-24-2003, 06:14 AM
Copied "spells_en.text" and went to My Computer -> Local Disk(C: ) -> EqEmu and pasted.

Copy spells_us.text as well.

I play EQ in the UK, and it still said that it couldn't find the spells, so copied that file over, and all was fine.