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-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 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 f

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-13 Thread Dan Langille
On 3/12/2011 9:33 PM, ganiuszka wrote: > W dniu 13 marca 2011 01:01 użytkownik Dan Langille > napisał: >> On 3/12/2011 9:29 AM, ganiuszka wrote: >>> >>> W dniu 11 marca 2011 21:45 użytkownik ganiuszka >>> napisał: Hi, In my example jobid is putting in: ... File.JobId=8... >>

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 i

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 ganiuszka 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, 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 fu

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 al

Re: [Bacula-users] file listing?

2011-03-11 Thread Dan Langille
On 3/9/2011 5:36 PM, ganiuszka wrote: > 2011/3/9 Mike Eggleston: >> 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 shown the

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 :

Re: [Bacula-users] file listing?

2011-03-09 Thread John Drescher
On Wed, Mar 9, 2011 at 4:52 PM, Mike Eggleston wrote: > On Wed, 09 Mar 2011, John Drescher might have said: > >> 2011/3/9 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. >

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 : > > 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.

Re: [Bacula-users] file listing?

2011-03-09 Thread John Drescher
2011/3/9 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

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 2011-03-09,

[Bacula-users] file listing?

2011-03-09 Thread Mike Eggleston
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 shown the size of each file. Is there a command or query that shows me the size of the fil