Hello Kern
It looks that the old code from bacula-gui it was written in pearl.
If you want, you can take a look in the code:
https://sourceforge.net/projects/bacula/files/bacula/5.2.10/bacula-gui-5.2.10.tar.gz
.
I guess baculum have some function in php to decode LStat.
But the main problem, if you only include these functions in MySQL or
PostgreSQL, is the queries needs to read and decode the field LStat and
this generate a lot of processing if you have a lot of files.
If the original file size are saved in the File table as number, probably
the queries will be executed more fast.
Would be interesting include in the Job table too, because it easier and
practical to get the total of bytes that were backed up x JobBytes (that
are saved compressed).
Today there's no way to get this information from Bacula quickly.
Best regards
*Wanderlei Hüttel*
http://www.huttel.com.br
2017-10-11 8:07 GMT-03:00 Kern Sibbald <k...@sibbald.com>:
> I do not know much about the bacula-gui code, but I imagine this was
> something written in php.
>
> Does it still exist in the bacula-gui code?
>
> Does it exist in the baculum code?
>
> If it was in C++ like the Bacula core code please let me know.
>
> Best regards,
>
> Kern
>
> On 10/09/2017 07:46 PM, Wanderlei Huttel wrote:
>
> Hello Kern
>
> In the old bacula-gui-5.2.10 version there was the code.
>
>
> Atenciosamente
>
> *Wanderlei Hüttel*
> http://www.huttel.com.br
>
> 2017-10-09 14:29 GMT-03:00 Kern Sibbald <k...@sibbald.com>:
>
>> Hello Wanderlei,
>>
>> On 10/09/2017 07:21 PM, Wanderlei Huttel wrote:
>>
>> I would like to suggest to include a column in table "File" to identify
>> the original size of files.
>> Or another suggestion is to include in the Job table the sum of all files
>> backed up.
>>
>> This would be increase the speed of SQL queries to get information about
>> original file size.
>>
>> I know that we have the information of file size in the column "LStat"
>> but the queries are very slow and the function used to decode LSTAT is not
>> by default in the Bacula community.
>>
>>
>> Would be interesting incorporate the function "base64_decode_lstat" by
>> default in Bacula community.
>>
>>
>> Where have you seen this function? is it in bvfs.c? In general if it is
>> something in the Enterprise Edition, it should be included in the Community
>> version unless it is a big differentiator, and base64_decode_lstat() is not
>> such a differentiator.
>>
>> Best regards,
>> Kern
>>
>>
>> I'm suggesting these because today is not possible to know the real size
>> of files backed up.
>>
>> I've tried to implement by myself and only send a patch, but I couldn't.
>>
>>
>>
>> Best regards
>>
>> *Wanderlei Hüttel*
>> http://www.huttel.com.br
>>
>>
>> ------------------------------------------------------------------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>>
>>
>>
>> _______________________________________________
>> Bacula-devel mailing
>> listBacula-devel@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/bacula-devel
>>
>>
>>
>
>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-devel mailing list
Bacula-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-devel
