[Bacula-users] Bacula 7.0.4 director: Symbol not found _mysql_init on OSX 10.9 with MySQL 5.5.38

2014-06-26 Thread Robert Oschwald
Currently working on the macports variants of Bacula 7.0.4.
FD, Bat and PostgreSQL8.4 server versions work flawlessly.

Building the MySQL variant with MySQL 5.5.38 compile ok, but when running the 
director, I get:

# bacula-dir -v -f
dyld: lazy symbol binding failed: Symbol not found: _mysql_init
  Referenced from: /opt/local/lib/libbaccats-7.0.4.dylib
  Expected in: flat namespace

dyld: Symbol not found: _mysql_init
  Referenced from: /opt/local/lib/libbaccats-7.0.4.dylib
  Expected in: flat namespace

Bacula interrupted by signal 5: Trace/Breakpoint trap
Kaboom! bacula-dir, bacula-dir got signal 5 - Trace/Breakpoint trap at 
26-Jun-2014 00:36:44. Attempting traceback.
Kaboom! exepath=/opt/local/sbin
Calling: /opt/local/sbin/btraceback /opt/local/sbin/bacula-dir 58689 
/opt/local/var/bacula/working

All libs and bacula-dir are 64bit.

Any hints?


Rob

--
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula 7.0.4 director: Symbol not found _mysql_init on OSX 10.9 with MySQL 5.5.38

2014-06-26 Thread Robert Oschwald
Hi Kern,

it’s on the same machine as the binaries were compiled.

Found the reason for the problem. 
Problem seem to be the configure script.
MYSQL_INCLUDE and MYSQL_LIBS in src/cats/Makefile is set empty.
This causes the libbaccats-7.0.4.so library to be linked without the mysql 
library.
When adding the correct values:

MYSQL_INCLUDE = -I/opt/local/include/mysql55/mysql
MYSQL_LIBS = -R /opt/local/lib/mysql55/mysql -L/opt/local/lib/mysql55/mysql 
-lmysqlclient_r -lz

the libbaccats library gets linked correctly and bacula-dir works.
Will investigate why the configure script ignores MYSQL_LIBS, later.


Here is the otool output (OSX equivalent to ldd) of the defect director build:

# otool -L bacula-dir 

/System/Library/Frameworks/CoreFoundation.framework/Versions/A/CoreFoundation 
(compatibility version 150.0.0, current version 855.16.0)
/opt/local/lib/libbacfind-7.0.4.dylib (compatibility version 0.0.0, 
current version 0.0.0)
/opt/local/lib/libbacsql-7.0.4.dylib (compatibility version 0.0.0, 
current version 0.0.0)
/opt/local/lib/libbaccats-7.0.4.dylib (compatibility version 0.0.0, 
current version 0.0.0)
/opt/local/lib/libbaccfg-7.0.4.dylib (compatibility version 0.0.0, 
current version 0.0.0)
/opt/local/lib/libbac-7.0.4.dylib (compatibility version 0.0.0, current 
version 0.0.0)
/opt/local/lib/libz.1.dylib (compatibility version 1.0.0, current 
version 1.2.8)
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current 
version 1197.1.1)
/opt/local/lib/libwrap.7.dylib (compatibility version 7.0.0, current 
version 7.6.0)
/opt/local/lib/libintl.8.dylib (compatibility version 10.0.0, current 
version 10.2.0)
/opt/local/lib/libssl.1.0.0.dylib (compatibility version 1.0.0, current 
version 1.0.0)
/opt/local/lib/libcrypto.1.0.0.dylib (compatibility version 1.0.0, 
current version 1.0.0)
/usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version 
120.0.0)


and:

# ldd /opt/local/lib/libbaccats-7.0.4.dylib
/opt/local/lib/libbaccats-mysql-7.0.4.dylib (compatibility version 
0.0.0, current version 0.0.0)
/usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version 
120.0.0)
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current 
version 1197.1.1)

(here the mysql library is missing).


Corrected Makefile built library holds:
# ldd /opt/local/lib/libbaccats-7.0.4.dylib 
/opt/local/lib/libbaccats-7.0.4.dylib:
/opt/local/lib/libbaccats-mysql-7.0.4.dylib (compatibility version 
0.0.0, current version 0.0.0)
/opt/local/lib/mysql55/mysql/libmysqlclient.18.dylib (compatibility 
version 18.0.0, current version 18.0.0)
/usr/lib/libz.1.dylib (compatibility version 1.0.0, current version 
1.2.5)
/usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version 
120.0.0)
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current 
version 1197.1.1)




Rob

Am 26.06.2014 um 11:45 schrieb Kern Sibbald :

