Kern, that's exactly what I would like to do: I would like to delete
properly and safely a client using the bacula tools for that purpose.
Can you let me know which command(s) I need to use in bconsole in
order to remove properly a client?
Regards,
John
On Fri, Jan 19, 2018 at 6:46 PM, Kern Sibbald <k...@sibbald.com> wrote:
> It is a *very* bad idea to do any direct operations on the SQL database,
> particularly deleting records. This is NOT a good solution.
>
> If you need to delete a client, you should do it through some bconsole
> command (other than the sql command) so that all the tables/records that are
> connected to a client are also deleted.
>
> Best regards,
>
> Kern
>
>
> On 17.01.2018 10:51, Rolf Halmen wrote:
>
> Hi John,
>
> turns out we're cheating.
>
> mysql -u bacula -p${BACULAMYSQLPW} -e "DELETE FROM Client WHERE
> Name='${FDHOSTNAME}';" bacula
> dbcheck -b -f -y -c /etc/bacula/bacula-dir.conf
>
> So we're just deleting the client, and then let bacula get the database
> back into a consistent state.
>
> Depending on your load and requirements that might not be feasible for
> you, of course.
>
> Kind regards,
> Rolf Halmen
>
>
> On 16.01.2018 17:47, John Naggets wrote:
>
> Hi Rolf,
>
> So if I understand correctly, there is no "standard" procedure or any
> documentation how to properly remove a client once it is not needed
> anymore (e.g. when decomissioning a server)?
>
> If not I would be interested to see your SQL query which you use for
> that purpose.
>
> Indeed I use the "use volume once = true" parameter so that each
> volume contains only one single backup from a client.
>
> Best regards,
> J.
>
> On Mon, Jan 15, 2018 at 4:59 PM, Rolf Halmen
> <rolf.hal...@neubert-consulting.de> wrote:
>
> Hi John,
>
> The database can correlate jobs to volume files.
> I'm not at a workstation right now, but off the top of my head, I'd assume
> joining the jobs, media, and clients tables should let you get to the list
> of volumes that contain backup-data of the specified client.
>
> Do keep in mind that volume files can contain data from multiple jobs,
> unless "use volume once = true".
>
> Kind regards,
> Rolf
>
> On January 15, 2018 2:10:00 PM UTC, John Naggets <hostingnugg...@gmail.com>
> wrote:
>
> Hello,
>
> It happens that some clients on the network get removed and as such do
> not need to be backed up anymore. Now I would like to know what is the
> procedure on the bacula director in order to remove properly and
> entirely a bacula client?
>
> I checked the official documentation but could not find any procedure
> for that purpose.
>
> From my understanding I need to delete the jobs and files associated
> with them as well as the volumes and finally the physical volumes on
> the filesystem (backups are done on files on a partition of the backup
> server).
>
> My problem here is that the physical volumes on the filesystem all
> have the same label except for the number so how would I know which
> file I can delete?
>
> Thank you in advance for your help.
>
> Best regards,
> John
>
> ________________________________
>
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ________________________________
>
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
> --
> Sent from my Android device with K-9 Mail. Please excuse my brevity.
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>
>
>
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
