MySQL Forums
Forum List  »  Security

Re: keyring_file plugin EOF error during master key writing
Posted by: Gaurav Garg
Date: April 09, 2018 05:31AM

Hi Harin,

Thank you very much for your reply.

>> my_rand_buffer() generates a random number of given length
is there any use of my_rand_buffer()

I went to mentioned file (checker, digest and buffered_file_io) and got to know much more details.

at the time of key storage its computing digest value and writing at end of file. but when i debug it step by step and watch keyring file data its gives me:

Every 2.0s: cat keyring/keyring Mon Apr 9 13:28:29 2018

Keyring file version:2.0 0 ^ IN
NODBKey-xxxxxxx-gaur-chri-garg-f44d306286a6-8AESMm ,I ^*ٳ2 ; pb
{^^ N @l,

EOF35H^i#I o . M zI hC^=

but when i do cat keyring/keyring its giving me wrong value.

because of that when i restart mysql it is not decrypting table that i have encrypted before using keyring because its unable to find master key.

this is happening because at the time of restarting mysqld_safe its reading from keyring file and if keyring file length is more then it will not load key in to memory.

may i know whats going wrong here.



Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

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.