What I was able to use was mod_log_sql. It is better documented, at outoforder.cc, there is an apt package for easy installation in Ubuntu, and it partially works when activated. There is a scorecard table which I had to manually create (scorecard is apparently a recent modification).
LogSQLDatabase your_log_table LogSQLLoginInfo mysql://your_logging_db_user:your_password_here@localhost/your_log_table LogSQLCreateTables on LogSQLDBParam socketfile /var/run/mysqld/mysqld.sock LogSQLTransferLogFormat AbHhmRSsTUuvI
- Note: 'c' requires LogSQLWhichCookie
- Note: 'I' requires: Apache module unique_id: a2enmod unique_id
- Check the Apache error log after enabling mod_log_sql for errors such as a nonexistent score_board.
- SQL which might be needed once to create the scoreboard:
- CREATE TABLE IF NOT EXISTS `scoreboard` (
- `id` int(14) NOT NULL auto_increment,
- `vhost` varchar(50) NOT NULL default '',
- `bytes_sent` int(14) NOT NULL default '0',
- `count_hosts` int(12) NOT NULL default '0',
- `count_visits` int(12) NOT NULL default '0',
- `count_status_200` int(12) NOT NULL default '0',
- `count_status_404` int(12) NOT NULL default '0',
- `count_impressions` int(18) NOT NULL default '0',
- `last_run` int(14) NOT NULL default '0',
- `month` int(4) NOT NULL default '0',
- `year` int(4) NOT NULL default '0',
- `domain` varchar(50) NOT NULL default '',
- `bytes_receive` int(14) NOT NULL default '0',
- PRIMARY KEY (`id`),
- UNIQUE KEY `vhost` (`vhost`,`month`,`year`,`domain`)
- ) TYPE=MyISAM;
- LogSQLScoreDomain -> this is what will be targeted when doing the UPDATE
- query, default is default-domain.tld
- LogSQLScoreSubdomain -> this is what will be targeted when doing the
- UPDATE query, default is www
- LogSQLScoreTable -> this is the score table used for doing the stats
LogSQLScoreDomain reallysimplechat.org LogSQLScoreSubdomain www LogSQLTransferLogTable reallysimplechat_access_log
- Now turn on the logging.
Another detail which I didn't see mentioned is that both of these modules work alongside the others. If you still want the traditional text file logging, you can have that running in addition to the SQL copy of the data. And you may as well run both while you test the new tools.

Post new comment