Creating a private EQemu server [Archive]

View Full Version : Creating a private EQemu server

deez2255

07-13-2014, 01:11 PM

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

07-13-2014, 01:13 PM

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

Uleat

07-13-2014, 10:31 PM

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?Complete_Windows-based_Server_Setup_Guide&frm=Main

deez2255

07-14-2014, 01:50 PM

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

07-14-2014, 05:22 PM

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

07-14-2014, 06:56 PM

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

07-14-2014, 07:26 PM

really want to get this server up and running tonight!

werebat

07-14-2014, 07:51 PM

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

07-14-2014, 07:56 PM

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

07-14-2014, 07:57 PM

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

Nightrider84

07-14-2014, 09:26 PM

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

07-14-2014, 10:25 PM

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

07-14-2014, 10:28 PM

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

deez2255

07-14-2014, 10:48 PM

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

Nightrider84

07-14-2014, 11:13 PM

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

deez2255

07-14-2014, 11:18 PM

e:\users\elderin council>cd c:\eq\sql. type that it does not switch from E to C.

E:users\elderin council> use peq; or use peq. tryed both. says is not recognized as an internal or external command. operable program or batch file. tryed also

E:\users\elderin council> source peqbeta.sql

gives the same error.. what now? thanks for all the help so far guys.

Scorpious2k

07-14-2014, 11:31 PM

Try this:

C:
cd \eq\sql
mysql -uuser -ppassword
create database eq;
use eq;
source peqbeta.sql;
exit

where -uuser is -u followed by the user (root?) and -ppassword is -p followed by the password

after the mysql command your prompt should change to mysql> after the exit it should go back to what it was before

I think there are more things to source for you, but see if this works first

edit: the semicolons are important! be sure to type them - also after the source you should see a lot of things scrolling in the window, this is normal. wait for the mysql> prompt. It will appear when it finishes

deez2255

07-14-2014, 11:40 PM

Nice Scorp! that did it! i am now awaiting after i typed in source peqbeta.sql; i will update you guys later on how it went! Thanks a bunch!!

Scorpious2k

07-14-2014, 11:59 PM

You're welcome. As I recall there are other files to source since this is your first time. Check the tutorial. You can do them after the one that is running and before you type exit

deez2255

07-15-2014, 12:51 PM

hello again. i am really new to this. i am having trouble of step 7 of the guide. this one. You must now edit the config file or your server will not work. The following wiki page has a full explanation of the file and what it's contents mean http://wiki.eqemulator.org/p?eqemu_config.xml&frm=Main , please follow that page as to how to edit your config file and then return to this page to move onto step 7. c)

i go to the website. i see all of the writing such as this.

Before you begin
The recommended way to configure your server is to start with the minimum configuration and add in only the sections of the config that you want to change away from the defaults.
Most of the settings you will not have a need to change. If you think you do, you are probably wrong. If you really think you do, you are probably still wrong. But, just in case, we'll go over them all.
I'll walk through two configuration files. First, a minimal configuration which will probably work for 99.9% of you and then a full configuration to show and describer all the available settings. If you are looking to get your server up fast, use the minimal/recommneded config.
*Minimal/Recommened Configuration

Here is the recommended minimum configuration file that you could use to get your server up and running.

This XML should be in eqemu_config.xml in the same directory that you start world / eqlaunch / zone from.

?
1
2
3
4
5
6
7
8
9
10

<server>
<world>
<shortname>setme</shortname>
<longname>I Forgot To Edit My Config</longname>


<key>some long random string</key>
</world>
</server>
A few notes on the above config:

The element is not, technically, required. But, it is recommaned as it will prevent unauthorized zones and launchers from connecting to your world server.
Since there is no element (see , below) it's assumed that there is a mysql user called "eq" with a password of "eq" and that your database is called "eq".
You'll notice that there is nothing setting the address of your server. This is on purpose. (see, Addresses, below)
*Full Configuration

Here is a full configuration file example. An up to date version of this config file is hopefully always avaliable in the source code in utils/defaults/eqemu_config.xml.full.
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82

<server>
<world>
<shortname>setme</shortname>
<longname>I Forgot To Edit My Config</longname>






<loginserver>
<host>login.eqemulator.net</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>






<tcp ip="localhost" port="9000" telnet="disable">


<key>some long random string</key>


<http enabled="false" mimefile="mime.types" port="9080">
</http></tcp></world>


<chatserver>
<host>channels.eqemulator.net</host>
<port>7778</port>
</chatserver>


