␡
- Introduction to Logging in Apache
- Default Apache Log Files
- Creating Log Formats
- Creating a Custom Log File
- Redirecting Logs to an External Program
- Logging Requests Conditionally
- Monitoring Who Is Linking to Your Website
- Monitoring Apache with mod_status
- Monitoring Apache with SNMP
- Analyzing Your Logs with Open-source Tools
- Monitoring Your Logs in Real Time
- Logging Requests to a Database
- Rotating and Archiving Logs
- Controlling IP Address Resolution
- Processing Logged IP Addresses
- Restarting Apache Automatically If It Fails
- Merging and Splitting Log Files
- Keeping Separate Logs for Each Virtual Host
- Common Log Entries
This chapter is from the book
Logging Requests to a Database
Apache itself does not include tools for logging to databases, but a few third-party scripts and modules are available:
- mod_log_sql allows you to log requests directly to a MySQL database: http://www.outoforder.cc/projects/apache/mod_log_sql/
- You can then query the database using the Apache LogView SQL tool: http://freshmeat.net/projects/apachelogviewsql/
- pglogd collects logs and stores log entries in a PostgreSQL database: http://www.digitalstratum.com/pglogd/.