COMPLETE PUBLIC SERVER SETUP - Jan-2011 [Archive]

View Full Version : COMPLETE PUBLIC SERVER SETUP - Jan-2011

Pages : [1] 2

Huppy

01-30-2011, 01:02 AM

This is ONLY for new people who want to run a PUBLIC server on eqemulator.net
I am only trying to save people the hassle of jumping all over these forums
looking for information on the setup. There is lots of helpful people and
helpful information on these forums, but when they see the same questions
being asked over and over again, it becomes annoying, especially when YOU
are expected to do a lot of searching for answers before you ask. And, yes,
there is thousands of posts in the Windows Server Support forum and it can be
overwhelming. No, the search feature is not perfect, and it can take a LONG
time to find everything you need to know. But keep the following in mind:
Everyone involved in the EQEmu community are volunteering their time for any
and ALL work, admin, development and help that these forums are full of.
So there is NO librarian at a desk being paid to help you everytime you need
it. Everything is out of the kindness of their EQEmu hearts :)

*WARNING*PLEASE READ FIRST*

One of the biggest reasons some people end up with problems is because
they "missed" something in one of the guides.(I've done it myself)
Please make sure your not just "skimming" over the text written here.
If you read each and every single line in the following steps, and I mean
every character, symbol, phrase, line and step, before moving on to the
next one, double checking to make sure, you will have NO PROBLEMS.
I can almost guarantee, if you get an "error" in your setup, you probably
"missed" something, or changed something you weren't supposed to. You
have no idea, how much one single mis-typed character can cause your
server not to start, run or connect to the public server list. I would
recommend not starting the setup until you are in a position to concentrate
on what you are doing.

FIRST - The Basic Program Downloads (this is how I organized it all)

*WARNING*
There is specific instructions to installing Zlib, MySQL and Visual C++ in
this guide. Please read them before installing.

Make a folder somewhere on your drive called EQEmu Installs put all the
necessary program installs you need before you start. I have all these installs
backed up on disc, so I never have to do it again.

*WARNING*64-BIT Windows Users*
I use the 32-BIT versions of Perl and MySQL to avoid problems.
EQEmu is a 32-bit application.

For WinRAR, go here - (just download the trial version at top of page)
http://www.rarlab.com/download.htm

For Zlib, go here -
http://sourceforge.net/projects/libpng/files/zlib/1.2.3/zlib123-dll.zip/download

For Perl, go here - (I use 5.1 - 1007 version)
http://www.activestate.com/activeperl/downloads

For MySQL, go here - (scroll down the page to see downloads,I use 5.1.54 version)
http://dev.mysql.com/downloads/mysql/5.1.html

For MS Visual C++ 2008 Express Edition, go here -
http://www.microsoft.com/express/Downloads/#2008-Visual-CPP

For Navicat Lite, go here -
http://www.navicat.com/en/download/download.html

For TortoiseSVN, go here -
http://tortoisesvn.net/downloads

For Notepad++, go here - (this can be essential for editing)
http://notepad-plus-plus.org/release/5.8.6

SECOND - Installing the Basic Programs
(My preference is to reboot computer after each install, whether needed or not)

1. I would suggest installing WinRAR first if you haven't already.

2. Unzip the Zlib files to c:\zlib (NOT c:\zlib\zlib) and inside that folder,
copy one file called ZLIB1.dll to your c:\windows\system32 folder, then reboot.

3. Now install the Perl 5.10 (1007). Type yes to everything BUT There will be
one question that has C:\Perl in it. That question requires you to enter
that path as the answer. So just type c:\perl (YOU HAVE TO REBOOT FOR NEXT STEP)
After you rebooted, open command prompt and type the following (one at a time and
wait for it to finish):
ppm install DBI
ppm install IO-stringy

4.Now install MySQL 5.1 (this will be installed to C:\mysql)
When you first start up the install, make sure you choose CUSTOM install.
IMPORTANT: after clicking "next" this is where you change the install
path to "C:\mysql
On that same menu, make sure ALL options are installed.
After clicking "next", on that menu, choose Detailed Configuration.
After clicking "next" again, choose Server Machine.
After clicking "next" again, choose Multifunctional Database
On the next menu, there is nothing to change, click "next" again.
On that menu, choose Online Transaction Processing (OLTP)
Then click "next". UNCHECK the strict mode option, and make sure that the
TCP/IP Networking is checked ENABLE and at port 3306.
After clicking "next" again, Choose Best Support for Multilingualism.
After clicking "next" again, make sure BOTH of the following are checked:
Install As Windows Service and Include Bin Directory in Windows Path
After clicking "next" again, you will be prompted for a password.
(This password is what goes with your SQL database username)
Your SQL username is automatically set as "root"
After you click "next" again, you will get a menu with "Execute" on it.
Just click that and wait, as it installs and finishes. Reboot.

5.Now we install Microsoft Visual C++ 2008 Express Edition
You can just install this with all the default installation. Nothing to
do until after installation is complete. But once it is done;
Open up the program and on the menu at top, click on "Tools"
From that menu choose "Options" and then you will see a menu list with
"Projects and Solutions" with a little "+" sign to expand that menu.
You will see "VC++ Directories" to click on and change the menu to the right.
On the top right of the menu you will see "Show directories for" and under
that, by default, it will show "Executable files".
First you need to change that to "Include files" from the drop down menu.
You will also see a little yellow folder icon under that drop down menu.
This is to "add a new line". After you click on that and see a new line,
you will see a grey icon to the right of that line with 3 dots [...]
Click on that to browse for the following: You will repeat this for all 3
new lines.***NOTE** the following are FOLDERS, not files.

INCLUDE:

C:\mysql\include
C:\perl\lib\CORE
C:\zlib\include

Now after those 3, change the "Show directories for" to Library files and
repeat the steps for the following 3: (notice, a couple are different)

LIBRARY:
C:\mysql\lib\opt
C:\perl\lib\CORE
C:\zlib\lib

OK, Your done with installing the C++ program.

6. Now you can install TortoiseSVN, Navicat and Notepad++ using defaults
(click yes or next to everything)
Then REBOOT

OK, now you have all the basic programs installed, we can download the sources
needed to compile, setup and configure the server.

7. Create 3 seperate folders on your C-drive;(the folder names are a preference)

1st one. source (this is where you'll download and compile the source files)
2nd one. eqemu (this will be your main server folder)
3rd one. peqdb (this will have your database source files)

*NOTE* - when I mention "server folder" in the rest of this setup, I am pointing
to the folder called eqemu. (not the source folder)

8. Now on your main C-Drive, right click on the folder called source.
From the menu that pops up, you will see SVN Checkout...Click on that to
bring up a Checkout menu.
On the TOP LINE called URL of repository, copy and paste this line in to it:
http://projecteqemu.googlecode.com/svn/
Then click OK. It will start downloading all the server source files. When it
is finished, it will show "At Revision XXXX" (XXXX being a number). Then close
the window. Your source folder will now have many files and folders in it.
***NOTE** - After your done compiling the source, there will be lots of files
to copy over to your server folder from your source folder. But first -

9. Open up the MS Visual C++ 2008 Program that you installed.

Click on "File" and scroll down to "Open" and from that menu "Project/Solution"
The browser will pop up and you will navigate to C: drive to the source folder.
Inside the source folder is trunk folder. Inside that one is EQEmuServer folder.
Click on that folder and inside, one of the files Server.sln (NOT Server71).
Click on Server.sln and click open.(this file will have a number "9" on it)
You should now see the project on a menu (on the left)
On the top menu, click on "Build" and choose "Clean Solutution" from that menu.
At the end of that it should say Build: 5 succeeded 0 failed 0 up-to-date 0 skipped
Now, at the top menu click on Build and scroll down to "Configuration Manager".
You will see a drop-down menu called "Active solution manager" (make sure it is)
Change that drop menu entry to "Release" and click "close".

***WARNING*** There is also another option in there for "ReleaseBots". You would want
that one if your implementing the bot system.

So now, its time to click on the top menu called Build and choose "Build" from that one.
It will start building the server for you. Don't pay any attention to the warnings and
crap that goes up the window, A lot of it doesn't mean anything.
All you have to hope for, is when its done, it will give that same line again:
Build: 5 succeeded 0 failed 0 up-to-date 0 skipped
THIS WILL TAKE AWHILE TO BUILD - HAVE A COFFEE!

***WARNING***
If the build was successful, (5 succeeded), you DO NOT have to re-do that just because
you have future problems. The rest of the setup is copying files, sourcing your database
and configuring your server. The database and the server are two seperate things.
Your config files will help connect the two when your server is finally up and running.

10. It's time to start copying files from your source folder to the server folder.

***WARNING** - All of the files I am going to list here NEED to be copied over to your
server folder. you will find them all in different sub folders in the source folder.

First go into /source/trunk/EQEmuServer folder. You will see a folder called Build.
This folder was created when you compiled the server apps.It contains 5 files you
need to copy over to your server folder:
Chatserver.exe, eqlaunch.exe, World.exe, Zone.exe and EMuShareMem.dll

Next, In /source/trunk/EQEmuServer/utils folder, copy these to your server folder also;

mail_opcodes.conf, opcodes.conf, patch_6.2.conf, patch_Anniversary.conf,
patch_HoT.conf, patch_SoD.conf, patch_SoF.conf, patch_Titanium.conf, schema.xml
and patch_Underfoot.conf

Next, In /source/trunk/EQEmuServer/utils/defaults folder -

Copy ALL the folders and files inside this folder. EVERYTHING !!!! and put them in your
server folder also.YOU DON'T need the folder called .svn

11. Ok, Now you need to download the Maps and quests.

In your server folder, right click on the quests folder and choose "SVN Checkout"
In the "URL of repository" line copy and paste the following:
http://projecteqquests.googlecode.com/svn/trunk/quests (Then click on OK)

Let it download the quests. It will show "At Revision xx when done.

Next, in your server folder, right click on the Maps folder and choose "SVN Checkout"
In the "URL of repository" line copy and paste the following:

http://eqemu-maps.googlecode.com/svn/trunk/ (then click OK)

This will take awhile, have a coffee :)

12. Now, inside the quests folder where you downloaded all the quests, there is a folder
inside that one called plugins. You need to go inside there and copy ALL of those
plugin files over to your main plugins folder in your server directory.

***NOTE***
Let's make sure you have ALL FILES copied over that are supposed to be:

In your eqemu (server folder) there should be 6 folders.

1. logs (this will be empty right now)

2. Maps (full of all the map files you downloaded)

3. plugins (has all the plugin files you copied from /quests/plugins folder)

4. quests (has all the quests you downloaded.)

5. templates

6. worldui

Aside from those 6 folders, you should have at another 22 files in your server folder.

If you don't, go back to step 10 and start over.

So NOW, you can download and source in the database (and updates needed)

13.First, go to your C-Drive and right click on the folder you made called peqdb
and choose "SVN Checkout"
In the "URL of repository" line copy and paste the following:
http://projecteqdb.googlecode.com/svn/trunk/peqdatabase (then click OK)
It will finish with "At Revision XX"

Next, go to that folder peqdb and unzip the file from peqdb_rev1751.sql.gz
to the same peqdb folder.
This file will be named peqdb_rev1751.sql (without the .gz)

***NOTE***
The "rev1751" was the most current at the time of this writing. It may change over time.

14. Ok, now open up your Navicat Lite program that you installed.
On the upper left you will see Connection. Click on that and choose MySQL
A connection window will open. The only thing you really need to do is put your mysql
password in (make sure the "Save Password" is checked) and click OK.
This will create a connection with MySQL.
In the Connections window, you should now see localhost_3306 (Double click on that)
Then right click on that same name (localhost_3306) and choose New Database...
In the next window, in the first line, type peq (then click OK)
Close Navicat Lite.

15. NOW, you need to go in to a command prompt and navigate to the peqdb folder.
Simply type cd \peqdb and you should be there. You will see: C:\peqdb>_

REMEMBER THE PASSWORD YOU GAVE when you set up MySQL ? (You need it NOW)

***WARNING*** - at this point, make sure you are in the peqdb folder.

Type mysql -uroot -p
Hit enter and enter your password. (Hit enter again)
You should now see a prompt that looks like this: (along with "Welcome" text before it)
mysql>_

Type the following (in order):

use peq (Hit enter and you will see a short note saying "Database changed")

Then type the following:

source peqdb_rev1751.sql (when this is done, you will be back at the mysql>_ prompt)

Then type in the following:

source load_player.sql (this will load fast)

***WARNING*** - When you compiled your server, if you chose "ReleaseBots", you will now
need to type the following at the mysql prompt:

source load_bots.sql

Which ever you chose, you can now close the command window and work on the sql updates.

***WARNING*** - the sql updates ARE NOT in the peqdb folder, they are in the source
folder where you compiled your server, but you can use Navicat Lite to run the updates.

16. When you open Navicat, double click on the localhost_3306 name and double click on the
peq name. Then right click on the peq name and choose "Execute SQL File"

In the window that pops up, click on the little square with 3 dots [...] to navigate to
the following folder(on your C-Drive: /source/trunk/EQEmuServer/utils/sql/svn/
*Note*
You will find a lot of .sql files in there, but you only need the ones starting with the
number 1711 (and up)(this is based on using the 1751 database)

So first click on the 1711 file called 1711_account_restricted_aa.sql and click Open
Then click Start. It will source that sql in to your database.
***NOTE*** - You will have to do this step with each one, especially the ones that have
the word "required" in the name of the file.

The reason your doing this, is because, even after a new database revision is out, all
the updates developed after that, need to be sourced in. In this case, when the rev1751
was sent out, (after the 1667), not all updates were applied to the release.
I know it leaves more work for us "end users", but what the heck, it's free :)

***WARNING*** - You may run in to errors on some of the updates, (I ignored some), but
there is one you can not ignore: 1711_account_restricted_aa.sql
YOU NEED THIS UPDATE for your server to create accounts without errors.
If you get an error when sourcing that in, you can do this to help it along:

Open the 1711 file with Notepad++ and remove the first line (there is 3)
After removing that line, run the update again.
I CAN NOT help you with all the errors from the updates, but just search the forums for
any others.

***TIP*** - Once you have your database updated fully, BACK IT UP !!!
That is easily done without even logging in to your mysql.
Create a folder on your C-Drive (or wherever), called backup
Then in a command window, simply type the following:
mysqldump -uroot -ppassword peq > c:\backup\peq_backup.sql
(I do this frequently while I work on my server and burn it on a disc)
Then if you ever have to re-install everything, you can easily source your whole database
back in by typing the following: (make sure your in that same backup folder)

mysql -uroot -ppassword
use peq
source peq_backup.sql

***Note** After re-installing, make sure you created the peq database name again with
Navicat first

But anyways, in your server folder, you will have two xml files in there, one called
eqemu_config.xml and another called eqemu_config.xml.full
You don't need both of these. DELETE the eqemu_config.xml and keep the other one.
Rename the other one, by REMOVING, the .full at the end of it. So it has the same name
as the first one you deleted. (the .full xml file is a more complete config)

***WARNING***WARNING***WARNING***

Editing this xml file is where a lot of people don't understand when someone trys to
advise them NOT TO EDIT LINES, they don't listen and then get frustrated.
You have no idea how SIMPLE it is to configure this file.
First of all when a line has these characters in front of it: 
<shortname>shortname</shortname>
<longname>My Long Name</longname>






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






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


<key>somelongrandomstring12345</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>7779</port>
</mailserver>

<zones>

<defaultstatus>0</defaultstatus>


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


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


<launcher>




</launcher>


<files>




</files>

<directories>



</directories>
</server>

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

@echo off
start world.exe
echo waiting for the world to finish before starting zone...
ping -n 10 127.0.0.1 > nul
start eqlaunch.exe zone
exit

Then create a shortcut on your desktop to run this file.

***WARNING***WARNING***WARNING***

PORT FORWARDING ON YOUR ROUTER (if your using one)

Log in to your router and you need to forward the following ports to the internal
ip of your server computer : (These are the ones that worked for me)

5998, 5999
7000 to 7100 (Port Range Forwarding is essential for this)
9000

To find out the internal ip of your computer, at a command prompt type ipconfig
The 192.168.1.xxx number that is listed is the forwarding IP you need.
Every router is different, so if you don't know how to log in to it, then you
will have some searching to do without the manual :)
Most commonly, a web browser is used, typing in an address like 192.168.1.1
Mine was set to leave username blank, and enter a default password. Then you
can change that, but that is MY ROUTER ONLY, yours may be different.

OK, If you've done all that, been there and back again, and your 300% sure that
you followed these steps exactly, crossed all t's and dotted all i's - Your done.

Before you click on that Start.bat file, a couple things to know.

Two command windows will open up and you will start to see text scrolling by.
A couple of times you might see the word "error", but don't jump the gun right
away. One you will definately see is with eqtime.cfg THAT IS NORMAL.
You might see another brief one while the WORLD is connecting.
If everything has gone smooth, you should see the zone servers loading.
There will be 5 of them in total, and the text will stop after the 5th one.
If your seeing a constant error with anything "FAILED TO CONNECT" that keeps
going up your screen, something is wrong. TRACE YOUR STEPS and READ.

***NOTE*** - Your server places it's log files in the logs folder. This is where
you look for troubleshooting problems.

GOOD LUCK

Fulcrum

01-30-2011, 08:02 PM

Thanks Huppy, should save new folks a bunch of headaches!

Irreverent

01-30-2011, 10:37 PM

how about chat channels setup? :) That one always kicked my butt!(still does...)

