Re: [Bacula-users] Other SMTP Client than bsmtp.

2011-07-19 Thread Phil Stracchino
On 07/19/11 12:57, Rickifer Barros wrote:
> Hello Guys...
> 
> Can I use another SMTP client than bsmtp, like sendEmail? I've tried put
> the mailcommand based on sendEmail, sending the message to a Third Party
> Email Server but it didn't worked.

Absolutely you can.  I set up my message commands to use mutt as the
mailer.  Example:

  mailcommand = "/usr/bin/mutt -F /root/.muttrc-bacula -s \"Storage
alert\" %r"



-- 
  Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
  ala...@caerllewys.net   ala...@metrocast.net   p...@co.ordinate.org
  Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
 It's not the years, it's the mileage.

--
Magic Quadrant for Content-Aware Data Loss Prevention
Research study explores the data loss prevention market. Includes in-depth
analysis on the changes within the DLP market, and the criteria used to
evaluate the strengths and weaknesses of these DLP solutions.
http://www.accelacomm.com/jaw/sfnl/114/51385063/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] database claims tape has data, but tape is empty

2011-07-19 Thread mark . bergman
I'm running bacula 5.02, writing to tape. Bacula correctly recognizes tapes in
the library by barcode, and database entries exist for each piece of media.
However, some of the tapes may not be labeled (this may be due to a fault in
our in-house script that labels new media).

The odd thing is that bacula shows the unlabeled tapes as being in specific
pools (not "Scratch", as originally assigned), and shows the volume status as
"Append".

Here are some command excerpts to illustrate the issue:

--- tape with barcode 003234, from slot 9 is loaded in drive 1 --
mtx -f /dev/changer-ml6000 status |head
  Storage Changer /dev/changer-ml6000:2 Drives, 40 Slots ( 6 Import/Export )
Data Transfer Element 0:Full (Storage Element 3 Loaded):VolumeTag = 003230 
Data Transfer Element 1:Full (Storage Element 9 Loaded):VolumeTag = 003234  


--- btape shows that there's no label --
./btape -v -c /opt/bacula/etc/bacula-sd.conf ml6000-drv1
Tape block granularity is 1024 bytes.
btape: butil.c:284 Using device: "ml6000-drv1" for writing.
19-Jul 18:30 btape JobId 0: 3301 Issuing autochanger "loaded? drive 1" command.
19-Jul 18:31 btape JobId 0: 3302 Autochanger "loaded? drive 1", result is Slot 
9.
btape: btape.c:476 open device "ml6000-drv1" (/dev/tape1-ml6000): OK
*status
 Bacula status: file=0 block=0
 Device status: BOT ONLINE IM_REP_EN file=0 block=0
btape: btape.c:2133 Device status: 645. ERR=
*readlabel
btape: btape.c:525 Volume has no label.

Volume Label:
Id: **error**VerNo : 0
VolName   : 
PrevVolName   : 
VolFile   : 0
LabelType : Unknown 0
LabelSize : 0
PoolName  : 
MediaType : 
PoolType  : 
HostName  : 
Date label written: -4712-01-01 at 00:00

- "dd" finds no data on the tape -
[root@sbia-infr1 bin]# mt -f /dev/tape1-ml6000 rewind
[root@sbia-infr1 bin]# dd if=/dev/tape1-ml6000  of=/tmp/tape_003234.dump
0+0 records in
0+0 records out
0 bytes (0 B) copied, 0.011468 seconds, 0.0 kB/s
[root@sbia-infr1 bin]# file /tmp/tape_003234.dump
/tmp/tape_003234.dump: empty


- bacula thinks that the tape has already been used -
printf "query\n15\n" | ./bconsole | egrep "VolStatus|003234"
| MediaId | VolumeName | GB  | Storage | Slot | Pool| MediaType 
| VolStatus |
|   1,008 | 003234 | 302.4804| ml6000  |9 | Incremental | LTO2  
| Append|


Any ideas?

Mark

--
Magic Quadrant for Content-Aware Data Loss Prevention
Research study explores the data loss prevention market. Includes in-depth
analysis on the changes within the DLP market, and the criteria used to
evaluate the strengths and weaknesses of these DLP solutions.
http://www.accelacomm.com/jaw/sfnl/114/51385063/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Scripting restores?

