Percona Server with XtraDB

mysql_install_db still not working properly with clean install

Reported by Jason Cox on 2013-04-29
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server
Status tracked in 5.6
5.1
Undecided
Unassigned
5.5
Critical
Ignacio Nin
5.6
Critical
Laurynas Biveinis

Bug Description

Trying to install latest Server-55 RPMs on clean Centos 6.4 system and still seeing Bug#1170024 issue. No mysql system tables.

Running Transaction
  Installing : Percona-Server-shared-55-5.5.30-rel30.2.508.rhel6.x86_64 1/3
  Installing : Percona-Server-client-55-5.5.30-rel30.2.508.rhel6.x86_64 2/3
  Installing : Percona-Server-server-55-5.5.30-rel30.2.508.rhel6.x86_64 3/3
chown: invalid user: `mysql'
Cannot change ownership of the database directories to the 'mysql'
user. Check that you have the necessary permissions and try again.
Percona Server is distributed with several useful UDF (User Defined Function) from Maatkit.
Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
See http://code.google.com/p/maatkit/source/browse/trunk/udf for more details
  Verifying : Percona-Server-client-55-5.5.30-rel30.2.508.rhel6.x86_64 1/3
  Verifying : Percona-Server-server-55-5.5.30-rel30.2.508.rhel6.x86_64 2/3
  Verifying : Percona-Server-shared-55-5.5.30-rel30.2.508.rhel6.x86_64 3/3

Installed:
  Percona-Server-client-55.x86_64 0:5.5.30-rel30.2.508.rhel6 Percona-Server-server-55.x86_64 0:5.5.30-rel30.2.508.rhel6 Percona-Server-shared-55.x86_64 0:5.5.30-rel30.2.508.rhel6

Complete!

[root@localhost ~]# ls -al /var/lib/mysql/
total 24
drwxr-xr-x. 4 mysql mysql 4096 Apr 29 10:10 .
drwxr-xr-x. 19 root root 4096 Apr 29 10:10 ..
drwx--x--x. 2 mysql mysql 4096 Apr 29 10:10 mysql
-rw-r--r--. 1 root root 123 Apr 29 10:10 RPM_UPGRADE_HISTORY
-rw-r--r--. 1 mysql mysql 123 Apr 29 10:10 RPM_UPGRADE_MARKER-LAST
drwxr-xr-x. 2 mysql mysql 4096 Apr 29 10:10 test
[root@localhost ~]# ls -al /var/lib/mysql/mysql/
total 8
drwx--x--x. 2 mysql mysql 4096 Apr 29 10:10 .
drwxr-xr-x. 4 mysql mysql 4096 Apr 29 10:10 ..
[root@localhost ~]#

Running "mysql_install_db --rpm --user=mysql" post RPM install creates the tables.

Alexey Kopytov (akopytov) wrote :

Confirmed on a clean CentOS 5.9 install:

Running Transaction
  Installing : Percona-Server-shared-55 1/3
  Installing : Percona-Server-client-55 2/3
  Installing : Percona-Server-server-55 3/3
chown: `mysql': invalid user
Cannot change ownership of the database directories to the 'mysql'
user. Check that you have the necessary permissions and try again.
Percona Server is distributed with several useful UDF (User Defined Function) from Maatkit.
Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
See http://code.google.com/p/maatkit/source/browse/trunk/udf for more details

Installed:
  Percona-Server-server-55.i686 0:5.5.30-rel30.2.508.rhel5

Dependency Installed:
  Percona-Server-client-55.i686 0:5.5.30-rel30.2.508.rhel5 Percona-Server-shared-55.i686 0:5.5.30-rel30.2.508.rhel5

Complete!

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers