Encrypt MariaDB Data

Encrypt MariaDB Data

Postby Otto » Thu Sep 06, 2018 5: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
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6331
Joined: Fri Oct 07, 2005 7:07 pm

Re: Encrypt MariaDB Data

Postby fraxzi » Fri Sep 07, 2018 2: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
User avatar
fraxzi
 
Posts: 811
Joined: Tue May 06, 2008 4:28 am
Location: Philippines

Re: Encrypt MariaDB Data

Postby Otto » Sun Sep 09, 2018 4:51 pm

Hello,
with encryption on my database files look like this. Now I feel relaxed.
Best regards
Otto
Image
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6331
Joined: Fri Oct 07, 2005 7:07 pm

Re: Encrypt MariaDB Data

Postby fraxzi » Mon Sep 10, 2018 1: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
User avatar
fraxzi
 
Posts: 811
Joined: Tue May 06, 2008 4:28 am
Location: Philippines

Re: Encrypt MariaDB Data

Postby Otto » Sun Sep 23, 2018 8: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
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6331
Joined: Fri Oct 07, 2005 7:07 pm

Re: Encrypt MariaDB Data

Postby Otto » 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
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6331
Joined: Fri Oct 07, 2005 7:07 pm


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 63 guests