Posted 08 May, 2019
After adding a bunch of clients, we realized that a good naming convention was required and that some funny names, where not the best choice after all. So we changed them. However, Bareos will remember those Jobs ran against the old Client. The ‘new’ name will be seen as a new client; Some of the scripts we made however found it annoying that some clients where not backed up for weeks. Basically cause they where no longer existing. There is however a way to completely remove them from database.
*purge jobs client=SVENND This command can be DANGEROUS!!! It purges (deletes) all Files from a Job, JobId, Client or Volume; or it purges (deletes) all Jobs from a Client or Volume without regard to retention periods. Normally you should use the PRUNE command, which respects retention periods. This command requires full access to all resources. Using Catalog "MyCatalog" Begin purging jobs from Client "SVENND" Found 19 Jobs for client "SVENND" in catalog "MyCatalog". Purge (yes/no)? yes
bareos-dbcheck -v -f
[[email protected] ~]# bareos-dbcheck -v -f Hello, this is the Bareos database check/correct program. Modify database is on. Verbose is on. Please select the function you want to perform. 0) Quit 1) Toggle modify database flag 2) Toggle verbose flag 3) Check for bad Filename records 4) Check for bad Path records 5) Check for duplicate Path records 6) Check for orphaned Jobmedia records 7) Check for orphaned File records 8) Check for orphaned Path records 9) Check for orphaned FileSet records 10) Check for orphaned Client records 11) Check for orphaned Job records 12) Check for all Admin records 13) Check for all Restore records 14) Run ALL checks Select function number: 10 Checking for orphaned Client entries. Found 1 orphaned Client records. Print them? (yes/no): yes Orphaned ClientId=8 Name="SVENND" Deleting 1 orphaned Client records. Deleting: DELETE FROM Client WHERE ClientId=8
Of course the data of those users are still in the filesystem (or tape) for me that is not really an issue, so I did not look into it.
If you enjoyed this article, please consider buying me a Dr Pepper.
Fuel the beast!
Buy me a Dr Pepper