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

some help please on step 13


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


Please advise.

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/

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

Strut: Just grab the latest database.

The file is named database_incremental.zip now.

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 >

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

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.

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....

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.

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

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.

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!

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.

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 ;-)

svn checkout with 64bit hangs on update
 

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

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 ?

FIXED the SVN hang on Update
 

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.

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.

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

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.

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?

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...

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

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

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

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...)

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!

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/sv...k/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

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?

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?

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.

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.

Fixed all issues.

Now need to tweak.

Thank you everyone for your help. :)

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?