[Bacula-users] FW: Client saves old information - Problem solved

2011-05-18 Thread Robert Kromoser
Hi Radoslav.

 

Yes it works.

 

Thx.

 

br Robert

 

 

From: Radosław Korzeniewski [mailto:rados...@korzeniewski.net] 
Sent: Mittwoch, 18. Mai 2011 07:09
To: Robert Kromoser
Subject: Re: [Bacula-users] Client saves old information

 

Hello,

2011/5/17 Robert Kromoser robert.kromo...@kinamu.com

Hi Radek.

 

Thx for the tip.

One another question.

Shall I just remove the *.state files on the bacula server itself or must

I remove the *.state file(s) on the client too?


Everywhere where You want to clean up.
 

 

br Robert

 



Radoslaw
 

 

From: Radosław Korzeniewski [mailto:rados...@korzeniewski.net] 
Sent: Dienstag, 17. Mai 2011 12:08
To: Robert Kromoser
Cc: bacula-users@lists.sourceforge.net
Subject: Re: [Bacula-users] Client saves old information

 

Hello Robert,

2011/5/17 Robert Kromoser robert.kromo...@kinamu.com

 

The funny situation is that, that the clients must save information 
about any old

backup run anywhere, but where?

 

When I did a status client=CCRM0004-fd before the removal then I get

the information about my runs in the last 3 days. 3 days ago were the 
last removal.

Then I do the removal now.

After restarting bacula and run a status client=CCRM0004-fd again then 
I will

get the information about old backup run 3 days ago as before the 
removal.

 

Can anyone tell me where the bacula server or the bacula client is 
storing

old information about old backup runs?


Simply remove: /var/bacula/working/bacula-fd.9102.state, 
/var/bacula/working/bacula-sd.9103.state or similar files. 


If you check it with a hexdum you can find info below: 

/var/bacula/working# hexdump -C bacula-sd.9103.state |less
  42 61 63 75 6c 61 20 53  74 61 74 65 0a 00 00 00  |Bacula 
State|
0010  04 00 00 00 bc 00 00 00  00 00 00 00 40 08 00 00  
|@...|
0020  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00  
||
*
00b0  00 00 00 00 00 00 00 00  00 00 00 00 0a 00 00 00  
||
00c0  40 09 fd 08 00 00 00 00  00 00 00 00 42 00 00 00  
|@...B...|
00d0  54 00 00 00 46 00 00 00  a8 10 00 00 c9 00 00 00  
|T...F...|
00e0  67 b5 c9 4d 01 00 00 00  aa 74 89 0d 00 00 00 00  
|g..M.t..|
00f0  5d be d1 4d 00 00 00 00  3a bf d1 4d 00 00 00 00  
|]..M:..M|
0100  42 61 63 6b 75 70 5f 43  61 74 61 6c 6f 67 2e 32  
|Backup_Catalog.2|
0110  30 31 31 2d 30 35 2d 31  37 5f 30 32 2e 31 30 2e  
|011-05-17_02.10.|
0120  30 30 5f 30 33 00 00 00  00 00 00 00 00 00 00 00  
|00_03...|
0130  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00  
||

 

br Robert

 

 


cheers,

 
Radek


--
Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation 
tools
to help boost performance applications - inlcuding clusters.
http://p.sf.net/sfu/intel-dev2devmay
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users




-- 
Radosław Korzeniewski
rados...@korzeniewski.net




-- 
Radosław Korzeniewski
rados...@korzeniewski.net

--
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Accurate Job - Cannot find previous jobids

2011-05-18 Thread Christian Manal
Hi list,

I have a problem regarding accurate backups. When I set 'Accurate = yes'
for any given job in my setup, the next run fails with the following
error(s):

   Fatal error: Cannot find previous jobids.
   Fatal error: Network error with FD during Backup: ERR=Interrupted
system call

The strange thing is, contrary to everything google came up with for
these messages, that the catalog seems to be in order. At least I can
build a filetree for the most recent backups of all my clients in both
bconsole and bat and restore files without a problem.

Does anyone have an idea what could be going on here? My Bacula version
is 5.0.3 with a Postgres 8.3 catalog on Solaris 10. Any pointers would
be appreciated.


Regards,
Christian Manal

--
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Accurate Job - Cannot find previous jobids

2011-05-18 Thread Graham Keeling
On Wed, May 18, 2011 at 10:47:05AM +0200, Christian Manal wrote:
 Hi list,
 
 I have a problem regarding accurate backups. When I set 'Accurate = yes'
 for any given job in my setup, the next run fails with the following
 error(s):
 
Fatal error: Cannot find previous jobids.
Fatal error: Network error with FD during Backup: ERR=Interrupted
 system call
 
 The strange thing is, contrary to everything google came up with for
 these messages, that the catalog seems to be in order. At least I can
 build a filetree for the most recent backups of all my clients in both
 bconsole and bat and restore files without a problem.
 
 Does anyone have an idea what could be going on here? My Bacula version
 is 5.0.3 with a Postgres 8.3 catalog on Solaris 10. Any pointers would
 be appreciated.

Bacula looks for the last full backup in the database. And it relies on 
timestamps to find it. So, I would look for your previous full and its
timestamps, and check that your clock is set later than those timestamps.
Though, if this were the case, I would expect your job to be upgraded to be
a full. So perhaps something more complicated is going on.

If times don't explain it, take a look at this bacula code from
src/cats/sql_get.c (function db_accurate_get_jobids()), which is getting
the jobids from the database. You should be able to construct very similar
queries and run them by hand to see what the database says.
Or add some debug to get the exact sql queries being used.

   /* First, find the last good Full backup for this job/client/fileset */
   Mmsg(query,
CREATE TABLE btemp3%s AS 
 SELECT JobId, StartTime, EndTime, JobTDate, PurgedFiles 
   FROM Job JOIN FileSet USING (FileSetId) 
  WHERE ClientId = %s 
AND Level='F' AND JobStatus IN ('T','W') AND Type='B' 
AND StartTime'%s' 
AND FileSet.FileSet=(SELECT FileSet FROM FileSet WHERE FileSetId = %s) 
  ORDER BY Job.JobTDate DESC LIMIT 1,
edit_uint64(jcr-JobId, jobid),
edit_uint64(jr-ClientId, clientid),
date,
edit_uint64(jr-FileSetId, filesetid));

   if (jr-JobLevel == L_INCREMENTAL || jr-JobLevel == L_VIRTUAL_FULL) {
  /* Now, find the last differential backup after the last full */
  Mmsg(query,
INSERT INTO btemp3%s (JobId, StartTime, EndTime, JobTDate, PurgedFiles) 
 SELECT JobId, StartTime, EndTime, JobTDate, PurgedFiles 
   FROM Job JOIN FileSet USING (FileSetId) 
  WHERE ClientId = %s 
AND Level='D' AND JobStatus IN ('T','W') AND Type='B' 
AND StartTime  (SELECT EndTime FROM btemp3%s ORDER BY EndTime DESC LIMIT 
1) 
AND StartTime  '%s' 
AND FileSet.FileSet= (SELECT FileSet FROM FileSet WHERE FileSetId = %s) 
  ORDER BY Job.JobTDate DESC LIMIT 1 ,
   jobid,
   clientid,
   jobid,
   date,
   filesetid);

  /* We just have to take all incremental after the last Full/Diff */
  Mmsg(query,
INSERT INTO btemp3%s (JobId, StartTime, EndTime, JobTDate, PurgedFiles) 
 SELECT JobId, StartTime, EndTime, JobTDate, PurgedFiles 
   FROM Job JOIN FileSet USING (FileSetId) 
  WHERE ClientId = %s 
AND Level='I' AND JobStatus IN ('T','W') AND Type='B' 
AND StartTime  (SELECT EndTime FROM btemp3%s ORDER BY EndTime DESC LIMIT 
1) 
AND StartTime  '%s' 
AND FileSet.FileSet= (SELECT FileSet FROM FileSet WHERE FileSetId = %s) 
  ORDER BY Job.JobTDate DESC ,
   jobid,
   clientid,
   jobid,
   date,
   filesetid);


 Regards,
 Christian Manal
 
 --
 What Every C/C++ and Fortran developer Should Know!
 Read this article and learn how Intel has extended the reach of its 
 next-generation tools to help Windows* and Linux* C/C++ and Fortran 
 developers boost performance applications - including clusters. 
 http://p.sf.net/sfu/intel-dev2devmay
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users


--
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Call for Papers for the Bacula Conference 2011

2011-05-18 Thread Kern Sibbald
Hello,

Most of you who attended last year's Bacula Conference, and responded to the 
survey earlier this year, specifically requested that we hold another Bacula 
Conference, which is what we are doing.  We are beginning to organize the 
conference, and as we did last year, we would like to give you your chance to 
make presentations.  

If you are interested in presenting something at the next Bacula Conference, 
or you want a bit of information about the conference (still in the early 
planning stage for the moment), please read more at the following link:

http://www.baculasystems.com/index.php?option=com_flexicontentview=itemsid=252:bacula-developer-conference-2011


Best regards,

Kern

--
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Accurate Job - Cannot find previous jobids

2011-05-18 Thread Christian Manal
Am 18.05.2011 11:13, schrieb Graham Keeling:
 If times don't explain it, take a look at this bacula code from
 src/cats/sql_get.c (function db_accurate_get_jobids()), which is getting
 the jobids from the database. You should be able to construct very similar
 queries and run them by hand to see what the database says.
 Or add some debug to get the exact sql queries being used.
 
/* First, find the last good Full backup for this job/client/fileset */
snip

Thank you. The problem seems to be that the query doesn't account for
the job name it is supposed to do, just the client and fileset. I have
two jobs with the same fileset for each client. One backs up to local
storage with a full/diff/incr cycle and a rather long retention period,
the other does monthly full backups to another building for DR and gets
immediately purged.

I enabled accurate for the onsite job but the query returns the last
full run of the offsite job. When I add AND Name = 'JobName' to the
query it gets the right jobid.

I think this qualifies for a bug, doesn't it?


Regards,
Christian Manal

--
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Accurate Job - Cannot find previous jobids

2011-05-18 Thread Graham Keeling
On Wed, May 18, 2011 at 11:54:18AM +0200, Christian Manal wrote:
 Am 18.05.2011 11:13, schrieb Graham Keeling:
  If times don't explain it, take a look at this bacula code from
  src/cats/sql_get.c (function db_accurate_get_jobids()), which is getting
  the jobids from the database. You should be able to construct very similar
  queries and run them by hand to see what the database says.
  Or add some debug to get the exact sql queries being used.
  
 /* First, find the last good Full backup for this job/client/fileset */
 snip
 
 Thank you. The problem seems to be that the query doesn't account for
 the job name it is supposed to do, just the client and fileset. I have
 two jobs with the same fileset for each client. One backs up to local
 storage with a full/diff/incr cycle and a rather long retention period,
 the other does monthly full backups to another building for DR and gets
 immediately purged.
 
 I enabled accurate for the onsite job but the query returns the last
 full run of the offsite job. When I add AND Name = 'JobName' to the
 query it gets the right jobid.
 
 I think this qualifies for a bug, doesn't it?

I agree with you, but...
I have just remembered coming across this before. The thread starts here:
http://www.mail-archive.com/bacula-devel@lists.sourceforge.net/msg04050.html

Kern:
Bacula does not support this option.

Me:
It does appear to be *trying* to support it, as some parts of the code that
figure out dependent jobs take note of the job name, though others do not.

Kern:
I wouldn't exactly say that it is trying to support it, but rather that since 
the program is so complicated, and I try not to restrict it too much, there 
are places where it can seem to work, but it is just not designed to do so 
(at least at the moment), and thus it will not work.  It isn't that I don't 
want it to work, but there is only so much that the developers can do in the 
time we have.

Unfortunate what you are trying to do is simply not possible in the way you 
are trying to do it with the current code.



 Regards,
 Christian Manal
 
 --
 What Every C/C++ and Fortran developer Should Know!
 Read this article and learn how Intel has extended the reach of its 
 next-generation tools to help Windows* and Linux* C/C++ and Fortran 
 developers boost performance applications - including clusters. 
 http://p.sf.net/sfu/intel-dev2devmay
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users


--
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] make_catalog_backup authentication error

