date:20101020

Re: [Bacula-users] Unable to restore jobs created on one client, on another

2010-10-20 Thread Richard Scobie

Dan Langille wrote:

> Instead, what you're saying is:
>
> - backup of Box A was done to Storage Daemon backup1
> - tape was then moved to Storage Daemon flash

Yes, sorry for the confusion.

> Does the Director know that the tape has moved from one system to another?

Only in the sense that once the tapes were removed from backup1's 
autoloader, the command "update slots" was done.

Is there something else that needs doing?

Regards,

Richard

--
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in  U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store 
http://p.sf.net/sfu/nokia-dev2dev
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Unable to restore jobs created on one client, on another

2010-10-20 Thread Richard Scobie

Dan Langille wrote:

>> I don't understand here why it attempts to use "Drive-1", which is the
>> drive on the creation host, backup1.
>
> My guess: because that's where the Catalog says is it?

A "list media" for the Archive pool shows the "In changer" and "Slot" 
flag for AR0030L4 to be 0.

Regards,

Richard


--
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in  U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store 
http://p.sf.net/sfu/nokia-dev2dev
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Unable to restore jobs created on one client, on another

2010-10-20 Thread Dan Langille

On 10/20/2010 9:24 PM, Richard Scobie wrote:
> Bacula 5.0.2 Linux.
>
> I have a number of Jobs, written to LTO4 tape on a host, backup1, which
> I am trying to restore from  with the tapes loaded in a host called
> flash. Director is running on host library1.

The subject line appears misleading.  It makes me think you're trying to 
take a backup of box A and restore it to Box B.  This is rather straight 
forward.

Instead, what you're saying is:

- backup of Box A was done to Storage Daemon backup1
- tape was then moved to Storage Daemon flash

Does the Director know that the tape has moved from one system to another?


> These restores are failing with either an error:
>
> "RestoreFiles.2010-10-21_13.54.01_08  is waiting on max Storage jobs",
> and there are no other jobs pending, or fail completely with "Fatal Error".
>
> All bacula fds,sds and director have been restarted a number of times.
> Below is a typical fatal error scenario:
>
> "restore jobid="345" client="backup1-fd_arc"
> file="?restore_476707713_16" done
>
> 1 file selected to be restored.
>
> Bootstrap records written to /var/bacula/library1-dir.restore.1.bsr
>
> The job will require the following
>  Volume(s) Storage(s)SD Device(s)
> ===
>
>   AR0030L4  HP_MSL2024HP_MSL2024
>
> NOTE: HP_MSL2024 is attached to backup1 and job is modified to set flash
> as the restore client and storage:

This reads right to me.