2011-07-19 Thread Rory Campbell-Lange
On 19/07/11, Jason A. Kates (ja...@kates.org) wrote:
> This is a restore that I have run as just a one off:
> 
> restore client=clientname restoreclient=otherclient pool=Weekly
> where=/mnt/restore select current all done yes
> 
> so if you combine this with passing more in from the script (You can
> even make the script from perl/shell/etc you can do anything.

The ideal, from my point of view, is to construct a boostrap restore
file from a database query.

>From http://www.bacula.org/en/dev-manual/main/main/What_is_Bacula.html

Bootstrap File
The bootstrap file is an ASCII file containing a compact form of
commands that allow Bacula or the stand-alone file extraction
utility (bextract) to restore the contents of one or more Volumes,
for example, the current state of a system just backed up. With a
bootstrap file, Bacula can restore your system without a Catalog.
You can create a bootstrap file from a Catalog to extract any file
or files you wish. 

You may be able to emulate the construction of a bootstrap file by
turning on verbose logging in your database daemon and then running a
manual bconsole restore. From this you will discover the sql queries
required to construct the bootstrap file. The bootstrap file can also be
constructed by doing all the steps to perform a restore then selecting
"no" at the last. A restore.bsr file will then be visible in your
working directory.

http://www.bacula.org/en/dev-manual/main/main/Bootstrap_File.html#22756

Rory

--
Magic Quadrant for Content-Aware Data Loss Prevention
Research study explores the data loss prevention market. Includes in-depth
analysis on the changes within the DLP market, and the criteria used to
evaluate the strengths and weaknesses of these DLP solutions.
http://www.accelacomm.com/jaw/sfnl/114/51385063/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Database performance issue

2011-07-19 Thread Roy Sigurd Karlsbakk
> Starting a file-based restore job, this led to postgresql spending a
> full 15 minutes in a query. Any idea what can be done to fix this?
> 
> http://paste.ubuntu.com/647576/ has a full explain/analyze of the
> query, but so far, I haven't figured out where the problem is. Anyone
> with an idea of how to tune this?

create index file_filenameid on file(filenameid);

I guess that should be part of the FAQ...

Vennlige hilsener / Best regards

roy
--
Roy Sigurd Karlsbakk
(+47) 97542685
r...@karlsbakk.net
http://blogg.karlsbakk.net/
--
I all pedagogikk er det essensielt at pensum presenteres intelligibelt. Det er 
et elementært imperativ for alle pedagoger å unngå eksessiv anvendelse av 
idiomer med fremmed opprinnelse. I de fleste tilfeller eksisterer adekvate og 
relevante synonymer på norsk.

--
Magic Quadrant for Content-Aware Data Loss Prevention
Research study explores the data loss prevention market. Includes in-depth
analysis on the changes within the DLP market, and the criteria used to
evaluate the strengths and weaknesses of these DLP solutions.
http://www.accelacomm.com/jaw/sfnl/114/51385063/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Scripting restores?

2011-07-19 Thread Jason A. Kates
You might combine things...

This is a restore that I have run as just a one off:

restore client=clientname restoreclient=otherclient pool=Weekly
where=/mnt/restore select current all done yes

so if you combine this with passing more in from the script (You can
even make the script from perl/shell/etc you can do anything.


-Jason



On Tue, 2011-07-19 at 21:40 +0200, Roy Sigurd Karlsbakk wrote:
> > > Alternatively you can simply script restores via bconsole.
> > > eg
> > >
> > > bconsole << EOF
> > > restore
> > > 7
> > > /example/DUMP/Archive/P_NW.mxi
> > > /example/ptec/storman_6_amd64.deb
> > > /example/DUMP/CC_Planning_3d.mxs
> > > /example/DUMP/CC_Planning_side.mxi
> > > /example/PLE/3D_N_StageC_.c4d
> > > /example/aw/05 3d/Mark/03/ViewNo01/B
> > > /example/sit/shops/Sheet-000921.pdf
> > > /example/arket/typical_side_winder.psd
> > > /example/2.25/elements2/gtc_.psd
> > > /example/for planners/Tiff/ordnance copy.
> > > /example/102__Binder.pdf
> > > /example/Thomas/rice
> > >
> > > yes
> > > EOF
> > 
> > Any chance of telling bconsole from which job it should extract this?
> 
> Seems this will only pull the latest version from the backup, which isn't 
> really what I want.
> 
> Vennlige hilsener / Best regards
> 
> roy
> --
> Roy Sigurd Karlsbakk
> (+47) 97542685
> r...@karlsbakk.net
> http://blogg.karlsbakk.net/
> --
> I all pedagogikk er det essensielt at pensum presenteres intelligibelt. Det 
> er et elementært imperativ for alle pedagoger å unngå eksessiv anvendelse av 
> idiomer med fremmed opprinnelse. I de fleste tilfeller eksisterer adekvate og 
> relevante synonymer på norsk.
> 
> --
> Magic Quadrant for Content-Aware Data Loss Prevention
> Research study explores the data loss prevention market. Includes in-depth
> analysis on the changes within the DLP market, and the criteria used to
> evaluate the strengths and weaknesses of these DLP solutions.
> http://www.accelacomm.com/jaw/sfnl/114/51385063/
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users

estore
-- 

Jason A. Kates (ja...@kates.org) 
Fax:208-975-1514
Phone:  660-960-0070



--
Magic Quadrant for Content-Aware Data Loss Prevention
Research study explores the data loss prevention market. Includes in-depth
analysis on the changes within the DLP market, and the criteria used to
evaluate the strengths and weaknesses of these DLP solutions.
http://www.accelacomm.com/jaw/sfnl/114/51385063/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Database performance issue

2011-07-19 Thread Roy Sigurd Karlsbakk
Hi all

Starting a file-based restore job, this led to postgresql spending a full 15 
minutes in a query. Any idea what can be done to fix this?

http://paste.ubuntu.com/647576/ has a full explain/analyze of the query, but so 
far, I haven't figured out where the problem is. Anyone with an idea of how to 
tune this?

Vennlige hilsener / Best regards

roy
--
Roy Sigurd Karlsbakk
(+47) 97542685
r...@karlsbakk.net
http://blogg.karlsbakk.net/
--
I all pedagogikk er det essensielt at pensum presenteres intelligibelt. Det er 
et elementært imperativ for alle pedagoger å unngå eksessiv anvendelse av 
idiomer med fremmed opprinnelse. I de fleste tilfeller eksisterer adekvate og 
relevante synonymer på norsk.

--
Magic Quadrant for Content-Aware Data Loss Prevention
Research study explores the data loss prevention market. Includes in-depth
analysis on the changes within the DLP market, and the criteria used to
evaluate the strengths and weaknesses of these DLP solutions.
http://www.accelacomm.com/jaw/sfnl/114/51385063/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Scripting restores?

2011-07-19 Thread Roy Sigurd Karlsbakk
> > Alternatively you can simply script restores via bconsole.
> > eg
> >
> > bconsole << EOF
> > restore
> > 7
> > /example/DUMP/Archive/P_NW.mxi
> > /example/ptec/storman_6_amd64.deb
> > /example/DUMP/CC_Planning_3d.mxs
> > /example/DUMP/CC_Planning_side.mxi
> > /example/PLE/3D_N_StageC_.c4d
> > /example/aw/05 3d/Mark/03/ViewNo01/B
> > /example/sit/shops/Sheet-000921.pdf
> > /example/arket/typical_side_winder.psd
> > /example/2.25/elements2/gtc_.psd
> > /example/for planners/Tiff/ordnance copy.
> > /example/102__Binder.pdf
> > /example/Thomas/rice
> >
> > yes
> > EOF
> 
> Any chance of telling bconsole from which job it should extract this?

Seems this will only pull the latest version from the backup, which isn't 
really what I want.

Vennlige hilsener / Best regards

roy
--
Roy Sigurd Karlsbakk
(+47) 97542685
r...@karlsbakk.net
http://blogg.karlsbakk.net/
--
I all pedagogikk er det essensielt at pensum presenteres intelligibelt. Det er 
et elementært imperativ for alle pedagoger å unngå eksessiv anvendelse av 
idiomer med fremmed opprinnelse. I de fleste tilfeller eksisterer adekvate og 
relevante synonymer på norsk.

--
Magic Quadrant for Content-Aware Data Loss Prevention
Research study explores the data loss prevention market. Includes in-depth
analysis on the changes within the DLP market, and the criteria used to
evaluate the strengths and weaknesses of these DLP solutions.
http://www.accelacomm.com/jaw/sfnl/114/51385063/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Volumes Getting Marked as Error

2011-07-19 Thread Mike Hobbs
I have bacula v5.0.3 and Vchanger woring well for a few months now.  I 
noticed in one of my backup job logs that there was an error with a 
volume so bacula marked the volume as Error in the catalog.  I did a 
little looking around and I found that quite a few of my volumes have 
been marked as Error.  I should mention I am backing up to disk.   Here 
is the output of my job log.  If someone could point me in the right 
direction to fix the problem and as to how I would tell bacula that the 
error volumes are good.

Thank you!

19-Jul 07:00 mtl-backup2-dir JobId 511: Start Backup JobId 511, 
Job=cimon.mit.edu.2011-07-19_07.00.00_22
19-Jul 08:41 mtl-backup2-dir JobId 511: Using Device "vdrive2"
19-Jul 08:41 mtl-backup2-sd JobId 511: 3307 Issuing autochanger "unload 
slot 189, drive 2" command.
19-Jul 08:44 mtl-backup2-sd JobId 511: Warning: Volume 
"backup2-vchanger_0006_0025" wanted on "vdrive2" 
(/usr/local/bacula/working/backup2-vchanger/2/drive2) is in use by 
device "vdrive3" (/usr/local/bacula/working/backup2-vchanger/3/drive3)
19-Jul 08:44 mtl-backup2-sd JobId 511: 3301 Issuing autochanger "loaded? 
drive 2" command.
19-Jul 08:44 mtl-backup2-sd JobId 511: 3302 Autochanger "loaded? drive 
2", result: nothing loaded.
19-Jul 08:44 mtl-backup2-sd JobId 511: Warning: Volume 
"backup2-vchanger_0006_0025" not on device "vdrive2" 
(/usr/local/bacula/working/backup2-vchanger/2/drive2).
19-Jul 08:44 mtl-backup2-sd JobId 511: Marking Volume 
"backup2-vchanger_0006_0025" in Error in Catalog.
19-Jul 08:44 mtl-backup2-sd JobId 511: 3301 Issuing autochanger "loaded? 
drive 2" command.
19-Jul 08:44 mtl-backup2-sd JobId 511: 3302 Autochanger "loaded? drive 
2", result: nothing loaded.
19-Jul 08:44 mtl-backup2-sd JobId 511: Warning: Volume 
"backup2-vchanger_0006_0025" not on device "vdrive2" 
(/usr/local/bacula/working/backup2-vchanger/2/drive2).
19-Jul 08:44 mtl-backup2-sd JobId 511: Marking Volume 
"backup2-vchanger_0006_0025" in Error in Catalog.
19-Jul 08:44 mtl-backup2-sd JobId 511: Warning: mount.c:217 Open device 
"vdrive2" (/usr/local/bacula/working/backup2-vchanger/2/drive2) Volume 
"backup2-vchanger_0006_0025" failed: ERR=dev.c:549 Could not open: 
/usr/local/bacula/working/backup2-vchanger/2/drive2, ERR=No such file or 
directory

19-Jul 08:44 mtl-backup2-sd JobId 511: 3301 Issuing autochanger "loaded? 
drive 2" command.
19-Jul 08:44 mtl-backup2-sd JobId 511: 3302 Autochanger "loaded? drive 
2", result: nothing loaded.
19-Jul 08:44 mtl-backup2-sd JobId 511: 3304 Issuing autochanger "load 
slot 192, drive 2" command.
19-Jul 08:44 mtl-backup2-sd JobId 511: 3305 Autochanger "load slot 192, 
drive 2", status is OK.
19-Jul 08:44 mtl-backup2-sd JobId 511: Wrote label to prelabeled Volume 
"backup2-vchanger_0006_0027" on device "vdrive2" 
(/usr/local/bacula/working/backup2-vchanger/2/drive2)


and another log:

18-Jul 07:00 mtl-backup2-dir JobId 447: Start Backup JobId 447, 
Job=asahi.mit.edu.2011-07-18_07.00.06_47
18-Jul 07:00 mtl-backup2-dir JobId 447: Using Device "vdrive1"
18-Jul 07:00 mtl-backup2-sd JobId 447: 3301 Issuing autochanger "loaded? 
drive 1" command.
18-Jul 07:00 mtl-backup2-sd JobId 447: 3302 Autochanger "loaded? drive 
1", result: nothing loaded.
18-Jul 07:03 mtl-backup2-sd JobId 447: Warning: Volume 
"backup2-vchanger_0006_0007" wanted on "vdrive1" 
(/usr/local/bacula/working/backup2-vchanger/1/drive1) is in use by 
device "vdrive3" (/usr/local/bacula/working/backup2-vchanger/3/drive3)
18-Jul 07:03 mtl-backup2-sd JobId 447: 3301 Issuing autochanger "loaded? 
drive 1" command.
18-Jul 07:03 mtl-backup2-sd JobId 447: 3302 Autochanger "loaded? drive 
1", result: nothing loaded.
18-Jul 07:03 mtl-backup2-sd JobId 447: Warning: Volume 
"backup2-vchanger_0006_0007" not on device "vdrive1" 
(/usr/local/bacula/working/backup2-vchanger/1/drive1).
18-Jul 07:03 mtl-backup2-sd JobId 447: Marking Volume 
"backup2-vchanger_0006_0007" in Error in Catalog.
18-Jul 07:03 mtl-backup2-sd JobId 447: 3301 Issuing autochanger "loaded? 
drive 1" command.
18-Jul 07:03 mtl-backup2-sd JobId 447: 3302 Autochanger "loaded? drive 
1", result: nothing loaded.
18-Jul 07:03 mtl-backup2-sd JobId 447: Warning: Volume 
"backup2-vchanger_0006_0007" not on device "vdrive1" 
(/usr/local/bacula/working/backup2-vchanger/1/drive1).
18-Jul 07:03 mtl-backup2-sd JobId 447: Marking Volume 
"backup2-vchanger_0006_0007" in Error in Catalog.
18-Jul 07:03 mtl-backup2-sd JobId 447: Warning: mount.c:217 Open device 
"vdrive1" (/usr/local/bacula/working/backup2-vchanger/1/drive1) Volume 
"backup2-vchanger_0006_0007" failed: ERR=dev.c:549 Could not open: 
/usr/local/bacula/working/backup2-vchanger/1/drive1, ERR=No such file or 
directory

18-Jul 07:03 mtl-backup2-sd JobId 447: 3301 Issuing autochanger "loaded? 
drive 1" command.
18-Jul 07:03 mtl-backup2-sd JobId 447: 3302 Autochanger "loaded? drive 
1", result: nothing loaded.
18-Jul 07:03 mtl-backup2-sd JobId 447: 3304 Issuing autochanger "load 
slot 176, drive 1" command.
18-Jul 07:03 mtl-backup

Re: [Bacula-users] Scripting restores?

2011-07-19 Thread Roy Sigurd Karlsbakk
> You can generate boostrap files and run these directly. You might find
> checking out http://code.google.com/p/baculafs/ is helpful.

I'll check that, thanks
 
> Alternatively you can simply script restores via bconsole.
> eg
> 
> bconsole << EOF
> restore
> 7
> /example/DUMP/Archive/P_NW.mxi
> /example/ptec/storman_6_amd64.deb
> /example/DUMP/CC_Planning_3d.mxs
> /example/DUMP/CC_Planning_side.mxi
> /example/PLE/3D_N_StageC_.c4d
> /example/aw/05 3d/Mark/03/ViewNo01/B
> /example/sit/shops/Sheet-000921.pdf
> /example/arket/typical_side_winder.psd
> /example/2.25/elements2/gtc_.psd
> /example/for planners/Tiff/ordnance copy.
> /example/102__Binder.pdf
> /example/Thomas/rice
> 
> yes
> EOF

Any chance of telling bconsole from which job it should extract this?

Vennlige hilsener / Best regards

roy
--
Roy Sigurd Karlsbakk
(+47) 97542685
r...@karlsbakk.net
http://blogg.karlsbakk.net/
--
I all pedagogikk er det essensielt at pensum presenteres intelligibelt. Det er 
et elementært imperativ for alle pedagoger å unngå eksessiv anvendelse av 
idiomer med fremmed opprinnelse. I de fleste tilfeller eksisterer adekvate og 
relevante synonymer på norsk.

--
Magic Quadrant for Content-Aware Data Loss Prevention
Research study explores the data loss prevention market. Includes in-depth
analysis on the changes within the DLP market, and the criteria used to
evaluate the strengths and weaknesses of these DLP solutions.
http://www.accelacomm.com/jaw/sfnl/114/51385063/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Scripting restores?

2011-07-19 Thread Rory Campbell-Lange
On 19/07/11, Kevin Keane (subscript...@kkeane.com) wrote:
> Maybe bextract will help you? Instead of restoring from within
> bconsole, you can access the tape/file volumes directly.
> -Original Message-
> From: Roy Sigurd Karlsbakk [mailto:r...@karlsbakk.net] 
>
> So - is it possible to somehow manually restore each version of each
> of these files? I'm thinking something like "restore the files under
> the given directories for job #9965 to /newdir/9965" Is this
> possible, and if so, how can I automate this somehow?

You can generate boostrap files and run these directly. You might find
checking out http://code.google.com/p/baculafs/ is helpful.

Alternatively you can simply script restores via bconsole.
eg

   bconsole << EOF
   restore
   7
   /example/DUMP/Archive/P_NW.mxi
   /example/ptec/storman_6_amd64.deb
   /example/DUMP/CC_Planning_3d.mxs
   /example/DUMP/CC_Planning_side.mxi
   /example/PLE/3D_N_StageC_.c4d
   /example/aw/05 3d/Mark/03/ViewNo01/B
   /example/sit/shops/Sheet-000921.pdf
   /example/arket/typical_side_winder.psd
   /example/2.25/elements2/gtc_.psd
   /example/for planners/Tiff/ordnance copy.
   /example/102__Binder.pdf
   /example/Thomas/rice

   yes
   EOF



-- 
Rory Campbell-Lange
r...@campbell-lange.net

Campbell-Lange Workshop
www.campbell-lange.net
0207 6311 555
3 Tottenham Street London W1T 2AF
Registered in England No. 04551928

--
Magic Quadrant for Content-Aware Data Loss Prevention
Research study explores the data loss prevention market. Includes in-depth
analysis on the changes within the DLP market, and the criteria used to
evaluate the strengths and weaknesses of these DLP solutions.
http://www.accelacomm.com/jaw/sfnl/114/51385063/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Scripting restores?

2011-07-19 Thread Kevin Keane
Maybe bextract will help you? Instead of restoring from within bconsole, you 
can access the tape/file volumes directly.

Kevin Keane
The NetTech
http://www.4nettech.com

-Original Message-
From: Roy Sigurd Karlsbakk [mailto:r...@karlsbakk.net] 
Sent: Tuesday, July 19, 2011 8:30 AM
To: bacula-users
Subject: [Bacula-users] Scripting restores?

Hi all

I have a particular server 'ny-filur' that is backed up every night 
(incrementally). Some data are stored temporarily on some areas, let's name 
them /home/a, /home/b, /home/x and /home/whatever. The data comes from air 
quality stations and are normally imported into a database. Now, for a set of 
reasons, I need to extract the files in these directories from each backup 
since the end of May. Doing this manually with Bat should be quite simple, but 
there seems to be a bug in Bat, so it doesn't show all files. Doing this 
manually from the console seems to be something that'll take a few days.

So - is it possible to somehow manually restore each version of each of these 
files? I'm thinking something like "restore the files under the given 
directories for job #9965 to /newdir/9965" Is this possible, and if so, how 
can I automate this somehow?

Vennlige hilsener / Best regards

roy
--
Roy Sigurd Karlsbakk
(+47) 97542685
r...@karlsbakk.net
http://blogg.karlsbakk.net/
--
I all pedagogikk er det essensielt at pensum presenteres intelligibelt. Det er 
et elementært imperativ for alle pedagoger å unngå eksessiv anvendelse av 
idiomer med fremmed opprinnelse. I de fleste tilfeller eksisterer adekvate og 
relevante synonymer på norsk.

--
Magic Quadrant for Content-Aware Data Loss Prevention Research study explores 
the data loss prevention market. Includes in-depth analysis on the changes 
within the DLP market, and the criteria used to evaluate the strengths and 
weaknesses of these DLP solutions.
http://www.accelacomm.com/jaw/sfnl/114/51385063/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Magic Quadrant for Content-Aware Data Loss Prevention
Research study explores the data loss prevention market. Includes in-depth
analysis on the changes within the DLP market, and the criteria used to
evaluate the strengths and weaknesses of these DLP solutions.
http://www.accelacomm.com/jaw/sfnl/114/51385063/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Compaq SCSI tape drive, doesn't work as expected.

2011-07-19 Thread J. Echter
Hi,

i have a Compaq SCSI Tape on a Adaptec AIC-7892A SCSI controller.

If i issue a mt -f /dev/nst0 rewind the command quits without a message,
mt -f /dev/nst0 weof does the same.

Now my problem, if i hit mt -f /dev/nst0 eject, the drive gets stuck,
and the led's are flashing.

lsscsi tells me:

[12:0:6:0]   tapeCOMPAQ   SDT-11.16  /dev/st0

system is a ubuntu 10.04 lts server x64.

what's wrong, is my drive faulty?

cheers

juergen

--
Magic Quadrant for Content-Aware Data Loss Prevention
Research study explores the data loss prevention market. Includes in-depth
analysis on the changes within the DLP market, and the criteria used to
evaluate the strengths and weaknesses of these DLP solutions.
http://www.accelacomm.com/jaw/sfnl/114/51385063/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula cannot create pools in PostgreSQL database

2011-07-19 Thread Martin Simmons
> On Tue, 19 Jul 2011 17:36:51 +0400, Igor Zinovik said:
> 
>   Hello.
> 
> I cannot understand why bacula cannot fill my postgresql database tables.
> I'm using CentOS 5.6 with bacula 5.0.3 and postgresql 8.1.23
> 
> When i'm try to backup some of my client i see follwoing :
> 19-Jul 17:18 bacula.petrsu.ru-dir JobId 3: No prior Full backup Job
> record found.
> 19-Jul 17:18 bacula.petrsu.ru-dir JobId 3: No prior or suitable Full
> backup found in catalog. Doing FULL backup.
> 19-Jul 17:18 bacula.petrsu.ru-dir JobId 3: Fatal error:
> sql_create.c:211 sql_create.c:211 insert INSERT INTO Pool
> (Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat,RecyclePoolId,ScratchPoolId,ActionOnPurge)
> VALUES 
> ('fullpool',0,5,0,1,0,1,1,15552000,0,40,0,268435456000,'backup',0,'fullvol-${Year}${Month:p/2/0/r}${Day:p/2/0/r}',0,0,1)
> failed:
> ERROR:  new row for relation "pool" violates check constraint
> "pool_pooltype_check"

Check your Pool definition in bacula-dir.conf -- it looks like you have 

Pool Type = backup

If so, change it to

Pool Type = Backup

i.e. capital B.

__Martin

--
Magic Quadrant for Content-Aware Data Loss Prevention
Research study explores the data loss prevention market. Includes in-depth
analysis on the changes within the DLP market, and the criteria used to
evaluate the strengths and weaknesses of these DLP solutions.
http://www.accelacomm.com/jaw/sfnl/114/51385063/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Other SMTP Client than bsmtp.

2011-07-19 Thread Rickifer Barros
Hello Guys...

Can I use another SMTP client than bsmtp, like sendEmail? I've tried put the
mailcommand based on sendEmail, sending the message to a Third Party Email
Server but it didn't worked.

Thanks in Advance

Rickifer Barros.
--
Magic Quadrant for Content-Aware Data Loss Prevention
Research study explores the data loss prevention market. Includes in-depth
analysis on the changes within the DLP market, and the criteria used to
evaluate the strengths and weaknesses of these DLP solutions.
http://www.accelacomm.com/jaw/sfnl/114/51385063/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Scripting restores?

2011-07-19 Thread Roy Sigurd Karlsbakk
Hi all

I have a particular server 'ny-filur' that is backed up every night 
(incrementally). Some data are stored temporarily on some areas, let's name 
them /home/a, /home/b, /home/x and /home/whatever. The data comes from air 
quality stations and are normally imported into a database. Now, for a set of 
reasons, I need to extract the files in these directories from each backup 
since the end of May. Doing this manually with Bat should be quite simple, but 
there seems to be a bug in Bat, so it doesn't show all files. Doing this 
manually from the console seems to be something that'll take a few days.

So - is it possible to somehow manually restore each version of each of these 
files? I'm thinking something like "restore the files under the given 
directories for job #9965 to /newdir/9965" Is this possible, and if so, how 
can I automate this somehow?

Vennlige hilsener / Best regards

roy
--
Roy Sigurd Karlsbakk
(+47) 97542685
r...@karlsbakk.net
http://blogg.karlsbakk.net/
--
I all pedagogikk er det essensielt at pensum presenteres intelligibelt. Det er 
et elementært imperativ for alle pedagoger å unngå eksessiv anvendelse av 
idiomer med fremmed opprinnelse. I de fleste tilfeller eksisterer adekvate og 
relevante synonymer på norsk.

--
Magic Quadrant for Content-Aware Data Loss Prevention
Research study explores the data loss prevention market. Includes in-depth
analysis on the changes within the DLP market, and the criteria used to
evaluate the strengths and weaknesses of these DLP solutions.
http://www.accelacomm.com/jaw/sfnl/114/51385063/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] cannot build BAT - hopefully something simple?

2011-07-19 Thread Brodie, Kent
Hi- I am going to re-send this again in hopes someone can assist...
thanks!

 

 

 

From: Brodie, Kent 
Sent: Tuesday, July 12, 2011 12:56 PM
To: 'bacula-users@lists.sourceforge.net'
Subject: cannot build BAT - hopefully something simple?

 

Good morning!

 

New bacula user here--  I'm building bacula on a RedHat 5.5 server.   I
built the depkgs-qt, sourced the paths  - but when I try to build

Bacula (the following is a snippet from my .configure...)- I get the
following:

 

 

Creating bat Makefile

QMAKESPEC has not been set, so configuration cannot be deduced.

Error processing project file:
/usr/local/src/bacula/bacula-5.0.3/src/qt-console/bat.pro

make: *** No rule to make target `clean'.  Stop.

Doing make of dependencies

..

 

 

Afterward, the rest of bacula appears to build OK, but I can't build BAT
- which I'd really like to use.

 

"qmake" is defined properly, as are the qt-related paths:

 

# which qmake

/usr/local/src/bacula/depkgs-qt/qt4/bin/qmake

 

# printenv | grep Q

QTDIR=/usr/local/src/bacula/depkgs-qt/qt4

QTINC=/usr/local/src/bacula/depkgs-qt/qt4/include

QTLIB=/usr/local/src/bacula/depkgs-qt/qt4/lib

 

 

 

Any help is appreciated!

 

-kent

--
Magic Quadrant for Content-Aware Data Loss Prevention
Research study explores the data loss prevention market. Includes in-depth
analysis on the changes within the DLP market, and the criteria used to
evaluate the strengths and weaknesses of these DLP solutions.
http://www.accelacomm.com/jaw/sfnl/114/51385063/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Bacula on NAS

2011-07-19 Thread Seonica
Hi everyone,

I just installed Bacula on my QNAP TS-809 Pro. Now i dont know how to configure 
it.
I want to make a inkremetal backup every day and a full backup every weak.

Could somebody help me plz? :)

Regards,
Seonica

+--
|This was sent by stipan.ra...@hotmail.de via Backup Central.
|Forward SPAM to ab...@backupcentral.com.
+--



--
Magic Quadrant for Content-Aware Data Loss Prevention
Research study explores the data loss prevention market. Includes in-depth
analysis on the changes within the DLP market, and the criteria used to
evaluate the strengths and weaknesses of these DLP solutions.
http://www.accelacomm.com/jaw/sfnl/114/51385063/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Bacula cannot create pools in PostgreSQL database

2011-07-19 Thread Igor Zinovik
  Hello.

I cannot understand why bacula cannot fill my postgresql database tables.
I'm using CentOS 5.6 with bacula 5.0.3 and postgresql 8.1.23

When i'm try to backup some of my client i see follwoing :
19-Jul 17:18 bacula.petrsu.ru-dir JobId 3: No prior Full backup Job
record found.
19-Jul 17:18 bacula.petrsu.ru-dir JobId 3: No prior or suitable Full
backup found in catalog. Doing FULL backup.
19-Jul 17:18 bacula.petrsu.ru-dir JobId 3: Fatal error:
sql_create.c:211 sql_create.c:211 insert INSERT INTO Pool
(Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat,RecyclePoolId,ScratchPoolId,ActionOnPurge)
VALUES 
('fullpool',0,5,0,1,0,1,1,15552000,0,40,0,268435456000,'backup',0,'fullvol-${Year}${Month:p/2/0/r}${Day:p/2/0/r}',0,0,1)
failed:
ERROR:  new row for relation "pool" violates check constraint
"pool_pooltype_check"

19-Jul 17:18 bacula.petrsu.ru-dir JobId 3: Fatal error: Pool
"fullpool" not in database. ERR=sql_create.c:213 Create db Pool record
INSERT INTO Pool
(Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat,RecyclePoolId,ScratchPoolId,ActionOnPurge)
VALUES 
('fullpool',0,5,0,1,0,1,1,15552000,0,40,0,268435456000,'backup',0,'fullvol-${Year}${Month:p/2/0/r}${Day:p/2/0/r}',0,0,1)
failed: ERR=
19-Jul 17:18 bacula.petrsu.ru-dir JobId 3: Error: Bacula
bacula.petrsu.ru-dir 5.0.3 (30Aug10): 19-Jul-2011 17:18:50

# psql -WU bacula -d bacula -c \\dt
Password for user bacula:
 List of relations
 Schema |  Name  | Type  |  Owner
++---+--
 public | basefiles  | table | postgres
 public | cdimages   | table | postgres
 public | client | table | postgres
 public | counters   | table | postgres
 public | device | table | postgres
 public | file   | table | postgres
 public | filename   | table | postgres
 public | fileset| table | postgres
 public | job| table | postgres
 public | jobhisto   | table | postgres
 public | jobmedia   | table | postgres
 public | location   | table | postgres
 public | locationlog| table | postgres
 public | log| table | postgres
 public | media  | table | postgres
 public | mediatype  | table | postgres
 public | path   | table | postgres
 public | pathhierarchy  | table | postgres
 public | pathvisibility | table | postgres
 public | pool   | table | postgres
 public | status | table | postgres
 public | storage| table | postgres
 public | unsavedfiles   | table | postgres
 public | version| table | postgres
(24 rows)

# psql -WU bacula -d bacula -c \\dp
Password for user bacula:
   Access privileges for database "bacula"
 Schema |   Name|   Type   |
Access privileges
+---+--+-
 public | basefiles | table|
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | basefiles_baseid_seq  | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 public | cdimages  | table|
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | client| table|
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | client_clientid_seq   | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 public | counters  | table|
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | device| table|
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | device_deviceid_seq   | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 public | file  | table|
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | file_fileid_seq   | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 public | filename  | table|
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | filename_filenameid_seq   | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 public | fileset   | table|
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | fileset_filesetid_seq | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 public | job   | table|
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | job_jobid_seq | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 public | jobhisto  | table|
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | jobmedia  | table|
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | jobmedia_jobmediaid_seq   | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 pu