[Bacula-users] Bacula version error and Fatal error: Could not open Catalog
Hello All, I have set up bacula in the past, but am now installing the latest version 5.2.1.3 onto Ubuntu 12.04 with postgresql and am running into all sorts of issues! I setup bacula using the configuration files that I use on another server (lets call this server B), and have edited the files in the appropriate places i.e. the location of logs, address, and the catlog information. I then checked for errors in the files by running commands such as bacula-dir -t -c bacula-dir.conf . No issues, so started up bacula. I then did a dump of the bacula database from server B, and restored the bacula database on the server I just did the installation on. This worked fine, no issues. I then noticed the next day that the bacula daemon had stopped. So i restarted it, was fine, but then it stopped again. This kept happening. I looked at the log file which stated:- 14-May 16:03 bacula-dir JobId 0: Fatal error: Could not open Catalog MyCatalog, database bacula. 14-May 16:03 bacula-dir JobId 0: Fatal error: postgresql.c:248 Unable to connect to PostgreSQL server. Database=bacula User=bacula Possible causes: SQL server not running; password incorrect; max_connections exceeded. 14-May 16:03 bacula-dir ERROR TERMINATION But this error seemed to be occuring prior to my restore of the database. I have since been playing with the dir configuration file and the postgresql files but am not having any luck. Currently, the error I have is:- 17-May 16:28 bacula-dir JobId 0: Fatal error: Version error for database bacula. Wanted 14, got 11 17-May 16:28 bacula-dir JobId 0: Fatal error: Could not open Catalog MyCatalog, database bacula. 17-May 16:28 bacula-dir JobId 0: Fatal error: Version error for database bacula. Wanted 14, got 11 But I have upgraded using the command - sudo ./update_bacula_tables which runs after giving me this error:- /etc/bacula/update_postgresql_tables: 16: [: 14: unexpected operator I have played around with the configuration file and currently, the lines which may possibly be giving me trouble is:- # Generic catalog service Catalog { Name = MyCatalog # Uncomment the following line if you want the dbi driver #dbdriver = dbi:postgresql; dbaddress =127.0.0.1; dbport =5432 dbname = bacula; dbuser = bacula; dbpassword = PASSWORD FOR USER BACULA; } Altering those lines i.e. by inputting the address of my server would give me the following error:- 17-May 15:04 bacula-dir JobId 0: Fatal error: Could not open Catalog MyCatalog, database bacula. 17-May 15:04 bacula-dir JobId 0: Fatal error: postgresql.c:248 Unable to connect to PostgreSQL server. Database=bacula User=bacula Possible causes: SQL server not running; password incorrect; max_connections exceeded. 17-May 15:04 bacula-dir ERROR TERMINATION Also, another strange thing im noticing since doing the restore, is that the bacula database is the exact same as server b's even though no backups are in fact occuring on server A. HEL??? T. +-- |This was sent by tqzeli...@yahoo.co.uk via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacula script help - passing variable...
Hello all! :) I'm trying to write a bash script for bacula and need a bit of help! My first file contains a script that gets the volume name of a tape and then runs the bconsole program that has a list of commands in a second file inputted to it i.e. ./bconsole -c ./bconsole.conf baculaCommandList. How do I pass my tape name to that command list and how do I ref the tape name in that second file too??? Sorry - I am new to shell scripting! Thanks. +-- |This was sent by tqzeli...@yahoo.co.uk via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacula script help - passing variable...
Hi and thanks for your response... drescherjm how would you get it to do that?? I am a complete beginner to this type of scripting!!! At the moment here is an example of what my files look like:- my bacula.sh file:- #! /bin/bash Vol=$(echo st storage=DEV6-Changer | bconsole | grep Volume: | cut -d':' -f2) echo $Vol /etc/bacula/bconsole -c bin/bconsole.conf /bin/baculacommands.sh exit 0 For my baculacommands.sh file i have something like:- mount purge 3 8 I just want to add the $Vol name that I have found from my first file to the bottom of my second file - but am clueless as to how to pass the variable to this file... Hope this is clearer... Thanks for any help I recieve in advance! :) +-- |This was sent by tqzeli...@yahoo.co.uk via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] How to get label of tape currently in tape drive
Hello all How do you get the tape name of the tape currently in the tape drive? Many thanks in advance for any responses! +-- |This was sent by tqzeli...@yahoo.co.uk via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] How to get label of tape currently in tape drive
Hi John Thanks for the response. st stor im assuming gives the same output as stauts storgae? Is there a way to simply just get the name of the tape - as I would like to write a script that will purge the current tape in the tape drive so that bacula uses this tape to do the nightly backup. Thanks t. +-- |This was sent by tqzeli...@yahoo.co.uk via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] How to get label of tape currently in tape drive
Hi John That works PERFECTLY! Thanks! :) Phil thanks for your response too! I have to resort to do this as I need to ensure that a backup occurs even if the wrong tape is inserted or if a tape is accidently not changed for whatever reason...I cant really see another workaround and have been on the forum see http://www.backupcentral.com/phpBB2/two-way-mirrors-of-external-mailing-lists-3/bacula-25/bacula-backup-problem-105183/ to see if there was another solution. Thanks again for you responses! :) +-- |This was sent by tqzeli...@yahoo.co.uk via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacula backup problem!
Hello all I have an ubuntu (8.04.3) server where I use bacula to make backups of the files stored on the server. Ive been trying to find a solution (with no luck) trying to succesfully implement the following:- A Backup tape for each day of the week besides Thurs which is resused on a weekly basis. For the thursday tapes we have a backup tape corresponding to the week number that the thursday falls so for the first thursday of the month it would be ThursOne For example. These tapes are resued on a monthly basis. We then have a monthly tape that is used on the last thursday of the month. These tapes will be resused on a yearly basis. Another requirement is just in case a tape is accidently not changed a backup should still occur regardless of what tape is in the drive (so if its tuesday and mondays tape is still in the tape drive it should rewrite the tape). I did have this successfully set up where the tape was appeneded after each use rather than being recycled after the nightly backup. But then after a few weeks I would have to manually purge tapes when they became full (which isnt ideal - as Im not always in the office so in my absence it may be that a backup may not take place), so have been playing around and have now got the tapes to be marked as used after a max of 2 jobs (so the backup of the files and the catalog of the night). I also added this line 'Recycle Current Volume = yes' so that it would hopefully recycle the volume in the drive. However what I am finding is that the tape that should be recycled is not, but in yesterday case the Mondays tape was recycled rather than the Tuesday although Mondays was the last written so Im not even sure why it choose to recycle this tape... Any ideas as to how I would implement the above with the requirements... Another idea is for a script to run before the job that would purge the current tape and recycle it so that the backup occurs on this tape. Any idea how to write such a script - as I would have no clue!!! Thanks in advance for any help!!! +-- |This was sent by tqzeli...@yahoo.co.uk via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacula backups and restores
Hmm...I may be getting confused with another response I received from another forum... I have my keys stored off site in a secured location, as well as the bacula config files. So in the event of a disaster, if I reinstall bacula and my database management system, restore my keys (from the CD and place them where they were before), use bextract/bscan to dump the latest copy of the bacula catalog/recreate catalog saved on the tape, and then use bacula to restore the contents of the tape should this work? i will test this out, but just want a plan and to confirm that this is possible before doing this. Like I said I am not a system admins (or have any exp in this area as is prob obvious from my posts! :) ) Thanks for all your responses...and patience! :) +-- |This was sent by tqzeli...@yahoo.co.uk via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacula backups and restores
Hmm...I dont like the fact that if my server and nas devices are all damaged in a fire (for example) then my off site backup copy (the encrypted tape) is useless to me! I dont see the point of having the offsite copy, if what is saved on the tape cant be restored! I'm no system admin, or have any experience in other backup software so dont know if this is the case with them as well or if this is just a down point for using bacula. My boss would like the tapes encrypted as there may be confidential data on the tapes so encrypting the tapes is a requirement for him. Is there any way that I could keep the bacula catalog unencrypted on the same tape? Is this possible to specify in the config files? Or is this being illogical as then anyone can restore the data if they have knowledge on bacula even if the other contents on the tape is encrypted...or is just sending a dump of the bacula catalog via email or to an off site location the only option if we encrypt the tape Many thanks in advance t. +-- |This was sent by tqzeli...@yahoo.co.uk via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacula backups and restores
Hello all Lets say in the event that disaster strikes and all data on my server is lost for whatever reason. I have encrypted backups of the data on the server stored on tapes (on and off site) and NAS. After reinstalling my database management system, and then firing up bacula using copies I have of the director, client and storage daemon files how can I then read the catalog from the encrypted tape. Is there any way I can test this without overwriting the bacula database. Also is there a way to read files (the director, storage and daemon) off the encrypted storage and then restoring them using bacula command line tools or non bacula command line tools .or am I not making any sense?! Second thing is that I am noticing that the size of the backups on my different storage devices are different. So for example the first backup occurs on the tape and the size of the backup is 14.09gb, then on my second storage device it will be 14.12gb and my third one is 14.16gb. They are all full backups ??? Any idea why there may be different sizes Thanks for any help in advance!!! +-- |This was sent by tqzeli...@yahoo.co.uk via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users