[Mod_log_sql] module fails to load on Apache 2.0 under Yellow Dog Linux
Shawn Michael
smichael at rightnow.com
Thu Jan 27 11:47:10 EST 2005
Make sure that the mysql libraries you are compiling against are also shared
libraries instead of static. I encountered a similiar problem compiling the
Python MySQLdb module for x86_64. The static mysql libraries were not compiled
with -fPIC so I couldn't include them in the shared object code for MySQLdb. The
fix for me was to install the .so files for MySQL.
Artur Jasowicz wrote:
> This particular time I did "apachectl graceful", but I also use
> "/etc/init.d/httpd restart" (yes, I know, I should use "service httpd
> restart" instead). Each time after I try to start apache with
> mod_log_sql enabled, it fails, so after that it is a full cold start.
>
> Apparently, there is a problem with symbol relocation on PowerPC
> platform. That is why -fPIC has to be used, but in this particular case
> it does not seem to prevent relocation. Same code compiled on an old
> Pentium box under Fedora 2 works just fine.
>
> One other thing I noticed: mod_log_sql.so seems to load fine, it is
> mod_log_sql_mysql.so that fails to load. What might be different about
> the two? Perhaps it is code within some library included in
> mod_log_sql_mysql that was compiled without -fPIC and is causing this?
> Again, I am not experienced enough to really know what I'm talking
> about, so please go easy on me if this doesn't make sense :) How can I
> check what symbol within what library the error message refers to given
> it's address?
>
> Artur
>
> On Jan 26, 2005, at 6:03 PM, Shawn Michael wrote:
>
>> Are you doing an apachectl restart or apachectl stop && apachectl
>> start ??
>>
>> There's a difference between the two operations. A restart command
>> doesn't actually shut apache down it just gives it a special signal
>> and the parent process respawns all of it's children.
>>
>> Artur Jasowicz wrote:
>>
>>> So, I did a bit of research on R_PPC_REL24 and discovered that
>>> recompiling with -lc and -fPIC or -fpic should solve the problem. It
>>> did not. What seems strange is that the symbol name is not given.
>>> Could this message be triggered by something else actually? I am only
>>> a programmer wannabe and really don't have the experience to launch
>>> gdb and see what's going on...
>>> Still hoping to hear from someone here.
>>> Artur
>>> On Jan 21, 2005, at 1:04 PM, Artur Jasowicz wrote:
>>>
>>>> When trying to restart httpd to activate mod_log_sql modules I get
>>>> following error:
>>>>
>>>> [Fri Jan 21 12:31:07 2005] [notice] Graceful restart requested,
>>>> doing restart
>>>> Syntax error on line 213 of /etc/httpd/conf/httpd.conf:
>>>> Cannot load /etc/httpd/modules/mod_log_sql_mysql.so into server:
>>>> /etc/httpd/modules/mod_log_sql_mysql.so: R_PPC_REL24 relocation at
>>>> 0x0c16f08c for symbol `' out of range
>>>> Syntax error on line 213 of /etc/httpd/conf/httpd.conf:
>>>> Cannot load /etc/httpd/modules/mod_log_sql_mysql.so into server:
>>>> /etc/httpd/modules/mod_log_sql_mysql.so: R_PPC_REL24 relocation at
>>>> 0x0d34e08c for symbol `' out of range
>>>>
>>>> Yellow Dog Linux 3.0 (practically port of RedHat 8 or 9 for PowerPC
>>>> platform) running Apache/2.0.40
>>>>
>>>> The module compiled and installed clean. apachectl -t says "OK"
>>>>
>>>> What should I try to solve this?
>>>>
>>>> Regards,
>>>>
>>>> Artur
>>>>
>>>> _______________________________________________
>>>> 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
>>
>>
>> --
>> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>> Shawn Michael smichael at rightnow.com
>> RightNow Technologies Hosting Administrator
>> A Better Way to Serve your Customers
>> _______________________________________________
>> 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
>
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Shawn Michael smichael at rightnow.com
RightNow Technologies Hosting Administrator
A Better Way to Serve your Customers
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3202 bytes
Desc: S/MIME Cryptographic Signature
Url : http://lists.outoforder.cc/pipermail/mod_log_sql/attachments/20050127/2e1f27d7/attachment.bin
More information about the Mod_log_sql
mailing list