MySQL 5.0 Percona Highperf RPMs do not create standard mysql group

[m00dawg]

I recently upgraded from MySQL 5.0.84 (Rackspace RPMs - don't worry, this is all on a test box) and noticed that, while the 'mysql' user gets properly recreated when I remove the 5.0.84 RPMs and install the Percona 5.0 RPM set, the group does not:

[root@hyperthread_mysqltest mysql]# grep mysql /etc/passwd
mysql:x:27:503:MySQL Server:/var/lib/mysql:/bin/bash
[root@hyperthread_mysqltest mysql]# grep mysql /etc/group
mysql:x:503:
[root@hyperthread_mysqltest mysql]# ls -la
total 16935108
drwxr-xr-x 3 mysql mysql 4096 Nov 30 15:45 .
drwxr-xr-x 26 root root 4096 Nov 30 15:44 ..
-rw-rw---- 1 mysql 27 16777216000 Nov 30 15:45 ibdata1
-rw-rw---- 1 mysql 27 10485760 Nov 30 15:45 ibdata2
-rw-rw---- 1 mysql 27 268435456 Nov 30 15:45 ib_logfile0
-rw-rw---- 1 mysql 27 268435456 Nov 19 16:46 ib_logfile1
drwx------ 2 mysql 27 4096 Nov 18 15:57 mysql
srwxrwxrwx 1 mysql mysql 0 Nov 30 15:45 mysql.sock

[MikeG (mikegriffin)]

The affects both mysql50-percona-highperf-server and mysql51-server:

Stock RHEL:

[root@mgslice2 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.4 (Tikanga)
[root@mgslice2 ~]# yum repolist
Loaded plugins: rhnplugin, security
repo id repo name status
epel Extra Packages for Enterprise Linux 5 - x86_ enabled: 4,862
ius IUS Community Packages for Enterprise Linux enabled: 166
rhel-x86_64-server-5 Red Hat Enterprise Linux (v. 5 for 64-bit x8 enabled: 8,299
repolist: 13,327
[root@mgslice2 ~]# grep mysql /etc/passwd /etc/group
[root@mgslice2 ~]# yum install mysql-server.x86_64
Loaded plugins: rhnplugin, security
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql-server.x86_64 0:5.0.77-3.el5 set to be updated
--> Processing Dependency: mysql = 5.0.77-3.el5 for package: mysql-server
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: mysql-server
--> Processing Dependency: libmysqlclient_r.so.15(libmysqlclient_15)(64bit) for package: mysql-server
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: mysql-server
--> Processing Dependency: libmysqlclient_r.so.15()(64bit) for package: mysql-server
--> Running transaction check
---> Package mysql.x86_64 0:5.0.77-3.el5 set to be updated
---> Package perl-DBD-MySQL.x86_64 0:3.0007-2.el5 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package Arch Version Repository Size
================================================================================
Installing:
 mysql-server x86_64 5.0.77-3.el5 rhel-x86_64-server-5 9.8 M
Installing for dependencies:
 mysql x86_64 5.0.77-3.el5 rhel-x86_64-server-5 4.8 M
 perl-DBD-MySQL x86_64 3.0007-2.el5 rhel-x86_64-server-5 147 k

Transaction Summary
================================================================================
Install 3 Package(s)
Update 0 Package(s)
Remove 0 Package(s)

Total download size: 15 M
Is this ok [y/N]: y
Downloading Packages:
(1/3): perl-DBD-MySQL-3.0007-2.el5.x86_64.rpm | 147 kB 00:00
(2/3): mysql-5.0.77-3.el5.x86_64.rpm | 4.8 MB 00:00
(3/3): mysql-server-5.0.77-3.el5.x86_64.rpm | 9.8 MB 00:01
--------------------------------------------------------------------------------
Total 6.7 MB/s | 15 MB 00:02
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : mysql 1/3
  Installing : perl-DBD-MySQL 2/3
  Installing : mysql-server 3/3

Installed:
  mysql-server.x86_64 ...

[MikeG (mikegriffin)]

Created separate tracker as I should have originally: Bug #499650

[BJ Dierkes (derks)]

This has been pushed to ius-el5 stable.

[Abed Escobal (abednegoyulo)]

May I ask the status of mysql50-percona-highperf-5.0.87-1.b20? I can only see mysql50-percona-highperf

[Abed Escobal (abednegoyulo)]

Sorry for the incomplete statement. As I was saying, I can only see mysql50-percona-highperf-5.0.86-1.b19 both from yum and from http://dl.iuscommunity.org/pub/ius/stable/Redhat/5/x86_64/. I cannot find mysql50-percona-highperf-5.0.87-1.b20. May I ask the status of mysql50-percona-highperf-5.0.87-1.b20? It neither exists in the ius-testing nor in the ius-dev repos.

[BJ Dierkes (derks)]

mysql50-percona-highperf is admittedly behind on updates. We have been focussing on development of our build system, as well as working on other project/administrative tasks keeping us from focussing on updates for the near future. Some of which was blogged about:

http://iuscommunity.org/

Would you mind opening a new tracker specifically for the update of mysql50-percona-highperf to the latest version and we will attempt to address it asap.

I apologize for any inconvenience, and appreciate your understanding.