Op 20130207 om 18:55 schreef Humphrey Bryant:

On 02/07/2013 03:03 AM, Geert Stappers wrote:

Op 20130130 om 17:38 schreef Humphrey Bryant:

Hi All,

I am running Bacula 5.2.12 on CentOS 6.2 storing my backups to Disk
(fileStorage).

I recently removed some bacula clients that no longer exists on my network from
my "bacual-dir.conf" file but whenever i go to Bconsole and try to do a restore
/backup i notice i still see the (Old) Clients that I have deleted in there.
None of these Old Clients have never run a backup before on bacula; they were
created as typos (incorrect names) when setting up bacula hence i want to get
rid of them to ease the confusion.

Also I Removed/Purged some Volumes from bacula but when i go to Bconsole and
run "list volumes" i still see the old volumes there even though i purged,
volume delete and remove (rm -rf)  the file from the server. These volumes
still show up with no info attached to them.

How can i remove these stale (Old) Client/Volume info from Bacula?

AFAIK it is something along

   select ClientId, Name from Client order by ClientId ;
   delete from Client where Name = 'your_no_longer_existing_client' ;


Yes, those are database actions.
They can be performed from `bconsole` with the command `sqlquery`.


Cheers
Geert Stappers

Hey thanks for your reply, I went into the MYSQL database via phpmyadmin 
and I see the client list but they don't show actual names but judging 
by the info I see in them i can identify the non-existent clients.
I was wondering if i could just delete them from the database this way 
(via phpmyadmin)?

This is what i see for client name in the MYSQL Tables  [BLOB - 0 B]  
[BLOB - 12 B]

I will read up on Bconsole 'sqlquery'  and see how best I can remedy 
this problem.

Thanks again for your reply

Regards

Please bring it back to the bacula community, e.g. the mailinglist.