Server Set up

[Bones]

I have followed the directions to the server setup twice now and i still think there is something wrong, when i click the start.bat two windows pop up but one closes right away and i am just left with one saying wait for world to finish loading then press enter. Does that mean i have done something wrong?

[Bones]

I have followed the directions to the server setup twice now and i still think there is something wrong, when i click the start.bat two windows pop up but one closes right away and i am just left with one saying wait for world to finish loading then press enter. Does that mean i have done something wrong?

I also have a question about part of the set up guide with the peq_db.

when i get to the part of the guide that says click start>run "cod"

After typing "cod" in run i get this error.

"windows cannot find 'cod'. Make sure you typed the name correctly, and try again."

figuring it was a typo, and typed "cmd" instead

start> run >cmd
c:\Documents and Settings\Owner) cd\peq_db
c:\peq_db
c:\peq_db MySQL -u root -p

I took this from the axdb set up that i tried previously. the set up for peq_eq says to use cod\peq_db but cod doesnt work for me so am i doing something wrong?


the guide als

the command so I just typed cmd instead.

Ive got alot of questions,
The guide said to type

"Create database pew;"
\u pew
i accidently did /u pew and when i typed
Source load_system.sql nothing happend

I closed the command prompt and started at
C:\ Documents\settings\owner)
C:\Documents\setting\owner) cd\peq_db
C:\peq_db) MySQL -u root -p
Enter Password: ****
MySQL:) \u pew
Database Changed
MySQL:) Source Load_system.sql

Query OK, 0 rows affected (0.00 sec)
" "
" "
" "

Is there a way for me to check if they are being installed into the right place?

Are all these Versions compatible with peq_db?
-ActivePerl-5.10.0.1004-MSWin32-x86-287188
-EqEmu-0.7.0-129
-MiniLogin 6.2
-MySQL 5.0.67-win32
-MySQL-gui-tools-5.0-r12-win32
-Navicat8_mysql_en
-WinCvs2_0_2-4

what am i doing wrong?

[Sylaei]

Ok, first I don't think that EQEMU will work with perl 5.10, you need 5.8. Second look through these directions and see if you followed them to install the database. These directions are from http://www.eqemulator.net/wiki/wikka.php?wakka=Portable. I removed a few lines that don't apply to you but the main points are the same everywhere.

b. Open a Dos Window
2. Change Directory to c:\Peq_db\Peq_db. Or where ever you placed the database files.
3. mysql -u root -p
4. mysql will prompt you for a password. At this point the password is empty. Just press enter.
5. Enter the following to create and source the database.

create database peq;
\u peq
source load_player.sql


6. Wait for this to finish. It could be several minutes.
7. We need to extract the peq database from peqdb_XXXXx.sql.gz. Use 7ZipPortable to extract the file. Remember to replace the XXXXx with the version number of the database you are using. For example: peqdb_1128a.sql, that is the database I used.
8. Next source the database

source peqdb_XXXXx.sql


9. Wait for this to finish. It too could be several minutes.
10. Next we need to add a password to your database.

set password for 'root'@'localhost' = OLD_PASSWORD('newpwd');


Note: Make sure to replace newpwd with the password you want for your database.

Syl

[Lokymean]

I am having this identical errror.

when I enter
"source load_player.sql" it simply goes back to
-> and I cannot tell if it did anything. same with the source load.

I went into sqlyog(or heidisql) and populated the database there though instead of through the commadn line.

Does the db NEED to be named PEQ?

DO I need the referrence to eqemulator.net? Am I not hosting from my own server?
<!-- Loginserver information. -->
<loginserver>
<host>eqemulator.net</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>

[Sylaei]

When using mysql from the command line you have to end the line with a ; or else you get the prompt again and nothing happens.

No the database doesn't have to be called peq, you can call it anything you like.

Yes you are hosting your own server, just using eqemulator.net for the login. If you are playing on a lan you can use minilogin, but that has to be setup after the server is functioning.