path: root/CHANGELOG

$Id: CHANGELOG,v 1.21 2003/03/27 01:58:42 helios Exp $

TODO:
* Rethink documentation flow and rewrite?
* Port connection portion to other DBMS?  Genericize the module?  Start with 
  PostgreSQL.
* GNU autoconf
* merge server config into vh config
* port to Apache 2.x
* does determining table name in massvirtual mode upon every request
  cause performance degradation?  If so fix.
* LogSQLRotateLogs directive with daily/monthly/weekly/etc.
* new format char: IP as bigint?
* socket-based middleman daemon with configurable conns, or connect/disconnect.
* ignore by cookie
* tool to import logs into SQL
* Directive to yes/no create ancillary tables (or just access table)

CHANGES:

1.18:
* Delayed inserts (a MySQL extension) are now available at compile-time.
  THIS IS UGLY because there seems to be a bug in the way MySQL returns
  errors on failed INSERT DELAYED queries.  See the FAQ.
* Reworked the Makefile a tad.
* Added stdlib.h to the includes, some systems need it for atoi(). Added
  string.h to the includes just to be safe.
* Reworked table creation (again).  Inserts are attempted and tables
  are made only on ER_NO_SUCH_TABLE.  This should solve all the multiple-
  creation-attempt issues as well as reduce overhead.
* safe_mysql_query reworked; it now can be counted on to preserve_entry()
  if the query doesn't succeed.  [Before, preserve_entry() was called
  separately.]
* Always reset SIGPIPE to handler before leaving safe_mysql_query().
* New directive LogSQLRequestAccept, another filter for excluding things
  from being logged.
* Alphabetized the directives in the reference section of the docs.
* New format char 'a' lets one log the request arguments, i.e. the
  part of a CGI request after the ? character.  Also put a column for
  this in the create_tables.sql file.  Thanks to Dave Wilson for this.
* Reorganized the FAQ by section.
* Renamed global variables (e.g. tcp_port -> logsql_tcpport) throughout
  the code in order to ensure against naming conflicts.  tcp_port, in
  particular, seemed to be causing problems / segfaults on certain systems.
* Renamed safe_mysql_query() to safe_sql_query().
* Now check for minimum configuration info to establish db link and
  log an error if it's insufficient.


1.17:
* Renamed the module mod_log_sql to conform to the project goal of
  database-inspecificity.
* Added capability of logging Notes field.  This is useful for folks using
  custom modules that provide loggable info in the notes, e.g. mod_gzip.
  A new directive LogSQLWhichNotes configures which notes to log to the
  notes_log table.
* Added capability of logging inbound and outbound headers. New directives
  LogSQLWhichHeadersIn and LogSQLWhichHeadersOut configure which headers to
  capture.  Headers are stored in their own table or tables.
* Fixed potential segfault in preserve file function due to silly pfclose
  placement. (Only affected user if the preserve file couldn't
  be opened.)
* Changed default socket file to /tmp/mysql.sock because that's the
  default on a compiled MySQL.
* Put back-quotes (`) around table name so that names with dashes are
  legal.
* Took away the prepend of /tmp to the preserve filename.  Now the
  user can specify whatever local path they want.  I figure that
  filesystem permissions will prevent people from doing anything
  really dumb, and people have requested this change.
* Better checking in the extract_cookie routine.  Before, it could
  segfault if a person specified "c" but didn't define MySQLWhichCookie.
* Some code reorg/renaming for clarity and to support the new direction
  of database inspecificity.  More to come.
* Simplified error messages.
* Table creation now uses safe_mysql_query and checks the result.
* Config directives used to begin with MySQL, now begin with LogSQL.
  This is for database inspecificity.  In your httpd.conf just do
  a search-and-replace.
* More robust table-creation code with error checking.  [The race condition
  that several users have reported may still exist, but this will go a long
  way toward debugging the condition.]
* Fixed bug whereby a MySQL connection was abandoned on reopen; the old
  connection is now properly closed first.
* Minor: remind user not to set createtables when massvirtual is on.
* If Apache started but MySQL was unavailable, the module would do
  everything it was supposed to (preserve entries, etc.) but not notify
  the sysadmin. Added a log message to alert sysadmin if MySQL is
  unreachable at startup.
* New config key 'I' to extract & log unique_id, provided by mod_unique_id.
  unique_id is the key that links separate tables (access, notes, etc.)
* Migrated to the Artistic License (as used by Perl).
* Moved table creation into its own callable function
* Robustifying table creation
* In make_combined_log.pl, backtick-quoted the table name and added an 
  order-by clause within the select statement.
* TCP port number for db connection is now configurable using LogSqlTCPPort
* New directive LogSQLForcePreserve sends all log entries directly to the
  preserve file and *entirely bypasses* the db.  Useful for debugging, but
  can be dangerous if you forget it's set!
* Table names are now quoted in all cases with backticks in order to permit
  names containing dashes (since many hostnames contain dashes).
* The request_method field is now creat Christopher Powell