Bacula upgrade while updating ubuntu to 10.04

-
When you update your ubuntu to 10.04, the upgrade process forgets to update the bacula database which ends with this in bacula logs : 

02-May 17:39 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 12, got 10
02-May 17:39 bacula-dir JobId 0: Fatal error: Could not open Catalog "MyCatalog", database "bacula".
02-May 17:39 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 12, got 10
02-May 17:39 bacula-dir ERROR TERMINATION
Please correct configuration file: /etc/bacula/bacula-dir.conf

to correct this you need to run manuall two SQL scripts to upgrade the database (extracted from sources of bacula).


First you need to edit ~/.my.cnf so that 'mysql' command use this file to connect to the database : 

[client]
user=root
password=YOU_MYSQL_ROOT_PWD_HERE
protocol=tcp

or change the scripts so that

this line :

if $bindir/mysql $* -f <<END-OF-DATA

is changed to this line :

if $bindir/mysql -uroot -p $* -f <<END-OF-DATA



here is this scripts you need to upgrade the database :

upgrade-v10-to-v11.sh

upgrade-v11-to-v12.sh

Download theses files on your server, review what changes it brings (you should always check these kind of things found on internet ;)
edit these files to update the bacula database name

db_name=bacula

and run it : 

root@home:~/upgradeBacula# ./upgrade-v10-to-v11.sh

This script will update a Bacula MySQL database from version 10 to 11
 which is needed to convert from Bacula version 2.0.x to 3.0.x or higher

Update of Bacula MySQL tables succeeded.
root@home:~/upgradeBacula# ./upgrade-v11-to-v12.sh

This script will update a Bacula MySQL database from version 11 to 12
 which is needed to convert from Bacula Enterprise 2.6 to 4.0 or
 Standard version 3.0 to 5.0

Update of Bacula MySQL tables succeeded.

Next, try to start bacula :

sudo service bacula-director start
sudo service bacula-fd       start
sudo service bacula-sd       start

you should now be able to connect with bconsole and run a job !


This post was written based on information found on this bug report : https://bugs.launchpad.net/ubuntu/+source/bacula/+bug/579924

Comments

Unknown said…
Thanks - this blog post saved me a lot of trouble.
9 July 2010 at 09:46
Unknown said…
Awesome! Right on the money, I had the same issue when I upgrade from karmic to lucid. Saved me loads of trouble. Thanks for the detailed instructions and the files.
16 May 2011 at 05:22
Stryder said…
Kudos to you for great content!
21 March 2012 at 04:49
Post a Comment

Popular posts from this blog

Upgrade Slimframework v3 to v4, how I did it

-
Here is an article that details my path to upgrade to Slimframework v3 to v4. I'm developing on my freetime an application that manage the fundraising of the French Red Cross, and I'm updating a lot of frameworks to their last version (AngularJS to Angular 8/9 is my big next move). You can find the project sources here : https://github.com/dev-mansonthomas/RedCrossQuest There’s quite a lot of breaking changes involved, feature removed in profit to external frameworks, the upgrade documentation is quite minimal, but you must read it to understand what's changing : http://www.slimframework.com/docs/v4/start/upgrade.html This article is not well redacted, it’s just a log of what I did to achieve the upgrade, but I feel it may help some, so here we are ;) What I've read to perform the upgrade I’ve read theses article to help the transition to the 4.x  https://akrabat.com/a-first-look-at-slim-4/ https://dzone.com/articles/a-first-look-at-slim-4 ...
Read more

Reset Bacula database and files

-
Image
Today I need to purge my bacula for several reasons. Here is how I did. First backup the database and files used in your previous setup, one never knows you might actually need it after the purge... /usr/bin/mysqldump -aecqQ bacula > bacula_before_purge.sql and copy the volumes and bsr files. Stop bacula : service bacula-director stop service bacula-fd stop service bacula-sd stop then : mysql -u root -p drop database bacula; create database bacula; quit next we need to recreate bacula tables. There's a bacula script to do that, but the file needs to be changed to set the correct database name. cp /usr/share/bacula-director/make_mysql_tables ~/ vi ~/make_mysql_tables change XXX_DBNAME_XXX by your bacula database (let's say 'bacula') save and exit. then run as root the script ~/make_mysql_tables it should have recreated the tables : mysql -u root -p use bacula; show tables; +------------------+ | Tables_in_bacula | +-----------...
Read more

Limit the upload bandwidth of your apache webserver with mod_bw

-
Image
I've a server at home on a ADSL connection which has 100kBytes/s of upload and 1.2MBytes/s of download as bandwidth. If someone download at full speed some large file on my web server, my internet connection become unusable. To avoid this, I start to ask my friends to use a download manager to limit their download speed... but it's somewhat far too tricky for a lot of them... So I use mod_bw developed by Ivan Barrera http://www.ivn.cl/apache/ (sourceforge : http://bwmod.sourceforge.net/ ). Here is a quick way to limit the bandwidth used by Apache : Install & enable (on Ubuntu): sudo apt-get install libapache2-mod-bw sudo a2enmod bw Configure (your apache virtualhost conf file like /etc/apache2/sites-available/default) : <virtualhost *:80> #... other config stuf for the virtual host BandWidthModule On ForceBandWidthModule On BandWidth 192.168.0.0/24 0 BandWidth all 80000 </virtualhost> Explaination : line 1 : Activate the mod for the virtualhost. line 2 : Set a...
Read more