Re: [Bacula-users] Tape mount problem with autochanger

2007-08-13 Thread Timo Neuvonen
 I have a quite fresh install of Bacula 2.03 on CentOS5 (~RHEL5)
 Tape drive is Exabyte VXA-320 w/ 10-slot autochanger.
 Now, when there is a need for the autochanger to jump to another tape
 (because of eg. expired volume duration, that was set to only 15 mins for
 this debugging) Bacula properly calls mtx-changer script, unloads and 
 loads
 the tapes, but the new tape won't get mounted.
 Manual mount command solves this, but the need to execute it effectively
 eliminates the benefits of an autochanger anyway...
 Any idea what causes this behaviour, and how to fix it?

 Autochanger {
   Name = Exabyte Autoloader
   Device = VXA320
   Changer Command = /etc/bacula/mtx-changer %c %o %S %a %d
   Changer Device = /dev/sg2
 }
 Try adding
 AutomaticMount = yes

 to the changer section.

Results in:
Config error: Keyword AutomaticMount not permitted in this resource.

So it obviously needs to be only in the Device resource.

Btw, is this line documented somewhere, saying what it really does, where it 
should be used, if there is some default value, etc?
Using Acrobat Readers's find- command, I only found config file examples in 
the Bacula 2.0.3 manual, but no explanation at all.


 Also check line 167ff in the mtx-changer script and increase the
 sleep time if necessary.

Now I increased this by a factor of 4. Should be enough, I guess.


I'm getting an idea that maybe the problem had something to do with a forced 
system shutdown that took place earlier the same day due to exceptionally 
long power outage (The Power Company had messed with a 110 kV line, it 
hadn't been unpowered yet as they thought before grounding it for some 
maintenance work...)
Anyway, it looks to me like Bacula had gotten a little bit confused with 
something after the next power-up. I'll try to debug that further some day, 
the problem with this is that the only autochanger I have is in a file 
server that can't be shut down whenever I'd like to test something...

--
TiN 



-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] can't load library: libmysqlclient_r.so.15

2007-08-13 Thread Rich
On 2007.08.10. 01:29, Jarrod Lewis-Peacock wrote:
...
 /etc/bacula/bin/bacula-dir: error while loading shared libraries: 
 libmysqlclient_r.so.15: cannot open shared object file: No such file or 
 directory

how did you install bacula (that is, did you compile it yourself or from 
packages) ?

do you have a file named libmysqlclient_r.so.15 anywhere at all ?

 I searched the archives  manual to find the solution of setting the 
 LD_LIBRARY_PATH to the appropriate mysql library, and also hard coding 
 this in /etc/ld.so.conf.
 
  LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/mysql/lib/
  export LD_LIBRARY_PATH
 
 I did this and still get the linking problem.
 I verified that /usr/local/mysql/lib/ is accessible which it is, and it 
 has the file libmysqlclient_r.a in there, which I assume is what is 
 needed for libmysqlclient_r.so.15.
 
 Any further suggestions?
 
 Thanks,
 Jarrod
-- 
  Rich

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] I/O error

2007-08-13 Thread Martijn de Munnik
Hi,

I've installed Bacula on Solaris 10 machine and have been using it  
with an Exabyte VXA tape library. I get this error and then Bacula  
continues with the next tape. I can still use the tapes for restore  
(tried it) but why is this going wrong? I tried the btape test and it  
ran without any errors.

01-Jul 01:26 chet-dir: Start Backup JobId 715, Job=Mail_Job. 
2007-07-01_00.05.01
01-Jul 01:31 chet-sd: Mail_Job.2007-07-01_00.05.01 Error: block.c:569  
Write error at 194:12946 on device Exabyte VXA-2 Drive (/dev/rmt/ 
0cbn). ERR=I/O error.
01-Jul 01:32 chet-sd: Mail_Job.2007-07-01_00.05.01 Error: Error  
writing final EOF to tape. This Volume may not be readable.
dev.c:1687 ioctl MTWEOF error on Exabyte VXA-2 Drive (/dev/rmt/ 
0cbn). ERR=I/O error.
01-Jul 01:32 chet-sd: End of medium on Volume A005  
Bytes=77,950,752,768 Blocks=1,208,313 at 01-Jul-2007 01:32.

Thanks,
Martijn


-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] thanks!

2007-08-13 Thread Kern Sibbald
Hello,

I'm copying this to the lists, because they will probably be interested in 
this.

On Monday 13 August 2007 03:50, Bachman Kharazmi wrote:
 Hi Kern
 First I would like to thank you for good software!
 I've been a bacula user for a few days, and I'm really impressed so far.
 It's very well documented (like obsd where I come from).

Thanks. :-)


 I've been playing around with 1.38.10 which is the version coming with
 debian :/
 With debian running(director) 1.38 I had poor transfer rates backing up
 a XPhost, something like Bytes/s=250 and now when I compiled 2.2.0 from
 source I've Bytes/sec=2,797,999 ;) I donno why, but it's quite a good
 improvement.

Yes, there are a very good number of performance enhancements in 2.2.0 
compared to prior versions.  I cannot say exactly why you have such a big 
difference, but I'm very pleased that it is in the right direction, though I 
admit such a big change is a bit surprising.  

If you are using SQLite3, you will have at least a 30 times speedup on 2.2.0 
compared to other versions, with a small additional risk of database 
corruption if your disk fills or your OS crashes.  PostgreSQL (and probably 
MySQL) should have at least a factor of 10 improvement for Full backups. 

For Win32 systems, one of the big problems has been Ethernet cards/OS that do 
not gracefully handle comm buffer sizes greater than 32K.  I cannot exactly 
remember, but I think I reduced the default on Win32 to 32K, while on Unix, 
it is typically 64K.


 Anyhow, I sent a message to the bacula-user ML admin below, about that I
 couldn't register with my gmail account, but I haven't heard anything
 from him.
 Do you know if he's on vacation or something?

Well, it is possible that he is on vacation as most of Europe shuts down in 
August :-).  In any case, I regret there is nothing he can do for you. Source 
Forge does not accept complaints about individual problems from us -- they 
require the person concerned to file a support request.  I suggest before 
filing a support request you look at the email documentation on their site -- 
they have a lot of anti-spam requirements, but their documentation is quite 
complete.

Best regards,

Kern


 have a nice day!
 /Bachman

  Ursprungligt meddelande 
 Ämne: bacula-users
 Datum:Sat, 11 Aug 2007 02:35:14 +0200
 Från: Bachman Kharazmi [EMAIL PROTECTED]
 Till: [EMAIL PROTECTED]



 Why don't I get any confirmation email when I try to subscribe to
 bacula-users ML?
 Please check if you can help me with this.
 /Bachman

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Tapes are not rewinded

2007-08-13 Thread Martijn de Munnik
Hi,

I'm trying to setup a backup server and face the following problem. I  
already setup a Bacula system using a Exabyte VXA tape library. This  
system is using a Seagate LTO library and I get this error when using  
the tapes (only a small amount of data is written on the tape). The  
tapes are before with another system (a windows backup system) and I  
cleaned them all using the following script:

### begin cleanalltapes ###
#!/usr/bin/bash

