LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices

Reply
 
Search this Thread
Old 11-25-2013, 09:34 AM   #1
carlitoco
Member
 
Registered: Jan 2008
Location: Berlin
Distribution: Slackware / Arch
Posts: 132

Rep: Reputation: 15
Slackware 14.1 mariadb encrypted mydiamo


Do anybody have experience about the installation on a running mysql?

How does the encryption works...

If I've already a whloe dm-crpted device, does mydiamo take an effect, and/or is the database complete (at all) decrypted while running mariadb?

What is the effect in detail?

Thank you!

Last edited by carlitoco; 11-25-2013 at 09:36 AM.
 
Old 11-27-2013, 04:16 AM   #2
carlitoco
Member
 
Registered: Jan 2008
Location: Berlin
Distribution: Slackware / Arch
Posts: 132

Original Poster
Rep: Reputation: 15
Nobody knows something?
 
Old 11-27-2013, 12:18 PM   #3
TracyTiger
Member
 
Registered: Apr 2011
Location: California, USA
Distribution: Slackware
Posts: 269

Rep: Reputation: 62
Since you've already removed your post from the zero reply list ...

I don't use Mariadb, or mydiamo (or MySql) so if you're asking about some special encryption feature of those I can't offer any help.

Regarding the encryption of block devices ...

You encrypt the device (partition), which it sounds like you've done. When the operating system is running you access the files (and databases) there just as though encryption was not involved ... everything is encrypted/decrypted automatically. Your SQL queries are created just as though encryption was not involved.

If you reboot the computer and don't enter the proper key for the encrypted device then none of the files on the encrypted device can be accessed. It doesn't matter what application is running, database or otherwise.

Additionally, database programs also have have encrypted data types so that you can encrypt just the data in one field/column. This encrypted data type is independent of the block level encryption mentioned above.

Perhaps this is the explanation you were seeking?

I'm no expert in this area and others can explain more precisely.
 
Old 11-27-2013, 06:41 PM   #4
tux_dude
Member
 
Registered: Dec 2008
Distribution: Slackware64 Current
Posts: 226

Rep: Reputation: 33
Quote:
Originally Posted by carlitoco View Post
Do anybody have experience about the installation on a running mysql?
How does the encryption works...

If I've already a whloe dm-crpted device, does mydiamo take an effect, and/or is the database complete (at all) decrypted while running mariadb?

What is the effect in detail?

Thank you!
Having MyDiamo on dm-crypt device will provide two level encryption. The dm-crypt device ensures your data is protected if the device falls into the wrong person's hand (if they don't have your keys). MyDiamo encrypts the database data, which prevent someone with unauthorized access to your system (or device if your dm key is compromised) from gaining access to your data by dumping the DBs or copying the DB files.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Replace MySQL with MariaDB in Slackware abesirovic1 Slackware 36 03-28-2013 08:53 AM
LXer: Slackware switching to the MariaDB database LXer Syndicated Linux News 0 03-24-2013 09:42 PM
[SOLVED] Slackware: Replace MySQL with MariaDB on fresh installation. astanton Slackware 4 03-03-2012 02:37 AM
encrypted rootfs on Slackware 12.0 /y0shi Slackware 2 03-12-2008 10:18 AM
Encrypted Filesystems with Slackware 12 AMarkos Slackware 7 10-27-2007 01:33 PM


All times are GMT -5. The time now is 05:05 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration