[Bacula-users] command line editing
Dear bacula users, another question: I wonder if I can configure or compile bconsole in a way that I can use history and/or command line editing in a linux/mac terminal? Now, even typing a backspace confuses my terminal ... -- Kind regards Christoph Christoph Litauer lita...@uni-koblenz.de Uni Koblenz, Computing Center, http://www.uni-koblenz.de/~litauer Postfach 201602, 56016 Koblenz Fon: +49 261 287-1311, Fax: -100 1311 PGP-Fingerprint: F39C E314 2650 650D 8092 9514 3A56 FBD8 79E3 27B2 -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Very slow interactive restore
Jesper Krogh schrieb: Christoph Litauer wrote: 3.) What are your directory building times when using interactive restores? For 8.5 million files ~ 2 minutes. That would be _very_ nice! Jesper, please give the following information, so I can compare our setups: 1.) Output of 'show index from File' http://krogh.cc/~jesper/show-index.txt 2.) Your /etc/my.cnf http://krogh.cc/~jesper/my.cnf 3.) How much memory your system has. 48GB where typically 40GB are uses as spool-area for 2 x LTO4 devices mounted as a ramfs Sorry Jesper, a few more questions: 1.) Where is the 'dump_info_idx' index from? I don't think it is created by make_mysql_tables ... 2.) Is your machine/os 32bit or 64bit based? 3.) Do you use InnoDB- or MyISAM-Tables? -- Kind regards Christoph Christoph Litauer lita...@uni-koblenz.de Uni Koblenz, Computing Center, http://www.uni-koblenz.de/~litauer Postfach 201602, 56016 Koblenz Fon: +49 261 287-1311, Fax: -100 1311 PGP-Fingerprint: F39C E314 2650 650D 8092 9514 3A56 FBD8 79E3 27B2 -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Verify Job: Warning: The following files are in the Catalog but not on the Volume(s):
On Tue, 10 Nov 2009 10:54:26 +0100, Ralf Gross said: Martin Simmons schrieb: On Tue, 3 Nov 2009 09:51:17 +0100, Ralf Gross said: bacula 3.0.2, psql, debian etch Every now and then I receive error mails about missing files from verify jobs where I can't find the problem. Does it report all files as missing in that case or is it some subset? Not all. What does the end of the email look like, i.e. the job report from Build OS: to Termination:? This verify job complained only about missing files in /usr. Ah, this is a good clue. What is the fileset definition? Maybe it includes the /usr directory twice? __Martin -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] command line editing
On Wed, 11 Nov 2009 09:28:13 +0100, Christoph Litauer said: Dear bacula users, another question: I wonder if I can configure or compile bconsole in a way that I can use history and/or command line editing in a linux/mac terminal? Now, even typing a backspace confuses my terminal ... Try building with the --disable-conio argument to configure. Then Bacula will use readline if you have it installed (on Linux you'll need readline-devel as well). __Martin -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] eSATA / USB disks as media for Bacula
Hello all, Been looking for a half hour or so now, and it /seems/ that - with moderate work - Bacula can use disk as media..? Is that true? I'd be more interested in using eSATA than USB. Can anyone confirm that this can be done? Thanks, Andrew Vliet --- Snakes. Why did it have to be snakes? -- Indiana Jones, Raiders of the Lost Ark -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] eSATA / USB disks as media for Bacula
On Wed, Nov 11, 2009 at 8:20 AM, John Drescher dresche...@gmail.com wrote: On Wed, Nov 11, 2009 at 4:53 AM, Andrew Vliet arvl...@gmail.com wrote: Hello all, Been looking for a half hour or so now, and it /seems/ that - with moderate work - Bacula can use disk as media..? Is that true? I'd be more interested in using eSATA than USB. Can anyone confirm that this can be done? Yes, you can use disks and esata, sata, usb, scsi, 1394, FC... I use regular sata and a 5 in 1 drive bay. http://www.newegg.com/Product/Product.aspx?Item=N82E16817332011cm_re=5_in_3-_-17-332-011-_-Product Slight correction. This is a 5 in 3 bay. Meaning 5 x 3.5 drives in 3 x 5.25 bays. Also this is what I use at home. At work my 20TB+ are on LTO2 tape using a 24 bay 2 drive autochanger. I have over 70 LTO2 tapes in use. John -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacula and MySQL in different servers
How could I create the Bacula tables and database on another server? And how could I link the Bacula with the remite DB server? Thank you people -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] eSATA / USB disks as media for Bacula
On Wed, Nov 11, 2009 at 4:53 AM, Andrew Vliet arvl...@gmail.com wrote: Hello all, Been looking for a half hour or so now, and it /seems/ that - with moderate work - Bacula can use disk as media..? Is that true? I'd be more interested in using eSATA than USB. Can anyone confirm that this can be done? Yes, you can use disks and esata, sata, usb, scsi, 1394, FC... I use regular sata and a 5 in 1 drive bay. http://www.newegg.com/Product/Product.aspx?Item=N82E16817332011cm_re=5_in_3-_-17-332-011-_-Product I am now using the vchanger to make swapping easier, volume handling better and the concurrency setup easier. Since recycling only works when you have 3 or more volumes per pool. http://sourceforge.net/projects/vchanger/ John -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula and MySQL in different servers
On Wed, Nov 11, 2009 at 8:13 AM, Paschoal Mingoto p...@mingoto.com wrote: How could I create the Bacula tables and database on another server? And how could I link the Bacula with the remite DB server? The create catalog script takes a parameter for the host. At lest it did the last time I checked. You specify the server the catalog config in bacula-dir.conf Here is what I have for postgres # Generic catalog service Catalog { Name = HBCatalog dbname = bacula user = bacula password = bacula dbaddress = dev6 dbport = 5432 } The director machine is fileserver so the remote machine dev6 now holds the catalog however I probably will move this soon since dev6 is a 5 years old dual processor opteron box with only 4 GB of memory. John -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Verify Job: Warning: The following files are in the Catalog but not on the Volume(s):
Martin Simmons schrieb: On Tue, 10 Nov 2009 10:54:26 +0100, Ralf Gross said: Martin Simmons schrieb: On Tue, 3 Nov 2009 09:51:17 +0100, Ralf Gross said: bacula 3.0.2, psql, debian etch Every now and then I receive error mails about missing files from verify jobs where I can't find the problem. Does it report all files as missing in that case or is it some subset? Not all. What does the end of the email look like, i.e. the job report from Build OS: to Termination:? This verify job complained only about missing files in /usr. Ah, this is a good clue. What is the fileset definition? Maybe it includes the /usr directory twice? The fileset looks ok to me. FileSet { Name = Client Ignore FileSet Changes = yes Include { Options { aclsupport = yes signature = MD5 } File = / File = /var File = /boot } Exclude { File = /media/* File = /lost+found/* File = /mnt/* File = /dev/* File = /sys/* File = /proc/* File = /tmp/* File = /.journal File = /.fsck } } Ralf -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bconsole shortcut command parameters: specifically add command
On Wed, Nov 11, 2009 at 10:36 AM, Bob Hetzel b...@case.edu wrote: Greetings, Is there anywhere that the shortcut parameters you can use with bconsole are documented so as to avoid the submenus? For the moment, the task that's frustrating me is that I'd like to add in a bunch of new volumes and I can't seem to figure out the right parameters to the add command so as to specify the label on the command line. Has anybody figured this out how to skip past this prompt ? Enter number of Volumes to create. 0=fixed name. Max=1000: How about help in bconsole? John -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bconsole shortcut command parameters: specifically add command
On Wed, Nov 11, 2009 at 11:00 AM, John Drescher dresche...@gmail.com wrote: On Wed, Nov 11, 2009 at 10:36 AM, Bob Hetzel b...@case.edu wrote: Greetings, Is there anywhere that the shortcut parameters you can use with bconsole are documented so as to avoid the submenus? For the moment, the task that's frustrating me is that I'd like to add in a bunch of new volumes and I can't seem to figure out the right parameters to the add command so as to specify the label on the command line. Has anybody figured this out how to skip past this prompt ? Enter number of Volumes to create. 0=fixed name. Max=1000: How about help in bconsole? I take that back. It does not seem to have every command documented. John -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bconsole shortcut command parameters: specifically add command
On Wed, Nov 11, 2009 at 10:36:57AM -0500, Bob Hetzel wrote: Greetings, Is there anywhere that the shortcut parameters you can use with bconsole are documented so as to avoid the submenus? For the moment, the task that's frustrating me is that I'd like to add in a bunch of new volumes and I can't seem to figure out the right parameters to the add command so as to specify the label on the command line. Has anybody figured this out how to skip past this prompt ? Enter number of Volumes to create. 0=fixed name. Max=1000: In my experience, I've most often had to end up examining the code in src/dird/ua_cmds.c in order to figure this kind of thing out. ...and looking at the code now, it seems to me that what you want isn't possible without changing the code - or doing something like the following: bconsole EOF add pool=poolname 1 volumebasename 1 EOF -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] eSATA / USB disks as media for Bacula
On 11/11/2009 4:53 AM, Andrew Vliet wrote: Hello all, Been looking for a half hour or so now, and it /seems/ that - with moderate work - Bacula can use disk as media..? Is that true? I'd be more interested in using eSATA than USB. Can anyone confirm that this can be done? Thanks, Andrew Vliet I've been doing all backups that way for a bit over six months now. It's much more convenient than tape. Just use Media Type = File in your director Storage definition block, which changes volumes from individual tapes to individual files. Then use something like this in your storage daemon configuration: Device { Name = MiniTowerStorage Device Type = File Media Type = File Archive Device = /backups LabelMedia = yes Random Access = yes # Requires Mount = yes # Mount Point = /backups # Mount Command = /etc/bacula/mountback # Unmount Command = /etc/bacula/unmountback AutomaticMount = yes RemovableMedia = no AlwaysOpen = no } That's from a 2.4.4 config. The 3.x options may be slightly different, but I haven't migrated yet. The commented statements are what should make Bacula automatically mount and unmount the storage, but it doesn't actually work. It will happily mount the array, but when the job is done, it does not run the unmount command. I worked around that by adding before/after scripts to each job that do the mounting/unmounting. You could just leave the storage mounted, of course, but I prefer being able to physically remove the drive tower at any time when a job isn't running, without having to manually log to unmount and stop the array first. Things get more complicated if you want to cycle multiple different drives. You'll want to search the mailing list archive for info about that - as I recall from what I've read, it's not all that easy to do properly. My last bit of advice is to size the volumes appropriately, since the files are treated exactly like tapes for the purposes of expiration and reuse. Size the volumes too big, and you might run into a situation that's exactly like running out of tapes before the oldest one can be recycled, but can't be remedied as easily as adding more to the pool. -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Sizes of database dump?
On Mon, 9 Nov 2009, Alan Brown wrote: Nor can I. 20 billion rows dumped when there should only be only 400 million in there and 3 billion ever written in. Arrgh... Arrgh indeed. To summarise: The file table was corrupt (innodb) and mysqldump was jumping back about 50 million entries every time it reached the highest FileId. To fix it, I set mysqldump to produce INSERT IGNORE statements and just watched the output then aborted when it started looping, cleaned up the last line and manually added a mysqldump closing stanza. Mysql repeatedly segfaulted when trying to drop the table, so in the end I simply deleted the whole (all mysql files), reinstalled the server, reran the make_msyql_* files and then imported all the tables again. It's all going now, but I'm not happy with what happened an am considering options (including replication to a slave) Does anyone have stats on Postgres performance vs MySQL Innodb? Dan? AB -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Need input on an Issue
On Tue, 10 Nov 2009, Jesper Krogh wrote: Wonder if there is a feature request sitting in bacula for accurate backups? Looking at the projects file it doesn't look like it. Yes - and it was implemented in V3, which is why it's not in the project tree. (Disclosure: We helped pay for it.) -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bconsole shortcut command parameters: specifically add command
On Wed, 11 Nov 2009, Graham Keeling wrote: ...and looking at the code now, it seems to me that what you want isn't possible without changing the code - or doing something like the following: bconsole EOF add pool=poolname 1 volumebasename 1 EOF or echo add\\\n$NumVols\\\n$VolBaseName\\\n$StartNumber | bconsole If you need to do it in a bash script. (works for me, YMMV. HTH. HAND) AB -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Very slow interactive restore
Christoph Litauer wrote: Jesper Krogh schrieb: Christoph Litauer wrote: 3.) What are your directory building times when using interactive restores? For 8.5 million files ~ 2 minutes. That would be _very_ nice! Jesper, please give the following information, so I can compare our setups: 1.) Output of 'show index from File' http://krogh.cc/~jesper/show-index.txt 2.) Your /etc/my.cnf http://krogh.cc/~jesper/my.cnf 3.) How much memory your system has. 48GB where typically 40GB are uses as spool-area for 2 x LTO4 devices mounted as a ramfs Sorry Jesper, a few more questions: 1.) Where is the 'dump_info_idx' index from? I don't think it is created by make_mysql_tables ... I may have created it manually.. years ago.. The setup is actually since may 2006, file-table around 1.8 billion (10^9) files. 2.) Is your machine/os 32bit or 64bit based? 64bit 3.) Do you use InnoDB- or MyISAM-Tables? Hmm. due to some wierd reason.. it is a mixture, but the large ones are all InnoDB. -- Jesper -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] eSATA / USB disks as media for Bacula
Andrew Vliet arvl...@gmail.com kirjoitti viestissä news:1257933183.9152.14.ca...@cadmium.vlietwerkz.ca... Hello all, Been looking for a half hour or so now, and it /seems/ that - with moderate work - Bacula can use disk as media..? Is that true? I'd be more interested in using eSATA than USB. Can anyone confirm that this can be done? Whichever disk interface (sata, usb etc.) that your hardware and operating system supports will work. Actually, you won't use directly the disks from Bacula, but files on these disks behave as Bacula's volumes, similar to tapes. MediaType=File in the configuration is the key here. -- TiN -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] command line editing
Am 11.11.2009 um 13:46 schrieb Martin Simmons: On Wed, 11 Nov 2009 09:28:13 +0100, Christoph Litauer said: Dear bacula users, another question: I wonder if I can configure or compile bconsole in a way that I can use history and/or command line editing in a linux/mac terminal? Now, even typing a backspace confuses my terminal ... Try building with the --disable-conio argument to configure. Then Bacula will use readline if you have it installed (on Linux you'll need readline- devel as well). Worked like a charm! Thanks a lot! -- Kind regards Christoph -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users