Re: [Bacula-users] Job Type Copy

2013-01-08 Thread Uwe Schuerkamp
On Tue, Jan 08, 2013 at 11:30:28AM +0100, Olivier L. wrote: Hi all, When i use a job of type Copyto put my file backup on a tape. Some jobs are marked as type = Backup and other are marked as Type = Job Copy. Do you know why types differ ? For my use i prefer type = Backup, how can i

[Bacula-users] bacula 5.2.12 randomly fails to recycle disk based volumes

2013-01-11 Thread Uwe Schuerkamp
Hello all, even with bacula version 5.2.12 we're still seeing the errors below where bacula sometimes fails to properly recycle a disk based volume. There are lots of error messages like these: ## 10-Jan 21:16 serverl186-dir

Re: [Bacula-users] bacula 5.2.12 randomly fails to recycle disk based volumes

2013-01-14 Thread Uwe Schuerkamp
On Fri, Jan 11, 2013 at 02:52:05PM +, Martin Simmons wrote: Do you know which volume is used? There seems to be some confusion between incremental-0058 and incremental-0508. Is that a common feature of other failures like this? The problem is that this occurs only every once in a

Re: [Bacula-users] restore performance

2013-01-14 Thread Uwe Schuerkamp
On Mon, Jan 14, 2013 at 11:38:04AM +, Antony Mayi wrote: Hi guys, I seem to have major performance problem with the director/catalog when trying restoration. Using MySQL, the catalog has about 200MB, mysql is using innodb with large enough buffer pool to keep all data in memory. there

Re: [Bacula-users] restore performance

2013-01-14 Thread Uwe Schuerkamp
: Uwe Schuerkamp uwe.schuerk...@nionex.net To: Antony Mayi antonym...@yahoo.com Cc: bacula-users@lists.sourceforge.net bacula-users@lists.sourceforge.net Sent: Monday, 14 January 2013, 12:45 Subject: Re: [Bacula-users] restore performance On Mon, Jan 14, 2013 at 11:38:04AM +, Antony

Re: [Bacula-users] restore performance

