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.

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.

Gotcha
 

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.

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.

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

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.

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

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/libp...l.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

Try here: http://sourceforge.net/projects/gnuw...es/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.

New problem
 

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

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

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?

Almostt
 

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.

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.

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.

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/...reATTsetup.png

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

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.

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

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/...rimgetting.png

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.

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

http://s1106.photobucket.com/albums/...rent=Error.png

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.

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.

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.

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.

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.

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 ?

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.

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!

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!

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.

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?

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

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.

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.

Compile problem
 

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

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

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