2011-05-18 Thread Tobias Dinse

Hi @all,

make_catalog_backup works fine if i start it manually as bacula User. 
But with a Backup Schedule I always get the follow Error Msg:


FATAL:  password authentication failed for user bacula


*/etc/postgresql/8.4/main/pg_hba.conf*:

local   bacula  bacula 127.0.0.1/32   trust


*/var/lib/bacula/.pgpass:*
127.0.0.1:5432:bacula:bacula:PASSWORD
localhost:5432:bacula:bacula:PASSWORD


*make_catalog_backup:*

BINDIR=/usr/bin

cd /var/lib/bacula
rm -f $1.sql
if test xsqlite = xpostgresql ; then
  echo .dump | ${BINDIR}/sqlite $1.db $1.sql
else
  if test xmysql = xpostgresql ; then
if test $# -gt 2; then
  MYSQLPASSWORD= --password=$3
else
  MYSQLPASSWORD=
fi
if test $# -gt 3; then
  MYSQLHOST= --host=$4
else
  MYSQLHOST=
fi
${BINDIR}/mysqldump -u ${2}${MYSQLPASSWORD}${MYSQLHOST} -f --opt $1 
$1.sql

  else
if test xpostgresql = xpostgresql ; then
  if test $# -gt 2; then
PGPASSWORD=$1
export PGPASSWORD
  fi
  if test $# -gt 3; then
PGHOST= --host=$4
  else
PGHOST=
  fi
  # you could also add --compress for compression.  See man pg_dump
  #exec ${BINDIR}/pg_dump -c $PGHOST -U $2 $1 $1.sql
  exec ${BINDIR}/pg_dump -h localhost bacula |bzip2 -9 -f -c  
bacula.sql.bz2

else
  echo .dump | ${BINDIR}/sqlite3 $1.db $1.sql
fi
  fi
fi



Thanks and regards

Tobias

--
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Accurate Job - Cannot find previous jobids

2011-05-18 Thread Christian Manal
Am 18.05.2011 12:26, schrieb Graham Keeling:
 On Wed, May 18, 2011 at 11:54:18AM +0200, Christian Manal wrote:
 Am 18.05.2011 11:13, schrieb Graham Keeling:
 If times don't explain it, take a look at this bacula code from
 src/cats/sql_get.c (function db_accurate_get_jobids()), which is getting
 the jobids from the database. You should be able to construct very similar
 queries and run them by hand to see what the database says.
 Or add some debug to get the exact sql queries being used.

/* First, find the last good Full backup for this job/client/fileset */
snip

 Thank you. The problem seems to be that the query doesn't account for
 the job name it is supposed to do, just the client and fileset. I have
 two jobs with the same fileset for each client. One backs up to local
 storage with a full/diff/incr cycle and a rather long retention period,
 the other does monthly full backups to another building for DR and gets
 immediately purged.

 I enabled accurate for the onsite job but the query returns the last
 full run of the offsite job. When I add AND Name = 'JobName' to the
 query it gets the right jobid.

 I think this qualifies for a bug, doesn't it?
 
 I agree with you, but...
 I have just remembered coming across this before. The thread starts here:
 http://www.mail-archive.com/bacula-devel@lists.sourceforge.net/msg04050.html
 
 Kern:
 Bacula does not support this option.
 
 Me:
 It does appear to be *trying* to support it, as some parts of the code that
 figure out dependent jobs take note of the job name, though others do not.
 
 Kern:
 I wouldn't exactly say that it is trying to support it, but rather that 
 since 
 the program is so complicated, and I try not to restrict it too much, there 
 are places where it can seem to work, but it is just not designed to do so 
 (at least at the moment), and thus it will not work.  It isn't that I don't 
 want it to work, but there is only so much that the developers can do in the 
 time we have.
 
 Unfortunate what you are trying to do is simply not possible in the way you 
 are trying to do it with the current code.

Great... so I have to create two identical filesets to get this to work?
If this kind of setup is not supported, it would be nice if I'd get at
least a warning by './bacula-dir -t' or something.

Thanks for the help, though, I'll fix my config.


Regards,
Christian Manal


 
 
 
 Regards,
 Christian Manal

 --
 What Every C/C++ and Fortran developer Should Know!
 Read this article and learn how Intel has extended the reach of its 
 next-generation tools to help Windows* and Linux* C/C++ and Fortran 
 developers boost performance applications - including clusters. 
 http://p.sf.net/sfu/intel-dev2devmay
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users
 
 
 --
 What Every C/C++ and Fortran developer Should Know!
 Read this article and learn how Intel has extended the reach of its 
 next-generation tools to help Windows* and Linux* C/C++ and Fortran 
 developers boost performance applications - including clusters. 
 http://p.sf.net/sfu/intel-dev2devmay
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users
 


--
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Accurate Job - Cannot find previous jobids

2011-05-18 Thread Graham Keeling
On Wed, May 18, 2011 at 01:02:08PM +0200, Christian Manal wrote:
 Am 18.05.2011 12:26, schrieb Graham Keeling:
  On Wed, May 18, 2011 at 11:54:18AM +0200, Christian Manal wrote:
  Am 18.05.2011 11:13, schrieb Graham Keeling:
  If times don't explain it, take a look at this bacula code from
  src/cats/sql_get.c (function db_accurate_get_jobids()), which is getting
  the jobids from the database. You should be able to construct very similar
  queries and run them by hand to see what the database says.
  Or add some debug to get the exact sql queries being used.
 
 /* First, find the last good Full backup for this job/client/fileset */
 snip
 
  Thank you. The problem seems to be that the query doesn't account for
  the job name it is supposed to do, just the client and fileset. I have
  two jobs with the same fileset for each client. One backs up to local
  storage with a full/diff/incr cycle and a rather long retention period,
  the other does monthly full backups to another building for DR and gets
  immediately purged.
 
  I enabled accurate for the onsite job but the query returns the last
  full run of the offsite job. When I add AND Name = 'JobName' to the
  query it gets the right jobid.
 
  I think this qualifies for a bug, doesn't it?
  
  I agree with you, but...
  I have just remembered coming across this before. The thread starts here:
  http://www.mail-archive.com/bacula-devel@lists.sourceforge.net/msg04050.html
  
  Kern:
  Bacula does not support this option.
  
  Me:
  It does appear to be *trying* to support it, as some parts of the code that
  figure out dependent jobs take note of the job name, though others do not.
  
  Kern:
  I wouldn't exactly say that it is trying to support it, but rather that 
  since 
  the program is so complicated, and I try not to restrict it too much, there 
  are places where it can seem to work, but it is just not designed to do so 
  (at least at the moment), and thus it will not work.  It isn't that I don't 
  want it to work, but there is only so much that the developers can do in 
  the 
  time we have.
  
  Unfortunate what you are trying to do is simply not possible in the way you 
  are trying to do it with the current code.
 
 Great... so I have to create two identical filesets to get this to work?

Or add AND Name = 'JobName', as was your idea. Maybe it works fine.

 If this kind of setup is not supported, it would be nice if I'd get at
 least a warning by './bacula-dir -t' or something.
 
 Thanks for the help, though, I'll fix my config.
 
 
 Regards,
 Christian Manal
 
 
  
  
  
  Regards,
  Christian Manal
 
  --
  What Every C/C++ and Fortran developer Should Know!
  Read this article and learn how Intel has extended the reach of its 
  next-generation tools to help Windows* and Linux* C/C++ and Fortran 
  developers boost performance applications - including clusters. 
  http://p.sf.net/sfu/intel-dev2devmay
  ___
  Bacula-users mailing list
  Bacula-users@lists.sourceforge.net
  https://lists.sourceforge.net/lists/listinfo/bacula-users
  
  
  --
  What Every C/C++ and Fortran developer Should Know!
  Read this article and learn how Intel has extended the reach of its 
  next-generation tools to help Windows* and Linux* C/C++ and Fortran 
  developers boost performance applications - including clusters. 
  http://p.sf.net/sfu/intel-dev2devmay
  ___
  Bacula-users mailing list
  Bacula-users@lists.sourceforge.net
  https://lists.sourceforge.net/lists/listinfo/bacula-users
  
 
 
 --
 What Every C/C++ and Fortran developer Should Know!
 Read this article and learn how Intel has extended the reach of its 
 next-generation tools to help Windows* and Linux* C/C++ and Fortran 
 developers boost performance applications - including clusters. 
 http://p.sf.net/sfu/intel-dev2devmay
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users


--
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Postgres Error

2011-05-18 Thread Martin Simmons
 On Tue, 17 May 2011 20:40:27 -0700, Mike Seda said:
 
 Hi All,
 I'm currently attempting to stand up a Bacula Director on FreeBSD 8.2.
 
 I installed the following packages from FreeBSD Ports:
 bacula-client-5.0.3
 bacula-server-5.0.3
 postgresql-client-8.3.14,1
 postgresql-server-8.3.14
 
 Everything has gone pretty well so far, but I just ran into the error below:
 [pgsql@bmir-backup-dir /usr/local]$ share/bacula/grant_bacula_privileges
 Granting PostgreSQL privileges
 CREATE ROLE
 GRANT
 GRANT
 .
 .
 GRANT
 GRANT
 psql:stdin:38: ERROR:  relation jobhisto_jobid_seq does not exist
 GRANT
 GRANT
 .
 .
 GRANT
 GRANT
 Privileges for user bacula granted on database bacula.
 
 Any thoughts?

Was make_bacula_tables 100% successful?  In particular, did it create the
jobhisto table?

__Martin

--
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Accurate Job - Cannot find previous jobids

2011-05-18 Thread Christian Manal
Am 18.05.2011 13:08, schrieb Graham Keeling:
 On Wed, May 18, 2011 at 01:02:08PM +0200, Christian Manal wrote:
 Am 18.05.2011 12:26, schrieb Graham Keeling:
 On Wed, May 18, 2011 at 11:54:18AM +0200, Christian Manal wrote:
 Am 18.05.2011 11:13, schrieb Graham Keeling:
 If times don't explain it, take a look at this bacula code from
 src/cats/sql_get.c (function db_accurate_get_jobids()), which is getting
 the jobids from the database. You should be able to construct very similar
 queries and run them by hand to see what the database says.
 Or add some debug to get the exact sql queries being used.

/* First, find the last good Full backup for this job/client/fileset */
snip

 Thank you. The problem seems to be that the query doesn't account for
 the job name it is supposed to do, just the client and fileset. I have
 two jobs with the same fileset for each client. One backs up to local
 storage with a full/diff/incr cycle and a rather long retention period,
 the other does monthly full backups to another building for DR and gets
 immediately purged.

 I enabled accurate for the onsite job but the query returns the last
 full run of the offsite job. When I add AND Name = 'JobName' to the
 query it gets the right jobid.

 I think this qualifies for a bug, doesn't it?

 I agree with you, but...
 I have just remembered coming across this before. The thread starts here:
 http://www.mail-archive.com/bacula-devel@lists.sourceforge.net/msg04050.html

 Kern:
 Bacula does not support this option.

 Me:
 It does appear to be *trying* to support it, as some parts of the code that
 figure out dependent jobs take note of the job name, though others do not.

 Kern:
 I wouldn't exactly say that it is trying to support it, but rather that 
 since 
 the program is so complicated, and I try not to restrict it too much, there 
 are places where it can seem to work, but it is just not designed to do so 
 (at least at the moment), and thus it will not work.  It isn't that I don't 
 want it to work, but there is only so much that the developers can do in 
 the 
 time we have.

 Unfortunate what you are trying to do is simply not possible in the way you 
 are trying to do it with the current code.

 Great... so I have to create two identical filesets to get this to work?
 
 Or add AND Name = 'JobName', as was your idea. Maybe it works fine.\

Well, going by the thread you linked I just noticed that there is also
the issue of Bacula using the wrong jobs to create the restore filetree.
I'd rather not find out what else is affected by this and just do what
works. I also lack the c(++) skills to look further into this, I'm afraid.

Regards,
Christian Manal


 
 If this kind of setup is not supported, it would be nice if I'd get at
 least a warning by './bacula-dir -t' or something.

 Thanks for the help, though, I'll fix my config.


 Regards,
 Christian Manal





 Regards,
 Christian Manal

 --
 What Every C/C++ and Fortran developer Should Know!
 Read this article and learn how Intel has extended the reach of its 
 next-generation tools to help Windows* and Linux* C/C++ and Fortran 
 developers boost performance applications - including clusters. 
 http://p.sf.net/sfu/intel-dev2devmay
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users


 --
 What Every C/C++ and Fortran developer Should Know!
 Read this article and learn how Intel has extended the reach of its 
 next-generation tools to help Windows* and Linux* C/C++ and Fortran 
 developers boost performance applications - including clusters. 
 http://p.sf.net/sfu/intel-dev2devmay
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users



 --
 What Every C/C++ and Fortran developer Should Know!
 Read this article and learn how Intel has extended the reach of its 
 next-generation tools to help Windows* and Linux* C/C++ and Fortran 
 developers boost performance applications - including clusters. 
 http://p.sf.net/sfu/intel-dev2devmay
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users
 
 
 --
 What Every C/C++ and Fortran developer Should Know!
 Read this article and learn how Intel has extended the reach of its 
 next-generation tools to help Windows* and Linux* C/C++ and Fortran 
 developers boost performance applications - including clusters. 
 http://p.sf.net/sfu/intel-dev2devmay
 

Re: [Bacula-users] Base jobs and incremental backups

2011-05-18 Thread - -
2011/5/18 Pablo Marques pmarq...@miamilinux.net


 When you do a Base backup, you need to do a FULL immediately after,
 because the BASE backup is a special backup and you cannot restore only
 from it.

 From then on you can do Incrementals, Fulls or Differentials.

 All the FULL backups that you will run after that fist FULL are going to be
 very small,
 so you should only need to have the laptop on Gig on your first BASE
 backup.

 Hope this helps.

 Pablo


Hello !

That's an interesting point ! I did not understand when read the
documentation that a full is necessary after a base job. I though a base
replaces a full.
For me the interesting point of a base job was that you can do a base job of
a template server, and then backup n servers directly without having n
full backups to do. Writing that, I now understand better the concept of
base jobs, all the n full would contain pointers on the base jobs. Are there
any informations in the log file that prove the first full after a base job
is effectively using the base job ?
Something like running 'client-bkp job' based on 'based-job'  ?

