[Bacula-users] SOLVED: Fatal error: Version error for database "bacula". Wanted 16, got 15

2017-11-08 Thread bernhard.glomm

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

2017-11-08 Thread bernhard.glomm

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

2017-11-08 Thread bernhard.glomm
?? 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

2017-11-08 Thread bernhard.glomm

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