COMPLETE PUBLIC SERVER SETUP - Jan-2011

[lerxst2112]

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]

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

[seratt]

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]

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

[lerxst2112]

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

[dranovir45]

Originally Posted by lerxst2112

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]

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]

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]

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]

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]

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]

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

[keglo]

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]

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.

[Bamzal]

Originally Posted by lerxst2112

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