COMPLETE PUBLIC SERVER SETUP - Jan-2011

[drumbler100]

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]

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]

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/s...utils/sql/svn/

[joligario]

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

Strut: Just grab the latest database.

[lerxst2112]

The file is named database_incremental.zip now.

[sorvani]

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]

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]

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]

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]

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]

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

[Relyt]

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

[Kayen]

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]

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]

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.