On 15.3.2010 13:02, Administrator wrote:
> Hi
> somebody pointed me to shell scripting bacula in order to mark all 
> volumes used. Long users of bacula will certainly not find this helpfull 
> but well .. hopefully this is not starting a relevance debate ;-)
> 
> I backup on two external USB-Disks which i rotate every Week (Monday). I 
> need to mark all appendable volumes as used and did not want to use the 
> volchanger script. Instead i now query the mysql db for volumes with 
> sthe status "append" and tell bconsole to mark these as used:
> ===================
> #!/bin/sh
> MYSQL=/usr/bin/mysql
> BACULA_DB=bacula5
> BACULA_USER=bacula5
> BACULA_PASS=not24get
> BCONSOLE=/opt/bacula5/etc/bconsole
> 
> openVolumes=$(${MYSQL} -u ${BACULA_USER} -p${BACULA_PASS} ${BACULA_DB} 
> -sN -e "select VolumeName from Media where VolStatus='Append'")
> 
> rm -f updateVolumes.bacula
> for volumeName in ${openVolumes}
> do
>          echo "update volume=${volumeName} volstatus=used" >> 
> updateVolumes.bacula
> done
> ${BCONSOLE} < updateVolumes.bacula
> ======================
> I could use bconsole to query for open volumes but that would involve 
> some parsing.
> 
> Criticism is welcome

If and when you use MySQL anyway, why not just

mysql -u ${BACULA_USER} -p${BACULA_PASS} ${BACULA_DB} \
-e "update Media set VolStatus='Used' where VolStatus='Append'"


-- 
http://www.iki.fi/jarif/

Q:      What's the difference between a dead dog in the road and a dead
        lawyer in the road?
A:      There are skid marks in front of the dog.

signature.asc
Description: OpenPGP digital signature

------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users