So for my problem, I should try to do a floating IP between the 2 interface
- GiB and wifi - and do the backup on this interface: if the LAN cable is
connected, backup goes through the LAN, if there is only the wifi it would
use it. I think I can do that with a piece of script.  eth0 would be
client-lan, wlan0 client-wlan and the backup interface would be
client-bkp pointing on eth0:0 if cable is connected or wlan0:0.

Thanks for your help !

JC




 - Original Message -
 From: TipMeAbout tipmeab...@gmail.com
 To: bacula-users@lists.sourceforge.net
 Sent: Tuesday, May 17, 2011 5:09:10 PM
 Subject: Re: [Bacula-users] Base jobs and incremental backups

  On Mon, May 16, 2011 at 11:07 PM, TipMeAbout tipmeab...@gmail.com
 wrote:
   Hello all,
  
   I use Bacula for some times now and I experiment now the base job
 backup.
   I have to solve a problem and I need help: I have to backup a laptop.
  
   This laptop is most of the time connected by wifi. As it contains quite
   large
   data, I have decided to do a full the 1st of each month and an
   incremental the
   other days.
   To let the full run quickly, I decided that the laptop will be
 connected
   by its LAN 1Gb connection the 1st and by wifi the rest of the month. So
   I have 2
   client instances configured: client-lan and client-wlan, one for
 each
   type
   of backup, each with its own IP address. But when I start an
 incremental
   for
   client-wlan, Bacula tells me it does not find a valid full, so it
   starts a
   full through the wifi connection. Too long !!
   I have decided to do a base job the 1st of the month by LAN for
 instance
   client-lan and then each incremental for client-wlan would be based
   on this base job. It does not work neither as it still starts a full
   backup in wifi mode instead of incremental. I have read that a base job
   is like a full
   and let full backup base on it: so I change my incremental backup by a
   full with hope it would saved only some datas, for instance
   client-wlan. But after a while running, I have the impression Bacula
   does a new total full without taking into consideration the base job
   backup.
  
   So my questions are simple: does base job can be used with incremental
   backups
   to realise what I would like and how to do that ?
  
   Thanks in advance for your help !
  
  
   JC
  
  
   --
   http://www.tipmeabout.org
 
  Rather than try to backup the laptop with Bacula, I would use RSYNC to on
  the laptop and then backup the rsync mirror of the laptop, that way you
  don't rely on the laptop being connected and once you have done the
 initial
  rsync the  incrementals are much easier to manage over your WiFi
 bandwidth.
  You could also trigger your rsync job to run when the interface comes up,
  and if you did this over SSH via an Internet resolvable f.q.d.n then you
  can backup from anywhere
 
  Although Bacula is fantastic for backing up, sometimes other tools can
  make the overall process better


 Hello,

 Thanks for your answer !
 Of course I could use other tools, but the challenge is to do that with
 bacula
 and to highlight how to use base job backup as a base for incremental
 backup.

 By using RSYNC, I have to provide space left on the bacula server which
 would
 act as mirror, and then space to backup this mirror with bacula (I use
 backup
 on disk file of 4GiB).
 Moreover, the rsync would mirror data I don't care (iso, mpeg, jpg) which
 are
 space and bandwidth consuming through wifi; with bacula, it excluded from
 the
 beginning. And maintaining 2 lists of exclusion - one for each tool - is
 not
 the most recommended I think.

 If someone else has a proposal, I'm still open for an answer.
 I will myself think if a solution based on virtual IPs can be set up. If I
 found something, I would of course complete this thread.

  See you all !

  JC


 --
 

[Bacula-users] OneFS = no doesn't work

2011-05-18 Thread Roy Sigurd Karlsbakk
Hi all

Working on setting up Bacula backup of a fileserver, I can't make OneFS = no 
work. The server is running OpenIndiana and has a few terabytes of storage. The 
home directories under /tos-data/home/${username} are each a ZFS 
filesystem/dataset. The configuration below looks good to me, but Bacula still 
complains about /tos-data/home/znw is a different filesystem. Will not descend 
from /tos-data/home into it.

How can I make it decend automatically? We have ~30 users on this site, and 
it'll be far more flexible to just backup the lot than backing up each and 
every one of them

roy (see below for config)

# Home directories
FileSet {
  Name = verdande.nilu.no-home-fileset
  Include {
Options {
  signature = MD5
  OneFS  = no
  FSType = zfs
}
Options {
  Exclude = yes
  WildFile = *.mp3
}
File = /tos-data/home
  }
}


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

--
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] OneFS = no doesn't work

2011-05-18 Thread Graham Keeling
On Wed, May 18, 2011 at 04:31:15PM +0200, Roy Sigurd Karlsbakk wrote:
 Hi all
 
 Working on setting up Bacula backup of a fileserver, I can't make OneFS = no 
 work. The server is running OpenIndiana and has a few terabytes of storage. 
 The home directories under /tos-data/home/${username} are each a ZFS 
 filesystem/dataset. The configuration below looks good to me, but Bacula 
 still complains about /tos-data/home/znw is a different filesystem. Will not 
 descend from /tos-data/home into it.
 
 How can I make it decend automatically?

onefs = yes   ?


 We have ~30 users on this site, and it'll be far more flexible to just backup 
 the lot than backing up each and every one of them


 
 roy (see below for config)
 
 # Home directories
 FileSet {
   Name = verdande.nilu.no-home-fileset
   Include {
 Options {
   signature = MD5
   OneFS  = no
   FSType = zfs
 }
 Options {
   Exclude = yes
   WildFile = *.mp3
 }
 File = /tos-data/home
   }
 }
 
 
 -- 
 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.
 
 --
 What Every C/C++ and Fortran developer Should Know!
 Read this article and learn how Intel has extended the reach of its 
 next-generation tools to help Windows* and Linux* C/C++ and Fortran 
 developers boost performance applications - including clusters. 
 http://p.sf.net/sfu/intel-dev2devmay
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users


--
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] OneFS = no doesn't work

2011-05-18 Thread Graham Keeling
On Wed, May 18, 2011 at 04:05:45PM +0100, Graham Keeling wrote:
 On Wed, May 18, 2011 at 04:31:15PM +0200, Roy Sigurd Karlsbakk wrote:
  Hi all
  
  Working on setting up Bacula backup of a fileserver, I can't make OneFS = 
  no work. The server is running OpenIndiana and has a few terabytes of 
  storage. The home directories under /tos-data/home/${username} are each a 
  ZFS filesystem/dataset. The configuration below looks good to me, but 
  Bacula still complains about /tos-data/home/znw is a different filesystem. 
  Will not descend from /tos-data/home into it.
  
  How can I make it decend automatically?
 
 onefs = yes   ?

Sorry, my mistake. Having checked the documentation, you got it the right way
round. I don't know the answer.

  We have ~30 users on this site, and it'll be far more flexible to just 
  backup the lot than backing up each and every one of them
 
 
  
  roy (see below for config)
  
  # Home directories
  FileSet {
Name = verdande.nilu.no-home-fileset
Include {
  Options {
signature = MD5
OneFS  = no
FSType = zfs
  }
  Options {
Exclude = yes
WildFile = *.mp3
  }
  File = /tos-data/home
}
  }
  
  
  -- 
  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.
  
  --
  What Every C/C++ and Fortran developer Should Know!
  Read this article and learn how Intel has extended the reach of its 
  next-generation tools to help Windows* and Linux* C/C++ and Fortran 
  developers boost performance applications - including clusters. 
  http://p.sf.net/sfu/intel-dev2devmay
  ___
  Bacula-users mailing list
  Bacula-users@lists.sourceforge.net
  https://lists.sourceforge.net/lists/listinfo/bacula-users
 
 
 --
 What Every C/C++ and Fortran developer Should Know!
 Read this article and learn how Intel has extended the reach of its 
 next-generation tools to help Windows* and Linux* C/C++ and Fortran 
 developers boost performance applications - including clusters. 
 http://p.sf.net/sfu/intel-dev2devmay
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users


--
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Base jobs and incremental backups

2011-05-18 Thread Pablo Marques
 Are there any informations in the log file that prove the first full after a 
 base job is effectively using the base job ? 
The Bacula report after the FULL gives you very useful information, including 
the BASE backup files used. 

This is a sample report after a FULL backup, notice the line Base files/Used 
files: 

JobId: 371 
Job: server-fd-data.2011-05-09_16.58.33_17 
Backup Level: Full (upgraded from Incremental) 
Client: server-fd 5.0.3 (04Aug10) Linux,Cross-compile,Win32 
FileSet: server-set 2011-05-09 14:29:09 
Pool: Yearly (From User input) 
Catalog: MyCatalog (From Client resource) 
Storage: FileStorage (From Job resource) 
Scheduled time: 09-May-2011 16:58:24 
Start time: 09-May-2011 17:02:10 
End time: 09-May-2011 18:01:16 
Elapsed time: 59 mins 6 secs 
Priority: 10 
FD Files Written: 39,344 
SD Files Written: 39,344 
FD Bytes Written: 8,600,464,982 (8.600 GB) 
SD Bytes Written: 8,606,510,471 (8.606 GB) 
Rate: 2425.4 KB/s 
Software Compression: 39.7 % 
Base files/Used files: 39336/39114 (99.44%) 
VSS: yes 
Encryption: no 
Accurate: yes 
Volume name(s): Tape-Year-0001 
Volume Session Id: 358 
Volume Session Time: 1302812565 
Last Volume Bytes: 252,270,109,076 (252.2 GB) 
Non-fatal FD errors: 0 
SD Errors: 0 
FD termination status: OK 
SD termination status: OK 
Termination: Backup OK 

