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