FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Encrypt MariaDB Data
Posts: 6984
Joined: Fri Oct 07, 2005 07:07 PM
Encrypt MariaDB Data
Posted: Thu Sep 06, 2018 05:36 AM
Hello,

From the MariaDB web page

https://mariadb.com/kb/en/library/why-e ... iadb-data/

Nearly everyone owns data of immense value: customer data, construction plans, recipes, product designs and other information. These data are stored in clear text on your storage media. Everyone with file system access is able to read and modify the data. If this data falls into the wrong hands (criminals or competitors) this may result in serious consequences.

With encryption you protect Data At Rest (see the Wikipedia article). That way, the database files are protected against unauthorized access.

BTW XAMPP is installing MariaDB by default.

Does someone of you have experience with setting up rest-data encryption and MariaDB.


Best regards
Otto
Posts: 811
Joined: Tue May 06, 2008 04:28 AM
Re: Encrypt MariaDB Data
Posted: Fri Sep 07, 2018 02:55 AM

Thank you Otto,

I am planning to do encryption on my current project too.. This is a good start to initially understand it .

:wink:

Kind Regards,

Frances



Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15
Posts: 6984
Joined: Fri Oct 07, 2005 07:07 PM
Re: Encrypt MariaDB Data
Posted: Sun Sep 09, 2018 04:51 PM
Hello,
with encryption on my database files look like this. Now I feel relaxed.
Best regards
Otto
Posts: 811
Joined: Tue May 06, 2008 04:28 AM
Re: Encrypt MariaDB Data
Posted: Mon Sep 10, 2018 01:44 AM

Hello Otto,

What are the steps you made? could you share ...

:wink:

Kind Regards,

Frances



Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15
Posts: 6984
Joined: Fri Oct 07, 2005 07:07 PM
Re: Encrypt MariaDB Data
Posted: Sun Sep 23, 2018 08:42 PM

Hello Frances,
I am sorry but I didn't setup the server myself.
Now we have working 64 bit version of Apache and MariaDB.
Both as a services.
Now I have to find a way how to secure the key file.
It seems you only need the file at the start of MariaDB.
Best regards,
Otto

Posts: 6984
Joined: Fri Oct 07, 2005 07:07 PM
Re: Encrypt MariaDB Data
Posted: Wed Oct 17, 2018 10:09 PM
https://blog.avira.com/a1-telekom-austria-hacked-user-data-stored-in-plain-text/

Hello,
usually you are not personally affected. But in this case I have a little member web page with this company too.
Only a landing page.
But that shows again the importance of "encryption at rest" .
Best regard,
Otto

Continue the discussion