Fulcrum

01-31-2011, 03:22 PM

how about chat channels setup? :) That one always kicked my butt!(still does...)

Chat and mail channels both have to be put on the same port, don't they?

Huppy

01-31-2011, 04:38 PM

how about chat channels setup? :) That one always kicked my butt!(still does...)

Although you wouldn't have to touch those for a public server setup, if your
talking about a private home server, I usually set the ports for mail and chat
at 10234. It seems to work pretty good.

wolfwalkereci

01-31-2011, 11:06 PM

Thank you for posting this. I'll read over it again later and add anything I learned setting mine up that might help people out.

Huppy

01-31-2011, 11:31 PM

Thank you for posting this. I'll read over it again later and add anything I learned setting mine up that might help people out.

Thanks wolf, just keep in mind, this guide was written for Public Server Setup
and did not include anything to do with setting up one's own login server.
Although all of this can be done before using your own login server.

HeavyHand

02-06-2011, 01:20 AM

Huppy,

thanks a lot for doing this. Couple of questions if you please:

1) How did you know about running the Extra SQL updates in that svn folder? If I am going to run a public server, I obviously need to know where to get all the proper info. Yours was the first place that even mentioned it.

2) I am having issues with the first required update "1720_required" (actually a couple of the optionals too) what the best way to search the forums for these? I am a desktop admin, so I know how to search in general and how simple word order changes gets results, but I am falling flat here. Or, is this where it's time to take off the training wheels and tear through the DB? I'd rather not without knowing more about it.

Thanks for any tips.

HeavyHand

02-06-2011, 02:49 AM

Or, is this where it's time to take off the training wheels and tear through the DB? I'd rather not without knowing more about it.

Thanks for any tips.

The answer at this time is, yes. If there isn't any easy way, you can get in there and check the tables being adjusted against the statement.

Huppy

02-06-2011, 06:12 AM

lerxst2112

02-06-2011, 08:16 AM

If you're interested in what each update is for, there's usually a comment in the changelist here:
http://projecteqemu.googlecode.com/svn/trunk/EQEmuServer/changelog.txt

And you can dig into more detail by browsing through the code changes here:
http://code.google.com/p/projecteqemu/source/list

sorvani

02-06-2011, 10:47 AM

joligario

02-06-2011, 11:23 AM

No spaces needed there

HeavyHand

02-06-2011, 02:17 PM

I actually had to search, ask, search, search, etc. to find out a lot of what I have learned so far. It has been mentioned several times about the sql updates. Some of them can/will give errors when you source them in, but there is info around for some of the fixes.

Yeah, I guess I heard hints, but nothing overt enough to slap me into recognition. Once again, thanks for this. I was actually compiling all my stuff together to create one myself incase I ever get through it all ;)

HeavyHand

02-06-2011, 02:22 PM

HeavyHand

02-06-2011, 02:22 PM

Also, struggled through all the SQL updates. I'm glad I did. I feel more like I am contributing to my server, than just host.

Huppy

02-07-2011, 06:23 AM

awesome post, I'll be going through this later tonight or tomorrow.

one quick thing I noticed since you stressed for the beginners to type thing EXACTLY as you did, in a few places you missed the spaces in the mysql login command. example: mysql -uroot -ppassword or are spaces not required there? never tried without spaces.

Ya, just like joligario replied, you can login to mysql without using a space between -u and root, so its typed -uroot (just like that)
And the same for your password -ppassword.
So if your user name was root and password was fufu, you would type:

mysql -uroot -pfufu

sorvani

02-07-2011, 05:43 PM

Ya, just like joligario replied, you can login to mysql without using a space between -u and root, so its typed -uroot (just like that)
just had never actually tried to do it like that before, so had no idea.

Tried it with perl 5.12 and after changing a couple references to perl510 to perl512 in the vb project it compiled and seems to run well.

i'll tear it back down and put perl 5.10 in there, but just thought i'd try it.

Thanks for this consolidated information thread, it made this a LOT easier..

Trying to make sense of these SQL scripts hurts my head simply because there are so many minor issues with them. Just to get the server up, I just dumped all of the required ones into 1 sql file and told it to run and not stop on error. Wasn't too worried if something was not perfect since i'm gonna blow it back out anyway.

MBroadway

02-13-2011, 04:10 PM

Hey for some reason every time someone makes a pet my zone.exe crashes. Everything else works great though, im not sure if I missed an sql update or what. im pretty sure I got it all right. but i am not sure. Any help would be great. thanks.

codysutton

02-16-2011, 09:57 AM

11. Ok, Now you need to download the Maps and quests.

In your server folder, right click on the quests folder and choose "SVN Checkout"
In the "URL of repository" line copy and paste the following:
http://projecteqquests.googlecode.com/svn/trunk/quests (Then click on OK)

Let it download the quests. It will show "At Revision xx when done.

Next, in your server folder, right click on the Maps folder and choose "SVN Checkout"
In the "URL of repository" line copy and paste the following:

http://eqemumaps.googlecode.com/svn/trunk/Maps (then click OK)

This will take awhile, have a coffee :)

two problems. Since I am supposed to go word for word on this, then the first is included. First- I cannot do the svn checkout on quests folder, it has that green check on it already. I just made another folder for the download and copied all that into it, hoping it would work.

However, this is the real problem. The maps download appears to be encrypted- When I try to svn checkout download that, it asked for a username and password. Do we know what it is?

sorvani

02-16-2011, 11:00 AM

No, the person who was hosting the maps rage quit and took down the repo.

Fulcrum

02-16-2011, 11:51 AM

No, the person who .....

Well, not -entirely- accurate but the end result is exactly the same. From a neutral, utterly unbiased position, the whole thing seems to have begun with a simple misunderstanding that got a little out of control on both sides of the fence.

I believe that all the missing files will soon be hosted by someone else in the very near future.

sorvani

02-16-2011, 12:48 PM

On the issue of SQL updates. I went through these one at a time on Sunday.

In the window that pops up, click on the little square with 3 dots [...] to navigate to
the following folder(on your C-Drive: /source/trunk/EQEmuServer/utils/sql/svn/
*Note*
You will find a lot of .sql files in there, but you only need the ones starting with the
number 1711 (and up)(this is based on using the 1751 database)

The 1711_account_restricted.sql is the only one with a rev prior to the DB (1751) that you need to source in. And as Huppy noted you need to remove the first line. So your file should look like this.
ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
UPDATE `account` SET `time_creation` = UNIX_TIMESTAMP() WHERE `time_creation` = 0;

After going through them all one at a time and figuring out that I only needed 1711, I dropped the database and resourced and only ran 1711 + >1751 updates and the server seems to be running fine.

Xakkis

02-16-2011, 05:22 PM

Well, not -entirely- accurate but the end result is exactly the same. From a neutral, utterly unbiased position, the whole thing seems to have begun with a simple misunderstanding that got a little out of control on both sides of the fence.

I believe that all the missing files will soon be hosted by someone else in the very near future.

For now you can just download the .rar of the maps and the new maps and unzip it to that folder. First download the maps.tar.gz , extract it to \maps, and then download the newmaps.rar and extract it to the same directory (will overwrite a few files).

In the future you can modify the repository URL for the SVN checkout when the files are re-hosted.

codysutton

02-17-2011, 01:17 PM

Alright. First of all, thank you so much for this guide. I -was- logged in and running around on my own server, thanks 100% to this guide, and answering my, until now, only problem very promptly.

Now, when I run start.bat, it was working. Loading the world and yada yada, but now- it doesn't. I get a popup about 'windows not being able to find eqlaunch.exe' I thought it was because I modded a file to allow me to have 250 status. I undid that, but I still get this error. I went to the mostly knowing google, and have come up dry thus far.

BUT! I suspect Norton 360. My server ran fine. I installed Norton because I realized I forgot to about my reboot, and now I am getting this problem, after Nortan said eqlaunch.exe was behaving suspiciously, and did what it does.

So, where are eqlaunch executables supposed to be? That is all Norton claims it wrung out of my pc with its dick beaters, but I am suspicious. It was in my backup, and now it isn't, which I had on my external storage HDD.

I am not the type to have a problem, and just immediately go posting for help. I have looked, and I am now throwing myself on your guys' mercy.

lerxst2112

02-17-2011, 03:57 PM

It sounds like Norton removed or quarantined the file. You'll have to figure out how to stop it from doing that and replace the file from wherever you got it before, either by compiling it or downloading/unzipping it again.

blackdragonsdg

02-17-2011, 07:30 PM

If I remember correctly Norton360 has always been fairly similar to NIS in alot of ways and if that still holds true then you can set it to exclude entire directories from auto protect and sonar scans. It should be fairly easy to find in the settings.

joligario

02-17-2011, 10:12 PM

sorvani

02-19-2011, 12:07 PM

Temporary (or permanent) solution arrived.

http://code.google.com/p/eqemu-maps/

Can we get a mod to edit the first post with the updated SVN since the whole point of the post is to gather it all in one place?

joligario

02-19-2011, 05:19 PM

Probably best to do guides in the wiki since you can edit them there as a community.

tzu-theory

02-22-2011, 09:47 PM

Is it okay to use PERL 5.10.1.1008? I don't see a way to download the version you listed unless you have a Business Edition account.

tzu-theory

02-22-2011, 10:16 PM

Furthermore, as I am trying to install MySQL, it is saying that it does not support my processor type. Note: I am running an instance of Windows Server 2003 on my iMac. I had hoped that no issues relating to the processor would present itself, as it is a VM. I guess I can only effectively run this on a x86 machine?

lerxst2112

02-22-2011, 10:23 PM

I use Perl 5.10.1.1007 with no trouble.

For MySQL, make sure you download the 32-bit version. It sounds like you may have the 64-bit version.

tzu-theory

02-22-2011, 10:26 PM

Dang, you're right. Attention to detail would help me in these things ;)

seratt

03-01-2011, 10:13 AM

Thanks for this guide Huppy!

Was working through it yesterday and realized I need to redo some stuff on my server before I continue with my eqemu install. I'll post back with how it goes later this week.

Cassieze

03-16-2011, 11:28 PM

Thank you for posting this! I really hate having to look around when the guides are not actually guiding... but leading me into a world of confusion...

deaddraqear

03-18-2011, 01:10 PM

Ok, I've followed this guide to the letter, and running into a problem at step 9. I am getting 1 successful build, and 4 failures. Briefly looked through forums here and I didn't see anything, but was just wondering if someone could point me in the right direction if nothing else?

Well, I guess I forgot to restart comp somewhere in there or something.. thats all I did and it worked just fine this time -.-

Fulcrum

03-18-2011, 02:34 PM

I am getting 1 successful build, and 4 failures.

Kinda sounds like you're running Perl 5.12.* or have remnants of it left over from an uninstall.

dranovir45

03-19-2011, 06:40 PM

oops wrong details.

dranovir45

03-19-2011, 07:22 PM

I figured out the problem with SVN, new problem, im getting 2 succeeds, and 3 failures, any idea why this is? was no write up on what to do if that happened.

lerxst2112

03-19-2011, 09:21 PM

Can you post the actual errors you get? Otherwise we're just guessing.

dranovir45

03-19-2011, 10:08 PM

Can you post the actual errors you get? Otherwise we're just guessing.

5>c:\source\trunk\eqemuserver\ucs\../common/dbcore.h(9) : fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory
5>chatchannel.cpp
5>c:\source\trunk\eqemuserver\ucs\../common/dbcore.h(9) : fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory
5>Build log was saved at "file://c:\Source\trunk\EQEmuServer\Build\ucs\Release\Buil dLog.htm"

Another one i just saw ---

5>.\database.cpp(29) : fatal error C1083: Cannot open include file: 'errmsg.h': No such file or directory ; i get 2 succeeded and 3 failed.

Also ; this is the actual BUILD, the first line went fine with 5 succeeded, its when i do the actual build it does this.

Huppy

03-19-2011, 10:40 PM

dranovir45 > have you double checked ALL the steps involved with the
"custom" installation of the needed programs (zlib, perl, mysql & 2008 express)
listed in the guide here ? (steps 2,3,4 and 5)
Not sure what OS your using (32 bit or 64).
I have all of those installed on my vista box for my home server and I am
constantly re-compiling, as updates are commited to the svn download.
I have never had these problems compiling at any time, so I am not really
sure why you are having them.

dranovir45

03-19-2011, 10:48 PM

Im using a 64 bit, but the files im using are 32 bit as the guide said ; the only thing i didnt really know how to compile was the whole perl thing cus there was no yes or no thing, i just did the command prompt installs, my Zlib i did properly, along with everything else (yes even the SQL) and it seems the error is with the SQL but i know for a fact im downloading EVERYTHING right with it, but ima try one more install thing and if that doesnt work i dont know really. but hopefuly if anything else occurs u will be on for a lil more guidance

does SQL essentials make the differnece in this, i saw you also said for perl it should be "1007" or something but mine is 1008 cus 1007 wasnt available.

Huppy

03-19-2011, 11:08 PM

You do not want to download "essentials", just the plain mysql
Did you not get asked any installation questions when installing perl ?
Its usually a .bat file to click on and opens a command window, at least the
version I installed did.

dranovir45

03-19-2011, 11:14 PM

Alrighty, i did regular mysql the only thing im trying different is instead of typing it in im just setting to the the Program file (x86) C:\mysql file hoping that will do something not sure though, ive tried alot of things, i guess this time ill also try reinstalling perl, though i still dont think thats the problem im getting but always worth a shot ;)

Actually my solution above did work, only new problem is my Quests folder already has a green check, how do i revise it to the http://projecteqquests.googlecode.com/svn/trunk/quests

dranovir45

03-19-2011, 11:28 PM

Edit: when i try to change it, it does this

Switch C:\eqemu\quests to http://projecteqquests.googlecode.com/svn/trunk/quests, Revision HEAD
Repository UUID '858f6fc0-2484-11de-a087-198e6c7179d9' doesn't match expected
UUID '1db01234-8a6e-11dd-8937-b3a01dae0fbe'

I deleted the old files like Maps and Quests and made news one that could actually have the URL process done to it, dont know if that works but we will see.

Bamzal

03-20-2011, 02:16 AM

I am encountering compiling falures as well. I am currently at 2/5 successful.

ActivePerl 5.10.1 Build 1008
Microsoft Visual C++ 2008 Express
MySQL Server 5.5.9
zlib 1.2.3

Ended up 1/4 success - they were failing because it could not find "zlib.lib"

