MySQL error after Ports upgrade

[Craig Hoffman]

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.

Any ideas on what's going on? I have the same setup on a another Mac and it runs fine.  

Apache error log  reports this:
[Tue May 04 04:25:48 2010] [notice] child pid 911 exit signal Abort trap (6)
[Tue May 04 04:25:48 2010] [notice] child pid 910 exit signal Abort trap (6)
[Tue May 04 04:25:48 2010] [notice] child pid 909 exit signal Abort trap (6)
[Tue May 04 04:32:26 2010] [notice] child pid 917 exit signal Abort trap (6)
[Tue May 04 04:32:26 2010] [notice] child pid 916 exit signal Abort trap (6)
[Tue May 04 04:32:27 2010] [notice] child pid 959 exit signal Abort trap (6)
[Tue May 04 04:32:27 2010] [notice] child pid 918 exit signal Abort trap (6)

> What version of mysql are you running now?
mysql5 @5.1.46_0+universal (active)
mysql5-server @5.1.46_0 (active)

> What version were you running before?
mysql5 @5.1.45_0+universal
mysql5-server @5.1.45_0

> Has anything else changed?
Nothing.   I ran sudo port self update -> sudo port upgrade outdated  Macports updated MySQL to the latest version.  

> Did you run mysql_upgrade5?
I tried and it did not let me.  
_______________________
Craig Hoffman
iChat / AIM: mountain.dog
_______________________






On May 3, 2010, at 4:19 PM, Ryan Schmidt wrote:

> On May 3, 2010, at 12:09, Craig Hoffman wrote:
> 
>> I could use some help here.  I ran sudo port self update -> sudo port upgrade outdated  Macports updated MySQL to the latest version.  
>> 
>> 
>> I restarted my computer (went to work) and I received this error message:
>> 100503 11:04:20 mysqld_safe Starting mysqld daemon with databases from /opt/local/var/db/mysql5
>> 100503 11:04:20 mysqld_safe mysqld from pid file /opt/local/var/db/mysql5/Craig-Hoffmans-MacBook-Pro.local.pid ended
>> 
>> Any ideas?  Please help.
> 
> 
> I'm afraid the lines of the log you've shown don't really say what went wrong.
> 
> What version of mysql are you running now? What version were you running before? Has anything else changed? Did you run mysql_upgrade5?
> 
>