[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