### Where are the binaries
MTXCHANGER=/opt/csw/etc/bacula/mtx-changer
MTX=/opt/csw/sbin/mtx
MT=/usr/bin/mt

CHANGER=/dev/scsi/changer/c3t5d0
DRIVE=/dev/rmt/0

SVCADM=/usr/sbin/svcadm
SVCNAME=cswbacula

TIME=time -p

### The script
echo Disabling Bacula
$SVCADM disable $SVCNAME

echo Unloading current tape
$TIME $MTX -f $CHANGER unload

for i in 1 2 3 4 5 6 7 8
do
 echo Loading tape $i
 $TIME $MTXCHANGER $CHANGER load $i $DRIVE 0
 echo Retension the tape
 $TIME $MT -f $DRIVE retension
 echo Writing 2 eof marks to remove the label
 $TIME $MT -f $DRIVE weof 2
 echo Rewinding the tape
 $TIME $MT -f $DRIVE rewind
 echo Unloading tape $i
 $TIME $MTXCHANGER $CHANGER unload $i $DRIVE 0
done

echo Enabling Bacula
$SVCADM enable $SVCNAME
### end cleanalltapes ###

I replaced the first rewind with a retension command but that doesn't  
help.
loading the tape takes about 56.16 seconds
retension takes about 289.94 seconds
writing 2 eof takes about 7.19 seconds
rewinding takes about 0.02 seconds
unloading the tape takes about 36.72 seconds
I don't get any errors with this script.

this is the error when running a backup:

12-Aug 16:37 popa-dir: No prior Full backup Job record found.
12-Aug 16:37 popa-dir: No prior or suitable Full backup found in  
catalog. Doing FULL backup.
12-Aug 16:37 popa-dir: Start Backup JobId 42, Job=YoungGuns_Linux. 
2007-08-12_16.37.47
12-Aug 16:45 popa-sd: YoungGuns_Linux.2007-08-12_16.37.47 Error:  
block.c:569 Write error at 1:15157 on device Certance LTO Drive (/ 
dev/rmt/0cbn). ERR=I/O error.
12-Aug 16:45 popa-sd: YoungGuns_Linux.2007-08-12_16.37.47 Error:  
Error writing final EOF to tape. This Volume may not be readable.
dev.c:1688 ioctl MTWEOF error on Certance LTO Drive (/dev/rmt/ 
0cbn). ERR=I/O error.
12-Aug 16:45 popa-sd: End of medium on Volume TAPE0017  
Bytes=977,937,408 Blocks=15,158 at 12-Aug-2007 16:45.
12-Aug 16:46 popa-sd: 3307 Issuing autochanger unload slot 1, drive  
0 command.
12-Aug 16:47 popa-sd: 3304 Issuing autochanger load slot 2, drive 0  
command.
12-Aug 16:48 popa-sd: 3305 Autochanger load slot 2, drive 0, status  
is OK.
12-Aug 16:48 popa-sd: 3301 Issuing autochanger loaded? drive 0  
command.
12-Aug 16:48 popa-sd: 3302 Autochanger loaded? drive 0, result is  
Slot 2.
12-Aug 16:48 popa-sd: Labeled new Volume TAPE0018 on device  
Certance LTO Drive (/dev/rmt/0cbn).
12-Aug 16:49 popa-sd: Wrote label to prelabeled Volume TAPE0018 on  
device Certance LTO Drive (/dev/rmt/0cbn)
12-Aug 16:49 popa-sd: New volume TAPE0018 mounted on device  
Certance LTO Drive (/dev/rmt/0cbn) at 12-Aug-2007 16:49.
12-Aug 17:06 popa-sd: YoungGuns_Linux.2007-08-12_16.37.47 Error:  
block.c:569 Write error at 0:9205 on device Certance LTO Drive (/ 
dev/rmt/0cbn). ERR=I/O error.
12-Aug 17:06 popa-sd: YoungGuns_Linux.2007-08-12_16.37.47 Error:  
Error writing final EOF to tape. This Volume may not be readable.
dev.c:1688 ioctl MTWEOF error on Certance LTO Drive (/dev/rmt/ 
0cbn). ERR=I/O error.
12-Aug 17:06 popa-sd: End of medium on Volume TAPE0018  
Bytes=593,832,960 Blocks=9,204 at 12-Aug-2007 17:06.
12-Aug 17:08 popa-sd: 3307 Issuing autochanger unload slot 2, drive  
0 command.
12-Aug 17:08 popa-sd: 3304 Issuing autochanger load slot 3, drive 0  
command.
12-Aug 17:09 popa-sd: 3305 Autochanger load slot 3, drive 0, status  
is OK.
12-Aug 17:09 popa-sd: 3301 Issuing autochanger loaded? drive 0  
command.
12-Aug 17:09 popa-sd: 3302 Autochanger loaded? drive 0, result is  
Slot 3.
12-Aug 17:10 popa-sd: Labeled new Volume TAPE0019 on device  
Certance LTO Drive (/dev/rmt/0cbn).
12-Aug 17:10 popa-sd: Wrote label to prelabeled Volume TAPE0019 on  
device Certance LTO Drive (/dev/rmt/0cbn)
12-Aug 17:10 popa-sd: New volume TAPE0019 mounted on device  
Certance LTO Drive (/dev/rmt/0cbn) at 12-Aug-2007 17:10.
12-Aug 17:11 popa-sd: YoungGuns_Linux.2007-08-12_16.37.47 Error:  
block.c:569 Write error at 0:2760 on device Certance LTO Drive (/ 
dev/rmt/0cbn). ERR=I/O error.
12-Aug 17:11 popa-sd: YoungGuns_Linux.2007-08-12_16.37.47 Error:  
Error writing final EOF to tape. This Volume may not be readable.
dev.c:1688 ioctl MTWEOF error on Certance LTO Drive (/dev/rmt/ 
0cbn). ERR=I/O error.
12-Aug 17:11 popa-sd: End of medium on Volume TAPE0019  
Bytes=178,053,120 Blocks=2,759 at 12-Aug-2007 17:11.
12-Aug 17:11 popa-sd: 3307 Issuing autochanger unload slot 3, drive  
0 command.


-
This SF.net email is 

[Bacula-users] SQL Query

2007-08-13 Thread Erich Prinz

Had a failure occur that prevented the usual running of Full backups.

Looking for a 'how to' query to find the most recent Full backup of  
all clients to see how far off we are into Incrementals / Diffs from  
an actual Full.

Any SQL gurus on the list that can help?

Erich

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] can't load library: libmysqlclient_r.so.15

2007-08-13 Thread MaxxAtWork
On 8/10/07, Jarrod Lewis-Peacock [EMAIL PROTECTED] wrote:

 Hello,

 I'm re-installing Bacula using MySQL instead of SQLite. I'm having problems
 linking with a mysql shared library.

  ./bacula start
 Starting the Bacula Storage daemon
 Starting the Bacula File daemon
 Starting the Bacula Director daemon
 /etc/bacula/bin/bacula-dir: error while loading shared libraries:
 libmysqlclient_r.so.15: cannot open shared object file: No such file or
 directory


Hi,

