Bacula-users

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

2015-10-29 05:00:59
Subject: Re: [Bacula-users] HELP!! upgrade from 5.2 to 7.2.0
From: Carlo Filippetto <carlo.filippetto AT gmail DOT com>
To: Ana Emília M. Arruda <emiliaarruda AT gmail DOT com>
Date: Thu, 29 Oct 2015 09:56:27 +0100
Yes you are right,
😢
I found the correct version into the config files directory after compile.
Unfortunatelly I used the "update_mysql_tables" from the original directory 'updatedb' into the tar.gz and here the file have the error...
The original version of August has "update_mysql_tables" and the "*.in" ones, the last one have only "update_mysql_tables.in" both with the error inside

bye bye






2015-10-28 17:54 GMT+01:00 Ana Emília M. Arruda <emiliaarruda AT gmail DOT com>:
Hello Carlo,

Thank you a lot. Nice to hear from you too. Unfortunately or fortunately I found no problem with the source files in sourceforge. I´ve just downloaded the tar.gz, build it and found no problem in the script (update_mysql_tables).

Best regards,

Ana

On Wed, Oct 28, 2015 at 12:19 PM, Carlo Filippetto <carlo.filippetto AT gmail DOT com> wrote:
Hi Ana, pleasure to hear from you,

Yes I buld it from source, I downloaded the file from http://sourceforge.net/projects/bacula/files/


Thank you



2015-10-28 15:49 GMT+01:00 Ana Emília M. Arruda <emiliaarruda AT gmail DOT com>:
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
<Prev in Thread] Current Thread [Next in Thread>