-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Eitan,

I had a similar problem.

The database contains a table name Version containing just one column named 
VersionId. 
You need to update the VersionId from '10' to '11'.

The easiest way to do this is to copy the sqlite3.exe program from the "Program 
Files\bacula\bin" directory to the "Document and Settings\All User\Application 
Data\bacula\work" directory because the bacula.db database file is here.

Open a command prompt (DOS) windows and go to the work directory using the 'cd' 
command.

Type in:

sqlite3 bacula.db
>

type in .help to get help, .exit to exit

You need to update the VersionId. The relevant sql command is:

update table Version set VersionId='11' where VersionId='10';

Then check running command:

select * from Version;

This should display just '11'.

Exit the program; you're done.

Hope this helps,

Bernd

On Tue, 28 Apr 2009 10:51:11 +0000
bacula-users-request AT lists.sourceforge DOT net wrote:

> Message: 16
> Date: Tue, 28 Apr 2009 10:01:25 +0300
> From: Eitan Talmi <eitant AT gmail DOT com>
> Subject: [Bacula-users] Director is not starting after backup
> To: Bacula-users AT lists.sourceforge DOT net
> Message-ID:
>       <10dcacc80904280001gf7d322h5ec69ec618cc39d3 AT mail.gmail DOT com>
> Content-Type: text/plain; charset="iso-8859-1"
> 
> Hi all
> 
> After upgrading from version 2.4.4 to 3.0.0 the director is not starting.
> 
> If I am running bacula-dir -t I am getting this error message
> 
> bacula-dir: dird.c:878 Could not open Catalog "MyCatalog", database
> "bacula".
> bacula-dir: dird.c:883 Version error for database "bacula". Wanted 10, got
> 11
> 28-Apr 09:11 bacula-dir ERROR TERMINATION
> 
> 
> I already run the update_bacula_tables script couple of times with no luck
> this is what I am receiving after running the script
> 
> Altering MySQL tables
> 
> This script will update a Bacula MySQL database from version 10 to 11
>  which is needed to convert from Bacula version 2.0.x to 3.0.x or higher
> 
> ERROR 1060 (42S21) at line 8: Duplicate column name 'ReadBytes'
> ERROR 1060 (42S21) at line 9: Duplicate column name 'ActionOnPurge'
> ERROR 1060 (42S21) at line 10: Duplicate column name 'ActionOnPurge'
> ERROR 1050 (42S01) at line 19: Table 'JobHisto' already exists
> Update of Bacula MySQL tables succeeded.
> 
> 
> Thanks
> Eitan

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkn28ZgACgkQpYU8M8PbPV4a2wCdG76xDzWzE5h40DQqeCg0c8t7
DwYAn0mzwGbyQPXSmaIDpu/6t0deoVXJ
=OOyG
-----END PGP SIGNATURE-----
------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations 
Conference from O'Reilly Media. Velocity features a full day of 
expert-led, hands-on workshops and two days of sessions from industry 
leaders in dedicated Performance & Operations tracks. Use code vel09scf 
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users