Hi folks.

I had a weird occurrence yesterday and thought I'd pick your collective brains to gain more insight as to what the heck happened.

I ran up2date yesterday and it installed a few new MySQL packages as well as a new kernel.

It got through everything up until it went to install the smp version of the kernel, and up2date spit an error at me and quit.

The problem was that my system keeps old kernels and /boot was full, so it couldn't add the new files there. No problem--I manually removed (via rpm -e) six or seven of the old kernel packages (there might have been a dozen or so), ran up2date again, and it successfully installed the new kernel. Great. So I rebooted the system.

And when it came back up... MySQL didn't start. Huh?

I tried to manually start it just to see, and was greeted with "chown: 'mysql:mysql': invalid user" Yikes! Sure enough, a look at /etc/passwd showed NO user "mysql." I quickly tried "useradd mysql" but it wouldn't go for that because there was a GROUP mysql.

I checked to make sure that there was no user with an id matching the group id of mysql and then manually added mysql back to /etc/passwd and /etc/shadow.

After doing that I was able to start the MySQL daemon and it now properly starts up and runs fine after rebooting.

So basically, it's fixed, but I still don't exactly understand what the heck happened. Updating to a new MySQL rpm and having up2date fail while installing a new kernel somehow deletes my "mysql" user from the system? I shouldn't have to be manually modifying /etc/passwd and /etc/shadow because of an up2date error, I wouldn't think.

If anyone has any ideas, I'd love to hear them.

Thanks!

Edit-- This is a RHEL 4 system now running 2.6.9-89.0.20.ELsmp on a Dell PowerEdge 1750..

G.--

I can't say exactly why the user was deleted - perhaps it had something to do with the fact the MySQL install RPM tries to add the user or maybe there is a different default user for new install?

However, I can say there is a way to add a user without doing the RedHat (Fedora/CentOS) default of adding a group. You use the "-n" option of useradd.

From man page:

1 members found this post helpful.

Ahh! In my haste yesterday skimming through man pages I probably got as far as "group having the same name... created by default" and skipped to the next option.

I appreciate the tip!