[Bacula-users] Clone a job only on certain circumstance

2006-02-23 Thread Baptiste Malguy
Hello,

I have a question related to cloning jobs.

I've just re-read my mail before pushing the Send button, and ... a
little long I'm afraid.

I want to write my full backups on two different storages (disk + DLT4).

To achieve this goal, I use the Run attribute of the Job resource,
providing the same job name: that's job cloning.

The job is normally an incremental one, that becomes a full one once a
month thanks to the corresponding schedule.

Only the monthly full backups have to go on the tapes. Not the
incremental ones neither the potential full ones that may occur because
FileSet resource has been modified.

And that's the point: how to avoid these random full backups to go on
the tape, that is, how to prevent the original job (writing to disk) to
clone itself (to write on tape).

I thought about using Run Before Job attribute, to prevent the cloned
job to work returning a non-zero value, but I don't know what to provide
to the run command to let it know to return 0 or non-zero.

The command needs:
 - I'm a clone or I'm writing to tapes
 - and I'm a full backup
 - and current date (because of random full backups)

I can't provide to the command, as long as I know, I'm a clone neither
I'm writing to tapes.

Here are some pieces of the setup:


Job {
  Name = server-test
  Write Bootstrap = /var/lib/bacula/server-test.bsr
  JobDefs = default
  FileSet = server-test
  Client = server-fd
  Run = server-test-etc level=\%l\ since=\%s\ pool=cart-month
storage=dlt-storage
  Type = Backup
  Storage = file-storage
  Messages = standard
  Priority = 10
  Pool = file-full
}

Schedule {
  Name = weekly-cycle
  Run = Full Pool=file-full 1st sat at 1:05
  Run = Differential Pool=file-diff 2nd-5th sat at 1:05
  Run = Incremental Pool=file-inc sun-fri at 1:05
}

JobDefs {
  Name = default
  Type = Backup
  Level = Incremental
  FileSet = full
  Schedule = weekly-cycle
  Storage = file-storage
  Messages = standard
  Priority = 10
  Pool = default
}

I've added this to see what I obtain:

  RunBeforeJob = /etc/bacula/scripts/cloned-inc-not-on-tape \%c\
\%d\ \%i\ \%e\ \%j\ \%l\ \%n\ \%t\ \%v\

And the command line is something like:

$1=server-fd
$2=
$3=634
$4=Unknown term code
$5=server-test-etc.2006-02-22_11.30.31
$6=Full
$7=Backup
$8=Backup
$9=

From this point, hoping I've been clear enought (not sure), does anyone
has an idea ?

Bye the way, I use Bacula 1.38.3. I'm looking forward for the project
item #2 Implement Migration that moves Jobs from one Pool to
another.

Thank you and keep on improving this great software !

-- 
Baptiste MALGUY - IT Engineer   SOLSOFT
PGP Fingerprint: 2A90 B6D1 855F 1584 FE68  94AC CCD6 36D0 3DC7 DCB8
www.solsoft.com - phone: +33 1 47 15 04 00 - fax: +33 1 47 15 55 09
 How secure networks are managed.


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


RE: [Bacula-users] DB Vacuuming in Postgres

2006-02-23 Thread Magnus Hagander
  Just a few quick questions before we start testing.
  
  Is this necessary to keep the DB size at a norm?
 
 I found it very necessary when using Postgres 7.3.4.  It 
 needs a full vacuum every week for me.

Vacuum is necessary in all PostgreSQL versions, if you ever do UPDATEs
or DELETEs. So as long as you never prune anything, you don't really
need it - you *do* need ANALYZE though. But in a real deployment, you
will have deletes, so you should definitly run vacuum analyze.

Only in ancient versions like = 7.3 do you need vacuum full. In modern
versions, a plain vacuum is enough. I'd recommend you run it once/day if
you can, or at least once/week.


  Time - If anyone is currently doing this whats the average time it 
  takes for you database? And how large is your database?
 
 The problem is likely to be the File table and its indexes.  
 On a 2.8HGz P4 with ~ 7 million rows in the File table, 
 vacuum takes 30 mins and vacuum full takes 90 mins for me.  
 I've not attempted to optimize this.

Wow, that's bad :-) I have a similar machine, with 14 million rows in
the File table, and a vacuum takes only 9 minutes (that's for the whole
database and not just file, but I assume you have the same - it's by far
the one that takes most time).
Also,that's vacuum analyze, but I don't think the analyze makes much
difference.

The things you want to do: increase maintenance_work_mem, and upgrade to
a current postgresql version (there has been plenty of work wrt vacuum
speed at least up to 8.0).

//Magnus


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] voluseduration without effect

2006-02-23 Thread Ralf Gross
Hi,

I created two pools with the option 'Volume Use Duration' set to 48 hours.

Volume Use Duration = 48 hours

The volume state of the tapes used for the backup 2 weeks ago, changed
their state to 'Used' on the following Tuesday. I got a appropriate
message on the console and the state was correctly displayed as 'Used'.

14-Feb 08:42 bacula-dir: Max configured use duration exceeded. Marking
Volume Bang3-2006-02-08 as Used.

mediaid |volumename| volstatus | -snip- | lastwritten |
   3| Bang3-2006-02-08 |Used   | -snip- | 2006-02-13 09:03:06 |


But the tapes from last weekends backup are still in 'Append' state.

mediaid |volumename| volstatus | -snip- | lastwritten |
   6| Bang6-2006-02-08 |   Append  | -snip- | 2006-02-19 11:13:43 |


 mediaid: 6
   volumename: Bang6-2006-02-08
 slot: 6
   poolid: 1
mediatype: AIT-2
 firstwritten: 2006-02-18 19:30:03
  lastwritten: 2006-02-19 11:13:43
labeldate: 2006-02-18 19:30:03
  voljobs: 2
 volfiles: 68
volblocks: 1,029,548
volmounts: 2
 volbytes: 66,418,086,144
volerrors: 0
volwrites: 1,029,549
 volcapacitybytes: 0
volstatus: Append
  recycle: 1
 volretention: 777,600
   voluseduration: 172,800
   maxvoljobs: 0
  maxvolfiles: 0
  maxvolbytes: 0
inchanger: 1
  endfile: 67
 endblock: 4,043
 volparts: 0
labeltype: 0
storageid: 2


This looks fine to me, anything I'm missing here? The last log message is:

19-Feb 11:22 bacula-dir: End auto prune.

Nothing about volume duration exceeded.

Ralf



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Listing filenames of backed up files

2006-02-23 Thread Geir Asle Borgen
On Wed, 2006-02-22 at 06:54 -0800, Karl Hakimian wrote:
 On Wed, Feb 22, 2006 at 02:58:11PM +0100, Geir Asle Borgen wrote:
  OK, but I'm no SQL guru ... I'm capable to get in to query-mode (using
  bconsole) ... But any hint om SQL queryes for MySQL is welcome :)
 
 Not sure why you would need to do this directly in sql, but the query in
 postgres looks like:
No need for SQL ... but I can't find the proper way to do this in
bconsol ... or any oter tool ... testing the wxconsole-hint from
Arno ... and that made me understand that I can use query in bconsol and
get the info I need :D Thanks Arno!

Now I only have to tind a way to put this info to a file ... I read some
where that bconsole can be run whit options as a normale *nix
command ... looking ... have to read ... no prob :)


 select Path.path || Filename.name
 from File, Path, Filename
 where File.jobid = yourjobnumber and File.pathid = Path.pathid and
 File.filenameid = Filename.filenameid
 
 Replace yourjobnumber with the job number you want the files for.
 
 Unless you are coding up some sort of app, I'd suggest sticking with
 bconsole.
 