> Hello,
> 
> I suspect that you had the MySQL development libraries loaded when you built 
> Bacula, but on the machine where you are trying to run Bacula, you do not 
> have the MySQL interface libraries loaded.  I am not sure what they are 
> called on Mac, but they provide the shared object client libraries that allow 
> Bacula to connect to the MySQL DB, which may be on the same system or 
> somewhere on the network.  These libraries are supplied by whoever supplies 
> MySQL.
> 
> On Linux systems, you can enter:
> 
>   ldd bacula-dir
> 
> and you will get a list of all the shared libraries that it needs, and one of 
> them is probably missing.
> On my system, (a slightly different Bacula version), it looks like:
> 
> ...
> libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x7fa122ad9000)
> libmysqlclient.so.18 => /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18 
> (0x7fa122591000)
> ...
> 
> On your system, I suspect that the equivalent of libmysqlclient.so.18 is 
> missing.
> 
> Best regards,
> Kern
> 
> On 06/26/2014 10:01 AM, Robert Oschwald wrote:
>> Currently working on the macports variants of Bacula 7.0.4.
>> FD, Bat and PostgreSQL8.4 server versions work flawlessly.
>> 
>> Building the MySQL variant with MySQL 5.5.38 compile ok, but when running 
>> the director, I get:
>> 
>> # bacula-dir -v -f
>> dyld: lazy symbol binding failed: Symbol not found: _mysql_init
>>   Referenced from: /opt/local/lib/libbaccats-7.0.4.dylib
>>   Expected in: flat namespace
>> 
>> dyld: Symbol not found: _mysql_init
>>   Referenced from: /opt/local/lib/libbaccats-7.0.4.dylib
>>   Expected in: flat namespace
>> 
>> Bacula interrupted by signal 5: Trace/Breakpoint trap
>> Kaboom! bacula-dir, bacula-dir go

Re: [Bacula-users] Bacula for OSX 10.9

2014-09-08 Thread Robert Oschwald
You can use MacPorts to build Bacula 7.0.4 (client by default, also supports 
MySQL-, PostgreSQL- and SQLite3 Server variants)

Install macports (macports.org), then perform 
„sudo port install bacula“

This by default installs the client fd.

Configure the client in /opt/local/etc/bacula/bacula-fd.conf
When configured, perform
„sudo port load bacula-fd“

To build a DMG file for standalone installation on other machines (which do not 
have MacPorts installed), you can perform

sudo port mdmg bacula
cd `port work bacula`

.. there you find bacula-7.0.4.dmg which includes all dependencies.

It’s recommended to use a separate MacPorts installation path for standalone 
dmg files. 
See 
https://guide.macports.org/chunked/using.binaries.html#using.binaries.binary-packages

Robert



Am 07.09.2014 um 07:33 schrieb Eric Dannewitz :

> I'm interested in perhaps deploying this in my k-8 school, but I have not 
> found a good tutorial of how to install it. Or if it even works right on Mac.
> 
> Anyone have some insights on this? My idea would be to back about 30 macs to 
> an Ubuntu server.
> 
> Thanks!
> 
> Sent from my iSomething
> --
> 
> 
> --
> Slashdot TV.  
> Video for Nerds.  Stuff that matters.
> http://tv.slashdot.org/
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users


--
Want excitement?
Manually upgrade your production database.
When you want reliability, choose Perforce
Perforce version control. Predictably reliable.
http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] sg device node stickyness

2014-10-22 Thread Robert Oschwald
Using Bacula Server 7.0.4 on CentOS6_64.

One thing which annoys me is that the sg device node for TapeAlert changes with 
every reboot from /dev/sg4 to /dev/sg6 and vice versa.
Is there any setting I can set in udev to get sticky device nodes for my tape 
device changer device node?

System has a LSI 3Ware  9650SE controller installed which is the one fighting 
for sg device node with my HP Ultrium 4 SCA tape device.

Thanks,
Robert
 




smime.p7s
Description: S/MIME cryptographic signature
--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Configuration reload for bacula-sd

2014-10-24 Thread Robert Oschwald
+1

Sent while mobile.

> Am 24.10.2014 um 10:11 schrieb Uwe Schuerkamp :
> 
>> On Fri, Oct 24, 2014 at 09:48:25AM +0200, Andrea Carpani wrote:
>> Hi all,
>> 
>> I'm still new to the product and I was playing around with Bacula 5.2.6 
>> (latest packages that come with CentOS 6.5). I added a new storage 
>> device to the Storage Daemon. I tried to run a job that used this 
>> device, but the backup failed apparently because bacula-sd wan't aware 
>> of this new device.
>> 
>> I tried to use
>> 
>> service bacula-sd reload
>> 
>> but this didn't work, so I had to restart bacula-sd, but this broke my 
>> running backups. So my question is: is there a way to reload bacula-sd 
>> configuration on the fly?
>> 
>> regards,
>> 
>> Andrea
>> .a.c.
> 
> This would indeed be a great feature to have. We use separate devices
> for each client (on-disk volumes for full and incr. jobs), and
> currently we have to wait for all jobs to complete before reloading
> the sd in order to configure the new devices. A reload triggered by
> sending the sd a signal would be very cool.
> 
> Uwe
> 
> 
> -- 
> NIONEX --- Ein Unternehmen der Bertelsmann SE & Co. KGaA
> 
> 
> 
> --
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users

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


