MySQL Forums
Forum List  »  Security

Unable to encrypt table using keyring plugin
Posted by: sandip patil
Date: February 07, 2022 08:10AM

Dear Team,

We have set up mysql enterprise edition 8.0 and trying to load load the keyring pulgin on windows server 2019.

The plugin loaded successfully

[mysqld]

early-plugin-load = keyring_file.dll

keyring_file_data=C:/Program Files/MySQL/MySQL Server 8.0/keyring

And we have created the one database and created table under same database.

after Test that encryption KMIP is working

mysql> INSERT INTO test_encryption VALUES (1, 'cleandro');

Query OK, 1 row affected (0.00 sec)

mysql> select * from test_encryption;

+----+----------+

| id | name |

+----+----------+

| 1 | cleandro |

+----+----------+

1 row in set (0.00 sec)

After that Edit the MySQL configuration file and disable the keyring_okv plugin, so i have committed above entries as below

[mysqld]

#early-plugin-load = keyring_file.dll

#keyring_file_data=C:/Program Files/MySQL/MySQL Server 8.0/keyring

and restated the MySQL service. so after that expected output is we are getting error like

The table is not accessible because MySQL cannot get to the master key from the

keyring.

But unfortunately we are not getting error and still above lines are committed.

mysql> use MySQL_TDE_Test;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> select * from test_encryption;

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
Unable to encrypt table using keyring plugin
148
February 07, 2022 08:10AM


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.