Re: [Bacula-users] multiple spool files per job
James Harper wrote: Is there a way to make bacula write multiple spool files per job? Two would do. What I'm seeing is that 4 jobs start, all hit their spool limit around the same time, then all wait in a queue until the file is despooled. The despool happens fairly quickly (much quicker than the spooling due to network and server fd throughput) so it isn't a huge problem, but it would be better if the sd could just switch over to another spool file when despooling starts so that the backup can continue uninterrupted. I believe this is in the todo list, but it will happen faster if someone submits already-written code. -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula disk to tape config
On Fri, 2011-09-30 at 18:08 -0400, Dan Langille wrote: On Sep 27, 2011, at 12:42 PM, René Moser wrote: On Tue, 2011-09-27 at 16:51 +0100, Gavin McCullagh wrote: It sounds like what you're looking for could be implemented as: 1. A normal Full/Differential/Incremental job to a disk-based storage device to happen during the day. 2. A Migrate job to tape from disk to happen during the night. Yep, http://www.bacula.org/manuals/en/concepts/concepts/Migration_Copy.html is what I was looking for. Key point: A migrate or copy job can involved exactly one SD. Therefore, you cannot copy between SD. Thus, your single SD involved in this must store both the disk and the tape backups. I am not sure if I understand your point. SD = Storage Device, I guess. I can not migrate between a file storage device, to a tape storage device? But http://www.bacula.org/manuals/en/concepts/concepts/Migration_Copy.html#SECTION00164 does exactly show this by example right? Thanks for explaining again :) -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula disk to tape config
On Mon, 10 Oct 2011 14:13:26 +0200 René Moser r...@adfinis.com wrote: [...] SD = Storage Device, I guess. I can not migrate between a file storage device, to a tape storage device? [...] SD stands for Storage Daemon--it's a program which manages one or more storage devices available on the host a particular SD instance runs on. What you have been told, I suppose, is that migrate jobs can't cross SDs which means you cannot migrate a backup jobs which storage media is managed by an SD running on one host to a storage media managed by an SD running on another host. The reason for this, I supposed, is that this would require SDs to transfer data over the wire between themselves while normally data only flows between FDs and SDs. -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula disk to tape config
The reason for this, I supposed, is that this would require SDs to transfer data over the wire between themselves while normally data only flows between FDs and SDs. That is correct. Storage Daemons do not currently communicate. John -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Freebsd snapshots and complaints Will not descend
Listers, I'm having intermittent issues with a backup job that completes OK but complains saying Will not descend into various user folders within a jail. Over the weekend this job ran twice and on the first occasion it complained about a larger set than on the second occasion. Although many of the same complaints were generated by both jobs. The file daemon is running on FreeBSD 7.3-RELEASE-p4, bacula-client-5.0.2, and takes snapshots of the jails and mounts them for the director. The director daemon is running FreeBSD 8.2-RELEASE-p3, bacula-server-5.0.3, and has the following config for this server: FileSet{ Name = foobar Include { Options { Compression = GZIP signature = SHA1 Sparse = yes Hardlinks = no } @/usr/local/etc/backuplist/foobar_backuplist }} Pool { Name = foobarF Pool Type = Backup Storage = kfoobarb Maximum Volume Jobs = 4 Maximum Volume Bytes = 270g Volume Use Duration = 2d Volume Retention = 10 days Catalog Files = yes Label Format = foobarF- Recycle = yes AutoPrune = yes } Job { Name = Foobar_Backup Enabled = Yes#[Yes|NO] Type = Backup #[Backup,Restore,Verify,Admin] Level= Full Accurate= yes #[Yes|No] Client = tao-fd Fileset = foobar Schedule = WeeklyCycle Storage = kfoobarb Messages = Standard Pool = foobarF Write Bootstrap = /data/working/foobar.bsr Priority = 40 } #cat /usr/local/etc/foobar_backuplist File = /mnt/foobar/usr File = /mnt/foobar/var File = /mnt/foobar/etc File = /mnt/foobar/root Given the intermittent nature of this I tend to think it is more likely something outside bacula, perhaps the snapshot as daily I have unexplained complaints from an unrelated rsync process, on the same snapshot: rsync: writefd_unbuffered failed to write 4 bytes to socket [sender]: Broken pipe (32) rsync: read error: Connection reset by peer (54) rsync error: error in rsync protocol data stream (code 12) at io.c(760) [sender=3.0.8] Any comments about the config or troubleshooting thought would be really appreciated. Thank you Troy Kocher -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Freebsd snapshots and complaints Will not descend
On Mon, 10 Oct 2011 11:03:58 -0500, Troy Kocher said: I'm having intermittent issues with a backup job that completes OK but complains saying Will not descend into various user folders within a jail. Over the weekend this job ran twice and on the first occasion it complained about a larger set than on the second occasion. Although many of the same complaints were generated by both jobs. You didn't post the job logs so it is impossible to know why did will not descend. __Martin -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Fwd: Freebsd snapshots and complaints Will not descend
Listers, I'm having intermittent issues with a backup job that completes OK but complains saying Will not descend into various user folders within a jail. Over the weekend this job ran twice and on the first occasion it complained about a larger set than on the second occasion. Although many of the same complaints were generated by both jobs. The file daemon is running on FreeBSD 7.3-RELEASE-p4, bacula-client-5.0.2, and takes snapshots of the jails and mounts them for the director. The director daemon is running FreeBSD 8.2-RELEASE-p3, bacula-server-5.0.3, and has the following config for this server: FileSet{ Name = foobar Include { Options { Compression = GZIP signature = SHA1 Sparse = yes Hardlinks = no } @/usr/local/etc/backuplist/foobar_backuplist }} Pool { Name = foobarF Pool Type = Backup Storage = kfoobarb Maximum Volume Jobs = 4 Maximum Volume Bytes = 270g Volume Use Duration = 2d Volume Retention = 10 days Catalog Files = yes Label Format = foobarF- Recycle = yes AutoPrune = yes } Job { Name = Foobar_Backup Enabled = Yes#[Yes|NO] Type = Backup #[Backup,Restore,Verify,Admin] Level= Full Accurate= yes #[Yes|No] Client = tao-fd Fileset = foobar Schedule = WeeklyCycle Storage = kfoobarb Messages = Standard Pool = foobarF Write Bootstrap = /data/working/foobar.bsr Priority = 40 } #cat /usr/local/etc/foobar_backuplist File = /mnt/foobar/usr File = /mnt/foobar/var File = /mnt/foobar/etc File = /mnt/foobar/root Truncated job log: 08-Oct 09:11 kfoobarb-dir JobId 2858: Start Backup JobId 2858, Job=foobar_Backup.2011-10-08_08.00.01_01 08-Oct 09:11 kfoobarb-dir JobId 2858: Using Device kfoobarbpool 08-Oct 09:10 jailhost-fd JobId 2858: DIR and FD clocks differ by -29 seconds, FD automatically compensating. 08-Oct 09:11 kfoobarb-dir JobId 2858: Sending Accurate information. 08-Oct 09:11 kfoobarb-sd JobId 2858: Volume foobarF-0011 previously written, moving to end of data. 08-Oct 09:11 kfoobarb-sd JobId 2858: Ready to append to end of Volume foobarF-0011 size=1031166 08-Oct 23:48 jailhost-fd JobId 2858: /mnt/foobar/usr/home/ltartmp is a different filesystem. Will not descend from /mnt/foobar/usr into /mnt/foobar/usr/home/ltartmp 08-Oct 23:48 jailhost-fd JobId 2858: /mnt/foobar/usr/home/ltlclerk is a different filesystem. Will not descend from /mnt/foobar/usr into /mnt/foobar/usr/home/ltlclerk 08-Oct 23:48 jailhost-fd JobId 2858: /mnt/foobar/usr/home/tester is a different filesystem. Will not descend from /mnt/foobar/usr into /mnt/foobar/usr/home/tester 08-Oct 23:48 jailhost-fd JobId 2858: /mnt/foobar/usr/home/purchasing is a different filesystem. Will not descend from /mnt/foobar/usr into /mnt/foobar/usr/home/purchasing 08-Oct 23:48 jailhost-fd JobId 2858: /mnt/foobar/usr/home/whsebol is a different filesystem. Will not descend from /mnt/foobar/usr into /mnt/foobar/usr/home/whsebol 08-Oct 23:48 jailhost-fd JobId 2858: /mnt/foobar/usr/home/sysview is a different filesystem. Will not descend from /mnt/foobar/usr into /mnt/foobar/usr/home/sysview 08-Oct 23:48 jailhost-fd JobId 2858: /mnt/foobar/usr/home/rtessier is a different filesystem. Will not descend from /mnt/foobar/usr into /mnt/foobar/usr/home/rtessier 08-Oct 23:48 jailhost-fd JobId 2858: /mnt/foobar/usr/home2 is a different filesystem. Will not descend from /mnt/foobar/usr into /mnt/foobar/usr/home2 08-Oct 23:57 kfoobarb-sd JobId 2858: Job write elapsed time = 14:45:49, Transfer rate = 2.702 M Bytes/second 08-Oct 23:57 kfoobarb-dir JobId 2858: Bacula kfoobarb-dir 5.0.3 (04Aug10): 08-Oct-2011 23:57:42 Build OS: amd64-portbld-freebsd8.2 freebsd 8.2-RELEASE JobId: 2858 Job: foobar_Backup.2011-10-08_08.00.01_01 Backup Level: Differential, since=2011-09-24 23:52:49 Client: jailhost-fd 5.0.2 (28Apr10) amd64-portbld-freebsd7.2,freebsd,7.2-RELEASE FileSet: foobar 2010-08-21 02:05:01 Pool: foobarF (From Job resource) Catalog: MyCatalog (From Client resource) Storage: kfoobarb (From Pool resource) Scheduled time: 08-Oct-2011 08:00:01 Start time: 08-Oct-2011 09:11:24 End time: 08-Oct-2011 23:57:42 Elapsed time: 14 hours 46 mins 18 secs Priority: 40 FD Files Written: 222,266 foobar SD Files Written: 222,266 FD Bytes Written: 143,571,912,970 (143.5 GB) SD Bytes Written: 143,609,540,425 (143.6 GB) Rate: 2699.8 KB/s Software Compression: 44.5 % VSS: no Encryption: no Accurate: yes Volume name(s): foobarF-0011 Volume Session Id: 59 Volume Session Time: 1317927904 Last Volume Bytes: 154,053,751,603 (154.0 GB) Non-fatal FD errors: 0 SD Errors: 0 FD termination status: OK SD termination status: OK Termination: Backup OK Given the intermittent nature of this I tend to think it is more likely something outside bacula, perhaps the
Re: [Bacula-users] Fwd: Freebsd snapshots and complaints Will not descend
On 10,Oct 2011, at 12:02 PM, David Romerstein wrote: On Mon, Oct 10, 2011 at 12:51 PM, Troy Kocher tkoc...@mtadistributors.com wrote: 08-Oct 23:48 jailhost-fd JobId 2858: /mnt/foobar/usr/home/ltartmp is a different filesystem. Will not descend from /mnt/foobar/usr into /mnt/foobar/usr/home/ltartmp From http://www.sibbald.com/bacula/html-manual/FileSet_Resource.html: Bacula's default for processing directories is to recursively descend in the directory saving all files and subdirectories. Bacula will not by default cross filesystems (or mount points in Unix parlance). This means that if you specify the root partition (e.g. /), Bacula will save only the root partition and not any of the other mounted filesystems. Similarly on Windows systems, you must explicitly specify each of the drives you want saved (e.g. c:/ and d:/ ...). In addition, at least for Windows systems, you will most likely want to enclose each specification within double quotes particularly if the directory (or file) name contains spaces. The df command on Unix systems will show you which mount points you must specify to save everything. -- D Thanks for the response, I'm aware of how recursively descending works. I use it on many other snapshot/jails and haven't had any issues getting other deeply buried folders I need backed up. It works just as the manual describes. There seems to be something unique about how this particular job/snapshot combination behaves, and that is what I'm trying to troubleshoot. Troy -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Fwd: Freebsd snapshots and complaints Will not descend
On Mon, 10 Oct 2011 11:51:14 -0500, Troy Kocher said: Truncated job log: 08-Oct 09:11 kfoobarb-dir JobId 2858: Start Backup JobId 2858, Job=foobar_Backup.2011-10-08_08.00.01_01 08-Oct 09:11 kfoobarb-dir JobId 2858: Using Device kfoobarbpool 08-Oct 09:10 jailhost-fd JobId 2858: DIR and FD clocks differ by -29 seconds, FD automatically compensating. 08-Oct 09:11 kfoobarb-dir JobId 2858: Sending Accurate information. 08-Oct 09:11 kfoobarb-sd JobId 2858: Volume foobarF-0011 previously written, moving to end of data. 08-Oct 09:11 kfoobarb-sd JobId 2858: Ready to append to end of Volume foobarF-0011 size=1031166 08-Oct 23:48 jailhost-fd JobId 2858: /mnt/foobar/usr/home/ltartmp is a different filesystem. Will not descend from /mnt/foobar/usr into /mnt/foobar/usr/home/ltartmp 08-Oct 23:48 jailhost-fd JobId 2858: /mnt/foobar/usr/home/ltlclerk is a different filesystem. Will not descend from /mnt/foobar/usr into /mnt/foobar/usr/home/ltlclerk 08-Oct 23:48 jailhost-fd JobId 2858: /mnt/foobar/usr/home/tester is a different filesystem. Will not descend from /mnt/foobar/usr into /mnt/foobar/usr/home/tester 08-Oct 23:48 jailhost-fd JobId 2858: /mnt/foobar/usr/home/purchasing is a different filesystem. Will not descend from /mnt/foobar/usr into /mnt/foobar/usr/home/purchasing 08-Oct 23:48 jailhost-fd JobId 2858: /mnt/foobar/usr/home/whsebol is a different filesystem. Will not descend from /mnt/foobar/usr into /mnt/foobar/usr/home/whsebol 08-Oct 23:48 jailhost-fd JobId 2858: /mnt/foobar/usr/home/sysview is a different filesystem. Will not descend from /mnt/foobar/usr into /mnt/foobar/usr/home/sysview 08-Oct 23:48 jailhost-fd JobId 2858: /mnt/foobar/usr/home/rtessier is a different filesystem. Will not descend from /mnt/foobar/usr into /mnt/foobar/usr/home/rtessier 08-Oct 23:48 jailhost-fd JobId 2858: /mnt/foobar/usr/home2 is a different filesystem. Will not descend from /mnt/foobar/usr into /mnt/foobar/usr/home2 08-Oct 23:57 kfoobarb-sd JobId 2858: Job write elapsed time = 14:45:49, Transfer rate = 2.702 M Bytes/second Are you running an automounter for home directories? That could explain both the Will not descend messages and also why the warnings vary over time. __Martin -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Fwd: Freebsd snapshots and complaints Will not descend
On 10,Oct 2011, at 1:12 PM, Martin Simmons wrote: On Mon, 10 Oct 2011 11:51:14 -0500, Troy Kocher said: 08-Oct 23:57 kfoobarb-sd JobId 2858: Job write elapsed time = 14:45:49, Transfer rate = 2.702 M Bytes/second Are you running an automounter for home directories? That could explain both the Will not descend messages and also why the warnings vary over time. __Martin I'm not running an automounter. And as I mentioned this error is intermittent. I run this job incremental daily without complaint, I get this issue on the differential weekly run. Regarding the time warning, I corrected this once by forcing an ntp on the fd client. I think my ntp must not be running properly over there. Beginning to feel like it's something with the snapshot (/mnt/foobar) not responding as a normal file system under load, and telling bacula-fd access is delayed/denied/?, then bacula understands the delay as device unreachable? Troy -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Problems configuring 5.0.1 with bat
Hi, I move the DIR/SD to a new motherboard and linux version. Before it was running FC 14 and now it is running Centos 5.7. The motherboard was an upgrade that was much needed. I am using the configure script that was used previously to build Bacula ( it was also used to build a test system ). Both of these build were/are configured to us BAT. I have installed Qt, meaning I can run the designer from the prompt without any problems. I have changed my PATH to include the Qt installation. But, when I run configure I am getting the following error: configure: error: Unable to find Qt4 installation needed by bat I have included the configure output, it shows that it is able to find gmake the the Qt directory but I don't know what it is looking for at this point. Any help is appreciated, thanks. checking for true... /bin/true checking for false... /bin/false configuring for Bacula 5.0.1 (24 February 2010) checking for gcc... gcc checking whether the C compiler works... yes checking for C compiler default output file name... a.out checking for suffix of executables... checking whether we are cross compiling... no checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ISO C89... none needed checking for g++... g++ checking whether we are using the GNU C++ compiler... yes checking whether g++ accepts -g... yes checking whether gcc and cc understand -c and -o together... yes checking how to run the C preprocessor... gcc -E checking for grep that handles long lines and -e... /bin/grep checking for egrep... /bin/grep -E checking whether gcc needs -traditional... no checking for g++... /usr/bin/g++ checking for a BSD-compatible install... /usr/bin/install -c checking for mv... /bin/mv checking for rm... /bin/rm checking for cp... /bin/cp checking for sed... /bin/sed checking for echo... /bin/echo checking for cmp... /usr/bin/cmp checking for tbl... /usr/bin/tbl checking for ar... /usr/bin/ar checking for openssl... /usr/bin/openssl checking for mtx... mtx checking for dd... /bin/dd checking for mkisofs... /usr/bin/mkisofs checking for python... /usr/bin/python checking for growisofs... /usr/bin/growisofs checking for dvd+rw-mediainfo... /usr/bin/dvd+rw-mediainfo checking for dvd+rw-format... /usr/bin/dvd+rw-format checking for pkg-config... /usr/bin/pkg-config checking for qmake... /usr/local/qtsdk-2010.04/qt/bin/qmake checking for gmake... /usr/bin/gmake checking for wx-config... wx-config checking for cdrecord... /usr/bin/cdrecord checking for pidof... /sbin/pidof checking for gawk... gawk checking for gawk... /bin/gawk checking build system type... x86_64-unknown-linux-gnu checking host system type... x86_64-unknown-linux-gnu checking for a sed that does not truncate output... (cached) /bin/sed checking for fgrep... /bin/grep -F checking for ld used by gcc... /usr/bin/ld checking if the linker (/usr/bin/ld) is GNU ld... yes checking for BSD- or MS-compatible name lister (nm)... /usr/bin/nm -B checking the name lister (/usr/bin/nm -B) interface... BSD nm checking whether ln -s works... yes checking the maximum length of command line arguments... 98304 checking whether the shell understands some XSI constructs... yes checking whether the shell understands +=... yes checking for /usr/bin/ld option to reload object files... -r checking for objdump... objdump checking how to recognize dependent libraries... pass_all checking for ar... /usr/bin/ar checking for strip... strip checking for ranlib... ranlib checking command to parse /usr/bin/nm -B output from gcc object... ok checking for ANSI C header files... yes checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking for dlfcn.h... yes checking whether we are using the GNU C++ compiler... (cached) yes checking whether /usr/bin/g++ accepts -g... (cached) yes checking how to run the C++ preprocessor... /usr/bin/g++ -E checking for objdir... .libs checking if gcc supports -fno-rtti -fno-exceptions... no checking for gcc option to produce PIC... -fPIC -DPIC checking if gcc PIC flag -fPIC -DPIC works... yes checking if gcc static flag -static works... yes checking if gcc supports -c -o file.o... yes checking if gcc supports -c -o file.o... (cached) yes checking whether the gcc linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes checking whether -lc should be explicitly linked in... no checking dynamic linker characteristics... GNU/Linux ld.so checking how to hardcode library paths into programs... immediate checking whether stripping libraries is possible... yes checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static
Re: [Bacula-users] Problems configuring 5.0.1 with bat
On 10/10/2011 04:51 PM, jerry lowry wrote: Hi, I move the DIR/SD to a new motherboard and linux version. Before it was running FC 14 and now it is running Centos 5.7. The motherboard was an upgrade that was much needed. I am using the configure script that was used previously to build Bacula ( it was also used to build a test system ). Both of these build were/are configured to us BAT. I have installed Qt, meaning I can run the designer from the prompt without any problems. I have changed my PATH to include the Qt installation. But, when I run configure I am getting the following error: configure: error: Unable to find Qt4 installation needed by bat I have included the configure output, it shows that it is able to find gmake the the Qt directory but I don't know what it is looking for at this point. Any help is appreciated, thanks. -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2d-oct ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users Okay, so I forgot the configure statementits been that kind of a day.. ./configure \ --sbindir=/usr/bacula/bin \ --sysconfdir=/usr/bacula/bin \ --with-pid-dir=/var/run/bacula \ --with-subsys-dir=/var/run/bacula/working \ --enable-smartalloc \ --with-mysql \ --with-working-dir=/usr/bacula/bin/working \ --with-dump-email=jlo...@edt.com \ --with-job-email=jlo...@edt.com \ --with-smtp-host=mailhost.edt.com \ --enable-tray-monitor \ --enable-bat \ --enable-bwx-console \ --with-python=/usr/lib/python2.4 \ --with-x -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2d-oct___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] query for file sizes in a job
2011/10/7 Jeff Shanholtz jeffs...@shanholtz.com: Thanks guys. I'm pretty sure I'm using sqlite (having a hard time determining that definitively, but I don't think I did anything from an installation point of view beyond just installing bacula). I assume this script is postgresql specific. Looks like the fastest option for me is going to be to simply search the drives of my 3 client systems for large files and then check to see if any of those files are being backed up when they don't need to be. Hi, I wrote a PHP script for getting files sizes and path of backup files by JobId value. It has also possibility setting sorting method files sizes and setting unit for sizes (bytes, kilobytes, megabytes etc.). I think that in your case this script may be useful. I know that there is possibility to write functions in SQLite, and maybe it is a good way to realize all algorithms from my script. In spite of it I used PHP script method. Yes, I remember thread about decoding LStat value on this mailing list. In that time I wrote PHP implementation of Bacula LStat decoder in PHP. Now, I used this for decoding the LStat value in below script. I hope that it will be useful. Any suggestions and bugs are welcome. I did not test this script too hard. I did the only basic tests. Before using script you need to edit constat named 'DB_FILE' which contains string with localization of SQLite database file. Regards. gani ?php /** * Script for listing sizes and paths files for selected JobId from SQLite Bacula database. * * @author gani redak...@bacula.pl * * Requirements * PHP with modules: * - BC Math * - PDO for SQLite * * Example of use for jobid: 23, sort: asc, unit: megabytes: * * php bacula-size-and-path-by-jobid.php 23 asc m * * Examle output: * 12 | /etc/aaa.conf * 14 | /etc/bbb.conf * 21 | /etc/ccc.conf */ // NOTE! Before run this script please update SQLite database file localization. const DB_FILE = '/tmp/bacula/var/bacula/working/bacula.db'; class BaculaJobDetails { private $joibid; private $order; private $unit; private $order_size_values = array('asc', 'desc'); private $units = array('b' = 1, 'k' = 1024, 'm' = 1048576, 'g' = 1073741824, 't' = 1099511627776); public function __construct($jobid, $order, $unit) { $this-jobid = intval($jobid); $this-order = $this-validate_order($order); $this-unit = $this-validate_unit($unit); } private function validate_order($order) { $order = strtolower($order); if(!in_array($order, $this-order_size_values)) { die('You entered wrong sort order. Available sort orders are: asc or desc'); } return $order; } private function validate_unit($unit) { $unit = strtolower($unit); if(!array_key_exists($unit, $this-units)) { die('You entered wrong unit. Available units are: b, k, m, g, t'); } return $unit; } private function decode_bacula_lstat($lstat) { $base64 = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/'; $lstat = trim($lstat); $lstat_fields = explode(' ', $lstat); if(count($lstat_fields) !== 16) { die('Error! Invalid LStat values count for ' . $lstat); } list($dev, $inode, $mode, $nlink, $uid, $gid, $rdev, $size, $blocksize, $blocks, $atime, $mtime, $ctime, $linkfi, $flags, $data) = $lstat_fields; $encoded_values = array('dev' = $dev, 'inode' = $inode, 'mode' = $mode, 'nlink' = $nlink, 'uid' = $uid, 'gid' = $gid, 'rdev' = $rdev, 'size' = $size, 'blocksize' = $blocksize, 'blocks' = $blocks, 'atime' = $atime, 'mtime' = $mtime, 'ctime' = $ctime, 'linkfi' = $linkfi, 'flags' = $flags, 'data' = $data); $ret = array(); foreach($encoded_values as $key = $val) { $result = 0; $is_minus = false; $start = 0; if(substr($val, 0, 1) === '-') { $is_minus = true; $start++; } for($i = $start; $i strlen($val); $i++) { $result = bcmul($result, bcpow(2,6)); $result += strpos($base64, substr($val, $i , 1)); } $ret[$key] = ($is_minus === true) ? -$result : $result; } return $ret; } private function get_db() { $dsn = 'sqlite:' . DB_FILE; try { $db = new PDO($dsn); } catch (PDOException $e) {