I notice that a "zlib.lib" file was not included in my zlib download. Found this forum (http://www.eqemulator.org/forums/showthread.php?t=28678) which confirms that the official zip file calls the lib "zdll.lib" instead of "zlib.lib". So I made a copy of "zdll.lib" named "zlib.lib" and the compiler can now find that file...

However, that brought me to 2/5 sucessful and the other 3 are all failing on the same issue.

The 3 build failures are identical for World, Zone, and ucs, and happens during the linking stage:

2>Linking...
2>mysqlclient.lib(inflate.obj) : error LNK2005: _inflateInit2_ already defined in zlib.lib(zlib1.dll)
2>mysqlclient.lib(inflate.obj) : error LNK2005: _inflate already defined in zlib.lib(zlib1.dll)
2>mysqlclient.lib(inflate.obj) : error LNK2005: _inflateEnd already defined in zlib.lib(zlib1.dll)
2>.\../build/World.exe : fatal error LNK1169: one or more multiply defined symbols found
2>World - 4 error(s), 2 warning(s)

The guide was going smoothly until it told me to add "C:\mysql\lib\opt" to the INCLUDE list in Visual Studio because that directory did not exist. So I just added "C:\mysql\lib\" and continued...

Not sure why that directory is missing because I installed all components of the MySQL server (confirmed by going into add/remove programs > change).

Downloaded this MySQL Connector C++ 1.1.0 which seems to actually contain a "mysql\lib\opt\" folder, but that did not have an affect either way...

Since I had a "mysql\lib\opt\" path now, i tried removing "c:\mysql\lib\" but then the linker fails with this reason:

LINK : fatal error LNK1104: cannot open file 'mysqlclient.lib'.

So it seems that I need to have "mysql\lib\" in the LIBRARY list, which puts me back to the previous error.

I believe my problem is somewhere between MySQL Server and zlib.

My thoughts are that with recent changes to MySQL there is no "opt" folder but just "lib" folder?

Also, in the zlib USAGE file and it states:

- If you wish, you may rename "zdll.exp" to "zlib1.exp", and/or
rename "zdll.lib" to "zlib1.lib".

It doesnt mention renaming it to "zlib.lib" possibly because it knows thats not compatible?

Either way, I tried naming the file to "zlib1.lib" and it brings me back to my first error: LINK : fatal error LNK1104: cannot open file 'zlib.lib'.

Now I feel strongly that perhaps recent updates with zlib and MySQL are conflicting with each calling their own "zlib.lib", and maybe zlib is recommending use zlib1.lib instead.

So what I think I need to do is somehow tell the Linker process to use zlib's "zlib1.lib" instead of "zlib.lib".

Any suggestions?
Thx

lerxst2112

03-20-2011, 03:03 AM

Bamzal

03-20-2011, 03:22 AM

If you downloaded the zlib file from the link in the first post and extracted it properly you would have zlib1.dll and some text files in the root directory and 3 directories named include, lib, test. The zlib.lib file is in the lib directory and that is where you should point the compiler.

I use MySQL 5.0.91 and have no trouble with missing files. You might try the older version as it seems you have either installed improperly or the layout and location of files has changed.

You shouldn't ever have to rename files in order to get this to work. If you find yourself missing files it is always going to be that you downloaded the wrong thing or installed it improperly.

This link? For Zlib, go here -
http://sourceforge.net/projects/libpng/files/zlib/1.2.3/zlib123-dll.zip/download

Just checked, same one as I previsouy had. There is NO zlib.lib file contained in that zip.

Obvously something has changed.

In the LIB directory, there is:
zdll.lib
zdll.exp
zlib.def

lerxst2112

03-20-2011, 04:30 AM

Try here: http://sourceforge.net/projects/gnuwin32/files/zlib/1.2.3/

You'll need both the bin and lib files extracted to the same place.

You may have to fiddle with the order of the library directories to get it to work properly. MySQL also distributes zlib.lib and if they are not the same version you will have linking errors as you saw. If you put the MySQL directory above the zLib directory it should work.

dranovir45

03-20-2011, 05:05 AM

Ok, when trying to do the 1711 file as shown here

So first click on the 1711 file called 1711_account_restricted_aa.sql and click Open
Then click Start. It will source that sql in to your database.

It will say this when i try

[Err] ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
[Err] 1146 - Table 'peq.account' doesn't exist
[Err] UPDATE `account` SET `time_creation` = UNIX_TIMESTAMP() WHERE `time_creation` = 0;
[Msg] Finished - Unsuccessfully

any ideas on how to fix this?

; I saw in guide it told me to delete first 3 lines ( that was the whole file basically ) but i did it and i just get
[Msg] Finished - 0 queries executed successfully

Also; when i try anything else i get

[Err] 1146 - Table 'peq.rule_values' doesn't exist
[Err] INSERT INTO `rule_values` (`ruleset_id`, `rule_name`, `rule_value`, `notes`) VALUES (1, 'Combat:NPCBashKickStunChance', '15', 'Percent chance that a bash/kick will stun');
[Msg] Finished - Unsuccessfully

lerxst2112

03-20-2011, 05:42 AM

Looks like you missed step 15 or typoed somewhere along the way.

dranovir45

03-20-2011, 06:09 AM

Now lets say i did miss something (cus i did ><) is it easy fix to just do it and a fix will happens or what exactly?

dranovir45

03-20-2011, 06:55 AM

Ok, i typed my IP into the internet browser ( im with AT&T ) anyone work with them that knows how to forwards ports on the page, if so plesae let me know.

Zandig

03-20-2011, 10:41 AM

Compiling with MySQL Server 5.5.9 will fail as it's not supported.
I use 5.1.56 (32 bit version) which works fine.

Bamzal

03-20-2011, 12:26 PM

Thank you Zandig and lerxst2112.

I now have a legit looking zlib but still running into the same errors:
"mysqlclient.lib(inflate.obj) : error LNK2005: _inflate already defined in zlib.lib(zlib1.dll)"

My thought is that MySQL is now the problem, and Zandig you just confirmed my assumption.

I will try downgrading right now and report back.

dranovir45

03-20-2011, 01:39 PM

Bamzal

03-20-2011, 01:54 PM

Got it working... 5/5 successful.

Uninstalled MySQL 5.5 and installed 5.1. Right off the bat things were looking much better - MySQL actually came with that "/lib/opt/" folder.

However then I ran into errors using the zlib that I was recently suggested trying.

I had to go back to the original zlib download from the original post, download that package even though it only contains a "zdll.lib" and not a "zlib.lib". Then I just renamed "zdll.lib" to "zlib.lib" and it started working fine. Using that other zlib that you suggested lerxst2112 was causing errors in zconf.h while compiling.

So my understanding is that part of my problem was that I accidentally downloaded a newer version of MySQL.

But another part of the problem is that the suggested zlib download has since changed and you actually need to rename the "zdll.lib" to "zlib.lib" in the lib folder, in order for it to work.

Thanks for all the help again.
-Bamzal

Bamzal

03-20-2011, 04:07 PM

Can someone dummy down this part for me please ;; i use AT&T 2wire router and such and watching guides, it makes sense (none of these guides are about eqemu making but for other games and the general idea on how to open ports and such) but the numbers posted here make no sense on where they are supposed to go " Log in to your router and you need to forward the following ports to the internal
ip of your server computer : (These are the ones that worked for me)

5998, 5999
7000 to 7100 (Port Range Forwarding is essential for this)
9000

http://s1106.photobucket.com/albums/h379/Nanarson_Lord/?action=view&current=2wireATTsetup.png

Those are the TCP and UDP port numbers that you should allow pass-through from your router to your server's local IP address.

You need to log onto your routers configuration page - a webpage. You type the local IP address of your router into a web browser to access it.

Find the local IP address of your router by going start>run>cmd then command prompt opens then type "ipconfig /all" and look for the IP associated with "Default Gateway" and that is the local IP address of your router (the one you type into your web browser). *unless you are not using a router but directly connecting your PC to a modem*

When I log in to my router's configuration page it has a section to specify port ranges and local IP addresses to allow the port open for.

Ie:
Allow / Enabled
192.168.1.1 BOTH (as in TCP and UDP) 7000 - 7100
and repeat for the others.

Hope that helps.

Edit: I just saw your picture...

Application Name is just a name for those saved settings on your router. Since you need multiple I just call mine Eq1, Eq2, etc. They have no bearing.

Looks like you cannot select "Both" so you need to repeat the process to open TCP and UDP, I am not sure which is required exactly.

Timeout I suggest using the default, same with Port Mapping. The router does not need to do any source/destination mapping.

5998 would go in the "From" Port(or Range) field, and 5999 would go in the "To" field.

Save the settings, then repeat the setup but with a different name and put 9000 into both "From" and "To" fields.

Keep repeating that process until all ports you need are open.

dranovir45

03-20-2011, 08:33 PM

What am i supposed to do with the 7000-7100 thing though, i dont see anywhere for me to tweak those anywhere

dranovir45

03-20-2011, 09:15 PM

Also; bamzal could u show me what ur folder looks like or in terms look at mine and see the error im getting nad hopefuly guide me from there? would be great.

http://s1106.photobucket.com/albums/h379/Nanarson_Lord/?action=view&current=Whatmysetuplookslikeerrorimgetting.png

lerxst2112

03-20-2011, 11:43 PM

You have no config file. The eqemu_config.xml.full is supposed to be copied to eqemu_config.xml and edited to suit your needs.

dranovir45

03-20-2011, 11:48 PM

I made that change, finally made progress, then got this ...

http://s1106.photobucket.com/albums/h379/Nanarson_Lord/?action=view&current=Error.png

Huppy

03-21-2011, 03:37 AM

This link? For Zlib, go here -
http://sourceforge.net/projects/libpng/files/zlib/1.2.3/zlib123-dll.zip/download

Just checked, same one as I previsouy had. There is NO zlib.lib file contained in that zip.

Obvously something has changed.

In the LIB directory, there is:
zdll.lib
zdll.exp
zlib.def

By the way I just went to the link I posted for the download of ZLIB.
I downloaded the zip file it points to and extracted it (TODAY) and it does
contain all the files you need. (INCLUDING the ZLIB1.dll that needs to be
copied over to the windows system folder) (ZLIB1.dll - NOT ZLIB.dll)
THIS FILE -ZLIB1.dll is right in the main extract of the zip file when you
download it. (You can see it when you open up the zip file before you even
extract it all) (I use WinRAR)
Once you extract the zlib folder to your c-drive, and copy that zlib1.dll
you don't need to do anything else with it.
When you are adding the folders to your 2008 express, keep in mind, you
are looking for FOLDER NAMES, not file names.

lerxst2112

03-21-2011, 04:20 AM

The issue is with the library name, not the DLL, and it has in fact been renamed for whatever reason. I've used that link many times before as well, and it was always named properly when I've downloaded it, but it has been a few months since I've done so.

Annoying, but easily fixable if necessary. Some people might not even notice the rename since MySQL also includes the library and if that directory is searched first it would choose that file to link against and not even look in the zlib directory.

dranovir45

03-21-2011, 08:45 AM

I made that change, finally made progress, then got this ...

http://s1106.photobucket.com/albums/h379/Nanarson_Lord/?action=view&current=Error.png

Anyone know exactly what is what at this point, ive read whole guide word for word, it should "be working now" im thinking ive missed a few lil key things and hoping that message could give you guys hints on whats going on.

Zandig

03-21-2011, 02:34 PM

The most up to date compile guide can always be found in the Wiki:
http://www.eqemulator.net/wiki/wikka.php?wakka=VS2008

I don't have ZLIB1.DLL in my 'windows/system32' directory and it compiles properly. I only have that file in the c:\zlib directory where it belongs.....for what it's worth.

sorvani

03-21-2011, 03:20 PM

i find the wiki hard to use, but maybe that's just me.
Maybe the landing page for the wiki needs redone somehow to help drive things better, I dunno.

dranovir45

03-21-2011, 06:55 PM

Still getting same error as posted above ; and still seeking an answer for what im supposed to do with the 7000-7100 (following bamzal's advice i made multiple files with the ports etc using from:5998 to: 5999 and making the other shit standard, along with making it 9000 to 9000 when making another TCP, UPD or w/e is different im told but what exactly then, this mean i need 7000-7100 for UPD ?

Zandig

03-21-2011, 07:49 PM

i find the wiki hard to use, but maybe that's just me.
Maybe the landing page for the wiki needs redone somehow to help drive things better, I dunno.

I agree the server setup guide in the Wiki is lacking (this thread is much better for that). However I always keep the compile guide up to date on the Wiki.

Dylan1994

03-27-2011, 07:28 PM

THANKS YOU FOR THIS GUIDE!!!!!!!

For the longest time I havent been able to get his thing working.. Well i got it working now.. Thanks. That's all I have to say!

Karamanos

03-28-2011, 06:30 PM

K So when I ran the build 3 succeeded 2 failed. All the errors are Perl related, When I looked my Perl is 64 bit assuming this is the problem and going to reinstall. Will post results after

2 succeeded, 3 up to date!

Versalin

03-28-2011, 07:01 PM

any idea why when I try to have MySql do the execute part it freezes up and wont continue. I think its getting stuck in the Processing config part. The very beginning.

Dokuton

03-28-2011, 11:35 PM

11. Ok, Now you need to download the Maps and quests.

In your server folder, right click on the quests folder and choose "SVN Checkout"
In the "URL of repository" line copy and paste the following:
http://projecteqquests.googlecode.com/svn/trunk/quests (Then click on OK)

So how can i do a CVN CHECKOUT if the quest folder is ALREADY been CVN checkout'd out?!?! So frustrating, it doesn't give the option because its already got a URL, you know the folders already got a green check mark, How do i work around this? MERGE?

Please help me... i just slamed into a wall with this, there is NO option in turtle CVN or w/e to CVN checkout something thats already allocated to another URL..... So what option did you actually Mean for your pupils to use?

pfyon

03-29-2011, 08:25 AM

If you already have a checked out version and you need to update it to the most recent, you use 'svn update'.

sorvani

03-29-2011, 10:09 AM

So what option did you actually Mean for your pupils to use?
He meant the option he stated because the instructions are based on never having set anything up before. You obviously have not followed the instructions if you already have various SVN's set up.

Dokuton

03-29-2011, 04:09 PM

Well the quest folder i copied and pasted came from a folder that already had been CVN checkout'd. So it made the quest folder already had a URL.I followed everything to a T...

In the End i just used the Merge option and merged the two URLs... my server is up and running idk if it will cause problems.. there was no option to CVN checkout the Quest/map folders since they like i said were already assigned URL's from the moment the Source folder was CVN'd much earlier in the guide.

chipotle

03-30-2011, 05:03 PM

I'm stuck with the compile. I've started completely over and landed on the same error twice. Can someone tell me what I'm doing wrong.

c:\source\trunk\eqemuserver\common\dbcore.h(9): fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory

Rikon

03-30-2011, 08:12 PM

I did everything to to a "T" and still got hung up on this step...

So now, its time to click on the top menu called Build and choose "Build" from that one.
It will start building the server for you. Don't pay any attention to the warnings and
crap that goes up the window, A lot of it doesn't mean anything.
All you have to hope for, is when its done, it will give that same line again:
Build: 5 succeeded 0 failed 0 up-to-date 0 skipped
THIS WILL TAKE AWHILE TO BUILD - HAVE A COFFEE!

I am showing 1 succeeded and 4 failed. Any suggestions?

Rikon

03-30-2011, 08:45 PM

I have it up to 2/5. Better than nothing :)

EDIT: Removed

lerxst2112

03-30-2011, 08:49 PM

You either do not have MySQL properly installed, or you did not follow the steps to add the directories to Visual Studio.

Rikon

03-30-2011, 08:55 PM

You either do not have MySQL properly installed, or you did not follow the steps to add the directories to Visual Studio.

Thanks Lerxst, you are correct. I skipped a paragraph it would seem. Thanks.

Rikon

03-30-2011, 09:25 PM

11. Ok, Now you need to download the Maps and quests.

In your server folder, right click on the quests folder and choose "SVN Checkout"
In the "URL of repository" line copy and paste the following:
http://projecteqquests.googlecode.com/svn/trunk/quests (Then click on OK)

Let it download the quests. It will show "At Revision xx when done.

Next, in your server folder, right click on the Maps folder and choose "SVN Checkout"
In the "URL of repository" line copy and paste the following:

http://eqemu-maps.googlecode.com/svn/trunk/ (then click OK)

This will take awhile, have a coffee

I don't have the option to select "SVN Checkout" when I right-click these folders. Does anyone know what I am doing incorrectly? I only see:

SVN Update
SVN Commit...
TortoiseSVN

joligario

03-30-2011, 09:33 PM

If it says update/commit, then you have already checked out the folder before. Does it have a green checkmark on the folder?

Rikon

03-30-2011, 09:35 PM

Yes, it has a green check mark. But when I click on the folders, there is nothing inside but '.keep' ...as if it didn't update/download anything.

joligario

03-30-2011, 09:38 PM

Looks like you might have checked out the wrong folder. Delete the .svn folder inside and re-checkout.

Rikon

03-30-2011, 09:39 PM

Cool. Thanks Joligario :)

Jhail83

03-30-2011, 11:28 PM

Tried using VS C++ 2010 express but i couldnt get all 5 to build. 2 kept saying it couldnt find perl510.lib

I couldnt even find that file in the perl directory, i did find a 512.lib however. Is it because my perl is a newer version perhaps? Im a little new at this so forgive me. :)

chipotle

03-31-2011, 09:17 AM

Someone said I didn't have the VC++ directories set up properly. In my version of MS Visual C++, i get the following when I follow the directions:

VC++ Directories editing in Tools > Options has been deprecated. VC++ Directories are now available as a user property sheet that is added by default to all projects.

