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

Discussion:

Thing

2017-07-19 22:11:32 UTC

I have an error, unable to find how to fix this via google however.

=======
***@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.
***@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'.
***@vuwunicobculat1:~#
========

I can connect to the mysql database fine.

Wanderlei Huttel

2017-07-19 22:28:30 UTC

Permalink

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*
http://www.huttel.com.br

Post by Thing
I have an error, unable to find how to fix this via google however.
=======
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.
--
-- The start-up result is done.
Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
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
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.
bacula-dir: dird.c:969-0 Could not open Catalog "MyCatalog", data
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
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.
bacula-director.service: Unit entered failed state.
bacula-director.service: Failed with result 'exit-code'.
========
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
https://lists.sourceforge.net/lists/listinfo/bacula-users

Thing

2017-07-19 22:43:17 UTC

Permalink

Yes I expect bacual was also upgraded, what I get is,

***@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
***@vuwunicobculat1:~# update_mysql_tables
bash: update_mysql_tables: command not found
***@vuwunicobculat1:~# find /etc/ -name update_mysql_tables
***@vuwunicobculat1:~# find /usr/ -name update_mysql_tables
/usr/share/bacula-director/update_mysql_tables
***@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.
***@vuwunicobculat1:~#

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

Post by Wanderlei Huttel
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*
http://www.huttel.com.br

Post by Thing
I have an error, unable to find how to fix this via google however.
=======
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.
--
-- The start-up result is done.
Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
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
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.
bacula-dir: dird.c:969-0 Could not open Catalog "MyCatalog", data
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
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.
bacula-director.service: Unit entered failed state.
bacula-director.service: Failed with result 'exit-code'.
========
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
https://lists.sourceforge.net/lists/listinfo/bacula-users

Thing

2017-07-19 22:56:17 UTC

Permalink

Got a wee bit further,

======
***@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.
***@vuwunicobculat1:~# vi /etc/bacula/bacula-dir.conf
***@vuwunicobculat1:~# vi /etc/bacula/bacula-dir.conf
***@vuwunicobculat1:~# dpkg -l bacula
dpkg-query: no packages found matching bacula
***@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

Post by Thing
Yes I expect bacual was also upgraded, what I get is,
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
bash: update_mysql_tables: command not found
/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.
password: NO)
Unable to detect database version, you can specify connection information
on the command line.
Error. Cannot upgrade this database.
How am I meant to run this? google isnt being much help.

Post by Thing
I have an error, unable to find how to fix this via google however.
=======
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.
--
-- The start-up result is done.
Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
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
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.
bacula-dir: dird.c:969-0 Could not open Catalog "MyCatalog", data
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
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.
bacula-director.service: Unit entered failed state.
bacula-director.service: Failed with result 'exit-code'.
========
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
https://lists.sourceforge.net/lists/listinfo/bacula-users

Wanderlei Huttel

2017-07-19 22:58:24 UTC

Permalink

Hello

You don't have access in MySQL

It looks you have configured a password in MySQL and in Catalog the user is
root and password is empty.

To check if you can access MySQL try this below:

mysql -u root (if you do not have mysql root password)

mysql -u root -p (will ask for a password)

If one of the commands above runs fine, just run the following commands
below:
grant all on *.* to 'root'@'localhost';
create user bacula;
grant all on *.* to 'bacula'@'localhost' identified by 'bacula' with grant
option;
flush privileges;
quit
/etc/init.d/mysql restart

Change Catalog and modify the user and password.

Best Regards

*Wanderlei HÃŒttel*
http://www.huttel.com.br

Post by Thing
I have an error, unable to find how to fix this via google however.
=======
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.
--
-- The start-up result is done.
Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
Allocating size to GtkScrollbar 0x5609b9d022a0 without calli
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
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.
bacula-dir: dird.c:969-0 Could not open Catalog "MyCatalog", data
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
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.
bacula-director.service: Unit entered failed state.
bacula-director.service: Failed with result 'exit-code'.
========
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
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
https://lists.sourceforge.net/lists/listinfo/bacula-users