2.1.4 The Backups Should be Properly Secured

Warning! Audit Deprecated

This audit has been deprecated and will be removed in a future update.

View Next Audit Version

Information

The backup files will contain all data in the databases. Filesystem permissions and/or encryption should be used to prevent unauthorized users from gaining access to the backups.

Rationale:

Backups should be considered sensitive information. If an unauthorized user can access backups, then they have access to all data in the database. This is true for unencrypted backups and for encrypted backups if the encryption key is stored along with the backup.

NOTE: Nessus has not performed this check. Please review the benchmark to ensure target compliance.

Solution

Implement encryption, properly restrict filesystem permissions, protect and backup encryption keys.

$ mariabackup --defaults-file=/home/dbadmin/my.cnf --backup --stream=xbstream \
| openssl enc -aes-256-cbc -k mypass > backup.xb.enc

The example above creates an AES-encrypted backup, protected with the password 'mypass' and stores it in a file 'backup.xb.enc':

See Also

https://workbench.cisecurity.org/benchmarks/12270