For your case, depending on how much data changes on the Laptop, it maybe OK 
just to leave it on the WiFi for all backups (except for the BASE). 

Pablo 
- Original Message -
From: - - tipmeab...@gmail.com 
To: Pablo Marques pmarq...@miamilinux.net 
Cc: bacula-users@lists.sourceforge.net 
Sent: Wednesday, May 18, 2011 9:10:55 AM 
Subject: Re: [Bacula-users] Base jobs and incremental backups 


2011/5/18 Pablo Marques  pmarq...@miamilinux.net  



When you do a Base backup, you need to do a FULL immediately after, 
because the BASE backup is a special backup and you cannot restore only from 
it. 

From then on you can do Incrementals, Fulls or Differentials. 

All the FULL backups that you will run after that fist FULL are going to be 
very small, 
so you should only need to have the laptop on Gig on your first BASE backup. 

Hope this helps. 

Pablo 








Hello ! 

That's an interesting point ! I did not understand when read the documentation 
that a full is necessary after a base job. I though a base replaces a full. 
For me the interesting point of a base job was that you can do a base job of a 
template server, and then backup n servers directly without having n full 
backups to do. Writing that, I now understand better the concept of base jobs, 
all the n full would contain pointers on the base jobs. Are there any 
informations in the log file that prove the first full after a base job is 
effectively using the base job ? 
Something like running 'client-bkp job' based on 'based-job'  ? 

So for my problem, I should try to do a floating IP between the 2 interface - 
GiB and wifi - and do the backup on this interface: if the LAN cable is 
connected, backup goes through the LAN, if there is only the wifi it would use 
it. I think I can do that with a piece of script. eth0 would be client-lan, 
wlan0 client-wlan and the backup interface would be client-bkp pointing on 
eth0:0 if cable is connected or wlan0:0. 

Thanks for your help ! 

JC 



blockquote


- Original Message - 
From: TipMeAbout  tipmeab...@gmail.com  
To: bacula-users@lists.sourceforge.net 
Sent: Tuesday, May 17, 2011 5:09:10 PM 
Subject: Re: [Bacula-users] Base jobs and incremental backups 

 On Mon, May 16, 2011 at 11:07 PM, TipMeAbout  tipmeab...@gmail.com  wrote: 
  Hello all, 
  
  I use Bacula for some times now and I experiment now the base job backup. 
  I have to solve a problem and I need help: I have to backup a laptop. 
  
  This laptop is most of the time connected by wifi. As it contains quite 
  large 
  data, I have decided to do a full the 1st of each month and an 
  incremental the 
  other days. 
  To let the full run quickly, I decided that the laptop will be connected 
  by its LAN 1Gb connection the 1st and by wifi the rest of the month. So 
  I have 2 
  client instances configured: client-lan and client-wlan, one for each 
  type 
  of backup, each with its own IP address. But when I start an incremental 
  for 
  client-wlan, Bacula tells me it does not find a valid full, so it 
  starts a 
  full through the wifi connection. Too long !! 
  I have decided to do a base job the 1st of the month by LAN for instance 
  client-lan and then each incremental for client-wlan would be based 
  on this base job. It does not work neither as it still starts a full 
  backup in wifi mode instead of incremental. I have read that a base job 
  is like a full 
  and let full backup base on it: so I change my incremental backup by a 
  full with hope it would saved only some datas, for instance 
  client-wlan. But after a while running, I have the impression Bacula 
  does a new total full without taking into 

Re: [Bacula-users] OneFS = no doesn't work

2011-05-18 Thread Roy Sigurd Karlsbakk


- Original Message -
 Hi all
 
 Working on setting up Bacula backup of a fileserver, I can't make
 OneFS = no work. The server is running OpenIndiana and has a few
 terabytes of storage. The home directories under
 /tos-data/home/${username} are each a ZFS filesystem/dataset. The
 configuration below looks good to me, but Bacula still complains about
 /tos-data/home/znw is a different filesystem. Will not descend from
 /tos-data/home into it.
 
 How can I make it decend automatically? We have ~30 users on this
 site, and it'll be far more flexible to just backup the lot than
 backing up each and every one of them
 
 roy (see below for config)
 
 # Home directories
 FileSet {
 Name = verdande.nilu.no-home-fileset
 Include {
 Options {
 signature = MD5
 OneFS = no
 FSType = zfs
 }
 Options {
 Exclude = yes
 WildFile = *.mp3
 }
 File = /tos-data/home
 }
 }

AFAICS, there's some code that might relate to this in 
src/findlib/find_one.c:639

 if(!(ff_pkt-flags  FO_MULTIFS)) {
ff_pkt-type = FT_NOFSCHG;
recurse = false;

This flag is set in src/filed/job.c:1065

  case 'f':
 fo-flags |= FO_MULTIFS;
 break;

Any idea what FD option that might map to 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.

--
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] make_catalog_backup authentication error

2011-05-18 Thread J. Echter
Am 18.05.2011 12:31, schrieb Tobias Dinse:
 Hi @all,
 
 make_catalog_backup works fine if i start it manually as bacula User.
 But with a Backup Schedule I always get the follow Error Msg:
 
 FATAL:  password authentication failed for user bacula
 
 
 */etc/postgresql/8.4/main/pg_hba.conf*:
 
 local   bacula  bacula 127.0.0.1/32   trust
 
 
 */var/lib/bacula/.pgpass:*
 127.0.0.1:5432:bacula:bacula:PASSWORD
 localhost:5432:bacula:bacula:PASSWORD
 
 
 *make_catalog_backup:*
 
 BINDIR=/usr/bin
 
 cd /var/lib/bacula
 rm -f $1.sql
 if test xsqlite = xpostgresql ; then
   echo .dump | ${BINDIR}/sqlite $1.db $1.sql
 else
   if test xmysql = xpostgresql ; then
 if test $# -gt 2; then
   MYSQLPASSWORD= --password=$3
 else
   MYSQLPASSWORD=
 fi
 if test $# -gt 3; then
   MYSQLHOST= --host=$4
 else
   MYSQLHOST=
 fi
 ${BINDIR}/mysqldump -u ${2}${MYSQLPASSWORD}${MYSQLHOST} -f --opt $1
$1.sql
   else
 if test xpostgresql = xpostgresql ; then
   if test $# -gt 2; then
 PGPASSWORD=$1
 export PGPASSWORD
   fi
   if test $# -gt 3; then
 PGHOST= --host=$4
   else
 PGHOST=
   fi
   # you could also add --compress for compression.  See man pg_dump
   #exec ${BINDIR}/pg_dump -c $PGHOST -U $2 $1 $1.sql
   exec ${BINDIR}/pg_dump -h localhost bacula |bzip2 -9 -f -c 
 bacula.sql.bz2
 else
   echo .dump | ${BINDIR}/sqlite3 $1.db $1.sql
 fi
   fi
 fi
 
 
 
 Thanks and regards
 
 Tobias
 
 
 
 
 --
 What Every C/C++ and Fortran developer Should Know!
 Read this article and learn how Intel has extended the reach of its 
 next-generation tools to help Windows* and Linux* C/C++ and Fortran 
 developers boost performance applications - including clusters. 
 http://p.sf.net/sfu/intel-dev2devmay
 
 
 
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users

Hi,

how do you start manually and how do you start it within the job?

cheers.

--
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Postgres Error

2011-05-18 Thread Mike Seda
Hi Martin,
It looks like make_bacula_tables succeeded. There were some notices (not 
errors) though, which are provided below:

