[Mod_log_sql] problem getting work mod_log_sql under gentoo with apache2

blue-dragon blue-dragon at tele2.it
Tue May 2 09:23:09 EDT 2006


Hi,

is there noone who can help me?

Max
> 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
>>
>>   
>
> _______________________________________________
> 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
>




More information about the Mod_log_sql mailing list