We have a winner! It turned out to be SELinux causing the trouble.
Thanks Joseph!
Eric W.
On Thu, 2007-04-05 at 09:24 -0400, Joseph Mesterhazy wrote:
> Hi Eric,
>
> First check if you have the php-mysql RPM installed. Next I would check
> to see if selinux is running, it's stricter than it was in RHEL 4
> (/etc/sysconfig/selinux). If selinux is running, temporarily turn it
> off, and see if that fixes the problem.
>
> Joe
>
> --
> Joe Mesterhazy
> UNIX Administrator, RHCE
> MSU Department of Radiology
> 133 Radiology Building
> (517) 355-0120 ext. 298
>
>
>
> -----Original Message-----
> From: MSU Network Administrators Group [mailto:[log in to unmask]] On
> Behalf Of Eric Weston
> Sent: Thursday, April 05, 2007 9:17 AM
> To: [log in to unmask]
> Subject: [MSUNAG] PHP5 question
>
> Hey all you LAMP developers -
>
> We just started upgrading our RHEL4 servers to RHEL5. RHEL5 is
> bundled with PHP5, and we discovered that when we upgraded, some PHP
> pages we were running broke. The problem is with the MySQL functions;
> They no longer connect to our MySQL database server. After Googling this
> problem, I learned that PHP5 no longer enables MySQL access by default,
> and I also read that the functions have been renamed. The renamed
> functions doesn't appear to be a problem for us, as the error messages
> we've encountered do not indicate unknown functions (I assume the RedHat
> implementation of PHP5 includes backward compatibility). We get messages
> such as:
>
> Warning: mysql_connect() [function.mysql-connect]: Can't connect to
> MySQL server on 'mysql.lib.msu.edu' (13)
>
> I was able to connect to our mysql server from the upgraded RHEL5 server
> with the mysql client, so the problem is definitely with PHP. All the
> "solutions" to this problem I found explain how to enable mysql library
> support by passing "--with-mysql" when you compile PHP5, but we didn't
> built PHP5; it comes bundled with RedHat.
>
> Any ideas?
--
^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V
Eric Weston, M.F.A.
Information Technology Professional
Michigan State University Libaries, Systems Unit
http://www.msu.edu/~westone
Friday the 13th falls on a Friday this month.