-- 
Phone Work: +47 69212321 / 2321  Phone Priv: +47 69809853 (o_  
+47 99521685 / 3137   //\
ICQ: 48948625   MSN: [EMAIL PROTECTED]   V_/_ i n u x
Registered Linux User # 171776 (http://counter.li.org)


signature.asc
Description: This is a digitally signed message part


Re: [Bacula-users] Client on Fedora Core 1

2006-02-23 Thread Barry L. Bond
Hi Ger!

 I run Fedora Core 4.  I compiled Bacula from the source.

 Here is my current config.out:


Configuration on Tue Oct 11 22:18:22 EDT 2005:

  Host:   i686-redhat-linux-gnu -- redhat (Stentz)
  Bacula version: 1.36.3 (22 April 2005)
  Source code location:   .
  Install binaries:   /home/bacula/bin
  Install config files:   /home/bacula/bin
  Scripts directory:  /home/bacula/bin
  Working directory:  /var/bacula/working
  PID directory:  /var/run
  Subsys directory:   /var/run/subsys
  C Compiler: gcc 4.0.0
  C++ Compiler:   g++ 4.0.0
  Compiler flags:  -g -O2 -Wall
  Linker flags:
  Libraries:  -lpthread 
  Statically Linked Tools:no
  Statically Linked FD:   no
  Statically Linked SD:   no
  Statically Linked DIR:  no
  Statically Linked CONS: no
  Database type:  MySQL
  Database lib:   -L/usr/lib/mysql -lmysqlclient_r -lz

  Job Output Email:   barry
  Traceback Email:barry
  SMTP Host Address:  localhost

  Director Port:  9101
  File daemon Port:   9102
  Storage daemon Port:9103

  Director User:  
  Director Group: 
  Storage Daemon User:
  Storage DaemonGroup:
  File Daemon User:   
  File Daemon Group:  

  SQL binaries Directory  /usr/bin

  Large file support: yes
  Bacula conio support:   yes -ltermcap
  readline support:   no 
  TCP Wrappers support:   no
  ZLIB support:   yes
  enable-smartalloc:  yes
  enable-gnome:   yes Version 2.x
  enable-wx-console:  no
  enable-tray-monitor:yes
  client-only:no
  ACL support:yes


 In mid-January, I did a *major* revamp of my three daemon
configuration files.  (I now have two separate/independent USB external
hard disks holding my backup data, and my situation is I should be able to
restore from either disk -- in case something happens to one or the
other.  So, a full backup gets made to both disks on the first day [from
my once a week backup schedule] of the month, with differentials
thereafter, for the rest of the month.  It's working GREAT!)

 Probably in the next couple of weeks or so, I am going to get the
latest source, because I do want to enable something I didn't enable the
first time.  I didn't enable wx-console when I compiled it, before.  (See
above.)  I do want that, because I'm going to want to run something in my 
GNOME desktop to monitor the status of the bacula daemons.  Since I'll be
recompiling, anyway, I'll likely get the latest release.

 And, I am going to need to burn a bacula rescue CD, which I have not
done yet.

 In any event, though, it works -- great!

 I hope that helps.

 Barry

-- 
Barry L. Bond | http://home.cfl.rr.com/os9barry/
Software Engineer, ITT Industries | (My personal home web page, last
  | updated February 17, 2005)
  |
[EMAIL PROTECTED] - personal  |  Re-Vita Products:
[EMAIL PROTECTED] - Work ONLY   |  http://www.re-vita.net/barrybond
  |  Re-Vita Distributor Information
Home office:  407-382-2815|  http://www.re-vita.net/barrybond-2
Work: 321-494-5627|  Toll free order:  1-888-820-5531


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] voluseduration without effect

2006-02-23 Thread Ralf Gross
Me said:

[voluseduration ignored]

I'm a bit confused about this paragraph in the documentation.

http://www.bacula.org/rel-manual/Configuring_Director.html#SECTION000141

Volume Use Duration
[...]
The use duration is checked and the Used status is set only at the end of
a job that writes to the particular volume, which means that even though
the use duration may have expired, the catalog entry will not be updated
until the next job that uses this volume is run.

If I understand this right, I should never see the 'Used' state set by
'Volume Use Duration' in the volume list, because it will only be updated
by the next job that uses that tape. Does that make sense at all?

13-Feb 17:17 bacula-dir: Begin pruning Jobs.
13-Feb 17:17 bacula-dir: No Jobs found to prune.
13-Feb 17:17 bacula-dir: Begin pruning Files.
13-Feb 17:17 bacula-dir: No Files found to prune.
13-Feb 17:17 bacula-dir: End auto prune.
14-Feb 08:42 bacula-dir: Max configured use duration exceeded. Marking
Volume Bang3-2006-02-08 as Used.

Ralf




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] ERROR: new row for relation media violates check constraint media_volstatus

2006-02-23 Thread Arno Lehmann

Hello,

On 2/23/2006 8:19 AM, Ross Boylan wrote:

I got the error in the subject line while doing backups.  I'm running
bacula 1.36.3-2 on Debian with postgresql 7.4.9.  This happened around
the time my /var partition may have filled up, though it did have a
reasonable looking amount of free space when I checked in the morning
(/var holds the postgres dataset, the spool area to which bacula is
writing, and it was the partition being backed up by one of the failed
jobs!).


:-)


Is this consistent with running out of room, or is someting else going
on?  In particular, I'm a little surprised by the constraint failure
reports, and wonder if they could indicate some other problem.


Now, I'm not an experienced PostgreSQL user, but the Bacula log seems to 
indicate that the disk space really was full. See below:



Here's more of the logs:
22-Feb 02:21 wheat-dir: Start Backup JobId 963, Job=MSD.2006-02-22_01.05.03
22-Feb 02:21 wheat-sd: Volume Inc2006-02-22_0197 previously written, moving 
to end of data.
22-Feb 02:22 wheat-sd: End of Volume Inc2006-02-22_0197 at 0:312 on device 
/var/spool/bacula. Write of 64512 bytes got 45209.


Here, only part of a block could be written, and...


22-Feb 02:22 wheat-sd: End of medium on Volume Inc2006-02-22_0197 
Bytes=54,509,211 Blocks=845 at 22-Feb-2006 02:22.
22-Feb 02:22 wheat-dir: Created new Volume Inc2006-02-22_0198 in catalog.
22-Feb 02:22 wheat-sd: End of Volume Inc2006-02-22_0198 at 0:0 on device 
/var/spool/bacula. Write of 205 bytes got -1.


... even a small amount could not be written to the next volume.


22-Feb 02:22 wheat-dir: MSD.2006-02-22_01.05.03 Error: sql_update.c:327 
sql_update.c:327 update UPDATE Media SET 
VolJobs=0,VolFiles=0,VolBlocks=0,VolBytes=0,VolMounts=0,VolErrors=0,VolWrites=1,MaxVolBytes=681574400,LastWritten='2006-02-22
 02:22:39',VolStatus='',Slot=0,InChanger=0,VolReadTime=0,VolWriteTime=0  WHERE 
VolumeName='Inc2006-02-22_0198' failed:
ERROR:  new row for relation media violates check constraint media_volstatus

22-Feb 02:22 wheat-dir: MSD.2006-02-22_01.05.03 Error: Catalog error updating 
Media record. sql_update.c:327 update UPDATE Media SET 
VolJobs=0,VolFiles=0,VolBlocks=0,VolBytes=0,VolMounts=0,VolErrors=0,VolWrites=1,MaxVolBytes=681574400,LastWritten='2006-02-22
 02:22:39',VolStatus='',Slot=0,InChanger=0,VolReadTime=0,VolWriteTime=0  WHERE 
VolumeName='Inc2006-02-22_0198' failed:


Trying to insert an empty string for VolStatus might be a bug.

I'd report this as a bug.


This followed several successful backups, and was in turn followed by
another successful backup (!), which included


Probably because the spool space wasn't full then.


22-Feb 02:24 wheat-sd: Labeled new Volume Inc2006-02-22_0198 on device 
/var/spool/bacula.
22-Feb 02:24 wheat-sd: Wrote label to prelabeled Volume Inc2006-02-22_0198 on device 
/var/spool/bacula

It apparently succeeded in making a new volume though the previous
attempt failed.

However, the log does not show the usual job status report for either
of the two preceding jobs.


Might also be because the disk was full, so Bacula couldn't write the 
log. As far as I recall (I've had similar problems once) there is no 
error reporting in this case. Which is reasonable, because there's 
hardly any way to report an error if Bacula can't use its temporary disk 
space.




The final part of the log shows the attempt to backup /var itself:
22-Feb 02:30 wheat-sd: Volume Inc2006-02-22_0198 previously written, moving 
to end of data.
22-Feb 02:30 wheat-sd: End of Volume Inc2006-02-22_0198 at 0:0 on device 
/var/spool/bacula. Write of 64512 bytes got -1.
22-Feb 02:30 wheat-sd: End of medium on Volume Inc2006-02-22_0198 Bytes=383 
Blocks=1 at 22-Feb-2006 02:30.
22-Feb 02:30 wheat-dir: Created new Volume Inc2006-02-22_0199 in catalog.
22-Feb 02:30 wheat-sd: End of Volume Inc2006-02-22_0199 at 0:0 on device 
/var/spool/bacula. Write of 205 bytes got -1.
22-Feb 02:30 wheat-dir: LinSysVar.2006-02-22_01.05.06 Error: sql_update.c:327 
sql_update.c:327 update UPDATE Media SET 
VolJobs=0,VolFiles=0,VolBlocks=0,VolBytes=0,VolMounts=0,VolErrors=0,VolWrites=1,MaxVolBytes=681574400,LastWritten='2006-02-22
 02:30:19',VolStatus='',Slot=0,InChanger=0,VolReadTime=0,VolWriteTime=0  WHERE 
VolumeName='Inc2006-02-22_0199' failed:
ERROR:  new row for relation media violates check constraint media_volstatus

22-Feb 02:30 wheat-dir: LinSysVar.2006-02-22_01.05.06 Error: Catalog error 
updating Media record. sql_update.c:327 update UPDATE Media SET 
VolJobs=0,VolFiles=0,VolBlocks=0,VolBytes=0,VolMounts=0,VolErrors=0,VolWrites=1,MaxVolBytes=681574400,LastWritten='2006-02-22
 02:30:19',VolStatus='',Slot=0,InChanger=0,VolReadTime=0,VolWriteTime=0  WHERE 
VolumeName='Inc2006-02-22_0199' failed:
ERROR:  new row for rel
It ends in mid line.


Probably this was the moment the disk was full and the write to the log 
couldn't aquire more file system space.


Arno

--
IT-Service Lehmann[EMAIL PROTECTED]
Arno Lehmann 

Re: [Bacula-users] A script to ease the pain of switching from SQLite to PostgreSQL

2006-02-23 Thread Russell Howe
Kern Sibbald wrote:
 On Monday 06 February 2006 18:04, Russell Howe wrote:
 
Well, the time is nigh. Our SQLite database has hit 1.3GB and creates a
900MB dump file, which is big enough to cause our bacula Xen virtual
machine to run out of space when running a catalog backup.

We have a Postgres (7.4) server with plenty of space, so I thought I'd
try importing the catalog into that.. things didn't go so smoothly, so I
ended up knocking up a script to do the import.

I haven't actually tested this yet, so it's probably broken and riddled
with bugs. Still, enjoy :)
 
 I've added this to the examples/dbdump directory -- perhaps not the most 
 obvious place.  If you ever have an update, please send it to me.
 
 Thanks for the contribution, in addition to your regular Bacula list spam 
 filtering work :-)

heh, I should add that the script is pretty broken. I've got a more up
to date version at http://siksai.co.uk/~rhowe/software/sqlite2pgsql but
it's still not quite right.

Still, it may make the transition slightly less painful for anyone else
who has to do it. In the end, I blew our catalog away after getting
complaints from SQLite about the database file being corrupt. I started
afresh with Postgres. We were switching to a new drive and a whole new
set of tapes, so the catalog was only of historical interest in case we
needed to restore from a while back. In about 4 months, it would be
rendered completely useless.

I'm tempted to knock up yet another web interface to the database,
however, so you might see some Java stuff from me in the not too distant
future.

-- 
Russell Howe
[EMAIL PROTECTED]


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] FOSDEM 2006

2006-02-23 Thread Russell Howe
Is anyone else going to FOSDEM 2006 in Brussels?

http://www.fosdem.org/

I'll be arriving Friday afternoon, and will stay until sometime Sunday
afternoon/evening.

-- 
Russell Howe
[EMAIL PROTECTED]


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] A script to ease the pain of switching from SQLite to PostgreSQL

2006-02-23 Thread Florian Schnabel

Russell Howe wrote:

Well, the time is nigh. Our SQLite database has hit 1.3GB and creates a
900MB dump file, which is big enough to cause our bacula Xen virtual
machine to run out of space when running a catalog backup.

We have a Postgres (7.4) server with plenty of space, so I thought I'd
try importing the catalog into that.. things didn't go so smoothly, so I
ended up knocking up a script to do the import.

I haven't actually finished it yet, and I know there are some
optimisations which could be made, but I hope this is useful to someone:

What could be better:

* Automatic reorganisation of CREATE statements so that they execute in
the correct order
* Commandline parameters
* Handling of arbitrary conversions (Postgres - MySQL, MySQL -
Postgres, SQLite - MySQL, MySQL - SQLite, Postgres - SQLite)

Note that it would be a good idea to turn off the fsync stuff on
Postgres while you do the import - I haven't benchmarked, but it should
make things go a good bit quicker.

I haven't actually tested this yet, so it's probably broken and riddled
with bugs. Still, enjoy :)



not it wouldn't be nice to have scripts for most database changes (no 
need from anything to change to sqLite though)
but i would just change the database and wait for it to be populated 
with the new entries .. no real need to import data since you can 
restore without having it in the database


Florian


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Clone a job only on certain circumstance

2006-02-23 Thread Baptiste Malguy
Hello,

I have a question related to cloning jobs.

I've just re-read my mail before pushing the Send button, and ... a
little long I'm afraid.

I want to write my full backups on two different storages (disk + DLT4).

To achieve this goal, I use the Run attribute of the Job resource,
providing the same job name: that's job cloning.

The job is normally an incremental one, that becomes a full one once a
month thanks to the corresponding schedule.

Only the monthly full backups have to go on the tapes. Not the
incremental ones neither the potential full ones that may occur because
FileSet resource has been modified.

And that's the point: how to avoid these random full backups to go on
the tape, that is, how to prevent the original job (writing to disk) to
clone itself (to write on tape).

I thought about using Run Before Job attribute, to prevent the cloned
job to work returning a non-zero value, but I don't know what to provide
to the run command to let it know to return 0 or non-zero.

The command needs:
 - I'm a clone or I'm writing to tapes
 - and I'm a full backup
 - and current date (because of random full backups)

I can't provide to the command, as long as I know, I'm a clone neither
I'm writing to tapes.

Here are some pieces of the setup:


Job {
  Name = server-test
  Write Bootstrap = /var/lib/bacula/server-test.bsr
  JobDefs = default
  FileSet = server-test
  Client = server-fd
  Run = server-test-etc level=\%l\ since=\%s\ pool=cart-month
storage=dlt-storage
  Type = Backup
  Storage = file-storage
  Messages = standard
  Priority = 10
  Pool = file-full
}

Schedule {
  Name = weekly-cycle
  Run = Full Pool=file-full 1st sat at 1:05
  Run = Differential Pool=file-diff 2nd-5th sat at 1:05
  Run = Incremental Pool=file-inc sun-fri at 1:05
}

JobDefs {
  Name = default
  Type = Backup
  Level = Incremental
  FileSet = full
  Schedule = weekly-cycle
  Storage = file-storage
  Messages = standard
  Priority = 10
  Pool = default
}

I've added this to see what I obtain:

  RunBeforeJob = /etc/bacula/scripts/cloned-inc-not-on-tape \%c\
\%d\ \%i\ \%e\ \%j\ \%l\ \%n\ \%t\ \%v\

And the command line is something like:

$1=server-fd
$2=
$3=634
$4=Unknown term code
$5=server-test-etc.2006-02-22_11.30.31
$6=Full
$7=Backup
$8=Backup
$9=

From this point, hoping I've been clear enought (not sure), does anyone
has an idea ?

Bye the way, I use Bacula 1.38.3. I'm looking forward for the project
item #2 Implement Migration that moves Jobs from one Pool to
another.

Thank you and keep on improving this great software !

-- 
Baptiste MALGUY - IT Engineer   SOLSOFT
PGP Fingerprint: 2A90 B6D1 855F 1584 FE68  94AC CCD6 36D0 3DC7 DCB8
www.solsoft.com - phone: +33 1 47 15 04 00 - fax: +33 1 47 15 55 09
 How secure networks are managed.


signature.asc
Description: OpenPGP digital signature


[Bacula-users] Help

2006-02-23 Thread Pe�fffffffffff1aloza
Por favor necesito ayuda urgente sobre el siguiente
error a la hora de ejecutar un trabajo con el comando
run en la consola:
*
21-Feb 19:53 scott2-dir: No prior Full backup Job
record found.
21-Feb 19:53 scott2-dir: No prior or suitable Full
backup found. Doing FULL backup.
21-Feb 19:53 scott2-dir: Start Backup JobId 10,
Job=Client1.2006-02-21_19.53.27
21-Feb 19:53 scott2-dir: Client1.2006-02-21_19.53.27
Fatal error: authenticate.c:99 Director unable to
authenticate with Storage daemon. Possible causes:
Passwords or names not the same or
Maximum Concurrent Jobs exceeded on the SD or
SD networking messed up (restart daemon).
Please see
http://www.bacula.org/rel-manual/faq.html#AuthorizationErrors
for help.
21-Feb 19:53 scott2-dir: Client1.2006-02-21_19.53.27
Error: Bacula 1.38.5 (18Jan06): 21-Feb-2006 19:53:34
  JobId:  10
  Job:Client1.2006-02-21_19.53.27
  Backup Level:   Full (upgraded from
Incremental)
  Client: scott2-fd
  FileSet:Full Set 2006-02-20
20:31:41
  Pool:   Default
  Storage:File
  Scheduled time: 21-Feb-2006 19:53:21
  Start time: 21-Feb-2006 19:53:29
  End time:   21-Feb-2006 19:53:34
  Priority:   10
  FD Files Written:   0
  SD Files Written:   0
  FD Bytes Written:   0
  SD Bytes Written:   0
  Rate:   0.0 KB/s
  Software Compression:   None
  Volume name(s):
  Volume Session Id:  0
  Volume Session Time:0
  Last Volume Bytes:  0
  Non-fatal FD errors:0
  SD Errors:  0
  FD termination status:
  SD termination status:
  Termination:*** Backup Error ***

*exit
hemos confirmado los names y paswords de bacula-fd;
bacula-dir; bacula-sd y todos estan correctos, tenemos
especificados como maximo de trabajos concurrentes 10
pero no tenemos idea de como solucionar el problema,
es la primera vez que configuramos bacula y no hemos
ejecutado ningun trabajo hasta el momento. adjuntamos
la configuracion de nuestros archivos


__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Bacula Storage Device

2006-02-23 Thread KeenLearner

Hi to All,

i need your help again..regarding Bacula Storage Device.
I have 3 machines:
OS on 1st Machine = Win - 2000
OS on 2 nd Machine =  Win - 2000
OS on 3 rd Machine =  Redhat Linux

Linux is my bacula server.
now what i want is ..
My bacula server (Linux) will take the Backup of 1st Machine(Win-2000) and
stored it on to the other Machine..that is 3rd Machine(Win- 2000). 
Means i want My Storage Device should be Windows-2000 Machine and not the
Linux Bacula Server.

I tried but it is not working...
Pls help me..with proper syntax in bacula-dir, bacula-fd and bacula-sd
files.

Thanks  Regards,
KeenLearner

--
View this message in context: 
http://www.nabble.com/Bacula-Storage-Device-t1174725.html#a3087808
Sent from the Bacula - Users forum at Nabble.com.



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] FOSDEM 2006

2006-02-23 Thread Dan Langille
On 23 Feb 2006 at 11:16, Russell Howe wrote:

 Is anyone else going to FOSDEM 2006 in Brussels?
 
 http://www.fosdem.org/
 
 I'll be arriving Friday afternoon, and will stay until sometime Sunday
 afternoon/evening.

Russell and I spoke on IRC about this.  I've told him about this 
brochure, which was recently updated:

 http://www.freebsddiary.org/advocacy/bsdcan-brochure-non-folding.pdf

Anyone is free to print out copies of that document and distribute to 
friends / clubs / etc.

-- 
Dan Langille : Software Developer looking for work
my resume: http://www.freebsddiary.org/dan_langille.php




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Help

2006-02-23 Thread Arno Lehmann

Hmm. Spanish?

Not one of my languages... anyway, what you need to know is in the 
message: Authentication problem. Make sure that bacula-sd is running and 
he passwords are set up correctly.


Arno

On 2/23/2006 1:53 AM, Alexandra PeXfff1aloza wrote:

Por favor necesito ayuda urgente sobre el siguiente
error a la hora de ejecutar un trabajo con el comando
run en la consola:
*
21-Feb 19:53 scott2-dir: No prior Full backup Job
record found.
21-Feb 19:53 scott2-dir: No prior or suitable Full
backup found. Doing FULL backup.
21-Feb 19:53 scott2-dir: Start Backup JobId 10,
Job=Client1.2006-02-21_19.53.27
21-Feb 19:53 scott2-dir: Client1.2006-02-21_19.53.27
Fatal error: authenticate.c:99 Director unable to
authenticate with Storage daemon. Possible causes:
Passwords or names not the same or
Maximum Concurrent Jobs exceeded on the SD or
SD networking messed up (restart daemon).
Please see
http://www.bacula.org/rel-manual/faq.html#AuthorizationErrors
for help.
21-Feb 19:53 scott2-dir: Client1.2006-02-21_19.53.27
Error: Bacula 1.38.5 (18Jan06): 21-Feb-2006 19:53:34
  JobId:  10
  Job:Client1.2006-02-21_19.53.27
  Backup Level:   Full (upgraded from
Incremental)
  Client: scott2-fd
  FileSet:Full Set 2006-02-20
20:31:41
  Pool:   Default
  Storage:File
  Scheduled time: 21-Feb-2006 19:53:21
  Start time: 21-Feb-2006 19:53:29
  End time:   21-Feb-2006 19:53:34
  Priority:   10
  FD Files Written:   0
  SD Files Written:   0
  FD Bytes Written:   0
  SD Bytes Written:   0
  Rate:   0.0 KB/s
  Software Compression:   None
  Volume name(s):
  Volume Session Id:  0
  Volume Session Time:0
  Last Volume Bytes:  0
  Non-fatal FD errors:0
  SD Errors:  0
  FD termination status:
  SD termination status:
  Termination:*** Backup Error ***

*exit
hemos confirmado los names y paswords de bacula-fd;
bacula-dir; bacula-sd y todos estan correctos, tenemos
especificados como maximo de trabajos concurrentes 10
pero no tenemos idea de como solucionar el problema,
es la primera vez que configuramos bacula y no hemos
ejecutado ningun trabajo hasta el momento. adjuntamos
la configuracion de nuestros archivos


__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users



--
IT-Service Lehmann[EMAIL PROTECTED]
Arno Lehmann  http://www.its-lehmann.de


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] device load tracking in database?

2006-02-23 Thread Kern Sibbald
On Thursday 09 February 2006 12:41, Jens Boettge wrote:
 Hello,

 only a short question for today.
 The database has a device table which should keep the usage of the
 backup devices. But there are no rows in this table.
 Is this feature not yet implemented 

It was partially implemented in a previous development version, then turned 
off for lack of time to fully implement it.

 or is this a bug? Possibly I have 
 overlooked something?

 Best regards,
 Jens Boettge



 ---
 This SF.net email is sponsored by: Splunk Inc. Do you grep through log
 files for problems?  Stop!  Download the new AJAX search engine that makes
 searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
 http://sel.as-us.falkag.net/sel?cmd=lnkkid=103432bid=230486dat=121642
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Postgres speed

2006-02-23 Thread Kern Sibbald
On Friday 10 February 2006 15:58, Karl Hakimian wrote:
  I don't think COPY will be useful.

 I don't think I'm ready to give up on the copy command yet. The amount
 of data in the filename and path tables is small compared to the file
 table. If we created a copy command while updating the file and path
 tables and then dumped the file updates via copy, that should be a
 significant speed improvement.

 http://www.postgresql.org/docs/8.1/static/sql-copy.html
 
  The data we are adding to the database does not already exist.
  There's nothing to COPY.

 We should be able to created it from the spooled attributes.

  I think transactions are more important here.  We need to look more
  closely at that.

 I believe transactions would help quite a bit. Seems to me I saw some
 transaction code in bacula commented out. Does anyone know why it was
 removed?

If you are still interested in this subject, I would make the following 
comments:

- I don't know what the COPY command is, but I doubt it is something Bacula 
would want to use since I like to keep the code simple and as uniform as 
possible across systems.

- As you noted, there is some transaction code in Bacula.  However, it is 
turned off for the reasons that Martin mentions.

- On the other hand, I have come up with an idea that I have discussed with 
Dan (possibly off-list) for implementing transactions in a slightly different 
way from before.  This would IMO permit a significant improvement in speed 
inserting the file attributes. If this interests you and you have not seen 
those emails, please let me know, and I'll see if I can dig them out -- if I 
don't have them (because I was not using my normal email), I'm sure Dan does.

Best regards,

Kern


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Re: [Bacula-devel] Encryption Status

