1 files changed, 261 insertions, 92 deletions

diff --git a/Documentation/documentation.lyx b/Documentation/documentation.lyx
index a678315..eeb6af5 100644
--- a/Documentation/documentation.lyx
+++ b/Documentation/documentation.lyx
@@ -1,5 +1,5 @@
-#LyX 1.2 created this file. For more info see http://www.lyx.org/
-\lyxformat 220
+#LyX 1.3 created this file. For more info see http://www.lyx.org/
+\lyxformat 221
 \textclass article
 \language english
 \inputencoding default
@@ -162,7 +162,7 @@ Note which directives go in the 'main server config' and which directives
  This is made clear in the directive documentation.
 \layout Itemize
 
-The 'time_stamp' field is stored in an UNSIGNED INTEGER column, in the standard
+The 'time_stamp' field is stored in an UNSIGNED INTEGER format, in the standard
  unix 
 \begin_inset Quotes eld
 \end_inset 
@@ -173,9 +173,9 @@ seconds since the epoch
 
  format.
  This is superior to storing the access time as a string due to size requirement
-s: an UNSIGNED INT requires 4 bytes, whereas an Apache date string -- e.g.
- "18/Nov/2001:13:59:52 -0800" -- requires 26 bytes: those extra 22 bytes
- become significant when multiplied by thousands of accesses on a busy server.
+s: an UNSIGNED INT requires 4 bytes, whereas an Apache date string (e.g.
+ "18/Nov/2001:13:59:52 -0800") requires 26 bytes: those extra 22 bytes become
+ significant when multiplied by thousands of accesses on a busy server.
  Besides, an INT type is far more flexible for comparisons, etc.
 \begin_deeper 
 \layout Standard
@@ -301,6 +301,11 @@ These installation documents assume a relatively modern GNU/Linux scenario.
  compiling the module for those platforms.
 \layout Subsubsection
 
+
+\begin_inset LatexCommand \label{sub:Solaris}
+
+\end_inset 
+
 Solaris
 \layout Standard
 
@@ -387,6 +392,143 @@ contact
 \end_inset 
 
  and help fill in this section.