>
> .mod restoreclient="flash-fd_arc" fileset="Full Set"
> storage="flash_LTO-4" replace="always" when="2010-10-21 12:00:30"
> bootstrap="/var/bacula/library1-dir.restore.1.bsr"
> where="/mnt/storage1/share/bacula/restores" priority="10" yes
> Job queued. JobId=466
>
> NOTE: A "status" shows:
>
> Select daemon type for status (1-4): library1-dir Version: 5.0.2 (28
> April 2010) x86_64-unknown-linux-gnu redhat
> Daemon started 21-Oct-10 11:56, 0 Jobs run since started.
>Heap: heap=135,168 smbytes=85,035 max_bytes=1,096,857 bufs=360
> max_bufs=365
> Full  Backup   1122-Oct-10 09:10   BackupCatalog
>   Catalog2
>  466  RestoreFiles.2010-10-21_12.00.58_04is waiting
> on Storage flash_LTO-4
>
> NOTE: the requested volume is then mounted:
>
> Select Storage resource (1-3): 3001 Mounted Volume: AR0030L4
> 3001 Device "flash_LTO-4" (/dev/nst0) is mounted with Volume "AR0030L4"
>
> NOTE: At this point the job fails with a fatal error.
>
> 21-Oct 12:01 library1-dir JobId 466: Start Restore Job
> RestoreFiles.2010-10-21_12.00.58_04
> 21-Oct 12:05 library1-dir JobId 466: Using Device "flash_LTO-4"
> 21-Oct 12:05 flash-sd JobId 466: Fatal error: No Volume names found for
> restore.
> 21-Oct 12:05 flash-fd JobId 466: Fatal error: job.c:2004 Bad response to
> Read Data command. Wanted 3000 OK data
> , got 3000 error
>
> 21-Oct 12:05 library1-dir JobId 466: Using Device "Drive-1"
> 21-Oct 12:05 flash-fd JobId 466: Fatal error: Failed to authenticate
> Storage daemon.
> 21-Oct 12:05 library1-dir JobId 466: Fatal error: Bad response to
> Storage command: wanted 2000 OK storage
> , got 2902 Bad storage
>
> 21-Oct 12:05 library1-dir JobId 466: Error: Bacula library1-dir 5.0.2
> (28Apr10): 21-Oct-2010 12:05:07
> Build OS:   x86_64-unknown-linux-gnu redhat
> JobId:  466
> Job:RestoreFiles.2010-10-21_12.00.58_04
> Restore Client: flash-fd_arc
> Start time: 21-Oct-2010 12:01:00
> End time:   21-Oct-2010 12:05:07
> Files Expected: 1
> Files Restored: 0
> Bytes Restored: 0
> Rate:   0.0 KB/s
> FD Errors:  0
> FD termination status:
> SD termination status:  Waiting on FD
> Termination:*** Restore Error ***
>
> 21-Oct 12:05 library1-dir JobId 466: Error: Bacula library1-dir 5.0.2
> (28Apr10): 21-Oct-2010 12:05:07
> Build OS:   x86_64-unknown-linux-gnu redhat
> JobId:  466
> Job:RestoreFiles.2010-10-21_12.00.58_04
> Restore Client: flash-fd_arc
> Start time: 21-Oct-2010 12:01:00
> End time:   21-Oct-2010 12:05:07
> Files Expected: 1
> Files Restored: 0
> Bytes Restored: 0
> Rate:   0.0 KB/s
> FD Errors:  1
> FD termination status:
> SD termination status:  Waiting on FD
> Termination:*** Restore Error ***
>
> I don't understand here why it attempts to use "Drive-1", which is the
> drive on the creation host, backup1.

My guess: because that's where the Catalog says is it?

>
> Am I missing something basic here? All the jobs tried restore OK on
> backup1, where they were created.
>
> Regards,
>
> Richard
>
>
> --

[Bacula-users] Unable to restore jobs created on one client, on another

2010-10-20 Thread Richard Scobie

Bacula 5.0.2 Linux.

I have a number of Jobs, written to LTO4 tape on a host, backup1, which 
I am trying to restore from  with the tapes loaded in a host called 
flash. Director is running on host library1.

These restores are failing with either an error:

"RestoreFiles.2010-10-21_13.54.01_08is waiting on max Storage jobs", 
and there are no other jobs pending, or fail completely with "Fatal Error".

All bacula fds,sds and director have been restarted a number of times. 
Below is a typical fatal error scenario:

"restore jobid="345" client="backup1-fd_arc" 
file="?restore_476707713_16" done

1 file selected to be restored.

Bootstrap records written to /var/bacula/library1-dir.restore.1.bsr

The job will require the following
Volume(s) Storage(s)SD Device(s)
===

 AR0030L4  HP_MSL2024HP_MSL2024

NOTE: HP_MSL2024 is attached to backup1 and job is modified to set flash 
as the restore client and storage:

.mod restoreclient="flash-fd_arc" fileset="Full Set" 
storage="flash_LTO-4" replace="always" when="2010-10-21 12:00:30" 
bootstrap="/var/bacula/library1-dir.restore.1.bsr" 
where="/mnt/storage1/share/bacula/restores" priority="10" yes
Job queued. JobId=466

NOTE: A "status" shows:

Select daemon type for status (1-4): library1-dir Version: 5.0.2 (28 
April 2010) x86_64-unknown-linux-gnu redhat
Daemon started 21-Oct-10 11:56, 0 Jobs run since started.
  Heap: heap=135,168 smbytes=85,035 max_bytes=1,096,857 bufs=360 
max_bufs=365
Full  Backup   1122-Oct-10 09:10   BackupCatalog 
 Catalog2
466  RestoreFiles.2010-10-21_12.00.58_04is waiting 
on Storage flash_LTO-4

NOTE: the requested volume is then mounted:

Select Storage resource (1-3): 3001 Mounted Volume: AR0030L4
3001 Device "flash_LTO-4" (/dev/nst0) is mounted with Volume "AR0030L4"

NOTE: At this point the job fails with a fatal error.

