Bacula-users

Re: [Bacula-users] How to properly delete Clients and data from DB

2012-05-07 09:29:48
Subject: Re: [Bacula-users] How to properly delete Clients and data from DB
From: Machiel van Veen <mvv AT sentia DOT nl>
To: bacula-users AT lists.sourceforge DOT net
Date: Mon, 7 May 2012 15:09:59 +0200
On Monday 07 May 2012 14:13:48 Martin Reissner wrote:
> Hello,
> 
> I had to remove several clients (fds) from my bacula setup and I found
> no intructions on how to do this properly. Can someone please help me out?
> What I want to achieve is that all database entries related to those
> clients (clients, jobs, files,...) will be removed as this is quiet some
> data.
> My best guess was to delete those clients including
> jobs,filesets,schedules and also their dedicated storage devices and
> pools from the config files and then run dbcheck to remove orphaned
> entries but this didn't work as dbcheck reported no orphaned
> Clients/Jobs/.. but they are still in the DB when I check via SQL and
> the Clients are also still listed when prompted to select a Client in
> 'restore' mode.
> 
> I'm using Bacula 5.0.2 with Mysql on Debian Squeeze 64.
> 
> Regards,
> 
> Martin
> 

Whenever I remove a client I delete all it's configuration and run reload in 
bconsole. Then remove the database entry manualy and run a dbcheck.

psql -c "delete from client where name='client-name'" bacula
dbcheck -f -b -c /etc/bacula/bacula-dir.conf

I use postgresql but the query should be the same for mysql.

Machiel.

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users