ius-coredev team mailing list archive

Thread
Date
[Bug 499650] Re: mysql51-server rpms do not create standard mysql group

To: ius-coredev@xxxxxxxxxxxxxxxxxxx
From: BJ Dierkes <wdierkes@xxxxxxxxxxxxx>
Date: Tue, 05 Jan 2010 21:21:50 -0000
Reply-to: Bug 499650 <499650@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
This also effects mysql50.  Added -g 27 to both.

** Also affects: ius/mysql50
   Importance: Undecided
       Status: New

** Also affects: ius/mysql51
   Importance: Undecided
       Status: New

** Changed in: ius/mysql51
   Importance: Undecided => Medium

** Changed in: ius/mysql50
       Status: New => Confirmed

** Changed in: ius/mysql50
   Importance: Undecided => Medium

** Changed in: ius/mysql51
       Status: New => Triaged

** Changed in: ius/mysql50
       Status: Confirmed => Triaged

** Changed in: ius
       Status: Confirmed => Triaged

-- 
mysql50/mysql51 do not create standard mysql group
https://bugs.launchpad.net/bugs/499650
You received this bug notification because you are a member of IUS Core
Development, which is subscribed to IUS Community Project.

Status in IUS Community Project: Triaged
Status in IUS Community Project mysql50 series: Triaged
Status in IUS Community Project mysql51 series: Triaged

Bug description:
This is related to Bug #490536

The RPM does not use the correct GID when creating the mysql user and group.

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 0:5.0.77-3.el5

Dependency Installed:
  mysql.x86_64 0:5.0.77-3.el5 perl-DBD-MySQL.x86_64 0:3.0007-2.el5

Complete!
[root@mgslice2 ~]# grep mysql /etc/passwd /etc/group
/etc/passwd:mysql:x:27:27:MySQL Server:/var/lib/mysql:/bin/bash
/etc/group:mysql:x:27:
[root@mgslice2 ~]#

mysql51-server is affected:

[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 mysql51-server.x86_64
Loaded plugins: rhnplugin, security
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql51-server.x86_64 0:5.1.41-2.ius.el5 set to be updated
--> Processing Dependency: mysql51 = 5.1.41-2.ius.el5 for package: mysql51-server
--> Processing Dependency: perl-DBD-MySQL for package: mysql51-server
--> Processing Dependency: libmysqlclient_r.so.16(libmysqlclient_16)(64bit) for package: mysql51-server
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: mysql51-server
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: mysql51-server
--> Processing Dependency: libmysqlclient_r.so.16()(64bit) for package: mysql51-server
--> Running transaction check
---> Package mysql51.x86_64 0:5.1.41-2.ius.el5 set to be updated
--> Processing Dependency: mysqlclient15-devel for package: mysql51
--> Processing Dependency: mysqlclient15 for package: mysql51
---> Package perl-DBD-MySQL.x86_64 0:3.0007-2.el5 set to be updated
--> Running transaction check
---> Package mysqlclient15.x86_64 0:5.0.85-1.ius.el5 set to be updated
---> Package mysqlclient15-devel.x86_64 0:5.0.85-1.ius.el5 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package Arch Version Repository Size
================================================================================
Installing:
 mysql51-server x86_64 5.1.41-2.ius.el5 ius 11 M
Installing for dependencies:
 mysql51 x86_64 5.1.41-2.ius.el5 ius 5.5 M
 mysqlclient15 x86_64 5.0.85-1.ius.el5 ius 1.7 M
 mysqlclient15-devel x86_64 5.0.85-1.ius.el5 ius 187 k
 perl-DBD-MySQL x86_64 3.0007-2.el5 rhel-x86_64-server-5 147 k

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

Total download size: 19 M
Is this ok [y/N]: y
Downloading Packages:
(1/5): perl-DBD-MySQL-3.0007-2.el5.x86_64.rpm | 147 kB 00:00
(2/5): mysqlclient15-devel-5.0.85-1.ius.el5.x86_64.rpm | 187 kB 00:00
(3/5): mysqlclient15-5.0.85-1.ius.el5.x86_64.rpm | 1.7 MB 00:00
(4/5): mysql51-5.1.41-2.ius.el5.x86_64.rpm | 5.5 MB 00:01
(5/5): mysql51-server-5.1.41-2.ius.el5.x86_64.rpm | 11 MB 00:02
--------------------------------------------------------------------------------
Total 3.8 MB/s | 19 MB 00:04
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : mysqlclient15 1/5
  Installing : perl-DBD-MySQL 2/5
  Installing : mysqlclient15-devel 3/5
  Installing : mysql51 4/5
  Installing : mysql51-server 5/5

Installed:
  mysql51-server.x86_64 0:5.1.41-2.ius.el5

Dependency Installed:
  mysql51.x86_64 0:5.1.41-2.ius.el5
  mysqlclient15.x86_64 0:5.0.85-1.ius.el5
  mysqlclient15-devel.x86_64 0:5.0.85-1.ius.el5
  perl-DBD-MySQL.x86_64 0:3.0007-2.el5

Complete!
[root@mgslice2 ~]# grep mysql /etc/passwd /etc/group
/etc/passwd:mysql:x:27:504:MySQL Server:/var/lib/mysql:/bin/bash
/etc/group:mysql:x:504:
[root@mgslice2 ~]#
References

[Bug 499650] [NEW] mysql51-server rpms do not create standard mysql group
From: MikeG, 2009-12-23