Problems with the MySQL after PHP upgade

[X-Korpio]

Hi

I updated my VPS Plesk 7.5 with YUM:

mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i686) using readline 4.3
mysql-server-4.1.20-1.art.rhel3.art
libdbi-dbd-mysql-0.6.5-5
mysql-4.1.20-1.art.rhel3.art
mysql_passwd-0.7-2.swsoft
mysql-compat-4.1.20-1.art.rhel3.art
php-mysql-4.4.2-3.rhel3.art

The problem is that the MySQL stop working and the admins told me this:

Unfortunetly you are using an unsupported version of MySQL. Plesk does not make use of MySQL 4.1 on RHEL3. You will either need to downgrade your MySQL.

And when I use: # yum remove mysql

Is apears this:

I will do the following:
[erase: mysql 4.1.20-1.art.rhel3.art.i386]
I will erase these to satisfy the dependencies:
[deps: psa-agent 1.3.5-75050824.12.noarch]
[deps: DocFAQ 1.71-7508.noarch]
[deps: php-mysql 4.4.2-3.rhel3.art.i386]
[deps: psa-turba 2.0.3-rhel3.build75050824.12.noarch]
[deps: AutoIndex 1.5.3-7507.noarch]
[deps: SSHTerm 0.2.2-rhel3.build75050824.12.noarch]
[deps: psa-fileserver 1.0.0-rhel3.build75050824.12.i586]
[deps: CSLH 2.12.2-7504.noarch]
[deps: libdbi-dbd-mysql 0.6.5-5.i386]
[deps: mysql-server 4.1.20-1.art.rhel3.art.i386]
[deps: xrms 1.19-7504.noarch]
[deps: bbclone 0.48-7508.noarch]
[deps: psa-api-rpc 7.5.4-rhel3.build75050824.12.noarch]
[deps: phpMoney 1.3-7510.noarch]
[deps: phpWiki 1.3.11-7508.noarch]
[deps: phpsurveyor 0.98-7510.noarch]
[deps: psa-migration-manager 7.5.4-rhel3.build75050824.12.i586]
[deps: osCommerce 2.2ms2-7509.noarch]
[deps: perl-DBD-MySQL 2.1021-3.i386]
[deps: phpBugTracker 1.19-7506.noarch]
[deps: psa-api-common 7.5.4-rhel3.build75050824.12.noarch]
[deps: psa-vztune 1.0-1.swsoft.i386]
[deps: Mambo 4.5.2-7505.noarch]
[deps: PostNuke 0.750-7505.noarch]
[deps: psa-manual-custom-skin-guide 7.5.4-rhel3.build75050824.12.noarch]
[deps: psa-firewall 1.0.1-rhel3.build75050824.12.i586]
[deps: typo 3.8.0-7505.noarch]
[deps: mysql_passwd 0.7-2.swsoft.noarch]
[deps: phpBook 1.50-7507.noarch]
[deps: phpBB 2.0.17-7505.noarch]
[deps: psa-ingo 1.0.1-rhel3.build75050824.12.noarch]
[deps: psa-horde 3.0.5-rhel3.build75050824.12.noarch]
[deps: psa-bu 7.5.4-rhel3.build75050824.12.i586]
[deps: pLog 1.0-7508.noarch]
[deps: TUTOS 1.88-7504.noarch]
[deps: Tellme 1.2-7507.noarch]
[deps: psa-api-cli 7.5.4-rhel3.build75050824.12.noarch]
[deps: Coppermine 1.3.3-7515.noarch]
[deps: phpAds 2.0.5-7506.noarch]
[deps: phpDig 1.85-7505.noarch]
[deps: PPWSE 1.1-rhel3.build75050824.12.i586]
[deps: cs-gs 1.2.2-rhel3.build75050824.12.i586]
[deps: WebCalendar 1.0-7504.noarch]
[deps: psa-mnemo 2.0.1-rhel3.build75050824.12.noarch]
[deps: mysql-compat 4.1.20-1.art.rhel3.art.i386]
[deps: psa-vpn 1.0.0-rhel3.build75050824.12.i586]
[deps: WebShopmanager 2.0-7506.noarch]
[deps: psa-kronolith 2.0.3-rhel3.build75050824.12.noarch]
[deps: UebiMiau 2.7.8-7508.noarch]
[deps: psa-bf1942 1.0.0-rhel3.build75050824.12.i586]
[deps: psa-qmail-rblsmtpd 0.70-rhel3.build75050824.12.i586]
[deps: psa-tomcat-configurator 7.5.4-rhel3.build75050824.12.noarch]
[deps: openbiblio 0.5-7513.noarch]
[deps: phpMyFamily 1.4.1-7508.noarch]
[deps: psa 7.5.4-rhel3.build75050824.12.i586]
[deps: b2evolution 0.9.0.12-7505.noarch]
[deps: gallery 2.0-7516.noarch]
[deps: psa-watchdog 1.0.0-rhel3.build75050824.12.i586]
[deps: Owl 0.80-7507.noarch]
[deps: WordPress 1.5.1-7509.noarch]
[deps: AdvancedPoll 2.03-7505.noarch]
[deps: psa-imp 4.0.3-rhel3.build75050824.12.noarch]
[deps: psa-passwd 3.0-rhel3.build75050824.12.noarch]
[deps: gtchat 0.93-7507.noarch]

Is there a way to remove the just the MySQL without removing all other componets except for this:

mysql-server-4.1.20-1.art.rhel3.art
libdbi-dbd-mysql-0.6.5-5
mysql-4.1.20-1.art.rhel3.art
mysql_passwd-0.7-2.swsoft
mysql-compat-4.1.20-1.art.rhel3.art

And is there a way to install the MySQL 4.0.27 insted?

[breun]

I don't use RHEL3 myself, but I believe MySQL 4.1 works just fine with Reloaded. I use MySQL 4.1 with Plesk 7.5.4 on FC2, FC3 and CentOS 4. Since Scott has MySQL 4.1 rpms for RHEL3 I'd think that ought to work.

It seems like you have two MySQL install though. I'd get rid of 'mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i686) using readline 4.3'. I think that that might be ruining it for you. Just install the .art packages.

[X-Korpio]

I saw in a forum that this version is the most compatible one: MySQL 4.0.27 and I have this rpms:

MySQL-client-4.0.27-0.i386.rpm
MySQL-devel-4.0.27-0.i386.rpm
MySQL-server-4.0.27-0.i386.rpm

Is there a way to uninstall all other MySQL and install this ones?

[breun]

They don't look RHEL3 specific to me, but if you're sure they'll work you can run rpm -Uvh --oldpackage *.rpm in a directory where those rpms are located.

[scott]

Oh yeah definitely, "MySQL" labeled rpms are from the mysql.com folks.