I have just upgraded PHP on my Plesk 7.0 server - I've also just discovered that I did this the wrong way (using yum) and it seems to have thrown a few things out.
In particular, any PHP pages with a MySQL connection aren't working any more. I don't get an error message, in fact I don't get anything other than a blank page.
MySQL itself is fine - I can log in from the command line, and I can also access it from the Plesk control panel and everything seems fine.
I'm not even sure where to start looking for a solution to this problem - does anybody have any suggestions?
Thanks,
Dan Sumption
Full Version: PHP upgrade has broken MySQL in PHP
BTW I have looked in the error log for the sites in question, and also in /var/log/httpd/error_log and I can't see any errors listed that relate to this.
Hi,
Is it possible that you are experiencing issues with authentication?
http://dev.mysql.com/doc/refman/5.0/en/pas...rd-hashing.html
I know that you have upgraded php only and not mysql, but perhaps the php you have installed (be it rpm or tgz) has defaulted to using the new hashing algorithm.
check out php.ini
da!!as
Is it possible that you are experiencing issues with authentication?
http://dev.mysql.com/doc/refman/5.0/en/pas...rd-hashing.html
I know that you have upgraded php only and not mysql, but perhaps the php you have installed (be it rpm or tgz) has defaulted to using the new hashing algorithm.
check out php.ini
da!!as
make sure php-mysql is installed
if not yum install php-mysql
Then restart apache.
if not yum install php-mysql
Then restart apache.
QUOTE (dansumption)
I have just upgraded PHP on my Plesk 7.0 server - I've also just discovered that I did this the wrong way (using yum) and it seems to have thrown a few things out.
In particular, any PHP pages with a MySQL connection aren't working any more. I don't get an error message, in fact I don't get anything other than a blank page.
MySQL itself is fine - I can log in from the command line, and I can also access it from the Plesk control panel and everything seems fine.
I'm not even sure where to start looking for a solution to this problem - does anybody have any suggestions?
Thanks,
Dan Sumption
In particular, any PHP pages with a MySQL connection aren't working any more. I don't get an error message, in fact I don't get anything other than a blank page.
MySQL itself is fine - I can log in from the command line, and I can also access it from the Plesk control panel and everything seems fine.
I'm not even sure where to start looking for a solution to this problem - does anybody have any suggestions?
Thanks,
Dan Sumption
What version of mysql and PHP have you just put in?
What happens when you close mysql and start again? Does it appear to hang on restart?
Same thing happend to me when installing new PHP, expat & sablotron (for xslt) on a raq yesterday. I did not touch mysql which was ok.
I am trying to make a fix now, Some mysql is functioning fine, some is not. PHPBB is running fine, some info from some tables is fine, some session info is lost, calls to mysql on same page, the second seems unwilling to work.
I am looking at the php info and mysql files.
When I try to start after stopping, I dont get a started message,
I get a msg :-
/usr/bin/safe_mysqld: 5: command not found
Starting mysqld daemon with databases from /var/lib/mysql
and it appears to hang with no command prompt
But
ps aux|grep mysql
reveals its there kicking away.:confused:
I wonder if it is PHP or MySQL...
J.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.