<mailserver>
<host>channels.eqemulator.net</host>
<port>7779</port>
</mailserver>

<zones>
<defaultstatus>20</defaultstatus>


<ports high="7100" low="7000">
</ports></zones>


<database>
<host>localhost</host>
<port>3306</port>
<username>eq</username>
<password>eq</password>
<db>eq</db>
</database>


<launcher>




</launcher>


<files>




</files>

<directories>



</directories>
</server>
*Elements
*
These are the xml entries that can be inside the tags. If they are not there, the shown defaults will be used.
?
1
2
3
4
5
<shortname> and <longname>
<world>
<shortname>setme</shortname>
<longname>I Forgot To Edit My Config</longname>
</world></longname></shortname>
These are really the two main items in world that you need to set, the others will default to values that are probably correct. Shortname will be used for things like chat channels, client side log and ini file names.
?
1

and
These two should not need to be set. If you think you need to, you are probably wrong. If you really, really think you need to, you are probably still wrong. But, just in case they are here.
World discovers its local address when it connects to the loginserver and provides to the loginserver so it can tell local clients to use the internal address. When world connects to the loginserver, the loginserver tells world what it sees for it's external address so world can tell remote clients what IP to use for connecting to zones from the outside.
Confusing? Maybe. The important thing is, it works. Let it do it's job.
*

?
1
2
3
4
5
6
7
8
9
<world>

<loginserver>
<host>login.eqemulator.net</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>
</world>
These should not need to be set except in the case if you have an loginserver account for your server, then you should only need to set the account/password values. If you leave the host/port settings out, they will default to what is shown above. When in doubt, leave it out.
* and

?
1
2
3
4
5
<world>



</world>
You can probably figure these out for yourself. Left for an excercise for the reader (thats you).
*

?
1
2
3
4
<world>

<tcp ip="localhost" port="9000" telnet="disable">
</tcp></world>
This is where you can change the port that world listens on for TCP connections for the zones to connect to and for the telnet console. Telnet is disabled by default and I'd consider leaving it that way and using the embedded HTTP server instead.
*

?
1
2
3
4
<world>

<key>some long random string</key>
</world>
This is the authorization key that zones and the launcer will present to world to prevent unauthorized access. It's recommended that you set this.
*

?
1
2
3
4
<world>

<http enabled="false" mimefile="mime.types" port="9080">
</http></world>
This is where you can change what port the embedded HTTP server is listening on for requests. Again, if it's left out the shown defaults will be used. You can do many things with your server by using the embedded HTTP server. Point your favorite browser at it and take a peek.
*

?
1
2
3
4
5

<chatserver>
<host>channels.eqemulator.net</host>
<port>7778</port>
</chatserver>
Defines the host and port where the chat channel server is. You shouldn't need to set/change this.
*

?
1
2
3
4
5

<mailserver>
<host>channels.eqemulator.net</host>
<port>7779</port>
</mailserver>
Defines the host and port where the mail (for in-game mail) server is. This is currently not implemented. You shouldn't need to set/change this.
*

The settings under the zone elements are used to control different aspects of the starting and controlling of zones.
*

?
1
2
3
<zones>
<defaultstatus>20</defaultstatus>
</zones>
You guessed it, the default status that new accounts get on creation.
*

?
1
2
3

<ports high="7100" low="7000">
</ports>
This is the port range that world will use to assign ports dynamically to zones as they connect. You probably don't need to
*

?
1
2
3
4
5
6
7
8

<database>
<host>localhost</host>
<port>3306</port>
<username>eq</username>
<password>eq</password>
<db>eq</db>
</database>
This is where you can change where have created your database or what username/password you are using.
*

?
1
2
3
4
5
6
7

<launcher>




</launcher>
This is where you can change the behavior of the launcher.
* and

?
1
2
3
4
<launcher>
<logprefix>logs/zone-</logprefix>
<logsuffix>.log</logsuffix>
</launcher>
These options set the path, prefix, and suffix of the log files which the launcher pipes all of zone's output into. Any intermediate directories will not be created, so make sure they exist. The zone launch name will be sandwiched between prefix and suffix, eg: logs/zone-butcher.log would be the log file for a static butcher zone, and logs/zone-dynamic_01.log would be the log for your first dynamic zone.
*

?
1
2
3
4
5
<launcher>
<exe>zone.exe</exe>