21-Oct 12:01 library1-dir JobId 466: Start Restore Job 
RestoreFiles.2010-10-21_12.00.58_04
21-Oct 12:05 library1-dir JobId 466: Using Device "flash_LTO-4"
21-Oct 12:05 flash-sd JobId 466: Fatal error: No Volume names found for 
restore.
21-Oct 12:05 flash-fd JobId 466: Fatal error: job.c:2004 Bad response to 
Read Data command. Wanted 3000 OK data
, got 3000 error

21-Oct 12:05 library1-dir JobId 466: Using Device "Drive-1"
21-Oct 12:05 flash-fd JobId 466: Fatal error: Failed to authenticate 
Storage daemon.
21-Oct 12:05 library1-dir JobId 466: Fatal error: Bad response to 
Storage command: wanted 2000 OK storage
, got 2902 Bad storage

21-Oct 12:05 library1-dir JobId 466: Error: Bacula library1-dir 5.0.2 
(28Apr10): 21-Oct-2010 12:05:07
   Build OS:   x86_64-unknown-linux-gnu redhat
   JobId:  466
   Job:RestoreFiles.2010-10-21_12.00.58_04
   Restore Client: flash-fd_arc
   Start time: 21-Oct-2010 12:01:00
   End time:   21-Oct-2010 12:05:07
   Files Expected: 1
   Files Restored: 0
   Bytes Restored: 0
   Rate:   0.0 KB/s
   FD Errors:  0
   FD termination status:
   SD termination status:  Waiting on FD
   Termination:*** Restore Error ***

21-Oct 12:05 library1-dir JobId 466: Error: Bacula library1-dir 5.0.2 
(28Apr10): 21-Oct-2010 12:05:07
   Build OS:   x86_64-unknown-linux-gnu redhat
   JobId:  466
   Job:RestoreFiles.2010-10-21_12.00.58_04
   Restore Client: flash-fd_arc
   Start time: 21-Oct-2010 12:01:00
   End time:   21-Oct-2010 12:05:07
   Files Expected: 1
   Files Restored: 0
   Bytes Restored: 0
   Rate:   0.0 KB/s
   FD Errors:  1
   FD termination status:
   SD termination status:  Waiting on FD
   Termination:*** Restore Error ***

I don't understand here why it attempts to use "Drive-1", which is the 
drive on the creation host, backup1.

Am I missing something basic here? All the jobs tried restore OK on 
backup1, where they were created.

Regards,

Richard


--
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in  U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store 
http://p.sf.net/sfu/nokia-dev2dev
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] premature recycling

2010-10-20 Thread Dan Langille

I'm getting recycling before retention expires.  Or so I think.  It may be
possible that the Pools definitions are out of date, but before I run an
update command, I wanted to see if anyone saw something out of order here.

This is the Volume before it was recycled:

Pool: FullsFile
| mediaid | volumename| volstatus | enabled | volbytes  | volfiles
| volretention | recycle | slot | inchanger | mediatype | lastwritten 
   |
| 445 | FileAuto-0445 | Full  |   1 | 5,368,691,646 |1
|   94,608,000 |   1 |0 | 0 | File  | 2010-04-16
08:24:59 |

That is 3 years retention. Last written April this year

The Volume is then recycled during the job:

20-Oct 20:18 kraken-sd JobId 39232: User defined maximum volume capacity
5,368,709,120 exceeded on device "MegaFile"
(/storage/compressed/bacula/volumes).
20-Oct 20:18 kraken-sd JobId 39232: End of medium on Volume
"FileAuto-0437" Bytes=5,368,688,857 Blocks=83,220 at 20-Oct-2010 15:18.
20-Oct 20:18 bacula-dir JobId 39232: There are no more Jobs associated
with Volume "FileAuto-0445". Marking it purged.
20-Oct 20:18 bacula-dir JobId 39232: All records pruned from Volume
"FileAuto-0445"; marking it "Purged"
20-Oct 20:18 bacula-dir JobId 39232: Recycled volume "FileAuto-0445"
20-Oct 20:18 kraken-sd JobId 39232: Recycled volume "FileAuto-0445" on
device "MegaFile" (/storage/compressed/bacula/volumes), all previous data
lost.
20-Oct 20:18 kraken-sd JobId 39232: New volume "FileAuto-0445" mounted on
device "MegaFile" (/storage/compressed/bacula/volumes) at 20-Oct-2010
15:18.

