[Mod_log_sql] problem getting work mod_log_sql under gentoo with apache2

blue-dragon blue-dragon at tele2.it
Sat Apr 29 08:25:10 EDT 2006


Hello,
since 3 days i'm trying to set up od_log_sql with apache2 under
my gentoo machine.
i followed this documentation:
http://www.outoforder.cc/projects/apache/mod_log_sql/docs/
now i have a database with the 5 tables access_log, cookies, headers_in,
headers_out and notes.
The mysqluser "apache" has rights to use this tables.
But when i try to edit my http.conf i get always an error that the
syntax isn't correct.
So i set up my original http.conf and trie to get help in this mailing list.
my mod_log_sql is unter /etc/apache2/modules.d/ 42_mod_log_sql.conf
Here it is its content:
<IfDefine LOG_SQL>
        LoadModule log_sql_module        modules/mod_log_sql.so
        LoadModule log_sql_mysql_module  modules/mod_log_sql_mysql.so

        <IfModule mod_ssl.c>
                LoadModule log_sql_ssl_module modules/mod_log_sql_ssl.so
        </IfModule>
</IfDefine>

<IfModule mod_log_sql.c>
        LogSQLLoginInfo mysql://apache:apache@localhost/apache
        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
        <IfModule mod_ssl.c>
                LogSQLTransferLogFormat AbHhmRSsTUuv
        </IfModule>
</IfModule>

Can anyone help me??
Sorry for my weak english and greets to all over the world from italy
Max




More information about the Mod_log_sql mailing list