Re: [Bacula-users] How change the MedId for an exist Volume

[Rodrigo N. de C. F. <rn...@ho...>]

Hi Bob,

exactly, i want an 'order by VolumeName', and not by MediaId on 'list media' or 'list volume' console command.

How can i change it?


Regards

Rodrigo

> Date: Thu, 16 Dec 2010 10:47:32 -0500
> From: be...@ca...
> To: bac...@li...
> Subject: Re: [Bacula-users] How change the MedId for an exist Volume
> 
> 
> 
> > From: Martin Simmons <ma...@li...>
> 
> >>>>>> >>>>> On Wed, 15 Dec 2010 08:19:02 -0200, Rodrigo N de Castro Fernandes said:
> >> >
> >> > I would like to know how to change the MediaId from a VolumeName.
> >> > Just for backup Media/Volume sort organization.
> >> >
> >> > Can somebody help me? Is it possible? Is it recommended?
> > It isn't recommended, but you could do it with some SQL commands if you are
> > very careful.
> >
> > Purge the volume first, otherwise you will need to update the jobmedia table
> > as well.  You may need to adjust the SQL sequence that controls the automatic
> > numbering of new volumes as well, if you new MediaId is higher.  There may be
> > other problems that I haven't though about...
> >
> > __Martin
> 
> I'm not 100% sure what the original poster's goal was but in my case my 
> goal was to change how bacula sorts when you do a 'list volumes'.  It sorts 
> by default by MediaId which is kinda unhelpful to those of us that use 
> actual bar-coded tapes.  The MediaId is generated when the volume is first 
> inserted into the catalog, but if the autochanger picks up the tapes in the 
> wrong order you're left with that odd sorting.  I tried to update the 
> tables directly for a while but eventually I decided it was too big a pain 
> to wait for a tape to be Scratch (I presume you meant Prune not Purge, by 
> the way).
> 
> My solution was to just tweak the query bacula uses so that it sorts on the 
> VolumeName field instead.  Unfortunately I'm on vacation so can't dig into 
> the code to see what file it was in, but all you have to do is change the 
> line where the query ends in something like 'order by MediaId' to use 
> something 'order by VolumeName' instead.  I figured that would be a great 
> enhancement to the bacula code but didn't know if there were actually some 
> people who preferred the MediaId order, perhaps because they're mixing LTO3 
> and LTO4 tapes or something, so I didn't bother generating a patch to submit.
> 
>     Bob
> 
> ------------------------------------------------------------------------------
> Lotusphere 2011
> Register now for Lotusphere 2011 and learn how
> to connect the dots, take your collaborative environment
> to the next level, and enter the era of Social Business.
> http://p.sf.net/sfu/lotusphere-d2d
> _______________________________________________
> Bacula-users mailing list
> Bac...@li...
> https://lists.sourceforge.net/lists/listinfo/bacula-users