The job, storage, and some pools.


Job {
  Name= "kraken"
  JobDefs = "DefaultJob"
  Client  = kraken-fd
  FileSet = "kraken files"
  Storage = MegaFile-kraken
  Pool= MegaFile-kraken
  Write Bootstrap = "/home/bacula/working/kraken-fd.bsr"

  Schedule = "WeeklyCycle"
}


Storage {
  Name   = MegaFile-kraken
  Address= kraken.unixathome.org
  SDPort = 9103
  Password   = "YesThisReallyIsMyPassword"
  Device = MegaFile-kraken
  Media Type = File
}


Pool {
  Name = MegaFile-kraken
  Pool Type= Backup
  Recycle  = yes
  AutoPrune= yes
  Volume Retention = 3 years
  Storage  = MegaFile-kraken

  Maximum Volume Bytes = 5G

  LabelFormat = "FileAuto-"
}


Pool {
  Name = FullsFile
  Pool Type= Backup
  Recycle  = yes
  AutoPrune= yes
  Volume Retention = 3 years
  Storage  = MegaFile

  Maximum Volume Bytes = 5G

  LabelFormat = "FileAuto-"
}

This is the only pool with a "Purge Oldest Volume" directive.

Pool {
  Name = FilePool
  Pool Type= Backup
  Recycle  = yes
  AutoPrune= yes
  Volume Retention = 1 year
  Next Pool= Default

  Storage  = File

  Maximum Volume Bytes = 5G

  LabelFormat = "FileAuto-"

  Maximum Volumes = 67
  Purge Oldest Volume = yes
}






-- 
Dan Langille -- http://langille.org/


--
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in  U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store 
http://p.sf.net/sfu/nokia-dev2dev
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] get_file_record want 1 got rows=2 after migration from MySQL to PostgreSQL

2010-10-20 Thread Martin Simmons

Indeed, the copy job is an administative job, which creates a second job that
is the copy.  The latest select output shows the same FileIndex and LStat
atime for both jobs as expected.

__Martin


