<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
font-face
{font-family:Tahoma;}
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:#606420;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.emailstyle17
{font-family:Arial;
color:navy;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink="#606420">
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Here’s something I saw some time ago
related to cleaning up the rpm database. You might want to try it and see if
it removes those duplicates.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>> [root@prophead ~]#
cat /usr/local/bin/fixrpmdb<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>> #!/bin/bash<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>> # fixrpmdb - Clean
up RPM database weirdness<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>> # Rick Stevens,
VitalStream, Inc., 22 January 2004<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>> # First, delete the
RPM database files since they may be<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>> # beyond help...<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>> rm -f
/var/lib/rpm/__db.*<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>> # Now, rebuild the
RPM database...<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>> echo -n
"Rebuilding RPM database, do NOT interrupt..."<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>> rpm --rebuilddb<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>> echo "Rebuild
complete"<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>> exit 0<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Richard<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
rhn-users-bounces@redhat.com [mailto:rhn-users-bounces@redhat.com] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Chen, Jason<br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, April 12, 2007
9:46 PM<br>
<b><span style='font-weight:bold'>To:</span></b> Discussions about Red Hat
Network (rhn.redhat.com)<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [rhn-users] problem
with installing mysql server</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div id=idOWAReplyText47928>
<div>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black'>Thanks for your reply.
The trouble I have here is about unable to do a clean install. There are 2
mysql-4.1.20-2.RHEL4.1 and I cannot remove with rpm -e since the 2 packages
have the same name. I tried downloading the new rpm from mysql.com but have
conflicts with those 2 files. So I tried the CD... </span></font><span
lang=EN-GB><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>Do you mean the 64-bit is not supported? But we have
64-bit SUN servers and really need to stick to 64-bit achitecture considering
the software we have here for work. </span></font><span lang=EN-GB><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>Or please just let me know how to unistall the
duplicate-named packages so that I may proceed with a clean install. Thanks!</span></font><span
lang=EN-GB><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>Jun</span></font><span lang=EN-GB><o:p></o:p></span></p>
</div>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span lang=EN-GB style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma><span
lang=EN-GB style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span lang=EN-GB style='font-size:10.0pt;font-family:Tahoma'>
rhn-users-bounces@redhat.com on behalf of Steven Jones<br>
<b><span style='font-weight:bold'>Sent:</span></b> Thu 4/12/2007 5:23 PM<br>
<b><span style='font-weight:bold'>To:</span></b> Discussions about Red Hat
Network (rhn.redhat.com)<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [rhn-users] problem
with installing mysql server</span></font><span lang=EN-GB><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>Can you do a clean
install?</span></font><span lang=EN-GB><o:p></o:p></span></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>If so look at rhas4-32 or
better rhas5-32 (it has mysql5). I would suggest avoiding RH’s ??_64,
they are “piggy’s” when it comes to 3<sup>rd</sup> party software
(often hard to install, unsupported by 3<sup>rd</sup> party vendors, and
lacking in “free” rpms compared to 32bit)…..otherwise try
rpmfind.net and look for the equiv fedora rpm’s if rhas4 ones are not
about….try mysql’s website for 64 bit rpms….ie you have a few
options….</span></font><span lang=EN-GB><o:p></o:p></span></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>Or, remove all packages
and then install off CD….(do backups of your database first of course).
You could install with –nodeps to get around such conflicts, but that can
be dangerous……MAKE sure you do have a VALIDATED backup first.</span></font><span
lang=EN-GB><o:p></o:p></span></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>Other possibilities is
manually bring down rhas5’s mysql rpms and try that as its version 5.</span></font><span
lang=EN-GB><o:p></o:p></span></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>Do note that you are
turning a supported platform into an un-supported one…</span></font><span
lang=EN-GB><o:p></o:p></span></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>regards</span></font><span
lang=EN-GB><o:p></o:p></span></p>
<div>
<p><font size=2 color=navy face="Times New Roman"><span lang=EN-GB
style='font-size:10.0pt;color:navy'>Steven Jones<br>
Senior Linux/Unix/San System Administrator<br>
APG -Technology Integration Team<br>
<st1:PlaceName w:st="on">Victoria</st1:PlaceName> <st1:PlaceName w:st="on">University</st1:PlaceName>
of <st1:City w:st="on"><st1:place w:st="on">Wellington</st1:place></st1:City><br>
Phone: +64 4 463 6272 <st1:City w:st="on"><st1:place w:st="on">Mobile</st1:place></st1:City>:
+64 27 563 6272</span></font><font color=navy><span lang=EN-GB
style='color:navy'> </span></font><span lang=EN-GB><o:p></o:p></span></p>
<p><font size=3 face="Times New Roman"><span lang=EN-GB style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
rhn-users-bounces@redhat.com [mailto:rhn-users-bounces@redhat.com] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Chen, Jason<br>
<b><span style='font-weight:bold'>Sent:</span></b> Friday, 13 April 2007 10:03
a.m.<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">rhn-users@redhat.com</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> [rhn-users] problem with
installing mysql server</span></font><span lang=EN-GB><o:p></o:p></span></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<div>
<div>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black'>Hi, <br>
<br>
Recently, I found our mysql is not running correctly. Then I tried install the
new version of mysql. However, on out <st1:place w:st="on"><st1:City w:st="on">Redhat</st1:City>
<st1:State w:st="on">AS</st1:State></st1:place> 4/x86_64 platform, there were
conflicts. I'm not able to remove all the related mysql rpms since there are
duplicate rpm names, like mysql-4.1.20-2.RHEL4.1. There are 2 of them. So I
couldn't remove them with rpm -e and have a 'clear' upgrade. <br>
<br>
When I resort to the Redhat CD's, I tried to install the old version of mysql,
i.e. 4.1.7. But I got error when I tried to install mysql-server-4.1.7 <br>
<br>
"failed dependencies: mysql=4.1.7 is needed by
mysql-server-4.1.7-4.RHEL4.1.x86_64". <br>
<br>
This type of error also prevents from installing some other mysql related
packages. Can anyone tell me why it is asking an rpm package which is
already there and how to solve the problem? <br>
<br>
Thanks1</span></font><span lang=EN-GB><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black'>Jun</span></font><span
lang=EN-GB><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</body>
</html>