Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-357

LP #1174426: mysql_install_db still not working properly with clean install

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      **Reported in Launchpad by Jason Cox last update 31-05-2013 08:08:55

      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-rr-. 1 root root 123 Apr 29 10:10 RPM_UPGRADE_HISTORY
      rw-rr-. 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.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: