Problem with apache, php and mysql after FC4 upgrade: Segmentation Fault ...

[Mark Linford]

On Wed, 2005-06-15 at 12:14 -0700, Mark Linford wrote:
> Hi, everyone:
> 
> I just finished my upgrade to FC4 last night, and so far, everything's
> running smoothly, except for an issue with mysql and php ...
> 
> I'm having problems with certain php scripts causing apache to
> seg-fault. After a little debugging, I narrowed it down to the php
> function mysql_connect. Whenever the script hits that line, the
> web-server child dies. However, there's no php error, either on screen
> or in my php.log file. Only this error shows up in error_log:
> 
> [Wed Jun 15 11:40:41 2005] [notice] child pid 1877 exit signal
> Segmentation fault (11)
> 
> What's odd is that mysqld seems to be working fine since the upgrade. I
> can connect from the command line using the same username, password and
> queries I use in my php script with no problems.
> 
> Any Ideas? Anyone else having this problem?
> 
> 
> 
> Mark
> 
> 

Quick update: I've "fixed" the problem, but unfortunately my fix was to
do a clean install again, this time formatting all the partitions
except /home (previously, I didn't format my old /var partition). Right
now, I'm in the process of restoring my old databases from backup and
re-entering the privileges. So far, so good - no more Seg faults, and
all my mysql_queries work fine.

BTW, for those who are interested, I did open a bug-ticket with RedHat:
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=160691 . Maybe
there's an easier fix, but I couldn't wait for it. Moral of the story?
Maybe it's just always bite the bullet, and do a clean install when
upgrading :)

Mark