I right clicked all 5 projects and added the appropriate directories to each of the projects there. Is that not correct?

Edit: Nevermind. I grabbed 2010 instead of 2008 by mistake.

dranovir45

04-06-2011, 09:02 AM

Been waiting on a reply for over a month now, ive redone the WHOLE thing, and i did it properly, but only thing that is still stumping me is the where am i supposed to put the 7000-7100 port thing, is it for TCP or UDP, cus i put 9000-9000 for UDP and TCP aswell has the 5000 for both like i was told. But no idea for the 7000 & im still getting this error when trying to start it once again

http://s1106.photobucket.com/albums/h379/Nanarson_Lord/?action=view&current=Error.png

joligario

04-06-2011, 09:57 AM

Your zones should be UDP. Your 9000 should be TCP. Did you allow world/zone through your firewall?

dranovir45

04-07-2011, 06:03 PM

still having the same problem. this is what my current set up for UDP/TCP looks like.

http://s1106.photobucket.com/albums/h379/Nanarson_Lord/?action=view&current=Current.png

joligario

04-07-2011, 07:43 PM

Based upon your previous post, I didn't think you had a port problem anyways. What does your emu config look like?

dranovir45

04-07-2011, 09:42 PM

Based upon your previous post, I didn't think you had a port problem anyways. What does your emu config look like?

http://s1106.photobucket.com/albums/h379/Nanarson_Lord/?action=view&current=Part1.png

http://s1106.photobucket.com/albums/h379/Nanarson_Lord/?action=view&current=Part2.png

the whole file is right there.

joligario

04-08-2011, 01:19 AM

I didn't see an answer from a question previously: did you allow world.exe and zone.exe through windows firewall? Also, what does your start.bat file look like?

dranovir45

04-08-2011, 04:45 PM

I didn't see an answer from a question previously: did you allow world.exe and zone.exe through windows firewall? Also, what does your start.bat file look like?

I never saw that question; how do u allow ur world.exe and zone.exe through firewall? and start.bat looks exactly like whats told to be posted.

http://s1106.photobucket.com/albums/h379/Nanarson_Lord/?action=view&current=Start-bat.png

Edit: I see question now, sorry bout ignoring that man.

joligario

04-08-2011, 05:47 PM

Looks like you have Win7.

Go to Start -> Control Panel -> Windows Firewall
Verify the profile your current connection you are using is Home/Work (Private) network
Select Advanced Settings on the left
Select inbound. Scroll down to see if World and Zone are listed. If they are, ensure it matches your type of network (Private) and that it is set to Allow. If not, create a new rule for World.exe and Zone.exe files to allow on your private network. You may create public rules in addition if you want, but not necessary if your network is set to private and it will stay that way.

If allowing through the firewall doesn't solve it, try starting up the command prompt and running each of your start.bat commands individually. Start with world.exe and see what it says (copy/paste is better as the window should scroll). I suspect you should find your problem at this point.

dranovir45

04-08-2011, 06:32 PM

joligario

04-08-2011, 06:45 PM

Start -> Run -> Command Prompt
Change to your eqemu directory
Type start world.exe and press enter
Copy/Paste everything from the world.exe window that opens up.

dranovir45

04-08-2011, 06:50 PM

Start -> Run -> Command Prompt
Change to your eqemu directory
\.

How do i change it to my eqemu directory.

dranovir45

04-08-2011, 08:16 PM

When i go into Command Prompt, and type start world.exe and start eqlauncher.exe or w/e it says cannot be found.

lerxst2112

04-08-2011, 08:34 PM

cd c:\server or wherever your server files are.

dranovir45

04-08-2011, 09:11 PM

cd c:\server or wherever your server files are.

I did that thanks, problem being, when i tried both suggestions made earlier to plug into when at c:/eqemu it just flashes a command prompt screen up real fast and closes

dranovir45

04-08-2011, 10:34 PM

When i didnt add the start command into the command prompt, i get this.

http://s1106.photobucket.com/albums/h379/Nanarson_Lord/?action=view&current=Odd.png

joligario

04-09-2011, 08:11 AM

Your database is not named 'eq'. What is your database name?

dranovir45

04-09-2011, 08:17 AM

Your database is not named 'eq'. What is your database name?

Exactly what do you mean, like the name of my folder? or what.

joligario

04-09-2011, 08:56 AM

No, the database has a name. In one of the steps it should have told you to type in "CREATE DATABASE XXX" and then "USE XXX". What did you use?

dranovir45

04-09-2011, 09:05 AM

No, the database has a name. In one of the steps it should have told you to type in "CREATE DATABASE XXX" and then "USE XXX". What did you use?

"Then right click on that same name (localhost_3306) and choose New Database...
In the next window, in the first line, type peq (then click OK)
Close Navicat Lite."

I named it what it says, peq?

joligario

04-09-2011, 09:24 AM

So in your config, change the database from "eq" to "peq"

Also I recommend setting your default status to 0

wolfwalkereci

04-09-2011, 09:28 AM

Wow reading your thread and saw how you mentioned you had issues for over a month. Wish I would have checked it sooner, I am no expert at this but I would have sat down to go over it with you.
Hope you get the DB connection fixed and it works for you.
Post an update when you do.

dranovir45

04-09-2011, 09:35 AM

So in your config, change the database from "eq" to "peq"

Also I recommend setting your default status to 0

wow i made alot of progress, same getting a TCP:9000 error though :/

Edit: umm actually its doing something completly new now, now it says wait 2000 miliseconds before booting the next zone, thats where its at though. I havent seen it do anything, whats supposed to happen once they command prompts run?

Re-Edit: i read that it stops at 5, both my world.exe and the 0:Sleeping stop at 5, and they have zero errors ; i found that out myself, i went to connect to it, and i dont even get like a loading screen to server select, any ideas?

dranovir45

04-09-2011, 09:57 AM

This is what i get when i try to connect

http://s1106.photobucket.com/albums/h379/Nanarson_Lord/?action=view&current=StreamNet.png

dranovir45

04-09-2011, 10:05 AM

This is what i get when i try to connect

http://s1106.photobucket.com/albums/h379/Nanarson_Lord/?action=view&current=StreamNet.png

I actually go to the point of making a char, but when i hit enter world, froze at Entering Crescent Reach. this is what my world.exe looks like atm with that going on.

http://s1106.photobucket.com/albums/h379/Nanarson_Lord/?action=view&current=UnknownDiss.png

http://s1106.photobucket.com/albums/h379/Nanarson_Lord/?action=view&current=Interesting.png

dranovir45

04-09-2011, 10:25 AM

I got a toon up and running actually in tutortial, now i know this isnt meant for thread, but i have looked all over forums, i cant find 2 things. 1. It says im a GM, but i have no commands, 2. How exactly do i code, like i see they add the links to code, but am i just supposed to put that in a blank notepad thingie or what, figured id ask you guys cus u seem pretty expert in what you do, and seems u guys prob run your own.

dranovir45

04-09-2011, 02:26 PM

Staer

04-20-2011, 01:14 PM

I've spent 6 hours trying to set up my own server (thanks, this guide is fantastic), however something has gone wrong.

---------------------------------------------
[04.20. - 18:38:13] Starting Log: logs/eqemu_debug_3428.log
[04.20. - 18:38:13] [LAUNCHER__INIT] Loading server configuration..
[04.20. - 18:38:14] [NET__WORLD] WorldConnection connect: Connecting to the server localhost:9000 failed: TCPConnection::Connect(): connect() failed. Error: 10061
[04.20. - 18:38:14] [LAUNCHER__ERROR] worldserver.Connect() FAILED! Will retry.
[04.20. - 18:38:14] [LAUNCHER__INIT] Starting main loop...

_____

---------------------------------------------
[04.20. - 18:41:37] Starting Log: logs/eqemu_debug_world_2820.log
[04.20. - 18:41:37] [WORLD__INIT] Loading server configuration..
[04.20. - 18:41:37] [WORLD__INIT] Log settings loaded from log.ini
[04.20. - 18:41:37] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEmulator 0.8.0
[04.20. - 18:41:37] [WORLD__INIT] Added loginserver eqemulator.net:5998
[04.20. - 18:41:37] [WORLD__INIT] Connecting to MySQL...
[04.20. - 18:41:37] [WORLD__INIT_ERR] Cannot continue without a database connection.

joligario

04-20-2011, 04:02 PM

It's not connecting to the database. Follow the same troubleshooting procedures and you should find out why.

eski2

05-05-2011, 10:56 AM

Eqemu login server gives the error below. Can someone give me a hint what might be wrong?

[Debug] [05.06.11 - 00:49:05] Logging System Init.
[Debug] [05.06.11 - 00:49:05] Config System Init.
[Debug] [05.06.11 - 00:49:05] MySQL Database Init.
[Debug] [05.06.11 - 00:49:08] Encryption Initialize.
[Debug] [05.06.11 - 00:49:08] Encryption Loaded Successfully.
[Debug] [05.06.11 - 00:49:08] Server Manager Initialize.
[Network] [05.06.11 - 00:49:08] ServerManager listening on port 5998
[Debug] [05.06.11 - 00:49:08] Client Manager Initialize.
[Network] [05.06.11 - 00:49:08] ClientManager listening on Titanium stream.
[Network] [05.06.11 - 00:49:08] ClientManager listening on SoD stream.
[Debug] [05.06.11 - 00:49:08] Server Started.
[Network] [05.06.11 - 00:49:16] New world server connection from 127.0.0.1:64849

[Database] [05.06.11 - 00:49:16] Mysql query failed: SELECT WSR.ServerID, WSR.Se
rverTagDescription, WSR.ServerTrusted, SLT.ServerListTypeID, SLT.ServerListTypeD
escription, WSR.ServerAdminID FROM tblWorldServerRegistration AS WSR JOIN tblSer
verListType AS SLT ON WSR.ServerListTypeID = SLT.ServerListTypeID WHERE WSR.Serv
erLongName = 'SoloMan' AND WSR.ServerShortName = 'SoloMan'
[World] [05.06.11 - 00:49:16] Server SoloMan(SoloMan) attempted to log in but da
tabase couldn't find an entry but unregistered servers are allowed.
[Database] [05.06.11 - 00:49:16] Mysql query failed: SELECT max(ServerID) FROM t
blWorldServerRegistration
[Database] [05.06.11 - 00:49:16] Mysql query failed: UPDATE tblWorldServerRegist
ration SET ServerLastLoginDate = now(), ServerLastIPAddr = '127.0.0.1' where Ser
verID = 0

Astal

05-21-2011, 01:16 AM

http://media.giantbomb.com/uploads/4/45270/1289119-this_thread_again_super.jpg

just kidding, good job man

drumbler100

05-26-2011, 07:38 AM

Have done everything from all of the steps in the original post. start bat looks the same and eqemu_config looks the same (only changing the servername and mysql password in their as asked and changing from 5998 to 5999 since running underfoot)

Firewall is allowing zone and world, router is setup. and after running start.bat getting the [LAUNCHER_ERROR] Wolrd told us to start zone dynamic_01 but it is already running.

Running world.exe from the command prompt there are no problems, but running zone.exe I get [Debug] [NET_WORLD] Worldconnection connect: connecting to the server localhost:9000: TCPConnection::Connect<>: connect<> failed. error 10061

Setrutysewet

05-30-2011, 07:29 PM

some help please on step 13

13.First, go to your C-Drive and right click on the folder you made called peqdb
and choose "SVN Checkout"
In the "URL of repository" line copy and paste the following:
http://projecteqdb.googlecode.com/svn/trunk/peqdatabase (then click OK)
It will finish with "At Revision XX"

Next, go to that folder peqdb and unzip the file from peqdb_rev1751.sql.gz
to the same peqdb folder.
This file will be named peqdb_rev1751.sql (without the .gz)

The peqdb_revXXXX.sql.gz file does not appear in the http://projecteqdb.googlecode.com/svn/trunk/peqdatabase location

Please advise.

image

05-30-2011, 09:38 PM

Go into the updates directory of that folder you were just in. The revision sql's are there just not gzipped.

Edit: Actually I think you want a completely different google project - this isn't the EQEMu google project.

This has all the latest sql revisions:
http://projecteqemu.googlecode.com/svn/trunk/EQEmuServer/utils/sql/svn/

joligario

05-30-2011, 09:54 PM

No, he's looking for the database. It's just not named peqdb_revXXXX.sql.gz.

Strut: Just grab the latest database.

lerxst2112

05-30-2011, 09:58 PM

The file is named database_incremental.zip now.

sorvani

05-30-2011, 10:33 PM

that is because the person who does the normal release is gone for a bit. you can basically consider this release peqdb_rev1900.sql.gz as you will need to source in sql 1908 and >

Setrutysewet

05-30-2011, 11:10 PM

Thanks guys :) so for following this guide I should use database_incremental.zip ?

sounds good to me,

Also, if any of you have the time I would really appreciate any suggestions on how I would be able to make custom spells, AA's, zones, and quests.

Also I have an eqlive account and would like to collect data from it, such as Alternate Abilities from OOW to HoT and zone info for end game zones between OOW and on to HoT, any advice or direction to this end would also be greatly appreciated

sorvani

05-31-2011, 09:18 AM

There is a packet collection application in the SVN. Build and run that for the packet collects.

There is a location they can be uploaded over on the PEQ website.

AsmoTiC

06-08-2011, 08:47 AM

Just a quick note. I ran through this guide last night (June 7th 2011) and everything worked out. Couple quick notes however.

Step 5. I couldn't get 2008 Express, and ended up with 2010. The major difference as far as the guide is concerned is that when you setup the search paths, it has to be done after you open (and convert) the server project. I couldn't find a way to setup the search path for the whole project, so ended up doing it 5 times for each of the programs. Clicking on one, then going to Project Properties will give you the option to edit the search paths.

Step 13. As noted above, the current peq database doesn't contain the "peqdb_revxxx.sql" file. I tried using the dump file that was provided, but after loading into the server, the world wasn't populated. I plan to go back to the 1751 database, which you can get from PEQ's website, and patch it back up tonight.

Otherwise, the install worked fine with current downloads of all the listed software. I believe Perl 5.1.1007 isn't available, however 1008 worked fine. There is a new version still, but I stuck with 1008. Also, MySQL 5.1.54 isn't available, but the new version 5.1.57 I believe worked too. Again, other than the tweek to 2010 Express the guide works if you follow it to the letter.

Now to get the database working....

sorvani

06-08-2011, 11:39 AM

you are missing required sql 1908 from the SVN. As noted many times the intermediate DB dump that was provided can basically be considered rev1900.

Use the current DB and source in the required SQL updates > 1900.

re vb 2008 look aroudn the MS site closer and you will see the links for prior versions.

lerxst2112

06-08-2011, 01:31 PM

http://msdn.microsoft.com/en-us/express/future/bb421473

Relyt

06-30-2011, 10:07 AM

I'm only successfully building three of the five files?

Kayen

06-30-2011, 10:26 AM

If your using perl 5.12 which is what is freely available now.

You will need to rename file perl512.lib to perl510.lib

That worked for me when recently trying to set up a server and getting the 3/5 issue.

Relyt

06-30-2011, 10:37 AM

Thank you for the hasty response, Kayen. I really appreciate it! I will try it and report back.

Edit: It's building perfect now, thanks!

Relyt

06-30-2011, 01:48 PM

I've completed every step and I'm able to see my server and enter character select. However, I can't enter the world. My world.exe output is simply repeating, "Attempting autobootup of <zone>" I use Titanium.

Melandril

07-26-2011, 03:20 AM

I think I'm up and running. Had 0 compile issues (after getting the x86 version of MySQL and correctly referencing the Includes and Libraries in VSe2008 C++). And I was able to apply the updates from 1711 on to the file called db_dump (which I assume to be the right one...). When I run the launcher (start.bat), I do get two windows and no errors.

What else do I need to do get my server to show up on the public list? I know the router part is something I'll have to do; but is there anything else I could be missing? (probably just this. asking anyway just in case.)

Also, can anyone point me to a good tutorial on mini-login? Not sure if it matters, but I'm thinking it would be nice to do some custom stuff in private before opening the server. (Not that I expect much traffic.) Or, if you recommend any other methods for internal testing, that would be cool too ;-)

michaelw2000

07-26-2011, 10:02 PM

I have set up a complete server with an XP machine and am currently moving to a windows 7 server.

Well when i try to downlad the source code with tortoise 64bit it hangs up. I dont get the same error each time but it mostly contains time outs from the repo. I use kapersky and have turned entire firewall and antivirus off to try to get code and it still hangs. I can hang up at 2mb transfered or even up to 60mb transfered.

