Topic: Another set of VC++ 2005 command-line build instructions

[tdonovan]

At the risk of creating yet another large topic - this set of command-line instructions for building Apache 2.2.3 with mod_ssl and mod_deflate differs in several ways from the previous posts:

The "not for commercial use" MASM V8 assembler is avoided
GCC is used to build ZLib using an assembly language component
Warnings during the ZLib build are reduced
Separate .manifest files are not needed

This produces a "Release" build of Apache 2.2.3 which builds and runs OK for me on both Windows 2003 and Windows 2000.

I hope it will be useful to other Windows/Apache enthusiasts.

-tom-

TOOLS USED TO BUILD APACHE 2.2.3

Visual C++ 2005 Express Edition - http://msdn.microsoft.com/vstudio/express/visualc/download/
Windows Server 2003 R2 Platform SDK (1) - http://www.microsoft.com/downloads/details.aspx?FamilyId=0BAF2B35-C656-4969-ACE8-E4C0C0716ADB
Perl Programming Language - http://downloads.activestate.com/ActivePerl/Windows/5.8/ActivePerl-5.8.8.817-MSWin32-x86-257965.msi
GNU GAWK Programming Language (2) - http://prdownloads.sourceforge.net/gnuwin32/gawk-3.1.4.exe
GNU BISON Parser Generator (3) - http://prdownloads.sourceforge.net/gnuwin32/bison-1.875-4.exe
GNU FLEX Lexical Analyser - http://prdownloads.sourceforge.net/gnuwin32/flex-2.5.4a-1.exe
GNU M4 Macro Processor - http://prdownloads.sourceforge.net/gnuwin32/m4-1.4.4.exe
GNU SED Stream Editor - http://prdownloads.sourceforge.net/gnuwin32/sed-4.1.4.exe
GNU PATCH (4) - http://prdownloads.sourceforge.net/gnuwin32/patch-2.5-bin.exe
NASM Assembler (5) - http://prdownloads.sourceforge.net/nasm/nasm-0.98.39-win32.zip
MinGW GCC compiler (6) - http://prdownloads.sourceforge.net/mingw/gcc-core-3.4.2-20040916-1.tar.gz
MinGW GAS assembler(6) - http://prdownloads.sourceforge.net/mingw/binutils-2.17.50-20060824-1.tar.gz

(1) Start the Visual C++ 2005 Express Edition at least once before installing Windows Server 2003 R2 Platform SDK

(2) Copy or rename C:\Program Files\GnuWin32\bin\gawk.exe to awk.exe so the Apache build will recognize it.

An alternative to GAWK is at http://cm.bell-labs.com/cm/cs/who/bwk/awk95.exe.
If you use this version of awk, be sure to copy or rename awk95.exe to awk.exe.

(3) Versions of BISON higher than 1.875-4 will not work to build OpenSSL. All other GNU tools are the latest version.

(4) PATCH is only needed to correct errors in Apache 2.2.3 Windows source makefiles.

(5) A roughly 10% performance gain in OpenSSL (mod_ssl) can be acheived by using several assembly-language components
NASM will assemble a dialect of Intel-format assembly-language files.

(6) A roughly 10% performance gain in Zlib compression (mod_deflate) can be acheived by using one assembly-language component
GCC.exe and AS.exe (which is in the binutils package) will assemble a dialect of AT&T-format assembly-language files.

If you do not have a utility which will expand .tar.gz files (like WinZip version 9 or higher), the additional GNU tools GZIP and TAR are useful.
Create a new directory to un-tar the MinGW tools into, for example:

[toadie]

THe build went fine . When trying to run it, it says I am missing MSVC*80.dll.

I followed the instructions from MS to install the redistributable DLL, still failed.

Any one has any luck?

Thanks

[tdonovan]

Installing the redistributable DLL should have put MSVCR80.DLL in a directory with a name like
C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd
for Windows XP.

A copy also goes in C:\WINNT\System32 for Windows 2000.

If Apache cannot find this file - you might try searching for MSVCR80.DLL and copying it to your Apache \bin directory.

-tom-

[toadie]

Thanks tdonovan. That works. One more followup question. That works on another machine but not the one that I used to build the binaries. Apparently my WinXP Sp2 has 2 copies of the DLL. Any idea how I can remove ond of the DLL?

Both are in C:\WINDOWS\WinSxS and complete with manifests.

Thanks a bunch
Toadie

[acid.-.burn]

i have did ever thing in the above & it built ever thing ok all exe's dll's & mod folders & files but 1 problem when i ziped it up to put on anuther pc it will not work but it works on the pc i built it on am i missing somthing here i have even tryed the dll with the code in anuther tut here

MSVCR80.DLL

Microsoft.VC80.CRT.manifest

[krka01]

Hi,

Have you installed the Microsoft Visual C++ 2005 Redistributable Package (x86)? Check out this thread for more info:

