PDA

View Full Version : HOWTO: Host a 6.0 Server on Windows (Perl Quests enabled!!)


Malignus Wingnut
09-30-2004, 02:11 PM
12/12/04 - Got a problem? Head on over to my new error post and tell me what it is. Link is:

http://www.eqemulator.net/forums/viewtopic.php?t=18921


11/3/04 - I've rewritten most of the guide, it should flow better now. As of now i would STRONLGY advise using the peq kunark database. Soon i will add an update on how to make any database 6.0 DR1 compatible, but until then, use kunark ^^.


COLOR CODES:

RED - Main steps
YELLOW - Substeps
CYAN (Light Blue) - Notes


MAIN STEP ONE - DOWNLOADS

1a) MySQL - used for database editing.

http://dev.mysql.com/get/Downloads/MySQL-4.0/mysql-4.0.23-win.zip/from/pick#mirrors


1b) EQEmu 6.0 - Perl Enabled

http://adam.eqemulator.net/11-09-04_Compiled_Perl.zip

1c) Loginserver.ini, Boot5zones.bat, and db.ini (EQEmuConfig.zip)

http://home.comcast.net/~molimo140/EQEmuConfig.zip




1d) Active Perl - Used for writing quests.

Perl 5.8 http://downloads.activestate.com/ActivePerl/Windows/5.8/ActivePerl-5.8.2.808-MSWin32-x86.msi

AND

NMAKE.EXE

http://home.comcast.net/~molimo140/NMAKE.EXE


1e) Databases:
Pick a database, the newest one is:

Kunark DB can be located at www.peqserver.com


1f)Default.pl
http://home.comcast.net/~molimo140/default.pl

1g)Plugin.pl
http://home.comcast.net/~molimo140/plugin.pl


1h) Additional Database Files

http://home.comcast.net/~molimo140/DBUpdate.zip



---------------------------------------------------------------
MAIN STEP TWO - INSTALLING OF STUFF

2a) Install MySQL, run the program I had you download.

2b) Extract the contents of 11-9-04_Compiled_Perl.zip to C:\eqemu

2c) Extract the contents of EQEmuConfig.zip to C:\eqemu

EDIT::Also copy spells_us.txt from your Everquest directory to C:\EQEmu.

2d) Install Perl 5.8

2e) Copy NMAKE.exe (downloaded above) into C:\perl\bin

2f) Install IO::Scalar

Open a Command Prompt (Start menu -> run -> type cmd -> hit enter

type

perl -MCPAN -e shell



It will ask you if you want to configure Manually. Say no.

RESTART YOUR COMPUTER BEFORE PROCEEDING.

When that is done type
install IO::Scalar


Once complete it will say Install OK (or something to that effect).

IF YOU GET AN ERROR MESSAGE saying it failed to install, It should say something at the bottom as an alternate method of installing IO::Scalar. Type what it says to. If that doesn't work.. I dont know, because by this point i had it installed successfully.

To make sure IO::Scalar is installed properly, type

perl -MIO::Scalar -e "print 'Installed'"



If it was installed properly, you should see the word "Intalled" on your command prompt.

wIf you are having trouble installing IO::Scalar, and you have typed 'make install IO::Scalar' into cmd prompt and it still refuses to install, visit http://search.cpan.org.

Search for Scalar.PM and WrapTie.PM (they should both be at the top of their search page when you search for them.) Download them. (You may have to copy the code from the website, paste it into notepad, and the select Save As (ALL FILES) and make sure to add the extension .PM to the end of the file name.

Copy both these files to your C:\perl\lib\io Directory and that should do it.

NOTE:: This is NOT fully tested and may/may not work for you.

2g) Copy necessary perl files
Copy Plugin.pl to your C:\EQEmu directory

Create a new folder in your eqemu directory called Quests.

Copy default.pl into the quests directory.




2h) Extract your database that you downloaded to C:\mysql\bin

2i) Extract the contents of DBUpdate.zip to C:\ mysql\bin.
-----------------------------------------------------

MAIN STEP THREE - MYSQL

3a) Go to C:\mysql\bin and run WinMySQLAdmin.exe

