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
2017-07-19 19:43 GMT-03:00 Thing <thing.th...@gmail.com>:
> 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 <wanderleihut...@gmail.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*
>> http://www.huttel.com.br
>>
>> 2017-07-19 19:11 GMT-03:00 Thing <thing.th...@gmail.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
>>> Bacula-users@lists.sourceforge.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@lists.sourceforge.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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
