[PHP-DB] php crashes with msyql
Hello, I have a mission critical problem that I cant seem to solve. Can anyone help?? I'll even offer $100 paypal if someone gives me the answer to solve this issue. Thanks, -N -- The issue: when I load a php file in a browser that references mysql, it crashes the apache thread. The clues: if I call the same php from the command line, it works perfectly! If I call a php file that doesn't use mysql, it works perfectly! The problem is only when calling a php file using mysql THROUGH A BROWSER. The environment slackware with kernel 2.6.11.8 php 5.1.2 apache 2.2.0 mysql 4.1.18 (pre-compiled downloaded from mysql.com) apache config command: ./configure --with-apr=/usr/local/apr-httpd/ --with-apr-util=/usr/ local/apr-util-httpd/ --enable-so --enab le-rewrite --disable-autoindex --enable-ssl --with-ssl=/usr/local/ssl php config command: './configure' '--with-apxs2=/usr/local/apache2/bin/apxs' '--with- mysql=/usr/local/mysql' '--with-mysql-sock=/tmp/mysql.sock' '--with- sqlite' '--enable-sqlite-utf8' '--with-zlib' '--with-zlib-dir' '-- with-bz2' '--with-gd' '--enable-gd' '--enable-gd-native-ttf' '--with- jpeg-dir=/usr/local' '--with-png-dir=/usr/local' '--with-ttf' '--with- curl=/usr/local' '--enable-track-vars' '--with-gettext' '--with- config-file-path=/usr/local/apache2/conf' '--enable-trans-id' '-- enable-ftp' '--enable-mbstring' '--with-openssl=/usr/local/ssl' -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php crashes with msyql
Chris, Thanks in advance for all the help. i appreciate it. The script - ?php mysql_connect('123.123.123.123','user','pass'); ? -- The error from apache log - [Tue Mar 21 15:36:05 2006] [notice] child pid 19337 exit signal Segmentation fault (11) - How I got here: I had an old copy of apache and php running (apache 2.0.? and php 4.3.5) I delete apache I configured, made, and installed apache (2.2.0) I configured, made, and installed php (4.4.2) The mysql being used is the pre-compiled one from mysql.com. I have used it on other servers and it works fine. I can provide an strace of the apache processing crashing if anyone is interested, Thanks On Mar 21, 2006, at 5:46 PM, Chris wrote: Noah Silverman wrote: Chris, Same problem Called from the command line it works. Called through a browser, it crashes. php test.php - WORKS http://server.com/test.php - CRASHES What exactly is in test.php (change database details, but we need to see the test.php script) ? Is it segfaulting (check the apache error logs) ? Did you re-compile php after updating mysql? Maybe there's a version difference in there somewhere, it's trying to load an older module. Does a phpinfo page show correct database version details? Please CC the list, others may have ideas I don't about what's going on. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] php crashes with msyql
Hello, I have a mission critical problem that I cant seem to solve. Can anyone help?? I'll even offer $100 paypal if someone gives me the answer to solve this issue. Thanks, -N -- The issue: when I load a php file in a browser that references mysql, it crashes the apache thread. The clues: if I call the same php from the command line, it works perfectly! If I call a php file that doesn't use mysql, it works perfectly! The problem is only when calling a php file using mysql THROUGH A BROWSER. The environment slackware with kernel 2.6.11.8 php 5.1.2 apache 2.2.0 mysql 4.1.18 (pre-compiled downloaded from mysql.com) apache config command: ./configure --with-apr=/usr/local/apr-httpd/ --with-apr-util=/usr/ local/apr-util-httpd/ --enable-so --enab le-rewrite --disable-autoindex --enable-ssl --with-ssl=/usr/local/ssl php config command: './configure' '--with-apxs2=/usr/local/apache2/bin/apxs' '--with- mysql=/usr/local/mysql' '--with-mysql-sock=/tmp/mysql.sock' '--with- sqlite' '--enable-sqlite-utf8' '--with-zlib' '--with-zlib-dir' '-- with-bz2' '--with-gd' '--enable-gd' '--enable-gd-native-ttf' '--with- jpeg-dir=/usr/local' '--with-png-dir=/usr/local' '--with-ttf' '--with- curl=/usr/local' '--enable-track-vars' '--with-gettext' '--with- config-file-path=/usr/local/apache2/conf' '--enable-trans-id' '-- enable-ftp' '--enable-mbstring' '--with-openssl=/usr/local/ssl' -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php