Sebastian Mogilowskis Blog

Just another blog about administration, linux and other stuff

mod-log-sql-mysql

Secure Apache 2 with mod-security 2 on Debian Lenny

This article describes how to install mod_security2 on Debian Lenny. It should work on Etch, too. On the http://www.modsecurity.org website there is a link to the mod_security2 pakets for Debian. (Community-Produced Binary packages) Note: You should check this website for the latest versions and change the example “wget” commands in this howto. 1. Download the […]

, , , , , , , , , ,

Log Apache2 access log into a MySQL database on Debian Lenny

This article describes how you can log your apache access log entries into a MySQL database. You need a installed and configurated Apache2 webserver and MySQL server. Installation: On the webserver: aptitude install libapache2-mod-log-sql-mysql a2enmod unique_id On the database server: Create a new database “apachelogs” and a user for this database. Configurate a virtual host: […]

, , , , , , , ,