+\layout Subsubsection
+
+OS X
+\layout Standard
+
+mod_log_sql should compile and work out-of-the-box on this platform.
+ Here are some notes from a user successfully running the module on OS X:
+\layout Quote
+
+
+\emph on 
+The only changes I had to make were to where I had the various libraries
+ installed.
+\layout Quote
+
+
+\emph on 
+Here are the changes I made to the head of the Makefile:
+\layout LyX-Code
+
+APACHESOURCE    = /usr/local/src/apache_1.3.27 
+\layout Quote
+
+
+\emph on 
+(Wasn't sure if this was really needed or not, so I downloaded the Apache
+ source just in case)
+\layout LyX-Code
+
+APACHEINSTALLED = /usr/sbin 
+\layout LyX-Code
+
+APACHEHEADERS   = /usr/include/httpd 
+\layout LyX-Code
+
+APXS            = $(APACHEINSTALLED)/apxs
+\layout LyX-Code
+
+MYSQLLIBRARIES  = /usr/local/mysql/lib 
+\layout LyX-Code
+
+MYSQLHEADERS    = /usr/local/mysql/include
+\layout Quote
+
+
+\emph on 
+I'm using a binary installation of MySQL and the default apache installation
+ on OS X Client 10.2.3, the locations of these files may vary depending on
+ how you've installed MySQL and will almost certainly be different if you're
+ using OS X Server.
+\layout Standard
+
+My thanks to Tom Wiebe for being the first (to my knowlege) mod_log_sql
+ user on OS X and for providing these notes.
+\layout Subsubsection
+
+Digital Unix
+\layout Standard
+
+Digital Unix, like Solaris, needs to be linked against librt; see section
+ 
+\begin_inset LatexCommand \ref{sub:Solaris}
+
+\end_inset 
+
+.
+ Here are further notes from a user successfully running the module on Digital
+ Unix:
+\layout Quote
+
+
+\emph on 
+Instead of trying to get the module to remember where the MySQL libraries
+ were, I instead compiled apache with the information:
+\layout Quote
+
+
+\emph on 
+LDFLAGS='-rpath /isp/mysql/lib/mysql' ./configure ...
+\layout Quote
+
+
+\emph on 
+Everything worked as expected after that.
+ (The error I got without this was "/sbin/loader: Fatal Error: cannot map
+ libmysqlclient.so" )
+\layout Quote
+
+
+\emph on 
+Digital Unix (v4.0f, at least ) appears to follow the same requirements needed
+ by Solaris, so simply adding librt to the module made it compile without
+ errors.
+\layout Quote
+
+
+\emph on 
+As for the warnings, here's the text:
+\layout LyX-Code
+
+
+\emph on 
+mod_log_sql.c: In function `extract_request_duration': 
+\layout LyX-Code
+
+
+\emph on 
+mod_log_sql.c:292: warning: long int format, different type arg (arg 4)
+\layout LyX-Code
+
+
+\emph on 
+mod_log_sql.c: In function `extract_request_timestamp': 
+\layout LyX-Code
+
+
+\emph on 
+mod_log_sql.c:497: warning: long int format, different type arg (arg 4)
+\layout Quote
+
+
+\emph on 
+Poking around in the code, it looks like the compiler was complaining that
+ what time() is returning doesn't play nicely with %ld by default.
+ I just typecast them as (long)'s and the warnings went away ( not that
+ the module wasn't working correctly without them ).
+\layout Quote
+
+
+\emph on 
+The module works very well so far in testing...
+ hasn't dropped a single log entry yet.
+ 
+\layout Standard
+
+My thanks to Jim Turner for permitting me to quote him here, and for being
+ the first known user of mod_log_sql on Digital Unix.
 \layout Subsection
 
 Do I want a DSO or a static module?
@@ -919,10 +1061,24 @@ mysql> create database apachelogs;
 \end_inset 
 
 If you want to hand-create the tables, run the enclosed 'create-tables'
- SQL script as follows:
+ SQL script as follows (
+\begin_inset Quotes eld
+\end_inset 
+
+create_tables.sql
+\begin_inset Quotes erd
+\end_inset 
+
+ needs to be in your current working directory).
 \begin_deeper 
 \layout LyX-Code
 
+mysql> use apachelogs
+\layout LyX-Code
+
+Database changed
+\layout LyX-Code
+
 mysql> source create_tables.sql
 \end_deeper 
 \layout Enumerate
@@ -939,9 +1095,7 @@ Create a specific MySQL userid that httpd will use to authenticate and enter
 \layout LyX-Code
 
 mysql> grant insert,create on apachelogs.* to loguser@my.apachemachine.com
-\layout LyX-Code
-
-identified by 'l0gger';
+ identified by 'l0gger';
 \end_deeper 
 \layout Enumerate
 
@@ -4817,24 +4971,29 @@ Context: virtual host
 In HTTP, cookies have names to distinguish them from each other.
  Using mod_usertrack, for example, you can give your user-tracking cookies
  a name with the CookieName directive.
+ 
 \layout Standard
 
-You must include a 'c' character in 
-\noun on 
-LogSQLTransferLogFormat
-\noun default 
- for this directive to take effect; once you specify 'c', 
+mod_log_sql allows you to log cookie information.
+
 \noun on 
-LogSQLWhichCookie
+ LogSQLWhichCookie
 \noun default 
  tells mod_log_sql which cookie to log.
  This is necessary because you will usually be setting and receiving more
- than one cookie from a client; this cookie designates which one to log.
+ than one cookie from a client.
+\layout Standard
+
+You must include a 'c' character in 
+\noun on 
+LogSQLTransferLogFormat
+\noun default 
+ for this directive to take effect.
 \layout Standard
 
-Note: although this was intended for people who are using mod_usertrack
- to set user-tracking cookies, you aren't restricted in any way.
- You can choose which cookie you wish to log to the database --any cookie
+Note: although this was origintally intended for people using mod_usertrack
+ to create user-tracking cookies, you aren't restricted in any way.
+ You can choose which cookie you wish to log to the database -- any cookie
  at all -- and it doesn't necessarily have to have anything to do with mod_usert
 rack.
 \layout Subsubsection
@@ -5742,7 +5901,7 @@ Please contact
 Problems
 \layout Subsubsection
 
-Apache segfaults when using PHP and mod_log_sql
+Apache segfaults or has other problems when using PHP and mod_log_sql
 \layout Standard
 
 This occurs if you compiled PHP with MySQL database support.
@@ -5759,8 +5918,9 @@ real
  
 \layout Standard
 
-The solution is to configure PHP to link against the real MySQL libraries
- and recompile mod_php.
+PHP and mod_log_sql can be configured to happily coexist.
+ The solution is to configure PHP to link against the real MySQL libraries:
+ recompile PHP using --with-mysql=/your/path.
  Apache will run properly once the modules are all using the same version
  of the MySQL libraries.
 \layout Subsubsection
@@ -5983,6 +6143,83 @@ Reference:
 \end_inset 
 
 
+\layout Subsubsection
+
+Sometimes a single VirtualHost gets logged to two different tables (e.g.
+ access_foo_com, access_www_foo_com).
+ Or, accesses to an unqualified hostname (e.g.
+ 
+\begin_inset Quotes eld
+\end_inset 
+
+http://intranet/index.html
+\begin_inset Quotes erd
+\end_inset 
+
+) get logged in separate tables.
+\layout Standard
+
+Proper usage of the Apache runtime 
+\noun on 
+ServerName
+\noun default 
+ directive and the directive 
+\noun on 
+UseCanonicalName On 
+\noun default 
+(or 
+\noun on 
+DNS
+\noun default 
+) are necessary to prevent this problem.
+ 
+\begin_inset Quotes eld
+\end_inset 
+
+On
+\begin_inset Quotes erd
+\end_inset 
+
+ is the default for 
+\noun on 
+UseCanonicalName
+\noun default 
+, and specifies that self-referential URLs are generated from the 
+\noun on 
+ServerName 
+\noun default 
+part of your VirtualHost:
+\layout Quote
+
+With UseCanonicalName on (and in all versions prior to 1.3) Apache will use
+ the ServerName and Port directives to construct the canonical name for
+ the server.
+ With UseCanonicalName off Apache will form self-referential URLs using
+ the hostname and port supplied by the client if any are supplied (otherwise
+ it will use the canonical name, as defined above).
+ [From 
+\begin_inset LatexCommand \url[the Apache documentation]{http://httpd.apache.org/docs/mod/core.html#usecanonicalname}
+
+\end_inset 
+
+]
+\layout Standard
+
+The module inherits Apache's 
+\begin_inset Quotes eld
+\end_inset 
+
+knowledge
+\begin_inset Quotes erd
+\end_inset 
+
+ about the server name being accessed.
+ As long as those two directives are properly configured, mod_log_sql will
+ log to only one table per virtual host while using 
+\noun on 
+LogSQLMassVirtualHosting
+\noun default 
+.
 \layout Subsection
 
 Performance and Tuning
@@ -6236,7 +6473,7 @@ not
 correct
 \series default 
  to assume that 20 Apache children with a VSZ of 7MB each equals 
-\begin_inset Formula $(20\times 7MB)$
+\begin_inset Formula $(20\times7MB)$
 \end_inset 
 
  of memory consumption -- the real answer is much, much lower.
@@ -6359,74 +6596,6 @@ How do I...?
  -- accomplishing certain tasks
 \layout Subsubsection
 
-I am using LogSQLMassVirtualHosting, and sometimes a single VirtualHost
- gets logged to two different tables.
- How do I prevent that?
-\layout Standard
-
-Proper usage of the Apache runtime 
-\noun on 
-ServerName
-\noun default 
- directive and the directive 
-\noun on 
-UseCanonicalName On 
-\noun default 
-(or 
-\noun on 
-DNS
-\noun default 
-) are necessary to prevent this problem.
- 
-\begin_inset Quotes eld
-\end_inset 
-
-On
-\begin_inset Quotes erd
-\end_inset 
-
- is the default for 
-\noun on 
-UseCanonicalName
-\noun default 
-, and specifies that self-referential URLs are generated from the 
-\noun on 
-ServerName 
-\noun default 
-part of your VirtualHost:
-\layout Quote
-
-With UseCanonicalName on (and in all versions prior to 1.3) Apache will use
- the ServerName and Port directives to construct the canonical name for
- the server.
- With UseCanonicalName off Apache will form self-referential URLs using
- the hostname and port supplied by the client if any are supplied (otherwise
- it will use the canonical name, as defined above).
- [From 
-\begin_inset LatexCommand \url[the Apache documentation]{http://httpd.apache.org/docs/mod/core.html#usecanonicalname}
-
-\end_inset 
-
-]
-\layout Standard
-
-The module inherits Apache's 
-\begin_inset Quotes eld
-\end_inset 
-
-knowledge
-\begin_inset Quotes erd
-\end_inset 
-
- about the server name being accessed.
- As long as those two directives are properly configured, mod_log_sql will
- log to only one table per virtual host while using 
-\noun on 
-LogSQLMassVirtualHosting
-\noun default 
-.
-\layout Subsubsection
-
 How do I extract the data in a format that my analysis tool can understand?
 \layout Standard