have you tried to check with 'ldd /etc/bacula/bin/bacula-dir' whether
the binary has a problem finding that library? In my (Debian)
installation that library is actually in /usr/lib/.
What if at least as a test you try to manually copy it there?

-- 
Maxx

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Tapes are not rewinded

2007-08-13 Thread John Drescher
On 8/13/07, Martijn de Munnik [EMAIL PROTECTED] wrote:
 Hi,

 I'm trying to setup a backup server and face the following problem. I
 already setup a Bacula system using a Exabyte VXA tape library. This
 system is using a Seagate LTO library and I get this error when using
 the tapes (only a small amount of data is written on the tape). The
 tapes are before with another system (a windows backup system) and I
 cleaned them all using the following script:

 ### begin cleanalltapes ###
 #!/usr/bin/bash

 ### Where are the binaries
 MTXCHANGER=/opt/csw/etc/bacula/mtx-changer
 MTX=/opt/csw/sbin/mtx
 MT=/usr/bin/mt

 CHANGER=/dev/scsi/changer/c3t5d0
 DRIVE=/dev/rmt/0

 SVCADM=/usr/sbin/svcadm
 SVCNAME=cswbacula

 TIME=time -p

 ### The script
 echo Disabling Bacula
 $SVCADM disable $SVCNAME

 echo Unloading current tape
 $TIME $MTX -f $CHANGER unload

 for i in 1 2 3 4 5 6 7 8
 do
  echo Loading tape $i
  $TIME $MTXCHANGER $CHANGER load $i $DRIVE 0
  echo Retension the tape
  $TIME $MT -f $DRIVE retension
  echo Writing 2 eof marks to remove the label
  $TIME $MT -f $DRIVE weof 2
  echo Rewinding the tape
  $TIME $MT -f $DRIVE rewind
  echo Unloading tape $i
  $TIME $MTXCHANGER $CHANGER unload $i $DRIVE 0
 done

 echo Enabling Bacula
 $SVCADM enable $SVCNAME
 ### end cleanalltapes ###

 I replaced the first rewind with a retension command but that doesn't
 help.
 loading the tape takes about 56.16 seconds
 retension takes about 289.94 seconds
 writing 2 eof takes about 7.19 seconds
 rewinding takes about 0.02 seconds
 unloading the tape takes about 36.72 seconds
 I don't get any errors with this script.

I am very confused at what exactly you are trying to do. I know for a
fact that you do not have to rewind  LTO media because this media has
one spool on the drive and a second on the tape so for the drive to
physically unload the tape the drive performs a rewind.

 this is the error when running a backup:

 12-Aug 16:37 popa-dir: No prior Full backup Job record found.
 12-Aug 16:37 popa-dir: No prior or suitable Full backup found in
 catalog. Doing FULL backup.
 12-Aug 16:37 popa-dir: Start Backup JobId 42, Job=YoungGuns_Linux.
 2007-08-12_16.37.47
 12-Aug 16:45 popa-sd: YoungGuns_Linux.2007-08-12_16.37.47 Error:
 block.c:569 Write error at 1:15157 on device Certance LTO Drive (/
 dev/rmt/0cbn). ERR=I/O error.
 12-Aug 16:45 popa-sd: YoungGuns_Linux.2007-08-12_16.37.47 Error:
 Error writing final EOF to tape. This Volume may not be readable.
 dev.c:1688 ioctl MTWEOF error on Certance LTO Drive (/dev/rmt/
 0cbn). ERR=I/O error.
 12-Aug 16:45 popa-sd: End of medium on Volume TAPE0017
 Bytes=977,937,408 Blocks=15,158 at 12-Aug-2007 16:45.
snip

Have you tested the backup by restoring the data somewhere else or run
a Verify job with job level set at VolumeToCatalog? These errors may
not actually be errors.

For me just as labeling a brand new tape always produces a read error
as os gives an error when you try to read past the end of the written
media and since the tape is blank you can not read anything.

John

John

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Problems building BAT

2007-08-13 Thread Florian Schürfeld
Hi there,

i got some problems while building BAT from source.
During make i encounter the following errors:

[...]
Makefile:1340: Warnung: Die Befehle für das Ziel »moc/moc_help.cpp«
werden überschrieben
Makefile:1268: Warnung: Alte Befehle für das Ziel »moc/moc_help.cpp«
werden ignoriert
/usr/share/qt3/bin/uic run/estimate.ui -o ui/estimate.h
uic: File generated with too recent version of Qt Designer (4.0 vs.
3.3.7)
make[1]: *** [ui/estimate.h] Fehler 1
make[1]: Leaving directory `/usr/src/bacula-2.2.0/src/qt-console'

I use a Debian Etch i386 and tried both with the Debian qt4/qwt Packages
and the depkgs-qt-30Jul07.tar.gz from sourceforge.

-- 
Florian Schürfeld [EMAIL PROTECTED]
nunet AG


-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] configuration weirdness

2007-08-13 Thread Rich
first, generic problem - --enable-client-only parameter for configure. 
as far as i understand, this switch is supposed to disable building of 
director  sd.

it's pretty unintuitive, as it would have been much better if all three 
components had individual switches with identical behaviour (each switch 
would enable that particular component).

second - bacula 2.2.0. running configure with --enable-client-only shows 
at the end of the configuration :

   client-only:yes
   build-dird: yes
   build-stored:   yes

it seems that either the parameter is incorrectly named or not working ?
-- 
  Rich

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Problems building BAT

2007-08-13 Thread Marc Schiffbauer
* Florian Schürfeld schrieb am 13.08.07 um 15:29 Uhr:
 Hi there,
 
 i got some problems while building BAT from source.
 During make i encounter the following errors:
 
 [...]
 Makefile:1340: Warnung: Die Befehle für das Ziel »moc/moc_help.cpp«
 werden überschrieben
 Makefile:1268: Warnung: Alte Befehle für das Ziel »moc/moc_help.cpp«
 werden ignoriert
 /usr/share/qt3/bin/uic run/estimate.ui -o ui/estimate.h
 uic: File generated with too recent version of Qt Designer (4.0 vs.
 3.3.7)
 make[1]: *** [ui/estimate.h] Fehler 1
 make[1]: Leaving directory `/usr/src/bacula-2.2.0/src/qt-console'
 
 I use a Debian Etch i386 and tried both with the Debian qt4/qwt Packages
 and the depkgs-qt-30Jul07.tar.gz from sourceforge.
 


Hi Florian,

it is very likely that your system uses the wrong (== old 3.x)
versions of qmake and friends.

See update-alternatives to make it use the qt4 versions.

-Marc

-- 
begin  LOVE-LETTER-FOR-YOU.txt.vbs
I am a signature virus. Distribute me until the bitter
end

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] SQL Query

2007-08-13 Thread Alan Brown
On Mon, 13 Aug 2007, Erich Prinz wrote:


 Had a failure occur that prevented the usual running of Full backups.

 Looking for a 'how to' query to find the most recent Full backup of
 all clients to see how far off we are into Incrementals / Diffs from
 an actual Full.

 Any SQL gurus on the list that can help?

I don't have exactly what you're after (A bit of guru attention would 
solve that) but these should do as a starting point...

Just append them to /etc/bacula/query.sql

