ius-coredev team mailing list archive
-
ius-coredev team
-
Mailing list archive
-
Message #00088
[Bug 490536] Re: MySQL 5.0 Percona Highperf RPMs do not create standard mysql 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 ~]#
mysql50-percona-highperf-server is reconfirmed to be 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 mysql50-percona-highperf-server.x86_64
Loaded plugins: rhnplugin, security
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql50-percona-highperf-server.x86_64 0:5.0.86-1.b19.ius.el5 set to be updated
--> Processing Dependency: mysql50-percona-highperf = 5.0.86-1.b19.ius.el5 for package: mysql50-percona-highperf-server
--> Processing Dependency: perl-DBD-MySQL for package: mysql50-percona-highperf-server
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: mysql50-percona-highperf-server
--> Processing Dependency: libmysqlclient_r.so.15(libmysqlclient_15)(64bit) for package: mysql50-percona-highperf-server
--> Processing Dependency: libmysqlclient_r.so.15()(64bit) for package: mysql50-percona-highperf-server
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: mysql50-percona-highperf-server
--> Running transaction check
---> Package mysql50-percona-highperf.x86_64 0:5.0.86-1.b19.ius.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:
mysql50-percona-highperf-server x86_64 5.0.86-1.b19.ius.el5 ius 11 M
Installing for dependencies:
mysql50-percona-highperf x86_64 5.0.86-1.b19.ius.el5 ius 4.3 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): mysql50-percona-highperf-5.0.86-1.b19.ius.el5.x86 | 4.3 MB 00:01
(3/3): mysql50-percona-highperf-server-5.0.86-1.b19.ius. | 11 MB 00:01
--------------------------------------------------------------------------------
Total 4.3 MB/s | 15 MB 00:03
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : mysql50-percona-highperf 1/3
Installing : perl-DBD-MySQL 2/3
Installing : mysql50-percona-highperf-server 3/3
Installed:
mysql50-percona-highperf-server.x86_64 0:5.0.86-1.b19.ius.el5
Dependency Installed:
mysql50-percona-highperf.x86_64 0:5.0.86-1.b19.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 ~]#
--
MySQL 5.0 Percona Highperf RPMs do not create standard mysql group
https://bugs.launchpad.net/bugs/490536
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: Confirmed
Status in IUS Community Project mysql50-percona-highperf series: Confirmed
Bug description:
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
References