[Bacula-users] bacula-users replyTo address

2015-04-08 Thread Robert Oschwald
The reply-to address for posts on the mailing list is not set at least in my 
received emails from the list.
Therefore it happened before that I sent a reply to the author instead of the 
list.

Is it possible for the admins to set the reply-to address to the list-address 
so replies are posted to the list instead of the author?

Thanks,
Robert





--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] PostgreSQL db indexes on 7.0.5 question

2015-04-08 Thread Robert Oschwald
I’m a bit irritated about indexes for PostgreSQL installations of 7.0.5.

In 7.0.5, those are the indexes created by make_postgresql_tables:

CREATE UNIQUE INDEX filename_name_idx on Filename (Name);
CREATE UNIQUE INDEX path_name_idx on Path (Path);
CREATE INDEX file_jpfid_idx on File (JobId, PathId, FilenameId);
CREATE INDEX file_jobid_idx on File (JobId);
CREATE INDEX restore_jobid_idx on RestoreObject(JobId);
CREATE INDEX job_name_idx on job (name);
CREATE INDEX jobhisto_idx ON JobHisto ( StartTime );
CREATE INDEX fileset_name_idx on fileset (fileset);
CREATE INDEX job_media_job_id_media_id_idx on jobmedia (jobid, mediaid);
CREATE INDEX media_poolid_idx ON Media (PoolId);
CREATE INDEX pool_name_idx on pool (name);
create unique index client_name_idx on client (name);
create index log_name_idx on Log (JobId);
CREATE INDEX basefiles_jobid_idx ON BaseFiles ( JobId );


In the upgrade scripts for PostgreSQL, we have found this additional indexes 
are enabled by default:
update_postgresql_tables_7_to_8:create index file_pathid_idx on file(pathid);
update_postgresql_tables_7_to_8:create index file_filenameid_idx on 
file(filenameid);

But the make_postgresql_tables script states:
  -- Possibly add one or more of the following indexes
  --  if your Verifies are too slow, but they can slow down
  --  backups.

Shouldn’t those indexes be optional in the upgrade scripts as well to have 
consistent db installations?

Additionally, I haven’t  found anything about this alternate concurrent 
file_jpf_idx index. 
Is it better to use this one on PGSQL >= 8.2? Is it documented somewhere? 
It’s also not stated in the make_postgresql_tables script:

-- Create the good one
-- If you want to create this index during production, you can use
-- update_postgresql_tables_11_to_12:-- CREATE INDEX CONCURRENTLY file_jpf_idx 
ON File (JobId, PathId, FilenameId)


Thanks,
Robert



--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] bacula-users replyTo address

2015-04-08 Thread Robert Oschwald
So OSX Mail doesn’t seem to be decent enough, then.




> Am 08.04.2015 um 15:20 schrieb Albert Dengg :
> 
> hi,
> On Wed, Apr 08, 2015 at 01:24:34PM +0200, Robert Oschwald wrote:
>> The reply-to address for posts on the mailing list is not set at least in my 
>> received emails from the list.
>> Therefore it happened before that I sent a reply to the author instead of 
>> the list.
>> 
>> Is it possible for the admins to set the reply-to address to the 
>> list-address so replies are posted to the list instead of the author?
> decent email clients have a "reply to list" functionality
> 
> reply to mangling can be really annoying.
> 
> regards,
> albert
> --
> BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
> Develop your own process in accordance with the BPMN 2 standard
> Learn Process modeling best practices with Bonita BPM through live exercises
> http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
> source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users



smime.p7s
Description: S/MIME cryptographic signature
--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] HP 1/8 G2 LTO6 Ultrium 6250 SAS autoloader

2015-04-29 Thread Robert Oschwald
The compatibilty list seems to be outdated.

We switched yesterday to a Tandberg Data 3535-LTO LTO6 SCA device (standalone) 
which works flawlessly so far.

I’m sure Bacula Systems got a compatiblity list for Enterprise customers. 
Could you please update the list at 

http://wiki.bacula.org/doku.php?id=hardware_results
and
http://blog.bacula.org/general/supported-tape-drives/


Thanks!