If you want to only see sucessful backups, uncomment the
# AND JobStatus = 'T' lines - I commented those out in order to see 
how much tape was being eaten by failure.



#20
:List Volumes by Jobs:
SELECT Job.Name as JobName, Job.JobId as JobID, VolumeName,
  Job.StartTime as Start, sum(JobFiles) AS Files,sum(JobBytes) AS Bytes
  FROM Job,JobMedia,Media
  WHERE JobMedia.JobId=Job.JobId
  AND JobMedia.MediaId=Media.MediaId
  GROUP by VolumeName, Job.JobID, Job.Name, Job.StartTime
  ORDER by JobName, Start;
# 21
:List Volumes for a jobname:
*Enter Job name:
SELECT Job.Name as JobName, Job.JobId as JobID, VolumeName, Job.StartTime 
as
  Start, sum(JobFiles) AS Files,sum(JobBytes) AS Bytes
  FROM Job,JobMedia,Media
  WHERE Job.Name='%1'
  AND JobMedia.JobId=Job.JobId
  AND JobMedia.MediaId=Media.MediaId
  GROUP by VolumeName, Job.JobID, Job.Name, Job.StartTime
  ORDER by JobName, Start;
#22
:List all Full backups
SELECT DISTINCT Job.JobId,Job.Name,Job.Level AS L,Job.JobStatus as S,
  StartTime,JobBytes/1024/1024/1024 as Gb FROM Client,Job,JobMedia,Media
  WHERE Client.ClientId=Job.ClientId AND Level='F'
#AND JobStatus = 'T'
  AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
  ORDER BY Job.Name,Job.StartTime
#23
:List all Full + Differential backups
SELECT DISTINCT Job.JobId,Job.Name,Job.Level AS L,Job.JobStatus as S,
  StartTime,JobBytes/1024/1024/1024 as Gb FROM Client,Job,JobMedia,Media
  WHERE Client.ClientId=Job.ClientId
# AND JobStatus = 'T'
  AND ( Level='F' or Level=D )
  AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
  ORDER BY Job.Name,Job.StartTime
#24
:List all Full backups for a particular Job
*Enter JobName:
SELECT DISTINCT Job.JobId,Job.Name,Job.Level AS L,Job.JobStatus as S,
  StartTime,JobBytes/1024/1024/1024 as Gb FROM Client,Job,JobMedia,Media
  WHERE Client.ClientId=Job.ClientId
# AND JobStatus = 'T'
  AND Level='F'
  AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
  AND Job.Name='%1'
  ORDER BY Job.Name,Job.StartTime
#25
:List all Full + Differential backups for a particular Job
*Enter JobName:
SELECT DISTINCT Job.JobId,Job.Name,Job.Level AS L,Job.JobStatus as S,
  StartTime,JobBytes/1024/1024/1024 as Gb FROM Client,Job,JobMedia,Media
  WHERE Client.ClientId=Job.ClientId
# AND JobStatus = 'T'
  AND ( Level='F' or Level=D )
  AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
  AND Job.Name='%1'
  ORDER BY Job.Name,Job.StartTime
#26
:List all backups for a particular Job
*Enter JobName:
SELECT DISTINCT Job.JobId,Job.Name,Job.Level AS L,Job.JobStatus as S,
  StartTime,JobBytes/1024/1024/1024 as Gb FROM Client,Job,JobMedia,Media
  WHERE Client.ClientId=Job.ClientId
# AND JobStatus = 'T'
# AND ( Level='F' or Level=D )
  AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
  AND Job.Name='%1'
  ORDER BY Job.Name,Job.StartTime


-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] i need help in performing partial backups of /usr/home

2007-08-13 Thread Monstad


It looks like your whole directory is being copied because of the

File = /mnt/san/usr/home/

Try removing this

Cheers,
Kris



Jordi Moles wrote:
 
 hi, i would like to backup just something like
 
 /usr/home/a*
 
 
 reading bacula's documentation, i came up with this fileset:
 
 FileSet {
   Name = sanab
   Include {
  Options {
 wilddir = /mnt/san/usr/home/a*
 wilddir = /mnt/san/usr/home/b*
  }
  File = /mnt/san/usr/home/
   }
 }
 
 
 
 this is exactly the example that they show you, except that i replaced 
 /usr/home with /mnt/san/usr/home cause it's my situation.
 /mnt/san/usr/home is a mounted device through nfs. does that have any 
 effect on the backup wilddir rules?
 
 well.. .that doens't work, it just makes a backup of the whole 
 /mnt/san/usr/home.
 
 I'm using version 2.0.3 of bacula dir.
 
 
 
 -
 This SF.net email is sponsored by: Splunk Inc.
 Still grepping through log files to find problems?  Stop.
 Now Search log events and configuration files using AJAX and a browser.
 Download your FREE copy of Splunk now   http://get.splunk.com/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users
 
 

-- 
View this message in context: 
http://www.nabble.com/i-need-help-in-performing-partial-backups-of--usr-home-tf4262132.html#a12129242
Sent from the Bacula - Users mailing list archive at Nabble.com.


-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] i need help in performing partial backups of /usr/home

2007-08-13 Thread Jordi Moles
hi, i would like to backup just something like

/usr/home/a*


reading bacula's documentation, i came up with this fileset:

FileSet {
  Name = sanab
  Include {
 Options {
wilddir = /mnt/san/usr/home/a*
wilddir = /mnt/san/usr/home/b*
 }
 File = /mnt/san/usr/home/
  }
}



this is exactly the example that they show you, except that i replaced 
/usr/home with /mnt/san/usr/home cause it's my situation.
/mnt/san/usr/home is a mounted device through nfs. does that have any 
effect on the backup wilddir rules?

well.. .that doens't work, it just makes a backup of the whole 
/mnt/san/usr/home.

I'm using version 2.0.3 of bacula dir.



-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] i need help in performing partial backups of /usr/home

2007-08-13 Thread Jordi Moles
Hi,

what you told me makes an empty backup, it doesn't backup anything at 
all, 0 files. However it doesn't say it failed, it doesn't send any 
error message.

any other idea?

thank you.

En/na Monstad ha escrit:
 It looks like your whole directory is being copied because of the

 File = /mnt/san/usr/home/

 Try removing this

 Cheers,
 Kris



 Jordi Moles wrote:
   
 hi, i would like to backup just something like

 /usr/home/a*


 reading bacula's documentation, i came up with this fileset:

 FileSet {
   Name = sanab
   Include {
  Options {
 wilddir = /mnt/san/usr/home/a*
 wilddir = /mnt/san/usr/home/b*
  }
  File = /mnt/san/usr/home/
   }
 }



 this is exactly the example that they show you, except that i replaced 
 /usr/home with /mnt/san/usr/home cause it's my situation.
 /mnt/san/usr/home is a mounted device through nfs. does that have any 
 effect on the backup wilddir rules?

 well.. .that doens't work, it just makes a backup of the whole 
 /mnt/san/usr/home.

 I'm using version 2.0.3 of bacula dir.



 -
 This SF.net email is sponsored by: Splunk Inc.
 Still grepping through log files to find problems?  Stop.
 Now Search log events and configuration files using AJAX and a browser.
 Download your FREE copy of Splunk now   http://get.splunk.com/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users


 

   


