System/Apache

openssl

Remove passphrase from key:

openssl rsa -in server.key -out server-nopass.key

Generate a self signed certificate in one step:

openssl req -new -newkey rsa:4096 -days 730 -nodes -x509 -subj "/C=US/ST=There/L=Town/O=Region/CN=my.domain.fr" -keyout my.domain.fr.key  -out my.domain.fr.cert

MySQL logging

Install the module

apt-get install libapache2-mod-log-sql-mysql

Create database and grant access to mysql user:

CREATE DATABASE apachelogs;
GRANT INSERT,CREATE ON apachelogs.* 
 TO apachelog@localhost 
 IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

In apache config, add the configuration for the module:

LogSQLLoginInfo mysql://apachelog:password@localhost/apachelogs
LogSQLCreateTables on
LogSQLDBParam socketfile /var/run/mysqld/mysqld.sock
LogSQLTransferLogFormat AabfHhmRSsTUuvI

In each Virtual Host, add this line:

LogSQLTransferLogTable table_name_for_this_vhost