> Am 29.04.2015 um 16:56 schrieb Michael Ivanov :
> 
> Hallo,
> 
> Does anybody use HP 1/8 G2 LTO6 Ultrium 6250 SAS autoloader device with 
> bacula?
> We've been offered to buy this model but regrettab ly I couldn't find any
> bacula compatibility statement about it.
> 
> Best regards,
> -- 
> \   / |  |
> (OvO) |  Michael  |
> (^^^) |   |
>  \^/  |  E-mail:  iv...@isle.spb.ru   |
>  ^ ^  |   |
> 
> --
> One dashboard for servers and applications across Physical-Virtual-Cloud 
> Widest out-of-the-box monitoring support with 50+ applications
> Performance metrics, stats and reports that give you Actionable Insights
> Deep dive visibility with transaction tracing using APM Insight.
> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users


--
One dashboard for servers and applications across Physical-Virtual-Cloud 
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Upgrading Fed 22->23 Unknown column 'VolABytes' in 'field

2015-11-25 Thread Robert Oschwald

CREATE TABLE RestoreObject (
   RestoreObjectId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
   ObjectName BLOB NOT NULL,
   RestoreObject LONGBLOB NOT NULL,
   PluginName TINYBLOB NOT NULL,
   ObjectLength INTEGER DEFAULT 0,
   ObjectFullLength INTEGER DEFAULT 0,
   ObjectIndex INTEGER DEFAULT 0,
   ObjectType INTEGER DEFAULT 0,
   FileIndex INTEGER UNSIGNED DEFAULT 0,
   JobId INTEGER UNSIGNED NOT NULL REFERENCES Job,
   ObjectCompression INTEGER DEFAULT 0,
   PRIMARY KEY(RestoreObjectId),
   INDEX (JobId)
);


> Am 25.11.2015 um 09:02 schrieb bdam :
> 
> I have managed to get everything up and running with the help from the 
> Maraidb group and backups are now running ok! Thanks to everyone for the 
> help. There is one last table I need to create manually - the RestoreObject 
> one. Can someone please list the CREATE TABLE statement I need to make it, 
> and any associated  things like indexes etc? It is for bacula db version 15. 
> Thanks.
> 
> +--
> |This was sent by bill.dam...@yahoo.com via Backup Central.
> |Forward SPAM to ab...@backupcentral.com.
> +--
> 
> 
> 
> --
> Go from Idea to Many App Stores Faster with Intel(R) XDK
> Give your users amazing mobile app experiences with Intel(R) XDK.
> Use one codebase in this all-in-one HTML5 development environment.
> Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
> http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users


--
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula backup speed

2015-12-17 Thread Robert Oschwald
We got approx 80 mio entries in the file table and I confirm Alan.

Before, we had MySQL 5.5 with 24GB buffer ram, but attribute insertions took 
ages.
Then we migrated the DB to PostgreSQL and the issue resolved.

1 year ago, we migrated the physical backup Server to a vCenter VM and lowered 
the memory of the VM dramatically to 4GB (not kidding).
No issues since then. Speed is still really good. We do B2D2T.



> Am 17.12.2015 um 12:34 schrieb Uwe Schuerkamp :
> 
> On Tue, Dec 15, 2015 at 05:16:42PM +, Alan Brown wrote:
>> 
>> MySQL works ok for small sites but doesn't scale well. PostgreSQL is a 
>> heavy load on small installations but will keep running long after MySQL 
>> has decided to use all your system ram and swap too. The breakeven point 
>> is about 10-15 million entries. Beyond that point MySQL needs endless 
>> tuning and PostgreSQL doesn't.
> 
> 
> Hm, I cannot confirm your observation here. Our largest catalog has
> 600,000,000 file table entries on a 64GB server that also runs the
> director with about half of that allocated to the innodb buffers, and
> while it's not exactly a speed daemon when restoring stuff it's also
> no slouch, backing up over 300 clients and about 10TB of data on
> average every day. I doubt postgres would perform much better with a
> similar sized catalog on the same hardware.
> 
> We're using MariaDB 5.5x if that has anything to do with it.
> 
> All the best,
> 
> Uwe
> 
> 
> 
> 
> 
> 
> 
> 
> 
> --
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users


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


[Bacula-users] 5.0.1: Copy job setup as documented leads to fatal error on startup

2010-03-15 Thread Robert Oschwald
Hi Folks,

I sucessfully migrated from BackupExec (Win) to Bacula 5.0.1 (CentOS/OSX 10.6 
clients using CentOS5.1 Director) with a Backup2Disk2Tape configuration.
Everything works perfectly so far (Thanks for this great software!), but I got 
one issue:

On restart of bacula-dir, I receive the following fatal error:
JobId 0: Fatal error: Unable to authenticate with File daemon at 
"localhost:9102". Possible causes:

Reason for this message:
The Jobdefs for the duplication job is configured as described in the 5.0 
documentation:
http://www.bacula.org/5.0.x-manuals/en/main/main/New_Features_in_3_0_0.html#SECTION0072

As I need to setup a dummy client, I receive the error mentioned above.
Why do I need to setup a dummy client for copy jobs? It's just from Pool to 
Pool copy and no client is involved, right?
As the doc url states "New_Features_in_3_0_0", could it be possible that the 
documentation for copy jobs is outdated?
The system itself works without any problems, just the fatal error is raised on 
startup.

Here is the config part I'm talking about:

JobDefs {
  Name = CopyDiskToTape   # Disk To Tape
  Type = Copy
  Messages = Standard
  Client = None
  FileSet = None
  Selection Type = PoolUncopiedJobs
  Maximum Concurrent Jobs = 10
  SpoolData = No
  Allow Duplicate Jobs = Yes
  Allow Higher Duplicates = No
  Cancel Queued Duplicates = No
  Cancel Running Duplicates = No
  Priority = 100
}

# Fake fileset for copy jobs
Fileset {
  Name = None
  Include {
Options {
  signature = MD5
}
  }
}

# Fake client for copy jobs
Client {
  Name = None
  Address = localhost
  Password = "NoNe"
  Catalog = MyCatalog
}

# Duplicate to tape
Job {
  Name = "CopyDiskToTapeFullBackups"
  Enabled = Yes
  Schedule = DaySchedule4:00
  Pool = Default
  JobDefs = CopyDiskToTape
}

# Default B2D pool definition
Pool {
  Name = Default
  Pool Type = Backup
  Storage = File
  Recycle = yes
  AutoPrune = yes
  # enable for duplicate to Tape Pool
  Volume Retention = 14 days
  LabelFormat = b2d-
  Maximum Volume Bytes = 50G
  NextPool = Tape
}

# LTO-4 Tape pool definition
Pool {
  Name = Tape
  Pool Type = Backup
  Recycle = yes
  AutoPrune = yes
  Volume Retention = 2 weeks
  LabelFormat = autolabel-
  Storage = LTO-4
}


Thanks,
Robert

--
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] End of Tape errors with HP LTO-4 drive on Linux

2010-04-13 Thread Robert Oschwald
Bacula works perfectly so far. 
The only serious problem I have is End of Tape detection.
E.g. if I need to reboot the backup server, the current tape will be rewinded.
The next backup job then seems not to find the end of the last backup and the 
tape will be set to Error state:

14-Apr 04:00 bacula-sd JobId 925: Volume "Weekly1" previously written, moving 
to end of data.
14-Apr 04:23 bacula-sd JobId 925: Error: Unable to position to end of data on 
device "LTO-4" (/dev/nst0): ERR=dev.c:954 ioctl MTEOM error on "LTO-4" 
(/dev/nst0). ERR=Input/output error.
14-Apr 04:23 bacula-sd JobId 925: Marking Volume "Weekly1" in Error in Catalog.


I already tried playing with  TWO EOF = yes/no with no luck.

Any ideas?
 

Robert
--
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] End of Tape errors with HP LTO-4 drive on Linux

2010-04-21 Thread Robert Oschwald

Norberto,

if we rewind manually, the same problem occurs.
Bacula was not writing during reboot (reboot was during the day, all backup 
jobs run during the night, duplicates occur approx. at 11PM)
Currently, the Drive only works if we leave the tape as_is during backups (we 
remove the tape weekly).
But if the tape is rewinded somhow (reboot or manually), bacula seems not to 
find the EOF marker.
As said, we already try with TWO EOF = yes, but this doesn't help.

Tape drive is a single HP StorageWorks Ultrium 1760 SAS drive.

This tape drive worked on BackupExec on the same hw without any problem, so I 
think it is a bacula-sd or config problem.
Here is the tape definition we use:

# LTO-4 tape drive
Device {
  Name = LTO-4
  Media Type = LTO-4
  Archive Device = /dev/nst0
  LabelMedia = yes;   # let Bacula label unlabeled media
  RandomAccess = no;
  AutomaticMount = yes;   # when device opened, read it
  RemovableMedia = yes;
  # this avoids shoe shining
  Spool Directory = /B2D/bacula-spool
  # release tape if not used
  AlwaysOpen = no;
  Maximum File Size = 5GB
  # need to specify for Alert Command. Use sg1 as sg0 is Raid Controller
  Changer Device = /dev/sg1
  # AutoChanger = yes
  # Try for tape errors on reboot (eof marker not found). Bacula doc states 
this is for BSD Unix.
  TWO EOF = yes
  Alert Command = "sh -c 'smartctl -H -l error %c'"
}

Robert

Am 21.04.2010 um 10:33 schrieb Norberto Meijome:

