Re: [Bacula-users] bacula 1.38.11 or bacula 2.0.3 error
Ok then. Here is the lines that are not working: # List of files to be backed up FileSet { Name = Full Set Include { Options { signature = MD5 } # # Put your list of files here, preceded by 'File =', one per line #or include an external list with: # #File = file-name # # Note: / backs up everything on the root partition. #if you have other partitons such as /usr or /home #you will probably want to add them too. # # By default this is defined to point to the Bacula build #directory to give a reasonable FileSet to backup to #disk storage during initial testing. # File = /home/fs/rpmbuild/BUILD/bacula-1.38.11 } # # If you backup the root directory, the following two excluded # files can be useful # Exclude { File = /proc File = /tmp File = /.journal File = /.fsck } } And the error message: Starting Bacula Director services: 28-Haz 09:55 bacula-dir: ERROR TERMINATION at parse_conf.c:853 Config error: Keyword Include not permitted in this resource. Perhaps you left the trailing brace off of the previous resource. : line 76, col 10 of file /etc/bacula/bacula-dir.conf Include { It says I can't put Options{} in FileSet{} section Hi, 27.06.2007 20:31,, Omer Faruk Sen wrote:: I have just copied bacula-dir.conf from one of my previous installations. but it didn't work both 1.38.11 or 2.0.3 ... It seems configuration structure changed Not that much... also, the changes are documented in the manual and the release notes. but what is interesting that 1.38.11 or 2.0.3 comes with old configuration (bacula-dir.conf) and thus doesn't work. Last time I set up a recent Bacula that was not the case... I could easily modify the sample configuration files and it worked. Can someone enlighten me what happened with bacula-dir configuration file? What has changed or can someone send me a working bacula-dir.conf for 1.38.11 or 2.0.3 I doubt a configuration file from someone else will help you much. It might be more useful if you posted the parts that gave errors for you, for example the top of your bacula-dir.conf. Arno Best Regards, On 2007.06.27. 19:03, Craig White wrote: ... TERMINATION at parse_conf.c:853 Config error: Keyword Include not permitted in this resource. Perhaps you left the trailing brace off of the previous resource. : line 76, col 10 of file /etc/bacula/bacula-dir.conf Include { after taking these errors I have used the conf file that comes with stock bacula package but again i got the same error messages. Is bacula configuration changed in new versions? I have also tried bacula 1.38.11 and bacula 2.0.3 version and got the same error messages.. I had a similar issue but it was obvious that something was wrong with the conf file. In my case, I had a Windows system and I was using quotations to enclose an 'Include' path - something like this... File = c:\Document and Settings\ and UNIX interprets the \ as an escape which meant that the quotes were never closed so I had to use '\\' for the backslashes. bacula manual explicitly tells not to do that ;) http://www.bacula.org/rel-manual/FileSet_Resource.html Windows users, please take note to specify directories (even c:/...) in Unix path notation. If you use Windows conventions, you will most likely not be able to restore your files due to the fact that the Windows path separator was defined as an escape character long before Windows existed, and Bacula adheres to that convention -- Rich - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Arno Lehmann IT-Service Lehmann www.its-lehmann.de - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Omer Faruk Sen http://www.faruk.net - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list
Re: [Bacula-users] bacula 1.38.11 or bacula 2.0.3 error
are you sure other jobs, jobdefs and whatnot you have before this entry in the file are correct ? maybe you should try to strip the file to absolute minimum, and, if that does not work, show the complete configuration. On 2007.06.28. 09:48, Omer Faruk Sen wrote: Ok then. Here is the lines that are not working: # List of files to be backed up FileSet { Name = Full Set Include { Options { signature = MD5 } # # Put your list of files here, preceded by 'File =', one per line #or include an external list with: # #File = file-name # # Note: / backs up everything on the root partition. #if you have other partitons such as /usr or /home #you will probably want to add them too. # # By default this is defined to point to the Bacula build #directory to give a reasonable FileSet to backup to #disk storage during initial testing. # File = /home/fs/rpmbuild/BUILD/bacula-1.38.11 } # # If you backup the root directory, the following two excluded # files can be useful # Exclude { File = /proc File = /tmp File = /.journal File = /.fsck } } And the error message: Starting Bacula Director services: 28-Haz 09:55 bacula-dir: ERROR TERMINATION at parse_conf.c:853 Config error: Keyword Include not permitted in this resource. Perhaps you left the trailing brace off of the previous resource. : line 76, col 10 of file /etc/bacula/bacula-dir.conf Include { It says I can't put Options{} in FileSet{} section ... -- Rich - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bacula 1.38.11 or bacula 2.0.3 error
I have solved the problem. It is the LC_ settings of the machine it was set to something( to turkish locale) other than xxx..UTF-8 . I have added following lines to /etc/rc.d/init.d/bacula-dir startup script and problem solved bacula-dir started perfectly with default configuration problem. export LANG=en_US.UTF-8 export LC_ALL=en_US.UTF-8 Ok then. Here is the lines that are not working: # List of files to be backed up FileSet { Name = Full Set Include { Options { signature = MD5 } # # Put your list of files here, preceded by 'File =', one per line #or include an external list with: # #File = file-name # # Note: / backs up everything on the root partition. #if you have other partitons such as /usr or /home #you will probably want to add them too. # # By default this is defined to point to the Bacula build #directory to give a reasonable FileSet to backup to #disk storage during initial testing. # File = /home/fs/rpmbuild/BUILD/bacula-1.38.11 } # # If you backup the root directory, the following two excluded # files can be useful # Exclude { File = /proc File = /tmp File = /.journal File = /.fsck } } And the error message: Starting Bacula Director services: 28-Haz 09:55 bacula-dir: ERROR TERMINATION at parse_conf.c:853 Config error: Keyword Include not permitted in this resource. Perhaps you left the trailing brace off of the previous resource. : line 76, col 10 of file /etc/bacula/bacula-dir.conf Include { It says I can't put Options{} in FileSet{} section Hi, 27.06.2007 20:31,, Omer Faruk Sen wrote:: I have just copied bacula-dir.conf from one of my previous installations. but it didn't work both 1.38.11 or 2.0.3 ... It seems configuration structure changed Not that much... also, the changes are documented in the manual and the release notes. but what is interesting that 1.38.11 or 2.0.3 comes with old configuration (bacula-dir.conf) and thus doesn't work. Last time I set up a recent Bacula that was not the case... I could easily modify the sample configuration files and it worked. Can someone enlighten me what happened with bacula-dir configuration file? What has changed or can someone send me a working bacula-dir.conf for 1.38.11 or 2.0.3 I doubt a configuration file from someone else will help you much. It might be more useful if you posted the parts that gave errors for you, for example the top of your bacula-dir.conf. Arno Best Regards, On 2007.06.27. 19:03, Craig White wrote: ... TERMINATION at parse_conf.c:853 Config error: Keyword Include not permitted in this resource. Perhaps you left the trailing brace off of the previous resource. : line 76, col 10 of file /etc/bacula/bacula-dir.conf Include { after taking these errors I have used the conf file that comes with stock bacula package but again i got the same error messages. Is bacula configuration changed in new versions? I have also tried bacula 1.38.11 and bacula 2.0.3 version and got the same error messages.. I had a similar issue but it was obvious that something was wrong with the conf file. In my case, I had a Windows system and I was using quotations to enclose an 'Include' path - something like this... File = c:\Document and Settings\ and UNIX interprets the \ as an escape which meant that the quotes were never closed so I had to use '\\' for the backslashes. bacula manual explicitly tells not to do that ;) http://www.bacula.org/rel-manual/FileSet_Resource.html Windows users, please take note to specify directories (even c:/...) in Unix path notation. If you use Windows conventions, you will most likely not be able to restore your files due to the fact that the Windows path separator was defined as an escape character long before Windows existed, and Bacula adheres to that convention -- Rich - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Arno Lehmann IT-Service Lehmann www.its-lehmann.de - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Omer Faruk Sen
Re: [Bacula-users] checksumming problem
Thanks Kern. Kern Sibbald wrote: It seems like the checksumming and base64 encoding in the version of Bacula we have is broken. We can't just run md5sum on the command line and compare against what's in the Catalog. The bug report for this is here (fixed in newer releases): The code was not broken. The hash code is identical to the RFC defining it. However, when Bacula was originally written, there was no RFC for 64 bit encoding or I wasn't aware of it, so the 64 bit printable representation was different from what md5sum produces. Noted. Perhaps unusual is a better word than broken :-) Some questions: 1) Are the checksums stored in Bacula any use to me at all? Yes, of course, but they are not so easy to use without a bit of work. OK. We can do some work 2) Can I set up a Verify task, and compare the stored checksums against the disk copies? Or is this going to be too hard, given that the InitCatalog jobs was never run, and we have moved files around? The closest thing to what you want is a Verify VolumeToCatalog. It will verifiy that the hash codes stored on the Volume are the same as those in the catalog. This means that Bacula must read the whole tape to find the hash codes, but they are pre-computed, so Bacula does not actually read the data on the Volume and re-compute a hash code (considering the data such as Win32 data, ... that would be a nearly impossible task anyway). Re-reading all the tapes is not an option, I'm afraid. There is a C++ program (actually written in C) in bacula-source/src/lib/md5.c that you can tweak and compile into a program that will permit you to create an md5 program that does the same thing as md5sum, but using the Bacula 64 bit encoding scheme ... If I remember right, if you have already configured and built Bacula, you can simply: cd bacula-source/src/lib make md5sum and it will create a binary named md5 (I think) that you can execute. If not, just tweak the Makefile. Right, got the 1.36.3 source. Compiled the md5sum binary. It does something, but gives a hex answer. The database has an base64 entry. Hmmm. [EMAIL PROTECTED] lib]# ./md5sum /path/to/datfix/2101.1.dat c4e8a6c211039eae6e94da1620b35581 Now compare this to the catalog in Mysql: mysql select Filename.FilenameId,Path.Path,Filename.Name,File.MD5 from Path,File,Filename where Filename.Name='2101.1.dat' and Filename.FilenameId=File.FilenameId and File.PathId=Path.PathId and Path like '%/datfix/%'; ++-+++ | FilenameId | Path| Name | MD5 ++-+++ | 137634 | /original/path/ | 2101.1.dat | ti/+AnBHiz4yb9YM45/RDB | | 137634 | /original/path/ | 2101.1.dat | ti/+AnBHiz4yb9YM45/RDB | ++-+++ 2 rows in set (0.00 sec) (There are two entries, because we do on and off-site backup runs) How do I get from c4e8a6c211039eae6e94da1620b35581 to ti/+AnBHiz4yb9YM45/RDB or vice-versa? I think I am stuck. For reference, the standard linux md5sum gives this: [EMAIL PROTECTED] lib]# /usr/bin/md5sum /path/to/datfix/2000/2101.1.dat b622fe0270478b3e326cd60ce196d10d I have checked all this with some other files, and the behaviour is the same. Thanks, Jon -- Jon Wilson [EMAIL PROTECTED] Systems Administration Manager PO Box H58, Australia Square, Sydney NSW 1215 Level 2, 9 Castlereagh Street, Sydney Office Tel:+61 9231 5888 Direct Tel:+61 2 9236 9118 Fax: +61 2 9231 5988 www.sirca.org.au DISCLAIMER: The contents of this email, inclusive of attachments, may be legally privileged and confidential. Any unauthorised use of the contents is expressly prohibited. If you have received this email message in error or are not the intended recipient, you should destroy the message along with any attachment(s). Unintended recipients of this email are prohibited from retaining, disclosing, distributing or using any information herein. This email is also subject to copyright. No part of it should be reproduced, adapted or transmitted without the written consent of the copyright owner. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] The thing with restoring Moved and Deleted files
On Wed, 27 Jun 2007 16:55:42 -0400, Chris Hoogendyk said: Martin Simmons wrote: On Wed, 27 Jun 2007 09:46:01 -0400, Chris Hoogendyk said: Martin Simmons wrote: Because it is not a bug, it is the way things work. ... given standard backup algorithms Many commercial backup softwares have exactly the same problem. I would never use or even pay such a backup software. Some of those commercial backup packages run into tens of thousands of dollars. There are only a couple I'm aware of which do it the right way Fortunately in bacula, 90% of the work is already done - there is a file database in place. It is mainly a matter of hammering out the right method and cutting code - something I'm afraid I'm no good at. Once the GUI is done for the lazy people, they will find out that bacula is missing a reliable and professional reason. See above. There are very few enterprise-grade packages which can do snapshot restores via incrementals and they cost a great deal of money. Ironically, lots of open source unix backup systems do implement it! __Martin lots? for example? star (http://freshmeat.net/projects/star/) dump on Linux dump of FreeBSD GNU tar (well, it tries, but there are bugs) ufsdump on Solaris (OK, this is only recently open source) + all the wrapper scripts for the above Ahhh. I see what you mean by lots. ;-) Note that those are all one-off backup this partition or directory now programs. None of them are integrated backup systems like bacula or amanda. The list was just talking about dump being broken on Linux. True, but the moved/deleted file tracking is working in dump AFAIK. The problems are just related to backing up a live system, which I think has always been dangerous for dump-like programs on Unix. GNU tar tries? There are various options like --listed-incremental, which work in many cases but have a long history of bugs. star is a tar variant that has been stuck in 1.5 alpha versions for over 2 years. I actually found an old star-users email talking about using star through amanda so they could run unattended. I also found some discussions on that list arguing that GNU tar actually did work. True, it does always seem to be in alpha :-) So, we're left with ufsdump on Solaris and any wrapper scripts for it? And possibly dump on FreeBSD? And maybe GNU tar. None of those are integrated backup systems. However, they all plug into amanda. So, the implication is that amanda works, giving us lots=1. Any other open source integrated backup systems? I'm sure there are some other wrappers for tar that keep a catalog, though probably not as sophisticated as Bacula or Amanda. I've never had much call to do full recoveries with incrementals added on. I guess Sun hardware with mirroring just doesn't fail often enough. ;-) But, I'm running an experiment right now, trashing a file system that's my development space just so I can use ufsrestore to do a full and incremental restore. When it comes to backup and restore, I prefer hands on experience. Ahh, done already. Cool. It worked. Files and directories removed before the incremental ufsdump were restored by the full ufsrestore and then removed by the incremental ufsrestore. Files and directories moved before the incremental ufsdump were restored in their original position by the full ufsrestore and then moved to their new position by the incremental ufsrestore. I didn't actually know that that worked before. Nice to know. 8-) Yes, it is neat. __Martin - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] checksumming problem
Hello, On Thursday 28 June 2007 09:37, Jon Wilson wrote: Thanks Kern. Kern Sibbald wrote: It seems like the checksumming and base64 encoding in the version of Bacula we have is broken. We can't just run md5sum on the command line and compare against what's in the Catalog. The bug report for this is here (fixed in newer releases): The code was not broken. The hash code is identical to the RFC defining it. However, when Bacula was originally written, there was no RFC for 64 bit encoding or I wasn't aware of it, so the 64 bit printable representation was different from what md5sum produces. Noted. Perhaps unusual is a better word than broken :-) Some questions: 1) Are the checksums stored in Bacula any use to me at all? Yes, of course, but they are not so easy to use without a bit of work. OK. We can do some work 2) Can I set up a Verify task, and compare the stored checksums against the disk copies? Or is this going to be too hard, given that the InitCatalog jobs was never run, and we have moved files around? The closest thing to what you want is a Verify VolumeToCatalog. It will verifiy that the hash codes stored on the Volume are the same as those in the catalog. This means that Bacula must read the whole tape to find the hash codes, but they are pre-computed, so Bacula does not actually read the data on the Volume and re-compute a hash code (considering the data such as Win32 data, ... that would be a nearly impossible task anyway). Re-reading all the tapes is not an option, I'm afraid. There is a C++ program (actually written in C) in bacula-source/src/lib/md5.c that you can tweak and compile into a program that will permit you to create an md5 program that does the same thing as md5sum, but using the Bacula 64 bit encoding scheme ... If I remember right, if you have already configured and built Bacula, you can simply: cd bacula-source/src/lib make md5sum and it will create a binary named md5 (I think) that you can execute. If not, just tweak the Makefile. Right, got the 1.36.3 source. Compiled the md5sum binary. It does something, but gives a hex answer. The database has an base64 entry. Hmmm. [EMAIL PROTECTED] lib]# ./md5sum /path/to/datfix/2101.1.dat c4e8a6c211039eae6e94da1620b35581 Now compare this to the catalog in Mysql: mysql select Filename.FilenameId,Path.Path,Filename.Name,File.MD5 from Path,File,Filename where Filename.Name='2101.1.dat' and Filename.FilenameId=File.FilenameId and File.PathId=Path.PathId and Path like '%/datfix/%'; ++-+++ | FilenameId | Path| Name | MD5 ++-+++ | 137634 | /original/path/ | 2101.1.dat | ti/+AnBHiz4yb9YM45/RDB | | 137634 | /original/path/ | 2101.1.dat | ti/+AnBHiz4yb9YM45/RDB | ++-+++ 2 rows in set (0.00 sec) (There are two entries, because we do on and off-site backup runs) How do I get from c4e8a6c211039eae6e94da1620b35581 to ti/+AnBHiz4yb9YM45/RDB or vice-versa? I think I am stuck. For reference, the standard linux md5sum gives this: [EMAIL PROTECTED] lib]# /usr/bin/md5sum /path/to/datfix/2000/2101.1.dat b622fe0270478b3e326cd60ce196d10d I have checked all this with some other files, and the behaviour is the same. I guess 1.36.3, which is pretty old is probably missing some code that is in md5.c in the current SVN. I'll send a second email with the current md5.c attached -- off list. It *should* compile and run fine in your 1.36.3 code, just save the original for comparison if you run into problems. Thanks, Jon -- Jon Wilson [EMAIL PROTECTED] Systems Administration Manager PO Box H58, Australia Square, Sydney NSW 1215 Level 2, 9 Castlereagh Street, Sydney Office Tel:+61 9231 5888 Direct Tel:+61 2 9236 9118 Fax: +61 2 9231 5988 www.sirca.org.au DISCLAIMER: The contents of this email, inclusive of attachments, may be legally privileged and confidential. Any unauthorised use of the contents is expressly prohibited. If you have received this email message in error or are not the intended recipient, you should destroy the message along with any attachment(s). Unintended recipients of this email are prohibited from retaining, disclosing, distributing or using any information herein. This email is also subject to copyright. No part of it should be reproduced, adapted or transmitted without the written consent of the copyright owner. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/
[Bacula-users] MYSQL hint needed.
I need to find tapes which are at. or close to expiry. Does anyone have a MYSQL snippet to do this? - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Developer coordination
Hello, As developers come and go, and as Bacula gets larger and larger, and is now being used at the Enterprise level, I am more and more feeling the need to have a better way to keep the status of developer's efforts and a better way to communicate among us. In working on promoting a professional support service for Bacula (more about that probably mid-July), I have experimented a bit with RT a ticket tracking system. The more I look at it, the more I think it would be appropriate for tracking developer's efforts. The basic idea is that each developer would have access to the Bacula RT system, and would create and respond to ticket items that describe their project and the various stages they are in their project. Primarily this would be for developers, but there might be a way to give a certain public view of the overall project status. If you are familar with RT, I would appreciate hearing your comments about this proposal. If you are not familar with RT, you might want to take a look at their site, though reading their documentation and viewing their screenshots is not quite the same as using the system. For more see: http://bestpractical.com/rt I'm currently in the process of setting up a Bacula RT on my server where developers will be able to try it out. If any of you have experience using RT in any context, but particularly for development coordination, I would really appreciate to hear about it. Best regards, Kern PS: If you are a Bacula developer and you have any objections to this proposal or particular direction you would like it to take, now is the time to speak up. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] MYSQL hint needed.
On Thu, 28 Jun 2007, Alan Brown wrote: I need to find tapes which are at. or close to expiry. Does anyone have a MYSQL snippet to do this? I believe the following snippet will tell you all the Volumes due to expire in the next week, and the date and time they'll expire. It compares the LastWritten value + the VolRetention value to the current time. select VolumeName, FROM_UNIXTIME(UNIX_TIMESTAMP(LastWritten) + VolRetention) AS 'Expiration' from Media where DATEDIFF(FROM_UNIXTIME(UNIX_TIMESTAMP(LastWritten) + VolRetention), NOW()) = 7; Obviously, change the last number to reflect your idea of 'close to expiry' - if you need all the tapes expiring tomorrow, change it to 1, etc. (And, of course, if I've misunderstood 'expiration', I apologize in advance) -- D - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bat screenshots
If anyone's interested in seeing what Kern's been busy with (other than dealing with bug reports from annoying users like myself), I've posted a collection of screenshots of the current SVN version of Bat up on the Bacula wiki: http://wiki.bacula.org/doku.php?id=bat -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Senior Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E3 E2E8 8CEC - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] [Bacula-devel] Developer coordination
On Thursday 28 June 2007 16:27, demerphq wrote: On 6/28/07, Kern Sibbald [EMAIL PROTECTED] wrote: Hello, As developers come and go, and as Bacula gets larger and larger, and is now being used at the Enterprise level, I am more and more feeling the need to have a better way to keep the status of developer's efforts and a better way to communicate among us. In working on promoting a professional support service for Bacula (more about that probably mid-July), I have experimented a bit with RT a ticket tracking system. The more I look at it, the more I think it would be appropriate for tracking developer's efforts. The basic idea is that each developer would have access to the Bacula RT system, and would create and respond to ticket items that describe their project and the various stages they are in their project. Primarily this would be for developers, but there might be a way to give a certain public view of the overall project status. If you are familar with RT, I would appreciate hearing your comments about this proposal. If you are not familar with RT, you might want to take a look at their site, though reading their documentation and viewing their screenshots is not quite the same as using the system. For more see: http://bestpractical.com/rt I'm currently in the process of setting up a Bacula RT on my server where developers will be able to try it out. If any of you have experience using RT in any context, but particularly for development coordination, I would really appreciate to hear about it. Im familiar with using RT from the Perl project. Id say its a good plan and call. Can you tell me a bit how they have it setup and how the developer's use it? Regards, Kern cheers, Yves -- perl -Mre=debug -e /just|another|perl|hacker/ - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/bacula-devel - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] MYSQL hint needed.
On Thu, 28 Jun 2007, David Romerstein wrote: I believe the following snippet will tell you all the Volumes due to expire in the next week, and the date and time they'll expire. It compares the LastWritten value + the VolRetention value to the current time. Thanks, that's exactly what I needed. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Public online backup services
I have noticed an increasing number of public (Windows centric) online backup services. Sometimes they are free or sometimes there is a modest charge. They give the little Windows people a client program that automatically backs up their stuff to some server somewhere. I thought, wouldn't it be nice if those services ran a Bacula storage daemon for me. I could run a job to backup important stuff, encrypt it and send it to off site storage. Do you suppose such a thing will ever exist? A commercial, public Bacula based service? While I am on blue sky topics, the MS Home Server has a patented ability to only make one backup copy of a file that exists on several machines. This is sort of like the Base Job concept only more dynamic and self configuring. Ignoring MS's patent attorneys, has anybody thought out what would be involved in getting Bacula to do something like that? Bill - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Need advice on adapting mtx-changer for Exabyte Magnum 224
All, I was able to get the changer recognzied as /dev/scsi/changer/c5t4d1 on my Solaris 10_x86 system. Setup /kernel/drv/sgen.conf, loaded the driver, created the devlinks, and we're off. My Magnum 224 has 1 robot, and 1 LTO-3 drive. It holds can hold up to 24 tapes in 2 magazines. I currently have 1 fully loaded, 12 tape magazine installed. I'm now trying to get mtx-changer script working correctly by following the Autochanger Resource , http://www.bacula.org/rel-manual/Autochanger_Resource1.html, chapter of the User Guide. Some commands work, others don't. I tested all functions directly with mtx, and with the mtx-changer script. Mtx does perform all the operations correctly. It can load, unload, list, transfer, etc... However, as I said, some of the mtx-changer script functions aren't working correctly. I am unsure whether or not they need to work with the exact syntax described in the chapter, or if the commands will work, but with an expanded syntax (like the Changer Command) and bacula will function correctly. I peformed the mtx-changer tests in the same order as the guide, using its sytax. I also use a full command line to test if that works. In cases where the output isn't what I expected, I tried using mtx directly. First the mtx-changer list command ./mtx-changer /dev/scsi/changer/c5t4d1 list 0 /dev/rmt/0 0 1:Full:VolumeTag=A1 2:Full:VolumeTag=A2 3:Full:VolumeTag=A3 4:Full:VolumeTag=A4 5:Full:VolumeTag=A5 6:Full:VolumeTag=A6 7:Full:VolumeTag=A7 8:Full:VolumeTag=A8 9:Full:VolumeTag=A9 10:Full:VolumeTag=A00010 11:Full:VolumeTag=A00011 I know I have a fully loaded magazine in the library, so I check with mtx. [EMAIL PROTECTED]: mtx -f /dev/scsi/changer/c5t4d1 status Storage Changer /dev/scsi/changer/c5t4d1:1 Drives, 12 Slots ( 1 Import/Export ) Data Transfer Element 0:Empty Storage Element 1:Full :VolumeTag=A1 Storage Element 2:Full :VolumeTag=A2 Storage Element 3:Full :VolumeTag=A3 Storage Element 4:Full :VolumeTag=A4 Storage Element 5:Full :VolumeTag=A5 Storage Element 6:Full :VolumeTag=A6 Storage Element 7:Full :VolumeTag=A7 Storage Element 8:Full :VolumeTag=A8 Storage Element 9:Full :VolumeTag=A9 Storage Element 10:Full :VolumeTag=A00010 Storage Element 11:Full :VolumeTag=A00011 Storage Element 12 IMPORT/EXPORT:Full :VolumeTag=A00012 I checked the mtx-changer script and can see whats happening, but am not quite sure what the best way to remedy this is... Next the slots command, which works with the syntax from the guide. ./mtx-changer /dev/scsi/changer/c5t4d1 slots 0 /dev/rmt/0 0 12 Testing unload with the syntax of the guide produced: ./mtx-changer /dev/scsi/changer/c5t4d1 unload usage: mtx-changer ctl-device command [slot archive-device drive-index] Insufficient number of arguments arguments given. Command expected 5 arguments So I tried with a full command: ./mtx-changer /dev/scsi/changer/c5t4d1 unload 0 /dev/rmt/0 0 Unloading Data Transfer Element into Storage Element 0...mtx: Request Sense: Long Report=yes This makes sense as there is no tape in the drive. The load command appears to work: ./mtx-changer /dev/scsi/changer/c5t4d1 load 3 /dev/rmt/0 0 And loaded proves so: ./mtx-changer /dev/scsi/changer/c5t4d1 loaded 0 /dev/rmt/0 0 3 Before I ran the next mtx-changer test in the guide, I wanted to see what the list command and mtx status output showed. ./mtx-changer /dev/scsi/changer/c5t4d1 list 0 /dev/rmt/0 0 1:Full:VolumeTag=A1 2:Full:VolumeTag=A2 4:Full:VolumeTag=A4 5:Full:VolumeTag=A5 6:Full:VolumeTag=A6 7:Full:VolumeTag=A7 8:Full:VolumeTag=A8 9:Full:VolumeTag=A9 10:Full:VolumeTag=A00010 11:Full:VolumeTag=A00011 3:A3 Now in this case, from what I can tell of mtx-changer script, its correct in not displaying slot 12, as there isn't a tape in that slot. Is the drive status being shown correctly though? What format should a loaded tape drive be displayed as by mtx-changer? Mtx status looks like I'd expect mtx -f /dev/scsi/changer/c5t4d1 status Storage Changer /dev/scsi/changer/c5t4d1:1 Drives, 12 Slots ( 1 Import/Export ) Data Transfer Element 0:Full (Storage Element 3 Loaded):VolumeTag = A3 Storage Element 1:Full :VolumeTag=A1 Storage Element 2:Full :VolumeTag=A2 Storage Element 3:Empty:VolumeTag= Storage Element 4:Full :VolumeTag=A4 Storage Element 5:Full :VolumeTag=A5 Storage Element 6:Full :VolumeTag=A6 Storage Element 7:Full :VolumeTag=A7 Storage Element 8:Full :VolumeTag=A8 Storage Element 9:Full :VolumeTag=A9 Storage Element 10:Full :VolumeTag=A00010 Storage Element 11:Full :VolumeTag=A00011 Storage Element 12 IMPORT/EXPORT:Full :VolumeTag=A00012 Now back to the guide commands. I try to unload the tape: ./mtx-changer /dev/scsi/changer/c5t4d1 unload usage: mtx-changer ctl-device
Re: [Bacula-users] Public online backup services
Bill Merriam wrote: I have noticed an increasing number of public (Windows centric) online backup services. Sometimes they are free or sometimes there is a modest charge. They give the little Windows people a client program that automatically backs up their stuff to some server somewhere. I thought, wouldn't it be nice if those services ran a Bacula storage daemon for me. I could run a job to backup important stuff, encrypt it and send it to off site storage. Do you suppose such a thing will ever exist? A commercial, public Bacula based service? While I am on blue sky topics, the MS Home Server has a patented ability to only make one backup copy of a file that exists on several machines. This is sort of like the Base Job concept only more dynamic and self configuring. Ignoring MS's patent attorneys, has anybody thought out what would be involved in getting Bacula to do something like that? I'm not quite sure how MS got away with patenting that. Well, yeah, I guess I am. They have money lawyers and use them both abusively with no respect for truth or the rights of others. Anyway, Retrospect has been doing that for 25 years or more on Macintosh. I don't know the details, but some sort of file signature that might have more than one parameter, including file size and a checksum or something like that. The system catalog that Retrospect generates includes that information. One step in the backup sequence is to match the newly generated catalog for a particular client against the existing catalogs on the server and determine what things actually need to be backed up. Things which have an exact match for the file signature would get a link to the already backed up instance. Interestingly, I came up with the idea of doing something like that (using name, md5, size, etc.) to identify the correct fonts to use with a document in order to guarantee that it formatted and printed correctly. When I googled the idea, I found that someone had patented it just a couple of months ago. Luckily, it wasn't MS. Anyway, if Bacula developers want to do that, I think it's fair game. However, not being a lawyer, I wouldn't want anyone to count that as official legal advice. I'm just assuming that prior (long standing) implementations ought to negate MS' patent claims, unless it is some very specific technique that they have patented. --- Chris Hoogendyk - O__ Systems Administrator c/ /'_ --- Biology Geology Departments (*) \(*) -- 140 Morrill Science Center ~~ - University of Massachusetts, Amherst [EMAIL PROTECTED] --- Erdös 4 - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Need advice on adapting mtx-changer for Exabyte Magnum 224
I have a Magnum224 with 24 slots and 2 LTO2 drives but I am using linux and not Solaris. For that I did not have to change anything in the default mtx scripts as it works correctly. I believe the numbering is one slot off though but it does not matter. When I do a manual unload I verify the slot from the screen on the changer itself. I will try to answer the questions I can. One thing I would like to mention is that I am using bacula 2.X now. I mention that because I had a serious problems with 1.38.X and my changer. So everything is back to normal, but I still have a few questions How can I get mtx-changer to display the status of all my slots correctly? Is the format that mtx-changer is displaying the status of a loaded drive correct? Does it matter to bacula that I had to use the full command to unload the drive? Will Bacula know what storage element is in the drive and to move it back to the correct slot? For me bacula always puts the tape back into the stot it took it from. I have never tried manuall loading a tape there and seeing what would happen for an unload. How do I change tapes and update inventory? Use the release command in bacula to release any tape from the drive. Then change the tapes manually on the changer. I recommend doing that by unloading the magazines. Then after you are done with the manual stuff. type update slots in a bacula console. I was considering keeping a cleaning tape in slot 12, will this interfere with Bacula at all? Can I schedule cleaning operations with Bacula? This is fine. I have a CLN_ barcode on my cleaning tape and in my pools I have Cleaning Prefix = CLN so that bacula recognizes that as a cleaning tape. Any responses, or wilingness to share some mtx-changer magic is very appreciated. Also if you've used any replacement for mtx or mtx-changer and want to share the experience that would be great! John - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] [Bacula-devel] Developer coordination
Kern Sibbald schrieb: If you are familar with RT, I would appreciate hearing your comments about this proposal. If you are not familar with RT, you might want to take a look at their site, though reading their documentation and viewing their screenshots is not quite the same as using the system. For more see: http://bestpractical.com/rt maybe trac is also an option? http://en.wikipedia.org/wiki/Trac *http://trac*.edgewall.org It integrates a wiki, ticket system, milestone management and subversion browser. Tom - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Incremental backup upgrades to full when another filesystem is added in a file set
Hi All, I know that incremental backup upgrades to full backup, if another file system is added to a file set. The disadvantage of the scheme being, that I will have to take a full backup before schedule which disrupts other backup schedules. Is there anyway to avoid this and let bacula take the incremental like ufsdump where it will just backup the additional added disk? My bacula version is 1.38.5 running on solaris 8. Thanks and Regards - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Incremental backup upgrades to full when another filesystem is added in a file set
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Please read the list archives. This was discussed no earlier than this weekend (and in fact, some of the messages were from today). Naufal Sheikh wrote: Hi All, I know that incremental backup upgrades to full backup, if another file system is added to a file set. The disadvantage of the scheme being, that I will have to take a full backup before schedule which disrupts other backup schedules. Is there anyway to avoid this and let bacula take the incremental like ufsdump where it will just backup the additional added disk? My bacula version is 1.38.5 running on solaris 8. - -- _ _ _ _ ___ _ _ _ |Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer III |$| |__| | | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922) \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGg+Mwmb+gadEcsb4RAurOAJ9adjxMR4ZPUmCNItcJlZxyPlCTyACgynvK LkLTYc5iyEveAdJbtSo5tV0= =W9bv -END PGP SIGNATURE- - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] [Bacula-devel] Developer coordination
On Thursday 28 June 2007 18:14, Thomas Traeger wrote: Kern Sibbald schrieb: If you are familar with RT, I would appreciate hearing your comments about this proposal. If you are not familar with RT, you might want to take a look at their site, though reading their documentation and viewing their screenshots is not quite the same as using the system. For more see: http://bestpractical.com/rt maybe trac is also an option? http://en.wikipedia.org/wiki/Trac *http://trac*.edgewall.org It integrates a wiki, ticket system, milestone management and subversion browser. Thanks. Unfortunately, it seems to lack an email interface. RT (and most likely otrs) has email input to the tracking system -- this is, IMO, an essential requirement. Tom - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/bacula-devel - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Public online backup services
Chris Hoogendyk wrote: Bill Merriam wrote: snip While I am on blue sky topics, the MS Home Server has a patented ability to only make one backup copy of a file that exists on several machines. This is sort of like the Base Job concept only more dynamic and self configuring. Ignoring MS's patent attorneys, has anybody thought out what would be involved in getting Bacula to do something like that? snip Retrospect has been doing that for 25 years or more on Macintosh. snip Oops. Nearly 20 years. Not 25 years or more. Just getting confused by being in a new century. ;-) It'll be a couple of years before Macintosh hits the big 25. --- Chris Hoogendyk - O__ Systems Administrator c/ /'_ --- Biology Geology Departments (*) \(*) -- 140 Morrill Science Center ~~ - University of Massachusetts, Amherst [EMAIL PROTECTED] --- Erdös 4 - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] [Bacula-devel] Developer coordination
I have to say i like it quite a bit. Very powerful search features and ways of customizing your view of the tickets in the system. Another vote from here. It's a nice tool, if you add a few features around it. Perl comes bundled with a tool called perlbug which knows how to write a bug report for perl that contains the necessary diagnostic and environmental information to track the bug down. It then sends an email to the bug list where RT automatically picks it up, replies and forwards a copy to the main dev list. Glad you mentioned this; this would be an enormous help (or structure a WWW-based front end to collect the info you want, and use that to actually submit the bug report). You or someone else will probably have to do a few months worth of that's a bug, submit it via on the mailing lists to get people used to the idea, but it would make it easier to work on stuff. Given the out-of-control state of the spam industry, allowing people to directly open tickets in RT via email is a good recipe for a lot of spam noise. We had to do some fairly draconian whitelist processing to avoid getting our support queues hammered by spammers. Disabling the automatic registration function in RT is a good idea -- if you combine it with a tool like perlbug, you at least make it a little bit daunting to annoy lots of people. A perlbug-like interface that talked to a WWW application that did some validation on the input could also manage the whitelist, and then pass the posting on to RT. Another comment: if you're going to use RT, then I'd put in a vote that you decommission mantis and make the switch complete. Mantis works, but you're not going to want to have two places to hunt for stuff, and having the ability to link tickets and relate things within ticketing systems is a really Good Thing that you won't be able to do if both continue to be actively used. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Need advice on adapting mtx-changer for Exabyte Magnum 224
Thanks for the reply and info on cleaning tapes. I'm using v2.0.3 of Bacula. I think if I have my Changer Command correct that I'll be alright. Going to test it out and see what happens. Thanks, Shon On 6/28/07, John Drescher [EMAIL PROTECTED] wrote: I have a Magnum224 with 24 slots and 2 LTO2 drives but I am using linux and not Solaris. For that I did not have to change anything in the default mtx scripts as it works correctly. I believe the numbering is one slot off though but it does not matter. When I do a manual unload I verify the slot from the screen on the changer itself. I will try to answer the questions I can. One thing I would like to mention is that I am using bacula 2.X now. I mention that because I had a serious problems with 1.38.X and my changer. So everything is back to normal, but I still have a few questions How can I get mtx-changer to display the status of all my slots correctly? Is the format that mtx-changer is displaying the status of a loaded drive correct? Does it matter to bacula that I had to use the full command to unload the drive? Will Bacula know what storage element is in the drive and to move it back to the correct slot? For me bacula always puts the tape back into the stot it took it from. I have never tried manuall loading a tape there and seeing what would happen for an unload. How do I change tapes and update inventory? Use the release command in bacula to release any tape from the drive. Then change the tapes manually on the changer. I recommend doing that by unloading the magazines. Then after you are done with the manual stuff. type update slots in a bacula console. I was considering keeping a cleaning tape in slot 12, will this interfere with Bacula at all? Can I schedule cleaning operations with Bacula? This is fine. I have a CLN_ barcode on my cleaning tape and in my pools I have Cleaning Prefix = CLN so that bacula recognizes that as a cleaning tape. Any responses, or wilingness to share some mtx-changer magic is very appreciated. Also if you've used any replacement for mtx or mtx-changer and want to share the experience that would be great! John - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] 1.38.x and 2.x in parallel?
good day all, is it possible to run 2.x and 1.38.x in parallel? i've got 1.38.x running in production and i'd like to put a copy of 2.x on my backup server to test then migrate my 1.38.x once i've come to terms with 2.x thanks! -- michael - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] 1.38.x and 2.x in parallel?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael Galloway wrote: good day all, is it possible to run 2.x and 1.38.x in parallel? i've got 1.38.x running in production and i'd like to put a copy of 2.x on my backup server to test then migrate my 1.38.x once i've come to terms with 2.x thanks! As long as they don't share the same storage devices and with some hackery, yes. You will need to: - - change the catalog that it uses (bacula-dir.conf, the DB creation scripts) - - change all the ports (all .conf files) - - make sure you're not using storage devices in both simultaneously (bacula-sd.conf) Greetings, Michel -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32) iD8DBQFGg/Xr2Vs+MkscAyURAouaAJ9XdPW6TQNIT7DxZWvpeyJgml1UNgCgqcCq rj5Fu6/ebj9Hg7859o3RYFU= =NmGO -END PGP SIGNATURE- - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] query.sql suggestion
Thanks to David for the snippet this morning. I wanted to find tapes which were expired (or very close to expired(*)) and have them loaded into the autochanger before they are purged, plus not have bacula suggest they be removed. Here are the 2 snippets I suggest for this. They're adaptions of the existing entries and the advantage of these is that an expired-but-not-purged tape will be flagged for inclusion in the changer _BEFORE_ Bacula asks for it. :List Volumes Bacula thinks should be removed from changer SELECT VolumeName,VolStatus, VolBytes/(1024*1024*1024) AS GB, LastWritten, FROM_UNIXTIME(UNIX_TIMESTAMP(Media.LastWritten) + Media.VolRetention) AS Expiry, Slot,Storage.Name AS Location FROM Media,Pool,Storage WHERE Media.PoolId=Pool.PoolId AND Slot0 AND InChanger=1 AND Media.StorageId=Storage.StorageId AND ((DATEDIFF(FROM_UNIXTIME(UNIX_TIMESTAMP(LastWritten) + (Media.VolRetention * .95)), NOW()) 1 AND ((VolStatus='Used') OR (VolStatus='Full'))) OR (VolStatus='Disabled') OR (VolStatus='Error')) ORDER BY VolumeName ASC, Slot ASC; # 19 :List Volumes Bacula thinks are eligible for the changer SELECT VolumeName,VolStatus,Storage.Name AS Location, VolBytes/(1024*1024*1024) AS GB,LastWritten, FROM_UNIXTIME(UNIX_TIMESTAMP(Media.LastWritten) + Media.VolRetention) AS Expiry FROM Media,Pool,Storage WHERE Media.PoolId=Pool.PoolId # AND Media.StorageId=Storage.StorageId AND InChanger=0 AND Storage.Name='MSL6000-changer' AND ((VolStatus='Purged') OR (VolStatus='Append') OR (VolStatus='Recycle') OR DATEDIFF(FROM_UNIXTIME(UNIX_TIMESTAMP(Media.LastWritten) + (Media.VolRetention * .95)), NOW()) = 1) ORDER BY VolumeName ASC, Pool.Name ASC, VolMounts ASC (*) The selection is 95% of the retention period, rather than Retention period - 7 days - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] The table 'File' is full
Using Bacula 2.0.3 with MySQL 4.1.20 on a CentOS 4.5 x86 director. Doing a full backup of a new file system from a 2.0.3/CentOS 4.5/x86_64 client gives: 28-Jun 12:33 dante-dir: No prior Full backup Job record found. 28-Jun 12:33 dante-dir: No prior or suitable Full backup found in catalog. Doing FULL backup. 28-Jun 12:33 dante-dir: Start Backup JobId 1800, Job=inca-10_data1.2007-06-28_12.33.36 28-Jun 12:33 dante-sd: Volume Backup-0551 previously written, moving to end of data. 28-Jun 12:33 dante-dir: inca-10_data1.2007-06-28_12.33.36 Fatal error: sql_create.c:751 sql_create.c:751 insert INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (1,1800,8249353,345586,'gR BrMoF IGk B RK P1 A A BAA A BGHokQ BGHnZi BGgaUz A A E','1B2M2Y8AsgTpgAmY7PhCfg') failed: The table 'File' is full 28-Jun 12:33 dante-dir: sql_create.c:751 INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (1,1800,8249353,345586,'gR BrMoF IGk B RK P1 A A BAA A BGHokQ BGHnZi BGgaUz A A E','1B2M2Y8AsgTpgAmY7PhCfg') 28-Jun 12:33 dante-dir: inca-10_data1.2007-06-28_12.33.36 Fatal error: sql_create.c:753 Create db File record INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (1,1800,8249353,345586,'gR BrMoF IGk B RK P1 A A BAA A BGHokQ BGHnZi BGgaUz A A E','1B2M2Y8AsgTpgAmY7PhCfg') failed. ERR=The table 'File' is full28-Jun 12:33 dante-dir: inca-10_data1.2007-06-28_12.33.36 Fatal error: catreq.c:476 Attribute create error. sql_create.c:753 Create db File record INSERT INTO File (FileInde ,JobId,PathId,FilenameId,LStat,MD5) VALUES (1,1800,8249353,345586,'gR BrMoF IGk B RK P1 A A BAA A BGHokQ BGHnZi BGgaUz A A E','1B2M2Y8AsgTpgAmY7PhCfg') failed. ERR=The table 'File' is full28-Jun 12:33 dante-dir: inca-10_data1.2007-06-28_12.33.36 Fatal error: sql_create.c:751 sql_create.c:751 insert INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (2,1800,8249353,346071,'gR BrMtx IGk B RK P1 A A BAA A BGHnYa BGHnYa BGgaUz A A E','1B2M2Y8AsgTpgAmY7PhCfg') failed: The table 'File' is full ...and so on for several thousand entries. There are about 10 million files in this file system, but the initial error message as shown above appears right at the beginning of the backup (within one minute). A 'status dir' shows the backup as no longer running, but a 'status client' shows the backup as still active for another hour or so, when it disappears after apparently saving about 177,000 files. I've tried starting mysqld with the big-tables option, but that shouldn't be needed with this version of mysql, and in any event it doesn't make any difference. The /var/bacula filesystem has plenty of free space (about 8GB). The bacula mysql database is about 6GB in size, and there is about 9GB free on that file system. Que? -Steve - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] The table 'File' is full
The table 'File' is full I've tried starting mysqld with the big-tables option, but that shouldn't be needed with this version of mysql, and in any event it doesn't make any difference. The /var/bacula filesystem has plenty of free space (about 8GB). The bacula mysql database is about 6GB in size, and there is about 9GB free on that file system. Que? See http://dev.mysql.com/doc/refman/4.1/en/full-table.html I'd guess it's the max_rows / avg_row_length problem. -- Jorj pgp3dJhuMjd0Q.pgp Description: PGP signature - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] The table 'File' is full
On Thu, 28 Jun 2007, Steve Thompson wrote: 28-Jun 12:33 dante-dir: inca-10_data1.2007-06-28_12.33.36 Fatal error: sql_create.c:753 Create db File record INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (1,1800,8249353,345586,'gR BrMoF IGk B RK P1 A A BAA A BGHokQ BGHnZi BGgaUz A A E','1B2M2Y8AsgTpgAmY7PhCfg') failed. ERR=The table 'File' is full28-Jun 12:33 dante-dir: inca-10_data1.2007-06-28_12.33.36 Fatal error: catreq.c:476 Attribute create error. sql_create.c:753 Create db File record INSERT INTO File (FileInde ,JobId,PathId,FilenameId,LStat,MD5) VALUES (1,1800,8249353,345586,'gR BrMoF IGk B RK P1 A A BAA A BGHokQ BGHnZi BGgaUz A A E','1B2M2Y8AsgTpgAmY7PhCfg') failed. ERR=The table 'File' is full28-Jun 12:33 dante-dir: inca-10_data1.2007-06-28_12.33.36 Fatal error: sql_create.c:751 sql_create.c:751 insert INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (2,1800,8249353,346071,'gR BrMtx IGk B RK P1 A A BAA A BGHnYa BGHnYa BGgaUz A A E','1B2M2Y8AsgTpgAmY7PhCfg') failed: The table 'File' is full I've tried starting mysqld with the big-tables option, but that shouldn't be needed with this version of mysql, and in any event it doesn't make any difference. The /var/bacula filesystem has plenty of free space (about 8GB). The bacula mysql database is about 6GB in size, and there is about 9GB free on that file system. This is documented in the user manual: http://www.bacula.org/dev-manual/Catalog_Maintenance.html#SECTION00244 -- D - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Need advice on adapting mtx-changer for Exabyte Magnum 224
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Not to distract folks from your question, but I'm looking for a way to do this for a single tape drive so I can use smartmontools on it... do you have a pointer for a resource on setting up the sgen.conf file? I've been looking and not finding much (though I only suspected sgen was involved until this e-mail). Shon Stephens wrote: All, I was able to get the changer recognzied as /dev/scsi/changer/c5t4d1 on my Solaris 10_x86 system. Setup /kernel/drv/sgen.conf, loaded the driver, created the devlinks, and we're off. My Magnum 224 has 1 robot, and 1 LTO-3 drive. It holds can hold up to 24 tapes in 2 magazines. I currently have 1 fully loaded, 12 tape magazine installed. I'm now trying to get mtx-changer script working correctly by following the Autochanger Resource , http://www.bacula.org/rel-manual/Autochanger_Resource1.html, chapter of the User Guide. Some commands work, others don't. I tested all functions directly with mtx, and with the mtx-changer script. Mtx does perform all the operations correctly. It can load, unload, list, transfer, etc... However, as I said, some of the mtx-changer script functions aren't working correctly. I am unsure whether or not they need to work with the exact syntax described in the chapter, or if the commands will work, but with an expanded syntax (like the Changer Command) and bacula will function correctly. I peformed the mtx-changer tests in the same order as the guide, using its sytax. I also use a full command line to test if that works. In cases where the output isn't what I expected, I tried using mtx directly. First the mtx-changer list command ./mtx-changer /dev/scsi/changer/c5t4d1 list 0 /dev/rmt/0 0 1:Full:VolumeTag=A1 2:Full:VolumeTag=A2 3:Full:VolumeTag=A3 4:Full:VolumeTag=A4 5:Full:VolumeTag=A5 6:Full:VolumeTag=A6 7:Full:VolumeTag=A7 8:Full:VolumeTag=A8 9:Full:VolumeTag=A9 10:Full:VolumeTag=A00010 11:Full:VolumeTag=A00011 I know I have a fully loaded magazine in the library, so I check with mtx. [EMAIL PROTECTED]: mtx -f /dev/scsi/changer/c5t4d1 status Storage Changer /dev/scsi/changer/c5t4d1:1 Drives, 12 Slots ( 1 Import/Export ) Data Transfer Element 0:Empty Storage Element 1:Full :VolumeTag=A1 Storage Element 2:Full :VolumeTag=A2 Storage Element 3:Full :VolumeTag=A3 Storage Element 4:Full :VolumeTag=A4 Storage Element 5:Full :VolumeTag=A5 Storage Element 6:Full :VolumeTag=A6 Storage Element 7:Full :VolumeTag=A7 Storage Element 8:Full :VolumeTag=A8 Storage Element 9:Full :VolumeTag=A9 Storage Element 10:Full :VolumeTag=A00010 Storage Element 11:Full :VolumeTag=A00011 Storage Element 12 IMPORT/EXPORT:Full :VolumeTag=A00012 I checked the mtx-changer script and can see whats happening, but am not quite sure what the best way to remedy this is... Next the slots command, which works with the syntax from the guide. ./mtx-changer /dev/scsi/changer/c5t4d1 slots 0 /dev/rmt/0 0 12 Testing unload with the syntax of the guide produced: ./mtx-changer /dev/scsi/changer/c5t4d1 unload usage: mtx-changer ctl-device command [slot archive-device drive-index] Insufficient number of arguments arguments given. Command expected 5 arguments So I tried with a full command: ./mtx-changer /dev/scsi/changer/c5t4d1 unload 0 /dev/rmt/0 0 Unloading Data Transfer Element into Storage Element 0...mtx: Request Sense: Long Report=yes This makes sense as there is no tape in the drive. The load command appears to work: ./mtx-changer /dev/scsi/changer/c5t4d1 load 3 /dev/rmt/0 0 And loaded proves so: ./mtx-changer /dev/scsi/changer/c5t4d1 loaded 0 /dev/rmt/0 0 3 Before I ran the next mtx-changer test in the guide, I wanted to see what the list command and mtx status output showed. ./mtx-changer /dev/scsi/changer/c5t4d1 list 0 /dev/rmt/0 0 1:Full:VolumeTag=A1 2:Full:VolumeTag=A2 4:Full:VolumeTag=A4 5:Full:VolumeTag=A5 6:Full:VolumeTag=A6 7:Full:VolumeTag=A7 8:Full:VolumeTag=A8 9:Full:VolumeTag=A9 10:Full:VolumeTag=A00010 11:Full:VolumeTag=A00011 3:A3 Now in this case, from what I can tell of mtx-changer script, its correct in not displaying slot 12, as there isn't a tape in that slot. Is the drive status being shown correctly though? What format should a loaded tape drive be displayed as by mtx-changer? Mtx status looks like I'd expect mtx -f /dev/scsi/changer/c5t4d1 status Storage Changer
Re: [Bacula-users] The table 'File' is full
On Thu, 28 Jun 2007, David Romerstein wrote: On Thu, 28 Jun 2007, Steve Thompson wrote: 28-Jun 12:33 dante-dir: inca-10_data1.2007-06-28_12.33.36 Fatal error: sql_create.c:753 Create db File record INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (1,1800,8249353,345586,'gR BrMoF IGk B RK P1 A A BAA A BGHokQ BGHnZi BGgaUz A A E','1B2M2Y8AsgTpgAmY7PhCfg') failed. ERR=The table 'File' is full28-Jun 12:33 dante-dir: inca-10_data1.2007-06-28_12.33.36 Fatal error: catreq.c:476 Attribute create error. sql_create.c:753 Create db File record INSERT INTO File (FileInde ,JobId,PathId,FilenameId,LStat,MD5) VALUES (1,1800,8249353,345586,'gR BrMoF IGk B RK P1 A A BAA A BGHokQ BGHnZi BGgaUz A A E','1B2M2Y8AsgTpgAmY7PhCfg') failed. ERR=The table 'File' is full28-Jun 12:33 dante-dir: inca-10_data1.2007-06-28_12.33.36 Fatal error: sql_create.c:751 sql_create.c:751 insert INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (2,1800,8249353,346071,'gR BrMtx IGk B RK P1 A A BAA A BGHnYa BGHnYa BGgaUz A A E','1B2M2Y8AsgTpgAmY7PhCfg') failed: The table 'File' is full I've tried starting mysqld with the big-tables option, but that shouldn't be needed with this version of mysql, and in any event it doesn't make any difference. The /var/bacula filesystem has plenty of free space (about 8GB). The bacula mysql database is about 6GB in size, and there is about 9GB free on that file system. This is documented in the user manual: http://www.bacula.org/dev-manual/Catalog_Maintenance.html#SECTION00244 How I missed that I do not know. Thanks! Steve - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] How different pools affect Backup Levels
Hey All, I have 2 different pools. One for Differentials and one for Fulls. If I backup a full set to my Fulls pool and then backup changes to my Differentials pool will the first backup to the Differentials pool automatically convert to a full because the previous full wasn't apart of that pool? Thanks for your help! -Clyde - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Conditional statements in FileSets
Hey All, Is it possible to have conditional statements within your FileSet definitions? I'd like to backup or not backup a certain file depending on the Backup Level. I know this might be a stretch. Any ideas? Thanks. -Clyde - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] query.sql suggestion
Hi, 28.06.2007 20:59,, Alan Brown wrote:: Thanks to David for the snippet this morning. I wanted to find tapes which were expired (or very close to expired(*)) and have them loaded into the autochanger before they are purged, plus not have bacula suggest they be removed. Here are the 2 snippets I suggest for this. They're adaptions of the existing entries and the advantage of these is that an expired-but-not-purged tape will be flagged for inclusion in the changer _BEFORE_ Bacula asks for it. :List Volumes Bacula thinks should be removed from changer SELECT VolumeName,VolStatus, VolBytes/(1024*1024*1024) AS GB, LastWritten, FROM_UNIXTIME(UNIX_TIMESTAMP(Media.LastWritten) + Media.VolRetention) AS Expiry, Slot,Storage.Name AS Location FROM Media,Pool,Storage WHERE Media.PoolId=Pool.PoolId AND Slot0 AND InChanger=1 AND Media.StorageId=Storage.StorageId AND ((DATEDIFF(FROM_UNIXTIME(UNIX_TIMESTAMP(LastWritten) + (Media.VolRetention * .95)), NOW()) 1 AND ((VolStatus='Used') OR (VolStatus='Full'))) OR (VolStatus='Disabled') OR (VolStatus='Error')) ORDER BY VolumeName ASC, Slot ASC; # 19 :List Volumes Bacula thinks are eligible for the changer SELECT VolumeName,VolStatus,Storage.Name AS Location, VolBytes/(1024*1024*1024) AS GB,LastWritten, FROM_UNIXTIME(UNIX_TIMESTAMP(Media.LastWritten) + Media.VolRetention) AS Expiry FROM Media,Pool,Storage WHERE Media.PoolId=Pool.PoolId # AND Media.StorageId=Storage.StorageId AND InChanger=0 AND Storage.Name='MSL6000-changer' AND ((VolStatus='Purged') OR (VolStatus='Append') OR (VolStatus='Recycle') OR DATEDIFF(FROM_UNIXTIME(UNIX_TIMESTAMP(Media.LastWritten) + (Media.VolRetention * .95)), NOW()) = 1) ORDER BY VolumeName ASC, Pool.Name ASC, VolMounts ASC (*) The selection is 95% of the retention period, rather than Retention period - 7 days I experimented a bit, because I'm running MySQL in a version without DATEDIFF, and came up with something more complicated, due to the time arithmetic involved. Here is my starting point, in case anyone else runs older MySQL catalogs: select VolumeName, LastWritten from Media where VolStatus in ('Append','Used','Full') and unix_timestamp(LastWritten)+VolRetentionunix_timestamp()+(60*60*24*7); 60*60*24*7 should be one week in seconds, by the way. Arno - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Arno Lehmann IT-Service Lehmann www.its-lehmann.de - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] How different pools affect Backup Levels
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 No, the only thing you must make sure of is that your full and differentials are both run by the same job (the levels run by the schedule directive or manually). If you have two different Job defs for these types of backups, you'll have problems, but the pool is immaterial. Clyde O Goffe wrote: Hey All, I have 2 different pools. One for Differentials and one for Fulls. If I backup a full set to my Fulls pool and then backup changes to my Differentials pool will the first backup to the Differentials pool automatically convert to a full because the previous full wasn't apart of that pool? Thanks for your help! -Clyde - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users - -- _ _ _ _ ___ _ _ _ |Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer III |$| |__| | | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922) \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGhBdJmb+gadEcsb4RAre/AJ4u4ehERioZr4SLEKUb0xeuHTSI6gCfUlQc Rrv0PBcNpicqZuUkj6+sHVA= =1OVc -END PGP SIGNATURE- - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] How different pools affect Backup Levels
Hi, 28.06.2007 22:10,, Clyde O Goffe wrote:: Hey All, I have 2 different pools. One for Differentials and one for Fulls. If I backup a full set to my Fulls pool and then backup changes to my Differentials pool will the first backup to the Differentials pool automatically convert to a full because the previous full wasn't apart of that pool? No. That is, as long as you really run the same job. Thanks for your help! -Clyde Arno - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Arno Lehmann IT-Service Lehmann www.its-lehmann.de - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Conditional statements in FileSets
Hi, 28.06.2007 22:13,, Clyde O Goffe wrote:: Hey All, Is it possible to have conditional statements within your FileSet definitions? I'd like to backup or not backup a certain file depending on the Backup Level. I know this might be a stretch. Any ideas? Thanks. Without trying this, I think the way to go is to use a script to generate the file list. Probably on the client, but as long as your file list is static, you could also do this on the server. You have to make sure you don't include things multiple times, like /etc /etc/apache and so on. Arno -Clyde - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Arno Lehmann IT-Service Lehmann www.its-lehmann.de - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Conditional statements in FileSets
Hey Arno, Thanks, something like this is exactly what I was looking for. -Clyde On 6/28/07, Arno Lehmann [EMAIL PROTECTED] wrote: Hi, 28.06.2007 22:13,, Clyde O Goffe wrote:: Hey All, Is it possible to have conditional statements within your FileSet definitions? I'd like to backup or not backup a certain file depending on the Backup Level. I know this might be a stretch. Any ideas? Thanks. Without trying this, I think the way to go is to use a script to generate the file list. Probably on the client, but as long as your file list is static, you could also do this on the server. You have to make sure you don't include things multiple times, like /etc /etc/apache and so on. Arno -Clyde - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Arno Lehmann IT-Service Lehmann www.its-lehmann.de - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Need advice on adapting mtx-changer for Exabyte Magnum 224
Hey Ryan, I used an sgen.conf provided by Tandeberg support. I'm not sure if its in their Knowledge Base. Here is what I've got # Exabyte Magnum 224 tape library # sgen-diag=3; # device-type-config-list=changer; # inquiry-config-list=EXABYTE, Magnum 224; #inquiry-config-list= EXABYTE, *; #inquiry-config-list= EXABYTE; # name=sgen class=scsi target=0 lun=1; name=sgen class=scsi target=1 lun=1; name=sgen class=scsi target=2 lun=1; name=sgen class=scsi target=3 lun=1; name=sgen class=scsi target=4 lun=1; name=sgen class=scsi target=5 lun=1; name=sgen class=scsi target=6 lun=1; name=sgen class=scsi target=7 lun=1; name=sgen class=scsi target=8 lun=1; name=sgen class=scsi target=9 lun=1; name=sgen class=scsi target=10 lun=1; name=sgen class=scsi target=11 lun=1; name=sgen class=scsi target=12 lun=1; name=sgen class=scsi target=13 lun=1; name=sgen class=scsi target=14 lun=1; name=sgen class=scsi target=15 lun=1; # end Exabyte Magnum 224 Then I ran add_drv sgen and devfsadm. That created /dev/scsi/changer/c5t4d1. Let me know if you get a working mtx-changer script. -Shon On 6/28/07, Ryan Novosielski [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Not to distract folks from your question, but I'm looking for a way to do this for a single tape drive so I can use smartmontools on it... do you have a pointer for a resource on setting up the sgen.conf file? I've been looking and not finding much (though I only suspected sgen was involved until this e-mail). Shon Stephens wrote: All, I was able to get the changer recognzied as /dev/scsi/changer/c5t4d1 on my Solaris 10_x86 system. Setup /kernel/drv/sgen.conf, loaded the driver, created the devlinks, and we're off. My Magnum 224 has 1 robot, and 1 LTO-3 drive. It holds can hold up to 24 tapes in 2 magazines. I currently have 1 fully loaded, 12 tape magazine installed. I'm now trying to get mtx-changer script working correctly by following the Autochanger Resource , http://www.bacula.org/rel-manual/Autochanger_Resource1.html, chapter of the User Guide. Some commands work, others don't. I tested all functions directly with mtx, and with the mtx-changer script. Mtx does perform all the operations correctly. It can load, unload, list, transfer, etc... However, as I said, some of the mtx-changer script functions aren't working correctly. I am unsure whether or not they need to work with the exact syntax described in the chapter, or if the commands will work, but with an expanded syntax (like the Changer Command) and bacula will function correctly. I peformed the mtx-changer tests in the same order as the guide, using its sytax. I also use a full command line to test if that works. In cases where the output isn't what I expected, I tried using mtx directly. First the mtx-changer list command ./mtx-changer /dev/scsi/changer/c5t4d1 list 0 /dev/rmt/0 0 1:Full:VolumeTag=A1 2:Full:VolumeTag=A2 3:Full:VolumeTag=A3 4:Full:VolumeTag=A4 5:Full:VolumeTag=A5 6:Full:VolumeTag=A6 7:Full:VolumeTag=A7 8:Full:VolumeTag=A8 9:Full:VolumeTag=A9 10:Full:VolumeTag=A00010 11:Full:VolumeTag=A00011 I know I have a fully loaded magazine in the library, so I check with mtx. [EMAIL PROTECTED]: mtx -f /dev/scsi/changer/c5t4d1 status Storage Changer /dev/scsi/changer/c5t4d1:1 Drives, 12 Slots ( 1 Import/Export ) Data Transfer Element 0:Empty Storage Element 1:Full :VolumeTag=A1 Storage Element 2:Full :VolumeTag=A2 Storage Element 3:Full :VolumeTag=A3 Storage Element 4:Full :VolumeTag=A4 Storage Element 5:Full :VolumeTag=A5 Storage Element 6:Full :VolumeTag=A6 Storage Element 7:Full :VolumeTag=A7 Storage Element 8:Full :VolumeTag=A8 Storage Element 9:Full :VolumeTag=A9 Storage Element 10:Full :VolumeTag=A00010 Storage Element 11:Full :VolumeTag=A00011 Storage Element 12 IMPORT/EXPORT:Full :VolumeTag=A00012 I checked the mtx-changer script and can see whats happening, but am not quite sure what the best way to remedy this is... Next the slots command, which works with the syntax from the guide. ./mtx-changer /dev/scsi/changer/c5t4d1 slots 0 /dev/rmt/0 0 12 Testing unload with the syntax of the guide produced: ./mtx-changer /dev/scsi/changer/c5t4d1 unload usage: mtx-changer ctl-device command [slot archive-device drive-index] Insufficient number of arguments arguments given. Command expected 5 arguments So I tried with a full command: ./mtx-changer /dev/scsi/changer/c5t4d1 unload 0 /dev/rmt/0 0 Unloading Data Transfer Element into Storage Element 0...mtx: Request Sense: Long Report=yes This makes sense as there is no tape in the drive. The load command appears to work: ./mtx-changer /dev/scsi/changer/c5t4d1 load 3 /dev/rmt/0 0 And loaded proves so: ./mtx-changer /dev/scsi/changer/c5t4d1 loaded 0
Re: [Bacula-users] checksumming problem
Kern Sibbald wrote: [EMAIL PROTECTED] lib]# ./md5sum /path/to/datfix/2101.1.dat c4e8a6c211039eae6e94da1620b35581 Now compare this to the catalog in Mysql: mysql select Filename.FilenameId,Path.Path,Filename.Name,File.MD5 from Path,File,Filename where Filename.Name='2101.1.dat' and Filename.FilenameId=File.FilenameId and File.PathId=Path.PathId and Path like '%/datfix/%'; ++-+++ | FilenameId | Path| Name | MD5 ++-+++ | 137634 | /original/path/ | 2101.1.dat | ti/+AnBHiz4yb9YM45/RDB | | 137634 | /original/path/ | 2101.1.dat | ti/+AnBHiz4yb9YM45/RDB | ++-+++ 2 rows in set (0.00 sec) (There are two entries, because we do on and off-site backup runs) How do I get from c4e8a6c211039eae6e94da1620b35581 to ti/+AnBHiz4yb9YM45/RDB or vice-versa? I think I am stuck. For reference, the standard linux md5sum gives this: [EMAIL PROTECTED] lib]# /usr/bin/md5sum /path/to/datfix/2000/2101.1.dat b622fe0270478b3e326cd60ce196d10d I have checked all this with some other files, and the behaviour is the same. I guess 1.36.3, which is pretty old is probably missing some code that is in md5.c in the current SVN. I'll send a second email with the current md5.c attached -- off list. It *should* compile and run fine in your 1.36.3 code, just save the original for comparison if you run into problems. Thanks for that Kern. I had to hack it slightly, since there are now extra arguments to bin_to_base64(). Now I get results like this: [EMAIL PROTECTED] lib]# ./md5sum /path/to/datfix/2000/2101.1.dat c4e8a6c211039eae6e94da1620b35581 x++mwhEDn65ul9oWI7NVgB /path/to/datfix/2000/2101.1.dat So I have the following, which don't match: 1) System MD5sum from file on disk 2) Bacula md5sum, from file on disk 3) Base64 encoding of (2) 4) Base64 hash stored in the catalog 1 and 2 don't match, which is confusing me. 3 and 4 don't match either. I'm rapidly concluding that (4) is just garbage, due to whatever nonsense our in-house scripts introduced into the system many months ago. Jon -- Jon Wilson [EMAIL PROTECTED] Systems Administration Manager PO Box H58, Australia Square, Sydney NSW 1215 Level 2, 9 Castlereagh Street, Sydney Office Tel:+61 9231 5888 Direct Tel:+61 2 9236 9118 Fax: +61 2 9231 5988 www.sirca.org.au DISCLAIMER: The contents of this email, inclusive of attachments, may be legally privileged and confidential. Any unauthorised use of the contents is expressly prohibited. If you have received this email message in error or are not the intended recipient, you should destroy the message along with any attachment(s). Unintended recipients of this email are prohibited from retaining, disclosing, distributing or using any information herein. This email is also subject to copyright. No part of it should be reproduced, adapted or transmitted without the written consent of the copyright owner. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Need advice on adapting mtx-changer for Exabyte Magnum 224
I was able to get the mtx-changer script working correctly. I used the solaris-mtx-changer from the examples as a starting point. Then to work with the Magnum 224 and Solaris make a few changes -added a correct PATH statement for my system -Solaris doesn't have seq command, replaced seq in the wait_for_drive function with a perl statement -there are some commands that won't work (unload), unless the tape device is specified. I set this to a default, but still allow it to be set on command line too -changed the awk/sed statements for the list command to be compatible with a slot that is of type IMPORT/EXPORT Everything seems cool now. I do have one very important question: In the statement for the unload command, there is the following: mt -f $device rewoffl If I am using tapes to perform incremental backups, should I be rewinding the tape in the drive before unloading it to load another tape. If its loaded again, will it being rewound previously cause bacula to overwrite files on the tape? I don't believe so, but hopefully someone can answer that for sure. Thanks Shon On 6/28/07, John Drescher [EMAIL PROTECTED] wrote: I have a Magnum224 with 24 slots and 2 LTO2 drives but I am using linux and not Solaris. For that I did not have to change anything in the default mtx scripts as it works correctly. I believe the numbering is one slot off though but it does not matter. When I do a manual unload I verify the slot from the screen on the changer itself. I will try to answer the questions I can. One thing I would like to mention is that I am using bacula 2.X now. I mention that because I had a serious problems with 1.38.X and my changer. So everything is back to normal, but I still have a few questions How can I get mtx-changer to display the status of all my slots correctly? Is the format that mtx-changer is displaying the status of a loaded drive correct? Does it matter to bacula that I had to use the full command to unload the drive? Will Bacula know what storage element is in the drive and to move it back to the correct slot? For me bacula always puts the tape back into the stot it took it from. I have never tried manuall loading a tape there and seeing what would happen for an unload. How do I change tapes and update inventory? Use the release command in bacula to release any tape from the drive. Then change the tapes manually on the changer. I recommend doing that by unloading the magazines. Then after you are done with the manual stuff. type update slots in a bacula console. I was considering keeping a cleaning tape in slot 12, will this interfere with Bacula at all? Can I schedule cleaning operations with Bacula? This is fine. I have a CLN_ barcode on my cleaning tape and in my pools I have Cleaning Prefix = CLN so that bacula recognizes that as a cleaning tape. Any responses, or wilingness to share some mtx-changer magic is very appreciated. Also if you've used any replacement for mtx or mtx-changer and want to share the experience that would be great! John - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] The thing with restoring Moved and Deleted files
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Hoogendyk Sent: Thursday, 28 June 2007 8:56 AM To: Martin Simmons Cc: bacula-users@lists.sourceforge.net Subject: Re: [Bacula-users] The thing with restoring Moved and Deleted files [...snip...] Any other open source integrated backup systems? Dirvish - www.dirvish.org daily incremental snapshots via rsync YMMV Brenden - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users