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.