2006-02-23 Thread Kern Sibbald
On Sunday 12 February 2006 23:07, Landon Fuller wrote:
 Landon Fuller wrote:
  One other issue worth raising -- The director can currently overwrite
  any file on the FD, including the encryption keys or the FD
  configuration file, thus exposing private data to the director.

 Something else I forgot to mention; the file daemon also ensures data
 integrity by signing each file. Currently, only file data is signed --
 permissions, ownership, et al are not.

 AFAIK, during a restore, the storage daemon will provide the stream data
 in the same order it was written by the file daemon. If that's true, the
 easiest way to add extra file attributes/streams to the signature is to
 checksum them as we send them to (and receive them from) the storage
 daemon.

 Kern, is it reasonable to assume that the Storage Daemon will always
 provide per-file stream data in the order it was written by the File
 Daemon? 

Yes, it is a strict requirement.

 If not, I'd guess the alternative is to cache the file 
 attributes on restore and checksum them in the standard order.

 Thanks,
 -landonf


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] voluseduration without effect

2006-02-23 Thread Ralf Gross
Kern Sibbald said:
 On Thursday 23 February 2006 11:21, Ralf Gross wrote:
 Volume Use Duration
 [...]
 The use duration is checked and the Used status is set only at the end
 of
 a job that writes to the particular volume, which means that even though
 the use duration may have expired, the catalog entry will not be updated
 until the next job that uses this volume is run.

 If I understand this right, I should never see the 'Used' state set by
 'Volume Use Duration' in the volume list, because it will only be
 updated
 by the next job that uses that tape. Does that make sense at all?

 Yea, it really should say attempts to use that volume.

Ok, but why did bacula mark the volume the week before as used, although
no job attempted to use it (see below). I see nothing related in the log
file, the last entry before the volume was marked as 'Used' was the auto
prune job the day before.

 13-Feb 17:17 bacula-dir: Begin pruning Jobs.
 13-Feb 17:17 bacula-dir: No Jobs found to prune.
 13-Feb 17:17 bacula-dir: Begin pruning Files.
 13-Feb 17:17 bacula-dir: No Files found to prune.
 13-Feb 17:17 bacula-dir: End auto prune.
 14-Feb 08:42 bacula-dir: Max configured use duration exceeded. Marking
 Volume Bang3-2006-02-08 as Used.

I still think I'm missing something...

Ralf




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Will bacula be faster than rsnapshot over 3 GB?

2006-02-23 Thread Harry Putnam
Alan Brown [EMAIL PROTECTED] writes:

 Yikes! Double your disk space, just like that.

No, it doens't do what you think it does.  Try this test:

   mkdir -p test/test.0
   echo some data |tee  test/test.0/1 test/test.0/2 test/test.0/3 
   
ls -l test/test.0
   total 12
   -rw-r--r-- 2 reader users 10 Feb 23 08:13 1
   -rw-r--r-- 2 reader users 10 Feb 23 08:13 2
   -rw-r--r-- 2 reader users 10 Feb 23 08:13 3
   
du -sh test
   12K test
   
cp -al test/test.0 test/test.1
   
ls test
   test.0  test.1
   
du -sh test
   12K test

No increase in overall size has occured.


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Will bacula be faster than rsnapshot over 3 GB?

2006-02-23 Thread Alan Brown

On Thu, 23 Feb 2006, Harry Putnam wrote:


Alan Brown [EMAIL PROTECTED] writes:


Yikes! Double your disk space, just like that.


No, it doens't do what you think it does.  Try this test:


http://www.rsnapshot.org/howto/1.2/rsnapshot-HOWTO.en.html

...rsnapshot is a filesystem backup utility based on rsync. Using 
rsnapshot, it is possible to take snapshots of your filesystems at 
different points in time. Using hard links, rsnapshot creates the illusion 
of multiple full backups, while only taking up the space of one full 
backup plus differences.



As I said, double your disk space. The incrementals may be small, but the 
initial full backup requires as much disk space as the filesystem it's 
backup up.



AB



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] FOSDEM 2006

2006-02-23 Thread Michel Meyers

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Dan Langille wrote:

On 23 Feb 2006 at 11:16, Russell Howe wrote:


Is anyone else going to FOSDEM 2006 in Brussels?

http://www.fosdem.org/

I'll be arriving Friday afternoon, and will stay until sometime Sunday
afternoon/evening.


Russell and I spoke on IRC about this.  I've told him about this
brochure, which was recently updated:

 http://www.freebsddiary.org/advocacy/bsdcan-brochure-non-folding.pdf


BSDCAN 2004? Am I right if I guess you rather meant:

http://www.freebsddiary.org/advocacy/bacula-brochure-non-folding.pdf

?


Anyone is free to print out copies of that document and distribute to
friends / clubs / etc.


Greetings,
   Michel
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2 (MingW32) - GPGrelay v0.959

iD8DBQFD/ddu2Vs+MkscAyURAr1hAKDeg0nETllVsl8+wUsQyFC/f4Xe/QCcDYvb
HD4lQMfOhm+krwtZ7ULba4w=
=VX5t
-END PGP SIGNATURE-


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Re: Will bacula be faster than rsnapshot over 3 GB?

2006-02-23 Thread Harry Putnam
Alan Brown [EMAIL PROTECTED] writes:

 On Thu, 23 Feb 2006, Harry Putnam wrote:

 Alan Brown [EMAIL PROTECTED] writes:

 Yikes! Double your disk space, just like that.

 No, it doens't do what you think it does.  Try this test:

 http://www.rsnapshot.org/howto/1.2/rsnapshot-HOWTO.en.html

 ...rsnapshot is a filesystem backup utility based on rsync. Using
 rsnapshot, it is possible to take snapshots of your filesystems at
 different points in time. Using hard links, rsnapshot creates the
 illusion of multiple full backups, while only taking up the space of
 one full backup plus differences.


 As I said, double your disk space. The incrementals may be small, but
 the initial full backup requires as much disk space as the filesystem
 it's backup up.

Actually no... it wasn't what you indicated regardless of what you
actually said. 

From OP

   I'm noticing a lengthy pause in an rsnapshot setup when the
   directories being shuffled are over 3gb or so.  Rsnapshot makes a
   copy of the last backup to a new name then runs rsync against the
   original.  Making that copy can take awhile.  And more so as it gets
   bigger.
  
  Yikes! Double your disk space, just like that.

