COMPLETE PUBLIC SERVER SETUP - Jan-2011

[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]

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.

[Melandril]

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]

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]

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 ?

[michaelw2000]

Originally Posted by Melandril

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]

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.