> On Wed, 20 Oct 2010 16:41:16 +0200, Robert Oschwald said:
> 
> Martin, thanks for your suggestions.
> 
> I now did a test:
>  - Noted the last fileid in db.
>  - Ran BackupCatalog job. In the file table, one entry was added for this job 
> (JobID=3366):
> 
> select * from file where fileid > 273350941;
> 273350942;1;3366;7656;46696;0;"P0B stOS IGg B Bk Bl A FS1p6i BAA qZXI BMvvaQ 
> BMvveo BMvveo A A C";"IIuhxgZwyUMitZ4C4p5m4g"
> 
>  - Then I ran the duplicate to tape job.
> One thing I note is that the copy job is running (JobId=3367), and the 
> BackupCatalog job is also again running (JobID=3368) when I start the copy 
> job.
> 
> After copy, I checked the file entries again:
> select * from file where fileid > 273350941;
> 273350942;1;3366;7656;46696;0;"P0B stOS IGg B Bk Bl A FS1p6i BAA qZXI BMvvaQ 
> BMvveo BMvveo A A C";"IIuhxgZwyUMitZ4C4p5m4g"
> 273350943;1;3368;7656;46696;0;"P0B stOS IGg B Bk Bl A FS1p6i BAA qZXI BMvvaQ 
> BMvveo BMvveo A A C";"IIuhxgZwyUMitZ4C4p5m4g"
> 
> As you can see, one entry was added for JobID 3368.
> 
> So copy seems not to be the cause of the problem.
> 
> 
> Robert
> 
> 
> 
> Am 19.10.2010 um 16:57 schrieb Martin Simmons:
> 
> > I don't know if it the duplicates are caused by the copy job, but there are
> > two interesting differences between the rows:
> > 
> > 1) The atime (access time) field in the LStat is different (BMvLg8 vs 
> > BMvJgV),
> >   suggesting that the file's stat was read more than once.
> > 
> > 2) The FileIndex values are different (128385 vs 86).  These values 
> > increment
> >   from 1 at the start of the job, so it seems that the order of the files in
> >   the jobs is not very similar.
> > 
> > I think you need to do some tests, maybe periodically recording the value of
> > 
> > select max(fileid) from file;
> > 
> > to try to discover when the rows are added.
> > 
> > __Martin
> > 
> > 
> > 
> > 
> >> On Tue, 19 Oct 2010 14:28:24 +0200, Robert Oschwald said:
> >> 
> >> Today I checked again the migrated pg82 db for last nights incremental of 
> >> one of the servers.
> >> Still the same error  for this backup's new entries when I click on one of 
> >> the nodes in the bat restore select tree:
> >> 
> >> sql_get.c:156-0 === Problem!  sql_get.c:155 get_file_record want 1 got 
> >> rows=2 PathId=138243 FilenameId=2533203
> >> 
> >> DB entry check:
> >> SELECT * FROM public.file WHERE  file.filenameid = 2533203 AND 
> >> pathid=138243 and jobid = 3347;
> >> 
> >> Result:
> >> FileId FileIndex   JobId   PathId  FilenameId  MarkId  LStat   
> >> MD5
> >> 273044923 128385 3347 138243  2533203   0  "P0G VIFW IGk B 
> >> A A A IB BAA I BMvLg8 BMvJIy BMvJIy A A E"  "3eBz2t04SgJGcJFHVq62Mw"
> >> 273041096 86 3347 138243  2533203   0  "P0G VIFW IGk B 
> >> A A A IB BAA I BMvJgV BMvJIy BMvJIy A A E"  "3eBz2t04SgJGcJFHVq62Mw"
> >> 
> >> I then checked my old Bacula 5.0.2 MySQL Database.
> >> Here is a query for one of the oldest backups I have in the former mysql 
> >> db:
> >> 
> >> SELECT * FROM File WHERE  filenameid = 42066 AND pathid=102145 and jobid = 
> >> 2941;
> >> 
> >> FileIdFileIndex JobId  PathIdFilenameId MarkId  LStat  
> >> MD5
> >> 228247316  1910509 2941  102145  42066 0   P0C OhMx IGk B 
> >> A A A J8 BAA I BMiHlI BDIcWc BLkzrq A A E  SiJb2FBj/EYO/nmnkj9i7w
> >> 229942749  3605942 2941  102145  42066 0   P0C OhMx IGk B 
> >> A A A J8 BAA I BMkXTF BDIcWc BLkzrq A A E  SiJb2FBj/EYO/nmnkj9i7w
> >> 
> >> Even in the former MySQL DB I got two entries for each file in the db.
> >> 
> >> Maybe this is related to the copy job for the "Default" Pool which copies 
> >> to LTO-4 tapes (B2D2T) after all backups to the Default (disk) pool?
> >> 
> >> Pool {
> >>  Name = Default
> >>  Pool Type = Backup
> >>  Storage = File
> >>  Recycle = yes
> >>  AutoPrune = yes
> >>  Volume Retention = 14 days
> >>  LabelFormat = b2d-
> >>  Maximum Volume Bytes = 50G
> >>  # Duplicate: Next pool to use if running copy jobs
> >>  NextPool = Tape
> >> }
> >> 
> >> Note that the error message is only displayed if:
> >> - You start bacula-dir manually in the console or
> >> - Add 2>&1 > log_file to the init.d start() line
> >> 
> >> e.g.:
> >> daemon /usr/sbin/bacula-dir $2 ${DIR_OPTIONS} -c 
> >> /etc/bacula/bacula-dir.conf 2>&1 > /var/log/bacula_startup.log
> >> 
> >> on CentOS5.
> >> 
> >> Any ideas?
> >> 
> >> Robert
> >> 
> >> 
>  On Mon, 18 Oct 2010 09:54:28 +0200, Robert Oschwald said:
>  
>  I migrated Bacula 5.0.2 from MySQL to Bacula 5.0.3 PostgreSQL 8.1, 
>  and then migrated to PostgreSQL 8.2 using dump/restore.
>  ...snip...
>  Migration from PostgreSQL 8.1 to 8.2:
>  pg_dumpall > pg_dump.sql
>  - install postgreSQL 8.2 (

Re: [Bacula-users] get_file_record want 1 got rows=2 after migration from MySQL to PostgreSQL

2010-10-20 Thread Robert Oschwald

Martin, thanks for your suggestions.

I now did a test:
 - Noted the last fileid in db.
 - Ran BackupCatalog job. In the file table, one entry was added for this job 
(JobID=3366):

select * from file where fileid > 273350941;
273350942;1;3366;7656;46696;0;"P0B stOS IGg B Bk Bl A FS1p6i BAA qZXI BMvvaQ 
BMvveo BMvveo A A C";"IIuhxgZwyUMitZ4C4p5m4g"

 - Then I ran the duplicate to tape job.
One thing I note is that the copy job is running (JobId=3367), and the 
BackupCatalog job is also again running (JobID=3368) when I start the copy job.

After copy, I checked the file entries again:
select * from file where fileid > 273350941;
273350942;1;3366;7656;46696;0;"P0B stOS IGg B Bk Bl A FS1p6i BAA qZXI BMvvaQ 
BMvveo BMvveo A A C";"IIuhxgZwyUMitZ4C4p5m4g"
273350943;1;3368;7656;46696;0;"P0B stOS IGg B Bk Bl A FS1p6i BAA qZXI BMvvaQ 
BMvveo BMvveo A A C";"IIuhxgZwyUMitZ4C4p5m4g"

As you can see, one entry was added for JobID 3368.

So copy seems not to be the cause of the problem.


Robert



Am 19.10.2010 um 16:57 schrieb Martin Simmons:

> I don't know if it the duplicates are caused by the copy job, but there are
> two interesting differences between the rows:
> 
> 1) The atime (access time) field in the LStat is different (BMvLg8 vs BMvJgV),
>   suggesting that the file's stat was read more than once.
> 
> 2) The FileIndex values are different (128385 vs 86).  These values increment
>   from 1 at the start of the job, so it seems that the order of the files in
>   the jobs is not very similar.
> 
> I think you need to do some tests, maybe periodically recording the value of
> 
> select max(fileid) from file;
> 
> to try to discover when the rows are added.
> 
> __Martin
> 
> 
> 
> 
>> On Tue, 19 Oct 2010 14:28:24 +0200, Robert Oschwald said:
>> 
>> Today I checked again the migrated pg82 db for last nights incremental of 
>> one of the servers.
>> Still the same error  for this backup's new entries when I click on one of 
>> the nodes in the bat restore select tree:
>> 
>> sql_get.c:156-0 === Problem!  sql_get.c:155 get_file_record want 1 got 
>> rows=2 PathId=138243 FilenameId=2533203
>> 
>> DB entry check:
>> SELECT * FROM public.file WHERE  file.filenameid = 2533203 AND pathid=138243 
>> and jobid = 3347;
>> 
>> Result:
>> FileId   FileIndex   JobId   PathId  FilenameId  MarkId  LStat   
>> MD5
>> 273044923 128385 3347 138243  2533203   0  "P0G VIFW IGk B A 
>> A A IB BAA I BMvLg8 BMvJIy BMvJIy A A E"  "3eBz2t04SgJGcJFHVq62Mw"
>> 273041096 86 3347 138243  2533203   0  "P0G VIFW IGk B A 
>> A A IB BAA I BMvJgV BMvJIy BMvJIy A A E"  "3eBz2t04SgJGcJFHVq62Mw"
>> 
>> I then checked my old Bacula 5.0.2 MySQL Database.
>> Here is a query for one of the oldest backups I have in the former mysql db:
>> 
>> SELECT * FROM File WHERE  filenameid = 42066 AND pathid=102145 and jobid = 
>> 2941;
>> 
>> FileId  FileIndex JobId  PathIdFilenameId MarkId  LStat  
>> MD5
>> 2282473161910509 2941  102145  42066 0   P0C OhMx IGk B 
>> A A A J8 BAA I BMiHlI BDIcWc BLkzrq A A E  SiJb2FBj/EYO/nmnkj9i7w
>> 2299427493605942 2941  102145  42066 0   P0C OhMx IGk B 
>> A A A J8 BAA I BMkXTF BDIcWc BLkzrq A A E  SiJb2FBj/EYO/nmnkj9i7w
>> 
>> Even in the former MySQL DB I got two entries for each file in the db.
>> 
>> Maybe this is related to the copy job for the "Default" Pool which copies to 
>> LTO-4 tapes (B2D2T) after all backups to the Default (disk) pool?
>> 
>> Pool {
>>  Name = Default
>>  Pool Type = Backup
>>  Storage = File
>>  Recycle = yes
>>  AutoPrune = yes
>>  Volume Retention = 14 days
>>  LabelFormat = b2d-
>>  Maximum Volume Bytes = 50G
>>  # Duplicate: Next pool to use if running copy jobs
>>  NextPool = Tape
>> }
>> 
>> Note that the error message is only displayed if:
>> - You start bacula-dir manually in the console or
>> - Add 2>&1 > log_file to the init.d start() line
>> 
>> e.g.:
>> daemon /usr/sbin/bacula-dir $2 ${DIR_OPTIONS} -c /etc/bacula/bacula-dir.conf 
>> 2>&1 > /var/log/bacula_startup.log
>> 
>> on CentOS5.
>> 
>> Any ideas?
>> 
>> Robert
>> 
>> 
 On Mon, 18 Oct 2010 09:54:28 +0200, Robert Oschwald said:
 
 I migrated Bacula 5.0.2 from MySQL to Bacula 5.0.3 PostgreSQL 8.1, 
 and then migrated to PostgreSQL 8.2 using dump/restore.
 ...snip...
 Migration from PostgreSQL 8.1 to 8.2:
 pg_dumpall > pg_dump.sql
 - install postgreSQL 8.2 (CentOS-Testing)
 psql < pg_dump.sql
