|
Siag Office
Shohei Mail
Webresolve
Pen
Dwatch
XMagick
Myhtml
Simple Database Library
Sdbsiod
mod_log_sdb
mod_sql_sdb
Sdbgrey
Ulric's Router Construction Kit
neXtaw
Mowitz
Kylie
O3read
Ucron
Parsecgi
Mr Big
Ulric's stuff
|
|
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
|
|
|