-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] i need help in performing partial backups of /usr/home

2007-08-13 Thread Monstad


Hi there,

Whenever I've used the wilddir option Ive had use an include = yes line in
the Options section. I use an earlier version of bacula however, but it
might work for you. 

ie: 

 FileSet {
   Name = sanab
   Options {
 wilddir = /mnt/san/usr/home/a*
 wilddir = /mnt/san/usr/home/b*
 include = yes
  }
   }
 }

Hope that works for you

-Kris




Jordi Moles wrote:
 
 Hi,
 
 what you told me makes an empty backup, it doesn't backup anything at 
 all, 0 files. However it doesn't say it failed, it doesn't send any 
 error message.
 
 any other idea?
 
 thank you.
 
 En/na Monstad ha escrit:
 It looks like your whole directory is being copied because of the

 File = /mnt/san/usr/home/

 Try removing this

 Cheers,
 Kris



 Jordi Moles wrote:
   
 hi, i would like to backup just something like

 /usr/home/a*


 reading bacula's documentation, i came up with this fileset:

 FileSet {
   Name = sanab
   Include {
  Options {
 wilddir = /mnt/san/usr/home/a*
 wilddir = /mnt/san/usr/home/b*
  }
  File = /mnt/san/usr/home/
   }
 }



 this is exactly the example that they show you, except that i replaced 
 /usr/home with /mnt/san/usr/home cause it's my situation.
 /mnt/san/usr/home is a mounted device through nfs. does that have any 
 effect on the backup wilddir rules?

 well.. .that doens't work, it just makes a backup of the whole 
 /mnt/san/usr/home.

 I'm using version 2.0.3 of bacula dir.



 -
 This SF.net email is sponsored by: Splunk Inc.
 Still grepping through log files to find problems?  Stop.
 Now Search log events and configuration files using AJAX and a browser.
 Download your FREE copy of Splunk now   http://get.splunk.com/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users


 

   
 
 
 -
 This SF.net email is sponsored by: Splunk Inc.
 Still grepping through log files to find problems?  Stop.
 Now Search log events and configuration files using AJAX and a browser.
 Download your FREE copy of Splunk now   http://get.splunk.com/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users
 
 

-- 
View this message in context: 
http://www.nabble.com/i-need-help-in-performing-partial-backups-of--usr-home-tf4262132.html#a12129583
Sent from the Bacula - Users mailing list archive at Nabble.com.


-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] i need help in performing partial backups of /usr/home

2007-08-13 Thread Jordi Moles
hi again and thanks for you help.

i doesn't work either. i tried include=yes and other things like exclude 
= no.
actually, with include=yes, bacula throws the following message:

Config error: Keyword include not permitted in this resource


En/na Monstad ha escrit:
 Hi there,

 Whenever I've used the wilddir option Ive had use an include = yes line in
 the Options section. I use an earlier version of bacula however, but it
 might work for you. 

 ie: 

  FileSet {
Name = sanab
Options {
  wilddir = /mnt/san/usr/home/a*
  wilddir = /mnt/san/usr/home/b*
  include = yes
   }
}
  }

 Hope that works for you

 -Kris




 Jordi Moles wrote:
   
 Hi,

 what you told me makes an empty backup, it doesn't backup anything at 
 all, 0 files. However it doesn't say it failed, it doesn't send any 
 error message.

 any other idea?

 thank you.

 En/na Monstad ha escrit:
 
 It looks like your whole directory is being copied because of the

 File = /mnt/san/usr/home/

 Try removing this

 Cheers,
 Kris



 Jordi Moles wrote:
   
   
 hi, i would like to backup just something like

 /usr/home/a*


 reading bacula's documentation, i came up with this fileset:

 FileSet {
   Name = sanab
   Include {
  Options {
 wilddir = /mnt/san/usr/home/a*
 wilddir = /mnt/san/usr/home/b*
  }
  File = /mnt/san/usr/home/
   }
 }



 this is exactly the example that they show you, except that i replaced 
 /usr/home with /mnt/san/usr/home cause it's my situation.
 /mnt/san/usr/home is a mounted device through nfs. does that have any 
 effect on the backup wilddir rules?

 well.. .that doens't work, it just makes a backup of the whole 
 /mnt/san/usr/home.

 I'm using version 2.0.3 of bacula dir.



 -
 This SF.net email is sponsored by: Splunk Inc.
 Still grepping through log files to find problems?  Stop.
 Now Search log events and configuration files using AJAX and a browser.
 Download your FREE copy of Splunk now   http://get.splunk.com/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users


 
 
   
   
 -
 This SF.net email is sponsored by: Splunk Inc.
 Still grepping through log files to find problems?  Stop.
 Now Search log events and configuration files using AJAX and a browser.
 Download your FREE copy of Splunk now   http://get.splunk.com/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users


 

   


-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] i need help in performing partial backups of /usr/home

2007-08-13 Thread Jan Dohl
Jordi Moles wrote:
 hi, i would like to backup just something like

 /usr/home/a*


 reading bacula's documentation, i came up with this fileset:

 FileSet {
   Name = sanab
   Include {
  Options {
 wilddir = /mnt/san/usr/home/a*
 wilddir = /mnt/san/usr/home/b*
  }
  File = /mnt/san/usr/home/
   }
 }



 this is exactly the example that they show you, except that i replaced 
 /usr/home with /mnt/san/usr/home cause it's my situation.
 /mnt/san/usr/home is a mounted device through nfs. does that have any 
 effect on the backup wilddir rules?

 well.. .that doens't work, it just makes a backup of the whole 
 /mnt/san/usr/home.

 I'm using version 2.0.3 of bacula dir.



 -
 This SF.net email is sponsored by: Splunk Inc.
 Still grepping through log files to find problems?  Stop.
 Now Search log events and configuration files using AJAX and a browser.
 Download your FREE copy of Splunk now   http://get.splunk.com/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users
   

Hi,

try adding the following options-block in addition to your current one:

Options {
regexdir = .*
exclude = yes
}

This should exclude every directory except the ones you have explicitly
included in the first options-block.

Hope that helps,
Jan


-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] finding qt for Bat on FreeBSD

2007-08-13 Thread Dan Langille
I'm trying to build Bat on FreeBSD.  What configure options did you 
use?  I have:

--enable-bat
--with-qwt=/usr/lib


I have qt4-4.3.0 installed.

-- 
Dan Langille - http://www.langille.org/
Available for hire: http://www.freebsddiary.org/dan_langille.php



-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] SQL Query

2007-08-13 Thread Erich Prinz
Wonderful. This is a good start.

Thanks Alan.

Erich


On Aug 13, 2007, at 10:40 AM, Alan Brown wrote:

 On Mon, 13 Aug 2007, Erich Prinz wrote:


 Had a failure occur that prevented the usual running of Full backups.

 Looking for a 'how to' query to find the most recent Full backup of
 all clients to see how far off we are into Incrementals / Diffs from
 an actual Full.

 Any SQL gurus on the list that can help?

 I don't have exactly what you're after (A bit of guru attention would
 solve that) but these should do as a starting point...

 Just append them to /etc/bacula/query.sql

 If you want to only see sucessful backups, uncomment the
 # AND JobStatus = 'T' lines - I commented those out in order to see
 how much tape was being eaten by failure.



 #20
 :List Volumes by Jobs:
 SELECT Job.Name as JobName, Job.JobId as JobID, VolumeName,
   Job.StartTime as Start, sum(JobFiles) AS Files,sum(JobBytes) AS  
 Bytes
   FROM Job,JobMedia,Media
   WHERE JobMedia.JobId=Job.JobId
   AND JobMedia.MediaId=Media.MediaId
   GROUP by VolumeName, Job.JobID, Job.Name, Job.StartTime
   ORDER by JobName, Start;
 # 21
 :List Volumes for a jobname:
 *Enter Job name:
 SELECT Job.Name as JobName, Job.JobId as JobID, VolumeName,  
 Job.StartTime
 as
   Start, sum(JobFiles) AS Files,sum(JobBytes) AS Bytes
   FROM Job,JobMedia,Media
   WHERE Job.Name='%1'
   AND JobMedia.JobId=Job.JobId
   AND JobMedia.MediaId=Media.MediaId
   GROUP by VolumeName, Job.JobID, Job.Name, Job.StartTime
   ORDER by JobName, Start;
 #22
 :List all Full backups
 SELECT DISTINCT Job.JobId,Job.Name,Job.Level AS L,Job.JobStatus as S,
   StartTime,JobBytes/1024/1024/1024 as Gb FROM  
 Client,Job,JobMedia,Media
   WHERE Client.ClientId=Job.ClientId AND Level='F'
 #AND JobStatus = 'T'
   AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
   ORDER BY Job.Name,Job.StartTime
 #23
 :List all Full + Differential backups
 SELECT DISTINCT Job.JobId,Job.Name,Job.Level AS L,Job.JobStatus as S,
   StartTime,JobBytes/1024/1024/1024 as Gb FROM  
 Client,Job,JobMedia,Media
   WHERE Client.ClientId=Job.ClientId
 # AND JobStatus = 'T'
   AND ( Level='F' or Level=D )
   AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
   ORDER BY Job.Name,Job.StartTime
 #24
 :List all Full backups for a particular Job
 *Enter JobName:
 SELECT DISTINCT Job.JobId,Job.Name,Job.Level AS L,Job.JobStatus as S,
   StartTime,JobBytes/1024/1024/1024 as Gb FROM  
 Client,Job,JobMedia,Media
   WHERE Client.ClientId=Job.ClientId
 # AND JobStatus = 'T'
   AND Level='F'
   AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
   AND Job.Name='%1'
   ORDER BY Job.Name,Job.StartTime
 #25
 :List all Full + Differential backups for a particular Job
 *Enter JobName:
 SELECT DISTINCT Job.JobId,Job.Name,Job.Level AS L,Job.JobStatus as S,
   StartTime,JobBytes/1024/1024/1024 as Gb FROM  
 Client,Job,JobMedia,Media
   WHERE Client.ClientId=Job.ClientId
 # AND JobStatus = 'T'
   AND ( Level='F' or Level=D )
   AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
   AND Job.Name='%1'
   ORDER BY Job.Name,Job.StartTime
 #26
 :List all backups for a particular Job
 *Enter JobName:
 SELECT DISTINCT Job.JobId,Job.Name,Job.Level AS L,Job.JobStatus as S,
   StartTime,JobBytes/1024/1024/1024 as Gb FROM  
 Client,Job,JobMedia,Media
   WHERE Client.ClientId=Job.ClientId
 # AND JobStatus = 'T'
 # AND ( Level='F' or Level=D )
   AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
   AND Job.Name='%1'
   ORDER BY Job.Name,Job.StartTime


 -- 
 ---
 This SF.net email is sponsored by: Splunk Inc.
 Still grepping through log files to find problems?  Stop.
 Now Search log events and configuration files using AJAX and a  
 browser.
 Download your FREE copy of Splunk now   http://get.splunk.com/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users



-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] i need help in performing partial backups of /usr/home

2007-08-13 Thread Martin Simmons
 On Mon, 13 Aug 2007 18:45:01 +0200, Jordi Moles said:
 
 hi again and thanks for you help.
 
 i doesn't work either. i tried include=yes and other things like exclude 
 = no.
 actually, with include=yes, bacula throws the following message:
 
 Config error: Keyword include not permitted in this resource

I suggest reading the Fileset Example section at
http://www.bacula.org/rel-manual/Configuring_Director.html#SECTION00149
in particular the /home/a* example.

__Martin


 
 
 En/na Monstad ha escrit:
  Hi there,
 
  Whenever I've used the wilddir option Ive had use an include = yes line in
  the Options section. I use an earlier version of bacula however, but it
  might work for you. 
 
  ie: 
 
   FileSet {
 Name = sanab
 Options {
   wilddir = /mnt/san/usr/home/a*
   wilddir = /mnt/san/usr/home/b*
   include = yes
}
 }
   }
 
  Hope that works for you
 
  -Kris
 
 
 
 
  Jordi Moles wrote:

  Hi,
 
  what you told me makes an empty backup, it doesn't backup anything at 
  all, 0 files. However it doesn't say it failed, it doesn't send any 
  error message.
 
  any other idea?
 
  thank you.
 
  En/na Monstad ha escrit:
  
  It looks like your whole directory is being copied because of the
 
  File = /mnt/san/usr/home/
 
  Try removing this
 
  Cheers,
  Kris
 
 
 
  Jordi Moles wrote:


  hi, i would like to backup just something like
 
  /usr/home/a*
 
 
  reading bacula's documentation, i came up with this fileset:
 
  FileSet {
Name = sanab
Include {
   Options {
  wilddir = /mnt/san/usr/home/a*
  wilddir = /mnt/san/usr/home/b*
   }
   File = /mnt/san/usr/home/
}
  }
 
 
 
  this is exactly the example that they show you, except that i replaced 
  /usr/home with /mnt/san/usr/home cause it's my situation.
  /mnt/san/usr/home is a mounted device through nfs. does that have any 
  effect on the backup wilddir rules?
 
  well.. .that doens't work, it just makes a backup of the whole 
  /mnt/san/usr/home.
 
  I'm using version 2.0.3 of bacula dir.
 
 
 
  -
  This SF.net email is sponsored by: Splunk Inc.
  Still grepping through log files to find problems?  Stop.
  Now Search log events and configuration files using AJAX and a browser.
  Download your FREE copy of Splunk now   http://get.splunk.com/
  ___
  Bacula-users mailing list
  Bacula-users@lists.sourceforge.net
  https://lists.sourceforge.net/lists/listinfo/bacula-users
 
 
  
  


  -
  This SF.net email is sponsored by: Splunk Inc.
  Still grepping through log files to find problems?  Stop.
  Now Search log events and configuration files using AJAX and a browser.
  Download your FREE copy of Splunk now   http://get.splunk.com/
  ___
  Bacula-users mailing list
  Bacula-users@lists.sourceforge.net
  https://lists.sourceforge.net/lists/listinfo/bacula-users
 
 
  
 

 
 
 -
 This SF.net email is sponsored by: Splunk Inc.
 Still grepping through log files to find problems?  Stop.
 Now Search log events and configuration files using AJAX and a browser.
 Download your FREE copy of Splunk now   http://get.splunk.com/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users
 

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] [Bacula-devel] finding qt for Bat on FreeBSD