Somebody has to have the same problem i did. So i am begging for help because searching all over web and these forums with errors has given me no resolve.
I currently have 2 complete days invested in this svn update and it is driving me nuts. Please help.
Thank you

Melandril

07-27-2011, 02:11 AM

michaelw2000

07-27-2011, 03:16 PM

I know this doesn't answer your question, but I too am on Win7x64 and have Kapersky antivirus (came with the motherboard...). I did not run into issues with using tortoise.

Perhaps you can include some of the error messages ?

i fixed the problem. here is what it was so others may not have to search for days like i did.

my puter came with a download utility called AKAMAI net session, and this utility controls downloads over all the platforms (like .net and internet explorer and others). I took this off and disabled the file antivirus and BAM it worked.

So it was the combo of the 2 that cause DL issues cause i tried while just disable the antivirus and nothing worked. I took off the utility and no go. I did the combo of the 2 and got it done.

Also for others who have this AKAMAI utility on there machines. Well my download speed increased by almost 2 fold. This came installed on my asus puter.

Thank you for reply and keep up the good work everyone cause you all make this a great community.

Emmeric

08-20-2011, 03:47 PM

I've spent days trying this Guide. Many download requirements are out of date and are extremely difficult to find, if at all. Perl 5.10 in no longer free and Strawberry perl seems to have errors.

My build gets stuck. Yesterday it was 1 success. Today it is 2 by virtue of downgrading my MySQL, with 2 failures and 1 Up to dates. Both failures are this:

fatal error LNK1104: cannot open file "'perl510.lib'"

Any ideas before I give up completely? Try a more up-to-date guide? Otherwise, it looks like the advancement of software has outpaced eqemu.

lerxst2112

08-20-2011, 04:07 PM

Emmeric

08-20-2011, 05:18 PM

Find the two lines in the source code that look like this:

#pragma comment(lib, "perl510.lib")

Change the 510 to whatever version of perl you are using, like 512.

What are the errors you get with Strawberry perl? What version were you trying to use?

That "source code" - you mean look for that line in the peqdb files?

The Strawberry perl seems to be the only perl I can find to use that isn't too advanced, but perhaps it is. I am assuming the perl510.lib error is because of the Strawberryperl usage.

lerxst2112

08-20-2011, 06:22 PM

Emmeric

08-21-2011, 01:59 PM

No, the C++ source code. ActiveState 5.12 will probably work, but you would need to modify those lines.

Without you posting the errors you get using Strawberry I can't even guess what the problem is.

Hunted a bit through 2008 C# files and haven't seen anything that contains source code to alter. Tried a cmd insertion but that did nothing.

Where should I be looking?

lerxst2112

08-21-2011, 05:06 PM

Emmeric

08-21-2011, 07:39 PM

It's C++, not C#.

When you have the solution open in Visual Studio click the find in files button in the top center of the toolbar. It has an icon that looks like a folder. When the dialog pops up, type perl510 in it and click find all. There should be two places it finds. Double click on each line to go to the file where the line is, and change it, then recompile.

Find all "perl510 ", Whole word, Subfolders, Find Results 1, "Entire Solution", "*.*"
Matching lines: 0 Matching files: 0 Total files searched: 534

Interesting. :rolleyes:

Thank you so far, for your help. I'm not sure I drink enough for this. Don't understand why I got a failure error on trying to open a file the system wanted and then indicates isn't in the code anyway...

blackdragonsdg

08-22-2011, 03:52 AM

Find all "perl510 ", Whole word, Subfolders, Find Results 1, "Entire Solution", "*.*"
Matching lines: 0 Matching files: 0 Total files searched: 534

Interesting. :rolleyes:

Thank you so far, for your help. I'm not sure I drink enough for this. Don't understand why I got a failure error on trying to open a file the system wanted and then indicates isn't in the code anyway...

Check zone/embperl.cpp and world/EQWParser.cpp I think those were the files that needed to be changed.

lerxst2112

08-22-2011, 04:48 AM

Looking at what you posted, there's a space after perl510 that would possibly make it fail.

Find all "perl510", Subfolders, Find Results 1, "Entire Solution", "*.c;*.cpp;*.cxx;*.cc;*.tli;*.tlh;*.h;*.hpp;*.hxx;* .hh;*.inl;*.rc;*.resx;*.idl;*.asm;*.inc"
C:\EQEmu\ServerCode\trunk\EQEmuServer\world\EQWPar ser.cpp(35):#pragma comment(lib, "perl510.lib")
C:\EQEmu\ServerCode\trunk\EQEmuServer\zone\embperl .cpp(26):#pragma comment(lib, "perl510.lib")
Matching lines: 2 Matching files: 2 Total files searched: 534

BrandeX

08-22-2011, 06:46 AM

I just did this with installed version 5.12. Just rename you perl512.lib to perl510.lib it's a lot easier.

Melandril

08-22-2011, 01:10 PM

for what it's worth, I affirm the above statements. As soon as I replaced the perl510 with perl512 (and made sure my MySQL was the 32 bit version....), everything in this guide worked. (Still had to figure out the login piece but eventually figured that out too.)
(The other "gotcha" I missed before getting it working was the section on setting up environment variables...)

Emmeric

08-23-2011, 06:00 PM

Thank you for the responses. With the accurate directions, I changed the target to 512 and received 5 successes.

In Step 10, there are instructions to copy files. Before I go any further, I noted that both the WORLD and ZONE folders have red exclamation points. Inside world, EQWparser is exclamation. Everything else green. Inside zone, embperl is exclamation, everything else green. These two folders cause all the parent files to show exclamation points (C:\EQEmuSVNFiles\EQEmu\trunk\EQEmuServer\)

Should I be concerned about this? I do not want to advance the process only to find these things mattered and have to start over.

If they do matter, could someone indicate precise steps that I can follow to correct this? :-)

Thanks!

lerxst2112

08-23-2011, 07:03 PM

The exclamation point means that a file is changed, or a folder contains one or more files that are changed. It's nothing to worry about.

Emmeric

08-23-2011, 11:27 PM

The exclamation point means that a file is changed, or a folder contains one or more files that are changed. It's nothing to worry about.

Good, thanks.

The attempt to use the peqdb is not working. When downloading the DB using this link in Tortoise SVN (http://projecteqdb.googlecode.com/svn/trunk/peqdatabase), we get a zipped database_incremental. When that is unzipped, a folder named database incremental is formed with a db_dump text file inside. There are no .sql files.

Commands to use either the incremental folder or the dump text do not source the DB as the guide directs.

What should I be doing here? I read through this thread but didn't see a definite or clear answer to this issue.

Thanks for your help so far! Things are proceeding smoothly as long as I stop at every hitch and ask... :-D

BrandeX

08-23-2011, 11:59 PM

Try again. I just d/l and unzipped database_incremental.zip and got db_dump.sql

Do you have "hide file extensions enabled in windows explorer?

Emmeric

08-24-2011, 02:22 PM

Try again. I just d/l and unzipped database_incremental.zip and got db_dump.sql

Do you have "hide file extensions enabled in windows explorer?

:rolleyes:

That was exactly it, thank you.

Received a ton of duplicate errors when running load_player.sql. Nothing I should worry about, I imagine?

Also, should I be running any updates to the incremental file? Most look like optional pre-made modifications if I chose to use them?

Emmeric

08-24-2011, 02:33 PM

I sampled an sql update, #106 Optional proc rules. It returned an unsuccessful update using Navicat.

[Err] 1136 - Column count doesn't match value count at row 1
[Err] insert into rule_values values (0, 'Combat:AdjustProcPerMinute', 'true');
[Msg] Finished - Unsuccessfully

Using Visual C++, I can locate the lines and simply change them there. Would this work? If I make the changes through Vis C++, would I need to run anything again - the build? The mysql db commands?

lerxst2112

08-24-2011, 06:45 PM

Your database is version 1900+, you wouldn't want to apply update 106 to it.

If you look in your rule_values table you should see all of those rules already there.

Emmeric

08-24-2011, 07:14 PM

Yes, it appears most of them are already there, thank you. ;)

I was able to login to the world server, though it showed my server locked. I was able to enter the character creation screen, as was my wife at the same time. This is a very large success considering my attempts last week that would only allow 1 person at a time to login.

However, I am receiving a couple of errors and neither myself nor my wife can actually enter the world as whatever zone is "unavailable."

Here are the errors in the exe windows:

[08.24. - 16:40:12] [WORLD__INIT] Loading items..
[08.24. - 16:40:12] [WORLD__INIT_ERR] Error: Could not load item data. But ignoring
[08.24. - 16:40:12] [WORLD__INIT_ERR] Unable to load eqtime.cfg
[08.24. - 16:41:11] [NET__IDENT_TRACE] 192.168.0.2:3314: First opcode 0x4dd0 did not match expected 0x2792
[08.24. - 16:41:11] [NET__IDENT_TRACE] 192.168.0.2:3314: Tried patch 6.2_world, and it did not match.
[08.24. - 16:41:11] [NET__IDENT_TRACE] 192.168.0.2:3314: First opcode 0x4dd0 did not match expected 0x2ec9
[08.24. - 16:41:11] [NET__IDENT_TRACE] 192.168.0.2:3314: Tried patch 6.2_zone, and it did not match.
[08.24. - 16:42:50] [WORLD__CLIENT] xxxxxxx: Attempting autobootup of rivervale (19:0)
[08.24. - 16:42:50] [WORLD__CLIENT_ERR] xxxxxxx: No zoneserver available to boot up.

Still searching the forums, but if you see this while I'm looking, what might be the issue in the failure to load zones?

EDIT: Went into the rebuild of Visual and identified a couple problems. I had added a couple things to the exp race and class bonuses:

if(GetBaseRace() == DARK_ELF || GetBaseRace() == HALFLING) {
if(GetClass() == ROGUE) || GetClass() == WARRIOR || GetClass() == CLERIC) {

Apparently they don't like what I thought was a logical structure. Working on fixing it now.

Emmeric

08-24-2011, 09:53 PM

Fixed all issues.

Now need to tweak.

Thank you everyone for your help. :)

keglo

09-02-2011, 05:54 AM

I do not get any SVN options when I right click my folder. No SVN Checkout, nothing. I have installed Tortoise a couple of times, restarted, and still nothing. Anyone have any ideas?

lerxst2112

09-02-2011, 11:40 AM

Make sure you're installing the 32 or 64 bit version to match your OS. You should see the Tortoise SVN Menu on any folder you right-click on. If not it's either installed incorrectly or there's something else wrong with your computer.

keglo

09-02-2011, 01:17 PM

Oh ok. I downloaded the 32 bit version although I'm running Windows 7 64 bit. I thought I read somewhere to use the 32 bit versions on everything. I'll try installing the 64 bit version. Thank you!!

werebat

09-02-2011, 01:40 PM

Oh ok. I downloaded the 32 bit version although I'm running Windows 7 64 bit. I thought I read somewhere to use the 32 bit versions on everything. I'll try installing the 64 bit version. Thank you!!

Tortoise 64bit works fine. I am using it on my XP 64bit. But MySQL 64bit gives me errors so I had to go to 32bit for that.

keglo

09-02-2011, 03:50 PM

Tortoise 64bit works fine. I am using it on my XP 64bit. But MySQL 64bit gives me errors so I had to go to 32bit for that.

Yes. Installing 64 bit did work for me. Thanks for the help. Now I'm having anew problem at step 9 when I do the "Build">"Build Solution" I get the following:

Build: 3 succeeded, 2 failed, 0 up-to-date, 0 skipped

I have tried it twice with the same results. Any ideas?

lerxst2112

09-02-2011, 04:11 PM

You would need to post the specific errors in order for us to do anything other than guess.

You probably missed adding one or more of the include/library directories to Visual Studio.

keglo

09-02-2011, 05:18 PM

Never mind this post

keglo

09-02-2011, 06:09 PM

You would need to post the specific errors in order for us to do anything other than guess.

You probably missed adding one or more of the include/library directories to Visual Studio.

How do I post the errors without posting the whole huge log file? Id id double check my include/library directories and they where correct. I re-installed Mysql to make sure I followed all the steps. I still get the 3 succeed 2 fail.

lerxst2112

09-02-2011, 08:14 PM

How many errors are there? The only way you will get help is to post them, otherwise we have no idea what they are. I would make a new thread for it.

keglo

09-02-2011, 08:40 PM

How many errors are there? The only way you will get help is to post them, otherwise we have no idea what they are. I would make a new thread for it.

Well the log file says I didn't have "errors"

0 error(s), 324 warning(s)

but I keep getting the following

3 succeeded, 2 failed, 0 skipped

I do not know how to post them or I already would have. I'm not sure what you want me to post. I tried pasting my entire log file in a new thread but it wouldn't let me. Sorry for being such a newb, but......

keglo

09-02-2011, 09:46 PM

Ok lerxst2112. I found a post from you a couple of pages back.

Find the two lines in the source code that look like this:

#pragma comment(lib, "perl510.lib")

Change the 510 to whatever version of perl you are using, like 512.

What are the errors you get with Strawberry perl? What version were you trying to use?

I tried that solution for myself and it worked like a charm! Thank you!!

keglo

09-02-2011, 10:30 PM

Now I have a new problem. I am on step 11 where I need to download the maps and quest. The problem is that all the folders already have a green check on them, therefore I can't choose "SVN Checkout". I seen this same problem asked about a few pages back, but didn't really see a clear answer to the problem. Someone mentioned downloading the .rar map files and extracting to the map folder, but that doesn't explain what to do about the quest folder.

lerxst2112

09-02-2011, 11:38 PM

If you're following the guide properly, the server folder should be separate from the source and database folders that are under SVN control.

Check again that you followed step 7 properly.

keglo

09-03-2011, 09:08 AM

If you're following the guide properly, the server folder should be separate from the source and database folders that are under SVN control.

Check again that you followed step 7 properly.

Yes I checked and followed the steps properly. The problem is that when I did step 8 and downloaded all the source files, it put a green check on nearly everything inside. Including the maps and quest folder in /source/trunk/EQEmuServer/utils/defaults. So when I do the following part in step 10

"Next, In /source/trunk/EQEmuServer/utils/defaults folder -

Copy ALL the folders and files inside this folder. EVERYTHING !!!! and put them in your
server folder also.YOU DON'T need the folder called .svn"

it carried over the green checks from the source folder into the server folder. So with the green checks already there it will not let me SVN Checkout.

sorvani

09-03-2011, 12:49 PM

You failed to NOT copy the .svn folders from your source to server folders when you copied your stuff over.
If you don't see them, change your folder setting to show hidden files and folders etc.

keglo

09-03-2011, 01:44 PM

You failed to NOT copy the .svn folders from your source to server folders when you copied your stuff over.
If you don't see them, change your folder setting to show hidden files and folders etc.

Ok the instructions are

Next, In /source/trunk/EQEmuServer/utils/defaults folder -

Copy ALL the folders and files inside this folder. EVERYTHING !!!! and put them in your
server folder also.YOU DON'T need the folder called .svn

It says "YOU DON"T need the folder (singular) called .svn." There is a .svn folder in /source/trunk/EQEmuServer/utils/defaults. I did not copy that file over. I assumed by the way the instructions are worded that it was that singular file that it was refering to. There are other .svn folders within each of the other files located in the /default folder. Are you telling me that I need to go through all of these folders and delete the .svn folder from each one before I copy the folders over?

UPDATE:
I tried doing just that, deleting all the .svn files from each folder before copying them over and it seems to be working. I am updating the quest folder per the instructions as I type this. Thanks for the help!

keglo

09-03-2011, 06:17 PM

Now at step 13

So NOW, you can download and source in the database (and updates needed)

13.First, go to your C-Drive and right click on the folder you made called peqdb
and choose "SVN Checkout"
In the "URL of repository" line copy and paste the following:
http://projecteqdb.googlecode.com/svn/trunk/peqdatabase (then click OK)
It will finish with "At Revision XX"

Next, go to that folder peqdb and unzip the file from peqdb_rev1751.sql.gz
to the same peqdb folder.
This file will be named peqdb_rev1751.sql (without the .gz)

I'm lost here. Where does this file, peqdb_rev175.sql.gz, come from? I haven't seen it mentioned elsewhere in the instructions so I assumed that it would be downloaded into the peqdb folder in step 13, but it isn't there. Where do I find it please?

blackdragonsdg

09-03-2011, 07:37 PM

The database revision has changed since any of the guides were written. Look for database_incremental.zip instead of peqdb_rev1751.sql.gz.

keglo

09-03-2011, 09:23 PM

The database revision has changed since any of the guides were written. Look for database_incremental.zip instead of peqdb_rev1751.sql.gz.