A window should pop up asking you for a username and a password. Pick both and write them down, you will need them later.

You can now close this.

3b) In C:\mysql\bin, run mysql.exe

Type into the window:

GRANT ALL PRIVILEGES ON *.* TO Username@localhost IDENTIFIED BY 'Password' WITH GRANT OPTION;



Replace Username with the username you selected above, and Password with the password you selected above.

It should say something like:

Query OK, 1 Rows Affected, (0.0)sec


Note: If you get an error when typing the grant all privileges line:

1) Make SURE you copied the line of code EXACTLY as written and changed username/password. (you need the ''s(apostrophes) around the password. 'example' not "example" or example.)

2) Try opening a command prompt. Type:

CD C:\mysql\bin


then type

mysql -u root mysql


And proceed to type the grant all privileges command again.
--------------------------------

Now type:

Create Database eq;



You can name your database whatever you want (Replace eq with whatever), however for simplicity I am using eq.

Should say

Query OK, 1 Rows Affected, (0.0)sec


Next type:

Use eq;



This sets what database is being currently used. All changes made will be made to the database that is being used.

Should say

Database Changed.




Now type:

source databasename.sql;



Replace databasename.sql with whatever the database you downloaded happens to be called.

Lots and lots of

Query OK, 1 Rows Affected, 0.0sec


Will fly by... Eventually it will stop.

Now we can type:

source dbupdate.sql;

More stuff flies by, finally it stops and at this point you can type:

quit


And it will close.



------------------------------------------------------------------

MAIN STEP FOUR - EQEmu Folder

4a) Go to c:\eqemu

4b)Open up DB.ini

Should look like this:
# READ README.TXT!

[Database]
host=localhost
user=MySQLUsername
password=MySQLPassword
database=databasename


### --- This file tells world.exe what computer mySQL is on. Host should
### --- be left "localhost" unless mysql is on a differant computer than world.exe.




where it says user= and password=, enter the username and password you selected when you ran winmysqladmin.exe

Where it says database=, enter the name of the database you created. If you followed this guide exactly, it should read database=eq.

Save and close.

4c)Open up LoginServer.ini

Looks like this:

### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.

### --- Public Login is un-supported as is LAN playing. We reccomend using the EQEmu.net Loginserver ALWAYS.

### --- NOTE: Starting 6-1-2002, you can no longer use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automaticly.

# READ README.TXT

[LoginServer]
loginserver=newlogin1.eqemulator.net
loginport=5994
worldname=ServerName
worldaddress=EXTERNAL_IP_ADDRESS
locked=false
account=
password=


[WorldServer]
Defaultstatus=0
Unavailzone=

[ChatChannelServer]
worldshortname=
chataddress=
chatport=



Where it says worldname=, enter the name of your server. Whatever is there is what will show up on server select. Do not put the word Server in your server name, it is automatically added.

Where it says worldaddress=, enter your EXTERNAL IP ADDRESS.

You can find this by going to www.whatismyip.com

Where it says locked=, enter either true or false. This controls whether or not your server shows up as LOCKED on server select. In the locked state, only GM-Admins or higher can log in.

Leave everything else in this file alone.

Save and close.

4d)Open up Boot5Zones.bat, should look like this:

REM: ****Read this first!!!****

REM: This file requires your real IP in the place of "YourIP" when you are connecting
REM: To the EQEmu Loginserver.

REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1

REM: If you still get errors try using localhost instead of 127.0.0.1

REM:--------------Start-----------------------
@echo off

if NOT exist spells_us.txt goto NOSPELL

start zone . EXTERNAL_IP_ADDRESS 7995 INTERNAL_IP_ADDRESS
start zone . EXTERNAL_IP_ADDRESS 7996 INTERNAL_IP_ADDRESS
start zone . EXTERNAL_IP_ADDRESS 7997 INTERNAL_IP_ADDRESS
start zone . EXTERNAL_IP_ADDRESS 7998 INTERNAL_IP_ADDRESS
start zone . EXTERNAL_IP_ADDRESS 7999 INTERNAL_IP_ADDRESS
exit
cls

:NOSPELL
echo You did not copy the spells_us.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE

REM:---------------END------------------------


Replace EXTERNALIP with your external ip address (www.whatismyip.com)

Replace INTERNALIP with your Internal IP address.

To find your internal ip address, open start menu, click on run, type cmd, hit return. When the command prompt comes up, type ipconfig, and hit enter. You will see several things:

IP Address.....................................192.16 8.x.x
Subnet Mask...................................255.255.255 .0
Default Gateway.............................192.169.0.1

Not necessarily in that order. Where it says IP Address, this is your internal ip address.

After you have made those changes,save and close.


-----------------------------------------------------------------------

MAIN STEP FIVE - STARTING YOUR SERVER

5a)Run World.exe in your C:\eqemu folder.

5b)Run Boot5Zones.BAT.

5c) Let them both run...log in and you're ready to connect.

(Make sure your eqhost.txt file is correct (in your Everquest directory. It should read:


[Loginserver]
host=newlogin1.eqemulator.net:5994



---------------------------------------------------------------

Final Notes

IF YOU ARE BEHIND A ROUTER, VIEW THIS THREAD:

http://www.eqemulator.net/forums/viewtopic.php?t=16747

To set yourself as a GM. Log into your server, at least once, dont have to create a character, then log out. Open up a command prompt (start -> run -> type cmd -> hit enter)

type

cd c:\eqemu



then

world.exe flag Username Status



Replace Username with your EQEmu server name (the one you use to log into server select with)

Replace Status with one of the following:

0 - Legit
10 - Semi-Legit
20 - Non-Legit
60 - Guide
80 - GM-Quest Troupe
100 - GM-Admin
150 - GM-Lead Admin
200 - GM-Mgmt <--- SERVER OP, the one you want for yourself.


That's it. As far as I know this works as of today... Any questions / comments / concerns...post below.

Chrysm
10-18-2004, 07:34 PM
Ok, I followed this guide and it still did not work... when I made the char and tried to enter world, it dropped me.

Here is what I did to fix:
(this assumes you have fresh database etc and are starting from scratch)

Install the eqemu 6.0-DR1
Modify your files etc as stated before
now for the database part of it


source all this stuff
(don't forget use eq;)
Step 1. Download ProjectEQ's 5.8 Classic database from http://www.projecteq.net
Step 2. Source that file into your database.
Step 3. http://www.eqemulator.net/sql/aa_levels.sql
Step 4. http://www.eqemulator.net/sql/altadv_vars.sql
Step 5. http://www.eqemulator.net/sql/wr_update.sql
Step 6. http://www.eqemulator.net/sql/aa_actions.sql
Step 7. http://www.eqemulator.net/sql/aa_swarmpets.sql
Step 8. http://www.eqemulator.net/sql/fishing.sql
Step 9. http://www.eqemulator.net/sql/timers.sql
Step 10. http://www.eqemulator.net/sql/traps.sql
Step 11. ALTER TABLE items ADD attuneable tinyint(3) unsigned NOT NULL default '0';

Step 12. ALTER TABLE items CHANGE 'unknown008' 'SpellCharges' INT(11) DEFAULT '0' NOT NULL;

If you are using minilogin source this

Step 13. INSERT INTO variables (varname, value, information) VALUES ('LoginType', 'Minilogin', 'Set this to Minilogin to login using a minilogin server :)');

Step 14. alter table account add minilogin_ip varchar(32) not null;

Step 15. insert into account (name,status, minilogin_ip) values('THE_NAME_YOU_USE_TO_LOG_IN', 250, 'IP_OF_COMP_RUNNING_EQ');

Ok, now to enable the expansions:

Step 16. update variables set value=255 where varname like 'expansions';

Don't worry about errors saying something already exists, at least you know it's there heh... better than missing something.

Ok, so what I did was start minilogin, world.exe and wait for it to say connected to login server 127.0.0.1:5999, then boot5zone.bat ... Here is where I tried to log in early and kept getting error 1017... you have to wait for all 5 zones to go into sleep mode... then you can log in. Log in make your char AND MAKE SURE NOT TO SELECT TUTORIAL!! Uncheck that or you will freeze up and have to reboot and start the minlogin etc over again.

Make your char log in, and enjoy

Muuss
12-15-2004, 10:19 PM
Unless a senor dev contradicts me, I would like to see the privileges granting modified in the 2 tutorials that explain how to setup a server.

Granting all privileges on *.* is almost like creating a new root acount.
It's giving rights to the eqemu user on all the DBs of your server. This may allow him to create new mysql accounts, flush privileges, drop some databases, create new ones...
We certainly don't need this. It may be inoffensive on private lan servers, but a terrible breach on public servers where almost stranger are given rights on the database.

Please correct this by according the rights only on the eqemu database. Mysql documentations and the post i made on howto install a linux server contain this. (basically, create the eq db first, then give rights on it after).

Kakraaz
01-17-2005, 12:48 PM
is it possible to make a new account on mysql or delete your old one? i used it along time ago and forgot my password...(im on main step 3 on the grant privileges part) and i have already tried uninstalling it and reinstalling it...it saves my acct...

Malignus Wingnut
01-17-2005, 02:04 PM
1) Post your error in the ERROR GUIDE...that's what it's for.

Secondly, find my.ini located in c:\windows\, delete this file, run winmysqladmin.exe again and you can pick a new user/pw.

Malignus Wingnut
03-02-2005, 03:43 AM
3/2/05 - I'm back, and I've returned to the EQEmu project. I know everyone is having trouble installing IO::Scalar, and I've had to recently wipe my computer twice now....anyways, when i went back to set my server back up, I had all of the same problems that you guys had, IO::Scalar would install, i would get the "Installed" message when running the line of code, but I would get that damn wraptie error. All i can say to you people, is one day when i finally decided to try again, I uninstalled perl completely, deleted the folder, and re installed, the install worked. Here's EXACTLY what i did.

1) Install perl 5.8
2) Skip to step 2e) in the real guide.
3) RUN NMAKE.EXE IN YOUR PERL/BIN FOLDER BEFORE PROCEEDING
4) Follow step 2f)
5) DO NOT RESTART COMPUTER AFTER TYPING Perl -MCPAN -e shell AND INSTALLING AUTOMATICALLY. SKIP DIRECTLY TO THE install IO::Scalar COMMAND!!