[pgsql@bmir-backup-dir /usr/local]$ share/bacula/make_bacula_tables
Making PostgreSQL tables
psql:stdin:7: NOTICE:  CREATE TABLE will create implicit sequence 
filename_filenameid_seq for serial column filename.filenameid
psql:stdin:7: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit 
index filename_pkey for table filename
CREATE TABLE
ALTER TABLE
CREATE INDEX
psql:stdin:17: NOTICE:  CREATE TABLE will create implicit sequence 
path_pathid_seq for serial column path.pathid
psql:stdin:17: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index path_pkey for table path
CREATE TABLE
ALTER TABLE
CREATE INDEX
psql:stdin:33: NOTICE:  CREATE TABLE will create implicit sequence 
file_fileid_seq for serial column file.fileid
psql:stdin:33: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index file_pkey for table file
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:stdin:84: NOTICE:  CREATE TABLE will create implicit sequence 
job_jobid_seq for serial column job.jobid
psql:stdin:84: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index job_pkey for table job
CREATE TABLE
CREATE INDEX
CREATE TABLE
CREATE INDEX
psql:stdin:99: NOTICE:  CREATE TABLE will create implicit sequence 
location_locationid_seq for serial column location.locationid
psql:stdin:99: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index location_pkey for table location
CREATE TABLE
psql:stdin:109: NOTICE:  CREATE TABLE will create implicit sequence 
fileset_filesetid_seq for serial column fileset.filesetid
psql:stdin:109: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index fileset_pkey for table fileset
CREATE TABLE
CREATE INDEX
psql:stdin:126: NOTICE:  CREATE TABLE will create implicit sequence 
jobmedia_jobmediaid_seq for serial column jobmedia.jobmediaid
psql:stdin:126: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index jobmedia_pkey for table jobmedia
CREATE TABLE
CREATE INDEX
psql:stdin:178: NOTICE:  CREATE TABLE will create implicit sequence 
media_mediaid_seq for serial column media.mediaid
psql:stdin:178: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index media_pkey for table media
CREATE TABLE
CREATE INDEX
psql:stdin:188: NOTICE:  CREATE TABLE will create implicit sequence 
mediatype_mediatypeid_seq for serial column mediatype.mediatypeid
psql:stdin:188: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index mediatype_pkey for table mediatype
CREATE TABLE
psql:stdin:195: NOTICE:  CREATE TABLE will create implicit sequence 
storage_storageid_seq for serial column storage.storageid
psql:stdin:195: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index storage_pkey for table storage
CREATE TABLE
psql:stdin:214: NOTICE:  CREATE TABLE will create implicit sequence 
device_deviceid_seq for serial column device.deviceid
psql:stdin:214: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index device_pkey for table device
CREATE TABLE
psql:stdin:246: NOTICE:  CREATE TABLE will create implicit sequence 
pool_poolid_seq for serial column pool.poolid
psql:stdin:246: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index pool_pkey for table pool
CREATE TABLE
CREATE INDEX
psql:stdin:259: NOTICE:  CREATE TABLE will create implicit sequence 
client_clientid_seq for serial column client.clientid
psql:stdin:259: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index client_pkey for table client
CREATE TABLE
CREATE INDEX
psql:stdin:270: NOTICE:  CREATE TABLE will create implicit sequence 
log_logid_seq for serial column log.logid
psql:stdin:270: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index log_pkey for table log
CREATE TABLE
CREATE INDEX
psql:stdin:285: NOTICE:  CREATE TABLE will create implicit sequence 
locationlog_loclogid_seq for serial column locationlog.loclogid
psql:stdin:285: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index locationlog_pkey for table locationlog
CREATE TABLE
psql:stdin:297: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index counters_pkey for table counters
CREATE TABLE
psql:stdin:309: NOTICE:  CREATE TABLE will create implicit sequence 
basefiles_baseid_seq for serial column basefiles.baseid
psql:stdin:309: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index basefiles_pkey for table basefiles
CREATE TABLE
CREATE INDEX
psql:stdin:320: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index unsavedfiles_pkey for table unsavedfiles
CREATE TABLE
psql:stdin:327: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index cdimages_pkey for table cdimages
CREATE TABLE
psql:stdin:335: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index pathhierarchy_pkey for table pathhierarchy
CREATE TABLE
CREATE INDEX
psql:stdin:347: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index pathvisibility_pkey for table 

[Bacula-users] [SOLVED] OneFS = no doesn't work

2011-05-18 Thread Roy Sigurd Karlsbakk
 # Home directories
 FileSet {
   Name = verdande.nilu.no-home-fileset
   Include {
 Options {
   signature = MD5
   OneFS = no
   FSType = zfs
 }
 Options {
   Exclude = yes
   WildFile = *.mp3
 }
 File = /tos-data/home
   }
 }

FileSet {
  Name = verdande.nilu.no-home-fileset
  Include {
Options {
  signature = MD5
  OneFS = no
  FSType = zfs
  Exclude = yes
  WildFile = *.mp3
}
File = /tos-data/home
  }
}

Changing this to one single Options {} block as pasted above fixed this. I 
guess this should be fixed in the code for Bacula to either refuse two option 
blocks, or parse it correctly.

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.

--
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Postgres Error

2011-05-18 Thread Mike Seda
Hi Martin,
It turns out that I do have a jobhisto table after all:

bacula= SELECT table_name FROM information_schema.tables WHERE 
table_schema = 'public';
table_name

  location
  filename
  path
  file
  mediatype
  pool
  storage
  log
  fileset
  media
  locationlog
  jobhisto
  pathhierarchy
  unsavedfiles
  basefiles
  jobmedia
  job
  client
  counters
  version
  cdimages
  device
  status
  pathvisibility
(24 rows)

bacula=

Mike


On 05/18/2011 10:46 AM, Mike Seda wrote:
 Hi Martin,
 It looks like make_bacula_tables succeeded. There were some notices (not
 errors) though, which are provided below:

 [pgsql@bmir-backup-dir /usr/local]$ share/bacula/make_bacula_tables
 Making PostgreSQL tables
 psql:stdin:7: NOTICE:  CREATE TABLE will create implicit sequence
 filename_filenameid_seq for serial column filename.filenameid
 psql:stdin:7: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit
 index filename_pkey for table filename
 CREATE TABLE
 ALTER TABLE
 CREATE INDEX
 psql:stdin:17: NOTICE:  CREATE TABLE will create implicit sequence
 path_pathid_seq for serial column path.pathid
 psql:stdin:17: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index path_pkey for table path
 CREATE TABLE
 ALTER TABLE
 CREATE INDEX
 psql:stdin:33: NOTICE:  CREATE TABLE will create implicit sequence
 file_fileid_seq for serial column file.fileid
 psql:stdin:33: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index file_pkey for table file
 CREATE TABLE
 CREATE INDEX
 CREATE INDEX
 psql:stdin:84: NOTICE:  CREATE TABLE will create implicit sequence
 job_jobid_seq for serial column job.jobid
 psql:stdin:84: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index job_pkey for table job
 CREATE TABLE
 CREATE INDEX
 CREATE TABLE
 CREATE INDEX
 psql:stdin:99: NOTICE:  CREATE TABLE will create implicit sequence
 location_locationid_seq for serial column location.locationid
 psql:stdin:99: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index location_pkey for table location
 CREATE TABLE
 psql:stdin:109: NOTICE:  CREATE TABLE will create implicit sequence
 fileset_filesetid_seq for serial column fileset.filesetid
 psql:stdin:109: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index fileset_pkey for table fileset
 CREATE TABLE
 CREATE INDEX
 psql:stdin:126: NOTICE:  CREATE TABLE will create implicit sequence
 jobmedia_jobmediaid_seq for serial column jobmedia.jobmediaid
 psql:stdin:126: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index jobmedia_pkey for table jobmedia
 CREATE TABLE
 CREATE INDEX
 psql:stdin:178: NOTICE:  CREATE TABLE will create implicit sequence
 media_mediaid_seq for serial column media.mediaid
 psql:stdin:178: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index media_pkey for table media
 CREATE TABLE
 CREATE INDEX
 psql:stdin:188: NOTICE:  CREATE TABLE will create implicit sequence
 mediatype_mediatypeid_seq for serial column mediatype.mediatypeid
 psql:stdin:188: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index mediatype_pkey for table mediatype
 CREATE TABLE
 psql:stdin:195: NOTICE:  CREATE TABLE will create implicit sequence
 storage_storageid_seq for serial column storage.storageid
 psql:stdin:195: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index storage_pkey for table storage
 CREATE TABLE
 psql:stdin:214: NOTICE:  CREATE TABLE will create implicit sequence
 device_deviceid_seq for serial column device.deviceid
 psql:stdin:214: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index device_pkey for table device
 CREATE TABLE
 psql:stdin:246: NOTICE:  CREATE TABLE will create implicit sequence
 pool_poolid_seq for serial column pool.poolid
 psql:stdin:246: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index pool_pkey for table pool
 CREATE TABLE
 CREATE INDEX
 psql:stdin:259: NOTICE:  CREATE TABLE will create implicit sequence
 client_clientid_seq for serial column client.clientid
 psql:stdin:259: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index client_pkey for table client
 CREATE TABLE
 CREATE INDEX
 psql:stdin:270: NOTICE:  CREATE TABLE will create implicit sequence
 log_logid_seq for serial column log.logid
 psql:stdin:270: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index log_pkey for table log
 CREATE TABLE
 CREATE INDEX
 psql:stdin:285: NOTICE:  CREATE TABLE will create implicit sequence
 locationlog_loclogid_seq for serial column locationlog.loclogid
 psql:stdin:285: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index locationlog_pkey for table locationlog
 CREATE TABLE
 psql:stdin:297: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index counters_pkey for table counters
 CREATE TABLE
 psql:stdin:309: NOTICE:  CREATE TABLE will create implicit sequence
 basefiles_baseid_seq for serial column basefiles.baseid
 psql:stdin:309: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index 