> On 14 April 2010 16:32, Robert Oschwald  wrote:
> Bacula works perfectly so far.
> The only serious problem I have is End of Tape detection.
> E.g. if I need to reboot the backup server, the current tape will be rewinded.
> The next backup job then seems not to find the end of the last backup and the 
> tape will be set to Error state:
> 
> 14-Apr 04:00 bacula-sd JobId 925: Volume "Weekly1" previously written, moving 
> to end of data.
> 14-Apr 04:23 bacula-sd JobId 925: Error: Unable to position to end of data on 
> device "LTO-4" (/dev/nst0): ERR=dev.c:954 ioctl MTEOM error on "LTO-4" 
> (/dev/nst0). ERR=Input/output error.
> 14-Apr 04:23 bacula-sd JobId 925: Marking Volume "Weekly1" in Error in 
> Catalog.
> 
> 
> I already tried playing with  TWO EOF = yes/no with no luck.
> 
> Any ideas?
> 
> Robert,
> did you solve this? What tape / library are you using? We are just about to 
> start using a number of LTO4 drives,so this will be something we'd want to 
> test. 
> 
> btw, what happens if you rewind the tape manually? (ie, unmount @ bacula, mt 
> -f /dev/nst0 rewind && mtx -f /dev/xxx unload x, then load in bacula again.
> 
> Is bacula writing while the reboot happens?
> 
> cheers,
> B
> _
> {Beto|Norberto|Numard} Meijome
> 
> "The only people that never change are the stupid and the dead"
>  Jorge Luis Borges.
> 
> I speak for myself, not my employer. Contents may be hot. Slippery when wet.
> Reading disclaimers makes you go blind. Writing them is worse. You have been
> Warned.
> 

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


[Bacula-users] Bacula 5.0.2 needs readline-devel as dependency

2010-06-01 Thread Robert Oschwald
Currently, it is impossible for me to build the rpm packages for CentOS5 
x86_64, because you added readline-devel as a dependency into the spec file.
That package does not exist on CentOS5/RHEL.

I always thought bacula picks the readline lib during configure stage, so why 
is this dependency in the spec file?

Robert
--

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


[Bacula-users] Automatic tape status change doesn't work here

2010-10-06 Thread Robert Oschwald
hi,

I got a problem with automatic tape status change, which does not work. Tapes 
always got status "Append", even when their retention period is exceeded.

I use a Disk/Tape scheme with Bacula 5.0.2.
I change tapes weekly in a Single Drive  HP StorageWorks Ultrium 1760 LTO4.
Copy to tape runs every night after backup to disk.

One problem I haven't solved so far is automatic tape pruning.
On the Tape pool I have set 

 Volume Use Duration = 13 days
 Volume Retention = 14 days
 RecycleOldestVolume=no

But the Tapes are still always on "Append" state. So I must relabel the tape 
manually after change to get them pruned.

List of my current tapes:
N StatusBytes Max Jobs Retention   Type  First  
  Last
M2  Append  311.2 GB0   27  14   LTO-4  
2010-07-29 11:26:24 2010-08-04 04:10:40
M3  Append  505.5 GB0   28  14   LTO-4  
2010-08-26 17:56:15 2010-09-01 04:16:51
M4  Append  494.3 GB0   29  14   LTO-4  
2010-09-30 10:37:44 2010-10-06 06:18:07
M5  Append  264.6 GB0   28  14   LTO-4  
2010-04-30 04:00:02 2010-05-05 04:18:39
M6  Append  352.2 GB0   13  14   LTO-4  
2010-06-01 18:37:16 2010-06-02 09:19:17
W1  Append  502.8 GB0   28  14   LTO-4  
2010-08-20 04:00:02 2010-08-25 04:20:50
W2  Append  506.4 GB0   28  14   LTO-4  
2010-09-02 18:07:38 2010-09-08 04:17:16
W3  Append  507.1 GB0   28  14   LTO-4  
2010-09-10 06:00:03 2010-09-15 06:16:24
W4  Append  511.8 GB0   28  14   LTO-4  
2010-09-16 14:22:26 2010-09-22 06:17:27
W5  Append  534.3 GB0   29  14   LTO-4  
2010-09-23 06:00:02 2010-09-29 06:16:33

How could I change my configuration so that bacula automatically prunes tapes 
older 14 days on next insert?

Here is an excerpt of my config files:

--- POOLS ---
# Default B2D pool definition
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
}
# LTO-4 Tape pool definition
Pool {
 Name = Tape
 Pool Type = Backup
 Recycle = yes  
 AutoPrune = yes  
 Volume Use Duration = 13 days
 Volume Retention = 14 days
 RecycleOldestVolume=no
 #Recycle Current Volume = yes # enable this if autorecycle doesnt work. ro
 LabelFormat = autolabel-
 Storage = LTO-4
}

-- JOBDEFS --
JobDefs {
 Name = client1
 Type = Backup
 Level = Incremental
 Client = client1-fd
 FileSet = client1-files
 Schedule = WeeklyCycle
 Storage = File
 Messages = Standard
 Pool = Default
 Priority = 1
 Write Bootstrap = "/var/lib/bacula/%c.bsr"
}

