Bacula-users

Re: [Bacula-users] HELP!! upgrade from 5.2 to 7.2.0

2015-10-28 10:51:17
Subject: Re: [Bacula-users] HELP!! upgrade from 5.2 to 7.2.0
From: Ana Emília M. Arruda <emiliaarruda AT gmail DOT com>
To: Carlo Filippetto <carlo.filippetto AT gmail DOT com>
Date: Wed, 28 Oct 2015 11:49:52 -0300
Hello Carlo,

Did you buid bacula from source? Where did you get the source code? I have the one downloaded from blog.bacula.org and there is no problem with the update_mysql_tables script.

Best regards,
Ana

On Wed, Oct 28, 2015 at 11:24 AM, Carlo Filippetto <carlo.filippetto AT gmail DOT com> wrote:
Thank you,
ther's another problem, the script don't create a table because ther's a ";" instead of ","...


CREATE TABLE Snapshot (
 SnapshotId      INTEGER UNSIGNED AUTO_INCREMENT,
 Name            TINYBLOB NOT NULL,
 JobId           INTEGER UNSIGNED DEFAULT 0,
 FileSetId INTEGER UNSIGNED DEFAULT 0;
 CreateTDate     BIGINT   NOT NULL,
 CreateDate      DATETIME NOT NULL,
 ClientId        INTEGER DEFAULT 0,
 Volume          TINYBLOB NOT NULL,
 Device          TINYBLOB NOT NULL,
 Type            TINYBLOB NOT NULL,
 Retention       INTEGER DEFAULT 0,
 Comment         BLOB,
 primary key (SnapshotId)
);

Correct it before run this script.

Bye






2015-10-28 15:18 GMT+01:00 Heitor Faria <heitor AT bacula.com DOT br>:
I upgrade my Bacula versione from 5.2.3 to 7.2.0
The DB versione of the 5.2.3 is the 14th, now in the directory "updatedb" of the new installation ther's no new update, but when I run bacula if stops with:

28-ott 14:50 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 15, got 14
Hello Carlo: run correspondent update database script you must. E.g.: /etc/bacula/scripts/update_mysql_tables (or postgresql).
Don't forget to adequate the command according to your db authentication options. 

Regards,
===========================================================================
Heitor Medrado de Faria - LPIC-III | ITIL-F |  Bacula Systems Certified Administrator II
Do you need Bacula training? http://bacula.us/video-classes/
I do Bacula training and deploy in any city of the world. More information: http://bacula.us/
===========================================================================



WHY??

what can i do?

Thank you



------------------------------------------------------------------------------

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users



------------------------------------------------------------------------------

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users


------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users