<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="PlaceName"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<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-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
{font-family:Arial;
color:navy;}
span.EmailStyle20
{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'>I’m not an expert on this, but it
worked fine on my machines. If you check the man page for rpm, you will
see that it claims to rebuild the rpm database from installed package headers,
so the rebuild of the database insures it is in sync with what is actually
installed.<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> Friday, April 13, 2007 4:14
PM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">Discussions
about Red Hat Network</st1:PersonName> (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=idOWAReplyText80610>
<div>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:black'>Before I do that, could you tell me if it
is safe? I mean if will affect all other rpm's installed. Since I'm
working with the servers here and really have to be careful about deletions and
rebuild stuff. Thanks very much. </span></font><o:p></o:p></p>
</div>
<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>
<div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Jun</span></font><o:p></o:p></p>
</div>
</div>
<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 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 style='margin-bottom:12.0pt'><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
on behalf of <st1:PersonName w:st="on">Richard Riley</st1:PersonName><br>
<b><span style='font-weight:bold'>Sent:</span></b> Thu 4/12/2007 10:31 PM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">Discussions
about Red Hat Network</st1:PersonName> (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>
<div>
<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.</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'>> [root@prophead ~]# cat
/usr/local/bin/fixrpmdb</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'>> #!/bin/bash</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'>> # fixrpmdb - Clean up RPM
database weirdness</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'>> # Rick Stevens, VitalStream,
Inc., 22 January 2004</span></font><o:p></o:p></p>
<p class=MsoNormal><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</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'>> # beyond help...</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'>> rm -f /var/lib/rpm/__db.*</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'>> # Now, rebuild the RPM
database...</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'>> echo -n "Rebuilding RPM
database, do NOT interrupt..."</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'>> rpm --rebuilddb</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'>> echo "Rebuild
complete"</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'>> exit 0</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'>> </span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <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</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <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> <st1:PersonName w:st="on">Discussions
about Red Hat Network</st1:PersonName> (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><o:p></o:p></p>
</div>
<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>
<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><o:p></o:p></p>
</div>
<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>
<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><o:p></o:p></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><o:p></o:p></p>
</div>
</div>
<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 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> <st1:PersonName w:st="on">Discussions
about Red Hat Network</st1:PersonName> (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>
<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><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span 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><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span 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><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span 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><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span 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><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span 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><o:p></o:p></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><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span 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> rhn-users@redhat.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> [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>
<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><o:p></o:p></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><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</body>
</html>