No guarantees on this one guys, just my experience.

And just a note if you're wondering why my reply is here, its cuz my post up top is too long ^^.

sysadmin
03-02-2005, 04:47 AM
The problem begins at:

RESTART YOUR COMPUTER BEFORE PROCEEDING

Solution is to add this line AFTER reboot:

perl -MCPAN -e shell

before this line:

install IO::Scalar

ndnet
03-03-2005, 07:34 PM
If the IO::Scalar automated BS is messing up for you, here's an alternative method of installing IO::Scalar.

Visit http://cpan.uwinnipeg.ca/module/IO::Scalar - Click the "Download" link next to IO-Stringy (IO::Scalar's parent package)

Extract the file somewhere memorable. Open a command window (Start->Run->"cmd") and navigate to the folder including it (e.g. "cd \perl\IO-stringy-2.110\").

Now that you're in the folder, execute these commands:


perl Makefile.PL
nmake
nmake test
nmake install

RangerDown
03-11-2005, 02:06 PM
The link to download the Kunark database (www.peqserver.com) is no longer valid.

The kunark database should be downloaded from www.projecteq.net.

Daften
03-12-2005, 10:16 AM
I followed the directions exactly as stated but at the very last step(always has to happen at the end, eh? ;-)) when I open Boot5zones.bat 5 zones are automatically opened and I don't get to replace my internal nor external IP. So when I log in, I see my server however I am not able to log into it because it's locked. (I've tried saving "true" and "false" in my eqemu directory, and each time I log in and reboot World.exe and Boot5zones.bat it still shows up as locked.)

Any suggestions? Thanks in advance.

tallerin
03-12-2005, 10:57 AM
For the boot 5 zones right click it then select edit NOT open then change the int/ext ips. for the locked server might be from the wrong ip's in the boot 5 zones but dunno for sure worked flawlessly for me.

Daften
03-12-2005, 11:23 AM
Okay, thanks. I dunno how I could have missed the edit :-)