2007-08-13 Thread Martin Simmons
 On Mon, 13 Aug 2007 13:37:28 -0400, Dan Langille said:
 
 I'm trying to build Bat on FreeBSD.  What configure options did you 
 use?  I have:
 
 --enable-bat
 --with-qwt=/usr/lib
 
 
 I have qt4-4.3.0 installed.

Note:  (equal qt qwt)  =  nil

__Martin

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] configuration weirdness

2007-08-13 Thread Martin Simmons
 On Mon, 13 Aug 2007 17:47:36 +0300, Rich  said:
 
 first, generic problem - --enable-client-only parameter for configure. 
 as far as i understand, this switch is supposed to disable building of 
 director  sd.
 
 it's pretty unintuitive, as it would have been much better if all three 
 components had individual switches with identical behaviour (each switch 
 would enable that particular component).

I think it was written like that to match common usage, i.e. server backups
require all components, subsequent client backups only the client components.

Also, both the dird and stored components require a database, so it doesn't
make much difference (to the prerequisites) whether both are built or only one
is built.


 second - bacula 2.2.0. running configure with --enable-client-only shows 
 at the end of the configuration :
 
client-only:yes
build-dird: yes
build-stored:   yes
 
 it seems that either the parameter is incorrectly named or not working ?

It is working, but the configure output is wrong :-)

__Martin

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] How to get SRPM

2007-08-13 Thread Radek Hladik
Hi all,
I would like to try Bacula 2.2.0 however there are no RPMS on 
sourceforge yet and I prefer RPMs to direct installation.
I do not mind compiling my own packages from tarball or SRPM but there 
is no SRPM  anywhere and tarball contains only bacula.spec.in file. How 
can I convert this file into proper spec file so I can use:
rpmbuild -tb bacula.2.2.0.tar.gz ?

Or is there any other way how to create SRPM or RPM packages?

Sorry if this is lame question :-)


Radek


-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Tapes are not rewinded

2007-08-13 Thread John Drescher
  12-Aug 16:45 popa-sd: YoungGuns_Linux.2007-08-12_16.37.47 Error:
  Error writing final EOF to tape. This Volume may not be readable.
  dev.c:1688 ioctl MTWEOF error on Certance LTO Drive (/dev/rmt/
  0cbn). ERR=I/O error.
  12-Aug 16:45 popa-sd: End of medium on Volume TAPE0017
  Bytes=977,937,408 Blocks=15,158 at 12-Aug-2007 16:45.
  snip
 
 Bacula starts on the first tape with the backup but soon it needs the
 second tape and so on. The total size of the job is only about 60GB
 but al 8 tapes are needed and the job still is not completed. As you
 can see only about 1GB is written to the tape.
 

Oh, sorry. I see that now. Then there is some serious problem with the
tape handling. I see in another thread that you are running Solaris.
Have you tried filling the tape with dd or tar to see if it errors
under these as well? Have you run bscan?

John

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] single error = tape useless

2007-08-13 Thread Martin Simmons
 On Sun, 12 Aug 2007 15:57:54 +0200, Carsten Ralle said:
 
 Hi Martin,
 
  1. Even with brand new tapes, on two different tape drives, using
  continuous cleaning cycles, the tapes that used to store between 11.5
  and 13 GB uncompressed data on a windows machine only take about 8 GB
  using bacula (same drive, same tapes).
 
  Following the advice to switch off software compression when hardware
  compression is enabled, we run tests with following results (always the
  same fileset of 23 GB uncompressed data)
 
  hw-compress  sw-compress  spool size  data/tape  total # of tapes used
  on  on   14 GB   8.2 GB  1.7
  on  off  23 GB  12.9 GB  1.8
 
  so we use the installation with both sw and hw compression turned on, as
  it gives us better performance and less tapes/backup.
 
  Why is it impossible to store more then 8 GB on a 12/24GB tape. Again:
  we ran the tests on multiple different drives (HP15xx and Sony
  DDS3-drives).
  
  The problem is that DDS hw compression is not very good.  In particular, 
  when
  you use sw compression as well, the data written to tape actually gets
  expanded by the hw compression so your 8.2 GB of input gets written as 12 GB
  on the tape!
  Have you tried with hw compression off and sw compression on?
 Yes we've tried. On the Sony drives there's a tool that reports
 compression as disabled, but there where no changes in tape capacity,
 though. According to the manual the drive switches are set to control
 compression via software and if we turn off compression on a windows
 box, it's enabled after pluggin the unit back into the Linux box.
 So far we haven't noticed any difference with compression reported ON or
 OFF.

Have you tried setting defcompression?  I.e.

mt -f /dev/... defcompression 0
mt -f /dev/... compression 0

Also, I suggest that you erase the tape after doing this, i.e.

mt -f /dev/... rewind
mt -f /dev/... weof

to prevent the drive from picking up the old compression state from the tape.

__Martin

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] [Bacula-devel] finding qt for Bat on FreeBSD

2007-08-13 Thread Kern Sibbald
On Monday 13 August 2007 21:06, Martin Simmons wrote:
  On Mon, 13 Aug 2007 13:37:28 -0400, Dan Langille said:
 
  I'm trying to build Bat on FreeBSD.  What configure options did you
  use?  I have:
 
  --enable-bat
  --with-qwt=/usr/lib
 
 
  I have qt4-4.3.0 installed.

 Note:  (equal qt qwt)  =  nil

Which translated Lispian to Computerese means that the qwt package is 
different from the qt libraries.  You most likely do not have qwt loaded on 
your system.  See the --with-qwt section of the Install chapter of the manual 
for more details (possibly the README of the src/qt-console file has 
something too).




 __Martin

 -
 This SF.net email is sponsored by: Splunk Inc.
 Still grepping through log files to find problems?  Stop.
 Now Search log events and configuration files using AJAX and a browser.
 Download your FREE copy of Splunk now   http://get.splunk.com/
 ___
 Bacula-devel mailing list
 [EMAIL PROTECTED]
 https://lists.sourceforge.net/lists/listinfo/bacula-devel

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Random tape capacity figures

2007-08-13 Thread Ivan Adzhubey
Hi,

I am running bacula 1.36.1 with Qualstar RLS-4445 autochanger and a single DDS 
tape drive installed. The tapes used are all Sony SDX3-100C (100GB 
native/260GB compressed capacity). I have noticed that VolBytes and VolFiles 
values vary widely for tapes marked as Full in media list command (see 
attached listing). E.g., volume with MediaId 146 have only 30MB VolBytes and 
0 (sic!) VolFiles reported but still marked as Full, pretty strange. Another 
one listed as Full has about 600MB and also 0 files. Someone can suggest any 
plausible explanation or is it more likely that something is wrong with the 
catalog records? How I can check the actual tape usage?

Thanks,
Ivan


