[Bacula-users] SOLVED: Fatal error: Version error for database "bacula". Wanted 16, got 15
Sorry for the fuzz, thnx Martin that was "the right answer" ;-) that script is okay (one only has to set the dbname in the script) after executing it the director starts as expected. thnx everybody for the various hints best Bernhard On 2017-11-08 14:17, Martin Simmons wrote: You could try: dpkg -S update_mysql_tables I think it should be here: /usr/share/bacula-director/update_mysql_tables __Martin Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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
Re: [Bacula-users] Fatal error: Version error for database "bacula". Wanted 16, got 15
UPDATE Version SET VersionId=1019; why is that so when bacula-director want version 16 instead of 15 as said in the logfile "Fatal error: Version error for database "bacula". Wanted 16, got 15" On 2017-11-08 13:44, Kern Sibbald wrote: Hello, In source form the script may not be too useful because the paths are different for each packager. I recommend that you look at your binary files as they should have included the script. You can also do: find / -name "update_bacula_tables" if there are multiple copies, you will need to look at either update_postgresql_tables or update_mysql_tables (depending on what database you are using) and make sure it has: UPDATE Version SET VersionId=1019; as the last UPDATE Version command in the file. So, in your upgrade the version will go from 15 up to 1019 in several updates. Best regards, Kern On 11/08/2017 01:23 PM, bernhard.glomm wrote: ?? you mean the script might be in the source packages but not in the binary packages ?? bizarre but I will have a look On 2017-11-08 13:03, Olivier Delestre wrote: For me with bacula 7.4.7 /usr/local/src/bacula/bacula/src/cats/update_bacula_tables et grant_bacula_privileges ( with user postgres ) bacula=# select * from version; versionid --- 15 And 16 for version 9 (?) @page { margin: 2cm } p { margin-bottom: 0.25cm; line-height: 120% } pre.cjk { font-family: "NSimSun", monospace } a:link { so-language: zxx } Le 08/11/2017 à 11:58, bernhard.glomm a écrit : hi all after a regular apt-get update && apt-get upgrade on a "trusty" ubuntu system the upgrade of package bacula-director FAILED with the following errors in bacula_daemon.log: 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 15 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Could not open Catalog "", database "bacula". 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 15 08-Nov 10:27 bacula-dir ERROR TERMINATION Please correct configuration file: /etc/bacula/bacula-dir.conf I can't find any update_mysql_tables script or the like, has anybody successfully upgraded bacula-director to version: [/0]:/tmp # dpkg -l | egrep bacula-director iF bacula-director 9.0.4+dfsg-2+hawk~trusty+1 amd64 network backup service - Director daemon iU bacula-director-common 9.0.4+dfsg-2+hawk~trusty+1 amd64 transitional package for bacula-director ii bacula-director-mysql 9.0.4+dfsg-2+hawk~trusty+1 amd64 network backup service - MySQL storage for Director Any hint how to proceed from here is VERY welcome. best regards Bernhard Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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 Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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 Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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
Re: [Bacula-users] Fatal error: Version error for database "bacula". Wanted 16, got 15
?? you mean the script might be in the source packages but not in the binary packages ?? bizarre but I will have a look On 2017-11-08 13:03, Olivier Delestre wrote: For me with bacula 7.4.7 /usr/local/src/bacula/bacula/src/cats/update_bacula_tables et grant_bacula_privileges ( with user postgres ) bacula=# select * from version; versionid --- 15 And 16 for version 9 (?) @page { margin: 2cm } p { margin-bottom: 0.25cm; line-height: 120% } pre.cjk { font-family: "NSimSun", monospace } a:link { so-language: zxx } Le 08/11/2017 à 11:58, bernhard.glomm a écrit : hi all after a regular apt-get update && apt-get upgrade on a "trusty" ubuntu system the upgrade of package bacula-director FAILED with the following errors in bacula_daemon.log: 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 15 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Could not open Catalog "", database "bacula". 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 15 08-Nov 10:27 bacula-dir ERROR TERMINATION Please correct configuration file: /etc/bacula/bacula-dir.conf I can't find any update_mysql_tables script or the like, has anybody successfully upgraded bacula-director to version: [/0]:/tmp # dpkg -l | egrep bacula-director iF bacula-director 9.0.4+dfsg-2+hawk~trusty+1 amd64network backup service - Director daemon iU bacula-director-common9.0.4+dfsg-2+hawk~trusty+1 amd64transitional package for bacula-director ii bacula-director-mysql 9.0.4+dfsg-2+hawk~trusty+1 amd64network backup service - MySQL storage for Director Any hint how to proceed from here is VERY welcome. best regards Bernhard Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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 Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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
[Bacula-users] Fatal error: Version error for database "bacula". Wanted 16, got 15
hi all after a regular apt-get update && apt-get upgrade on a "trusty" ubuntu system the upgrade of package bacula-director FAILED with the following errors in bacula_daemon.log: 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 15 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Could not open Catalog "", database "bacula". 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 15 08-Nov 10:27 bacula-dir ERROR TERMINATION Please correct configuration file: /etc/bacula/bacula-dir.conf I can't find any update_mysql_tables script or the like, has anybody successfully upgraded bacula-director to version: [/0]:/tmp # dpkg -l | egrep bacula-director iF bacula-director 9.0.4+dfsg-2+hawk~trusty+1 amd64network backup service - Director daemon iU bacula-director-common9.0.4+dfsg-2+hawk~trusty+1 amd64transitional package for bacula-director ii bacula-director-mysql 9.0.4+dfsg-2+hawk~trusty+1 amd64network backup service - MySQL storage for Director Any hint how to proceed from here is VERY welcome. best regards Bernhard Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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