Package: openvas-manager
Version: 7.0.3-1
Severity: important

Dear Maintainer,

After upgrading from jessie to buster openvas-manager would not start
anymore (timeout reported by service). The database had to be upgraded
with:

openvasmd --migrate

but migration failed to upgrade tasks.db to revision 184 (stopped at
180). I found the problem was caused by new sqlite version as descibed
in this page:

https://github.com/greenbone/gvmd/issues/280

which  gave this command that resolved the problem:

(echo "DROP VIEW results_autofp;"; sqlite3 /var/lib/openvas/mgr/tasks.db 
'.schema results_autofp' | sed 's/nvts_172/nvts/g') | sqlite3 
/var/lib/openvas/mgr/tasks.db

after it was possible to migrate to 184.

Regards,
Marco


-- System Information:
Debian Release: 10.1
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 5.1.17-x86_64-linode128 (SMP w/1 CPU core; PREEMPT)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), 
LANGUAGE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages openvas-manager depends on:
ii  doc-base                0.10.8
ii  libassuan0              2.5.2-1
ii  libc6                   2.28-10
ii  libglib2.0-0            2.58.3-2+deb10u1
ii  libgnutls30             3.6.7-4
ii  libgpg-error0           1.35-1
ii  libgpgme11              1.12.0-6
ii  libopenvas9             9.0.3-1+b1
ii  libsqlite3-0            3.27.2-3
ii  lsb-base                10.2019051400
ii  openvas-manager-common  7.0.3-1

openvas-manager recommends no packages.

openvas-manager suggests no packages.

-- Configuration Files:
/etc/logrotate.d/openvas-manager changed [not included]
/etc/openvas/openvasmd_log.conf changed [not included]

-- no debconf information

Reply via email to