Creating a private EQemu server

[deez2255]

hello i am wanting to make a private everquest 1 server so i can play or i can have me and my fiance play together only. i followed a link and it got me the below information. it told me to download eq titanium. so i did. i burned it to 5 discs perfectly. I think mainly what i am needing to download is the right EQEMU client. or database to get started. see below for what i needed to do. after burning the discs for an example. but as i said i really only need a working link to an eqemu server pack which i can install my self and play alone or with her. this was the full information..


nstallation instructions:

1. Install EverQuest Titanium.

2. Install Perl

3. Install MySQL (Remember the password you created for the root user, you'll need it later)

4. REBOOT your computer.

5. Run the EQEmu Installer, please be sure to give it the proper location of your EQ client and of MySQL both of which you just installed.

6. Select your options - the default is fine for most people. Minilogin is a local only server, and Public is of course open to the public.

7. When the DOS prompt asks for your root password, give it the one you created above during the MySQL installation.


MySQL version MUST be 5.0. NOT 4.0, 4.1, or 5.1. You can get it here: http://dev.mysql.com/get/Downloads/M...net/pub/mysql/

Perl can be found here: http://downloads.activestate.com/Act...x86-211909.msi

Installing both the database and minilogin server type will create a username called mini, password mini that can be used to log into your server. Also, this installer will configure minilogin for localhost ONLY. (Meaning the server and client must be on the same machine.) If you wish to play over a private network, you must make additional changes after the installer completes. Instructions can be found on the EQEmu forums. This does not effect Public at all, provided you do not have a firewall conflict, other people should be able to connect to you without issue.

*Please note that the uninstall program will DESTORY the DATABASE it creates without warning. If you do not wish to lose your database, please back it up or rename it before uninstalling the Server Pack.*

ProjectEQ: http://www.projecteq.net (Database, quests/scripts, this installer.)
EQEmulator http://www.eqemulator.net (Game server, login server for public installs.)

EQEmu version: 0.7.0-1110-peq (virtually all submissions on EQEmu forums, #peqzone, and a few other things we have on Grand Creation)
EQoffline version: 1110-peq
PEQ DB version: 1110a

[deez2255]

so as said in post to fully clarify i need the right EQEmu Installer to go with the eq titanium i downloaded

[Uleat]

We don't currently support any installers here... However, there are a few around that people may have external links to.

Someone may be able to provide a link to a working one..but, I don't know of any at the moment...


That being said..you don't need an installer to actually run a server.

I think someone recently uploaded some up-to-date precompiled binaries and the d-i-y guide is fairly recent and pretty thorough.

It can be found here: http://wiki.eqemulator.org/p?Complet...Guide&frm=Main

[deez2255]

Awesome! thanks alot this is exactly what i most likely need!. is there going to be any settings in here where i can let my fiance play as well? maybe copy all of the settings over onto a different computer, make a seperate account like i did on wow and it was good to go? or is there something else i have to do to allow her and only her to play...or maybe several friends. lol

[Nightrider84]

Well basically the difference between a public login and a private login is really just a couple files that get sourced into your database once you get the server setup. Its not too hard really. Basically if you follow the guide on the wiki make sure you compile with the login. It will be in the list in the cmake part of the setup. And you will need to make sure you add accounts to the server as well. But the best thing to do is follow the wiki and get it setup first and then we can help you make it private if you are still having problems or can't figure it out

[deez2255]

i am having trouble. i have made it to this part. where it all says c) Now it is time to create the database.

The following assumes you have used my tip to rename the files to something easier to type!
Launch a command prompt window and navigate to your C:\EQ\SQL folder by typing:
cd c:\EQ\SQL

Then enter mysql -uroot -ppassword where password is the password you chose when installing MySQL.
You should be presented with a mysql> prompt. If you do not, and it says it cannot find "mysql" please refer to (link) Adding MySql to your "Path"
Assuming you are now logged in, you can now create your database.
Type:
create database peq;
and press enter.

The following ensures any commands you use next will apply to this new database:-
Type:
use peq;
and press enter.

Note: Now that the database is created anytime you need to login to MySQL in the future, you can do it with a single line command:

mysql -uroot -pyourpassword peq

Type:
source peqbeta.sql;
and press enter.

This may take a while to complete, depending on how powerful your PC is.

When the mysql> prompt returns:

Type:
source player_tables.sql;
and press enter.

(OPTIONAL) If you plan on using Bots, also do the following:

Type:
source load_bots.sql;
and press enter.

(OPTIONAL) If you plan on using mercenaries, follow this seperate guide located here.




when i get to use peq; i hit enter, it says database changed. and still shows mysql> so then i try typing mysql -uroot -root peq which root was my password. and it does nothing. then if i try to go to the next step and type source peqbeta.sql; it gives me a 1064 error. how can i fix this? i really hjave no experience with command prompt or mysql. i tryed using a normal command prompt it wouldnt change over to the other directory, i tryed using the mysql command line program. and it got me to the 1064 error. any help would be great

[deez2255]

really want to get this server up and running tonight!

[werebat]

1064 means you have a syntax error. Also, after use peq, you source your files in. The line about MySQL is for future reference. Make sure you read it carefully, mistakes are hard to track.

I built my private server using the wiki, the only thing I did different is use minilogin instead if the login server but either way will work.

[deez2255]

how do i fix the sintax 1064 error.. so i just ignore the whole creating the data base per say or?. i am really stumped. i am really going to need someone to break it down step by step the entire step where i have to create a database. the way im reading it i dont understand.

[deez2255]

i need it explained in a simpler form. but really exact. if that makes sense.

[Nightrider84]

ok ill see what I can do here. use the regular command promt

1. login to mysql. Mysql -uusername -ppassword (whatever your user and pass is)
2. type cd c:\EQ\SQL
3. type. use peq
4. type. source peqbeta.sql without the ;

start with that first and see if you get an error. if you dont get any errors continue with the wiki until your done and hopefully you wont get anymore issues.

[deez2255]

lol i cannot even seem to find mysql. will it run on windows 8 enterprise? thats what im running on. 64 bit. if so. what is the actual client called is it mysql? theres alot of em popping up. not sure which to actually click on. might need a little further break down of this mysql location thing.

[deez2255]

i also downloaded heidisql but i dont think i even did anything with it.

[deez2255]

honestly i do not know anything about my sql. i know i created some user root password. but cannot even remember where

[Nightrider84]

OK man open up a command promt and type what I posted earlier mysql isn't a program you open. If your at this point in the wiki then you already have mysql installed