>>> 
>>> Did you start with an empty database when you imported the dump after
>>> migration from PostgreSQL 8.1 to 8.2?  I suspect not, because you have
>>> everything twice.
>>> 
>>> 
 
 
 Are these error messages critical?
>>> 
>>> Yes.
>>> 
>>> __Martin
>>> 
>>> --
>>> Download new Adobe(R) Flash(R) Builder(TM) 4
>>> The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly 
>>> Flex(R) Builder

Re: [Bacula-users] How to parse Bacula conf files

2010-10-20 Thread Josh Fisher

On 10/19/2010 8:28 AM, Yuri Timofeev wrote:
> Hi
>
> During development the prototype of the my new system (Webacula 5.5),
> I tried to parse the bacula-dir.conf.
> However, this is probably not possible with simple regexp's.
> It turned out that some applications, for example, Webmin does this
> with a regexp

I don't think regexp will work. The best way is to translate the C code 
from the Bacula source into PHP. Since you are requiring PHP 5.0 or 
above, I think, then the values could be placed in a class object, just 
as Bacula puts them in C struct. Or, since all directives are key=value 
pairs, you could just put them in an associative array.

--
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in  U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store 
http://p.sf.net/sfu/nokia-dev2dev
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] current message appears when trying to launch bacula from webmin module

