You are viewing a plain text version of this content. The canonical link for it is here.
Posted to modperl@perl.apache.org by Sönke Ruempler <ru...@topconcepts.com> on 2004/11/16 09:58:17 UTC

Segfaults with mod_php + mod_perl + mysql + mysqli

Hi,

I asked the php-install and php-dev lists before - they didn't answer. 

I dunno if it's PHP and/or Perl related - so before I open a PHP Bug Report,
maybe here someone has an idea:

<<
Hi,

Because I upgraded my MySQL server to 4.1.7, I tried to compile my mod_php
with mysql + mysqli support. After some problems with double "-lmysqlclient"
in Makefile (found solution in bugs.php.net), the new mod_php compiled. But
after testing it with Apache, The webserver had segfaults and mod_perl error
messages:

[Fri Nov 12 08:41:30 2004] [notice] SIGHUP received.  Attempting to restart
[Fri Nov 12 08:41:31 2004] [notice] Digest: generating secret for digest
authentication ...
[Fri Nov 12 08:41:31 2004] [notice] Digest: done
[Fri Nov 12 08:41:31 2004] [notice] Apache/2.0.51 (Unix) mod_perl/1.99_16
Perl/v5.8.3 DAV/2 PHP/5.0.2 mod_ssl/2.0.51 OpenSSL/0.9.7d configured --
resuming no
Can't call STORE method on handle DBI::db=HASH(0x8f7aa84) after
take_imp_data() at
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBD/mysql.pm line 1
Can't call STORE method on handle DBI::db=HASH(0x8f7aa84) after
take_imp_data() at
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 642.
Can't call STORE method on handle DBI::db=HASH(0x8f7aa84) after
take_imp_data() at
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 642.
Can't call STORE method on handle DBI::db=HASH(0x8f7aa84) after
take_imp_data() at
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 645.
Can't call FETCH method on handle DBI::db=HASH(0x8f7aa84) after
take_imp_data() at
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 645.
Can't call STORE method on handle DBI::db=HASH(0x8f7aa84) after
take_imp_data() at
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 645.
Can't call FETCH method on handle DBI::db=HASH(0x8f7aa84) after
take_imp_data() at
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 645.
Can't call STORE method on handle DBI::db=HASH(0x8f7aa84) after
take_imp_data() at
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 645.
Can't call FETCH method on handle DBI::db=HASH(0x8f7aa84) after
take_imp_data() at
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 645.
Can't call connected method on handle DBI::db=HASH(0x8f7aa84) after
take_imp_data() at
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 650
Can't call STORE method on handle DBI::db=HASH(0x8f7aa84) after
take_imp_data() at
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 665.
Can't call prepare method on handle DBI::db=HASH(0x8f7aa84) after
take_imp_data() at /web/pm/CityMap/Abfragen.pm line 239.
[Fri Nov 12 08:41:33 2004] [error] Can't call method "execute" on an
undefined value at /web/pm/CityMap/Abfragen.pm line 247.\n
Can't call ping method on handle DBI::db=HASH(0x8f7aa84) after
take_imp_data() at /web/pm/CityMap/Abfragen.pm line 287.
Can't call ping method on handle DBI::db=HASH(0x8f7aa84) after
take_imp_data() at /usr/lib/perl5/site_perl/5.8.3/Apache/DBI.pm line 120.
[Fri Nov 12 08:41:34 2004] [notice] child pid 21593 exit signal Segmentation
fault (11)
[Fri Nov 12 08:41:35 2004] [notice] child pid 21594 exit signal Segmentation
fault (11)
[Fri Nov 12 08:41:35 2004] [notice] child pid 21609 exit signal Segmentation
fault (11)
[Fri Nov 12 08:41:35 2004] [notice] child pid 21612 exit signal Segmentation
fault (11)
Can't call STORE method on handle DBI::db=HASH(0x8f7f654) after
take_imp_data() at
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBD/mysql.pm line 1
Can't call STORE method on handle DBI::db=HASH(0x8f7f654) after
take_imp_data() at
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 642.
Can't call STORE method on handle DBI::db=HASH(0x8f7f654) after
take_imp_data() at
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 642.
Can't call STORE method on handle DBI::db=HASH(0x8f7f654) after
take_imp_data() at
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 645.
Can't call FETCH method on handle DBI::db=HASH(0x8f7f654) after
take_imp_data() at
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 645.
Can't call STORE method on handle DBI::db=HASH(0x8f7f654) after
take_imp_data() at
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 645.
Can't call FETCH method on handle DBI::db=HASH(0x8f7f654) after
take_imp_data() at
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 645.
Can't call STORE method on handle DBI::db=HASH(0x8f7f654) after
take_imp_data() at
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 645.
Can't call FETCH method on handle DBI::db=HASH(0x8f7f654) after
take_imp_data() at
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 645.
Can't call connected method on handle DBI::db=HASH(0x8f7f654) after
take_imp_data() at
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 650
Can't call STORE method on handle DBI::db=HASH(0x8f7f654) after
take_imp_data() at
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 665.
Can't call prepare method on handle DBI::db=HASH(0x8f7f654) after
take_imp_data() at xx.pm line 239.
[Fri Nov 12 08:41:35 2004] [error] Can't call method "execute" on an
undefined value at xx.pm line 247.\n
[Fri Nov 12 08:41:36 2004] [notice] child pid 21617 exit signal Segmentation
fault (11)
Can't call ping method on handle DBI::db=HASH(0x8f7f654) after
take_imp_data() at xx.pm line 287.
Can't call ping method on handle DBI::db=HASH(0x8f7f654) after
take_imp_data() at /usr/lib/perl5/site_perl/5.8.3/Apache/DBI.pm line 120.
[Fri Nov 12 08:41:37 2004] [notice] child pid 21616 exit signal Segmentation
fault (11)
[Fri Nov 12 08:41:40 2004] [notice] child pid 21599 exit signal Segmentation
fault (11)
[Fri Nov 12 08:41:46 2004] [notice] child pid 21611 exit signal Segmentation
fault (11)
[Fri Nov 12 08:41:55 2004] [notice] SIGHUP received.  Attempting to restart



I think there is a conflict between the mysql extensions of PHP and Perl.

Here is the Software:
Linux 2.6.8.1 #1 SMP Mon Sep 20 13:59:23 CEST 2004 i686 i686 i386 GNU/Linux
Apache  2.0.52
Perl 5.8.3
mod_perl 1.99
PHP 5.0.2
MySQL 4.1.7 libraries RPM from mysql.com

Any Ideas?
>>


--


Thx, Sönke.

-- 
Report problems: http://perl.apache.org/bugs/
Mail list info: http://perl.apache.org/maillist/modperl.html
List etiquette: http://perl.apache.org/maillist/email-etiquette.html


Re: Segfaults with mod_php + mod_perl + mysql + mysqli

Posted by Stas Bekman <st...@stason.org>.
jonathan vanasco wrote:
[...]
>> Because I upgraded my MySQL server to 4.1.7, I tried to compile my 
>> mod_php
>> with mysql + mysqli support. After some problems with double 
>> "-lmysqlclient"
>> in Makefile (found solution in bugs.php.net), the new mod_php 
>> compiled. But
>> after testing it with Apache, The webserver had segfaults and mod_perl 
>> error
>> messages:
>>
>> I think there is a conflict between the mysql extensions of PHP and Perl.
[...]
> Yep.  You're right.  I've run into this a few times.
> 
> If I remember right, its a problem stemming from library collisions -- 
> and there should be a bunch of info on google somwhere.
> 
> I don't remember what i did to get things to work, but a quick google 
> search just suggested that it might work  if you compile php without 
> mysql built in -- I dont believe php needs the mysql stuff compiled in 
> to use it, its just a speed issue.

Right. It's documented here:
http://perl.apache.org/docs/1.0/guide/troubleshooting.html#_exit_signal_Segmentation_fault__11___with_mysql

-- 
__________________________________________________________________
Stas Bekman            JAm_pH ------> Just Another mod_perl Hacker
http://stason.org/     mod_perl Guide ---> http://perl.apache.org
mailto:stas@stason.org http://use.perl.org http://apacheweek.com
http://modperlbook.org http://apache.org   http://ticketmaster.com

-- 
Report problems: http://perl.apache.org/bugs/
Mail list info: http://perl.apache.org/maillist/modperl.html
List etiquette: http://perl.apache.org/maillist/email-etiquette.html


Re: Segfaults with mod_php + mod_perl + mysql + mysqli

Posted by jonathan vanasco <jv...@mastersofbranding.com>.
On Nov 16, 2004, at 3:58 AM, Sönke Ruempler wrote:

> Hi,
>
> I asked the php-install and php-dev lists before - they didn't answer.
>
> I dunno if it's PHP and/or Perl related - so before I open a PHP Bug 
> Report,
> maybe here someone has an idea:
>
> <<
> Hi,
>
> Because I upgraded my MySQL server to 4.1.7, I tried to compile my 
> mod_php
> with mysql + mysqli support. After some problems with double 
> "-lmysqlclient"
> in Makefile (found solution in bugs.php.net), the new mod_php 
> compiled. But
> after testing it with Apache, The webserver had segfaults and mod_perl 
> error
> messages:
>
> I think there is a conflict between the mysql extensions of PHP and 
> Perl.
>
> Here is the Software:
> Linux 2.6.8.1 #1 SMP Mon Sep 20 13:59:23 CEST 2004 i686 i686 i386 
> GNU/Linux
> Apache  2.0.52
> Perl 5.8.3
> mod_perl 1.99
> PHP 5.0.2
> MySQL 4.1.7 libraries RPM from mysql.com
>
> Any Ideas?
>

Yep.  You're right.  I've run into this a few times.

If I remember right, its a problem stemming from library collisions -- 
and there should be a bunch of info on google somwhere.

I don't remember what i did to get things to work, but a quick google 
search just suggested that it might work  if you compile php without 
mysql built in -- I dont believe php needs the mysql stuff compiled in 
to use it, its just a speed issue.

-- 
Report problems: http://perl.apache.org/bugs/
Mail list info: http://perl.apache.org/maillist/modperl.html
List etiquette: http://perl.apache.org/maillist/email-etiquette.html