LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 11-16-2012, 10:40 PM   #1
Footsie
LQ Newbie
 
Registered: Jan 2012
Posts: 18

Rep: Reputation: Disabled
Using YUM to upgrade Mysql


Originally, until half an hour ago, I was running mysql (server) version 5.0.45-7.el5.

Want to upgrade to v.5.1.

Never done this before, or anything like it. I backed up all databases, stopped the mysqld service and typed:

# yum install MySQL-server-5.1.60-1.glibc23.i386.rpm

YUM said:

Error: mysql conflicts with MySQL

That seemed fair enough since the two versions are not compatible. So, I typed:

# yum remove mysql

That was fine.

Finally I tried again to install the new mysql version:

# yum install MySQL-server-5.1.60-1.glibc23.i386.rpm

and got the messages:

warning: rpmts_HdrFromFdno: V3 DSA signature: NOKEY, key ID 5072e1f5
Public key for MySQL-server-5.1.60-1.glibc23.i386.rpm is not installed

I can't start the mysql daemon and

# yum list MySQL

shows no trace of the package.

I tried a localinstall from a downloaded rpm file and got exactly the same result.

I hope this is something simple - it's a production server and I have to get it going again!
 
Old 11-16-2012, 11:05 PM   #2
John VV
Guru
 
Registered: Aug 2005
Posts: 12,836

Rep: Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709
Quote:
I was running mysql (server) version 5.0.45-7.el5.
el5 means that this is "one" of the redhat 5 ( RHEL 5.0,5.1,5.2,5.3,5.4,5.5,5.6,5.7,5.8 )
or
CentOS 5.8 or Scientificlinux 5.8 ( both cent and sl ONLY support the current version in the major version)

so WHAT operating system are you using ?

RHEL is NOT free and you MUST have the REQUIRED support contract to install software
or
one of the FREE rebuilds ????
cent or SL

--------------

that error is from trying to install an incompatible rpm BYPASSING the distros repo

the "glibc23" on the end of that "Random" rpm file
means you MUST have a operating system BUILT with glibc 2.3
the rpm MUST MATCH your system



there is nothing i can offer untill you inform us as to what you are using

other than USE your operating system's update and base repo
Code:
su -
yum update mysql
or
build and install from source the database and ALL of it's prerequisites
and for a mismatching libc
that is 80% of the operating system

so
1)
exactly what operating system is it ?
2) and what version is it ?



blindly trying to bypass the safeguards in "yum" and installing an incompatible rpm from some " random place on the web"
is NEVER a good idea
 
Old 11-16-2012, 11:28 PM   #3
Footsie
LQ Newbie
 
Registered: Jan 2012
Posts: 18

Original Poster
Rep: Reputation: Disabled
[root@monkey downloads]# cat /etc/*-release
CentOS release 5.2 (Final)

That's the OS. Can't make out whether you were asking anything else.

I want v5.1 of mysql. If you know how I should go about installing it, please let me know. I don't believe it is impossible.
 
Old 11-17-2012, 12:00 AM   #4
John VV
Guru
 
Registered: Aug 2005
Posts: 12,836

Rep: Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709
cent STOPPED supporting 5.2 a very long time ago
Cent only supports the CURRENT minor version in the major version
Cent5.8 and Cent 6.3 are the ONLY supported versions

please UPGRADE
You have not installed any security fixes sense "2008-05-21" when 5.2 hit "End Of Life"

but if you must use a OS that is vulnerable to EVERY KNOWN security hole for the last 4 years

then build mysql from source

that is really your only option
and hopefully you will not have to rebuild half of the OS to do so ?
but you might !
 
Old 11-17-2012, 12:13 AM   #5
Footsie
LQ Newbie
 
Registered: Jan 2012
Posts: 18

Original Poster
Rep: Reputation: Disabled
Okay, I'll upgrade.

Please bear in mind that I haven't done this before. If I just type

# yum update

and then re-boot, will that do the trick?

Am I likely to hit problems that will make me wish I'd never done it?
 
Old 11-17-2012, 01:13 AM   #6
John VV
Guru
 
Registered: Aug 2005
Posts: 12,836

Rep: Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709
on 5.2 you can not do that, that will NOT work
ALL , every and ALL the rpms were removed a long time ago from the folders that are listed in the repo files
/mnt/SL6/etc/yum.repos.d/cent.repo

EVERY link in that file is dead
you would have to manually point it to the very old and insecure historical vault
and then you can ONLY install rpms that are 4+ years OUT OF DATE
-- NO UPDATES -
http://vault.centos.org/5.2/
mysql-5.0.45-7.el5.i386.rpm

is the very LAST update to 5.2 and that WAS in June of 2008

if you MUST stay wit ha unsupported version of a Operating system ( not recommended )
then you will have to manually build every and ALL prerequisite for that version of MySQL
-- a LOT of work .
 
Old 11-17-2012, 03:10 AM   #7
Footsie
LQ Newbie
 
Registered: Jan 2012
Posts: 18

Original Poster
Rep: Reputation: Disabled
I was asking how to upgrade CentOS 5.2 to something shiny and new, and what the problems were likely to be.

Not sure whether or not you gave an answer???
 
Old 11-17-2012, 06:56 PM   #8
John VV
Guru
 
Registered: Aug 2005
Posts: 12,836

Rep: Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709Reputation: 1709
in that case you will need to do a new CLEAN install of CentOS 6.3
there is no option to upgrade between major versions of the operating system

and the major version of mysql in centos 5.8 will be the SAME as in 5.2
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Yum install mysql mysql-server not working drewdown Linux - Software 3 06-03-2012 10:51 PM
[SOLVED] yum install php-mysql create problem to my running mysql database arun5002 Linux - Server 1 08-11-2011 03:24 AM
yum update fails after FC6->FC9->FC11 upgrade on MySQL-server rpm ericcarlson Fedora 1 07-08-2009 01:06 PM
yum install php-mysql fails with mysql 5.1 - "Error: mysql conflicts with MySQL" rebelde Linux - Software 2 03-13-2009 10:32 AM
Problem Starting MySQL on Fresh Fedora 8 Install w/ Yum'd MySQL blong4life Linux - Server 2 07-04-2008 07:44 PM


All times are GMT -5. The time now is 05:35 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration