{"id":876,"date":"2014-06-15T14:30:46","date_gmt":"2014-06-15T12:30:46","guid":{"rendered":"http:\/\/blog.schmoigl-online.de\/?p=876"},"modified":"2014-06-15T14:35:33","modified_gmt":"2014-06-15T12:35:33","slug":"openvas-broken-debian-installer-packages","status":"publish","type":"post","link":"http:\/\/blog.schmoigl-online.de\/?p=876","title":{"rendered":"OpenVAS &#8211; Broken Debian Installer Packages"},"content":{"rendered":"<p>Recently, I have read an article in a computer magazine on the vulnerability scanner <a href=\"http:\/\/www.openvas.org\/index.html\">OpenVAS<\/a>. It sounded interesting and that was why I wanted to try it out. OpenVAS provides a <a href=\"http:\/\/www.openvas.org\/vm.html\">live virtual appliance container file<\/a> for demo purposes. Trying to install it into a VMWare Player, I was not able to get it running. As it appeared to be related to an incompatible library on the image, I decided to install a new <a href=\"https:\/\/www.debian.org\/News\/2014\/20140426\">Debian 7.5 Wheezy<\/a> image as VM. All the steps necessary for install and setup can be found on <a href=\"http:\/\/www.openvas.org\/install-packages-v6.html#openvas_debian_obs\">the OpenVAS website<\/a>. <!--more--><br \/>\nOne of the crucial steps in between is to run<\/p>\n<pre>\r\nopenvas-certdata-sync\r\n<\/pre>\n<p>which updates the cert database. Without it, you won&#8217;t be able to start the <code>openvas-scanner<\/code> service. It would fail with the error message<\/p>\n<pre>\r\nsql_x: sqlite3_prepare failed: no such table: main.meta\r\n<\/pre>\n<p>in the log file <code>\/var\/log\/openvas\/openvasmd.log<\/code>. However, when running <code>openvas-certdata-sync<\/code>, you will get another block of error messages, reading<\/p>\n<pre>\r\n\/usr\/sbin\/openvas-certdata-sync: 185: \/usr\/sbin\/openvas-certdata-sync: cannot open \/usr\/share\/openvas\/cert\/cert_db_init.sql: No such file\r\nError: no such table: dfn_cert_advs\r\nError: no such table: meta\r\nError: Inconsistent data. Resetting CERT database.\r\n<\/pre>\n<p>This problem has already been addressed by the <a href=\"https:\/\/bugzilla.novell.com\/show_bug.cgi?id=833235#c0\">Novell Bugzilla<\/a> since August, 2013, but has not been fixed yet. Futhermore, there are many other reports of this issue in several forums and mailing lists. <\/p>\n<p>The root cause of this matter is that the Debian software package <code>openvas-manager<\/code> is missing the files in <code>\/usr\/share\/openvas\/cert\/<\/code>. These files, however, are available in the <a href=\"http:\/\/mirrord.binarysignals.net\/OpenVAS-6-DEMO-3.0.ova\">VM container file<\/a>. Unfortunately, extracting and copying them over to your installation may be a bit tricky; that is why I have bundled them for you in a file attached to this blog. You may download the file and extract it via<\/p>\n<pre>\r\ncd \/usr\/share\/openvas\r\nmkdir cert\r\ncd cert\r\nwget http:\/\/blog.schmoigl-online.de\/?dl_id=5\r\ntar xzvf openvas-cert.tar.gz\r\nrm openvas-cert.tar.gz\r\n<\/pre>\n<p>onto you local machine. <div class=\"wp-downloadmanager\"><p><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"wp-downloadmanager-sprite\" aria-hidden=\"true\" focusable=\"false\"><symbol id=\"wp-downloadmanager-icon-file\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.4\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><path d=\"M6 2.5h7l5 5v14H6z\" \/><path d=\"M13 2.5v5h5\" \/><\/symbol><symbol id=\"wp-downloadmanager-icon-archive\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.4\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><path d=\"M6 2.5h7l5 5v14H6z\" \/><path d=\"M13 2.5v5h5\" \/><path d=\"M11 3h2v2h-2zM11 6h2v2h-2zM11 9h2v2h-2zM10.5 13h3v3.5h-3z\" \/><\/symbol><symbol id=\"wp-downloadmanager-icon-audio\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.4\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><path d=\"M6 2.5h7l5 5v14H6z\" \/><path d=\"M13 2.5v5h5\" \/><path d=\"M10 18.5v-5l5-1.5v5\" \/><circle cx=\"9\" cy=\"18.5\" r=\"1.4\" \/><circle cx=\"14\" cy=\"17\" r=\"1.4\" \/><\/symbol><symbol id=\"wp-downloadmanager-icon-code\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.4\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><path d=\"M6 2.5h7l5 5v14H6z\" \/><path d=\"M13 2.5v5h5\" \/><path d=\"M10.5 12.5 8 15.5l2.5 3M13.5 12.5 16 15.5l-2.5 3\" \/><\/symbol><symbol id=\"wp-downloadmanager-icon-document\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.4\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><path d=\"M6 2.5h7l5 5v14H6z\" \/><path d=\"M13 2.5v5h5\" \/><path d=\"M9 12.5h6M9 15.5h6M9 18.5h4\" \/><\/symbol><symbol id=\"wp-downloadmanager-icon-image\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.4\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><path d=\"M6 2.5h7l5 5v14H6z\" \/><path d=\"M13 2.5v5h5\" \/><circle cx=\"10\" cy=\"13.5\" r=\"1.1\" \/><path d=\"M8 19.5l3-3 2 2 3-3.5 2 4.5z\" \/><\/symbol><symbol id=\"wp-downloadmanager-icon-presentation\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.4\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><path d=\"M6 2.5h7l5 5v14H6z\" \/><path d=\"M13 2.5v5h5\" \/><path d=\"M9 19.5v-3M12 19.5v-5.5M15 19.5v-8\" \/><\/symbol><symbol id=\"wp-downloadmanager-icon-spreadsheet\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.4\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><path d=\"M6 2.5h7l5 5v14H6z\" \/><path d=\"M13 2.5v5h5\" \/><path d=\"M8 12.5h8v7H8zM8 16h8M11.5 12.5v7\" \/><\/symbol><symbol id=\"wp-downloadmanager-icon-video\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.4\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><path d=\"M6 2.5h7l5 5v14H6z\" \/><path d=\"M13 2.5v5h5\" \/><path d=\"M10.5 13.5l5 3-5 3z\" \/><\/symbol><symbol id=\"wp-downloadmanager-icon-application\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.4\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><path d=\"M6 2.5h7l5 5v14H6z\" \/><path d=\"M13 2.5v5h5\" \/><circle cx=\"12\" cy=\"16.5\" r=\"2\" \/><path d=\"M12 12.5V14M12 19v1.5M8.5 16.5H10M14 16.5h1.5\" \/><\/symbol><\/svg><svg class=\"wp-downloadmanager-icon\" aria-hidden=\"true\" focusable=\"false\"><use href=\"#wp-downloadmanager-icon-file\" \/><\/svg>&nbsp;&nbsp;<strong><a href=\"http:\/\/blog.schmoigl-online.de\/?dl_id=5\">OpenVAS metadata files for cert directory<\/a><\/strong> (2.0 KiB, 2,858 hits)<\/p><\/div> Afterwards, you need to run<\/p>\n<pre>\r\nopenvas-certdata-sync\r\n<\/pre>\n<p>again.<\/p>\n<p>It&#8217;s a shame that a bug report has been open for more than 10 months now, causing that no Debian distribution will run out of the box anymore, and has not been &#8211; even &#8211; addressed yet.<br \/>\nIf that is representative for the reliability of a security product, should you really run it in your network?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Due to a bug in the debian package of OpenVAS 6, the files in \/usr\/share\/openvas\/cert\/ are missing (&#8220;no such file&#8221;). It is being explained how to fix it.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-876","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"http:\/\/blog.schmoigl-online.de\/index.php?rest_route=\/wp\/v2\/posts\/876","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blog.schmoigl-online.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.schmoigl-online.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.schmoigl-online.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.schmoigl-online.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=876"}],"version-history":[{"count":17,"href":"http:\/\/blog.schmoigl-online.de\/index.php?rest_route=\/wp\/v2\/posts\/876\/revisions"}],"predecessor-version":[{"id":894,"href":"http:\/\/blog.schmoigl-online.de\/index.php?rest_route=\/wp\/v2\/posts\/876\/revisions\/894"}],"wp:attachment":[{"href":"http:\/\/blog.schmoigl-online.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=876"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.schmoigl-online.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=876"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.schmoigl-online.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=876"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}