mod_log_sdb

mod_log_sdb - Apache logging module to any database supported by libsdb.

This module is shamelessly adapted from mod_log_sqlite;
see original README in README.sqlite.

INSTALL:

You can install this module easily via apxs magic.

  % make
  # make install
  % make clean

CONFIGURATION (summary):

1. install libsdb from http://siag.nu/libsdb/
2. Add following lines to your httpd.conf

    LogSdbUrl url

CONFIGURATION (details):

First you should install the backend database and libsdb manually. See
http://siag.nu/libsdb/ for details.

Then you should initialize access_log database. How this happens
depends on the database. Example for sqlite:

  # mkdir /usr/local/apache/sqlite-logs
  # chown nobody:nobody /usr/local/apache/sqlite-logs

And for mysql:

  # mysqladmin create mydb


"create_table.sql" is bundled with this module. Note that this module
automatically creates log table if there's not one.

Finally, simply add the following line to your httpd.conf:

  LogSdbUrl url

The url is any url libsdb understands. What that is depends on
how libsdb was installed. Examples:

mysql:db=mydb:uid=myuser:pwd=mypassword
oracle:uid=myuser/mypasswd@mysid
sqlite:db=/path/to/datafile

Table name is "access_log" by default. You can change it via
"LogSdbTable" directive if you want to.

  LogSdbTable wwwlog

This module supports separate database urls per
VirtualHosts, which means you can even do:

  
  ServerName vh.example.com
  LogSdbUrl sqlite:db=/home/vh.example.com/logs/sqlite_log
  

That's all! Enjoy querying your access_log via VIEWs and/or sub-querys.

--
Ulric Eriksson
COPYING
ChangeLog
ChangeLog.sqlite
Makefile
README.sqlite
create_table.sql
mod_log_sdb.c