<exe>./zone</exe>
</launcher>
This option allows you to specify which zone binary the launcher will run. If you build your zone with perl support into ZonePerl.exe instead of Zone.exe, you can specify that here.
*

?
1
2
3
<launcher>
<timers initial="20000" interval="2000" restart="10000" reterminate="10000">
</timers></launcher>
This element lets you configure various timers that the launcher uses. All values are in milliseconds.

restart - This is the time between when a zone goes down, and when it is started back up again.
reterminate - This is how long we wait after sending a kill signal to a zone before killing it again.
initial - This is the time we wait after booting the first zone on the machine before booting any more zones (to let shared memory load).
interval - This is the time between booting each subsequent zone.
*

?
1
2
3
4
5
6
7

<files>




</files>
These entries are provided if you need to override the names or locations of the needed files. You probably don't need to change these settings.
*

?
1
2
3
4
5
6

<directories>



</directories>
These entries are provided if you need to override the names or locations of the needed directories. You probably don't need to change these settings.

i know im suppose to edit something. but i am really clueless here. i am hoping you can tell me exactly what to do and how to do it. since i am not fully understanding the guide. would muchly appreciate the help. thanks in advance.

deez2255

07-15-2014, 01:26 PM

also need help with one of the last steps as well as the one i just listed. this one says Creating a batch file to launch the server

Now you can make a start.bat file to put in your server folder with the following lines:

where do i go to make a start.bat file? and how do i do it? thanks in advance.

Nightrider84

07-15-2014, 01:49 PM

ok here is an example of the full file ill try and explain it


<server>
<world>
<shortname>shortname of your server</shortname>
<longname>server name you will see when login</longname>






<loginserver>
<host>>local address for the computer your server is on. IE 192.168.1.7</host>
<port>5998</port>
<account>Usually Admin</account> <-----this part might seem confusing but in your database under tblserveradminregistration the values under that will represent what to put here for your account and password.
<password>Usually Password</password> <-----As far as I know you dont hafto put anything in here its only recommended if you know how to do it.
</loginserver>






<tcp ip="localhost" port="9000" telnet="disable">


<key>some long random string</key>


<http enabled="false" mimefile="mime.types" port="9080">
</http></tcp></world>


<chatserver>
<host>channels.eqemulator.net</host>
<port>7778</port>
</chatserver>


<mailserver>
<host>channels.eqemulator.net</host>
<port>7779</port>
</mailserver>

<zones>
<defaultstatus>Change this to 0 so players dont get gm status</defaultstatus>


<ports high="7100" low="7000">
</ports></zones>


<database>
<host>localhost</host>
<port>3306</port>
<username>your mysql username</username>
<password>your mysql password</password>
<db>name of your database usually peq</db>
</database>


<launcher>




</launcher>


<files>




</files>

<directories>



</directories>
</server>

thats about the basics of how to setup that config file. as for the start.bat file make a text file and and click save as. and save it as start.bat it should change the file type to .bat
once thats change open the file and insert this into it. once the file is changed to a .bat file you can rename the file to whatever you want. btw you WILL need heidisql if you have no experience using the command prompt to change values. and it just makes it easier aswell make sure you install that. Hope this helps

@echo off
shared_memory.exe
start loginserver.exe
start world.exe
echo Waiting for the world to finish loading before starting zones...
ping -n 10 127.0.0.1 > nul
start queryserv.exe
start ucs.exe
start eqlaunch.exe zone
exit

deez2255

07-15-2014, 01:53 PM

Thanks for the prompt reply. at the top where it says 
<server>
<world>
<shortname>shortname of your server</shortname>
<longname>server name you will see when login</longname>




you state that i can change the address if i want other people to access my server as a private login. thats means i can have another couple of friends join it right? and what do i change the address too? thanks again for all the help so far.

deez2255

07-15-2014, 02:06 PM

also. i tryed to do some. again this is my first time doing this..lol please tell me if all of this is okay. or if its just plain bad and help me correct it. thanks in advance.

<?xml version="1.0"?>
<server>
<world>
<shortname>My Eq Server</shortname>
<longname>Elderin Councils private EQ server</longname>






<loginserver>
<host>184.155.54.255</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>






<tcp ip="local host" port="9000" telnet="disable"/>


<key>some long random string</key>


<http port="9080" enabled="false" mimefile="mime.types" />
</world>


<chatserver>
<host>channels.eqemulator.net</host>
<port>7778</port>
</chatserver>


<mailserver>
<host>channels.eqemulator.net</host>
<port>7778</port>
</mailserver>

<zones>
<defaultstatus>20</defaultstatus>


<ports low="7000" high="7100"/>
</zones>


<database>
<host>local host</host>
<port>3306</port>
<username>root</username>
<password>root</password>
<db>peq</db>
</database>

<qsdatabase>
<host>127.0.0.1</host>
<port>3306</port>
<username>eq</username>
<password>eq</password>
<db>eq</db>
</qsdatabase>


<launcher>




</launcher>


<files>




</files>

<directories>



</directories>
</server>

Nightrider84

07-15-2014, 02:13 PM

yeah so theres a few things you need to know before they can join

1. you have a dynamic dns which means you need to get a host of somekind thats free. like no-ip
the reason for this is when your modem restarts or you lose power ect ect. your dns address changes. The address you make with the host will always update to include the changed address. saves you a ton of trouble.
2. if you want other people to join you need to make sure that your ports are forwarded properly. 9-10 times people cant join because of port problems.

so to give you an example if your local address is 92.145.432.45 (find this out go to google and type whats my ip) and you lose power it will change to like 92.143.224.64 just as an example. but if you have a "host" the address they give you will never change. and it will be a address like myserver.gethere.ok
instead of numbers. you would put that name into that address box

 like this, it may sound confusing but if you want other people over the net to connect to your server while its "private" thats what you need to do.

Nightrider84

07-15-2014, 02:14 PM

your address is wrong.



 this and your host will be the same number but it will be your computers ip address not your local address


<loginserver>
<host>184.155.54.255</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>

deez2255

07-15-2014, 02:17 PM

okay yeah it is a little confusing. i did not set up port forwarding. i suppose i can make it just me right now to test it out. as per my settings above your post. are they all okay besides the <address>myserver.gethere.ok</address> ? or are alot of other input settings wrong that i typed?. also. when i made a txt document and tryed to type in start.bat it did not change over to .bat. it stayed txt. why is that? thanks for the continued help!

deez2255

07-15-2014, 02:18 PM

read your post late. lol so besides just the one address part is anything else wrong?

Nightrider84

07-15-2014, 02:20 PM

everything else looks ok id change your

<zones>
<defaultstatus>20</defaultstatus> to 0 so everyone doesnt get gm powers.

also when you click save as in your text file change it to all files. instead of text files. for your batch file

Nightrider84

07-15-2014, 02:22 PM

oh also is your mysql password the same as your username for it?

deez2255

07-15-2014, 02:29 PM

i am not sure about the mysql how do i check? lol thanks for the help again.

Nightrider84

07-15-2014, 02:34 PM

its the username and password you used in the command prompt ie mysql -username -ppassword

deez2255

07-15-2014, 02:40 PM

i will look into the sql thing. as for the bat i am still having problems switching it over. when i make a new text document and name it start.bat it doesnt give me any visible open to switch it over. it just automatically goes into text format

Nightrider84

07-15-2014, 02:43 PM

you gotta go into the text document go to file click save as and there is a bar at the bottom you can change to all files. and name the save start.bat

deez2255

07-15-2014, 03:25 PM

thanks for the prompt reply. okay i got the save.bat file saved as a bat. now you said i needed to change the address. and do i need to mess with the sql thing like you said? or is that optional

deez2255

07-15-2014, 04:14 PM

let me know asap thanks!

Scorpious2k

07-15-2014, 10:42 PM

You do need the user id and password for the DB in the config and it has to be correct. Otherwise it will all error out.

deez2255

07-21-2014, 05:20 PM

Where do i find it at? the user id and password

Scorpious2k

07-22-2014, 01:19 AM

Do you meam where do you put it in the config?

deez2255

07-23-2014, 04:03 AM

yes thats what i mean i think

lerxst2112

07-23-2014, 04:48 AM

It's the same account and password you asked about last week. Remember mysql -uusername -ppassword? The username is generally root for a local connection.

Scorpious2k

07-23-2014, 10:57 AM

Open the config file (eqemu_config.xml) with an editor (notepad works fine) Go down to where you see
<database>
<host>localhost</host>
<port>3306</port>
<username>eq</username>
<password>eq</password>
<db>eq</db>
</database>
change the eq between <username> and </username> to the user name you used in mysql, change the eq between <password> and </password> to the password you used. If the DB name isn't eq change the eq between <db> and </db> to the db name you used, otherwise leave it alone.

Save the config file and it should work.