File_key_management for MariaDB in Windows?

k-risc 2016-04-07 09:39:04 UTC #1

I have XAMPP for Windows 7.0.3 installed, which comes with 10.1.10-MariaDB. We would like to evaluate the possibilities of table encryption locally before setting up everything on the productive Linux severs. But it seems that the MariaDB version shipped with XAMPP is not contain the enryption plugin.

We defined the following in the my.ini:

innodb-encrypt-tables=ON

Which yielded: "cannot enable encryption, encryption plugin is not available."

Using other settings to define the location of the key file and the encryption method…

file_key_management_encryption_algorithm=aes_cbc
file_key_management_filename = /…keys.enc

…yields errors because those variable names are not known.

Is the file_key_management plugin available at all for Windows?

Best

Christian

jariza 2016-04-08 16:33:35 UTC #2

Hi @k-risc

I assume you are using XAMPP 5.6.19. The file_key_management was introduced at MariaDB-10.1.13 and as you said we are packing MariaDB-10.1.10 on that Stack.

We are working on a new version of the XAMPP product that will include that new version of MariaDB. If you want to install a plugin, please follow oficial MariaDB recommendations.
https://mariadb.com/kb/en/mariadb/install-plugin

Regards,

Juan

amarlian 2018-04-20 16:43:09 UTC #3

Hello,
I spent the better part of 2 days figuring this out and thought I would add my solution for others to find.
I am currently running XAMPP for Windows ver 5.6.35. (I know you are running the linux version, but you can translate these instructions for you use as well)

Since the plugin was not included in the download, I was able to grab the dll from the .zip file download of MariaDB for windows 32 bit (this is the key as xampp is a 32 bit install).
I opened the zip file and copied the lib/plugins folder into my mysql folder for xampp.

Then I could follow Chris Calendar's instructions here:
http://www.chriscalender.com/an-introduction-to-mariadbs-data-at-rest-encryption-dare-part-1/

Good luck,
Amarlian

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!