Bacula-users

Re: [Bacula-users] Upgrading Debian 8 to Debian 9 sees a broken bacula server install

2017-07-19 18:57:30
Subject: Re: [Bacula-users] Upgrading Debian 8 to Debian 9 sees a broken bacula server install
From: Thing <thing.thing AT gmail DOT com>
To: Thing <thing.thing AT gmail DOT com>
Date: Thu, 20 Jul 2017 10:56:17 +1200
Got a wee bit further,

======
root@vuwunicobculat1:~# /usr/share/bacula-director/update_mysql_tables -u root -p
 
This script will update a Bacula MySQL database from version 12-14 to 15
 
Depending on the current version of your catalog,
you may have to run this script multiple times.
 
Enter password:
ERROR 1049 (42000): Unknown database 'XXX_DBNAME_XXX'

Unable to detect database version, you can specify connection information
on the command line.
Error. Cannot upgrade this database.
root@vuwunicobculat1:~# vi /etc/bacula/bacula-dir.conf
root@vuwunicobculat1:~# vi /etc/bacula/bacula-dir.conf
root@vuwunicobculat1:~# dpkg -l bacula
dpkg-query: no packages found matching bacula
root@vuwunicobculat1:~# dpkg -l bacula-director
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name                         Version             Architecture        Description
+++-============================-===================-===================-==============================================================
iF  bacula-director              7.4.4+dfsg-6        amd64               network backup service - Director daemon
root@vuwunicobculat1:~#


On 20 July 2017 at 10:43, Thing <thing.thing AT gmail DOT com> wrote:
Yes I expect bacual was also upgraded,  what I get is,

root@vuwunicobculat1:~# bacula-dir -t
bacula-dir: dird.c:969-0 Could not open Catalog "MyCatalog", database "bacula".
bacula-dir: dird.c:974-0 Version error for database "bacula". Wanted 15, got 14
20-Jul 10:36 bacula-dir ERROR TERMINATION
Please correct configuration file: bacula-dir.conf
root@vuwunicobculat1:~# update_mysql_tables
bash: update_mysql_tables: command not found
root@vuwunicobculat1:~# find /etc/ -name update_mysql_tables
root@vuwunicobculat1:~# find /usr/ -name update_mysql_tables
/usr/share/bacula-director/update_mysql_tables
root@vuwunicobculat1:~# /usr/share/bacula-director/update_mysql_tables
 
This script will update a Bacula MySQL database from version 12-14 to 15
 
Depending on the current version of your catalog,
you may have to run this script multiple times.
 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Unable to detect database version, you can specify connection information
on the command line.
Error. Cannot upgrade this database.
root@vuwunicobculat1:~#

How am I meant to run this?  google isnt being much help.

On 20 July 2017 at 10:28, Wanderlei Huttel <wanderleihuttel AT gmail DOT com> wrote:
Hello 

First of all run the command "bacula -dir -t" and check what error is showing and try to fix it
Verify if the paramaters in Catalog resource in bacula-dir.conf are correct.

It looks Bacula was upgraded too, so, it's necessary to run the script "update_mysql_tables or update_postgresql_tables


Best Regards

Wanderlei Hüttel

2017-07-19 19:11 GMT-03:00 Thing <thing.thing AT gmail DOT com>:
I have an error, unable to find how to fix this via google however.

=======
root@vuwunicobculat1:~# systemctl restart  bacula-director
Job for bacula-director.service failed because the control process exited with error code.
See "systemctl status bacula-director.service" and "journalctl -xe" for details.
root@vuwunicobculat1:~# journalctl -xe
--
-- The start-up result is done.
Jul 20 10:02:39 vuwunicobculat1.ods.vuw.ac.nz gnome-terminal-[1493]: Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
Jul 20 10:02:39 vuwunicobculat1.ods.vuw.ac.nz gnome-terminal-[1493]: Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
Jul 20 10:02:39 vuwunicobculat1.ods.vuw.ac.nz gnome-terminal-[1493]: Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
Jul 20 10:02:39 vuwunicobculat1.ods.vuw.ac.nz gnome-terminal-[1493]: Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
Jul 20 10:02:39 vuwunicobculat1.ods.vuw.ac.nz gnome-terminal-[1493]: Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
Jul 20 10:02:39 vuwunicobculat1.ods.vuw.ac.nz gnome-terminal-[1493]: Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
Jul 20 10:02:49 vuwunicobculat1.ods.vuw.ac.nz dbus[544]: [system] Failed to activate service 'org.bluez': timed out
Jul 20 10:02:52 vuwunicobculat1.ods.vuw.ac.nz x-session-manager[1255]: WARNING: t+32.29767s: Could not launch application 'print-
Jul 20 10:03:27 vuwunicobculat1.ods.vuw.ac.nz systemd[1]: Starting Bacula Director Daemon service...
-- Subject: Unit bacula-director.service has begun start-up
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Unit bacula-director.service has begun starting up.
Jul 20 10:03:27 vuwunicobculat1.ods.vuw.ac.nz bacula-dir[1507]: bacula-dir: dird.c:969-0 Could not open Catalog "MyCatalog", data
Jul 20 10:03:27 vuwunicobculat1.ods.vuw.ac.nz bacula-dir[1507]: bacula-dir: dird.c:974-0 Version error for database "bacula". Wan
Jul 20 10:03:27 vuwunicobculat1.ods.vuw.ac.nz bacula-dir[1507]: 20-Jul 10:03 bacula-dir ERROR TERMINATION
Jul 20 10:03:27 vuwunicobculat1.ods.vuw.ac.nz bacula-dir[1507]: Please correct configuration file: /etc/bacula/bacula-dir.conf
Jul 20 10:03:27 vuwunicobculat1.ods.vuw.ac.nz systemd[1]: bacula-director.service: Control process exited, code=exited status=1
Jul 20 10:03:27 vuwunicobculat1.ods.vuw.ac.nz systemd[1]: Failed to start Bacula Director Daemon service.
-- Subject: Unit bacula-director.service has failed
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Unit bacula-director.service has failed.
--
-- The result is failed.
Jul 20 10:03:27 vuwunicobculat1.ods.vuw.ac.nz systemd[1]: bacula-director.service: Unit entered failed state.
Jul 20 10:03:27 vuwunicobculat1.ods.vuw.ac.nz systemd[1]: bacula-director.service: Failed with result 'exit-code'.
root@vuwunicobculat1:~#
========

I can connect to the mysql database fine.  

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
[email protected].net
https://lists.sourceforge.net/lists/listinfo/bacula-users




------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

ADSM.ORG Privacy and Data Security by https://kimlaw.us