[Mod_log_sql] module fails to load on Apache 2.0 under Yellow Dog Linux

Artur Jasowicz arturj_logsql at hoytpub.com
Thu Jan 27 11:32:20 EST 2005


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




More information about the Mod_log_sql mailing list