http://www.apachelounge.com/viewtopic.php?p=6074

Krister

[acid.-.burn]

Thanks that worked like a charm

[krka01]

Tdonovan,

Thanks for this excellent command-line guide, it´s a timesaver and have help me a lot. Any chance you will add instructions howto compile modsecurity2?

Krister

[Mitron]

I do like this tutorial, I was able to compile Apache 2.2.8 without issue. I attempted to take it one step further by enabling DBD support and attempting to build the apr_dbd_mysql but I got a little lost on where to put the mysql\lib\opt files.

I added my mysql\bin, mysql\include and mysql\lib paths to the PATH, INCLUDE and LIB variables, edited apu.hw to add the #define APR_DSO_BUILD 1 and #define APU_HAVE_MYSQL 1 but then it can't find the includes. If I do an echo %INCLUDE% the mysql\include path is listed but the build errors trying to find mysql.h.

By placing the mysql\include files in the work\httpd-2.2.8\srclib\apr-util\include\mysql folder I was able to get it to recognize all the *.h files but then it can't find the libraries, or so it seems by the erros. There doesn't seem to be a work\httpd-2.2.8\srclib\apr-util\lib folder to place the mysql\lib\opt files so I'm not sure where to place them. Again if I do an echo %LIB% the mysql\lib path is listed.

One other thing I noticed nibbing around in apu.hnw I noticed this line of code.

[Steffen]

You should only add this line to srclib\apr\include\apr.hw

#define APR_DSO_BUILD 1

Thats all.

This will let you use MySQL authentcation with ODBC, see the modules from Tom on the download page. No need to build Mysql in it.

Btw.
The DBD mods from Tom are working Great !!! here.


Steffen

[Mitron]

[tdonovan]

Yes - I built the mysql, pgsql, and sqlite3 dbd drivers from the SVN source sometime during the Apache 2.2.6 time frame in order to compare their performance to the odbc driver.

I dug up my notes, but I didn't really keep good notes about building them - just my results. My impression was that no one had previously built or tested any of these drivers on Windows. There are none of the usual #ifdef WIN32 directives which indicate someone ported the source code for Windows, and no Makefile - so be sure to test very thoroughly before using them in production!.

From memory, I built them like this:

* edit apu.h and set the symbols APU_HAVE_MYSQL, etc. to 1
(remember to change this file back before re-building Apache again)

* for all the drivers, compile and link each driver manually in the apu-util\dbd directory using the same compiler switches and defines that you see when you build libaprutil. The -DWIN32 and -DAPU_DECLARE_EXPORT switches are important. Add a -I compiler switch to the apr-util\include\private directory. Link with the the /DLL switch and include the Apache libraries: libaprutil-1.lib and libapr-1.lib, and also the Windows library: wsock32.lib

* for mysql, add a -I compiler switch to your mysql \include directory. Link with the libmysql.lib which corresponds to your libmysql.dll. I don't remember if you get this file with the MySQL distribution - but you will get one if you build MySQL yourself from source. I think I remember editing apr_dbd_mysql.c to fix the directory for the mysql include files.

* for pgsql, pretty much the same. add -I to your Postgresql \include directory. link with libpq.lib.

* for sqlite3, first build sqlite3 from source, then add -I to the directory containing sqlite3.h. Link with sqlite3.lib.

My notes about using them were:

* mysql - runs nearly as fast as odbc. OK to retrieve columns which are NULL, but don't ever pass it any NULL parameters.

* pgsql - runs even faster than odbc, but doesn't handle NULLs at all - either results or parameters. No error messages except for open errors - it just returns zero rows for any SQL error (the same as if there were no rows). This makes it pretty hard to diagnose problems.

* sqlite3 - as expected, it is amazingly fast on reads (> 2,000 per sec) and terrible on writes/updates (10-20 per second). This is sqlite's niche so it was no surprise. You definitely don't want to use sqlite for logging - but it is excellent for authentication, virtual host lookups, etc. I didn't note whether it handled NULLs correctly. It probably did.

Sorry it's such sketchy info. If I find the time I will try to build them all from the Apache 2.2.8 source and make some proper cookbook-style notes.

Hope this helps,
-tom-

[Mitron]

[tdonovan]

Sorry for the delay responding to your question.

Here is how to manually build the MySQL, PostGreSQL, and SQLite3 DBD drivers with Visual Studio 2005 from the Apache 2.2.8 source code:

* Edit the file srclib\apr-util\include\apu.h and change the defines for the three databases to 1:

[Mitron]

Awesome!! That worked like a charm.

BTW, thought I'd mention that this command:

[tdonovan]

I didn't realize that the /nologo switch was case-sensitive with CL.
I edited the instructions above to correct this.

-tom-

[bentogoa]

bin\ApacheMonitor.exe
bin\htdbm.exe

this files dont work when this