MySQL error after Ports upgrade

[Chris Janton]

On 2010-05-04 , at 03:34 , Craig Hoffman wrote:
> 
> I took this opportunity to upgrade to PHP 5.3 from 5.2.13 and perhaps learn a few things in the process.  Anyhow, the upgrade process ran fine.   PHP, MySQL and Apache came back online - all showing the correct versions.  All me PHP/MySQL sites work just fine.  PhpMyAdmin works.
> 
> Apache outputs this: 
>> Apache/2.2.15 (Unix) mod_ssl/2.2.15 OpenSSL/0.9.8n DAV/2 PHP/5.3.2 Server at localhost Port 80
> 
> Here's the really strange part, when I try to access a PHP script to show the install (<?php phpinfo(); ?>), Safari tells me  "Safari can’t open the page “http://localhost/~choffman/index.php” because the server unexpectedly dropped the connection. This sometimes occurs when the server is busy. Wait for a few minutes, and then try again."  Firefox wants to download the showphp.php (phpifo()) file.  Very odd.

OK - so if phpMyAdmin works what happens if you click on the link

	"Show PHP information"

that shows up on the right column of the main page? That runs the phpinfo() if you have configured it to do so.

What happens if you do

	php -i

from the command line?

Turn on full error reporting in PHP/Apache by making sure this is set in php.ini

	error_reporting = E_ALL

PHP 5.3 definitely causes some "amusement", depending on what/how your php is configured

face at mac:~:123 $ port installed *php*
The following ports are currently installed:
  php5 @5.3.2_0+apache2+darwin_10+macosx+pear (active)
  php5-apc @3.1.3p1_2 (active)
  php5-calendar @5.3.2_0 (active)
  php5-curl @5.3.2_0 (active)
  php5-dba @5.3.2_0 (active)
  php5-exif @5.3.2_0 (active)
  php5-ftp @5.3.2_0 (active)
  php5-gd @5.3.2_1 (active)
  php5-gearman @0.7.0_0 (active)
  php5-gettext @5.3.2_0 (active)
  php5-gmp @5.3.2_0 (active)
  php5-iconv @5.3.2_0 (active)
  php5-imagick @2.3.0_3 (active)
  php5-imap @5.3.2_0+macosx (active)
  php5-mbstring @5.3.2_0 (active)
  php5-mcrypt @5.3.2_0 (active)
  php5-memcache @2.2.5_3 (active)
  php5-mssql @5.3.2_0 (active)
  php5-mysql @5.3.2_0+mysqlnd (active)
  php5-odbc @5.3.2_0 (active)
  php5-openssl @5.3.2_0+macosx (active)
  php5-pcntl @5.3.2_0 (active)
  php5-posix @5.3.2_0 (active)
  php5-postgresql @5.3.2_0+postgresql84 (active)
  php5-pspell @5.3.2_0 (active)
  php5-soap @5.3.2_0 (active)
  php5-sockets @5.3.2_0 (active)
  php5-SPL_Types @0.3.0_0 (active)
  php5-sqlite @5.3.2_0 (active)
  php5-tidy @5.3.2_0 (active)
  php5-wddx @5.3.2_0 (active)
  php5-web @5.3.0_0 (active)
  php5-xmlrpc @5.3.2_0 (active)
  php5-xsl @5.3.2_0 (active)
  php5-zip @5.3.2_0 (active)

The following ports are currently installed:
  mysql5 @5.1.45_0
  mysql5 @5.1.46_0 (active)
  mysql5-server @5.1.45_0
  mysql5-server @5.1.46_0 (active)

8)
----------------------------------
Chris Janton  - face at CentosPrime dot COM
Netminder for Opus1.COM