Pages with MySQL - Page Cannot Be Displayed

[freebie]

After ugrading PHP, I get errors on all pages that make calls to MySQL that "Page Cannot Be Displayed".
My first question is why doesn't it display the page and show the error on the page.
My second question is if anyone thinks there's something not configured (relating to Mysql). Here is the configuration info from the MySQL portion of the phpinfo() printout

MySQL Support enabled
Active Persistent Links 0

Active Links 0

Client API version 3.23.58

MYSQL_MODULE_TYPE external

MYSQL_SOCKET /var/lib/mysql/mysql.sock

MYSQL_INCLUDE -I/usr/include/mysql

MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient

Directive Local Value Master Value
mysql.allow_persistent On On
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited

-- Additional information:
I'm running on RedHat Linux 9
MySQL (and previous install of apache and php) were all installed from RPMs)
I've installed Apache 2.0.48 from source.
I've installed PHP4.3.4 from source - as apache module
MySQL is running as a background process, and I can interact with it from the client command line utility.

-- I'm thinking about re-installing MySQL from the source-code, but really don't want to go through all that if there is something else causing the problem

Thank you for any suggestions,

Jeff

[Moonglobe]

never tried the RPM, but just the binary distros worked for me on slackware 9.1.... the sources are a bit wierd, but the binaries should work. there's an install script so it's not that hard, it'll take you 5 minutes + download times

hth
moon

[freebie]

After upgrading mysql (using mysql linux binaries) and then recompiling PHP, The page now displays, however, it still can't connect because the mysql.sock file it is looking for is "/tmp/mysql.sock", but the actual file is in "/var/lib/mysql/mysql.sock".

Can someone clue me in as to how I tell it correct path to the mysql.sock file.

Thank you for any suggestions.

Jeff

[Moonglobe]

if you look carfully at your fist pot you'll see there's a directive called "mysql.default_socket".... try that 😉

[freebie]

I just created a symbolic link and that worked for the mysql.sock problem

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

Thanks for the info Moonglobe on the defaultSocket. I'll go ahead and set that in my php.ini file as well.

[Moonglobe]

dunno if there'd be problems with that but if it floats for you why bother? glad you're up and running.