2010-10-20 Thread Heitor Faria


On 20-10-2010 09:27, Dantuma Computer Services wrote:


Failed to connect to the Bacula database : Failed to load the database 
DBI driver Pg at ./bacula-backup-lib.pl line 44. Maybe it is not set 
up, or the module configuration 
 is 
incorrect


What database are you using for Bacula? If its postgresql, you need to 
uncomment the "dbi driver" line on the Catalog resource 
(bacula-dir.conf) and also configure db port (likely 5432).


1st obs.: Dont sent signature attachments or html content to mail list. 
It only generates more trash, and its unsafe if compared to plain text.
2nd obs.: No one think its cool telling all your certifications on the 
mail signature. Worse: advertising that you are a Microsoft Certified 
Professional means you don't know nothing about computers. =P


Regards,

Heitor Faria
--
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly 
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] bacula director not running in webmin

2010-10-20 Thread Heitor Faria





Moderator?

On 20-10-2010 09:24, Dantuma Computer Services wrote:

  
  

  
  
   
   
  Kind
Regards,
  
    
  Johan
Dantuma
  
  Dantuma
Computer Services 
  Tel: 
033 345 8563 / 083
272 1779 
  Fax: 
088 033 345 8563
  
  e-mail: 
dc...@telkomsa.net 
  
  
  
   
  Dantuma
Computer Services
  “We
are driven by service to provide our clients with
cost effective implementation of complete Managed Outsource IT
solutions”
   
  Dantuma
Computer Services welcome all comments or suggestions
to improve our customer service
  Should you
experience
any dissatisfaction regarding customer service, please do not hesitate
to log a
concern, complaint or an improvement suggestion with our customer care
line by
sending an email  with COMPLAINT
or SUGGESTION in the
subject line.
   
  
  

--
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly 
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev
  

___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
  




--
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly 
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] bacula director not running in webmin

