Re: [Bacula-users] file listing?

2011-03-15 Thread Kjetil Torgrim Homme
I wrote a script to do this for me, I call it bacula-du, since it accepts many of the same options as du(1), and the output is the same. Usage: bacula-du [OPTIONS] -j JOBID Summarize disk usage of directories included in the backup JOBID Options are: -a, --all write counts for all

Re: [Bacula-users] file listing?

2011-03-15 Thread Phil Stracchino
On 03/15/11 12:41, Kjetil Torgrim Homme wrote: I wrote a script to do this for me, I call it bacula-du, since it accepts many of the same options as du(1), and the output is the same. Usage: bacula-du [OPTIONS] -j JOBID Summarize disk usage of directories included in the backup JOBID

Re: [Bacula-users] file listing?

2011-03-15 Thread Dan Langille
On 3/15/2011 12:41 PM, Kjetil Torgrim Homme wrote: I wrote a script to do this for me, I call it bacula-du, since it accepts many of the same options as du(1), and the output is the same. Usage: bacula-du [OPTIONS] -j JOBID Summarize disk usage of directories included in the backup JOBID

Re: [Bacula-users] file listing?

2011-03-13 Thread Dan Langille
On 3/12/2011 9:33 PM, ganiuszka wrote: W dniu 13 marca 2011 01:01 użytkownik Dan Langilled...@langille.org napisał: On 3/12/2011 9:29 AM, ganiuszka wrote: W dniu 11 marca 2011 21:45 użytkownik ganiuszkaganius...@gmail.com napisał: Hi, In my example jobid is putting in: ...

Re: [Bacula-users] file listing?

2011-03-13 Thread ganiuszka
Hi, Thank you for feedback again. Yes, the BCMath module is not in default configuration if you will compile PHP. In case compilation from sources need to add --enable-bcmath to configuration parameters. On some GNU/Linux distributions the BCMath is as default in PHP (Debian, Slackware) and on

Re: [Bacula-users] file listing?

2011-03-12 Thread ganiuszka
Hi, I wrote the Bacula LStat decoder implementation in PHP. I made WebGUI for this also. Now online LStat decoder (beta version) is available on my page Bacula.pl: http://www.bacula.pl/bacula-lstat-decoder/ In the near future I need to make description of fields. Here is Bacula LStat decoder

Re: [Bacula-users] file listing?

2011-03-12 Thread Dan Langille
On 3/12/2011 9:29 AM, ganiuszka wrote: W dniu 11 marca 2011 21:45 użytkownik ganiuszkaganius...@gmail.com napisał: Hi, In my example jobid is putting in: ... File.JobId=8... but this eight: base64_decode_lstat(8,File.LStat) is exactly eight field (encoded filesize field). I seem that you

Re: [Bacula-users] file listing?

2011-03-12 Thread ganiuszka
Hi, First, many thanks for your feedback. I researched that behaviour with filesize of your lstat field ( -1443891641). Yes, I made mistake with using shift bitwise operator. From PHP documentation: Warning! Don't right shift for more than 32 bits on 32 bits systems. Don't left shift in case it

Re: [Bacula-users] file listing?

2011-03-11 Thread Dan Langille
On 3/9/2011 5:36 PM, ganiuszka wrote: 2011/3/9 Mike Egglestonmikee...@mac.com: Afternoon, I just noticed one of my clients had a huge incremental (level 2) backup. I want to see what file caused the huge increase. I tried 'list files jobid=20097' and though I'm shown the files, I'm not

Re: [Bacula-users] file listing?

2011-03-11 Thread ganiuszka
Hi, In my example jobid is putting in: ... File.JobId=8... but this eight: base64_decode_lstat(8,File.LStat) is exactly eight field (encoded filesize field). I seem that you used standard base64 decoder to decode eighth field. Am I right? Bacula lstat is encoded by using non-standard base64

Re: [Bacula-users] file listing?

2011-03-09 Thread James Woodward
Hello Mike, I'd have to say no based on the tables defined here http://bacula.org/5.0.x-manuals/en/developers/developers/Database_Tables.html. The file size does not appear to be stored in the database. I don't think any size is mentioned until you get to the job level. James On

Re: [Bacula-users] file listing?

2011-03-09 Thread John Drescher
2011/3/9 James Woodward james.woodw...@ualberta.ca: Hello Mike, I'd have to say no based on the tables defined here http://bacula.org/5.0.x-manuals/en/developers/developers/Database_Tables.html. The file size does not appear to be stored in the database. I don't think any size is mentioned

Re: [Bacula-users] file listing?

2011-03-09 Thread Mike Eggleston
On Wed, 09 Mar 2011, John Drescher might have said: 2011/3/9 James Woodward james.woodw...@ualberta.ca: Hello Mike, I'd have to say no based on the tables defined here http://bacula.org/5.0.x-manuals/en/developers/developers/Database_Tables.html. The file size does not appear to be

Re: [Bacula-users] file listing?

2011-03-09 Thread John Drescher
On Wed, Mar 9, 2011 at 4:52 PM, Mike Eggleston mikee...@mac.com wrote: On Wed, 09 Mar 2011, John Drescher might have said: 2011/3/9 James Woodward james.woodw...@ualberta.ca: Hello Mike, I'd have to say no based on the tables defined here 

Re: [Bacula-users] file listing?

2011-03-09 Thread ganiuszka
Hi, Here you have SQL function for PostgreSQL (I took it from bweb): CREATE PROCEDURAL LANGUAGE plpgsql; BEGIN; CREATE OR REPLACE FUNCTION base64_decode_lstat(int4, varchar) RETURNS int8 AS $$ DECLARE val int8; b64 varchar(64); size varchar(64); i int; BEGIN size := split_part($2, ' ', $1); b64