David L. Anselmi wrote: > Package: bacula-common-sqlite3 > Version: 3.0.2-3+b1 > Severity: important > > On upgrading to bacula 3.0 I was told my catalog was empty and should new > tables > be created. I said no. I had hoped that my old catalog would be upgraded > automatically.
Doh. That shouldn't have happened... > > So I have an empty /var/lib/bacula/bacula.db and a large bacula.db.sqlite2. > > The release notes say to use the update_bacula_tables script but that doesn't > seem to be included. I tried the script at: > > http://bacula.git.sourceforge.net/git/gitweb.cgi?p=bacula/bacula;a=blob;f=bacula/updatedb/update_sqlite3_tables_10_to_11.in;h=54a407d26f307bbf2c02f09e2f1f155cc57ba9ae;hb=HEAD > > but it doesn't recognize the bacula.db.sqlite2 file. You can fix that with something along the lines of echo .dump | sqlite2 bacula.db.sqlite2 | sqlite3 bacula.db.sqlite This is from memory; a better recipe is probably in the preinst for bacula-sqlite3. I will try to look into why this happened next week. -- John > > Here's what changed during the update: > > [REMOVE, NOT USED] bacula-director-sqlite > [REMOVE, NOT USED] sqlite > [INSTALL, DEPENDENCIES] bacula-common-sqlite3 > [INSTALL, DEPENDENCIES] bacula-director-sqlite3 > [INSTALL, DEPENDENCIES] bacula-sd-sqlite3 > [INSTALL, DEPENDENCIES] sqlite3 > [REMOVE, DEPENDENCIES] bacula-sd-sqlite > [UPGRADE] bacula 2.4.4-1 -> 3.0.2-3 > [UPGRADE] bacula-client 2.4.4-1 -> 3.0.2-3 > [UPGRADE] bacula-common 2.4.4-1 -> 3.0.2-3+b1 > [UPGRADE] bacula-console 2.4.4-1 -> 3.0.2-3+b1 > [UPGRADE] bacula-director-common 2.4.4-1 -> 3.0.2-3+b1 > [UPGRADE] bacula-fd 2.4.4-1 -> 3.0.2-3+b1 > [UPGRADE] bacula-sd 2.4.4-1 -> 3.0.2-3+b1 > [UPGRADE] bacula-server 2.4.4-1 -> 3.0.2-3 > > Thanks! > Dave > > -- System Information: > Debian Release: squeeze/sid > APT prefers testing > APT policy: (990, 'testing'), (500, 'unstable') > Architecture: i386 (i686) > > Kernel: Linux 2.6.30-2-686 (SMP w/1 CPU core) > Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) > Shell: /bin/sh linked to /bin/bash > > Versions of packages bacula-common-sqlite3 depends on: > ii adduser 3.111 add and remove users and groups > ii bacula-common 3.0.2-3+b1 network backup, recovery and > verif > ii debconf [debconf-2.0] 1.5.27 Debian configuration management > sy > ii libc6 2.9-25 GNU C Library: Shared libraries > ii libgcc1 1:4.4.1-4 GCC support library > ii libsqlite3-0 3.6.18-1 SQLite 3 shared library > ii libstdc++6 4.4.1-4 The GNU Standard C++ Library v3 > > bacula-common-sqlite3 recommends no packages. > > Versions of packages bacula-common-sqlite3 suggests: > pn bacula-doc <none> (no description available) > > -- no debconf information > > > -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
