Page 1 of 2
Problem updating MySQL on my FC3/Plesk 7.5 box
Posted: Thu Jun 29, 2006 5:38 am
by hansdezwart
I am trying to get MySQL to a version higher than 4.16. Currently it is at 3.23.
The operating system is Fedora Core 3 with a Plesk 7.5 installation on top of it.
I have the following yum.conf file:
Code: Select all
# THIS CHANNEL CONTAINS MY PSA COMPATIBLE RPMS (php, mysql, qmail-scanner, etc)
[atomic]
name=Atomic Rocket Turtle - $releasever - Atomic PSA-Compatible RPMS
baseurl=http://3es.atomicrocketturtle.com/atomic/art/$releasever/
gpgcheck=0
[atomic-app-vault]
name=Atomic Rocket Turtle - $releasever - Atomic PSA App Vault RPMS
baseurl=http://3es.atomicrocketturtle.com/atomic/app-vault/
gpgcheck=0
[psa-7.5]
name=Atomic Rocket Turtle - $releasever - SW-Soft PSA 7.5 RPMS
baseurl=http://3es.atomicrocketturtle.com/atomic/psa-7.5/$releasever/
gpgcheck=0
# Update mirrors for Fedora, Fedoralegacy, and CentOS 3/4
[base]
name=Atomic Rocket Turtle - $releasever - Base OS RPMS mirror
baseurl=http://3es.atomicrocketturtle.com/3rd-party/base/$releasever/
gpgcheck=0
[updates]
name=Atomic Rocket Turtle - $releasever - OS Update RPMS mirror
baseurl=http://3es.atomicrocketturtle.com/3rd-party/updates/$releasever/
gpgcheck=0
When I run
as root I get the following output:
Code: Select all
Repository base already added, not adding again
Setting up Install Process
Setting up Repo: psa-7.5
repomd.xml 100% |=========================| 951 B 00:00
Setting up Repo: base
repomd.xml 100% |=========================| 951 B 00:00
Setting up Repo: atomic
repomd.xml 100% |=========================| 951 B 00:00
Setting up Repo: updates-released
repomd.xml 100% |=========================| 951 B 00:00
Setting up Repo: atomic-app-vault
repomd.xml 100% |=========================| 951 B 00:00
Setting up Repo: updates
repomd.xml 100% |=========================| 951 B 00:00
Reading repository metadata in from local files
psa-7.5 : ################################################## 133/133
primary.xml.gz 100% |=========================| 566 kB 00:01
MD Read : ################################################## 1652/1652
base : ################################################## 1652/1652
atomic : ################################################## 196/196
updates-re: ################################################## 910/910
atomic-app: ################################################## 6/6
primary.xml.gz 100% |=========================| 316 kB 00:00
MD Read : ################################################## 780/780
updates : ################################################## 780/780
Reading repository metadata in from local files
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package mysql.i386 0:4.1.20-1.art.rhfc3.art set to be updated
--> Running transaction check
--> Processing Dependency: libmysqlclient.so.10 for package: perl-DBD-MySQL
--> Processing Dependency: mysql= 3.23.58 for package: mysql-server
--> Processing Dependency: libmysqlclient.so.10 for package: sitebuilder-core
--> Processing Dependency: libmysqlclient.so.10 for package: mysql-server
--> Processing Dependency: libmysqlclient.so.10 for package: php-mysql
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package mysql.i386 0:3.23.58-16.FC3.1 set to be updated
---> Package mysql-server.i386 0:4.1.20-1.art.rhfc3.art set to be updated
---> Package sitebuilder-core.i386 0:1.0-fc3.build051222.05 set to be updated
---> Package php-mysql.i386 0:4.4.2-3.rhfc3.art set to be updated
--> Running transaction check
--> Processing Dependency: php= 4.4.2-3.rhfc3.art for package: php-mysql
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package php.i386 0:4.4.2-3.rhfc3.art set to be updated
--> Running transaction check
--> Processing Dependency: php= 4.3.9-3 for package: php-ldap
--> Processing Dependency: php= 4.3.9-3 for package: php-pear
--> Processing Dependency: php= 4.3.9-3 for package: php-domxml
--> Processing Dependency: php= 4.3.9-3 for package: php-pgsql
--> Processing Dependency: php-mbstring= 4.4.2-3.rhfc3.art for package: php
--> Processing Dependency: php= 4.3.9-3 for package: php-imap
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package php-ldap.i386 0:4.4.2-3.rhfc3.art set to be updated
---> Package php-pear.i386 0:4.4.2-3.rhfc3.art set to be updated
---> Package php-domxml.i386 0:4.4.2-3.rhfc3.art set to be updated
---> Package php-pgsql.i386 0:4.4.2-3.rhfc3.art set to be updated
---> Package php-mbstring.i386 0:4.4.2-3.rhfc3.art set to be installed
---> Package php-imap.i386 0:4.4.2-3.rhfc3.art set to be updated
--> Running transaction check
Dependencies Resolved
Transaction Listing:
Update: mysql.i386 0:4.1.20-1.art.rhfc3.art
Performing the following to resolve dependencies:
Install: php-mbstring.i386 0:4.4.2-3.rhfc3.art
Update: mysql.i386 0:3.23.58-16.FC3.1
Update: mysql-server.i386 0:4.1.20-1.art.rhfc3.art
Update: php.i386 0:4.4.2-3.rhfc3.art
Update: php-domxml.i386 0:4.4.2-3.rhfc3.art
Update: php-imap.i386 0:4.4.2-3.rhfc3.art
Update: php-ldap.i386 0:4.4.2-3.rhfc3.art
Update: php-mysql.i386 0:4.4.2-3.rhfc3.art
Update: php-pear.i386 0:4.4.2-3.rhfc3.art
Update: php-pgsql.i386 0:4.4.2-3.rhfc3.art
Update: sitebuilder-core.i386 0:1.0-fc3.build051222.05
Is this ok [y/N]:
I say it is okay and then I get the following output:
Code: Select all
Downloading Packages:
warning: rpmts_HdrFromFdno: V3 DSA signature: NOKEY, key ID 4f2a6fd2
public key not available for ///var/cache/yum/updates-released/packages/mysql-3.23.58-16.FC3.1.i386.rpm
Can somebody please help me? I have installed the GPG key so that should not be the problem.
Posted: Thu Jun 29, 2006 6:12 am
by scott
you need the fedoralegacy.org GPG key
Posted: Thu Jun 29, 2006 6:49 am
by hansdezwart
I have done:
Code: Select all
rpm --import http://www.fedoralegacy.org/FEDORA-LEGACY-GPG-KEY
That seems to work fine. I get no errors, just the prompt back.
The problem however stays identical!
Posted: Thu Jun 29, 2006 7:03 am
by scott
you might need the fedora key then (have you ever updated the box?), which is in /usr/share/doc/fedora-release-3/
Posted: Thu Jun 29, 2006 7:03 am
by scott
you might need the fedora key then (have you ever updated the box?), which is in /usr/share/doc/fedora-release-3/
Posted: Thu Jun 29, 2006 7:11 am
by hansdezwart
That seems to have helped. However now I get:
Code: Select all
Downloading Packages:
Running Transaction Test
Finished Transaction Test
Transaction Check Error: file /usr/bin/mysql conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/bin/mysql_config conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/bin/mysql_find_rows conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/bin/mysqlaccess conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/bin/mysqlbinlog conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/bin/mysqlcheck conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/bin/mysqldump conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/bin/mysqldumpslow conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/bin/mysqlimport conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/bin/mysqlshow conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/lib/mysql/mysql_config conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/lib/mysql/mysqlbug conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/info/mysql.info.gz conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/man/man1/mysql.1.gz conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/man/man1/mysqlaccess.1.gz conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/man/man1/mysqladmin.1.gz conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/man/man1/mysqldump.1.gz conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/man/man1/mysqlshow.1.gz conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/czech/errmsg.sys conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/czech/errmsg.txt conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/danish/errmsg.sys conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/danish/errmsg.txt conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/dutch/errmsg.sys conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/dutch/errmsg.txt conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/english/errmsg.sys conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/english/errmsg.txt conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/estonian/errmsg.sys conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/estonian/errmsg.txt conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/french/errmsg.sys conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/french/errmsg.txt conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/german/errmsg.sys conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/german/errmsg.txt conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/greek/errmsg.sys conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/greek/errmsg.txt conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/hungarian/errmsg.sys conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/hungarian/errmsg.txt conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/italian/errmsg.sys conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/italian/errmsg.txt conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/japanese/errmsg.sys conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/japanese/errmsg.txt conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/korean/errmsg.sys conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/korean/errmsg.txt conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/norwegian-ny/errmsg.sys conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/norwegian-ny/errmsg.txt conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/norwegian/errmsg.sys conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/norwegian/errmsg.txt conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/polish/errmsg.sys conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/polish/errmsg.txt conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/portuguese/errmsg.sys conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/portuguese/errmsg.txt conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/romanian/errmsg.sys conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/romanian/errmsg.txt conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/russian/errmsg.sys conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/russian/errmsg.txt conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/slovak/errmsg.sys conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/slovak/errmsg.txt conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/spanish/errmsg.sys conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/spanish/errmsg.txt conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/swedish/errmsg.sys conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/swedish/errmsg.txt conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/ukrainian/errmsg.sys conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/share/mysql/ukrainian/errmsg.txt conflicts between attempted installs of mysql-3.23.58-16.FC3.1 and mysql-4.1.20-1.art.rhfc3.art
file /usr/bin/isamchk conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/bin/isamlog conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/bin/my_print_defaults conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/bin/myisamchk conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/bin/myisamlog conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/bin/myisampack conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/bin/mysql_fix_privilege_tables conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/bin/mysql_install_db conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/bin/mysql_setpermission conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/bin/mysql_zap conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/bin/mysqlbug conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/bin/mysqld_multi conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/bin/mysqlhotcopy conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/bin/mysqltest conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/bin/pack_isam conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/bin/perror conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/bin/replace conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/bin/resolve_stack_dump conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/bin/resolveip conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/share/man/man1/isamchk.1.gz conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/share/man/man1/isamlog.1.gz conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/share/man/man1/mysql_zap.1.gz conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/share/man/man1/mysqld.1.gz conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/share/man/man1/mysqld_multi.1.gz conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/share/man/man1/perror.1.gz conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/share/man/man1/replace.1.gz conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
file /usr/share/man/man1/safe_mysqld.1.gz conflicts between attempted installs of mysql-server-4.1.20-1.art.rhfc3.art and mysql-3.23.58-16.FC3.1
Posted: Thu Jun 29, 2006 7:16 am
by scott
you got that from "yum update"?
Posted: Thu Jun 29, 2006 7:23 am
by hansdezwart
I got it from:
and then a yes
Posted: Thu Jun 29, 2006 9:40 am
by breun
Seems like you have multiple (partial) mysql installs. What does rpm -qa | grep -i mysql say?
Posted: Thu Jun 29, 2006 4:55 pm
by hansdezwart
When I run that command, I get the following:
Code: Select all
rpm -qa | grep -i mysql
perl-DBD-MySQL-2.9003-5
mysql-server-3.23.58-13
mysql-3.23.58-13
php-mysql-4.3.9-3
Thank you very much for putting so much effort in helping me by the way!
Still stumped
Posted: Sun Jul 02, 2006 12:08 pm
by hansdezwart
I have still not managed to resolve this issue. I am not sure what to do. Should I reinstall the operating system (which if fairly easy) and try again?
Posted: Tue Jul 11, 2006 7:37 am
by stevenb
Did you solve this as i have the same problem now as well on a clean install.
MySQL and Plesk problem still not solved
Posted: Tue Jul 11, 2006 3:17 pm
by hansdezwart
I am affraid to say I have not solved the problem...
I will try again in the middle of August, unless anybody else has an idea?
Posted: Tue Jul 11, 2006 3:54 pm
by scott
That shouldn't happen, I suspect something is seriously wrong with your box. RPM db corruption, something you've done to a config, etc. What thats saying is that the updated rpm, and the already installed rpm, are not the same package, which shouldn't happen, since they are using the same name. If you need more assistance, we do commercial support, contact
support@atomicorp.com
Posted: Tue Jul 11, 2006 4:01 pm
by stevenb
I solved it by reinstalling the OS there must have been some problem somewhere as it was a brandnew box only hours old and that was the first thing i tried to install.
It is a fedora 3 core with Plesk which i know can cause some problems. But an OS reinstall solved it.