Thank you!! That worked. Now...

***WARNING*** - You may run in to errors on some of the updates, (I ignored some), but
there is one you can not ignore: 1711_account_restricted_aa.sql
YOU NEED THIS UPDATE for your server to create accounts without errors.
If you get an error when sourcing that in, you can do this to help it along:

Open the 1711 file with Notepad++ and remove the first line (there is 3)
After removing that line, run the update again.

I tried removing the first line but I still get a failure with 1711_account_restricted_aa.sql.

Any ideas?

blackdragonsdg

09-03-2011, 10:01 PM

That update should already be in your database. Just skip that part and keep going.

keglo

09-04-2011, 09:33 AM

[Debug] Starting Log: logs/eqemu_debug_4000.log
[Debug] [LAUNCHER__INIT] Loading server configuration..
[Debug] [NET__WORLD] WorldConnection connect: Connecting to the server localhost:9000 failed: TCPConnection::Connect<>: connect<> failed. Error: 10061
[Debug] [LAUNCHER__ERROR] worldserver.Connect<> FAILED! Will retry.
[Debug] [LAUNCHER__INIT] Starting main loop...

This is all I get after using my start.bat to begin my server

Apoc.Index

09-04-2011, 12:35 PM

Double check your eqemu_config.XML file in your eqemu folder. It looks as if its not connecting properly. You can follow this post if you dont know what parts to check/edit.

http://eqemulator.org/forums/showthread.php?t=32980

If that is in order, double check any port fowarding on your router (if you have one). The same post on the bottom will teach you about port forwarding.

Rhodan

09-18-2011, 10:48 AM

installing Mysql just about drove me up the wall. I made a mistake and uninstalled/reinstalled but it kept acting like there was already a password after a reinstall.

Well it took a while to find it but mysql (at least the 5.1 version) does not delete its databases when it uninstalls. On windows 7 the database is in a hidden directory called AppData and the Mysql dir in AppData has to be erased to remove the "old" password. Of course, if someone wants to keep a database and wants to only reset the password they'll have to hit google.

Baruuk

09-19-2011, 10:12 PM

Hi fellas - been away from the EMU for about a year and thought I'd give it another whirl. Thanks for this great guide. Overall it was pretty easy to follow and helped a bunch. One question however... Everything compiled and is configured fine it seems - i get no errors when launching WORLD.EXE, etc - it looks happy. I even see my new server listed in the public login server list. However, when I go to click on it (my client is an SoD build and eqhost.txt configured with port 5999), it never displays a character select screen. It simply hangs. Below is the error I'm getting in my world window. It looks like my login server account simply doesnt exist on the world server and it chokes - and since I'm not running a private login server, it dies. However, I'm not sure. How do accounts get created on the server? (BTW - IP and login account have been replaced below) Thanks in advance.

[Debug] [WORLD__CLIENT] New connection from x.x.x.x:57859
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x2792
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch 6.2_world, and it d
id not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x2ec9
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch 6.2_zone, and it di
d not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x4dd0
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch Titanium_world, and
it did not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x7213
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch Titanium_zone, and
it did not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x6c3c
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch SoF_world, and it d
id not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x737e
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch SoF_zone, and it di
d not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode matched 0xff4 and
length matched 464
[Debug] [NET__IDENTIFY] Identified stream x.x.x.x:57859 with signature So
D_world
[Debug] [WORLD__CLIENT] Checking inbound connection x.x.x.x against Banne
dIPs table
[Debug] [WORLD__CLIENT] Connection x.x.x.x PASSED banned IPs check. Processing connection.
Account Attempting to be created:myaccount 0
Error in CreateAccount query 'INSERT INTO account SET name='myaccount', status=0,
lsaccount_id=175494, time_creation=UNIX_TIMESTAMP();' #1054: Unknown column 'time_creation' in 'field list'
[Debug] [WORLD__CLIENTLIST_ERR] Error adding local account for LS login: 'myaccount', duplicate name?
[Debug] [WORLD__CLIENT_ERR] NOCLE: Bad/Expired session key '175494'

sorvani

09-19-2011, 11:16 PM

drop and resource your DB with the latest db_incremetnal or whatever it is called form the database SVN. Then source in every SQL file in the server SVN SQL sub folder > 1900 that does not have the word optional in it.

Baruuk

09-19-2011, 11:17 PM

Lazzeraith

10-02-2011, 03:16 AM

For Perl, go here - (I use 5.1 - 1007 version)
http://www.activestate.com/activeperl/downloads

Where can I get this version, that link is no good for it anymore, just have 5.12 and 5.14. I am trying, without any success, to setup a server. The guides are great but still leave people, in the dark without a clue as to how to do this, short. I tried using strawberry perl 5.10.1.5, but when I issue the ppm install DBI and ppm install IO-stringy commands, I get error installing package 'dbi': could not locate a PPD file for package dbi and same for IO-stringy. Any help would be great, I really miss playing this game.

Lazzeraith

10-02-2011, 04:52 AM

I am trying with Perl 5.12. Another problem popped up, when added the settings to Visual C++ 2008....

C:\mysql\include <------- I do not have the include folder
C:\perl\lib\CORE
C:\zlib\include

and

LIBRARY:
C:\mysql\lib\opt <------ I do not have this one either, under the mysql folder
C:\perl\lib\CORE
C:\zlib\lib

lerxst2112

10-02-2011, 06:04 AM

If you don't have the correct MySQL directories then you don't have it installed properly or you don't have the proper version of MySQL. I use 5.0, but I've heard 5.1 works fine as well. You want the 32-bit version with the installer.

http://downloads.mysql.com/archives.php?p=mysql-5.0&o=-win

If you use Perl 5.12 you will need to change these lines to "perl512.lib"

trunk\EQEmuServer\world\EQWParser.cpp(35):#pragma comment(lib, "perl510.lib")
trunk\EQEmuServer\zone\embperl.cpp(26):#pragma comment(lib, "perl510.lib")

Lazzeraith

10-04-2011, 02:28 PM

Thank you, that got that fixed. Now though I am having a problem with this:

In your server folder, right click on the quests folder and choose "SVN Checkout"
In the "URL of repository" line copy and paste the following:
http://projecteqquests.googlecode.com/svn/trunk/quests (Then click on OK)

When I right click on the folder the SVN Checkout option is not there anymore, it has SVN Update, SVN Commit..., and the TortoiseSVN options. I cannot seem to find a way to paste the addy.

Aeryn

10-04-2011, 02:49 PM

You already have a URL associated with that folder

To check or change it
go into the tortoise options and choose "Relocate"
that will show the url currently associated with the folder, change it there if it's wrong

Lazzeraith

10-04-2011, 04:15 PM

Did that and got a TortoiseSVN error box.

The repository at 'http://projecteqquests.googlecode.com/svn/trunk/quests' has uuid '858f6fc0-2484-11de-a087-198e6c7179d9', but the WC has 1db01234-8a6e-11dd-8937-b3a0fbe'

Lazzeraith

10-04-2011, 04:39 PM

Also when I opened the relocate option it had this URL http://projecteqemu.googlecode.com/svn/trunk/EQEmuServer/utils/defaults/quests, I replaced it with the one from the guide http://projecteqquests.googlecode.com/svn/trunk/quests and got the error from the above post. Is it possible to manually download these files and put them in the folder or is there a needed purpose for using SVN?

Lazzeraith

10-05-2011, 03:51 PM

Ok I cheated, made same named folders on different drive pasted links then copied them to server directory.

Lazzeraith

10-05-2011, 04:59 PM

You will find a lot of .sql files in there, but you only need the ones starting with the
number 1711 (and up)(this is based on using the 1751 database)

So first click on the 1711 file called 1711_account_restricted_aa.sql and click Open
Then click Start. It will source that sql in to your database.
***NOTE*** - You will have to do this step with each one, especially the ones that have
the word "required" in the name of the file.

Hello,

I am using rev_2022.sql, when I did the above set I get the following error.

[Err] 1060 - Duplicate column name 'account_time_required'
[Err] ALTER TABLE `altadv_vars` ADD `account_time_required` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `clientver`;
[Err] 1060 - Duplicate column name 'time_creation'
[Err] ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
[Msg] Finished - Unsuccessfully
-------------------------------------------------

Also in using rev_2022, this means I will have execute all the files higher than 1711 ?

joligario

10-05-2011, 07:26 PM

with 2022 all updates are already applied and current to 2022

Lazzeraith

10-06-2011, 03:59 AM

with 2022 all updates are already applied and current to 2022

So you do not have to do this step then?

Sorry kind of confused now, the guide says..

***WARNING*** - You may run in to errors on some of the updates, (I ignored some), but
there is one you can not ignore: 1711_account_restricted_aa.sql
YOU NEED THIS UPDATE for your server to create accounts without errors.
If you get an error when sourcing that in, you can do this to help it along:

Open the 1711 file with Notepad++ and remove the first line (there is 3)
After removing that line, run the update again.
I CAN NOT help you with all the errors from the updates, but just search the forums for
any others.

lerxst2112

10-06-2011, 04:53 AM

You should always apply any updates where the code is newer than your installed database version, but since they currently match there is no need to do so.

Lazzeraith

10-06-2011, 11:55 AM

You should always apply any updates where the code is newer than your installed database version, but since they currently match there is no need to do so.

Ok thank you.

Lazzeraith

10-06-2011, 12:44 PM

Ok I have these windows now, is this what I was suppose to be getting?

http://s1194.photobucket.com/albums/aa370/kenlconne/?action=view&current=eqemuser.jpg

Lazzeraith

10-06-2011, 12:53 PM

If my server is up and running , how do I connect to it?

Lazzeraith

10-06-2011, 02:19 PM

Think I will just try this at another time. Just too much to do and not enough info for me. Just wanted to actually create a LAN server, got forums mixed up. Read about the LAN setup and it is more confusing than this one.

Titansfinest

10-18-2011, 06:46 PM

It took me 4 days to get mine up and running, thank you so much for your guide =)

Titansfinest

10-18-2011, 06:50 PM

One more thing! I am very new to managing a server, any recommended reading?

Huppy

10-24-2011, 11:53 AM

Its been awhile since I was active around here, (school priorities), but even though my original guide posted here is a little outdated, most of it is the download links and rev. updates. I just downloaded all new fresh versions of both the compile source and peq, installing it on a windows vista box last night. (Oct 23rd, 2011) and I still had all the same apps I originally was using when I wrote this guide. (2008 C++ express, mysql 5.1, etc). I had absolutely no problems compiling the server and sourcing in the current database. Since it had been awhile that I played around with this, I had to refer back to this to refresh my memory on a few things, but I didn't have to do anything different than I used to. I also had no probs compiling all the newest updates on my debian linux box either, but THANK YOU to the devs for a lot of the updates you've done, especially the guild creation window. I love it!

dhgbrown

10-24-2011, 09:27 PM

At Step 9 I get 5 succeeded 0 failed 0 up-to-date 0 skipped. But when I select release and build I get ========== Build: 3 succeeded, 2 failed, 0 up-to-date, 0 skipped ==========

The Errors are :
MMF.cpp(325) : warning C4532: 'return' : jump out of __finally block has undefined behavior during termination handling
httpsocket.cpp(115) : warning C4715: 'HTTPSocket::ProcessReceivedData' : not all control paths return a value
EQWParser.cpp(105) : error C2106: '=' : left operand must be l-value
EQWParser.cpp(108) : error C2106: '=' : left operand must be l-value
embperl.cpp(150) : error C2106: '=' : left operand must be l-value
embperl.cpp(153) : error C2106: '=' : left operand must be l-value
warning C4200: nonstandard extension used : zero-sized array in struct/unionCannot generate copy-ctor or copy-assignment operator when UDT contains a zero-sized array
EmuTCPServer.cpp one above
EmuTCPConnection.cpp many like above
ZoneLaunch.cpp one like above
worldserver.cpp many like above
eqlaunch.cpp many like above
worldconn.cpp many like above
tinyxmlparser.cpp warning C4996: 'strncpy': This function or variable may be unsafe. Consider using strncpy_s instead. To disable deprecation, use _CRT_SECURE_NO_WARNINGS. See online help for details. C:\Program Files (x86)\Microsoft Visual Studio 9.0\VC\include\string.h(157) : see declaration of 'strncpy'
tinyxmlerror.cpp warning C4996: 'strncpy': This function or variable may be unsafe. Consider using strncpy_s instead. To disable deprecation, use _CRT_SECURE_NO_WARNINGS. See online help for details. C:\Program Files (x86)\Microsoft Visual Studio 9.0\VC\include\string.h(157) : see declaration of 'strncpy'
tinyxml.cpp many like above
tinystr.cpp one like above
timer.cpp \common\timer.cpp(68) : warning C4244: '=' : conversion from 'time_t' to 'long', possible loss of data
TCPConnection.cpp many of the following c:\source\trunk\eqemuserver\common\../common/eq_packet_structs.h(429) : warning C4200: nonstandard extension used : zero-sized array in struct/union
4> Cannot generate copy-ctor or copy-assignment operator when UDT contains a zero-sized array
packet_dump.cpp many of the above
Mutex.cpp ..\common\Mutex.cpp(128) : warning C4800: 'BOOL' : forcing value to bool 'true' or 'false' (performance warning)
LINK : warning LNK4098: defaultlib 'LIBCMT' conflicts with use of other libs; use /NODEFAULTLIB:library

worldconn.cpp bunch like below c:\source\trunk\eqemuserver\common\../common/EmuTCPConnection.h(23) : warning C4200: nonstandard extension used : zero-sized array in struct/union
5> Cannot generate copy-ctor or copy-assignment operator when UDT contains a zero-sized array

rulesys.cpp many like below
c:\source\trunk\eqemuserver\common\eq_packet_struc ts.h(429) : warning C4200: nonstandard extension used : zero-sized array in struct/union
5> Cannot generate copy-ctor or copy-assignment operator when UDT contains a zero-sized array
also
..\common\rulesys.cpp(177) : warning C4244: '=' : conversion from 'double' to 'float', possible loss of data
5>c:\source\trunk\eqemuserver\common\ruletypes.h(40) : warning C4305: '=' : truncation from 'double' to 'float'

dbcore.cpp ..\common\dbcore.cpp(199) : warning C4244: '=' : conversion from 'my_ulonglong' to 'int32', possible loss of data

Most are warnings but only get 3 of 5.
Possibly due to ActivePerl-5.14.2.1402 ?
navicat100_mysql_en
VS2008ExpressWithSP1ENUX1504728 ?

After changing in the source to match perl 514 I still get these errors:

2>.\EQWParser.cpp(105) : error C2106: '=' : left operand must be l-value
2>.\EQWParser.cpp(108) : error C2106: '=' : left operand must be l-value

3>.\embperl.cpp(150) : error C2106: '=' : left operand must be l-value
3>.\embperl.cpp(153) : error C2106: '=' : left operand must be l-value

Still only 3 of 5 build Zone and World fail to build.

Dave

lerxst2112

10-24-2011, 11:03 PM

Yes, use perl 5.12.

You'll also need to edit the source code to use the proper libraries. Find in files for perl510, and change both lines it lists to perl512.

These are the lines you should see after your search:

C:\EQEmu\ServerCode\trunk\EQEmuServer\world\EQWPar ser.cpp(35):#pragma comment(lib, "perl510.lib")
C:\EQEmu\ServerCode\trunk\EQEmuServer\zone\embperl .cpp(26):#pragma comment(lib, "perl510.lib")

dhgbrown

10-25-2011, 12:22 AM

Where can I get it? ActivePerl is at 514.

Dave

lerxst2112

10-25-2011, 01:10 AM

http://www.activestate.com/activeperl/downloads

Look down.

Noport

10-26-2011, 01:45 PM

I compiled the server files Note: Missing Registered patch House of Thule
From http://projecteqemu.googlecode.com/svn/
Downloaded Oct-2011

[WORLD__INIT] CURRENT_WORLD_VERSION:EQEmulator 0.8.0
[NET__IDENTIFY] Registered patch 6.2
[NET__IDENTIFY] Registered patch Titanium
[NET__IDENTIFY] Registered patch SoF
[NET__IDENTIFY] Registered patch SoD
[NET__IDENTIFY] Registered patch Underfoot

Added #include "HoT.h"
Added HoT::Register(into);
Added HoT::Reload();

Edit Patches.cpp Example: Z:\ServerFiles\trunk\EQEmuServer\common\patches

#include "../debug.h"
#include "patches.h"
#include "Client62.h"
#include "Titanium.h"
#include "Anniversary.h"
#include "Underfoot.h"
#include "SoF.h"
#include "SoD.h"
#include "HoT.h"

