New Centos 4.5 server, trying to upgrade mysql

henningl · Unread post by **henningl** » Wed Jul 25, 2007 9:18 pm

Managed to upgrade PHP according to the wiki without problems, but MySQL won't update from 4.1.20 ?

This is what I get:

Code: Select all


[root@ng ~]# yum update mysql
Setting up Update Process
Setting up repositories
Reading repository metadata in from local files
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package mysql.x86_64 0:5.0.27-1.el4.art set to be updated
--> Running transaction check
--> Processing Dependency: libmysqlclient.so.14()(64bit) for package: php5sb
--> Processing Dependency: libmysqlclient.so.14(libmysqlclient_14)(64bit) for package: psa-ruby-mysql
--> Processing Dependency: libmysqlclient.so.14()(64bit) for package: psa-ruby-mysql
--> Processing Dependency: libmysqlclient.so.14(libmysqlclient_14)(64bit) for package: mysql-server
--> Processing Dependency: libmysqlclient.so.14()(64bit) for package: psa-qmail
--> Processing Dependency: libmysqlclient.so.14()(64bit) for package: php-mysql
--> Processing Dependency: libmysqlclient.so.14()(64bit) for package: psa
--> Processing Dependency: libmysqlclient.so.14(libmysqlclient_14)(64bit) for package: psa-qmail
--> Processing Dependency: libmysqlclient.so.14()(64bit) for package: mysql-server
--> Processing Dependency: libmysqlclient.so.14(libmysqlclient_14)(64bit) for package: psa
--> Processing Dependency: libmysqlclient.so.14()(64bit) for package: perl-DBD-MySQL
--> Processing Dependency: libmysqlclient_r.so.14(libmysqlclient_14)(64bit) for package: mysql-server
--> Processing Dependency: libmysqlclient_r.so.14()(64bit) for package: mysql-server
--> Processing Dependency: libmysqlclient.so.14()(64bit) for package: psa-courier-imap-add
--> Processing Dependency: libmysqlclient.so.14(libmysqlclient_14)(64bit) for package: psa-courier-imap-add
--> Processing Dependency: libmysqlclient.so.14(libmysqlclient_14)(64bit) for package: php-mysql
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package mysqlclient14.x86_64 0:4.1.22-2.el4.art set to be updated
---> Package mysql-server.x86_64 0:5.0.27-1.el4.art set to be updated
--> Running transaction check

Dependencies Resolved

=============================================================================
 Package                 Arch       Version          Repository        Size
=============================================================================
Updating:
 mysql                   x86_64     5.0.27-1.el4.art  atomic            4.0 M
Installing for dependencies:
 mysqlclient14           x86_64     4.1.22-2.el4.art  atomic            1.8 M
Updating for dependencies:
 mysql-server            x86_64     5.0.27-1.el4.art  atomic             11 M


Transaction Summary
=============================================================================
Install      1 Package(s)
Update       2 Package(s)
Remove       0 Package(s)
Total download size: 16 M
Is this ok [y/N]: y
Downloading Packages:
Running Transaction Test
Finished Transaction Test



Transaction Check Error:   file /etc/my.cnf from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/bin/mysql_tableinfo from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/info/mysql.info.gz from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/man/man1/mysql.1.gz from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/man/man1/mysqlaccess.1.gz from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/man/man1/mysqladmin.1.gz from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/man/man1/mysqldump.1.gz from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/man/man1/mysqlshow.1.gz from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/charsets/Index.xml from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/czech/errmsg.sys from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/danish/errmsg.sys from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/dutch/errmsg.sys from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/english/errmsg.sys from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/estonian/errmsg.sys from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/french/errmsg.sys from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/german/errmsg.sys from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/greek/errmsg.sys from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/hungarian/errmsg.sys from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/italian/errmsg.sys from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/japanese/errmsg.sys from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/korean/errmsg.sys from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/norwegian-ny/errmsg.sys from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/norwegian/errmsg.sys from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/polish/errmsg.sys from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/portuguese/errmsg.sys from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/romanian/errmsg.sys from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/russian/errmsg.sys from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/serbian/errmsg.sys from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/slovak/errmsg.sys from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/spanish/errmsg.sys from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/swedish/errmsg.sys from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
  file /usr/share/mysql/ukrainian/errmsg.sys from install of mysql-5.0.27-1.el4.art conflicts with file from package mysql-4.1.20-2.RHEL4.1
[root@ng ~]#

Maybe som problems related to x86_64 ?

Unread post by **scott** » Wed Jul 25, 2007 11:11 pm

centos specific issue on the x86_64s, they cover this in their forums on www.centos.org, but if I recall you've got to specify: yum update mysql.x86_64

henningl · Unread post by **henningl** » Fri Jul 27, 2007 4:25 am

That didn't solve the problem, still the same errors. Tried finding solutions on the centos.org forums, but didn't find any. The solution you suggestet was mentioned, but not clear if it actually helped anyone.

Soo.. remove mysql-4.1.20-2.RHEL4.1 first from the server then? How would one do that without removing every single dependant package?

Or, just wait for working updates or someone else with the same problems.

henningl · Unread post by **henningl** » Fri Jul 27, 2007 4:31 am

Small update, did the following:

Code: Select all

[root@ng ~]# rpm -qa --qf="%{n}-%{v}-%{r}.%{arch}\n" 'mysql*'
mysql-4.1.20-2.RHEL4.1.i386
mysql-4.1.20-2.RHEL4.1.x86_64
mysql-server-4.1.20-2.RHEL4.1.x86_64
[root@ng ~]#

This suggests that I have both 32 bit and 64 bit mysql doesn't it?

Unread post by **scott** » Fri Jul 27, 2007 7:21 am

yeah thats OK, it lets you run both i386 and x86_64 packages on the same system. That might be the problem really, the atomic channels are just i386 or just x86_64. The solution might be to use both on the x86_64 box, which Ive never tried before (but sounds really reasonable in my head!)

henningl · Unread post by **henningl** » Fri Jul 27, 2007 11:09 am

Hm.. changing atomic.repo to not use the $arch variable, and instead hardcode both a x86 and x86_64 archive?

henningl · Unread post by **henningl** » Sat Jul 28, 2007 2:42 pm

Okey, did just that (set up both x86_64 and i386 atomic repo) and the install went just fine..

Code: Select all

[root@ng ~]# rpm -qa --qf="%{n}-%{v}-%{r}.%{arch}\n" 'mysql*'
mysql-server-5.0.27-1.el4.art.x86_64
mysqlclient14-4.1.22-2.el4.art.x86_64
mysql-5.0.27-1.el4.art.i386
mysql-5.0.27-1.el4.art.x86_64
[root@ng ~]#

Now I have both i386 and x86_64 mysql, and x86_64 mysql-server. No idea which is actually used though. A bit confusing that I only have mysqlclient14-4.1.22.

phpinfo and phpmyadmin now claims running an old mysql client against the newer database is a problem. "Your PHP MySQL library version 4.1.22 differs from your MySQL server version 5.0.27. This may cause unpredictable behavior.", but as far as I can figure out, I'm fine as long as the client is >=4.1 ?