LICENSE

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55

$Id: LICENSE,v 1.3 2002/05/14 21:50:51 helios Exp $

Copyright (c) 2002 Christopher B. Powell. All rights reserved.
Portions copyright (c) 2000 The Apache Software Foundation.  

Redistribution and use in source and binary forms, with or without
modification, are permitted provided that the following conditions
are met:

1. Redistributions of source code must retain the above copyright
   notice, this list of conditions and the following disclaimer.

2. Redistributions in binary form must reproduce the above copyright
   notice, this list of conditions and the following disclaimer in
   the documentation and/or other materials provided with the
   distribution.

3. The end-user documentation included with the redistribution,
   if any, must include the following acknowledgment:
      "This product includes software developed by the
       Apache Software Foundation (http://www.apache.org/)
       and by Christopher Powell, mod_log_mysql Module Maintainer
       (http://www.grubbybaby.com/mod_log_mysql/)."
   Alternately, this acknowledgment may appear in the software itself,
   if and wherever such third-party acknowledgments normally appear.

4. The names "mod_log_mysql" and "mod_log_sql" must
   not be used to endorse or promote products derived from this
   software without prior written permission. For written
   permission, please contact <chris@grubbybaby.com>.

5. Products derived from this software may not be called
   "mod_log_mysql" or "mod_log_sql", nor may "mod_log_mysql" or
   "mod_log_sql" appear in their names, without prior written permission
   of Christopher B. Powell.

6. Redistributions of any form whatsoever must retain the following
   acknowledgment: "This product includes software developed by
   Christopher B. Powell <chris@grubbybaby.com> for use in the
   mod_log_mysql project (http://www.grubbybaby.com/mod_log_mysql/).

THIS SOFTWARE IS PROVIDED `AS IS'' AND ANY EXPRESSED OR IMPLIED
WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
OF MERCHANTABILITY AND FITN Edward Rudd
2004-06-03
| 
| 
| 
| 
| 
| 

fixed segfault in the mysql escape string function
DBi driver working with postgresql.
* 1.98 release1.98  Edward Rudd
2004-05-13
|
* renamed directory Documentation to docs  Edward Rudd
2004-05-12
| 
| 
| 
| 
| 

updated configure and makefile to use new m4 files
* win32 updates and build script  Edward Rudd
2004-04-29
| 
| 
| 
| 
| 

added LogSQLDisablePreserve
set default of preserve file to root_relative logs/mod_log_sql-preserve
* copied mysql driver to mod_log_sql_pgsql.c to start on PostgreSQL driver  Edward Rudd
2004-04-10
| 
| 
| 
| 
| 

added keyword ID expansion to source files and removed old CVS headers from others
* Made to work under Apache 1.3 again1.97  Edward Rudd
2004-04-09
| 
| 
| 
| 
| 

removed debugging for config merge function
* Added registration function for database drivers  Edward Rudd
2004-04-07
| 
| 
| 
| 
| 
| 
| 
| 
| 
| 
| 

completely separated mysql driver
added optional server announce (LogSQLAnnouce On)
cleaned up internal names of Database parameters
added code to allow +/- of logged cookies,headers, and notes, as well as remhostignore, request allow and request ignore.
reorganized command_rec again
made bigger not about deprecated commands
updated documentation
* Fixed issue with different include directories for APR and APU.  Edward Rudd
2004-03-22
| 
| 
| 
| 
| 

updated help screen after make install
* updated release date1.96  Edward Rudd
2004-03-05
|
* updated compatability header for Apache 1.3  Edward Rudd
2004-03-05
| 
| 
| 
| 
| 
| 
| 
| 
| 

Changed log_error routing for Apache 1.3 to include APLOG_NOERRNO
re-added quarter second delay between reconnect and query retry.
updated makefile to generate HTML version of docbook docs.
added comments to mod_log_sql_mysql.c
updated documentation about --with-db-inc configure option
* complete DB separation from core module code.  Edward Rudd
2004-03-04
| 
| 
| 
| 
| 
| 
| 

99% updated documentation (needs 2 tables added)
moved DB connection code for Apache 2 from open_logs to child_init.
removed more #ifdef debug lines
* separated out most mysql specific code to mod_log_sql_mysql.c  Edward Rudd
2004-02-29
| 
| 
| 
| 
| 
| 
| 
| 
| 
| 

beginnings of separation of core SQL logging logic
moved DB connection paramters to a table (for cutoms params for DB drivers)
added new configuration directive to handle any DB parameter
renamed all log_sql_* vars and type to logsql_*
Added enums for opendb return codes.
organized config directives and commented for easier reading of source
* Split Changelog and TODO to separate files.  Edward Rudd
2004-02-12
|
* Cleaned up changelog  Edward Rudd
2004-02-12
|
* update changelog1.95  Edward Rudd
2004-02-05
| 
| 
| 
| 
| 

release 1.95
* fixed segfaul bug with pointer arithmetic in add_server_string_slot  Edward Rudd
2004-02-04
| 
| 
| 
| 
| 
| 

Added authors file
release 1.94
* SSL support working under 1.3 and 2.0 as a separate module  Edward Rudd
2004-01-22
| 
| 
| 
| 
| 
| 

preparsing of logformat completed.
updated configure scripts to detect mod_ssl.h for 1.3 (mostly)
* fixed log_error function1.93  Edward Rudd
2004-01-21
| 
| 
| 
| 
| 
| 
| 

finished ssl split into separate module
added item registration function. (for ssl sub-module)
release 1.93
* moved extract_* functions to functions.h (version specific in ↵  Edward Rudd
2004-01-20
| 
| 
| 
| 
| 
| 
| 
| 
| 

functions(13|20).h)

moves SSL logging routings to mod_log_sql_ssl.c
updated changelog
added AUTHORS
* split out version specific code  Edward Rudd
2004-01-20
| 
| 
| 
| 
| 
| 
| 

code compiles under apache 1.3 and 2.0
updated apache m4 script to detect both verions (two minumums)
defaulted install to not activate module in configuration file (use make activate)
* update m4 files  Edward Rudd
2004-01-06
| 
| 
| 
| 
| 

release  1.92
* update apache.m4 to use -with-apxs instead of --with-apache  Edward Rudd
2004-01-04
| 
| 
| 
| 
| 
| 

got SSL support to compile.
added Documentation subdirectory.
* update autoconf scripts to check MySQL..1.91  Edward Rudd
2003-12-23
| 
| 
| 
| 
| 
| 
| 
| 
| 

moved autoconf DEFUN macros to m4 subdirectory
autogen.sh calls aclocal to include m4 directory.
merged in changes from 1.19b1
fixed log_sql_merge_config bug in 1.19b1
release 1.91
* compiles and loads under apache2.0  Edward Rudd
2003-12-22
| 
| 
| 
| 
| 
| 

consolidated configuration functions uses APR_OFFSETOF..
delayed inserts are configurable
* Initial revision  Edward Rudd
2003-12-20
|
* Changes on the way to 1.19.  This is probably going to be 1.19b1.  Detail:1.19b1  Christopher Powell
2003-07-22
| 
| 
| 
| 
| 
| 
| 
| 
| 
| 
| 
| 
| 
| 
| 

* Hostnames are now converted to lowercase in the mass-virtual naming section.
  The loop that converts dots to underscores has been optimized as well.
* Migration to autoconf
* New directive LogSQLTableType allows one to specify the kind of table that
  the module makes during table creation (e.g. InnoDB, MyISAM).  Thanks to Jim
  Turner for the suggestion and patch.  If your MySQL server does not support
  the specified type, it will create a MyISAM table instead.
* Directives can now be placed in the 'main' server config and will be
  inherited by the virtual hosts.  This means a LOT less repetition: you only
  specify the item once to have it inherited, but it can still be overridden
  on a virtualhost level.
* Some minor additions / edits to the docs.  Christopher Powell
2003-03-27
|
* Removed message about insufficient info to log.1.18  Christopher Powell
2002-12-18
|
* Delayed inserts, includes, better table creation, renamed global vars,  Christopher Powell
2002-12-18
|
* Changes on route to 1.18 release (better table creation logic and ↵  Christopher Powell
2002-12-10
| 
| 
| 
| 

workarounds for delayed insert kluge).
* More documentation work on the way to final 1.17 release.  Christopher Powell
2002-11-14
| 
| 
| 
| 
| 

Additional work on the Makefile.
* Monster changes en route to 1.17.  Esp. with new documentation.  Christopher Powell
2002-11-14
|
* *** empty log message ***1.17pre2  Christopher Powell
2002-09-04
|
* Lots of changes & bugfixes as requested on the list.  Pre-1 of 1.17.1.17pre1  Christopher Powell
2002-06-27
|
* More effort toward next release.  Now include headers in/out.  Christopher Powell
2002-05-24
|
* Further changes on the way to 1.17, big one was the segfault fix.  Christopher Powell
2002-05-16
|
* Added notes logging capability.  This is a commit prior to a lot of work  Christopher Powell
2002-05-14
| 
| 
| 
| 
| 

that will rename mod_log_mysql to mod_log_sql.
* Significant headway toward a releasable 1.16, passed ab testing and my  Christopher Powell
2002-04-23
| 
| 
| 
| 
| 

own hand tests.  Mods documented in CHANGELOG.
* Significant bugfixes and feature additions on the way to 1.16...  Christopher Powell
2002-04-21
|
* Added - but did not activate - routines to handle proxy environment variables.  Christopher Powell
2002-04-08
|
* This is a "pre" snapshot of 1.15.  Numerous changes emphasizing how SQL  Christopher Powell
2002-04-02
| 
| 
| 
| 
| 
| 

errors are reported and handled.  Any missed queries during SQL downtime
are written out to a textfile.
* Minor but significant updates to the instructions for apxs users.  Christopher Powell
2002-02-24
|
* Ported to mysql_real_connect, made a change for the mass-virtual-hosting1.13  Christopher Powell
2002-01-15
| 
| 
| 
| 
| 

folks, and enabled a socket name DEFINE.
* Added a mysql_close mechanism to the child exit process to fix MySQL  Christopher Powell
2001-12-07
| 
| 
| 
| 
| 
| 

complaining about bad communication packets.  Considerable code reorg
and cleanup.
* Big changes including reworked cookie code, new directives, SSL logging,  Christopher Powell
2001-12-03
| 
| 
| 
| 
| 

new formatting characters, bugfixes, etc.
* A lot of code cleanup and tweaking, plus cookie logging:1.10  Christopher Powell
2001-11-30
| 
| 
| 
| 
| 
| 
| 
| 
| 
| 
| 

* New capability:  log mod_usertrack cookies.
* Some code cleanup and commenting.
* Referer and User-Agent now set to want_orig=1 ( a very minor detail )
* Corrected mysql_escape_log to properly check for and escape strings
  with 'dangerous' characters.  It appears that it was doing this
  incorrectly before.
* Deleted log_mysql_child(), a function that was never called.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55	$Id: LICENSE,v 1.3 2002/05/14 21:50:51 helios Exp $ Copyright (c) 2002 Christopher B. Powell. All rights reserved. Portions copyright (c) 2000 The Apache Software Foundation. Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: 1. Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer. 2. Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution. 3. The end-user documentation included with the redistribution, if any, must include the following acknowledgment: "This product includes software developed by the Apache Software Foundation (http://www.apache.org/) and by Christopher Powell, mod_log_mysql Module Maintainer (http://www.grubbybaby.com/mod_log_mysql/)." Alternately, this acknowledgment may appear in the software itself, if and wherever such third-party acknowledgments normally appear. 4. The names "mod_log_mysql" and "mod_log_sql" must not be used to endorse or promote products derived from this software without prior written permission. For written permission, please contact <chris@grubbybaby.com>. 5. Products derived from this software may not be called "mod_log_mysql" or "mod_log_sql", nor may "mod_log_mysql" or "mod_log_sql" appear in their names, without prior written permission of Christopher B. Powell. 6. Redistributions of any form whatsoever must retain the following acknowledgment: "This product includes software developed by Christopher B. Powell <chris@grubbybaby.com> for use in the mod_log_mysql project (http://www.grubbybaby.com/mod_log_mysql/). THIS SOFTWARE IS PROVIDED `AS IS'' AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITN Edward Rudd	2004-06-03
\| \| \| \| \| \|	fixed segfault in the mysql escape string function DBi driver working with postgresql.
*	1.98 release1.98	Edward Rudd	2004-05-13
\|
*	renamed directory Documentation to docs	Edward Rudd	2004-05-12
\| \| \| \| \|	updated configure and makefile to use new m4 files
*	win32 updates and build script	Edward Rudd	2004-04-29
\| \| \| \| \|	added LogSQLDisablePreserve set default of preserve file to root_relative logs/mod_log_sql-preserve
*	copied mysql driver to mod_log_sql_pgsql.c to start on PostgreSQL driver	Edward Rudd	2004-04-10
\| \| \| \| \|	added keyword ID expansion to source files and removed old CVS headers from others
*	Made to work under Apache 1.3 again1.97	Edward Rudd	2004-04-09
\| \| \| \| \|	removed debugging for config merge function
*	Added registration function for database drivers	Edward Rudd	2004-04-07
\| \| \| \| \| \| \| \| \| \| \|	completely separated mysql driver added optional server announce (LogSQLAnnouce On) cleaned up internal names of Database parameters added code to allow +/- of logged cookies,headers, and notes, as well as remhostignore, request allow and request ignore. reorganized command_rec again made bigger not about deprecated commands updated documentation
*	Fixed issue with different include directories for APR and APU.	Edward Rudd	2004-03-22
\| \| \| \| \|	updated help screen after make install
*	updated release date1.96	Edward Rudd	2004-03-05
\|
*	updated compatability header for Apache 1.3	Edward Rudd	2004-03-05
\| \| \| \| \| \| \| \| \|	Changed log_error routing for Apache 1.3 to include APLOG_NOERRNO re-added quarter second delay between reconnect and query retry. updated makefile to generate HTML version of docbook docs. added comments to mod_log_sql_mysql.c updated documentation about --with-db-inc configure option
*	complete DB separation from core module code.	Edward Rudd	2004-03-04
\| \| \| \| \| \| \|	99% updated documentation (needs 2 tables added) moved DB connection code for Apache 2 from open_logs to child_init. removed more #ifdef debug lines
*	separated out most mysql specific code to mod_log_sql_mysql.c	Edward Rudd	2004-02-29
\| \| \| \| \| \| \| \| \| \|	beginnings of separation of core SQL logging logic moved DB connection paramters to a table (for cutoms params for DB drivers) added new configuration directive to handle any DB parameter renamed all log_sql_* vars and type to logsql_* Added enums for opendb return codes. organized config directives and commented for easier reading of source
*	Split Changelog and TODO to separate files.	Edward Rudd	2004-02-12
\|
*	Cleaned up changelog	Edward Rudd	2004-02-12
\|
*	update changelog1.95	Edward Rudd	2004-02-05
\| \| \| \| \|	release 1.95
*	fixed segfaul bug with pointer arithmetic in add_server_string_slot	Edward Rudd	2004-02-04
\| \| \| \| \| \|	Added authors file release 1.94
*	SSL support working under 1.3 and 2.0 as a separate module	Edward Rudd	2004-01-22
\| \| \| \| \| \|	preparsing of logformat completed. updated configure scripts to detect mod_ssl.h for 1.3 (mostly)
*	fixed log_error function1.93	Edward Rudd	2004-01-21
\| \| \| \| \| \| \|	finished ssl split into separate module added item registration function. (for ssl sub-module) release 1.93
*	moved extract_* functions to functions.h (version specific in ↵	Edward Rudd	2004-01-20
\| \| \| \| \| \| \| \| \|	functions(13\|20).h) moves SSL logging routings to mod_log_sql_ssl.c updated changelog added AUTHORS
*	split out version specific code	Edward Rudd	2004-01-20
\| \| \| \| \| \| \|	code compiles under apache 1.3 and 2.0 updated apache m4 script to detect both verions (two minumums) defaulted install to not activate module in configuration file (use make activate)
*	update m4 files	Edward Rudd	2004-01-06
\| \| \| \| \|	release 1.92
*	update apache.m4 to use -with-apxs instead of --with-apache	Edward Rudd	2004-01-04
\| \| \| \| \| \|	got SSL support to compile. added Documentation subdirectory.
*	update autoconf scripts to check MySQL..1.91	Edward Rudd	2003-12-23
\| \| \| \| \| \| \| \| \|	moved autoconf DEFUN macros to m4 subdirectory autogen.sh calls aclocal to include m4 directory. merged in changes from 1.19b1 fixed log_sql_merge_config bug in 1.19b1 release 1.91
*	compiles and loads under apache2.0	Edward Rudd	2003-12-22
\| \| \| \| \| \|	consolidated configuration functions uses APR_OFFSETOF.. delayed inserts are configurable
*	Initial revision	Edward Rudd	2003-12-20
\|
*	Changes on the way to 1.19. This is probably going to be 1.19b1. Detail:1.19b1	Christopher Powell	2003-07-22
\| \| \| \| \| \| \| \| \| \| \| \| \| \| \|	* Hostnames are now converted to lowercase in the mass-virtual naming section. The loop that converts dots to underscores has been optimized as well. * Migration to autoconf * New directive LogSQLTableType allows one to specify the kind of table that the module makes during table creation (e.g. InnoDB, MyISAM). Thanks to Jim Turner for the suggestion and patch. If your MySQL server does not support the specified type, it will create a MyISAM table instead. * Directives can now be placed in the 'main' server config and will be inherited by the virtual hosts. This means a LOT less repetition: you only specify the item once to have it inherited, but it can still be overridden on a virtualhost level.
*	Some minor additions / edits to the docs.	Christopher Powell	2003-03-27
\|
*	Removed message about insufficient info to log.1.18	Christopher Powell	2002-12-18
\|
*	Delayed inserts, includes, better table creation, renamed global vars,	Christopher Powell	2002-12-18
\|
*	Changes on route to 1.18 release (better table creation logic and ↵	Christopher Powell	2002-12-10
\| \| \| \|	workarounds for delayed insert kluge).
*	More documentation work on the way to final 1.17 release.	Christopher Powell	2002-11-14
\| \| \| \| \|	Additional work on the Makefile.
*	Monster changes en route to 1.17. Esp. with new documentation.	Christopher Powell	2002-11-14
\|
*	* empty log message *1.17pre2	Christopher Powell	2002-09-04
\|
*	Lots of changes & bugfixes as requested on the list. Pre-1 of 1.17.1.17pre1	Christopher Powell	2002-06-27
\|
*	More effort toward next release. Now include headers in/out.	Christopher Powell	2002-05-24
\|
*	Further changes on the way to 1.17, big one was the segfault fix.	Christopher Powell	2002-05-16
\|
*	Added notes logging capability. This is a commit prior to a lot of work	Christopher Powell	2002-05-14
\| \| \| \| \|	that will rename mod_log_mysql to mod_log_sql.
*	Significant headway toward a releasable 1.16, passed ab testing and my	Christopher Powell	2002-04-23
\| \| \| \| \|	own hand tests. Mods documented in CHANGELOG.
*	Significant bugfixes and feature additions on the way to 1.16...	Christopher Powell	2002-04-21
\|
*	Added - but did not activate - routines to handle proxy environment variables.	Christopher Powell	2002-04-08
\|
*	This is a "pre" snapshot of 1.15. Numerous changes emphasizing how SQL	Christopher Powell	2002-04-02
\| \| \| \| \| \|	errors are reported and handled. Any missed queries during SQL downtime are written out to a textfile.
*	Minor but significant updates to the instructions for apxs users.	Christopher Powell	2002-02-24
\|
*	Ported to mysql_real_connect, made a change for the mass-virtual-hosting1.13	Christopher Powell	2002-01-15
\| \| \| \| \|	folks, and enabled a socket name DEFINE.
*	Added a mysql_close mechanism to the child exit process to fix MySQL	Christopher Powell	2001-12-07
\| \| \| \| \| \|	complaining about bad communication packets. Considerable code reorg and cleanup.
*	Big changes including reworked cookie code, new directives, SSL logging,	Christopher Powell	2001-12-03
\| \| \| \| \|	new formatting characters, bugfixes, etc.
*	A lot of code cleanup and tweaking, plus cookie logging:1.10	Christopher Powell	2001-11-30
\| \| \| \| \| \| \| \| \| \| \|	* New capability: log mod_usertrack cookies. * Some code cleanup and commenting. * Referer and User-Agent now set to want_orig=1 ( a very minor detail ) * Corrected mysql_escape_log to properly check for and escape strings with 'dangerous' characters. It appears that it was doing this incorrectly before. * Deleted log_mysql_child(), a function that was never called.