Bug #85231 | Unable to create backup using MEB 4.0.3 with mysql version 5.7.11 | ||
---|---|---|---|
Submitted: | 28 Feb 2017 14:59 | Modified: | 6 Mar 2017 9:27 |
Reporter: | Steven Stritz | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Enterprise Backup | Severity: | S3 (Non-critical) |
Version: | 4.0.3 | OS: | Windows (Server 2012 R2) |
Assigned to: | CPU Architecture: | Any | |
Tags: | 4.0.3, 5.7.11, Backup, meb, MySQL, mysql enterprise backup, mysqlbackup, version |
[28 Feb 2017 14:59]
Steven Stritz
[3 Mar 2017 8:05]
MySQL Verification Team
Hello Steven Stritz, Thank you for the report. Could you please confirm whether 5.7.11 has keyring plungin enabled? Imho, MEB complains when it encounter plugin enabled and you are not using the option --encrypt-password while backing up using MEB - https://dev.mysql.com/doc/mysql-enterprise-backup/4.0/en/backup-encrypted-innodb-options.h... mysqlbackup: INFO: Encryption password "encrypt-password" not specified. mysqlbackup: ERROR: Invalid options, MEB would not be able backup encrypted tables. Thanks, Umesh
[3 Mar 2017 8:06]
MySQL Verification Team
-- Looks like in 5.7.11, keyring plugin active by default(unusuable unless path etc provided) [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.11: bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.11-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. root@localhost [(none)]> show plugins; +----------------------------+----------+--------------------+-----------------+-------------+ | Name | Status | Type | Library | License | +----------------------------+----------+--------------------+-----------------+-------------+ | keyring_file | ACTIVE | KEYRING | keyring_file.so | PROPRIETARY |
[6 Mar 2017 9:12]
Steven Stritz
Disabled the keyring-file plugin so the problem solved itself. It is now working with the version 5.7.11. Thank you very much!
[6 Mar 2017 9:27]
MySQL Verification Team
Thank you for confirming! Closing the bug now. Thanks, Umesh