I have upgraded mysql to 4.1.14, where the php-mysql installed with php is 3.23.58,
Now I am getting the following error while trying to install a php script:
Client does not support authentication protocol requested by server; consider upgrading MySQL client
How would i upgrade the mysql client for php?
Rebuild PHP 4.1.14 against the MySQL you have installed on the box and that should “fix” the error.
My php is 4.3.11
How would I do the rebuild?
just use the same ./configure that is on php.info?
yes, or you can use our SRPM and do a:
rpmbuild --rebuild --with rhe4x http://updates.interworx.com/iworx/SRPMS/php-4.3.11-100.iworx.src.rpm
Where rhe4x = RedHat Enterprise 4 or CentOS 4.
If you’re using a different distro you can use the following codes:
fdr10 = Fedora 1
fdr20 = Fedora 2
fdr30 = Fedora 3
cos3x = CentOS 3
After building the RPMs will be in /usr/src/redhat/RPMS/i386 and you can rpm -Uvh --force them to install.
php 4.3.11 + mysql 4.1.15
I have updated tye mysql to version 4.1.15, I rebuild the php-4.3.11-iworx.src.rpm but MyPhpAdmin still reports problem with mbstring.
The error is “The mbstring PHP extension was not found and you seem to be using a multibyte charset. Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.”.
What can I do from here ?
I’ve had the same ‘problem’ and just solved it with:
yum install php-mbstring
Reload phpmyadmin page and it won’t complain anymore
It’s the same when you need “imap” extension for PHP… yum install php-imap
These are the rpms i installed with --Uvh --force after rebuilding the php, after i have updated the mysql version to 4.1.15.
Anyway i can use phpmyadmin with no problem yet.
I was just wondering if I can get rid of the warning message.
Should I update the php version to a newer one ?
I think that’s up to you but the higher php versaions have backward ported features of php5 and will break many common scripts; make sure you do some research and know what you are doing first. In the case of php newer isn’t always better.
Make sure you restart httpd after installing mbstring voodookid. As juangake said all you need is the mbstring extension to get rid of the phpMyAdmin error.
And Tim is right about the PHP upgrade. I’d recommend sticking with 4.3.11.
Is there an wasy way to upgrade to PhP 4.4.2 and MySQL 4.1.15 without having InterWorx replacing it with the lower versions after we upgraded?
How do we get the new program versions to sync with InterWorx?
InterWorx-CP uses YUM as its update engine so as long as you version your RPMs for 4.4.2/4.1.5 correctly YUM won’t overwrite your installs. You could alternately edit the /etc/yum.conf and exclude php and mysql as updatable.