My server is now "up" But I can't log into it. I'm on a router >_< *sigh* another tutorial to go through,eh? :)

Malignus Wingnut
03-13-2005, 07:32 AM
There is a link to the router guide that I made a while ago...look at the guide.

raistlinist
03-18-2005, 12:16 PM
hi all, i got a problem and a need help, thx in advance i really want to play eq :)

im stuck at the main step 3 when i ran winsqladmins...exe i wrote a pass n username lets say username : bob and password : wayhne

and when i type GRANT ALL PRIVILEGES ON *.* TO bob@localhost IDENTIFIED BY 'wayhne' WITH GRANT OPTION; in mysql.exe i doesnt work

it says error 1045 : Acces denied for user @localhost' <Using password : NO>
i tried to type CD C:\mysql\bin and its not working for me maybe i misunderstood
something or scalar isnt installed properly ... HELP PLZ ! i want to play sniff...:(

Malignus Wingnut
03-18-2005, 03:58 PM
You see the thing is...99% of people who follow my guide get stuck because they DO NOT read every step in detail. I suggest you go back, and read the optional troubleshooting guide to the grant all privileges option... It clearly states what to do.

Make sure you have typed everything properly, be assured there are no typos.

Finally, the lines of code (CD c:\.....) DO NOT apply to everyone. Some people have a newer version of MySQL which installs defaultly to c:\program files\mysql instead of just c:\mysql. Be sure that YOU know where YOUR copies of programs are installed and use your brain and replace lines of code with what suits your configuration.

Sakrateri
03-22-2005, 01:58 AM
LoL ....nm i had a brain infunction !

hellkat138
03-24-2005, 08:47 AM
ok here is my issue i followed everything exactly but when i run eq i am not seeing my server in the list where did i go wrong I'm thinking when i try to login it overwrites the eqhost.txt file is there a way to stop that? I also tried to trick and waitied till i logged in and changed the host file and then i got a timeout error the link that was posted for router setup is dead so if anyone can help i would appreciate it

hellkat138
03-24-2005, 01:56 PM
ok here is what the bat5zones file output is

[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-DR2
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading loot tables
[Status] Loading doors
[Status] Loading guilds
[Status] Loading factions
[Status] Loading AA effects
[Status] Loading swarm spells
[Status] Loading tributes
[Status] Loading corpse timers
[Status] Loading what ever is left
Couldn't open './addon.ini'.
[Status] Loading commands
[Status] 176 commands loaded
[Status] Loading embedded perl XS
[Quest] Loading perlemb plugins.
[Quest] Loading perl commands...
[Quest] Warning - commands.pl: Perl runtime error: Unrecognized character \xEF a
t (eval 19) line 1.

[Error] Starting command queue Mapping...

[Quest] Loading perlemb plugins.
[Quest] Loading perl commands...
[Quest] Warning - commands.pl: Perl runtime error: Unrecognized character \xEF a
t (eval 19) line 1.

[Status] Entering sleep mode
Connected to worldserver: 192.168.1.100:9000


and here is the world,exe

[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR2
[Status] Loading variables..
[Status] Loading zones..
[Status] Clearing groups..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
Couldn't open './addon.ini'.
[Status] Loading EQ time of day..
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Formatting drive C:
TCP listening on: 69.149.60.84:9000
World server listening on: 69.149.60.84:9000
Connected to LoginServer: newlogin1.eqemulator.net:5994
4857 New TCP connection: 192.168.1.100:1973
New zoneserver: #1 192.168.1.100:1973
Zoneserver SetConnectInfo: 192.168.1.100:1973: 69.149.60.84:7999
5468 New TCP connection: 192.168.1.100:1974
5468 New TCP connection: 192.168.1.100:1975
5468 New TCP connection: 192.168.1.100:1976
5468 New TCP connection: 192.168.1.100:1977
New zoneserver: #2 192.168.1.100:1977
New zoneserver: #3 192.168.1.100:1976
New zoneserver: #4 192.168.1.100:1975
New zoneserver: #5 192.168.1.100:1974
Zoneserver SetConnectInfo: 192.168.1.100:1974: 69.149.60.84:7997
Zoneserver SetConnectInfo: 192.168.1.100:1975: 69.149.60.84:7995
Zoneserver SetConnectInfo: 192.168.1.100:1976: 69.149.60.84:7996
Zoneserver SetConnectInfo: 192.168.1.100:1977: 69.149.60.84:7998
81116 New TCP connection: 192.168.1.100:2055
New zoneserver: #6 192.168.1.100:2055
Zoneserver SetConnectInfo: 192.168.1.100:2055: 69.149.60.84:7999

i keep gettin a timeout error what do i do?

mt-mug
03-26-2005, 08:18 AM
The link to download the Kunark database (www.peqserver.com) is no longer valid.

The kunark database should be downloaded from www.projecteq.net.


I used the Db from there and have my server up. wasnt to bad but I cant zone when I try it just sends me back to start point. It doesnt save my items or my Char levels. And it didnt seem to load any spells or NPC I can spawn ... other than that it is working great . This setup guild was fast and easy even for a novice wanting to learn more about SQl:)

SiezeALL
03-26-2005, 07:27 PM
I wouldn't post here but the link to the Error thread gives me a 404 error, so here it is.

I have mysql installed (though it's irrelevant at this point.)
I have Perl 5.8.2 installed
I have NMAKE.exe in c:\perl\bin

I open up the command prompt and type in perl -MCPAN -e shell.
It tells me some junk and i tell it no to the manual configuration.

It does some more stuff and then leaves me at cpan> for a prompt.

so I type in install IO::Scalar, works great til the end...

"IBM(R) Program Maintenance Utility for Windows(R)
Version 3.50.000 Feb 13 1996
Copyright (C) IBM Corporation 1988-1995
Copyright (C) Microsoft Corp. 1988-1991
All rights reserved.

@ C:\Perl\bin\perl.exe "-MExtUtils::Command" -e mkpath blib\lib\IO
NMAKE : fatal error U1081: '@' : program not found
Stop.
C:\PERL\BIN\nmake.exe -- NOT OK
Running make test
Can't test without successful make
Running make install
make had returned bad status, install seems impossible

cpan>"

Anyone have any ideas, please? Is there a way to get rid of the @ before the C:\perl\bin\perl.exe?

Thanks in advance


--- Edit: I tried it on my windows xp pro machine and it worked flawlessly. Am I correct in assuming this doesn't work for windows 98? /grin The code above was from my 98 machine.

SiezeALL
03-26-2005, 07:34 PM
BTW, hellkat you can make eqhost read only. just right click, properties, check Read only and click apply.

JerHoo
03-30-2005, 12:36 PM
Okay i see my server on the list and its unlocked.. but, when i try to log into it... it gives me error 1017:cannot login to the everquest server. You may need to re-run the patch update ect... but when i try to log into other servers same verison it works any ideas?

leonskennedy
04-15-2005, 10:01 AM
Yeah, I cant make it work.

On the 'grant all options' part, It says

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

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

mysql> GRANT ALL PRIVILEGES ON *.* TO ______@localhost IDENTIFIED BY '_____' WITH GRANT OPTION;
ERROR 1045: Access denied for user: '@localhost' (Using password: NO)
mysql>


Rest assured my mysql is in c:\mysql\bin and thats what i put. Any help?

sysadmin
04-15-2005, 11:27 AM
try 127.0.0.1 instead of localhost

leonskennedy
04-16-2005, 07:51 AM
Its still saying the same thing... :-(

Cutter
04-20-2005, 05:34 AM
here is what i did... instead of typing all those commands..

i downloaded a program called front mysql

i use it alot to edit my database anyways..

once you get it launched...
you can goto users.. right click on the name
properties.. and you can edit the permissions .. which would include "grant"

this works..

everything you do in a command prompt you can do with this program...

just a thought and hope it helps out.. i just found this much easier to work with and this is how i got by that annoying error message

newtonform
04-22-2005, 04:12 AM
1) Post your error in the ERROR GUIDE...that's what it's for.

Secondly, find my.ini located in c:\windows\, delete this file, run winmysqladmin.exe again and you can pick a new user/pw.

We too. I delete my.ini file, run winmysqladmin.exe again,type a new user/pw,run mysql.exe type
GRANT ALL PRIVILEGES ON *.* TO myuser@localhost IDENTIFIED BY 'mypw' WITH GRANT OPTION;

but it display:
error 1045:access denied for user: '@localhost' (Using password:NO)

Malignus Wingnut
04-24-2005, 05:50 AM
Okay, you guys obviously aren't reading my guide. Note the section about your problem.

Note: If you get an error when typing the grant all privileges line:

1) Make SURE you copied the line of code EXACTLY as written and changed username/password. (you need the ''s(apostrophes) around the password. 'example' not "example" or example.)

2) Try opening a command prompt. Type:


CD C:\mysql\bin



then type



mysql -u root mysql




And proceed to type the grant all privileges command again.


------------------------------------------------

It's clearly stated in a different color, including code examples, on how to fix your problem.

My adivce, READ THE GUIDE THOURGOUGHLY!!

BArnett
05-01-2005, 10:29 AM
Is there a way to keep it from patching? Evertime I follow the directions step by step it starts patching on me

Luean
05-02-2005, 06:11 AM
I get:
ERROR 1045: Access denied for user: '@localhost' (Using password: NO)
too.

I get the same error when i try "mysql -u root mysql".
Reinstalled it about 5 times.
What could it be?

Malignus Wingnut
05-03-2005, 04:25 PM
Probably a typo... please copy + paste from the actual window.

@ BArnett - yes. locate your eqgame.exe file in your everquest folder. remember the path name (something like "c:\program files\sony\everquest trilogy\eqgame.exe")

Make a shortcut to this file, and in the target line, make sure the target is:

"C:\Program Files\Sony\EverQuest Trilogy\eqgame.exe" patchme

NOTE: your folders may be different, but still, put the target in quotes, and then press the spacebar once after the end quote and add "patchme" - make sure there are no extra spaces and that the patchme is outside of the quotes. this will now skip the patcher.

bouzi567
05-06-2005, 06:27 PM
i got a wierd problem it seems i installed everythin and got stuck on the io:scalar file.......got past it and installed it and checked to see if it was in fact installed and it said it was got to the end of guide and i did run world.exe and boot5zone thing and all was good loading till zone windows at the end said error initializing perlembed: failed to install plugin printhook, do you lack io:scalar? ///// then it said one more after that saying fatal error initializing perl: failed to install plugin printhook, do you lack io:scalar?/////what do i do or miss???

ModemMisuser
05-09-2005, 11:31 PM
ProjectEQ.net is DOA, is it coming back, or is there another spot to get the database scripts from?

Belfedia
05-13-2005, 12:45 PM
http://www.Projecteq.net is back :) and i hope for long time :p

yyewman
05-20-2005, 07:53 PM
1-09-04_Compiled_Perl.zip link is dead

Is there another mirror?

Thanks

Iamien
05-31-2005, 12:38 PM
I to am looking for a mirror to the mirrored 6.0 DR2 Compiled download

Ghost Fire
05-31-2005, 02:34 PM
Is this what your looking for? (http://sourceforge.net/project/showfiles.php?group_id=88515&package_id=128352)

Iamien
05-31-2005, 03:11 PM
yes thank you any now maybe a mod wil update the link in the tutorial?

Aydun
06-27-2005, 02:05 PM
Greetings ! ok , as to the guy or anyone for that matter whoe xperience the following problem..
you successfully install IO::Scalar, but you get the boot5zones error .. , if you notice in your c: directory or wherever you have the main perl folder, NOT INSIDE OF IT but in the same directory as your perl folder.. you will see one called .cpan
in there is everything you installed when you use the install IO::Scalar using the -MCPAN .. you were basically making a new folder called cpan to install it all to .. so what you do is go insid ethe folder, until you find the one with like lib and such (it will look like a bunch of the same folders in the ACTUAL perl folder) and you paste those i nto your perl folder, overlapping all files .. then it will run flawlessly :D, except for commands.pl error which is irrelevant ! if you have questions, still I'll attempt to assist !

Good luck :D

Mutamu
08-28-2005, 01:59 AM
hokay, ive done all in the guide (im pretty sure ive done everything as ive reead through and checked everything about 5 times) and world.exe and the zone programs work, but when i try to log in i get a "timeout" error, whats the prob?

ubatch
08-29-2005, 01:58 PM
Here's my files first so we can get that out of the way, then i'll ask a simple question that hopefully you guys can answer...My first server, so please dont bash! :)

EQHOST.TXT
[LoginServer]
Host=eqemulator.net:5998


DB.INI
# READ README.TXT!
[Database]
host=localhost
user=******
password=****
database=eq

### --- This file tells world.exe what computer mySQL is on. Host should
### --- be left "localhost" unless mysql is on a differant computer than world.exe

LOGINSERVER.INI
### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.
### --- Public Login is un-supported as is LAN playing. We reccomend using the EQEmu.net Loginserver ALWAYS.
### --- NOTE: Starting 6-1-2002, you can no longer use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automaticly.
# READ README.TXT
[LoginServer]
loginserver=eqemulator.net
loginport=5994
worldname=JustTestingThanks
worldaddress=70.240.135.110
locked=false
account=
password=

[WorldServer]
Defaultstatus=0
Unavailzone=
[ChatChannelServer]
worldshortname=
chataddress=
chatport=


And finally,

Boot5Zones.BAT
REM: ****Read this first!!!****
REM: This file requires your real IP in the place of "YourIP" when you are connecting
REM: To the EQEmu Loginserver.
REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1
REM: If you still get errors try using localhost instead of 127.0.0.1
REM:--------------Start-----------------------
@echo off
if NOT exist spells_us.txt goto NOSPELL
start zoneperl . 70.240.135.110 7995 70.240.135.110
start zoneperl . 70.240.135.110 7996 70.240.135.110
start zoneperl . 70.240.135.110 7997 70.240.135.110
start zoneperl . 70.240.135.110 7998 70.240.135.110
start zoneperl . 70.240.135.110 7999 70.240.135.110
exit
cls
:NOSPELL
echo You did not copy the spells_us.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE
REM:---------------END------------------------


That's basically all...

If you see an issue, let me know...I'll try it.

Everything connects fine to eqemu, but again I dont see my server called "JustTestingThanks Server" on there...any help would be appreciated.

Dr Zauis
08-29-2005, 02:19 PM
It seems to me like your eqhost is on port 5998 and you are creating a 5994 type server. I dont know anything about a 6.0 type server but if you are sure thats the version client you have then try changing eqhost to port 5994.

ubatch
08-29-2005, 02:28 PM
It seems to me like your eqhost is on port 5998 and you are creating a 5994 type server. I dont know anything about a 6.0 type server but if you are sure thats the version client you have then try changing eqhost to port 5994.

Ok, now it's hanging at "Logging in to the server. Please wait..."

When you log in to the server, is there any activity in the World.exe window or zone windows? I'm getting none, hehe...Again, its not going into the server select at all =/

Dr Zauis
08-29-2005, 04:16 PM
Ok, now it's hanging at "Logging in to the server. Please wait..."

When you log in to the server, is there any activity in the World.exe window or zone windows? I'm getting none, hehe...Again, its not going into the server select at all =/

world.exe should say something like new client logging in on blablabla..
So you should see yourself trying to log in..So maybe your server isnt "hearing" you at all. Maybe check your port settings in login and 5bootzones.
I run everything localhost and just set my server to public. But thats me. Thats not really the right way but it works.

EDIT>>Thats how a 6.1 looks. I dont really know what a 6.0 says but I suspect the same thing(new client logging in/ect...).

Malignus Wingnut
08-30-2005, 08:24 AM
Uhh yeah hey guys. It's been a long time since I've been around. I've been playing WoW recently, and I haven't worked on eqemu in such a long time. I'd like to get my setup guide back up to date, so if anyone can you know, PM me with what the most up to date and compatable database(s) are, what the new loginserver port/address is, then I'll work on getting my guide up to date (most likely a .pdf or .doc file which I will host for download on my website.