I have studied in detail "Restore Job".

I mean it
  restore ... file=?table_name

Here Bacula makes a request:
  SELECT JobId,FileIndex from table_name;

Why?
Suffice it:
  SELECT FileId from table_name;

PS.
For example, I have (in Webacula) in 'table_name' is information about
the files, _already_ ready to restore.
Ie "unnecessary" files in 'table_name' does not exist.
So, for example, Webacula can not use (good in theory) to 'restore
file=?table_name'.

2010/2/11 Eric Bollengier <e...@eb.homelinux.org>:
> Hello,
>
> Le Jeudi 11 Février 2010 08:48:01, Yuri Timofeev a écrit :
>> Hi,
>>
>> I develop a web-interface for bacula.
>> I can tell you that I would like to see in Bacula.
>> You can accept this or not.
>>
>> First.
>> Any status or action Bacula should be recorded in the database.
>> (often Job state in the  database and message from the Director is
>> different)
>
> Yes, i know this problem, and i would like to update the JobStatus field each
> time it changes too. It creates update queries on the Catalog, and it should
> be added carefully. I can do some work on that.
>
>
>> Second.
>> This applies to the Restore Job.
>> I create a temporary table, eg
>>
>> _file_XXX
>> _filename_XXX
>> _path_XXX
>>
>> where XXX - is md5 (JobId), or md5 (JobId1. .. JobIdN)
>>
>> These tables contain some data from the original tables Bacula (File,
>> Filename, Path).
>> Also, temporary tables contain the decoded data on the file size and one
>> additional field:
>>
>> FileSize INTEGER  DEFAULT 0
>> isMarked INTEGER  DEFAULT 0
>>
>> Field 'isMarked' shows the file is selected for Restore or not.
>>
>> Then the path + filename, where (isMarked! = 0) written to a file, for
>> example, /tmp/webacula_restore_XXX.tmp
>>
>>
>> And run Restore Job:
>> bconsole file=<"/tmp/webacula_restore_XXX.tmp"
>>
>> Therefore, I would like the file "/tmp/webacula_restore_XXX.tmp"
>> could be transmitted over the network from bconsole to the Director.
>
> You can do it by scp, nfs, custom php and many other standard unix tools. I
> don't think that it's very useful to implement copy tool over bconsole.
>
> And, if you look bat or bresto (an other web interface for Bacula), they are
> able to run restore jobs without copying files over the network in the same
> way. If i'm remember well, i already told you that it's possible to use a sql
> table for file selection. So as you have it, why don't use it directly instead
> of generating files?
>
>> Perhaps all this is too difficult.
>
> Not at all, Bacula should do his best to get good Gui, and all tips and tricks
> are not always well documented.
>
>> I hope this information will help make Bacula easier for developers of
>> web-interfaces.
>
> Bye
>



-- 
with best regards

------------------------------------------------------------------------------
Download Intel&#174; 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-devel mailing list
Bacula-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-devel

Reply via email to