-----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-requ...@lists.sourceforge.net wrote: > Message: 16 > Date: Tue, 28 Apr 2009 10:01:25 +0300 > From: Eitan Talmi <eit...@gmail.com> > Subject: [Bacula-users] Director is not starting after backup > To: Bacula-users@lists.sourceforge.net > Message-ID: > <10dcacc80904280001gf7d322h5ec69ec618cc3...@mail.gmail.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
