<IfDefine LOG_SQL>
LoadModule log_sql_module modules/mod_log_sql.so
LoadModule log_sql_mysql_module modules/mod_log_sql_mysql.so

<IfDefine SSL>
LoadModule log_sql_ssl_module modules/mod_log_sql_ssl.so
</IfDefine>

LogSQLLoginInfo mysql://user:passwd@host/database
LogSQLDBParam socketfile /var/run/mysqld/mysqld.sock

# LogSQLMassVirtualHosting automatically sets LogSQLCreateTables to 'on'
#LogSQLCreateTables on
LogSQLMassVirtualHosting on

LogSQLMachineID machine_id
LogSQLPreserveFile logs/mod_log_sql_preserve.sql

# See http://www.outoforder.cc/projects/apache/mod_log_sql/docs-2.0/
# for details about LogSQLTransferLogFormat
# be compatible with the Combined Log Format (CLF)
LogSQLTransferLogFormat AbHhmRSsTUuv
<IfDefine SSL>
LogSQLTransferLogFormat AbHhmRSsTUuv
</IfDefine>
</IfDefine>

# vim: ts=4 filetype=apache