[Bacula-users] SQL errors after upgrading to 2.2.5
Hello! I use Bacula on FreeBSD-6.1. I upgraded dir and sd from 2.2.4 to 2.2.5 on 12th of oct. Now some of the jobs contain SQL errors: 15-Oct 23:06 backup-dir JobId 12440: Warning: SQL failed, but ignored. ERR=Query failed: SELECT MAX(MediaId) FROM Media,POOL WHERE Pool.PoolId=179: ERR=Table 'bacula.POOL' doesn't exist All of the errors are the same. Jobs still complete OK. -- Silver - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Re : Error c:317 Volume data error - Restore Windows NT
Seems OK with Bacula V. 2.5.5. From: marwin bobinson [EMAIL PROTECTED] Subject: [Bacula-users] Error c:317 Volume data error - Restore Windows NT Hello, I'm using Bacula 2.0.3 (Dir / SD / FD ) run on a Windows NT 4.0 Sp6 Fr Server and the volumes (more than 50 Go) are on an ethernet disk. When I try to restore files from the Full Backup i have some message like that : 05-Oct 09:59 444MW001-sd: Ready to read from volume FQZ-0001 on device FileStorage (S:\tmp). 05-Oct 09:59 444MW001-sd: RESTORE_FIRSTQZ.2007-10-05_09 .59.08 Error: ../../stored/block.c:317 Volume data error at 0:64511! Block checksum mismatch in block=1 len=64512: calc=81138e04 blk=67d0c8d4 05-Oct 09:59 MW001-dir: RESTORE_FIRSTQZ.2007-10-05_09.59.08 Error: Bacula 2.0.3 (06Mar07): 05-Oct-2007 09:59:13 JobId: 397 Job:RESTORE_FIRSTQZ.2007-10-05_09.59.08 Client: 444MW001-fd Start time: 05-Oct-2007 09:59:10 End time: 05-Oct-2007 09:59:13 Files Expected: 1 Files Restored: 0 Bytes Restored: 0 Rate: 0.0 KB/s FD Errors: 0 FD termination status: OK SD termination status: Error Termination:*** Restore Error *** My Bacula-sd.conf : Device { Name = BIGDISK Device Type = File Media Type = File Archive Device = S:\\Sauvegardes LabelMedia = yes # lets Bacula label unlabeled media Random Access = Yes AutomaticMount = yes # when device opened, read it RemovableMedia = no AlwaysOpen = no Block Positioning = no Minimum Block Size = 512 Maximum Block Size = 512 # Volume Poll Interval = 600 } Regards, Bob - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Automatic Restore Jobs?
On 16 Oct 2007 at 12:59, Janco van der Merwe wrote: OK I read the thread and it gave me basically what I thought I had to do but I'm not to keen putting the Restore Job in a RunAfterJob script I was hoping that there was an alternative way of doing this. The rsync might work but I'm not to sure how it'll work if an entire system is backed up and restored on another except if the hardware was the same. My whole idea is to try to introduce high availability so if one server goes down we can start the other, most probably a VM, and carry on as if nothing happened until we get the original server back up and running. I know that there are Server Mirroring Software out there but they cost a lot and in a company with a tight budgetwell you know the rest. rsync? Between the two servers. But still use Bacula for backups. rsync is not a backup. It is a copy. -- Dan Langille - http://www.langille.org/ Available for hire: http://www.freebsddiary.org/dan_langille.php - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Automatic Restore Jobs?
On Tue, 2007-10-16 at 08:34 -0400, Dan Langille wrote: On 16 Oct 2007 at 12:59, Janco van der Merwe wrote: OK I read the thread and it gave me basically what I thought I had to do but I'm not to keen putting the Restore Job in a RunAfterJob script I was hoping that there was an alternative way of doing this. The rsync might work but I'm not to sure how it'll work if an entire system is backed up and restored on another except if the hardware was the same. My whole idea is to try to introduce high availability so if one server goes down we can start the other, most probably a VM, and carry on as if nothing happened until we get the original server back up and running. I know that there are Server Mirroring Software out there but they cost a lot and in a company with a tight budgetwell you know the rest. rsync? Between the two servers. But still use Bacula for backups. rsync is not a backup. It is a copy. The rsync was only an idea, maybe an ambitious idea, but an idea never the less. I went on the Search for Open Source HA software and came across this: http://www.drbd.org/. Hopefully this will do the Job. Backups aren't my main concern because Bacula has that covered, what I was looking for was something that had HA capabilities and I hoped Bacula had something like that but have a look at the URLquite interesting. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Verify-Job with a missing file ends in a loop ....
.. if the message-resource contains: catalog = all like this one i'm using: Messages { Name = VerifyJobs mailcommand = /sbin/bsmtp -h localhost -f \\(Bacula\) %r\ -s \%t %e of %c %l\ %r mail = [EMAIL PROTECTED] = all catalog = all } what i have done: after an InitCatalog I have touched a file /etc/einetestdatei. the next verify-job reports an error New file ... so i did the InitCatalog again. after that i have removed the new file and started a verify-job. the normal CatalogVerify-Jobs take about 2 minutes, so i have cancled this job after 6 minutes. then i got the email about the job: 16-Okt 14:47 backup-dir JobId 2332: Verifying against JobId=2331 Job=client.ic3s.de.2007-10-16_14.45.12 16-Okt 14:47 backup-dir JobId 2332: Start Verify JobId=2332 Level=Catalog Job=client.ic3s.de.2007-10-16_14.46.03 16-Okt 14:48 backup-dir JobId 2332: The following files are in the Catalog but not on disk: 16-Okt 14:48 backup-dir JobId 2332: /etc/einetestdatei 16-Okt 14:48 backup-dir JobId 2332: /etc/einetestdatei 16-Okt 14:48 backup-dir JobId 2332: /etc/einetestdatei 16-Okt 14:48 backup-dir JobId 2332: /etc/einetestdatei ... 16-Okt 14:49 backup-dir JobId 2332: /etc/einetestdatei 16-Okt 14:49 backup-dir JobId 2332: /etc/einetestdatei 16-Okt 14:49 backup-dir JobId 2332: /etc/einetestdatei 16-Okt 14:49 backup-dir JobId 2332: /etc/einetestdatei 16-Okt 14:49 backup-dir JobId 2332: /etc/einetestdatei 16-Okt 14:49 backup-dir JobId 2332: /etc/einetestdatei 16-Okt 14:49 backup-dir JobId 2332: /etc/einetestdatei 16-Okt 14:49 backup-dir JobId 2332: /etc/einetestdatei ... 16-Okt 14:51 backup-dir JobId 2332: /etc/einetestdatei 16-Okt 14:51 backup-dir JobId 2332: /etc/einetestdatei 16-Okt 14:51 backup-dir JobId 2332: /etc/einetestdatei 16-Okt 14:51 backup-dir JobId 2332: /etc/einetestdatei 16-Okt 14:51 backup-dir JobId 2332: Bacula backup-dir 2.2.5 (09Oct07): 16-Okt-2007 14:51:08 Build: x86_64-unknown-linux-gnu debian 4.0 JobId: 2332 Job:client.ic3s.de.2007-10-16_14.46.03 FileSet:IX-Server-Verify Verify Level: Catalog Client: client.ic3s.de Verify JobId: 2331 Verify Job: Start time: 16-Okt-2007 14:47:01 End time: 16-Okt-2007 14:51:08 Files Examined: 13,008 Non-fatal FD errors:0 FD termination status: OK Termination:Verify Canceled 16-Okt 14:51 backup-dir JobId 2332: Begin pruning Jobs. 16-Okt 14:51 backup-dir JobId 2332: No Jobs found to prune. 16-Okt 14:51 backup-dir JobId 2332: Begin pruning Files. 16-Okt 14:51 backup-dir JobId 2332: No Files found to prune. 16-Okt 14:51 backup-dir JobId 2332: End auto prune. this mail contains 19873 lines with backup-dir JobId 2332: /etc/einetestdatei also the log-table in the catalog-database contains this number of rows about that file. the fd debug output shows no problems, the job finished successful, the director debug output shows : ... backup-dir: getmsg.c:110-0 bget_dirmsg -1: backup-dir: postgresql.c:314-0 db_sql_query started backup-dir: postgresql.c:474-0 my_postgresql_query started backup-dir: postgresql.c:485-0 my_postgresql_query starts with 'SELECT Path.Path,Filename.Name FROM File,Path,Filename WHERE File.JobId=2331 AND File.MarkId!=2332 AND File.PathId=Path.PathId AND File.FilenameId=Filename.FilenameId' backup-dir: postgresql.c:501-0 we have a result backup-dir: postgresql.c:505-0 we have 2 fields backup-dir: postgresql.c:508-0 we have 1 rows backup-dir: postgresql.c:516-0 my_postgresql_query finishing backup-dir: postgresql.c:323-0 db_sql_query succeeded. checking handler backup-dir: postgresql.c:326-0 db_sql_query invoking handler backup-dir: postgresql.c:330-0 db_sql_query sql_store_result suceeded backup-dir: postgresql.c:355-0 my_postgresql_fetch_row start backup-dir: postgresql.c:359-0 we have need space of 16 bytes backup-dir: postgresql.c:375-0 my_postgresql_fetch_row row number '0' is acceptable (0..1) backup-dir: postgresql.c:379-0 my_postgresql_fetch_row field '0' has value '/etc/' backup-dir: postgresql.c:379-0 my_postgresql_fetch_row field '1' has value 'einetestdatei' backup-dir: postgresql.c:389-0 my_postgresql_fetch_row finishes returning 6cdfe8 backup-dir: postgresql.c:333-0 db_sql_query sql_fetch_row worked backup-dir: message.c:1082-0 Enter Jmsg type=6 backup-dir: message.c:608-0 Enter dispatch_msg type=6 msg=backup-dir JobId 2332: The following files are in the Catalog but not on disk: backup-dir: message.c:733-0 MAIL for following msg: backup-dir JobId 2332: The following files are in the Catalog but not on disk: backup-dir: postgresql.c:314-0 db_sql_query started backup-dir: postgresql.c:474-0 my_postgresql_query started backup-dir:
[Bacula-users] Install HowTo for Ubuntu 6.06.1 LTS
I apologize in advance if I'm asking this question on the wrong space I recently wrestled w/ Bacula and Ubuntu 6.06.1 LTS for a few days before I got everything installed and running correctly. I have kept track of what needed to be done to achieve compile and installation happiness, and I'd like to post the mini HowTo somewhere. Where do such things live for the Bacula world? Many thanks! Nathan - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Verifying run of backups - script?
My Bacula installation is progressing well. I was wondering - I know that Bacula can send email messages at the termination of a job, and can do this based on status of the job. However, what about if a job (or Bacula as a whole) isn't running? Does anyone have a script that can check all jobs that should have been run to make sure they were? Essentially, what I'm looking for (or may be writing) is a little script (Python maybe?) that will find all jobs that should have been run this calendar day (I guess by parsing the director config file, since it's not stored in the database) and then check the Jobs table to be sure that they actually ran and ended successfully. If all is ok, it would send an email with a subject like Bacula on HOSTNAME - DATE - All OK or would alert if there are any errors. I'd run it as a cron job so that it's entirely independent of Bacula. The idea is 1) It's a real pain to sift through daemon e-mails for every job looking to make sure they terminated ok 2) I don't want error emails only, because I want to be able to ensure that everything I want running is, in fact, running. Any thoughts? -Jason - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Verifying run of backups - script?
To make sure a job ran, simply mash up a bash script (or php/python) and run an sql query for all jobs that started on a certain day. Then you could compile this in a single readable e-mail. Then add an admin job which runs the script at a specified time every day (preferably after your backups, so I'd give it a higher priority). Sincerely, -Michael Short - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Verifying run of backups - script?
Hi, 16.10.2007 20:32,, Ryan Novosielski wrote:: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 There is also a Nagios plugin for Bacula. And to monitor if your jobs actually ran, use a Run After Job script to send passive check results to Nagios. The passive check should use freshness checking with a threshold that triggers when your jobs are late. Arno Michael Short wrote: To make sure a job ran, simply mash up a bash script (or php/python) and run an sql query for all jobs that started on a certain day. Then you could compile this in a single readable e-mail. Then add an admin job which runs the script at a specified time every day (preferably after your backups, so I'd give it a higher priority). Sincerely, -Michael Short - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users - -- _ _ _ _ ___ _ _ _ |Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer II |$| |__| | | |__/ | \| _| |[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.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHFQOomb+gadEcsb4RAq8MAKCYl7KY7EkOoipiOE4QVCeO0famfACgieWC +MdwAz4u2HjW/5d9WpFmrUU= =WEoJ -END PGP SIGNATURE- - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ 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: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Configurating for Qualstar TLS
Hey folks, Anyone using a Qualstar unit with Bacula? First time user of this software and I'm working with a Qualstar TLS-412360. Any help/input would be appreciated. Mike - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Separate (PostgreSQL) database required for Verify Catalog?
Hi all, I'm trying to set up a Verify Job configuration and noticed in the Bacula User's Guide, which provides an example Catalog for running a Verify Job, the following: Catalog { Name = Bacula dbname = verify; user = bacula; password = } This example implies that a separate database named verify should be used as well as a user and password to connect to such a database. However, when I looked at (I'm using PostgreSQL 8.1.9) the scripts for making / creating / deleting, etc. (such as create_postgresql_database, make_catalog_backup, etc.) there are no scripts specific for managing a verify-specific database. Rather than requiring a separate Verify database, is it possible for the main Catalog Resource used by the Director to be shared for Verify Jobs? Thank you, -H - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Separate (PostgreSQL) database required for Verify Catalog?
Hi all, I'm trying to set up a Verify Job configuration and noticed in the Bacula User's Guide, which provides an example Catalog for running a Verify Job, the following: Catalog { Name = Bacula dbname = verify; user = bacula; password = } I believe this case is for a verify job for data that was never backed up. Bacula has the ability to tell you what files have changed between running an InitCatalog job and a Catalog job. In these jobs only the signatures (MD5 or SHA1) are stored or compared. I believe the example shows you could use a separate database for this. John - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Verifying run of backups - script?
Thanks to all for the advice. I hadn't even thought of the Nagios passive check option. That sounds best for me - I'll look into it tomorrow. I haven't done anything with passive checks and freshness checking, but luckily I picked up the Nagios book - something good for bedtime reading... As to the Nagios check plugin for bacula, I installed bacula from the bacula-mysql SuSE RPM. Unfortunately, the RPM didn't include the check plugin, and I don't have the source to compile the plugin. I guess it's time to look for a source RPM... Thanks, Jason Arno Lehmann wrote: Hi, 16.10.2007 20:32,, Ryan Novosielski wrote:: There is also a Nagios plugin for Bacula. And to monitor if your jobs actually ran, use a Run After Job script to send passive check results to Nagios. The passive check should use freshness checking with a threshold that triggers when your jobs are late. Arno Michael Short wrote: To make sure a job ran, simply mash up a bash script (or php/python) and run an sql query for all jobs that started on a certain day. Then you could compile this in a single readable e-mail. Then add an admin job which runs the script at a specified time every day (preferably after your backups, so I'd give it a higher priority). Sincerely, -Michael Short - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users