maria-developers team mailing list archive

[Clemens Dörrhöfer <clemens.doerrhoefer@xxxxxxxx>]

Hi community,

I am working on implementing page encryption for XtraDB. Encryption itself works fine, now I am focusing on exception handling.
My problem is that whenever page encryption is misconfigured it will crash the entire server, which is no acceptable behaviour.

Example I encrypted a table with key id 42, I delete the key from the keypool thus I can no longer decrypt the table, because the appropriate key is missing.
Ideally whenever a client tries to query data from an encrypted table, which cannot be decrypted, it will receive an error message informing the client that
Table X could not be decrypted because key 42 is missing.

Can you point me out to how to accomplish such a behaviour.

Greetings
Clemens Dörrhöfer