Component Key ring file

[Pradeep Kumar Bojja]

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.