JobDefs {
 Name = CopyDiskToTape
 Type = Copy
 Messages = Standard
 Client = None
 FileSet = None
 Selection Type = PoolUncopiedJobs
 Maximum Concurrent Jobs = 10
 SpoolData = No
 Allow Duplicate Jobs = Yes
 Allow Higher Duplicates = No
 Cancel Queued Duplicates = No
 Cancel Running Duplicates = No
 Priority = 100
}

-- JOBS --
# client1
Job {
 Name = "client1-job"
 JobDefs = "client1-files"
}
# Duplicate to tape
Job {
 Name = "CopyDiskToTapeFullBackups"
 Enabled = Yes
 Schedule = DaySchedule6:00
 Pool = Default
 JobDefs = CopyDiskToTape
}


-- CLIENTS --
Client {
 Name = client1-fd
 Address = client1
 FDPort = 9102
 Catalog = MyCatalog
 Password = XX
 AutoPrune = yes
}



Thanks for your help!

Robert
--
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1,  ECMAScript5, and DOM L2 & L3.
Spend less time writing and  rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


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

2010-10-18 Thread Robert Oschwald
Hi folks,

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.
Speed is dramatically better than with MySQL (I will post my postgresql 
settings if one is interested).

Now when I  use BAT to simulate a restore to recent, I get this messages in 
stderr when I klick on one of the files:

sql_get.c:156-0 === Problem!  sql_get.c:155 get_file_record want 1 got rows=2 
PathId=80991 FilenameId=439
sql_get.c:156-0 === Problem!  sql_get.c:155 get_file_record want 1 got rows=2 
PathId=80796 FilenameId=439
sql_get.c:156-0 === Problem!  sql_get.c:155 get_file_record want 1 got rows=2 
PathId=307 FilenameId=439
sql_get.c:156-0 === Problem!  sql_get.c:155 get_file_record want 1 got rows=2 
PathId=2 FilenameId=439
sql_get.c:156-0 === Problem!  sql_get.c:155 get_file_record want 1 got rows=2 
PathId=80992 FilenameId=439
sql_get.c:156-0 === Problem!  sql_get.c:155 get_file_record want 1 got rows=2 
PathId=311 FilenameId=439
sql_get.c:156-0 === Problem!  sql_get.c:155 get_file_record want 1 got rows=2 
PathId=9 FilenameId=439


This is what I got in the db (example for the first error message):
select * from file where PathId=80991 and filenameId = 439;

fileid;fileindex;jobid;pathid;filenameid;markid;lstat;md5
195262190;196703;2686;80991;439;0;"P0G C EHt G A A A BAA BAA I BMdWat BLepez 
BLxIbv A A E";"0"
198655792;3590305;2686;80991;439;0;"P0G C EHt G A A A BAA BAA I BMdY3i BLepez 
BLxIbv A A E";"0"
219621970;3509726;2860;80991;439;0;"P0G C EHt G A A A BAA BAA I BMiAMX BLepez 
BLxIbv A A E";"0"
216309113;196869;2860;80991;439;0;"P0G C EHt G A A A BAA BAA I BMh9us BLepez 
BLxIbv A A E";"0"
229856219;3519412;2941;80991;439;0;"P0G C EHt G A A A BAA BAA I BMkT04 BLepez 
BLxIbv A A E";"0"
226533758;196951;2941;80991;439;0;"P0G C EHt G A A A BAA BAA I BMkRX8 BLepez 
BLxIbv A A E";"0"
241079525;3535279;3036;80991;439;0;"P0G C EHt G A A A BAA BAA I BMmzt1 BLepez 
BLxIbv A A E";"0"
237741269;197023;3036;80991;439;0;"P0G C EHt G A A A BAA BAA I BMmotw BLepez 
BLxIbv A A E";"0"
247155517;197101;3121;80991;439;0;"P0G C EHt G A A A BAA BAA I BMo4tF BLepez 
BLxIbv A A E";"0"
250493865;3535449;3121;80991;439;0;"P0G C EHt G A A A BAA BAA I BMo7JE BLepez 
BLxIbv A A E";"0"
255954922;3541015;3203;80991;439;0;"P0G C EHt G A A A BAA BAA I BMrOz/ BLepez 
BLxIbv A A E";"0"
252610691;196784;3203;80991;439;0;"P0G C EHt G A A A BAA BAA I BMrMV4 BLepez 
BLxIbv A A E";"0"
257085143;196784;3210;80991;439;0;"P0G C EHt G A A A BAA BAA I BMrMV4 BLepez 
BLxIbv A A E";"0"
260429374;3541015;3210;80991;439;0;"P0G C EHt G A A A BAA BAA I BMrOz/ BLepez 
BLxIbv A A E";"0"
262984244;197169;3289;80991;439;0;"P0G C EHt G A A A BAA BAA I BMtgAj BLepez 
BLxIbv A A E";"0"
266357999;3570924;3289;80991;439;0;"P0G C EHt G A A A BAA BAA I BMtidh BLepez 
BLxIbv A A E";"0"
270866064;3570924;3296;80991;439;0;"P0G C EHt G A A A BAA BAA I BMtidh BLepez 
BLxIbv A A E";"0"
267492309;197169;3296;80991;439;0;"P0G C EHt G A A A BAA BAA I BMtgAj BLepez 
BLxIbv A A E";"0"