void RegisterAllPatches(EQStreamIdentifier &into) {
Client62::Register(into);
Titanium::Register(into);
SoF::Register(into);
SoD::Register(into);
Underfoot::Register(into);
HoT::Register(into);
}

void ReloadAllPatches() {
Client62::Reload();
Titanium::Reload();
SoF::Reload();
SoD::Reload();
Underfoot::Reload();
HoT::Reload();
}

I have no idea why it was remarked in the file patches.cpp so i added it back.
I'll be running some test on standalone server.

Derision

10-26-2011, 02:33 PM

The HoT patch is commented out because it is not in a playable state. The HoT patch has a minimal set of working Opcodes/structs to get in game with the live client (well the live client as it was the last time I updated it a couple of months ago).

Note that the House Of Thule client from Steam is really what we would class as Underfoot, the only difference from the Underfoot Steam download is the CD key gives you access to the HoT expansion, if you should choose to open an account with SOE and patch up to EQLive.

dhgbrown

10-26-2011, 11:46 PM

Thanks. Got it going server-wise except I am getting [Debug] [World__LS_ERR] Unable to resolve 'PEQ' to an IP.

I plan to delete my folders and start over to try to repeat the process and maybe fix the IP issue.

Dave

wolfwalkereci

10-27-2011, 10:09 AM

Its been awhile since I played with this but I put mine back up today on a new machine. Started fresh and it took roughly 2hours because I was being dumb.
The guide is still pretty much spot on.

I used a copy of the following that I had saved:
ActivePerl-5.10.1.1007-MSWin32-x86
Mysql-5.0.82-win32
zlib123-dll
Visual C++ 2008 Express Edition with SP1

dhgbrown

10-27-2011, 01:26 PM

[Debug] Starting Log: logs/eqemu_debug_3012.log
[Debug] [LAUNCHER__INIT] Loading server configuration..
[Debug] [NET__WORLD] WorldConnection connect: Connecting to the server localhost
:9000 failed: TCPConnection::Connect(): connect() failed. Error: 10061
[Debug] [LAUNCHER__ERROR] worldserver.Connect() FAILED! Will retry.
[Debug] [LAUNCHER__INIT] Starting main loop...

This is getting frustrating.

Dave

lerxst2112

10-27-2011, 07:18 PM

It's normal to see that when you start everything as things get in sync. If you're still having trouble after it has been running a few minutes then you need to post those errors.

dhgbrown

10-28-2011, 12:28 PM

I am getting this error message on the client:

Sorry %3, you already have the maximum number of active tasks.

What did I miss now?

Dave

dhgbrown

10-28-2011, 01:42 PM

Ok after reading and searching the forums this tutorial is to establish a server online with a login server remotely.

I need to setup this server so that it is Lan only because it will soon not have internet access indefinately. So with that said. After checking on the server the world.exe was failing due to not finding end statement. Fixed that.

Then Started batch file again and I get Handle_NewLSInfo error, remote address was null, defaulting to stream address ... Login server crashes.

What can I do to get a Lan only server running? Do I need two boxes on with login server and another with database server?

Dave

nikkisman69

12-02-2011, 09:07 PM

I just put all of the files listed at the beginning in a rar file and uploaded them for easier downloads.
http://www.megaupload.com/?d=JRN4CP6Y

Includes:
WinRAR
Zlib
ActivePerl 5.10.1.1007 32-bit
MySQL 5.1.54 32-bit
MS Visual C++ 2008 Express Edition
Navicat
TortoiseSVN
Notepad++

pepsiphreak79

12-04-2011, 11:38 PM

Can someone please write a walkthrough that a normal human can understand None of this is working its all just messing everything up

pepsiphreak79

12-04-2011, 11:54 PM

