Step: 12

Tarnien · #1 11-23-2003, 01:47 AM

Ok Thanks to Rogean! He got me all the way to Step 11 before we had to stop n stuff...

Quote:

12. Create EQ Database

Make sure you followed the instructions in the cvs section for adding mysql binaries to the %path%.

Open a DOS prompt
Win98/95/ME - start->run->command
Win2k/XP/2k3 - start->run->cmd

Type in the following:
c:
cd "\eqemu\cvs\eqemu\eqemu release"
mysql -u root mysql

Inside of mysql, type these commands:
create database eq;
grant all privileges on *.* to test@localhost identified by 'test' with grant option;
quit

You should see the following as output from above:
Code:
C:\EqEmu\cvs\eqemu\EQEMu Release>mysql -u root mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 22 to server version: 3.23.57-nt

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

mysql> create database eq;
Query OK, 1 row affected (0.00 sec)

mysql> grant all privileges on eq.* to test@localhost identified by 'test'
with grant option;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

C:\EqEmu\cvs\eqemu\EQEMu Release>

Back in the DOS prompt, type this command:
mysql -u test -p eq

You should see a password prompt - enter in your password ('test' in this sample). You should see the following:
Code:
C:\EqEmu\cvs\eqemu\EQEMu Release>mysql -u test -p eq
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 24 to server version: 3.23.57-nt

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

mysql>

Time to load a blank database. Type in the following command:
source db.sql;

You will see the following for a LONG time:
Code:
mysql> source db.sql;
Query OK, 0 rows affected (0.03 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.00 sec)
(... repeat about fifteen thousand times)

You now have an EQ database with NO ITEMS/MOBS/ETC. See http://www.eqemulator.net/forums/viewtopic.php?t=6176 for info on populating your database.

0.5.0-DR3 - While 0.5.0 is still under development, you will need to run these temporary scripts to create tables that hold our work in progress:
source doors_objects.sql;
source pets.sql;

Close out the DOS window. You are done with it.

I can't get passed

Quote:

Open a DOS prompt
Win98/95/ME - start->run->command
Win2k/XP/2k3 - start->run->cmd

Type in the following:
c:
cd "\eqemu\cvs\eqemu\eqemu release"
mysql -u root mysql

for some reason when i type that stuff in in the cmd window nothing happens at all.. no error messages or anything :/

Kroeg · #2 11-23-2003, 03:21 AM

Wow, you obviously didn't follow the guide very well..

This:

c:
cd "\eqemu\cvs\eqemu\eqemu release"
mysql -u root mysql

Is irrelevant. It's basically saying to cd out to your cvs directory (which deals with the source code of eqemu) and then to load a mysql console? That makes no sense! either it's:

c:
cd \eqemu\cvs\eqemu\eqemu release
cvs -d:pserver:anonymous@cvs.sourceforge.net:/blah blah blah

OR, it'd be:

c:
cd \mysql\bin
mysql -u root mysql
(which is a proper path... although as a good rule of thumb, you should add the \mysql\bin directory to your environment variables).

Watch the steps more closely... this opened you up for a bit of a flame, considering everyone spent all that time making setup guides so people didn't just blindly come on the forum and ask for help with something 10 million other newbs a day ask for. Just a bit of advice, if you actually want people to respond to your 'help' threads.

good luck

Tarnien · #3 11-23-2003, 04:54 AM

Ok, I tried a different guide, http://www.eqemu.net/Guide.htm
I think it's a lil bit older but I think I used all the updated versions while doing it...
I got to having to type in:

Quote:

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

I got a message saying:

Quote:

ERROR 1045: Access denied for user: '@localhost' (Using password: NO)

The guide didn't say what it was suppose to say if i did it right or wrong so i went on and typed "Exit" like it told me to (without the "). I go on.. everything is fine then I get to the end and have to start up World.exe and wait for it to finish then start up "Boot5Zones" well... Hail!

Quote:

Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.0
[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..
[Error] LoadEMuShareMemDLL::Load() failed to load library 'EMuShareMem'. Error=
126
[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
Warning: You need to get laid...
TCP listening on: port 9000
World server listening on: port 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

What should I do?

If I am wrong Please let me know where I screwed up =(

Mehbe it's just the guide is too old? or just me :p

#4 11-23-2003, 05:08 AM

If you do a search for 1045 you will recieve all the answers you need.

Also you are posting in the wrong forum this is NOT a help or support forum.

Tarnien · #5 11-23-2003, 05:24 AM

Thank You.

Tarnien · #6 11-23-2003, 05:53 AM

Nothing Worked... if i am being rejected name and pw is there a way to clear it then redo 1 incase i dont have the right name and pw in the login server files or wherever i was suppose to put those ? :/

Tarnien · #7 11-23-2003, 05:56 AM

NM i will do it all over again with a different guide, mehbe it'll be more specific

#8 11-23-2003, 05:58 AM

Most people who are able to help you wont do it, because your posting in the wrong forum. Some dont read any but the support forums and others wont help people who dont follow directions.

Post in the correct forum and give lots of detail, saying " Me did everytin rite bt it do not work" isnt enough info because if you did everything right it would work. (not saying you did this or talk like this, but some people actualy do

)

Tarnien · #9 11-23-2003, 03:08 PM

Well then.. to the support forums with more detail! goooooooooo! :P

Merth · #10 11-24-2003, 02:59 AM

Quote:

Watch the steps more closely... this opened you up for a bit of a flame, considering everyone spent all that time making setup guides so people didn't just blindly come on the forum and ask for help with something 10 million other newbs a day ask for.

The original poster was right on the money. The quote given was from directly from the guide. The reason to change into the eqemu release directory is so you are able to source the .sql files located there.