Migration from MySQL to PostgreSQL steps I've done:
mysqldump -t -q -n -c --compatible=postgresql --skip-quote-names --skip-opt 
--disable-keys --lock-tables -u bacula -ppassword bacula \
  | grep -v "INSERT INTO Status" \
  | sed -e 's/-00-00 00:00:00/1970-01-01 00:00:00/g' \
  | sed -e 's/\\0//' > /B2D/bacula_mysql_dump_in_postgresql-format.sql

install postgresql-8.1 (CentOS 5 x86_64)
install bacula-postgresql

create_postgresql_database
make_postgresql_tables
grant_postgresql_privileges

psql -Ubacula bacula < bacula_mysql_dump_in_postgresql-format.sql

Reset sequences:
SELECT SETVAL('basefiles_baseid_seq', (SELECT MAX(baseid) FROM basefiles));
SELECT SETVAL('client_clientid_seq', (SELECT MAX(clientid) FROM client));
SELECT SETVAL('file_fileid_seq', (SELECT MAX(fileid) FROM file));
SELECT SETVAL('filename_filenameid_seq', (SELECT MAX(filenameid) FROM 
filename));
SELECT SETVAL('fileset_filesetid_seq', (SELECT MAX(filesetid) FROM fileset));
SELECT SETVAL('job_jobid_seq', (SELECT MAX(jobid) FROM job));
SELECT SETVAL('jobmedia_jobmediaid_seq', (SELECT MAX(jobmediaid) FROM 
jobmedia));
SELECT SETVAL('media_mediaid_seq', (SELECT MAX(mediaid) FROM media));
SELECT SETVAL('path_pathid_seq', (SELECT MAX(pathid) FROM path));
SELECT SETVAL('basefiles_baseid_seq', (SELECT MAX(baseid) FROM basefiles));
SELECT SETVAL('client_clientid_seq', (SELECT MAX(clientid) FROM client));
SELECT SETVAL('file_fileid_seq', (SELECT MAX(fileid) FROM file));
SELECT SETVAL('filename_filenameid_seq', (SELECT MAX(filenameid) FROM 
filename));
SELECT SETVAL('fileset_filesetid_seq', (SELECT MAX(filesetid) FROM fileset));
SELECT SETVAL('job_jobid_seq', (SELECT MAX(jobid) FROM job));
SELECT SETVAL('jobmedia_jobmediaid_seq', (SELECT MAX(jobmediaid) FROM 
jobmedia));
SELECT SETVAL('media_mediaid_seq', (SELECT MAX(mediaid) FROM media));
SELECT SETVAL('path_pathid_seq', (SELECT MAX(pathid) FROM path));
SELECT SETVAL('pool_poolid_seq', (SELECT MAX(poolid) FROM pool));
SELECT 

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

2010-10-19 Thread Robert Oschwald
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
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 (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(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] 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

Re: [Bacula-users] Compile Bacula on Snow Leopard

2010-11-11 Thread Robert Oschwald
Easiest way is to use MacPorts.

Note: you can build bacula on any OSX 10.6 machine (you only need xcode and 
macports there)

Install 
http://distfiles.macports.org/MacPorts/MacPorts-1.9.2-10.6-SnowLeopard.dmg

Perform the following steps in terminal:
sudo bash
port selfupdate
port mdmg bacula

(wait...)

This builds a Diskimage which contains an installer for bacula-fd (including 
all dependent libraries it needs).
It is in 
/opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_ports_sysutils_bacula/work

Simply copy the dmg to your OSX bacula client machine and install.


Hope it helps!


Robert


Am 11.11.2010 um 14:42 schrieb Michael Riehemann:

> Hi all,
> i´m try to compile bacula on Snow Leopard.
> It did not work on any way i try.
> 
> Is there anywhere a working howto to run
> bacula-fd on snow Leopard?
> 
> thanks for any idea.
> 
> best regards 
> 
> Micha
> --
> Centralized Desktop Delivery: Dell and VMware Reference Architecture
> Simplifying enterprise desktop deployment and management using
> Dell EqualLogic storage and VMware View: A highly scalable, end-to-end
> client virtualization framework. Read more!
> http://p.sf.net/sfu/dell-eql-dev2dev
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users


--
Centralized Desktop Delivery: Dell and VMware Reference Architecture
Simplifying enterprise desktop deployment and management using
Dell EqualLogic storage and VMware View: A highly scalable, end-to-end
client virtualization framework. Read more!
http://p.sf.net/sfu/dell-eql-dev2dev
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users