2013-01-14 Thread Uwe Schuerkamp
On Mon, Jan 14, 2013 at 08:24:07AM -0500, John Drescher wrote: I just ran into this. After a Google search, I turned up an article that says the indices that used to make Bacula run faster now cause a performance problem with recent versions of Bacula and recent versions of MySQL (it's on

Re: [Bacula-users] restore performance

2013-01-14 Thread Uwe Schuerkamp
On Mon, Jan 14, 2013 at 08:44:06AM -0500, John Drescher wrote: I did not mean file table indices (I am not sure about these - I use postgresql with bacula). However I meant tuning the database parameters to allow mysql server to use more memory. I have had to do that for other mysql usage.

Re: [Bacula-users] Which is better, conio or readline

2013-01-15 Thread Uwe Schuerkamp
On Mon, Jan 14, 2013 at 03:55:45PM +0100, Radosław Korzeniewski wrote: Hello, 2013/1/14 jba...@bayertechnologygroup.com If you have both, which would be better to use? Use readline and disable conio. How about command line completion via TAB, is this feature available in the

Re: [Bacula-users] restore performance

2013-01-15 Thread Uwe Schuerkamp
On Mon, Jan 14, 2013 at 09:01:32AM -0500, Novosielski, Ryan wrote: http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_sql_results_from_mysql_catalog Actually, after re-reading that, I'm a little confused. I don't know whether it says to drop all indexes except

Re: [Bacula-users] windows enterprise is not working, x32/x64.

2013-01-16 Thread Uwe Schuerkamp
On Wed, Jan 16, 2013 at 10:55:18AM +0100, Adrian Reyer wrote: This is why I wrote 'If I misgot this' as I have that very understanding the windows code stays where it is, get patches as they are developed, just noone of 'the community' provides precompiled binaries. Just like noone provides

Re: [Bacula-users] windows enterprise is not working, x32/x64.

2013-01-16 Thread Uwe Schuerkamp
:09, Uwe Schuerkamp wrote: On Wed, Jan 16, 2013 at 10:55:18AM +0100, Adrian Reyer wrote: This is why I wrote 'If I misgot this' as I have that very understanding the windows code stays where it is, get patches as they are developed, just noone of 'the community' provides precompiled

Re: [Bacula-users] save DB's online

2013-01-17 Thread Uwe Schuerkamp
On Thu, Jan 17, 2013 at 10:40:26AM +0100, Sven Gehr wrote: Hi@all, is it possible to backu databases e.g. mysql, pgsql (on other hosts) with bacula online? -- Viele Grüsse Sven Gehr Yes and no. If there are no jobs running you can set the db to read only, but bacula will barf the

Re: [Bacula-users] save DB's online

2013-01-17 Thread Uwe Schuerkamp
On Thu, Jan 17, 2013 at 08:20:48AM -0500, Phil Stracchino wrote: One last footnote: *SOLELY* setting MySQL read-only does NOT guarantee a consistent backup. You must FLUSH TABLES, and even then you're still not 100% safe on InnoDB. Agreed, I forgot that important step in my previous email.

Re: [Bacula-users] save DB's online

2013-01-17 Thread Uwe Schuerkamp
On Thu, Jan 17, 2013 at 08:52:32AM -0500, Phil Stracchino wrote: On 01/17/13 08:33, Uwe Schuerkamp wrote: Could we expect to see better db performance by moving to innodb or one of MariaDB's fancy new backends? I'm especially interested in improving volume recycle times which can be quite

Re: [Bacula-users] Fwd: Is my tape jukebox borked?

2013-01-23 Thread Uwe Schuerkamp
On Tue, Jan 22, 2013 at 03:06:33PM -0500, John Drescher wrote: -- Forwarded message -- From: Alan McKay alan.mckay+bac...@gmail.com Date: Tue, Jan 22, 2013 at 2:51 PM Subject: Re: [Bacula-users] Is my tape jukebox borked? To: John Drescher dresche...@gmail.com On Tue, Jan

Re: [Bacula-users] Increme job_backup.2013 has a fatal error

2013-01-23 Thread Uwe Schuerkamp
On Tue, Jan 22, 2013 at 04:29:39PM -0800, UserMOP wrote: When typing status sto at the Used Volume status: it freezes. does not go any further. ah, another bacula user with the same problem. I guess it *is* a bug in bacula-sd, and I've found no way around the above situation except for

Re: [Bacula-users] where to start?

2013-01-23 Thread Uwe Schuerkamp
On Wed, Jan 23, 2013 at 11:04:34AM -0500, Alan McKay wrote: This is all a little overwhelming. Is there a better tutorial somewhere to get me off the ground? Hi Alan, check the mail archive, I think Ken pointed out a recently published ebook about bacula. While I haven't read it myself

[Bacula-users] Bacula Django Admin?

2013-01-24 Thread Uwe Schuerkamp
Hi folks, before I duplicate anyone's previous efforts I'd like to find out if anyone has already created a Django definition for Bacula's DB tables? I think it'd be quite cool to have a web-based reporting monitoring interface, and Django seems like the perfect solution for implementing such a

Re: [Bacula-users] Bacula Django Admin?

2013-01-24 Thread Uwe Schuerkamp
On Thu, Jan 24, 2013 at 01:29:03PM +0100, Domen Kožar wrote: There is Almir, written also in Python but with Pyramid framework (really similar to Django, but much more flexible, not that it matters). See demo: http://almir-demo.domenkozar.com/ Documentation:

Re: [Bacula-users] Technical problems with the manual (was: where to start)

2013-01-24 Thread Uwe Schuerkamp
Hi Alan, the bacula manual is a complete mess IMHO. A seasoned bacula admin with decent technical writing skills could easily rase a few thousand bob, dollars or what have you by initiating a kickstarter campaign to rewrite and reorganize the documentation that is out there. Cheers, Uwe --

Re: [Bacula-users] Bacula-Web 5.2.12 released

2013-01-25 Thread Uwe Schuerkamp
Hi Davide, thanks for your continuing work support for bacula-web. Are backup job groups implemented in this version? I'd like to be able to create a group of clients and / or jobs for space accounting purposes. I'm aware this can be done with an admin job and a custom sql query, however it

Re: [Bacula-users] decrease File-Retention

2013-01-28 Thread Uwe Schuerkamp
On Mon, Jan 28, 2013 at 03:58:35PM +0100, Jürgen Ecker wrote: Hi, i have a file-retention of 14 days and want it to decrease to 7 days. If I understand it right, then it would only change the database entrys and purge the other 7 days if i decrease the file-retention. How can I completly

[Bacula-users] Delete multiple volumes at once?

2013-01-31 Thread Uwe Schuerkamp
Hello list, is it possible to delete several bacula volumes in one go, say like so: delete catalog=MyCatalog volume=v01 volume=vol2 ... yes ? I have several volumes with sizes in the hundreds of gigabytes and I assume that deleting them or rather their corresponding file table entries in

Re: [Bacula-users] Delete multiple volumes at once?

2013-02-01 Thread Uwe Schuerkamp
On Thu, Jan 31, 2013 at 06:00:58PM -0500, Dan Langille wrote: On Jan 31, 2013, at 7:58 AM, Uwe Schuerkamp wrote: Hello list, is it possible to delete several bacula volumes in one go, say like so: delete catalog=MyCatalog volume=v01 volume=vol2 ... yes ? Script it. echo

Re: [Bacula-users] Parallel copy jobs revisited

2013-02-05 Thread Uwe Schuerkamp
On Mon, Feb 04, 2013 at 05:41:51PM +0100, Stephane Navarro wrote: -Original message Uwe Schuerkamp Mon, 04 Jun 2012 06:50:47 -0700 Hi folks, while we're at it, I was wondering what's happening when bacula copies an on-disk (software-compressed) job to tape

[Bacula-users] Running one director with mixed db backends / catalogs?

2013-02-05 Thread Uwe Schuerkamp
Hi folks, we'd like to test a new postgres backend (one catalog for a couple of clients) to compare it to the existing mysql catalog. Is it possible to define mixed catalog backends in a single director instance? All the best thanks in advance, Uwe -- NIONEX --- Ein Unternehmen der

Re: [Bacula-users] Running one director with mixed db backends / catalogs?

2013-02-06 Thread Uwe Schuerkamp
On Tue, Feb 05, 2013 at 11:32:51AM -0500, Dan Langille wrote: On 2013-02-05 10:20, Uwe Schuerkamp wrote: Hi folks, we'd like to test a new postgres backend (one catalog for a couple of clients) to compare it to the existing mysql catalog. Is it possible to define mixed catalog backends

[Bacula-users] update slots scan question

2013-02-08 Thread Uwe Schuerkamp
Hi folks, I'm about to use the update slots scan bconsole command for the first time as I'm fed up with doing all the manual work changing a set of tapes involves. In a perfect (bacula) world, this command would achieve the following: - load all tapes in the changer one after the other -

Re: [Bacula-users] cataloging backup files

2013-02-08 Thread Uwe Schuerkamp
On Thu, Feb 07, 2013 at 08:42:22PM +, Jonathan Horne wrote: i would like to completely kill and reinstall bacula from the ground up. id like to keep the backup files i have on disk, and just import them into the next bacula install, and be able to run restores from them as time

Re: [Bacula-users] SQL-Query for copy job to get latest full + all following differentials incrementals...

2013-02-13 Thread Uwe Schuerkamp
On Wed, Feb 13, 2013 at 08:26:38AM +0100, Masopust, Christian wrote: Hi, I'd like to set up a copy job here for offsite backup (on demand) and therefore would need a fine SQL-query to get all jobs listed for the most recend full and all following differentials and incrementals. All

Re: [Bacula-users] SQL-Query for copy job to get latest full + all following differentials incrementals...

2013-02-13 Thread Uwe Schuerkamp
On Wed, Feb 13, 2013 at 08:08:34PM +0100, Masopust, Christian wrote: :List all Jobs needed for a disaster recovery for a jobname: *Enter Job name: SELECT DISTINCT Job.JobId,StartTime FROM Job WHERE Job.Name = '%1' AND ( (Level='F' AND JobStatus IN ('T', 'W') AND Job.StartTime = (

Re: [Bacula-users] Restore Error

2013-02-13 Thread Uwe Schuerkamp
On Wed, Feb 13, 2013 at 12:28:49PM -0500, John Drescher wrote: On Wed, Feb 13, 2013 at 12:17 PM, Craig Van Tassle cvantas...@purdue.edu wrote: I recently upgraded my tape library to LTO-6 Tapes. I need to read from my older LTO-4 tapes. When I run a restore I get director-sd

Re: [Bacula-users] SQL-Query for copy job to get latest full + all following differentials incrementals...

2013-02-14 Thread Uwe Schuerkamp
On Thu, Feb 14, 2013 at 11:04:23AM +0100, Masopust, Christian wrote: So... some questions left: - can the size of Selection Pattern be increased (probably without increasing it for all other parameter values) ? - why are stored procedures not possible in this case? Thanks, Christian

Re: [Bacula-users] Corrupted catalog on bad drive - please help!

2013-02-20 Thread Uwe Schuerkamp
On Wed, Feb 20, 2013 at 12:17:30AM -0500, Michael Stauffer _g wrote: How do I setup the DB using InnoDB? I'm not seeing that in the docs. (I'm sticking with bacula 3.0 for now, until I can get the catalog back and do another full backup). Hello Michael, I can only answer this question:

Re: [Bacula-users] Corrupted catalog on bad drive - please help!

2013-02-20 Thread Uwe Schuerkamp
On Wed, Feb 20, 2013 at 07:58:53AM -0500, Michael Stauffer _g wrote: snip snip So if I'm making a new empty database using the setup script in bacula, then I'll do this step - right? Yep, you can also alter the create_mysql_tables.sql script directly I believe. All the best, Uwe --

Re: [Bacula-users] rescan after corrupted catalog - another question?

2013-02-20 Thread Uwe Schuerkamp
On Wed, Feb 20, 2013 at 08:01:48AM -0500, Michael Stauffer _g wrote: Hi again, Regarding my situation of a corrupted catalog that I'm trying to recover from. The only table that was reported problematic was Files, with the Files.MYD unreadable. Can I do a bscan with all the other

Re: [Bacula-users] Corrupted catalog on bad drive - please help!

2013-02-21 Thread Uwe Schuerkamp
On Wed, Feb 20, 2013 at 09:50:14AM -0500, Phil Stracchino wrote: Also make sure you have the innodb_tables_as_files option set, otherwise you db will be one huge unmanageable blob that can't be reduced in size after a while by dumping / importing again. Whoa there, Nellie. Make sure

[Bacula-users] Latest Files link on bacula.org

2013-02-21 Thread Uwe Schuerkamp
Hi folks, the current files link on the bacula website still points to release 5.2.6 which might confuse some people ;) All the best, Uwe -- NIONEX --- Ein Unternehmen der Bertelsmann SE Co. KGaA -- Everyone

Re: [Bacula-users] Upgrade Bacula

2013-02-25 Thread Uwe Schuerkamp
On Fri, Feb 22, 2013 at 12:03:38PM -0500, Michael Namaiandeh wrote: Hi all- I am looking for a tutorial on how to upgrade my Bacula install from 5.0.2 to 5.2.13 on a CentOS 5.9 box. I am also looking on how to upgrade Bacula and preserve my config (Catalogs, Pool definitions, etc). Any

[Bacula-users] Migrating from myisam to innodb

2013-02-26 Thread Uwe Schuerkamp
Hi folks, for the record I'd like to give you some stats from our recent myisam - innodb conversion. The server in question runs mariadb 5.5.27 on centos 6 64bit (latest patches), has 18GB of RAM with a RAID5 built over 8 internal SAS disks (7 + one spare) which stores the mysql tables. Our

[Bacula-users] Reducing the maximum number of volumes in a pool

2013-02-27 Thread Uwe Schuerkamp
Hi folks, I'm trying to save a bit of disk space by reducing the number of volumes in the incremental pool (we use separate pools for for full and incremental backups for each client, bacula 5.2.13 compiled from source). Previously we had 15 incremental volumes per pool, now I'd like to retain 7

Re: [Bacula-users] Reducing the maximum number of volumes in a pool

2013-02-27 Thread Uwe Schuerkamp
On Wed, Feb 27, 2013 at 08:11:44AM -0500, Dan Langille wrote: for the incremental pools, but following an update pool from resource the db record still shows the previous number of volumes in the pool for Max, not the one defined in the director config. Any idea why this would happen or

Re: [Bacula-users] default bacula user rights

2013-02-28 Thread Uwe Schuerkamp
On Tue, Feb 26, 2013 at 08:57:42AM -0700, compdoc wrote: I was trying to set up a stunnel and changed the bacula user to allow logins, but I'd like to change that back to default and remove that right. Is the following command enough, or is there more I need to do? sudo usermod -s

Re: [Bacula-users] Migrating from myisam to innodb

2013-03-01 Thread Uwe Schuerkamp
On Tue, Feb 26, 2013 at 04:24:02PM +, Alan Brown wrote: On 26/02/13 09:42, Uwe Schuerkamp wrote: I wonder if dumping the file table and then re-importing it to an innodb replacement would have been quicker? In general: Yes. Hi folks, it looks like moving over to InnoDB has cut

Re: [Bacula-users] Migrating from myisam to innodb

2013-03-01 Thread Uwe Schuerkamp
On Tue, Feb 26, 2013 at 04:23:20PM +, Alan Brown wrote: On 26/02/13 09:42, Uwe Schuerkamp wrote: for the record I'd like to give you some stats from our recent myisam - innodb conversion. For the sizes you're talking about, I'd recommend: 1: A _lot_ more memory. 100Gb or so

Re: [Bacula-users] spurious Intervention needed messages

2013-03-04 Thread Uwe Schuerkamp
On Mon, Mar 04, 2013 at 09:55:25AM +0100, Tilman Schmidt wrote: Another one, this time with version 5.2.13. Recycling was actually necessary this time: I can assure that there was no one in the building Friday night between 20:06 and 20:11 to change a tape or enter a command to Bacula.

Re: [Bacula-users] backing up the backups: filesystem copy or 2nd rotation?

2013-03-04 Thread Uwe Schuerkamp
On Sun, Mar 03, 2013 at 10:50:49PM -0800, ixlo...@sent.at wrote: hello i've set up Bacula to back up multiple machines on my LAN. i've created a strategy/rotation of full, differential incremental backups. with all backups going only to hard drive volumes on a single NAS device, so

Re: [Bacula-users] Where is win32-5.2.12.exe?

2013-03-04 Thread Uwe Schuerkamp
On Sun, Mar 03, 2013 at 12:52:21PM +0100, Erik P. Olsen wrote: I've installed bacula 5.2.12 on Fedora 18 and should now proceed installing the windows client on a windows 7 system but win32-5.2.12.exe is nowhere to find. Is it safe to install win32-5.2.10.exe instead because that can be

Re: [Bacula-users] bconsole autocomplete and history feature

2013-03-05 Thread Uwe Schuerkamp
On Mon, Mar 04, 2013 at 11:23:17PM +0200, Andrei Moraru wrote: Hi, I have installed Bacula v5.2.13 on Debian 6.0.6 x86_64 In a putty session to the VM hosting the Bacula director, I connect to the console of Bacula by using bconsole utility. Unfortunately, I don't have autocomplete

Re: [Bacula-users] Migrating from myisam to innodb

2013-03-05 Thread Uwe Schuerkamp
On Tue, Mar 05, 2013 at 11:26:45AM +, Alan Brown wrote: On 01/03/13 11:16, Uwe Schuerkamp wrote: There's no real need for that. If you tell mysqldump to use compatible dump formats then postgres will import it. (mysqldump --compatible=(name)) Hi Alan, thanks for the heads-up. I'd

Re: [Bacula-users] update slots scan question

2013-03-05 Thread Uwe Schuerkamp
On Fri, Feb 08, 2013 at 09:40:28AM -0500, Dan Langille wrote: On 2013-02-08 05:17, Uwe Schuerkamp wrote: I take it that your tape library does not read barcodes? Or that you are not using barcodes. Which is it? Hi Dan, thanks much for your answer. Our library is unable to read barcodes

Re: [Bacula-users] Problem with concurrent mixed priority jobs

2013-03-05 Thread Uwe Schuerkamp
On Tue, Mar 05, 2013 at 03:19:29PM +0100, stefano scotti wrote: Hi, My director allows 5 concurrent jobs, and each job has *Allow Mixed Priority * set to yes. My aim is that even if a slow job takes a lot of time to finish, there will be other 4 job slots to use so that the backup system

Re: [Bacula-users] bacula does not recognizes any slots of an ADIC-1200G

2013-03-06 Thread Uwe Schuerkamp
On Tue, Mar 05, 2013 at 09:52:45PM +0100, Tilman Gloetzner wrote: Hello Distribution: Ubuntu 12.04 Issue: Bacula does not properly recognize the 12 tape slots of the ADIC-1200 G. Details: 1) *update slots scan 3306 Issuing autochanger slots command. Device AutoChanger1 has 0 slots.

Re: [Bacula-users] bconsole autocomplete and history feature

2013-03-06 Thread Uwe Schuerkamp
On Tue, Mar 05, 2013 at 08:21:31PM +0200, Andrei Moraru wrote: Hi, Yes, i've compiled it from sources. I assume you compiled 5.2.13 from source? If so, make sure your configure output displays either readline and / or conio enabled, this will provide you with the history feature.

Re: [Bacula-users] Problem with concurrent mixed priority jobs

2013-03-06 Thread Uwe Schuerkamp
On Tue, Mar 05, 2013 at 04:07:36PM +0100, stefano scotti wrote: I'm using mixed priorities because i want to handle the case in which all job slots are occupied. For example, if there are only a free slot i'd like to assign it to a more important job (like mailboxes) instead of a not

Re: [Bacula-users] Problem with concurrent mixed priority jobs

2013-03-06 Thread Uwe Schuerkamp
On Wed, Mar 06, 2013 at 01:27:17PM +0100, stefano scotti wrote: Thanks Uwe, I think i will use one of your workarounds, because they are workarounds. The best solution was to allow mixing lower priorities even though an higher job is running. Something like Allow Lower Mixed Priority

Re: [Bacula-users] Reducing the maximum number of volumes in a pool

2013-03-12 Thread Uwe Schuerkamp
On Wed, Feb 27, 2013 at 08:11:44AM -0500, Dan Langille wrote: snip snip In bconsole, did you issue the reload command before issuing the update command? Hi folks, some more observations on reducing the numbers of volumes in a pool: I changed the max volumes from 14 to 8 for a disk based

Re: [Bacula-users] How to remove disk volumes.

2013-03-15 Thread Uwe Schuerkamp
On Thu, Mar 14, 2013 at 08:57:43PM +, Stephen Pierce wrote: I've been using Bacula for only a few weeks, so I haven't gotten to the point where my first backup job is older than my retension time (30 days). However, when I used to do backups on real tape (~1998), I would recycle a piece

[Bacula-users] MySQLdump import seems very slow for Filename and Path tables

2013-03-16 Thread Uwe Schuerkamp
Hi folks, I've been warned re-importing an innodb mysql database was slow, but I hadn't expected it to be *this* slow. I'm dumping a catalog instance that is about 55GB in size (dump), but the file table has 294GB in the database, so obviously there's a lot of unused / deleted data in there.

Re: [Bacula-users] MySQLdump import seems very slow for Filename and Path tables

2013-03-19 Thread Uwe Schuerkamp
On Sat, Mar 16, 2013 at 11:39:40AM -0400, Phil Stracchino wrote: On 03/16/13 05:54, Uwe Schuerkamp wrote: Hi folks, I've been warned re-importing an innodb mysql database was slow, but I hadn't expected it to be *this* slow. The basic problem here is that mysqldump has not aged

Re: [Bacula-users] what would cause a server to not auto-label a new file?

2013-03-20 Thread Uwe Schuerkamp
On Tue, Mar 19, 2013 at 02:35:48PM +, Jonathan Horne wrote: This problem continues. I have 1 bacula server that pauses during full backup jobs: Running Jobs: Console connected at 19-Mar-13 07:47 JobId Level Name Status

Re: [Bacula-users] Pools not updating Attributes

2013-03-21 Thread Uwe Schuerkamp
On Wed, Mar 20, 2013 at 05:18:37PM -0400, Mingus Dew wrote: Dear All, I am running bacula-5.2.10 on Solaris 10 x86. I've noticed an issue recently where I've wanted to restrict further restrict the Maximum Volumes in a couple of Pools. I edited the config and changed Maximum Volumes = 3.

Re: [Bacula-users] Migrating from myisam to innodb

2013-03-21 Thread Uwe Schuerkamp
On Tue, Feb 26, 2013 at 04:24:02PM +, Alan Brown wrote: On 26/02/13 09:42, Uwe Schuerkamp wrote: I wonder if dumping the file table and then re-importing it to an innodb replacement would have been quicker? In general: Yes. Hi folks, last night I managed to shrink a 300GB File

Re: [Bacula-users] Migrating from myisam to innodb

2013-03-21 Thread Uwe Schuerkamp
On Thu, Mar 21, 2013 at 07:40:01AM -0400, Phil Stracchino wrote: Try this for a faster method: CREATE TABLE NewFile LIKE File; INSERT INTO NewFile (SELECT * FROM File); DROP TABLE File; RENAME TABLE NewFile TO File; Thanks Phil, I was a bit anxious about the select into bit because the

Re: [Bacula-users] MySQLdump import seems very slow for Filename and Path tables

2013-03-21 Thread Uwe Schuerkamp
On Tue, Mar 19, 2013 at 10:37:13AM -0500, Melvin Ross wrote: You may also want to try Xtrabackup from Percona. -Melvin Brilliant, thanks for the heads-up, Melvin! FWIW, in order to get xtrabackup to work with MariaDB 5.5, I had to add a [mysqld] section to my.cnf, pointing to the correct

Re: [Bacula-users] Bacula restore getting wrong Storage

2013-03-22 Thread Uwe Schuerkamp
On Fri, Mar 22, 2013 at 01:37:42PM +0200, Bugbear wrote: Hi Dimitrij, Well, for me using only one catalog isn't solution at all. With the number of clients and files I'm backing up, using one database (catalog) causes huge performance penalties, that's why I use multiple catalogs. We

Re: [Bacula-users] Change email to recived events for Bacula

2013-04-04 Thread Uwe Schuerkamp
On Thu, Apr 04, 2013 at 09:33:02AM +0200, Alberto Amo Garrido wrote: Hello. I need to change the email what recived the events for Bacula. I don't know where I have to configurate this. Can you help me? Thanks Hi Alberto, usually the mail address for notifications is configured in

Re: [Bacula-users] LTO 6 compression

2013-05-07 Thread Uwe Schuerkamp
On Tue, May 07, 2013 at 10:11:27AM -0400, Alan McKay wrote: On Tue, May 7, 2013 at 9:45 AM, John Drescher dresche...@gmail.com wrote: The 6.25TB is only an estimate. If you have non compressible data you will get close to 2.5 TB of space on your tape. If you have all text files you may

[Bacula-users] Bacula unable to restore most recent backup

2013-05-08 Thread Uwe Schuerkamp
Hi folks, I'm wondering if the following issue is a bug or feature: We're using separate incremental- and full pools for each client backed up by bacula (5.2.13). Each pool represents a directory in the file system containing the volumes (1 job / volume), so we have a structure like this:

Re: [Bacula-users] Device clean lto4

2013-05-10 Thread Uwe Schuerkamp
On Thu, May 09, 2013 at 05:42:59PM +0200, Alberto Amo Garrido wrote: Hello. How and how ofren, you have to load de device clean lto4??? -- You should see a message in the lc display of your tape library when the drive

Re: [Bacula-users] User unmounted?

2013-05-10 Thread Uwe Schuerkamp
On Thu, May 09, 2013 at 10:37:45AM -0300, Sergio Belkin wrote: Hi, I have some problems with bacula 5.x that I haven't when I used 2.x versions. Yesterday I unmount and eject a tape and change by hand by *another one differente tape* and backups didn't run, it outputs: Device LTO5

[Bacula-users] [uwe.schuerk...@nionex.net: Re: Multiplexing jobs]

2013-05-15 Thread Uwe Schuerkamp
Sorry, forgot to cc: the list. On Tue, May 14, 2013 at 10:33:00AM -0400, Michael Namaiandeh wrote: Hi Bacula Community, I am running Bacula 5.0.2 on a CentOS 5.9 box. I have a number of backups that run every night but I noticed that Bacula seems to run one backup job at a time. This

Re: [Bacula-users] Benefits of Hardware compression versus Software compression for highly compressable data

2013-05-15 Thread Uwe Schuerkamp
On Tue, May 14, 2013 at 09:56:03AM +0200, Raimund Sacherer wrote: [snip snip] How do you handle big database backups? Is it worth storing uncompressed? Is the hardware compression *actually* better? Do I waste space on tape? Would saving this space on tape be worth all the space problems I

Re: [Bacula-users] Benefits of Hardware compression versus Software compression for highly compressable data

2013-05-16 Thread Uwe Schuerkamp
On Wed, May 15, 2013 at 06:41:08PM +0200, Kern Sibbald wrote: Hello, I don't think the last version of the Windows FD produced by the project has LZO in the Windows version. For nearly every platform, we must build LZO from source, so it took longer to get it into the Windows version.

Re: [Bacula-users] disk full, director not available, director not working

2013-05-16 Thread Uwe Schuerkamp
On Mon, May 13, 2013 at 10:12:56AM +0200, Stefan Fuhrmann wrote: Hello all, the disk is full and the director is not reachable. Just to test I did also a reboot. I want to delete older backups now, but how when director isnt working? Can someone help? tia# Stefan Hi Stefan,

Re: [Bacula-users] very old Bacula-Version

2013-05-24 Thread Uwe Schuerkamp
On Fri, May 24, 2013 at 10:21:02AM +0200, Claudia Koch wrote: Hallo all, I need a very old version of Bacula. I have to integrate a Suse8-box to my bacula-environment. The oldest Version from the Bacula-Web-Site is 5.0.2. Hi Claudia, I could provide a source tarball from version 2.4.4.

[Bacula-users] Weird bacula-dir error Message / Crash

2013-05-27 Thread Uwe Schuerkamp
Hi folks, we found the following message in our director log: 25-Mai 19:35 bacula-dir JobId 70293: End auto prune. 25-May 21:24 bacula-dir: ERROR TERMINATION at bsys.c:484 bacula-dir is already running. pid=4469 Check file /var/run/bacula-dir.9101.pid This looks like some kind of auto-restart

Re: [Bacula-users] Multiple Catalog Configuration

2013-06-04 Thread Uwe Schuerkamp
On Mon, Jun 03, 2013 at 03:45:48PM -0400, Mingus Dew wrote: Does anyone have an example they can share of using mutliple catalogs? I have a particular set of NAS backups that has over 500,000,000 file records and pretty much need to use a separate catalog to hopefully overcome 3 days of table

Re: [Bacula-users] Automatically create volume and continue writing to it

2013-06-04 Thread Uwe Schuerkamp
On Tue, Jun 04, 2013 at 02:56:34AM -0400, Michael D. Wood wrote: Hi Guys, I've been combing through the mailing list and forums and trying to wrap my head around what I'm trying to accomplish. Hopefully, someone here can point me in the right direction. This is just a home setup

Re: [Bacula-users] problems restoring directory

2013-06-04 Thread Uwe Schuerkamp
On Tue, Jun 04, 2013 at 10:10:51AM -0400, Tim Dunphy wrote: Hello list, I have a working bacula system backing up a few cloud instances. But when I tried to perform a restore, I went into the bacula console and gave the 'restore all' command and walked through the steps to select the

Re: [Bacula-users] Automatically create volume and continue writing to it

2013-06-05 Thread Uwe Schuerkamp
On Tue, Jun 04, 2013 at 09:45:44PM -0400, Michael D. Wood wrote: It's literally only writing about 3-4GB's of data on a full backup and anywhere from 100-400MB's on an incremental. So, it's a small backup and it's just for home use. Mostly backing up config files and emails in case

Re: [Bacula-users] Question on Copy Jobs - Selection Type PoolUncopiedJobs

2013-06-05 Thread Uwe Schuerkamp
On Tue, Jun 04, 2013 at 01:28:07PM -0400, Mingus Dew wrote: Dear All, I have an existing Bacula installation that uses separate disk pools for Incremental and Full backups. I have setup a Copy Job to tape pool setup using the PoolUncopiedJobs Selection Type for the Full disk pool only.

Re: [Bacula-users] Timeout for Storage volumes

2013-06-05 Thread Uwe Schuerkamp
On Wed, Jun 05, 2013 at 07:58:34AM -0300, Isamar Maia wrote: Hi Folks ! Is there any way to timeout a volume with problem and skip to the next available volume in the pool ? For example: A tape that is not available anymore in the magazine but the volume status is not correct.

Re: [Bacula-users] Timeout for Storage volumes

2013-06-05 Thread Uwe Schuerkamp
On Wed, Jun 05, 2013 at 09:57:55AM -0300, Isamar Maia wrote: Yeah. It can be a way to go.. but we have the same problem with File volumes as well What kind of incorrect volume status are you referring to then? I've never used vchanger so I cannot help you there. All the best, Uwe --

Re: [Bacula-users] Timeout for Storage volumes

2013-06-05 Thread Uwe Schuerkamp
On Wed, Jun 05, 2013 at 10:19:41AM -0300, Isamar Maia wrote: IN the File context, when, for some reason, the file doesn't exist anymore... Isamar That's weird indeed, normally bacula wouldn't mind if a file volume (the physical file) doesn't exist anymore. What's the exact error message?

Re: [Bacula-users] multiple 2 directors, storage accessing same clients, 2 backups on 2 different locations

2013-06-06 Thread Uwe Schuerkamp
On Thu, Jun 06, 2013 at 01:11:48PM +0200, Stefan Fuhrmann wrote: Hello all, we want to do a special setup: we have one director and storege in datacenter. The second director and storage should be loacated in firm. Both should backup same clients. The ambition is to do only diff-backup on

Re: [Bacula-users] Copy jobs creates Incremental too?

2013-06-18 Thread Uwe Schuerkamp
On Sun, Jun 16, 2013 at 08:23:11PM +0100, Gary Cowell wrote: I'm using a DTDTT scenario, with the copy jobs being sent to USB disk via vchanger. This works fine, but I have a questio When my COPY job runs in the schedule, I get a COPY job, and also an Incremental job. I think that's

Re: [Bacula-users] command to check if bacula is running?

2013-06-28 Thread Uwe Schuerkamp
On Thu, Jun 27, 2013 at 08:45:48AM -0700, Joseph Spenner wrote: Is there a simple command line way to determine if bacula is not currently running any jobs? I want to write a script to perform some other backups of the bacula database, but want to make sure it's not currently running. I

Re: [Bacula-users] Intervention needed, asking for tape not in library

2013-07-02 Thread Uwe Schuerkamp
On Tue, Jul 02, 2013 at 10:07:16AM -0400, Kevin B. Zimmerman wrote: Once I swap the old magazine out (following the instructions at http://www.bacula.org/en/dev-manual/main/main/Autochanger_Resource.html#SECTION00295), Bacula refuses to automatically use any tapes in the

Re: [Bacula-users] Intervention needed, asking for tape not in library

2013-07-04 Thread Uwe Schuerkamp
Thanks for the update Kevin, I'll try those instructions during our next offline backup. Cheers, Uwe -- NIONEX --- Ein Unternehmen der Bertelsmann SE Co. KGaA -- This SF.net email is sponsored by Windows: Build

Re: [Bacula-users] MariaDB or Oracle's MySQL.

2013-07-09 Thread Uwe Schuerkamp
On Mon, Jul 08, 2013 at 09:49:55PM +0200, Erik P. Olsen wrote: On 08/07/13 19:48, Phil Stracchino wrote: On 07/08/13 12:15, Erik P. Olsen wrote: I have been using Oracle's mysql several years and one of the worst problem with it has been restore times, especially the time it takes to

Re: [Bacula-users] Authentication with public IP and bacula-sd binding problems

2013-07-09 Thread Uwe Schuerkamp
On Tue, Jul 09, 2013 at 10:08:43AM +0300, Darius Tumas wrote: Hello, I've two problems: a) bacula storage daemon wont bind to all IP's when SDAddress is not provided. It always bind to public servers hostname (everything ok with server configuration cause bacula file daemon binds to all

Re: [Bacula-users] Trying to understand file-based pools and datestamped volume labels - volume prune and recycling

2013-07-11 Thread Uwe Schuerkamp
On Wed, Jul 10, 2013 at 10:00:20PM -0400, Phil Stracchino wrote: On 07/10/13 18:38, Chris Harrison wrote: Also, is there a nicer way to have one file with a clear filename per job but also to have fully automated volume recycling so I don't just fill up our NAS? The big problem with

Re: [Bacula-users] Need help understanding and applying some Retention/Recycle concepts

2013-07-12 Thread Uwe Schuerkamp
On Thu, Jul 11, 2013 at 10:01:24AM -0400, Mingus Dew wrote: Dear All, I am running Bacula Community Edition 5.2.13 on Solaris 10 x86. I am trying to understand why Bacula doesn't seem to recycle when I think it should. I have recently moved to a configuration where each Volume

Re: [Bacula-users] Server 2012 running as client won't do full backup

2013-07-19 Thread Uwe Schuerkamp
On Thu, Jul 18, 2013 at 01:05:01PM -0500, Christina Murphy wrote: Hey y'all, So I'm pretty much at a loss as far as what could be going wrong with my configurations for my last client I need to set up. The client's OS is Windows Server 2012, 64 bit. I thought I had everything configured

Re: [Bacula-users] Why does bacula insist on autolabeling with TestA-n?

2013-07-25 Thread Uwe Schuerkamp
On Wed, Jul 24, 2013 at 11:22:21AM -0500, Barak Griffis wrote: For some reason, bacula insists on autolabeling with a format of 'TestA-n' where n is the incrementing number. Any ideas why doesn't is like my Label Format? Did you issue an update pool from resource in bconsole after

Re: [Bacula-users] What's wrong with my schedule?

2013-07-30 Thread Uwe Schuerkamp
On Mon, Jul 29, 2013 at 11:54:16PM -0400, Gary Dale wrote: I'm running Version: 5.2.6 (21 February 2012) x86_64-pc-linux-gnu debian 7.0 This schedule seems to almost be working. Unfortunately, I'm getting a full backup every Sunday before the differential backup on the 2nd-5th Sundays. The

Re: [Bacula-users] What might prevent auto-recycling?

2013-08-01 Thread Uwe Schuerkamp
On Wed, Jul 31, 2013 at 03:34:50PM -0400, Michael Stauffer wrote: PoolId: 6 Name: Differential NumVols: 6 MaxVols: 0 Wouldn't you want to set the maxvols parameter in your pool definition too together with recycle oldest volume to force bacula to recycle the oldest volume?

Re: [Bacula-users] Building directory tree for JobId(s) very slow

2013-09-03 Thread Uwe Schuerkamp
On Wed, Aug 14, 2013 at 08:13:39PM +0200, azurIt wrote: Where's my mistake? Could you suggest me some optimization. Hi, only one little suggestion from me - upgrade to MySQL 5.5. azur Or go straight to MariaDB. Another important question is how big is your file table, i.e. how many

Re: [Bacula-users] ml6000 tape library stopped to work

2013-09-03 Thread Uwe Schuerkamp
On Tue, Aug 13, 2013 at 10:21:47AM -0300, Alberto Viana wrote: Hi All, I have a ML6000 that stopped to work after a firmware upgrade to lastest version available (ML6000 Firmware 636G.GS003) But can't get library info: root:~# mtx -f /dev/sg5 status mtx: Request Sense: Long Report=yes

<    1   2   3   4   5   >