Louis,

Probably not, check the build parameters if possible.
I cannot help you any further than that, I run my installation build from 
source.

I have the –pg version of openvasmd running here:

:/opt/openvas/sbin# ls -l
total 7780
-rwxr-xr-x 1 root root   27363 Jun 22  2017 greenbone-certdata-sync
-rwxr-xr-x 1 root root   21500 May  9  2017 greenbone-nvt-sync
-rwxr-xr-x 1 root root   49073 May  9  2017 greenbone-scapdata-sync
-rwxr-xr-x 1 root root 1521872 May  9  2017 gsad
lrwxrwxrwx 1 root root      12 May  9  2017 openvasmd -> openvasmd-pg
-rwxr-xr-x 1 root root 5894048 May  9  2017 openvasmd-pg
-rwxr-xr-x 1 root root   67712 May  9  2017 openvas-migrate-to-postgres
-rwxr-xr-x 1 root root   67701 May 10  2017 openvas-migrate-to-postgres_thijss
-rwxr-xr-x 1 root root    2567 May  9  2017 openvas-portnames-update
-rwxr-xr-x 1 root root  302544 May  9  2017 openvassd

Thijs Stuurman
Quality & Security | KPN Internedservices B.V.
thijs.stuur...@internedservices.nl<mailto:thijs.stuur...@internedservices.nl> | 
thijs.stuur...@kpn.com<mailto:thijs.stuur...@kpn.com>
T: +31(0)299476185 | M: +31(0)624366778
PGP Key-ID: 0x16ADC048 (https://pgp.surfnet.nl/)
Fingerprint: 2EDB 9B42 D6E8 7D4B 6E02 8BE5 6D46 8007 16AD C048

W: https://www.internedservices.nl<https://www.internedservices.nl/> | L: 
https://nl.linkedin.com/in/thijsstuurman

Van: Openvas-discuss <openvas-discuss-boun...@wald.intevation.org> Namens Louis 
Bohm
Verzonden: dinsdag 14 augustus 2018 12:28
Aan: openvas-discuss@wald.intevation.org
Onderwerp: [Openvas-discuss] OpenVAS 9 MigrateDB


Running OpenVAS 9 on Centos 7.5.  I installed OpenVAS a while back via the 
RPMs.  Now I would like to migrate the DB to Postgresql.

Installed postgresql server and then ran openvas-migrate-to-postgres.  When it 
ran it complained that the role ROOT did not exist so I created that role with 
superuser power.  Ran it a second time this time it complained that the DB 
tasks did not exist so I created that.  Third time it ran to finish with no 
errors.

Now that it has run I still do not believe I am using the postgresql db.  So I 
did some more googling and found that openvasmd can take the —database= option. 
 So I passed it the path that postgresql reports when you run a ps on it.  The 
openvasmd.log complains about sqlite not being found.  So clearly that does not 
work.

Either I am not doing it correctly or maybe the stock RPMs were not compiled to 
support postgresql???

After even more research I found this: 
https://fossies.org/linux/misc/openvas/openvas-manager-7.0.3.tar.gz/gvm-7.0.3/doc/postgres-HOWTO.

Anyone have any clue?

Louis
_______________________________________________
Openvas-discuss mailing list
Openvas-discuss@wald.intevation.org
https://lists.wald.intevation.org/cgi-bin/mailman/listinfo/openvas-discuss

Reply via email to