Re: [Bacula-users] [Bacula-devel] [SOLVED] OneFS = no doesn't work

2011-05-18 Thread Kern Sibbald
Hello,

It is possible that the documentation is not as detailed or explicit as it 
could be, but the two different FileSets you wrote are totally different, and 
the parser works perfectly fine otherwise it would have reported an error. 

What is more likely is that the way two different Options blocks are 
interpreted (or executed) is non-trivial and different from what you 
understand.


Regards,

Kern

On Wednesday 18 May 2011 19:57:28 Roy Sigurd Karlsbakk wrote:
  # Home directories
  FileSet {
Name = verdande.nilu.no-home-fileset
Include {
  Options {
signature = MD5
OneFS = no
FSType = zfs
  }
  Options {
Exclude = yes
WildFile = *.mp3
  }
  File = /tos-data/home
}
  }

 FileSet {
   Name = verdande.nilu.no-home-fileset
   Include {
 Options {
   signature = MD5
   OneFS = no
   FSType = zfs
   Exclude = yes
   WildFile = *.mp3
 }
 File = /tos-data/home
   }
 }

 Changing this to one single Options {} block as pasted above fixed this. I
 guess this should be fixed in the code for Bacula to either refuse two
 option blocks, or parse it correctly.

 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.

 ---
--- What Every C/C++ and Fortran developer Should Know!
 Read this article and learn how Intel has extended the reach of its
 next-generation tools to help Windows* and Linux* C/C++ and Fortran
 developers boost performance applications - including clusters.
 http://p.sf.net/sfu/intel-dev2devmay
 ___
 Bacula-devel mailing list
 bacula-de...@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-devel



--
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Postgres Error

2011-05-18 Thread Mike Seda
All,
OK. It looks like this issue has shown up before and is not critical:
http://old.nabble.com/regression-tests%3A-jobhisto_jobid_seq-td28277084.html

If anyone else runs into this in the future, the relevant commit is at 
the following link:
http://www.bacula.org/git/cgit.cgi/bacula/commit/?id=fe35ad03e0bff911ab8c7fcea9684bba83e3e9b9

I'm not sure why this commit never made it into bacula-client-5.0.3 from 
FreeBSD Ports though.

Mike


On 05/18/2011 11:16 AM, Mike Seda wrote:
 Hi Martin,
 It turns out that I do have a jobhisto table after all:

 bacula= SELECT table_name FROM information_schema.tables WHERE 
 table_schema = 'public';
table_name
 
  location
  filename
  path
  file
  mediatype
  pool
  storage
  log
  fileset
  media
  locationlog
  jobhisto
  pathhierarchy
  unsavedfiles
  basefiles
  jobmedia
  job
  client
  counters
  version
  cdimages
  device
  status
  pathvisibility
 (24 rows)

 bacula=

 Mike


 On 05/18/2011 10:46 AM, Mike Seda wrote:
 Hi Martin,
 It looks like make_bacula_tables succeeded. There were some notices (not
 errors) though, which are provided below:

 [pgsql@bmir-backup-dir /usr/local]$ share/bacula/make_bacula_tables
 Making PostgreSQL tables
 psql:stdin:7: NOTICE:  CREATE TABLE will create implicit sequence
 filename_filenameid_seq for serial column filename.filenameid
 psql:stdin:7: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit
 index filename_pkey for table filename
 CREATE TABLE
 ALTER TABLE
 CREATE INDEX
 psql:stdin:17: NOTICE:  CREATE TABLE will create implicit sequence
 path_pathid_seq for serial column path.pathid
 psql:stdin:17: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index path_pkey for table path
 CREATE TABLE
 ALTER TABLE
 CREATE INDEX
 psql:stdin:33: NOTICE:  CREATE TABLE will create implicit sequence
 file_fileid_seq for serial column file.fileid
 psql:stdin:33: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index file_pkey for table file
 CREATE TABLE
 CREATE INDEX
 CREATE INDEX
 psql:stdin:84: NOTICE:  CREATE TABLE will create implicit sequence
 job_jobid_seq for serial column job.jobid
 psql:stdin:84: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index job_pkey for table job
 CREATE TABLE
 CREATE INDEX
 CREATE TABLE
 CREATE INDEX
 psql:stdin:99: NOTICE:  CREATE TABLE will create implicit sequence
 location_locationid_seq for serial column location.locationid
 psql:stdin:99: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index location_pkey for table location
 CREATE TABLE
 psql:stdin:109: NOTICE:  CREATE TABLE will create implicit sequence
 fileset_filesetid_seq for serial column fileset.filesetid
 psql:stdin:109: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index fileset_pkey for table fileset
 CREATE TABLE
 CREATE INDEX
 psql:stdin:126: NOTICE:  CREATE TABLE will create implicit sequence
 jobmedia_jobmediaid_seq for serial column jobmedia.jobmediaid
 psql:stdin:126: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index jobmedia_pkey for table jobmedia
 CREATE TABLE
 CREATE INDEX
 psql:stdin:178: NOTICE:  CREATE TABLE will create implicit sequence
 media_mediaid_seq for serial column media.mediaid
 psql:stdin:178: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index media_pkey for table media
 CREATE TABLE
 CREATE INDEX
 psql:stdin:188: NOTICE:  CREATE TABLE will create implicit sequence
 mediatype_mediatypeid_seq for serial column mediatype.mediatypeid
 psql:stdin:188: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index mediatype_pkey for table mediatype
 CREATE TABLE
 psql:stdin:195: NOTICE:  CREATE TABLE will create implicit sequence
 storage_storageid_seq for serial column storage.storageid
 psql:stdin:195: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index storage_pkey for table storage
 CREATE TABLE
 psql:stdin:214: NOTICE:  CREATE TABLE will create implicit sequence
 device_deviceid_seq for serial column device.deviceid
 psql:stdin:214: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index device_pkey for table device
 CREATE TABLE
 psql:stdin:246: NOTICE:  CREATE TABLE will create implicit sequence
 pool_poolid_seq for serial column pool.poolid
 psql:stdin:246: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index pool_pkey for table pool
 CREATE TABLE
 CREATE INDEX
 psql:stdin:259: NOTICE:  CREATE TABLE will create implicit sequence
 client_clientid_seq for serial column client.clientid
 psql:stdin:259: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index client_pkey for table client
 CREATE TABLE
 CREATE INDEX
 psql:stdin:270: NOTICE:  CREATE TABLE will create implicit sequence
 log_logid_seq for serial column log.logid
 psql:stdin:270: NOTICE:  CREATE TABLE / PRIMARY KEY will create
 implicit index log_pkey for table log
 CREATE TABLE
 CREATE INDEX
 psql:stdin:285: NOTICE:  CREATE TABLE will create implicit sequence
 locationlog_loclogid_seq for serial column 

Re: [Bacula-users] [Bacula-devel] [SOLVED] OneFS = no doesn't work

2011-05-18 Thread Roy Sigurd Karlsbakk
 It is possible that the documentation is not as detailed or explicit
 as it
 could be, but the two different FileSets you wrote are totally
 different, and
 the parser works perfectly fine otherwise it would have reported an
 error.
 
 What is more likely is that the way two different Options blocks are
 interpreted (or executed) is non-trivial and different from what you
 understand.

First of all, to my own defence, this configuration was something I took over 
after being absent from work a few weeks after an accident. We had a consultant 
do the initial installation, and I thought it was ok.

Secondly, after looking at the code, it looks like there is some built-in 
support for allowing multiple option blocks. A parameter 'pass' is passed to 
the functions, and the options struct is only initialised if the value of 
'pass' is one. However - I don't see this variable being incremented, but then, 
I've only spent an hour or so looking into the code, and I sometimes find 
object-oriented C a bit hard to follow.

Last, I would think the -t argument to bacula-dir should have reported this 
issue

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.

--
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] [Bacula-devel] [SOLVED] OneFS = no doesn't work

2011-05-18 Thread Kern Sibbald
On Wednesday 18 May 2011 21:45:57 Roy Sigurd Karlsbakk wrote:
  It is possible that the documentation is not as detailed or explicit
  as it
  could be, but the two different FileSets you wrote are totally
  different, and
  the parser works perfectly fine otherwise it would have reported an
  error.
 
  What is more likely is that the way two different Options blocks are
  interpreted (or executed) is non-trivial and different from what you
  understand.

 First of all, to my own defence, this configuration was something I took
 over after being absent from work a few weeks after an accident. We had a
 consultant do the initial installation, and I thought it was ok.

I understand.


 Secondly, after looking at the code, it looks like there is some built-in
 support for allowing multiple option blocks. 

Yes, multiple option blocks work and are very useful.  I refer you to the doc.

 A parameter 'pass' is passed 
 to the functions, and the options struct is only initialised if the value
 of 'pass' is one. However - I don't see this variable being incremented,
 but then, I've only spent an hour or so looking into the code, and I
 sometimes find object-oriented C a bit hard to follow.