The information transmitted in this electronic communication is intended only 
for the person or entity to whom it is addressed and may contain confidential 
and/or privileged material. Any review, retransmission, dissemination or other 
use of or taking of any action in reliance upon this information by persons or 
entities other than the intended recipient is prohibited. If you received this 
information in error, please contact the Compliance HelpLine at 800-856-1983 
and properly dispose of this information.
+-+--+---+-+--+--+-+--+---+---+-+
| MediaId | VolumeName   | VolStatus | VolBytes| VolFiles | 
VolRetention | Recycle | Slot | InChanger | MediaType | LastWritten |
+-+--+---+-+--+--+-+--+---+---+-+
|  74 | Mutation0017 | Recycle   |   1 |0 |   
15,552,000 |   1 |   12 | 1 | SDX700-C  | 2007-02-08 09:42:03 |
|  75 | Mutation0018 | Full  | 126,481,428,324 |  184 |   
15,552,000 |   1 |   17 | 1 | SDX700-C  | 2007-08-11 09:52:04 |
| 125 | Mutation0019 | Full  | 168,438,772,847 |  269 |   
15,552,000 |   1 |   18 | 1 | SDX700-C  | 2007-03-19 14:24:03 |
| 128 | Mutation0021 | Full  | 162,310,533,731 |  297 |   
15,552,000 |   1 |   20 | 1 | SDX700-C  | 2007-03-02 03:36:07 |
| 138 | Mutation0022 | Full  | 141,488,133,324 |  245 |   
15,552,000 |   1 |   19 | 1 | SDX700-C  | 2007-07-04 01:20:28 |
| 139 | Mutation0023 | Full  | 135,611,484,198 |  209 |   
15,552,000 |   1 |9 | 1 | SDX700-C  | 2007-06-11 01:31:51 |
| 140 | Mutation0024 | Full  | 149,275,192,825 |  190 |   
15,552,000 |   1 |   10 | 1 | SDX700-C  | 2007-07-14 07:08:41 |
| 145 | Mutation0026 | Full  | 601,703,410 |0 |   
15,552,000 |   1 |4 | 1 | SDX700-C  | 2007-07-14 08:11:21 |
| 146 | Mutation0027 | Full  |  30,578,689 |0 |   
15,552,000 |   1 |   12 | 0 | SDX700-C  | 2007-07-14 08:13:42 |
| 147 | Mutation0028 | Full  |  51,807,004,964 |   51 |   
15,552,000 |   1 |   13 | 1 | SDX700-C  | 2007-07-14 08:07:34 |
| 148 | Mutation0029 | Full  | 146,737,757,815 |  205 |   
15,552,000 |   1 |   14 | 1 | SDX700-C  | 2007-07-31 01:20:07 |
| 168 | Mutation0030 | Full  | 138,498,653,248 |  293 |   
15,552,000 |   1 |   15 | 1 | SDX700-C  | 2007-05-24 05:14:13 |
| 169 | Mutation0031 | Full  | 163,567,868,856 |  330 |   
15,552,000 |   1 |   11 | 1 | SDX700-C  | 2007-04-17 13:05:24 |
+-+--+---+-+--+--+-+--+---+---+-+
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] [Bacula-devel] finding qt for Bat on FreeBSD

2007-08-13 Thread Dan Langille
On 13 Aug 2007 at 20:06, Martin Simmons wrote:

  On Mon, 13 Aug 2007 13:37:28 -0400, Dan Langille said:
  
  I'm trying to build Bat on FreeBSD.  What configure options did you 
  use?  I have:
  
  --enable-bat
  --with-qwt=/usr/lib

Offlist, and I discovered myself, that this needs to be 
/usr/local/lib
  
  
  I have qt4-4.3.0 installed.
 
 Note:  (equal qt qwt)  =  nil

Thanks.  Fixed. I'm now using qwt, not qt.  cheers.


Does this error mean anything to anyone?

==Entering directory /usr/home/dan/src/bacula-bat/work/bacula-
2.2.0/src/qt-console
make: don't know how to make depend. Stop
*** Error code 1
 
Stop in /usr/home/dan/src/bacula-bat/work/bacula-2.2.0.
Creating bat Makefile
QMAKESPEC has not been set, so configuration cannot be deduced.
Error processing project file: /usr/home/dan/src/bacula-
bat/work/bacula-2.2.0/src/qt-console/bat.pro


-- 
Dan Langille - http://www.langille.org/
Available for hire: http://www.freebsddiary.org/dan_langille.php



-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Random tape capacity figures

2007-08-13 Thread John Drescher
 I am running bacula 1.36.1 with Qualstar RLS-4445 autochanger and a single DDS
 tape drive installed. The tapes used are all Sony SDX3-100C (100GB
 native/260GB compressed capacity). I have noticed that VolBytes and VolFiles
 values vary widely for tapes marked as Full in media list command (see
 attached listing).

Getting between 126GB and 168GB on your 100GB tapes is absolutely
normal (the other 3 tapes are a problem) assuming that you are not
backing up the exact data every time. This compression rate is not
outside the range of compression that I and of lot of others see.
Remember compressed data will not compress a second time so reaching
the magical 2.0 or 2.6 compression rate the manufacturer will assume
that you have no compressed files (.zip, .jpeg, .mpg ...) in your
backup or that if you do have some of these files then the bulk of
your data is plain text files which are generally highly compressible.

E.g., volume with MediaId 146 have only 30MB VolBytes and
 0 (sic!) VolFiles reported but still marked as Full, pretty strange. Another
 one listed as Full has about 600MB and also 0 files.
I agree with that. There is something wrong there. My first thought is
that you had a setting that expired the volume after the fist job but
then there would be at least 1 volfile written so this does not make
sense. Have you ran the btape tests that are in the manual?

http://www.bacula.org/dev-manual/Testing_Your_Tape_Drive.html#btape1

 Someone can suggest any
 plausible explanation or is it more likely that something is wrong with the
 catalog records?
I doubt that as if your database were corrupt I would expect to see
some really weird numbers.

 How I can check the actual tape usage?
I am not aware of a non destructive and reliable way of doing that.

In normal operation Bacula writes to a tape until it either hits the
end of the tape or an error.

John

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] can't load library: libmysqlclient_r.so.15

2007-08-13 Thread Jarrod Lewis-Peacock
Thanks for the suggestion Maxx.

I have since completely removed the bacula install, and the mysql install,
and re-intalled both fresh. Somehow, magically, the library linking works
now. One of those cases where I don't know precisely what the problem was,
but it resolved itself with fresh installs, so be it.

Jarrod

On 8/13/07, MaxxAtWork [EMAIL PROTECTED] wrote:

 On 8/10/07, Jarrod Lewis-Peacock [EMAIL PROTECTED] wrote:

  Hello,
 
  I'm re-installing Bacula using MySQL instead of SQLite. I'm having
 problems
  linking with a mysql shared library.
 
   ./bacula start
  Starting the Bacula Storage daemon
  Starting the Bacula File daemon
  Starting the Bacula Director daemon
  /etc/bacula/bin/bacula-dir: error while loading shared libraries:
  libmysqlclient_r.so.15: cannot open shared object file: No such file or
  directory
 

 Hi,

 have you tried to check with 'ldd /etc/bacula/bin/bacula-dir' whether
 the binary has a problem finding that library? In my (Debian)
 installation that library is actually in /usr/lib/.
 What if at least as a test you try to manually copy it there?

 --
 Maxx

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users