[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