RHEL4 MySQL install in limbo...?

[SilverJet]

Running new install of Red Hat Enterprise Linux AS release 4 (Nahant Update 4), trying to install LAMP stack...

I downloaded 4 MySQL 5 RPMs from the MySQL site last Thursday:
MySQL-server-community-5.1.46-1.rhel4.i386.rpm
MySQL-client-community-5.1.46-1.rhel4.i386.rpm
MySQL-community-debuginfo-5.1.46-1.rhel4.i386.rpm
MySQL-devel-community-5.1.46-1.rhel4.i386.rpm

Went to install the server, got the following:
#rpm -i MySQL-server-community-5.1.46-1.rhel4.i386.rpm
warning: MySQL-server-community-5.1.46-1.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5

Hmmm, ok. Did a Google search, tried the following from the RHEL4 man pages for "Checking a package's signature".

Did the steps in Section 15.3.1, got the expected output from the following cmds:
#rpm --import /usr/share/rhn/RPM-GPG-KEY

#rpm -qa gpg-pubkey*
gpg-pubkey-db42a60e-37ea5438

#rpm -qi gpg-pubkey-db42a60e-37ea5438
whole bunch o' hash gibberish to me

OK, looks like it took...

Tried the install again, got this...!
# rpm -ivh MySQL-server-community-5.1.46-1.rhel4.i386.rpm
warning: MySQL-server-community-5.1.46-1.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
package MySQL-server-community-5.1.46-1.rhel4 is already installed

OK, so I'm still getting the bad key, but it's already installed...?

OK, maybe the first install was faulty. I'll uninstall and start fresh (I hope).

So I tried to uninstall using -e, got this...!
# rpm -e MySQL-server-community-5.1.46-1.rhel4.i386.rpm
error: package MySQL-server-community-5.1.46-1.rhel4.i386.rpm is not installed

Could someone please explain to me how something could be installed yet not installed...?

[HROAdmin26]

MySQL-server-community-5.1.46-1.rhel4.i386.rpm

...is the name of a FILE, not the name of the package/application.

Google: how to manage rpm packages

[SilverJet]

Ok, sorry, now I'm more confused by the reply. I basically did everything in the reference link that was posted. In fact I have it bookmarked and thought I followed the instructions. The only change I made was downloading what I thought was an RPM for MySQL Server from MySQL, not a RH mirror site.

From the MySQL download page, the description of the object I downloaded:

Red Hat Enterprise Linux 4 (x86, 32-bit), RPM Package
MySQL Server
(MySQL-server-community-5.1.46-1.rhel4.i386.rpm)
MD5: 2c0e417f835c385006f1abcc2b677e4b

From the "Using RPM" link....

RPM packages typically have file names like foo-1.0-1.i386.rpm. The file name includes the package name (foo), version (1.0), release (1), and architecture (i386). Installing a package is as simple as logging in as root and typing the following command at a shell prompt:

rpm -Uvh foo-1.0-1.i386.rpm

So if I'm reading the linked doc correctly, the object in question in an RPM:
Package name: MySQL-server-community
Version: 5.1.46
Release: 1
Arch: i386

The cmd I ran was # rpm -ivh MySQL-server-community-5.1.46-1.rhel4.i386.rpm (new install, not upgrade)

Are you saying the inclusion of rhel4 in the object's name distinguishes this as a file and not an RPM...?

And why would MySQL mis-label a file as an RPM...?

I'm sorry if I'm not grasping this if this is incredibly easy, but this to me is confusing.

[HROAdmin26]

Your music collection...

Filename: myfavoritesong.mp3

Song title in the player: Bob Marley - No Woman No Cry

See the difference?

Continue reading the link:

Use the rpm -q command to query the database of installed packages. The rpm -q foo command will print the package name, version, and release number of the installed package foo:

foo-2.0-1

Note Note


Notice that we used the package name foo. To query a package, you will need to replace foo with the actual package name.

Instead of specifying the package name, you can use the following options with -q to specify the package(s) you want to query. These are called Package Specification Options.

*

-a queries all currently installed packages.
*

-f <file> will query the package which owns <file>. When specifying a file, you must specify the full path of the file (for example, /usr/bin/ls).
*

-p <packagefile> queries the package <packagefile>.

To find any packages with "mysql" in the name:

rpm -qa | grep -i mysql

You can also read the forum sticky about installing software. Easiest way to install MySQL on Fedora:

yum install mysql-server

[SilverJet]

OK, I have run this cmd before just to double-check I have what I need:

# rpm -qa | grep -i mysql
MySQL-community-debuginfo-5.1.46-1.rhel4
MySQL-devel-community-5.1.46-1.rhel4
MySQL-server-community-5.1.46-1.rhel4
MySQL-client-community-5.1.46-1.rhel4

So I do have the packages, not just the files, correct?

I have set up a directory /home/RPMInstall/MySQL. This is the directory I download RPMs to so I can keep track of what I have downloaded and (attempted to) install.

Will the Yum installer ignore an "already installed" message/condition?