[Mod_log_sql] problem getting work mod_log_sql under gentoo with apache2

[Edward Rudd]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

blue-dragon wrote:
> 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/

you should be using
htttp://www.outoforder.cc/projects/apache/mod_log_sql/docs-2.0/ for the
current 1.100 release of mod_log_sql.

> 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.

insert and create rights on the database?

> 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

Everything looks fine.  *IS* LOG_SQL defined by the gentoo init script?
Also, add in a LogLevel debug in your main httpd.conf file (there may
already be one in there with LogLevel warn).
And start up apache and look at the error log for apache.  Then
include/attach the relevant portion of that log file so we can figure
out what is not working.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFEU2tevwMxRUUct20RAsO/AJ9u9Qm+wd3SFO4u/44d6Ej6uAGO9gCfYGY3
ggf1fH/kCWgnmdpmq25UEoo=
=8PGw
-----END PGP SIGNATURE-----