MySQL Forums
Forum List  »  Security

Component Key ring file
Posted by: Pradeep Kumar Bojja
Date: June 24, 2024 09:43PM

Hi everyone,

I was trying to work on component key ring file installation and after performing all the steps am not able to encrypt a table. Am I missing something? Can someone guide me on this?

Added manifest file under /usr/sbin

cat mysqld.my
{
"components": "file://component_keyring_file"
}

Added configuration file under /usr/lib64/mysql/plugin/

cat component_keyring_file.cnf
{
"path": "/usr/lib64/mysql/plugin/component_keyring_file",
"read_only": false
}

created a zero bytes file under /usr/lib64/mysql/plugin/component_keyring_file

Its showing as active in mysql prompt but when am trying to encrypt a table it is not working.

mysql> SELECT * FROM performance_schema.keyring_component_status;
+---------------------+------------------------------------------------+
| STATUS_KEY | STATUS_VALUE |
+---------------------+------------------------------------------------+
| Component_name | component_keyring_file |
| Author | Oracle Corporation |
| License | GPL |
| Implementation_name | component_keyring_file |
| Version | 1.0 |
| Component_status | Active |
| Data_file | /usr/lib64/mysql/plugin/component_keyring_file |
| Read_only | No |
+---------------------+------------------------------------------------+
8 rows in set (0.00 sec)


mysql> alter table emp encryption='Y';
ERROR 3185 (HY000): Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.

Options: ReplyQuote


Subject
Views
Written By
Posted
Component Key ring file
286
June 24, 2024 09:43PM
124
June 27, 2024 01:35AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.