[MDEV-8262] file_key_management plugin install error Created: 2015-06-03  Updated: 2016-01-18  Resolved: 2015-06-03

Status: Closed
Project: MariaDB Server
Component/s: Encryption, Plugins
Affects Version/s: 10.1.4
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Daniel Cheung Assignee: Sergei Golubchik
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

Red Hat Enterprise Linux Server release 6.5

Issue Links:
Duplicate
duplicates MDEV-9430 Windows - Unable to install file_mana... Closed
Relates
relates to MDEV-8914 Provide better error message if file-... Closed
relates to MDEV-7979 file_key_management plugin is not ins... Closed

 Description   

I can't install file_key_management, but use same command can install other plugin.

MariaDB [test]> install soname 'file_key_management';
 
ERROR 29 (HY000): File '' not found (Errcode: 2 "No such file or directory")

and the error log says

150603 13:09:13 [ERROR] Plugin 'file_key_management' init function returned error.
 
150603 13:09:13 [ERROR] Plugin 'file_key_management' registration as a ENCRYPTION failed.

I follow the MDEV-7979 suggestion, use --loose

[root@ ~]# service mysql restart --loose-file-key-management-filename
 
Shutting down MySQL..                                      [  OK  ]
 
Starting MySQL..                                           [  OK  ]

But I still have error

MariaDB [test]> install soname 'file_key_management';
 
ERROR 29 (HY000): File '--log-error=/var/lib/mysql/test.err' not found (Errcode: 2 "No such file or directory")



 Comments   
Comment by Sergei Golubchik [ 2015-06-03 ]

The command line option --file-key-management-filename (with --loose or without) requires an argument, the file name.

Comment by Daniel Cheung [ 2015-06-03 ]

I'm sorry. I'm not understand the meaning of "requires an argument, the file name."
I try

service mysql restart --loose-file-key-management-'file_key_management'

or

service mysql restart --loose-file-key-management-filename='file_key_management'

I still have error.

MariaDB [test]> install soname 'file_key_management';
 
ERROR 29 (HY000): File '' not found (Errcode: 2 "No such file or directory")

But when I try

service mysql restart --loose-file-key-management-''
 

MariaDB [(none)]> show all_plugins;
 
+-------------------------------+---------------+---------------------+--------------------------+---------+
 
| Name                          | Status        | Type                | Library                  | License |
 
+-------------------------------+---------------+---------------------+--------------------------+---------+
 
| file_key_management           | DISABLED      | ENCRYPTION          | file_key_management.so   | GPL     |
 
+-------------------------------+---------------+---------------------+--------------------------+---------+

file_key_management status change to disable.
Is it correct or not ?
I still can't use the encryption
if it's right, how to change the file_key_management to be active?

Comment by Sergei Golubchik [ 2015-06-03 ]

you need to have

loose-file-key-management-filename=/path/to/existing/file/with/encryption/keys

in your my.cnf file. And /path/to/existing/file/with/encryption/keys
should be a valid path to the existing file with encryption keys.

Without this setting, the file name is empty and the plugin fails to load with
the error message "File '' not found".

Comment by Risky Pathak [ 2016-01-17 ]

Hello,

I am getting the same error on installing plugin "file_management" on MariaDB(mariadb-10.1.8-win32.msi) on Windows.

The error log reads:
2016-01-16 14:27:14 3740 [ERROR] mysqld.exe: file-key-management-filename is not set
2016-01-16 14:27:14 3740 [ERROR] Plugin 'file_key_management' init function returned error.
2016-01-16 14:27:14 3740 [ERROR] Plugin 'file_key_management' registration as a ENCRYPTION failed.

Generated at Thu Feb 08 07:25:50 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.