I have my sql pearl and apache up as portable but i dont know how to get the DB into it every time i try i get some error another and it never goes in correctly i dont understand what it means to sorce something or how to do it i cant even find matching maps to matching db files its all so scattered around that its to complex to just find the right things you need
Im just trying to get a server up for offline use for a new SOF un patched install that works on all the content. I figured out how to write uests and add content but the repack i used is so outdated and gimped i cant get sof to work on it
This is all so very frustrating that the people making the emu expect all of us to be devs and programmers and we arent :( More people might do eqemu if it was simplified alot more ...
Just so frustrated sorry for the rant but ive been trying to make mine work for 2 weeks and every time i get close it all gets screwed up and i have to start over i have so much crap downloaded none of it is ever versioned corectly its hard to tell what goes with what . im just going to have to delete everything and start all over

joligario

12-05-2011, 07:57 AM

You don't have to set up a server just to play. There also isn't a need for new servers. So if it is too complicated for the given step-by-step instructions, just join an existing server.

wolfwalkereci

12-05-2011, 09:47 AM

If you really really must have your own local server I can assist you with compiled binaries but its up to you to get everything else working.
I have copy/pasted the guide from here to my forums and made it prettier and easier to follow (my opinion) however its almost exactly word for word what is posted here.
The only thing I do is provide downloads of the required files and compiled binaries starting with I believe 2027.
PM me if you want to go that route.

pepsiphreak79

12-05-2011, 11:05 PM

Yes i must ave my own due to internet issues when i move iwill be out in never never land where net is non existant

Ok because i cant find a compatible set of portable servers i took the ones out of another repack "ax to be specific"

i gutted it.

i cleared the peq and ax DB out clean

i deleted the ax dir from it
i overwrote the files in the peq dir with the ones from

http://code.google.com/p/projecteqemu/downloads/list

EQEmu-Rev2068-Bots.zip Rev 2068 with Bots
EQEmuLoginServer.rar EQEmuLoginServer compiled from Rev1765 Source

so they went to ...
c:\eqemu\peq\World.exe
c:\eqemu\peq\EQEmuLoginServer.exe
ect....

I corrected the logins

I went into the DB and removed peq and ax database and created a blank peq DB using utf8 generic

I then imported peqdb_rev2027.sql to the peq database with no errors

i placed maps from http://eqemu-maps.googlecode.com/svn/trunk/
and Pathfiles_01.zip from http://code.google.com/p/projecteqemu/downloads/list
into c:\eqemu\peq\maps\*.*

I updated quests from http://projecteqquests.googlecode.com/svn/trunk/quests/
into c:\eqemu\peq\quests\*\

[Debug] [NET__WORLD] Connected to World: 127.0.0.1:9000
[Debug] [WORLD__LAUNCH] Unknown launcher 'zones' connected. Disconnecting.
[Debug] [WORLD__LAUNCH] Removing pending launcher 3. Adding zones to active list
.
[Debug] [WORLD__LAUNCH] Removing launcher zones (3)
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1146: Table 'peq.variables'
doesn't exist'
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:3400
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:3400
[Debug] [WORLD__LAUNCH] Adding pending launcher 4

So i copied the variables table from the login db

[Debug] [WORLD__INIT] Clearing groups..
Unable to clear group leaders: #1146: Table 'peq.group_leaders' doesn't exist
Unable to clear groups: #1146: Table 'peq.group_id' doesn't exist
[Debug] [WORLD__INIT] Clearing raids..
Unable to clear raids: #1146: Table 'peq.raid_members' doesn't exist
Unable to clear raid details: #1146: Table 'peq.raid_details' doesn't exist
[Debug] [WORLD__INIT] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=90209

[Debug] [WORLD__INIT] [Debug] Starting Log: logs/eqemu_debug_4296.log
Loading guilds..[Debug] [LAUNCHER__INIT] Loading server configuration..

[Debug] [GUILDS__ERROR] Error loading guilds 'SELECT id, name, leader, minstatus
, motd, motd_setter,channel,url FROM guilds': #1146: Table 'peq.guilds' doesn't
exist
[Error] Starting Log: logs/eqemu_error_world_3004.log
[Error] Error in LoadRules query SELECT ruleset_id FROM rule_sets WHERE name='de
fault': #1146: Table 'peq.rule_sets' doesn't exist
[Debug] [WORLD__INIT] No rule set configured, using default rules
[Debug] [WORLD__INIT] Clearing temporary merchant lists..
Error in ClearMerchantTemp query 'delete from merchantlist_temp' #1146: Table 'p
eq.merchantlist_temp' doesn't exist
[Debug] [WORLD__INIT] Loading EQ time of day..
[Debug] [WORLD__INIT] Loading launcher list..
[Error] WorldDatabase::GetLauncherList: #1146: Table 'peq.launcher' doesn't exis
t

t.
[Debug] [WORLD__LAUNCH] Removing launcher zones (10)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:3437
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:3437
[Debug] [WORLD__LAUNCH] Adding pending launcher 11
[Error] Error in AdventureManager:::GetLeaderboardInfo: select ch.name, ch.id, a
dv_stats.* from adventure_stats AS adv_stats left join character_ AS ch on adv_s
tats.player_id = ch.id; (#1146: Table 'peq.adventure_stats' doesn't exist)
[Debug] [NET__WORLD] Connected to World: 127.0.0.1:9000
[Debug] [WORLD__LAUNCH] Unknown launcher 'zones' connected. Disconnecting.
[Debug] [WORLD__LAUNCH] Removing pending launcher 11. Adding zones to active lis
t.
[Debug] [WORLD__LAUNCH] Removing launcher zones (11)

This is where im stuck this time

I am lost and nhave no idea what its doing I am pretty sure the peqdb_rev2027.sql was incomplete somehow and that im missing a chunk of stuff from my DB but i dont know where to get a full and ungimped DB i guess

lerxst2112

12-05-2011, 11:18 PM

It sounds like you did not source your database correctly. Steps 14 and 15 in the guide.

joligario

12-05-2011, 11:19 PM

You're already out of date. CD uploaded a new database (2083). Get that one. Drop everything, source players and source system.

lerxst2112

12-05-2011, 11:31 PM

You're already out of date. CD uploaded a new database (2083). Get that one. Drop everything, source players and source system.

That is generally good advice, but when using precompiled binaries a newer database may not work with the older server code. If you really can't compile your own server I'd stick with a slightly lower database rev and apply the updates to make it match your binary version.

pepsiphreak79

12-06-2011, 12:57 AM

It sounds like you did not source your database correctly. Steps 14 and 15 in the guide.

No crap that makes no since to me i dont know how do do it and when i try the walk through it messes up

pepsiphreak79

12-06-2011, 12:59 AM

You're already out of date. CD uploaded a new database (2083). Get that one. Drop everything, source players and source system.

and that does no good if you dont include where to get it if you couldnt tell stuff scattered all over

And again im not a programmer or hacker i dont know what half the crap they say to do is..

The whole sorcing thing makes no sence

pepsiphreak79

12-06-2011, 01:50 AM

And the things sorcing sais to do i cant do it that way im not setup like thoes people im instead using heidisql and choosing import sql

I am gonna try this uniserv with the perl 5.10 addon its a portable that way i can bag it up and move it around if needed
http://www.uniformserver.com/
i got perl from a google search on ActivePerl-5.10.1.1008-MSWin32-x86-294165.msi
and it installed into the uniserv

and i set SET PATH=C:\eqemu\UniServer\usr\local\mysql\bin;C:\eqe mu\UniServer\usr\bin;C:\eqemu\Core;%PATH%

into the cores bat file for start to find the required dll files on load right now its just re importing to the new blank database

ps ActivePerl-5.10.1.1008-MSWin32-x86-294165.msi is no longer obtainable through legal means free..... now you must be a paying cust on there site for it..

no clue why but you have to be a business or enterprise subscriber to obtain there older support for now its at 5.14 as the free release

And yes if i can get this up with SOF playable "races and zones and all possible Eq like quests" I will zip it up and put it around media sharings and torrent for all to use as an ungimped un customized Eqemu server easy to use with maps and all in it.. for non dev literate people like me..
If someone has an up to date DB and pre compiled un customized bots supported recient core that would help alot also i tried compiling and it gave me fatal errors and missing files and such and i followed the walkthroughs

Afterall isnt all this sopposed to be open sorce and a community project to keep improving it together as a group?

Plus think of all the quest writers that will come back to the project if it stays simple to use and upgrade. I do love how quests are kept to .pl and db and not hard coded like the wow ones

lerxst2112

12-06-2011, 03:24 AM

All I can say is those instructions are fairly simple and easy to follow. You can use the mysql command line tool just like everyone else, you are just choosing not to, and what you're doing isn't working.

I would advise instead of just saying you can't do it, take a deep breath, and follow the simple steps in order without trying to take any shortcuts along the way. You will end up with a working server if you do that.

pepsiphreak79

12-06-2011, 03:46 AM

ok again im not using a mysql installed to windows or the rest its all a portable i dont have the peqdb dir for exabmple so i dont have a clue how to do that sorce command shouldnt importing the SQL through heidi sql to the peq DB work the same way
Theres more than one way to skin a vashir

So unless you actually understand it yourself your not really able to help others.
helping others by saying stick to the tutorial really helps nobody it just aggravates them

i want this so that once its up and running i can have a complete server backup that can be just unziped and ran when im done i also run a wow server and so i want the databases ect... all seperate currently the wow server is on another pc up and running with no issues i did have a repack up for eq but again it was gimped and cudtomized and trying to upgrade it was useless so i am trying to start a fresh one
The instructions are simple to follow IF you know what all this stuff means and does and IF you want to setup a server how they have

lerxst2112

12-06-2011, 04:24 AM

My server works perfectly since I followed a guide very similar to this one. I didn't know how MySQL worked or what sourcing files was when I started, but by reading and following the instructions I worked it out.

Lashing out at everyone that has tried to help you really isn't going to make them or anyone else want to try and help you. You might consider being polite and rational about it since you're the one that needs help, not me.

Yes, this guide is not the only way to setup a server, but this way has worked for many people and it could work for you too. Perhaps if you follow this guide to setup a non-portable server you will be able to take that experience and be able to figure out how to make the portable server you want.

Good luck.

pepsiphreak79

12-06-2011, 05:18 AM

Again not helpfull at all

So i was able to find the peq datadir ill attempt this sorcing thing If anyone else has issues because there not setup the same your dirs for the sql may be located in \mysql\data\peq
and not in the c:\peqdb dir as some may have it no offense to the writer of the first page walkthrough its great you did that

mine happens to be
C:\eqemu\UniServer\usr\local\mysql\data\peq

Now i am starting with a naked Database
i have the standard structure of
DB information_schema - Standard mysql initial stuff unsure if anything needs altering
DB login - utf8 - bin Completly naked i assume i needed it so i created it
DB mysql - filled with the standard stuff for all my sql
DB peq - utf8 - bin format and completly empty (completly empty mind u)
DB performance_schema - again standard sql stuff
DB phpmyadmin - Standard stuff again and not relivant to eqemu

i went to the peq dir i did sorce it started importing and a bunch of errors like

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`ground_spawns`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.ground_spawns' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

in that order and alot more than that but it wont save that far up in the cmd window

i checked back and they really were missing after the import so what thats telling me is the .SQL file is telling mysql to create if not there before its telling mysql to delete it

so this whole time its not my importing through heidisql its the SQL itsself that is not working correctly

Its creating the table thats missing then deleting it then its unable to run the insert commands because the table is missing...

i appear to have a bad SQL db as i assumed... is there a 2068 DB around anywhere that is uncustomized? since the 2027 db im using is not allowing a full source

I did not run any updates because the initial sourcing failed and alot of stuff is not included anyway

what i came out with is a peqdb that was missing some tables
and not sure how to pupulate the login db so i will just copy another one into that one

i found the 2083 i will clear and try that one instead
http://code.google.com/p/projecteqdb/downloads/list
is where the 2083 db is

pepsiphreak79

12-06-2011, 05:46 AM

same thing with rev 2083 db

ERROR 1146 (42S02): Table 'peq.faction_list' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`fear_hints`' already exists
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`fishing`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.fishing' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`forage`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.forage' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 501 rows affected (0.01 sec)
Records: 501 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`graveyard`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.graveyard' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`grid`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.grid' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`grid_entries`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist

Query OK, 48964 rows affected (0.31 sec)
Records: 48964 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`spawn2`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`spawn_conditions`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.spawn_conditions' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`spawn_condition_values`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.spawn_condition_values' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`spawn_events`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.spawn_events' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`spawnentry`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.spawnentry' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawnentry' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawnentry' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`spawngroup`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.spawngroup' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawngroup' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawngroup' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawngroup' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.06 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.14 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 1599 rows affected (0.22 sec)
Records: 1599 Duplicates: 0 Warnings: 0

Query OK, 1595 rows affected (0.22 sec)
Records: 1595 Duplicates: 0 Warnings: 0

Query OK, 1604 rows affected (0.22 sec)
Records: 1604 Duplicates: 0 Warnings: 0

Query OK, 1621 rows affected (0.20 sec)
Records: 1621 Duplicates: 0 Warnings: 0

Query OK, 1605 rows affected (0.22 sec)
Records: 1605 Duplicates: 0 Warnings: 0

Query OK, 1590 rows affected (0.20 sec)
Records: 1590 Duplicates: 0 Warnings: 0

Query OK, 1536 rows affected (0.20 sec)
Records: 1536 Duplicates: 0 Warnings: 0

Query OK, 1575 rows affected (0.20 sec)
Records: 1575 Duplicates: 0 Warnings: 0

Query OK, 1610 rows affected (0.20 sec)
Records: 1610 Duplicates: 0 Warnings: 0

Query OK, 1696 rows affected (0.20 sec)
Records: 1696 Duplicates: 0 Warnings: 0

Query OK, 1576 rows affected (0.22 sec)
Records: 1576 Duplicates: 0 Warnings: 0

Query OK, 1552 rows affected (0.20 sec)
Records: 1552 Duplicates: 0 Warnings: 0

Query OK, 1598 rows affected (0.20 sec)
Records: 1598 Duplicates: 0 Warnings: 0

Query OK, 1620 rows affected (0.20 sec)
Records: 1620 Duplicates: 0 Warnings: 0

Query OK, 1574 rows affected (0.20 sec)
Records: 1574 Duplicates: 0 Warnings: 0

Query OK, 1602 rows affected (0.20 sec)
Records: 1602 Duplicates: 0 Warnings: 0

Query OK, 1529 rows affected (0.20 sec)
Records: 1529 Duplicates: 0 Warnings: 0

Query OK, 1193 rows affected (0.16 sec)
Records: 1193 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`start_zones`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.start_zones' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`starting_items`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.starting_items' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.06 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 113 rows affected (0.00 sec)
Records: 113 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.08 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 14 rows affected (0.00 sec)
Records: 14 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.14 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 172 rows affected (0.00 sec)
Records: 172 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`tradeskill_recipe`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.tradeskill_recipe' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.19 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 38390 rows affected (0.33 sec)
Records: 38390 Duplicates: 0 Warnings: 0

Query OK, 37874 rows affected (0.55 sec)
Records: 37874 Duplicates: 0 Warnings: 0

Query OK, 27620 rows affected (0.38 sec)
Records: 27620 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`traps`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.traps' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`tribute_levels`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.tribute_levels' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`tributes`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.tributes' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.06 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`zone`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.zone' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`zone_points`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.zone_points' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`zone_server`' already exists
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`zone_state_dump`' already exists
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`zoneserver_auth`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.zoneserver_auth' doesn't exist
mysql>

same kind of errors and missing tables at completion
its checking for them and creating them then deleting them then trying to populate

or is it " eq`.`fo "vs " eq.fo " i see that its having errors with ones like that

trevius

12-06-2011, 05:52 AM

As has already been said, your attitude is not likely to get you much assistance with your issues. The community is often likely to help people when they can, but no one is getting paid to do so, so being rude is more likely to result in no responses. You have started off rude in this thread and every post since then has followed that same overall feeling.

Regardless of what you may think, lerxst2112 is one of the more active, more knowledgeable and more helpful people in the EQEmu community right now. You are working against yourself to be rude to him like that. I won't tolerate disrespect to top notch community members, so please stop it.

First of all, from all of your posts, it looks like you are not following the guide exactly. You are trying to take short cuts or use other tools/procedures you have used for setting up your WoW emu server. If you knew exactly what you were doing and if you were able to get your server setup by doing things differently than the guide says, then that would be good. Unfortunately, that isn't working out so well for you. My suggestion would be to follow the guide exactly. If you can get the server working by following the guide exactly, then you can start doing your other stuff.

Yes, the EQEmu guides could probably be made better. Part of the problem is that there are many different Operating Systems that can run EQEmu and setting it up on each one can be slightly different. So, it does require a bit of knowledge here and there and is not for everyone out there. Though, there have been hundreds of servers created over the years using similar guides, so it isn't as hard as you make it out to be.

If you are having this much trouble just getting the server running, you are really probably going to have a hard time getting your Login Server or MiniLogin working. Both of those can be kinda tough to get working initially without a little bit of knowledge on what you need to do. The guides help, but many people have issues with it. Getting a public server running that uses the public EQEmu Login Server is much easier and most people do it that way for that reason.

Your posts on the issue seem to be all over the place. You mentioned AX classic repack, and that isn't supported here. You might try their website to see if there is better info there for it. From what I have heard of it, that is about as easy as it gets.

Your problems could be any number of things, and you may not even have the right versions of perl or mysql installed, which is only going to add to your issues.

Good luck with getting it all running. If the negative attitude keeps up, you will be temp banned to let you hopefully cool off.

pepsiphreak79

12-06-2011, 06:18 AM

im not trying to be rude just frustrating that some of the peopel really arent trying to help there just being negative saying your doing it wrong or refer to the walk through but they are not acually helping i did thank the one that acually offered some help ... and they act like we have all been here for ages ans should already know all this...
its kinda condasending and thats why i was negative

trevius

12-06-2011, 07:14 AM

In a previous post in this thread, you said you were able to source all of the PEQ SQL without errors, but now you are getting errors when you try?

Are you following these 3 step exactly (accounting for the path difference where your PEQ files are located)?

13.First, go to your C-Drive and right click on the folder you made called peqdb
and choose "SVN Checkout"
In the "URL of repository" line copy and paste the following:
http://projecteqdb.googlecode.com/svn/trunk/peqdatabase (then click OK)
It will finish with "At Revision XX"

Next, go to that folder peqdb and unzip the file from peqdb_rev1751.sql.gz
to the same peqdb folder.
This file will be named peqdb_rev1751.sql (without the .gz)

***NOTE***
The "rev1751" was the most current at the time of this writing. It may change over time.

14. Ok, now open up your Navicat Lite program that you installed.
On the upper left you will see Connection. Click on that and choose MySQL
A connection window will open. The only thing you really need to do is put your mysql
password in (make sure the "Save Password" is checked) and click OK.
This will create a connection with MySQL.
In the Connections window, you should now see localhost_3306 (Double click on that)
Then right click on that same name (localhost_3306) and choose New Database...
In the next window, in the first line, type peq (then click OK)
Close Navicat Lite.

15. NOW, you need to go in to a command prompt and navigate to the peqdb folder.
Simply type cd \peqdb and you should be there. You will see: C:\peqdb>_

REMEMBER THE PASSWORD YOU GAVE when you set up MySQL ? (You need it NOW)

***WARNING*** - at this point, make sure you are in the peqdb folder.

Type mysql -uroot -p
Hit enter and enter your password. (Hit enter again)
You should now see a prompt that looks like this: (along with "Welcome" text before it)
mysql>_

Type the following (in order):

use peq (Hit enter and you will see a short note saying "Database changed")

Then type the following:

source peqdb_rev1751.sql (when this is done, you will be back at the mysql>_ prompt)

Then type in the following:

source load_player.sql (this will load fast)

***WARNING*** - When you compiled your server, if you chose "ReleaseBots", you will now
need to type the following at the mysql prompt:

source load_bots.sql

Which ever you chose, you can now close the command window and work on the sql updates.

***WARNING*** - the sql updates ARE NOT in the peqdb folder, they are in the source
folder where you compiled your server, but you can use Navicat Lite to run the updates.

If you follow those 3 steps, your DB should be all set and you can move on to troubleshooting your next issue(s). If you are unable to understand exactly what to do at any part of those 3 steps, just ask specifically about the part you are unsure about.

If you don't know how to open a command prompt, you can do all of this fairly easily through Navicat and probably HeidiSQL as well. I don't use HeidiSQL, so I can't speak for how to do it there, but Navicat is similar I am sure and very simple. You just create a new database named "peq" (without the quotes). Then you double click that database to connect to it and right click on it. In that menu, you should see an option to Source the SQL (may not be worded exactly like that, but I am not at my desktop to verify right now). You then browse to the folder where your PEQ SQL files are located and run them in the order that the guide says to.

lerxst2112

12-06-2011, 07:36 AM

Looks like Trevius beat me to the punch, but maybe this will help anyway.

You can do everything you need to from the command prompt and not have to worry about using a different tool to create the database. I remember when I originally tried to use SQLyog to source load_player.sql it failed because it doesn't set the current directory to where the file you're importing is so it couldn't find the player_tables directory.

I also show deleting the existing database just to be sure you are starting from scratch. It sounds like, from the issues you posted, that you may have had something leftover there causing a conflict.

Substitute whatever directory you have the peq files in for the first command. The blue text is what I typed. I didn't include all of the spam the source commands generate because it wouldn't be helpful. If you want to save all of the output to a file you can type tee output.txt as the first command at the mysql> prompt. The file will be saved in the directory you started MySQL from.

If you are not using bots then skip the source load_bots.sql command.

C:\>cd EQEmu\Database\peqdatabase

C:\EQEmu\Database\peqdatabase>dir
Volume in drive C has no label.
Volume Serial Number is 4A57-06FC

Directory of C:\EQEmu\Database\peqdatabase

12/06/2011 03:11 AM <DIR> .
12/06/2011 03:11 AM <DIR> ..
10/04/2010 10:20 PM 564 drop_bots.sql
12/05/2011 07:55 PM 2,566 drop_player.sql
12/05/2011 07:55 PM 2,752 drop_system.sql
10/04/2010 10:20 PM 276 load_bots.sql
12/05/2011 07:55 PM 2,659 load_player.sql
12/05/2011 02:02 AM 169,453,496 peqdb_rev2083.sql
12/05/2011 07:55 PM 22,451,506 peqdb_rev2083.sql.gz
12/05/2011 07:55 PM <DIR> player_tables
10/04/2010 10:20 PM 1,586 readme.txt
12/05/2011 07:55 PM <DIR> updates
8 File(s) 191,915,405 bytes
4 Dir(s) 495,992,610,816 bytes free

C:\EQEmu\Database\peqdatabase>mysql -uroot -p
Enter password: *****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.0.91-community-nt MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> drop database peq;
Query OK, 151 rows affected (2.15 sec)

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

mysql> use peq
Database changed

mysql> source peqdb_rev2083.sql
mysql> source load_player.sql
mysql> source load_bots.sql
mysql> quit

pepsiphreak79

12-06-2011, 07:46 AM

yes i was using an ax repack and its still in another dir and working if i shut mine off and turn it on but its not working how i want a server to if that explains anything...

My first attempt was so use there portable mysql ect... since it was all ready to go with eqemu but each attempt failed

I have switched to a but naked uniserv
Apache 2.2.21
MySQL 5.5.18-community
PHP 5.3.8
perl 5.10

15. NOW, you need to go in to a command prompt and navigate to the peqdb folder.
Simply type cd \peqdb and you should be there. You will see: C:\peqdb>_

I believe this part was what had me from my understanding of what was written in tutorial was that this was to be the db stored files and so to copy your newly downloaded sql to it but since my portable doesnt work like others stuff it was my issue
i was copying the sql to the peq dir from the mysql and it looks like that was what botched it.... and yes up above i said thats what i did so instead i just resourced and i stoped getting the frustrating errors i still have no clue why it errord with the sql file in the db dir but oh well thats beyond my understanding. i got past it. just now

so im going to try the rest off the installs

is it ok to populate my naked login database using the login DB from a repack??

pepsiphreak79

12-06-2011, 07:52 AM

and i just saw your posts lol thank you :)

pepsiphreak79

12-06-2011, 07:57 AM

trevius

12-06-2011, 08:07 AM

This is unclear especially since the rev is now 2027 on the db does this mean i need to install update from the 1667 till 2068 line still or is the 2068 db updated? i am afraid to screw it up again so im just going to ask for clarification first.

The reason your doing this, is because, even after a new database revision is out, all
the updates developed after that, need to be sourced in. In this case, when the rev1751
was sent out, (after the 1667), not all updates were applied to the release.
I know it leaves more work for us "end users", but what the heck, it's free

That depends on what binaries you are using. It sounds like you are running Rev2068 binaries and Rev2027 of the PEQ DB. If that is true, you just need to source in any updates between 2027 and 2068 seen here:

http://code.google.com/p/projecteqemu/source/browse/#svn%2Ftrunk%2FEQEmuServer%2Futils%2Fsql%2Fsvn

In your case, that should be the following files:

2057_required_discovered_items.sql
2058_optional_rule_discovered_items.sql
2062_required_version_changes.sql

And then your DB and Binaries should be matching and set to go.

is it ok to populate my naked login database using the login DB from a repack??

I would not recommend mixing and matching with the Repack and normal install.

You should be able to just follow steps 9, 10, 11, 12, and 13 from the guide here:
http://www.eqemulator.net/wiki/wikka.php?wakka=ValesEQ

pepsiphreak79

12-06-2011, 08:37 AM

ok ty i was just curious cause of how it was worded it was confusing i ziped up my server incase i screw it up again cause as far as i know so far its going ok this time its hard to focus on all the walkthroughs so many diff ones keeping track of it can be difficult..
All this to play a game i loved for years since it came out till pop lol and since im moving out to where theres no real internet i wanted to get a hold of a working recient stable server that supported the latest client i had in my possession lol

pepsiphreak79

12-06-2011, 09:40 AM

Wow ok that helped straighten things out now im almost up just some config isses i have to find where i messed up the settings that keep it from connecting
Thank you for pointing me in the right places there is just so much its very hard to track down what you specifically need

pepsiphreak79

12-06-2011, 10:52 AM

up and created a drakkin and eq client crashed on login dont know what caused it yet but up to the char creation everything ran like a live server even the descriptions were there.
reinstalling sof fresh i know following some guides it said to alter some of my sof files and somthing tells me i shouldnt have

OK so my tip for server setups do not have your rev*.sql in the same dir as your database when you source them cause it really goes crazy

i only realized that was my issue when it wouldnt let me remove the peq db and recreate

And mmm what else heidi wont always tell you if you have a bug.. :( and i like my heidi so sweet and gentil

trevius

12-06-2011, 11:22 AM

If your zone is crashing when you log in, it is normally due to missing a required SQL update. You can normally check your logs and see if they have any useful information. If not, you can run a debug, but that might be a bit too complicated for you as it requires compiling your own source.

pepsiphreak79

12-06-2011, 12:34 PM

Server up and working after a bunch of minor config file changes

thank you for helping clarify the information in here to get this up

I would be happy to upload this preconfigured server for dummies as soon as i make sure its fully working it wont have anything custom or altered from the peq 2068
I know things are missing from it and itll never be perfect but the way eqemu is setup i can add content easily when not having internet

as for the booting thing it looked like it is the tutorial b thing but when i come back in i start in tutb anyway so im not gonna disable it

i may instead try and write the story for tutorial a zone 188 as is was on live last i recall and then alter the tutb to tut a starting and see if that resolves the whole char creation into tutorial issue

Tested server on Titanium and SOf both working on port 5999
no changing anything needed
multiple char creations and a little travel tested

pepsiphreak79

12-07-2011, 03:41 AM

Its up everything works pretty good Unaltered from what the peq 2068 db and core files
worked on tit and sof ;)

runs right out of an unzip once your maps are placed in

http://www.eqemulator.org/forums/showthread.php?t=34574

Secrets

12-07-2011, 04:38 AM

Its up everything works pretty good Unaltered from what the peq 2068 db and core files
worked on tit and sof ;)

If anyone wants it heres the torrent mag link:

magnet:?xt=urn:btih:021F89236BF6412818998701FF9364 5C02617864&dn=eqemu-rev2068-wbots-wcore-wdb-wquests_unmodified_repack_nomaps.zip&tr=udp%3a//tracker.openbittorrent.com%3a80

Media fire link
http://www.mediafire.com/file/ka04ae5m5yu07av/eqemu-rev2068-wbots-wcore-wdb-wquests_unmodified_repack_nomaps.zip

One post is enough. I advise people to compile from source themselves unless you want a potential trojan. The only official repack is the one on google code.

rullare

12-10-2011, 05:34 PM

hi^^

i just wondering way can't u write that we can have skype open when we are starting the server?????????

i get stack for i diden't know that^^ but i try to closed it and it's work^^ plz implument it its very importent.

wolfwalkereci

12-10-2011, 08:04 PM

https://support.skype.com/en-us/faq/FA148/Which-ports-need-to-be-open-to-use-Skype
Never had this issue myself and the above link doesnt show ports that would conflict but double check your settings.