[Mod_log_sql] problem getting work mod_log_sql under gentoo with apache2

[blue-dragon]

Hi,
here I am again,
i think now i know whats the error by take a look at the startuperror 
log from apache.
The error is by trying to load the module;
i tried two diferent versions witch i found on some internet sites:
here are the two versions with the errors i become:

LoadModule log_sql_mysql_module         modules/mod_log_sql_mysql.so

Cannot load /usr/lib/apache2/modules/mod_log_sql_mysql.so into server: 
/usr/lib/apache2/modules/mod_log_sql_mysql.so: undefined symbol: 
log_sql_register_driver

LoadModule sql_log_module               libexec/mod_log_sql.so

Cannot load /usr/lib/apache2/libexec/mod_log_sql.so into server: 
/usr/lib/apache2/libexec/mod_log_sql.so: cannot open shared object file: 
No such file or directory

Can anybody help my?
I think its an very easy error but i never tried to use a module or 
configure my apache so i dont understand wats going wrong


Max




Edward Rudd schrieb:
> -----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-----
> _______________________________________________
> Download the latest version at http://www.outoforder.cc/projects/apache/mod_log_sql/
>
> To unsubscribe send an e-mail to 
> mod_log_sql-unsubscribe at lists.outoforder.cc
>
>