2010-10-20 Thread John Drescher

You probably want to ask Jamie Cameron over at the Webmin mailing
list. And also provide details of what system you use this.
Bacula-director does show up in webmin under gentoo for me. With that
said webmin is slated to be removed from portage. I will continue to
support it on my overlay as much as I can..

http://github.com/drescherjm/jmdgentoooverlay

John

--
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly 
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] current message appears when trying to launch bacula from webmin module

2010-10-20 Thread Dantuma Computer Services

Failed to connect to the Bacula database : Failed to load the database DBI
driver Pg at ./bacula-backup-lib.pl line 44. Maybe it is not set up, or the
module 
configuration is incorrect

 

Kind Regards, 
  
Johan Dantuma 
Dantuma Computer Services 
Tel:  033 345 8563 / 083 272 1779 
Fax:  088 033 345 8563 
e-mail:  dc...@telkomsa.net 



 

Dantuma Computer Services

"We are driven by service to provide our clients with cost effective
implementation of complete Managed Outsource IT solutions"

 

Dantuma Computer Services welcome all comments or suggestions to improve our
customer service

Should you experience any dissatisfaction regarding customer service, please
do not hesitate to log a concern, complaint or an improvement suggestion
with our customer care line by sending an email    with
COMPLAINT or SUGGESTION in the subject line.

 

<>--
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly 
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] bacula director not running in webmin

2010-10-20 Thread Dantuma Computer Services

 

 

Kind Regards, 
  
Johan Dantuma 
Dantuma Computer Services 
Tel:  033 345 8563 / 083 272 1779 
Fax:  088 033 345 8563 
e-mail:  dc...@telkomsa.net 



 

Dantuma Computer Services

"We are driven by service to provide our clients with cost effective
implementation of complete Managed Outsource IT solutions"

 

Dantuma Computer Services welcome all comments or suggestions to improve our
customer service

Should you experience any dissatisfaction regarding customer service, please
do not hesitate to log a concern, complaint or an improvement suggestion
with our customer care line by sending an email    with
COMPLAINT or SUGGESTION in the subject line.

 

<>--
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly 
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] How to parse Bacula conf files

2010-10-20 Thread John Doe

From: Craig Miskell 

> Yuri Timofeev  wrote:
> > During development the prototype of the my  new system (Webacula 5.5),
> > I tried to parse the bacula-dir.conf.
> >  However, this is probably not possible with simple regexp's.
> Yes it is very difficult, at least with a RegEx.

Maybe have a look at lex/yacc...

JD


  

--
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly 
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Problem to compile Bacula Admin Tools

2010-10-20 Thread Damian Ge ; bicki

Stéphane Cesbron wrote:
>   Thanks for your reply.
> 
> I know that I don't need BAT on the server that runs bacula. 
> Nevertheless it will be easier as I am really new to bacula.
> Tonight I retried to install qt4 which was already installed.
> I think that I found what causes the trouble.
> It has to come with the settings of environment variables.
> In fact, I've got two different installations of qt on my box
> - qt-3.3 installed in /usr/lib64/qt-3.3
> - qt4 installed in /usr/lib64/qt4
> 

I wonder why you don't use depkgs from bacula.org? 
(depkgs-qt-28Jul09.tar.gz).
Its working fine.


-- 
=
Damian

--
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly 
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Unable to restore jobs created on one client, on another

Re: [Bacula-users] Unable to restore jobs created on one client, on another

Re: [Bacula-users] Unable to restore jobs created on one client, on another

[Bacula-users] Unable to restore jobs created on one client, on another

[Bacula-users] premature recycling

Re: [Bacula-users] get_file_record want 1 got rows=2 after migration from MySQL to PostgreSQL

Re: [Bacula-users] get_file_record want 1 got rows=2 after migration from MySQL to PostgreSQL

Re: [Bacula-users] How to parse Bacula conf files

Re: [Bacula-users] current message appears when trying to launch bacula from webmin module

Re: [Bacula-users] bacula director not running in webmin

Re: [Bacula-users] bacula director not running in webmin

[Bacula-users] current message appears when trying to launch bacula from webmin module

[Bacula-users] bacula director not running in webmin

Re: [Bacula-users] How to parse Bacula conf files

Re: [Bacula-users] Problem to compile Bacula Admin Tools

15 matches

Site Navigation

Mail list logo

Footer information