Even though it is my code, I will leave this to some other developer to answer 
as I am a bit overloaded at the moment.


 Last, I would think the -t argument to bacula-dir should have reported this
 issue

The -t does not add any additional checking other than what is normally done.  
Bacula does not check for every inconsistent configuration options, and in 
this case, I think that everything is completely consistent so I am not sure 
what it should have found or how it would have found it.

Regards,

Kern


 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.



--
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] MaximumVolJobs not working!!!

2011-05-18 Thread pedro moreno
On Fri, May 13, 2011 at 6:02 AM, John Drescher dresche...@gmail.com wrote:
 On Fri, May 13, 2011 at 4:54 AM, Bacula bacula-l...@armin-tueting.com wrote:
 Hi Pedro,

   dolume Retention = 180 days
 This is should read Volume Retention = 180 days


 If that is what is in the file. Use the bconsole commands

 update pool from resource

 then

 update all volumes in pool

 Again I am going from memory so the commands may be not exactly what I 
 posted..

 John

 --
 Achieve unprecedented app performance and reliability
 What every C/C++ and Fortran developer should know.
 Learn how Intel has extended the reach of its next-generation tools
 to help boost performance applications - inlcuding clusters.
 http://p.sf.net/sfu/intel-dev2devmay
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users


Sorry guys, I'm back.

The config file is correct
dolume Retention = 180 days this was a type error here.

Bacula won't run if u have errors in your setup.

I have other issue right, but this case is not close, I will let u
know the status.

Thanks!!!

--
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Base jobs and incremental backups

2011-05-18 Thread TipMeAbout
Thank you Pablo for your help.
I will do a test with the base job done through LAN, then the full through 
wifi. I will post the result here.

JC


Le mercredi 18 mai 2011 j'ai reçu le message suivant:

  Are there any informations in the log file that prove the first full
  after a base job is effectively using the base job ?
 
 The Bacula report after the FULL gives you very useful information,
 including the BASE backup files used.
 
 This is a sample report after a FULL backup, notice the line Base
 files/Used files:
 
 JobId: 371
 Job: server-fd-data.2011-05-09_16.58.33_17
 Backup Level: Full (upgraded from Incremental)
 Client: server-fd 5.0.3 (04Aug10) Linux,Cross-compile,Win32
 FileSet: server-set 2011-05-09 14:29:09
 Pool: Yearly (From User input)
 Catalog: MyCatalog (From Client resource)
 Storage: FileStorage (From Job resource)
 Scheduled time: 09-May-2011 16:58:24
 Start time: 09-May-2011 17:02:10
 End time: 09-May-2011 18:01:16
 Elapsed time: 59 mins 6 secs
 Priority: 10
 FD Files Written: 39,344
 SD Files Written: 39,344
 FD Bytes Written: 8,600,464,982 (8.600 GB)
 SD Bytes Written: 8,606,510,471 (8.606 GB)
 Rate: 2425.4 KB/s
 Software Compression: 39.7 %
 Base files/Used files: 39336/39114 (99.44%)
 VSS: yes
 Encryption: no
 Accurate: yes
 Volume name(s): Tape-Year-0001
 Volume Session Id: 358
 Volume Session Time: 1302812565
 Last Volume Bytes: 252,270,109,076 (252.2 GB)
 Non-fatal FD errors: 0
 SD Errors: 0
 FD termination status: OK
 SD termination status: OK
 Termination: Backup OK
 
 For your case, depending on how much data changes on the Laptop, it maybe
 OK just to leave it on the WiFi for all backups (except for the BASE).
 
 Pablo
 - Original Message -
 From: - - tipmeab...@gmail.com
 To: Pablo Marques pmarq...@miamilinux.net
 Cc: bacula-users@lists.sourceforge.net
 Sent: Wednesday, May 18, 2011 9:10:55 AM
 Subject: Re: [Bacula-users] Base jobs and incremental backups
 
 
 2011/5/18 Pablo Marques  pmarq...@miamilinux.net 
 
 
 
 When you do a Base backup, you need to do a FULL immediately after,
 because the BASE backup is a special backup and you cannot restore only
 from it.
 
 From then on you can do Incrementals, Fulls or Differentials.
 
 All the FULL backups that you will run after that fist FULL are going to be
 very small, so you should only need to have the laptop on Gig on your
 first BASE backup.
 
 Hope this helps.
 
 Pablo
 
 
 
 
 
 
 
 
 Hello !
 
 That's an interesting point ! I did not understand when read the
 documentation that a full is necessary after a base job. I though a base
 replaces a full. For me the interesting point of a base job was that you
 can do a base job of a template server, and then backup n servers
 directly without having n full backups to do. Writing that, I now
 understand better the concept of base jobs, all the n full would contain
 pointers on the base jobs. Are there any informations in the log file that
 prove the first full after a base job is effectively using the base job ?
 Something like running 'client-bkp job' based on 'based-job'  ?
 
 So for my problem, I should try to do a floating IP between the 2 interface
 - GiB and wifi - and do the backup on this interface: if the LAN cable is
 connected, backup goes through the LAN, if there is only the wifi it would
 use it. I think I can do that with a piece of script. eth0 would be
 client-lan, wlan0 client-wlan and the backup interface would be
 client-bkp pointing on eth0:0 if cable is connected or wlan0:0.
 
 Thanks for your help !
 
 JC
 
 
 
 blockquote
 
 
 - Original Message -
 From: TipMeAbout  tipmeab...@gmail.com 
 To: bacula-users@lists.sourceforge.net
 Sent: Tuesday, May 17, 2011 5:09:10 PM
 Subject: Re: [Bacula-users] Base jobs and incremental backups
 
  On Mon, May 16, 2011 at 11:07 PM, TipMeAbout  tipmeab...@gmail.com  
wrote:
   Hello all,
   
   I use Bacula for some times now and I experiment now the base job
   backup. I have to solve a problem and I need help: I have to backup a
   laptop.
   
   This laptop is most of the time connected by wifi. As it contains quite
   large
   data, I have decided to do a full the 1st of each month and an
   incremental the
   other days.
   To let the full run quickly, I decided that the laptop will be
   connected by its LAN 1Gb connection the 1st and by wifi the rest of
   the month. So I have 2
   client instances configured: client-lan and client-wlan, one for
   each type
   of backup, each with its own IP address. But when I start an
   incremental for
   client-wlan, Bacula tells me it does not find a valid full, so it
   starts a
   full through the wifi connection. Too long !!
   I have decided to do a base job the 1st of the month by LAN for
   instance client-lan and then each incremental for client-wlan
   would be based on this base job. It does not work neither as it still
   starts a full backup in wifi mode instead of incremental. I have read
   that a base job is like a full
   and let full 

Re: [Bacula-users] [Bacula-devel] [SOLVED] OneFS = no doesn't work

2011-05-18 Thread Mehma Sarja
On 5/18/11 12:45 PM, Roy Sigurd Karlsbakk wrote:

 Last, I would think the -t argument to bacula-dir should have reported this 
 issue

Roy,

Sometimes it is just better to swallow.

Mehma

--
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] OneFS = no doesn't work

2011-05-18 Thread James Harper
 
 Working on setting up Bacula backup of a fileserver, I can't make OneFS = no
 work. The server is running OpenIndiana and has a few terabytes of storage.
 The home directories under /tos-data/home/${username} are each a ZFS
 filesystem/dataset. The configuration below looks good to me, but Bacula still
 complains about /tos-data/home/znw is a different filesystem. Will not
 descend from /tos-data/home into it.
 
 How can I make it decend automatically? We have ~30 users on this site, and
 it'll be far more flexible to just backup the lot than backing up each and
 every one of them
 
 roy (see below for config)
 
 # Home directories
 FileSet {
   Name = verdande.nilu.no-home-fileset
   Include {
 Options {
   signature = MD5
   OneFS  = no
   FSType = zfs
 }
 Options {
   Exclude = yes
   WildFile = *.mp3
 }
 File = /tos-data/home
   }
 }
 

The docs for fstype say The permitted filesystem-type names are: ext2, jfs, 
ntfs, proc, reiserfs, xfs, usbdevfs, sysfs, smbfs, iso9660. I don't see zfs in 
that list... maybe it has to be hardcoded into the source code?

Is there anything under /tos-data/home that isn't zfs? Would it be easier to 
exclude those manually?

James

--
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] OneFS = no doesn't work

2011-05-18 Thread Roy Sigurd Karlsbakk
 The docs for fstype say The permitted filesystem-type names are:
 ext2, jfs, ntfs, proc, reiserfs, xfs, usbdevfs, sysfs, smbfs,
 iso9660. I don't see zfs in that list... maybe it has to be hardcoded
 into the source code?

Nothing has been changed in the source, but it clearly works with ZFS.

 Is there anything under /tos-data/home that isn't zfs? Would it be
 easier to exclude those manually?

Everything's ZFS

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.

--
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users