Your comment was a direct reply to my mention of rsnapshot copying the
last backup to a new name.  The `just likt that.'  Is obviously aimed
at my comments since you quoted them for your reply.  If you tried
that test you'll know that just isn't how it works.

What you are saying now is quit a lot different.  That 
 target + backup = double the space.

That is also true or very close to it, of any other backup system
including bacula when used in disk mode.  (assuming no compression)



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Frank Stuber ist nicht im Büro

2006-02-23 Thread frank . stuber




Ich werde ab  23.02.2006 nicht im Büro sein. Ich kehre zurück am
06.03.2006.

Ich werde Ihre Nachricht nach meiner Rückkehr beantworten.
In dringenden Fällen wenden Sie sich bitte an meine Kollegen in der EDV.

Gruß

Frank Stuber



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Help

2006-02-23 Thread Kern Sibbald
On Thursday 23 February 2006 01:53, Alexandra Pe�fff1aloza wrote:
 Por favor necesito ayuda urgente sobre el siguiente
 error a la hora de ejecutar un trabajo con el comando
 run en la consola:
 *
 21-Feb 19:53 scott2-dir: No prior Full backup Job
 record found.
 21-Feb 19:53 scott2-dir: No prior or suitable Full
 backup found. Doing FULL backup.
 21-Feb 19:53 scott2-dir: Start Backup JobId 10,
 Job=Client1.2006-02-21_19.53.27
 21-Feb 19:53 scott2-dir: Client1.2006-02-21_19.53.27
 Fatal error: authenticate.c:99 Director unable to
 authenticate with Storage daemon. Possible causes:
 Passwords or names not the same or
 Maximum Concurrent Jobs exceeded on the SD or
 SD networking messed up (restart daemon).
 Please see
 http://www.bacula.org/rel-manual/faq.html#AuthorizationErrors
 for help.
 21-Feb 19:53 scott2-dir: Client1.2006-02-21_19.53.27
 Error: Bacula 1.38.5 (18Jan06): 21-Feb-2006 19:53:34
   JobId:  10
   Job:Client1.2006-02-21_19.53.27
   Backup Level:   Full (upgraded from
 Incremental)
   Client: scott2-fd
   FileSet:Full Set 2006-02-20
 20:31:41
   Pool:   Default
   Storage:File
   Scheduled time: 21-Feb-2006 19:53:21
   Start time: 21-Feb-2006 19:53:29
   End time:   21-Feb-2006 19:53:34
   Priority:   10
   FD Files Written:   0
   SD Files Written:   0
   FD Bytes Written:   0
   SD Bytes Written:   0
   Rate:   0.0 KB/s
   Software Compression:   None
   Volume name(s):
   Volume Session Id:  0
   Volume Session Time:0
   Last Volume Bytes:  0
   Non-fatal FD errors:0
   SD Errors:  0
   FD termination status:
   SD termination status:
   Termination:*** Backup Error ***

 *exit
 hemos confirmado los names y paswords de bacula-fd;
 bacula-dir; bacula-sd y todos estan correctos, tenemos
 especificados como maximo de trabajos concurrentes 10
 pero no tenemos idea de como solucionar el problema,
 es la primera vez que configuramos bacula y no hemos
 ejecutado ningun trabajo hasta el momento. adjuntamos
 la configuracion de nuestros archivos


Try starting your daemons with -d100, then try to run your job. It will give 
you more information.



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] SD Connect Timeout

2006-02-23 Thread Enrique de la Torre Gordaliza

Hello,

we are trying to baclup some laptops using SD Connect Timeout directive. But 
as I read at the online documentation FAQ:

-
There are several things you can do to improve the situation. 
Upgrade to version 1.32 and use the new SDConnectTimeout record. For example, 
set: 
  SD Connect Timeout = 5 min

 in the FileDaemon resource.
-


How does it work? I mean, if the FileDaemon client is offline, how can the 
Director know about this timeout? Is this value saved at the director the 
first time it connects the client? Whats the difference between this 
directive located at the Director configuration and at the FileSet?

Thanks in advance

Enrique
-- 
Enrique de la Torre Gordaliza   
Departamento de Arquitectura de Computadores y Automática
Facultad de CC. Físicas, UCM
Av. Complutense s/n C.P:28040 

email: [EMAIL PROTECTED]
tlfn: 913944389


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Scheduling question

2006-02-23 Thread Jeremy Koppel








Hello,



 Weve
been using Bacula in our company since the beginning of the year with a good
deal of success, but I had a scheduling question that I hadnt
anticipated earlier. As part of our backup rotation, I have 2 additional
pools, Offsite1 and Offsite2 (just 1 tape each for now), that are scheduled to
be written to on alternating Saturdays. How it actually breaks down is:




We have 15 jobs setup that point to
one of two schedules, depending on the retention we need.


The schedule then determines when
and where to put the backup; in the case of the Offsite backups, the Offsite1
pool is used on the 1st and 3rd Saturdays, and the
Offsite2 pool is used on the 2nd and 4th Saturdays.


(The actual schedule is below)





The Question:

But I see that we have a problem
coming up in April; 5 Saturdays. So if I specify either pool for the 5th
Saturday, we loose our rotation. I see that what we actually need to do
is to set these up for every other Saturday regardless of when it
falls during the month. My question is, how do you do that?







Our Schedule:



Schedule {

 Name = MonthlyCycle

 Run = Level=Full Pool=Offsite1 1st sat at 2:00

 Run = Level=Full Pool=Offsite2 2nd sat at 2:00

 Run = Level=Full Pool=Offsite1 3rd sat at 2:00

 Run = Level=Full Pool=Offsite2 4th sat at 2:00

 Run = Level=Full Pool=Weekly sun at 2:00

 Run = Level=Differential Pool=Daily FullPool=Weekly
mon-fri at 2:00

}



Schedule {

 Name = LongTerm

 Run = Level=Full Pool=Offsite1 1st sat at 1:00

 Run = Level=Full Pool=Offsite2 2nd sat at 1:00

 Run = Level=Full Pool=Offsite1 3rd sat at 1:00

 Run = Level=Full Pool=Offsite2 4th sat at 1:00

 Run = Level=Full Pool=Monthly 1st sun at 1:00

 Run = Level=Full Pool=Weekly 2nd-4th sun at 1:00

 Run = Level=Differential Pool=Daily FullPool=Weekly
mon-fri at 1:00

}





Thanks!



--Jeremy Koppel













Re: [Bacula-users] Scheduling question

2006-02-23 Thread Arno Lehmann

Hello,

On 2/23/2006 8:11 PM, Jeremy Koppel wrote:



Hello,

 

We’ve been using Bacula in our company since the beginning 
of the year with a good deal of success, but I had a scheduling question 
that I hadn’t anticipated earlier.  As part of our backup rotation, I 
have 2 additional pools, Offsite1 and Offsite2 (just 1 tape each for 
now), that are scheduled to be written to on alternating Saturdays.  How 
it actually breaks down is:

...

* The Question: *

But I see that we have a problem coming up in April; 5 Saturdays.  So if 
I specify either pool for the 5^th Saturday, we loose our rotation.  I 
see that what we actually need to do is to set these up for ‘every other 
Saturday’ regardless of when it falls during the month.  My question is, 
how do you do that?


I'd try using the week of year specification in the schedule. You'd 
simply schedule like


run = pool=offsite1 w01,w03,w05,... sat at 2:00

the problems here: I don't know if this actually works :-) and you still 
have to worry about the odd number of weeks per year. At least only one 
a year, and simply by swapping the pool definitions in the job overrides 
of the schedules...


The better solution, also absolutely untested, would be to use the 
python interface and implement a simple script that determines which 
pool to use. I even assume it's impossible at the moment, because in the 
manual it states that the Pool attribute of a job object in python is 
read-only... but that might change one fine day :-)


Arno


--
IT-Service Lehmann[EMAIL PROTECTED]
Arno Lehmann  http://www.its-lehmann.de



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] voluseduration without effect

2006-02-23 Thread Ryan Novosielski
Do you really have NO task that kicks off at around that time that deals 
with that pool? If so, that is rather curious.


 _  _ _  _ ___  _  _  _
|Y#| |  | |\/| |  \ |\ |  | | Ryan Novosielski - User Support Spec. III
|$| |__| |  | |__/ | \| _| | [EMAIL PROTECTED] - 973/972.0922 (2-0922)
\__/ Univ. of Med. and Dent.| IST/AST - NJMS Medical Science Bldg - C630 




Ralf Gross wrote:

Kern Sibbald said:
  

On Thursday 23 February 2006 11:21, Ralf Gross wrote:


Volume Use Duration
[...]
The use duration is checked and the Used status is set only at the end
of
a job that writes to the particular volume, which means that even though
the use duration may have expired, the catalog entry will not be updated
until the next job that uses this volume is run.

If I understand this right, I should never see the 'Used' state set by
'Volume Use Duration' in the volume list, because it will only be
updated
by the next job that uses that tape. Does that make sense at all?
  

Yea, it really should say attempts to use that volume.



Ok, but why did bacula mark the volume the week before as used, although
no job attempted to use it (see below). I see nothing related in the log
file, the last entry before the volume was marked as 'Used' was the auto
prune job the day before.

  

13-Feb 17:17 bacula-dir: Begin pruning Jobs.
13-Feb 17:17 bacula-dir: No Jobs found to prune.
13-Feb 17:17 bacula-dir: Begin pruning Files.
13-Feb 17:17 bacula-dir: No Files found to prune.
13-Feb 17:17 bacula-dir: End auto prune.
14-Feb 08:42 bacula-dir: Max configured use duration exceeded. Marking
Volume Bang3-2006-02-08 as Used.
  


I still think I'm missing something...

Ralf




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
  




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Restore Error...

2006-02-23 Thread Ryan Novosielski
You will frequently notice this backing up e-mail volumes, or 
directories that contain lockfiles. For some unknown reason, the .lock 
files are stored in /var/mail on our system, and so there are many 
complaints about files that did not exist at the time of writing, but 
did exist when the list was being made (this was with Data Protector). 
As for e-mail files, they are bound to grow during the backup. My 
solution there was to exclude *.lock (useless files anyway). This is the 
equivalent to Dan's suggestion here.


It's scary to see a Restore error, but in these cases, they are no big deal.

 _  _ _  _ ___  _  _  _
|Y#| |  | |\/| |  \ |\ |  | | Ryan Novosielski - User Support Spec. III
|$| |__| |  | |__/ | \| _| | [EMAIL PROTECTED] - 973/972.0922 (2-0922)
\__/ Univ. of Med. and Dent.| IST/AST - NJMS Medical Science Bldg - C630 




Dan Langille wrote:

On 20 Feb 2006 at 20:06, Boniforti Flavio wrote:

  

In data Mon, 20 Feb 2006 19:56:07 +0100
Boniforti Flavio [EMAIL PROTECTED] scriveva:



I just discovered this:

19-Feb 18:43 dropbox-fd: RestoreFiles.2006-02-19_18.43.22 Error:
attribs.c:339 File size of restored file
/tmp/bacula-restores/var/lib/mysql/bacula/File.MYD n
ot correct. Original 115936, restored 116236.

19-Feb 18:43 dropbox-fd: RestoreFiles.2006-02-19_18.43.22 Error:
attribs.c:339 File size of restored file
/tmp/bacula-restores/var/log/mysql/mysql-bin.07
not correct. Original 662506, restored 663027.

What could the problem be?
  

OK, I self-answer me: maybe those files where in use when backup
started, and in the restore process something (WHAT?) went wrong?



My theory:

When the FD took the file size, it was X. While backing the FD was 
backing the file it, the file size changed to size Y.


My advice: 

Don't backup files that can change. Use mysqldump instead.  Then 
backup the output of that.  You can invoke MySQL dump in the 
RunBefore job.


  




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Bacula on MacOSX

2006-02-23 Thread Mikel King
Does Bacula offer some of the same metadata selectability under MAC  
OSX as Retrospect? Meaning, one, ok it's probably the only one, of  
Retros features is to select or exclude items from a job by the color  
attributed to the item. Believe it or not this is a critical issue  
for one of my clients who are mostly artists and need this visual bell.


Cheers,
Mikel King
Optimized Computer Solutions, INC
Tech Alliance, INC
39 West Fourteenth Street
Second Floor
New York, NY 10011
http://www.ocsny.com
http://www.techally.com
t: 212.727.2100x132
+--+
How do you spell cooperation? Pessimists use
each other, but optimists help each other.
Collaboration feeds your spirit, while
competition only stokes your ego. You'll
find the best way to get along.
+--+





---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula on MacOSX

2006-02-23 Thread Arno Lehmann

Hi,

On 2/23/2006 10:47 PM, Mikel King wrote:
Does Bacula offer some of the same metadata selectability under MAC  OSX 
as Retrospect? Meaning, one, ok it's probably the only one, of  Retros 
features is to select or exclude items from a job by the color  
attributed to the item.


Not out of the box, though I assume that this might be rather easy to 
implement. Even I as a non-programmer see that that metadata must be 
stored somewhere, and it's most probably in some extended attribute or 
the famous resource forks. Accessing that data should be possible for 
the FD, and passing it an option from the fileset is definitely already 
implemented :-)


Believe it or not this is a critical issue  for 
one of my clients who are mostly artists and need this visual bell.


Interesting concept of data management. But, concerning people, I'm 
ready to believe quite a lot.


Arno


Cheers,
Mikel King
Optimized Computer Solutions, INC
Tech Alliance, INC
39 West Fourteenth Street
Second Floor
New York, NY 10011
http://www.ocsny.com
http://www.techally.com
t: 212.727.2100x132
+--+
How do you spell cooperation? Pessimists use
each other, but optimists help each other.
Collaboration feeds your spirit, while
competition only stokes your ego. You'll
find the best way to get along.
+--+





---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live 
webcast

and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users



--
IT-Service Lehmann[EMAIL PROTECTED]
Arno Lehmann  http://www.its-lehmann.de


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Hardware Inquiry - Has anyone used the VXA-320?

2006-02-23 Thread Wyness Casama
Hi all,I'm looking to deploy a new backup system at an office. I've been working with the Exabyte VXA-2s in the past, but has anyone had a chance to look at the new VXA-320s?I'm thinking of deploying on FreeBSD 
5.x/6.x and I'd love to hear the community's input.Thanks,-- Wyness


Re: [Bacula-users] FOSDEM 2006

2006-02-23 Thread Jo

Russell Howe schreef:

Is anyone else going to FOSDEM 2006 in Brussels?

http://www.fosdem.org/

I'll be arriving Friday afternoon, and will stay until sometime Sunday
afternoon/evening.
  

Hi Russel,

I'm living 30 kilometers from Brussels. I'll probably be there on Sunday 
and maybe Saturday afternoon. My cell phone number is +32 (0)478-33 76 27.


Maybe we'll meet there,

Jo


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Hardware Inquiry - Has anyone used the VXA-320?

2006-02-23 Thread Mailinglist

Hi,

on a customer-site i'm using an Autoloader 1Ux10 with VXA-320 Drive for 
about 1 month.

Works great.
Bacula 1.38.5
SuSE Linux 9.3

Rate: 9 to 10 MB/s
with HW-compression about 200GB per Tape (lots of binary data and 
executables)


Regards

Helmut


Wyness Casama schrieb:

Hi all,

I'm looking to deploy a new backup system at an office. I've been 
working with the Exabyte VXA-2s in the past, but has anyone had a chance 
to look at the new VXA-320s?


I'm thinking of deploying on FreeBSD 5.x/6.x and I'd love to hear the 
community's input.


Thanks,

 -- Wyness



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Hardware Inquiry - Has anyone used the VXA-320?

2006-02-23 Thread Wyness Casama
Hi Helmut,Excellent. :) Though I'm working on FBSD, it's good to hear that there are people out there working with the device and Bacula.In your installation, did you notice anything I need to look out for in your bacula config that I wouldn't ordinarily worry about with a VXA-2? I do know that I need to watch the pthreads item in older FBSD releases so I'll be testing with that at install time to make sure.
-- WynessOn 2/23/06, Mailinglist [EMAIL PROTECTED] wrote:
Hi,on a customer-site i'm using an Autoloader 1Ux10 with VXA-320 Drive forabout 1 month.Works great.Bacula 1.38.5SuSE Linux 9.3Rate: 9 to 10 MB/swith HW-compression about 200GB per Tape (lots of binary data and
executables)RegardsHelmutWyness Casama schrieb: Hi all, I'm looking to deploy a new backup system at an office. I've been working with the Exabyte VXA-2s in the past, but has anyone had a chance
 to look at the new VXA-320s? I'm thinking of deploying on FreeBSD 5.x/6.x and I'd love to hear the community's input. Thanks,-- Wyness



Re: [Bacula-users] Bacula Storage Device

2006-02-23 Thread Diogo Melo
Try to mount an shared folder from your windows 2000 machine on your 
Linux machine and use this it as the device for the storage.
I sugest you to use the smbmount command. If I'm not wrong, use the 
syntax smbmount //IP_to_your_win2k_machine/name_of_shared_folder 
/local_folder_for_mountpoint -o 
username=useraccount_for_access_sharefolder/DOMAIN%password_for_this_account


Good Luck

Diogo Rocha.


KeenLearner wrote:

Hi to All,

i need your help again..regarding Bacula Storage Device.
I have 3 machines:
OS on 1st Machine = Win - 2000
OS on 2 nd Machine =  Win - 2000
OS on 3 rd Machine =  Redhat Linux

Linux is my bacula server.
now what i want is ..
My bacula server (Linux) will take the Backup of 1st Machine(Win-2000) and
stored it on to the other Machine..that is 3rd Machine(Win- 2000). 
Means i want My Storage Device should be Windows-2000 Machine and not the

Linux Bacula Server.

I tried but it is not working...
Pls help me..with proper syntax in bacula-dir, bacula-fd and bacula-sd
files.

Thanks  Regards,
KeenLearner

--
View this message in context: 
http://www.nabble.com/Bacula-Storage-Device-t1174725.html#a3087808
Sent from the Bacula - Users forum at Nabble.com.



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

  




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] FreeBSD 6.0 + Bacula 1.38.5 Crashing

2006-02-23 Thread Benson Wong
Hi,

I think I located the problem, but will have to see what happens at
the full backups this weekend. It might be a hardware problem (servers
are recycled/old). When I went to the box it had a lot of

swap_pager: indefinate wait buffer

in the console.

I swapped the RAID array to a different box. Will update after the
weekend to see if the problems disappear.



 Well it happens with a local MySQL and a remote MySQL. I'm pretty
 certain is actually not to do with the job at all and is probably a bug
 in the scheduler somewhere. As for using gdb being slower I doubt very
 much if you'd notice the difference between gdb and not. As for whether
 MySQL is faster? I'm not sure what you mean.

 Cheers,
 Dom



--
blog: http://www.mostlygeek.com


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Postgres speed

2006-02-23 Thread Karl Hakimian
On Thu, Feb 23, 2006 at 02:01:47PM +0100, Kern Sibbald wrote:
 If you are still interested in this subject, I would make the following 
 comments:

I'm still interested, this is actually pretty high on my list of things
to try.

 
 - I don't know what the COPY command is, but I doubt it is something Bacula 
 would want to use since I like to keep the code simple and as uniform as 
 possible across systems.

I understand this and (mostly) agree with you on it.

 - As you noted, there is some transaction code in Bacula.  However, it is 
 turned off for the reasons that Martin mentions.
 
 - On the other hand, I have come up with an idea that I have discussed with 
 Dan (possibly off-list) for implementing transactions in a slightly different 
 way from before.  This would IMO permit a significant improvement in speed 
 inserting the file attributes. If this interests you and you have not seen 
 those emails, please let me know, and I'll see if I can dig them out -- if I 
 don't have them (because I was not using my normal email), I'm sure Dan does.

I don't think I have seen them, I have some ideas too, but I did not
want to air them until I had been through the code enough to know what I
was talking about.

-- 
Karl Hakimian
[EMAIL PROTECTED]


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Listing filenames of backed up files

2006-02-23 Thread Karl Hakimian
On Thu, Feb 23, 2006 at 10:58:03AM +0100, Geir Asle Borgen wrote:
 On Wed, 2006-02-22 at 06:54 -0800, Karl Hakimian wrote:
  On Wed, Feb 22, 2006 at 02:58:11PM +0100, Geir Asle Borgen wrote:
   OK, but I'm no SQL guru ... I'm capable to get in to query-mode (using
   bconsole) ... But any hint om SQL queryes for MySQL is welcome :)
  
  Not sure why you would need to do this directly in sql, but the query in
  postgres looks like:
 No need for SQL ... but I can't find the proper way to do this in
 bconsol ... or any oter tool ... testing the wxconsole-hint from
 Arno ... and that made me understand that I can use query in bconsol and
 get the info I need :D Thanks Arno!

In bconsole, just issue the command

list files jobid=###

where ### is the job number you want to look at. I would avoid using
sql even through bconsole.

 Now I only have to tind a way to put this info to a file ... I read some
 where that bconsole can be run whit options as a normale *nix
 command ... looking ... have to read ... no prob :)

echo list files jobid=### | bconsole -s

should run command in bconsole.

-- 
Karl Hakimian
[EMAIL PROTECTED]


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula on MacOSX

2006-02-23 Thread Ian Levesque

Hi Mikel,

Does Bacula offer some of the same metadata selectability under MAC  
OSX as Retrospect?


I don't have any experience with generating client-side file lists,  
but theoretically you could write a script that builds a list of  
files/folders with certain metadata by using the OS X command mdls.


For instance, here's a folder with the orange label:

ian% mdls -name kMDItemFSLabel Downloads
Downloads -
kMDItemFSLabel = 7


Meaning, one, ok it's probably the only one, of Retros features is  
to select or exclude items from a job by the color attributed to  
the item. Believe it or not this is a critical issue for one of my  
clients who are mostly artists and need this visual bell.


I believe it... I'm looking into using Bacula to replace Retrospect  
for client backups in our network as well, where there was a policy  
at oe time where folders with a red label weren't backed up. Though I  
can define a new policy (these are technical users, not artists) ;-)


I'm interested in what you come up with, regardless.

Cheers,
Ian


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] tape drive not writing

2006-02-23 Thread Dave

Hello,
   I'm getting this msg from bacula 1.38, it's wanting a series of tapes 
tape-0007 through this one is asking for tape-0010, but it's not doing 
anything. I put in the tape label it, mount it, and nothing. What do i do?

Thanks.
Dave.



23-Feb 17:17 zeus-sd: Please mount Volume TAPE-0010 on Storage Device 
Quantum DLT4000 (/dev/sa0) for Job Manual_Backup.2006-02-22_22.13.49 




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] ERROR: new row for relation media violates check constraint media_volstatus

2006-02-23 Thread Ross Boylan
On Thu, Feb 23, 2006 at 12:06:12PM +0100, Arno Lehmann wrote:
 Hello,
 
 On 2/23/2006 8:19 AM, Ross Boylan wrote:
 I got the error in the subject line while doing backups.  I'm running
...
 Here's more of the logs:
 22-Feb 02:21 wheat-dir: Start Backup JobId 963, Job=MSD.2006-02-22_01.05.03
 22-Feb 02:21 wheat-sd: Volume Inc2006-02-22_0197 previously written, 
 moving to end of data.
 22-Feb 02:22 wheat-sd: End of Volume Inc2006-02-22_0197 at 0:312 on 
 device /var/spool/bacula. Write of 64512 bytes got 45209.
 
 Here, only part of a block could be written, and...

Yes, that does look as if the partition really ran out of room.



 22-Feb 02:22 wheat-dir: MSD.2006-02-22_01.05.03 Error: sql_update.c:327 
 sql_update.c:327 update UPDATE Media SET 
 VolJobs=0,VolFiles=0,VolBlocks=0,VolBytes=0,VolMounts=0,VolErrors=0,VolWrites=1,MaxVolBytes=681574400,LastWritten='2006-02-22
  02:22:39',VolStatus='',Slot=0,InChanger=0,VolReadTime=0,VolWriteTime=0  
 WHERE VolumeName='Inc2006-02-22_0198' failed:
 ERROR:  new row for relation media violates check constraint 
 media_volstatus
 
 22-Feb 02:22 wheat-dir: MSD.2006-02-22_01.05.03 Error: Catalog error 
 updating Media record. sql_update.c:327 update UPDATE Media SET 
 VolJobs=0,VolFiles=0,VolBlocks=0,VolBytes=0,VolMounts=0,VolErrors=0,VolWrites=1,MaxVolBytes=681574400,LastWritten='2006-02-22
  02:22:39',VolStatus='',Slot=0,InChanger=0,VolReadTime=0,VolWriteTime=0  
 WHERE VolumeName='Inc2006-02-22_0198' failed:
 
 Trying to insert an empty string for VolStatus might be a bug.
 
 I'd report this as a bug.
You mean in bacula, or postgres?

So the problem might be that when the write fails, bacula tries to
record an illegal VolStatus?

Or could this be postgres getting weird, e.g., losing the volstatus
info, when it runs out of room?


I agree that the disk being intermittently full seems a reasonable
explanation of the other oddities.

Thanks for your help.
Ross


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Console program get hang..........

2006-02-23 Thread vipul shukla
Hi all,

 I am system administrator, i am using bacula as a
backup tool. it was working fine but from last 1 month
it has some problem.

Problem discription

1) when i give command ./bconsole then it hang and
givemessage like Connecting to Director
localhost:9101


regarding to this problem please help me.

Thanks
vipul




__ 
Yahoo! India Matrimony: Find your partner now. Go to http://yahoo.shaadi.com


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] tape drive not writing

2006-02-23 Thread Ger Apeldoorn
Hi,

Are you letting the tape settle for about a minute before mounting?

If you dont, the storage daemon can get confused. If you restart the Storage 
Daemon, it will probably work fine.

Greetings,
Ger.

Op vrijdag 24 februari 2006 04:11, schreef Dave:
 Hello,
 I'm getting this msg from bacula 1.38, it's wanting a series of tapes
 tape-0007 through this one is asking for tape-0010, but it's not doing
 anything. I put in the tape label it, mount it, and nothing. What do i do?
 Thanks.
 Dave.

  23-Feb 17:17 zeus-sd: Please mount Volume TAPE-0010 on Storage Device
  Quantum DLT4000 (/dev/sa0) for Job Manual_Backup.2006-02-22_22.13.49

 ---
 This SF.Net email is sponsored by xPML, a groundbreaking scripting language
 that extends applications into web and mobile media. Attend the live
 webcast and join the prime developer group breaking into this new coding
 territory!
 http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Console program get hang..........

2006-02-23 Thread Ger Apeldoorn
Are you sure that the director is running on the same host as you try to run 
bconsole?

Check this using:
ps ax | grep bacula-dir

You can try to telnet to localhost to see if you see anything.

It should connect if you type: (linux)
telnet localhost 9101

If you type anything, it will disconnect.

Ger.


Op vrijdag 24 februari 2006 05:09, schreef vipul shukla:
 Hi all,

  I am system administrator, i am using bacula as a
 backup tool. it was working fine but from last 1 month
 it has some problem.

 Problem discription

 1) when i give command ./bconsole then it hang and
 givemessage like Connecting to Director
 localhost:9101


 regarding to this problem please help me.

 Thanks
 vipul




 __
 Yahoo! India Matrimony: Find your partner now. Go to
 http://yahoo.shaadi.com


 ---
 This SF.Net email is sponsored by xPML, a groundbreaking scripting language
 that extends applications into web and mobile media. Attend the live
 webcast and join the prime developer group breaking into this new coding
 territory!
 http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users