View Issue Details

IDProjectCategoryView StatusLast Update
0000721bareos-coreGeneralpublic2017-01-25 14:46
ReporterEOLE-team Assigned To 
PrioritylowSeverityfeatureReproducibilityN/A
Status closedResolutionwon't fix 
Platformamd64OSUbuntuOS Version16.04
Product Version14.2.7 
Summary0000721: make_catalog_backup dumps the database to /var/lib/bareos/bareos.db. Make the path configurable.
Descriptionmake_catalog_backup dumps the database to
${working_dir}/${catalog_name}.db, normally /var/lib/bareos/bareos.db.

The catalog database (bareos.sql) directory is defined by the WORKING_DIR variable in /usr/lib/bareos/scripts/bareos-config-lib.sh
The default WORKING_DIR is "/var/lib/bareos" and this variable seems to define many things.
Adding a dedicated variable for the bareos.sql path could avoid having a full /var partition.
TagsNo tags attached.

Activities

joergs

joergs

2016-11-14 15:58

developer   ~0002443

The file /var/lib/bareos/bareos.sql is only used by Sqlite.
Are you aware, that Sqlite is more intended for test environments. We do advice against using it in production.
Therefore I do not see the need to make the file path configurable.
EOLE-team

EOLE-team

2016-11-16 11:56

reporter   ~0002447

Thank you for your reply.

We use MySQL as Bareos database. The problem comes when backuping MySQL with :
  /usr/lib/bareos/scripts/make_catalog_backup

This script creates a file named "bareos.sql" in WORKING_DIR which is "/var/lib/bareos".

This file can be very large and in our architecture /var is not large enough, but /home is. So we would like to be able to specify an alternative path. Either with a configuration file or with a command line argument.
joergs

joergs

2016-11-16 12:11

developer   ~0002448

Now I see. I have been confused by the summary. Also, the file /var/lib/bareos/bareos.sql is the catalog dump. The Sqlite DB would be /var/lib/bareos/bareos.db.
joergs

joergs

2016-11-16 12:52

developer   ~0002449

I tend not to extend the behavior of make_catalog_backup. The make_catalog_backup script is just a convenient and robust way to create Bareos catalog backups.
However, it is not the only method. If you got space constraints, you can use the MySQL python plugin or bpipe to backup your database without consuming extra local disk space at all, see http://doc.bareos.org/master/html/bareos-manual-main-reference.html#BackupOfAMySQLDatabase

If you don't have strict space constraints on your backup media, you better not use incremental MySQL backup, as offered by the Percona xtrabackup plugin. Otherwise a Disaster Recovery of the Bareos server will be harder.

If you disagree, you may bring this issue to the bareos-users mailing list, to find out if more users would like to see this feature.

Issue History

Date Modified Username Field Change
2016-11-03 12:48 EOLE-team New Issue
2016-11-14 15:58 joergs Priority normal => none
2016-11-14 15:58 joergs Severity minor => feature
2016-11-14 15:58 joergs Note Added: 0002443
2016-11-14 15:59 joergs Status new => confirmed
2016-11-16 11:56 EOLE-team Note Added: 0002447
2016-11-16 12:11 joergs Note Added: 0002448
2016-11-16 12:15 joergs Priority none => low
2016-11-16 12:15 joergs Summary Make the catalog database directory configurable => make_catalog_backup dumps the database to /var/lib/bareos/bareos.db. Make the path configurable.
2016-11-16 12:15 joergs Description Updated
2016-11-16 12:52 joergs Note Added: 0002449
2017-01-25 14:46 joergs Status confirmed => closed
2017-01-25 14:46 joergs Resolution open => won't fix