Hi.
I'm new to the list, and saw the mail from Craig Holyoak in the list archive.

I did a misstake by reading the developer manual when using Bacula 1.36.2
so I created a Scratch pool, and a script to move purged tapes to that pool
PoolId 7 in my case.

#!/bin/sh
#

MYSQL=/extra/mysql/4.0.18/bin/mysql

pool() {
(
$MYSQL << EOF
use bacula
select count(*) from Media where PoolId=$1;
EOF
) | tail -1
}

poolids() {
(
$MYSQL << EOF
use bacula
update Media set PoolID=7 where VolStatus='Purged';
select PoolId from Pool ;
EOF
) | grep -v PoolId
}

updatenumvols() {
$MYSQL << EOF
use bacula
update Pool set NumVols=$2 where PoolId=$1;
EOF
}

for i in `poolids`
do
       updatenumvols $i `pool $i`
done


Now I noticed that 1.36.2 don't look in the Scratch pool for tapes :-(
so I must move them back again :-)

I run bacula on Solaris8 sun Enterprise E450 with an Adic Scalar AIT 480
(well, it took me some time to get all 4 drives to work)

/birre

-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to