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

In Percona Server tar.gz I am not able to use keyring_file plugin

    Details

    • Type: Bug
    • Status: On Hold
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 8.0.13-4
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      When I am trying to start Percona Server from a custom directory using distribution from https://www.percona.com/downloads/Percona-Server-LATEST/Percona-Server-8.0.13-4/binary/tarball/Percona-Server-8.0.13-4-Linux.x86_64.ssl100.tar.gz

      and with the keyring plugin, I get:

      ./mysqld --defaults-file=/opt/vadim/sysbench-encryption/my.cnf --early-plugin-load="keyring_file=keyring_file.so" --user=root --basedir=/opt/vadim/Percona-Server-8.0.13-4-Linux.x86_64.ssl100/
      2019-01-28T23:27:50.156897Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
      2019-01-28T23:27:50.157100Z 0 [System] [MY-010116] [Server] /opt/vadim/Percona-Server-8.0.13-4-Linux.x86_64.ssl100/bin/mysqld (mysqld 8.0.13-4) starting as process 7747
      2019-01-28T23:27:50.165518Z 0 [ERROR] [MY-011370] [Server] Plugin keyring_file reported: 'File '/usr/local/Percona-Server-8.0.13-4-Linux.x86_64.ssl100/keyring/keyring' not found (OS errno 2 - No such file or directory)'
      2019-01-28T23:27:50.165538Z 0 [ERROR] [MY-011355] [Server] Plugin keyring_file reported: 'keyring_file initialization failure. Please check if the keyring_file_data points to readable keyring file or keyring file can be created in the specified location. The keyring_file will stay unusable until correct path to the keyring file gets provided'

       

      Now, when I try the same for MySQL 8.0, also from tar.gz, I can start:

      ./mysqld --defaults-file=/opt/vadim/sysbench-encryption/my.cnf --early-plugin-load="keyring_file=keyring_file.so" --user=root --basedir=/opt/vadim/mysql-8.0.14-linux-glibc2.12-x86_64
      2019-01-28T23:24:23.238880Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
      2019-01-28T23:24:23.239016Z 0 [System] [MY-010116] [Server] /opt/vadim/mysql-8.0.14-linux-glibc2.12-x86_64/bin/mysqld (mysqld 8.0.14) starting as process 5939
      2019-01-28T23:24:29.403083Z 0 [ERROR] [MY-013142] [Server] Column count of mysql.user is wrong. Expected 51, found 50. Created with MySQL 80013, now running 80014. Please use mysql_upgrade to fix this error.
      2019-01-28T23:24:29.414204Z 0 [System] [MY-010931] [Server] /opt/vadim/mysql-8.0.14-linux-glibc2.12-x86_64/bin/mysqld: ready for connections. Version: '8.0.14' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - GPL.
      2019-01-28T23:24:29.496432Z 0 [Warning] [MY-011302] [Server] Plugin mysqlx reported: 'Failed at SSL configuration: "SSL context is not usable without certificate and private key"'
      2019-01-28T23:24:29.508030Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                vadimtk Vadim Tkachenko
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: