10_mod_log_sql.conf:

<IfDefine LOG_SQL>

    # Load the module first
    <IfModule !mod_log_sql.c>
        LoadModule log_sql_module        extramodules/mod_log_sql.so
        LoadModule log_sql_mysql_module  extramodules/mod_log_sql_mysql.so
#        <IfModule mod_ssl.c>
#            LoadModule log_sql_ssl_module  extramodules/mod_log_sql_ssl.so
#        </IfModule>

        AddModule mod_log_sql.c
#        <IfModule mod_ssl.c>
#            AddModule mod_log_sql_ssl.c
#        </IfModule>

    </IfModule>

    <IfModule mod_log_sql.c>

        # Change this with valid values for your setup (currently only mysql driver)!
        # Format:  LogSQLLoginInfo driver://username[:password]@hostname[:port]/database
        LogSQLLoginInfo mysql://loguser:l0gg3r@localhost/apachelogs

        LogSQLDBParam socketfile /var/run/mysqld/mysqld.sock

        LogSQLMachineID machine_id
        LogSQLPreserveFile /var/log/apache/mod_slog_sql_preserve.sql

        # LogSQLMassVirtualHosting automatically sets LogSQLCreateTables to 'On'
        LogSQLMassVirtualHosting On
        # LogSQLCreateTables On

        # with cookie add a "c"
        # with SSL add "Qqz"
        # with mod_usertrack add "I"
        LogSQLTransferLogFormat AabfHhMmPpRrSsTtUuv
        <IfModule mod_ssl.c>
            LogSQLTransferLogFormat AabfHhMmPpRrSsTtUuvQqz
        </IfModule>

    </IfModule>
</IfDefine>




10_mod_log_sql_apache2.conf:

<IfDefine LOG_SQL>

    # Load the module first
    <IfModule !mod_log_sql.c>
        LoadModule log_sql_module        extramodules/mod_log_sql.so
        LoadModule log_sql_mysql_module  extramodules/mod_log_sql_mysql.so
#        <IfModule mod_ssl.c>
#            LoadModule log_sql_ssl_module  extramodules/mod_log_sql_ssl.so
#        </IfModule>

    </IfModule>

    <IfModule mod_log_sql.c>

        # Change this with valid values for your setup (currently only mysql driver)!
        # Format:  LogSQLLoginInfo driver://username[:password]@hostname[:port]/database
        LogSQLLoginInfo mysql://loguser:l0gg3r@localhost/apachelogs

        LogSQLDBParam socketfile /var/run/mysqld/mysqld.sock

        LogSQLMachineID machine_id
        LogSQLPreserveFile /var/log/apache2/mod_slog_sql_preserve.sql

        # LogSQLMassVirtualHosting automatically sets LogSQLCreateTables to 'On'
        LogSQLMassVirtualHosting On
        # LogSQLCreateTables On

        # with cookie add a "c"
        # with SSL add "Qqz"
        # with mod_usertrack add "I"
        LogSQLTransferLogFormat AabfHhMmPpRrSsTtUuv
        <IfModule mod_ssl.c>
            LogSQLTransferLogFormat AabfHhMmPpRrSsTtUuvQqz
        </IfModule>

    </IfModule>
</IfDefine>