Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


About this task

The BVQ Server "and Grafana " the database should only be accessible through HTTPS.Therefore a reverse proxy has to be installedbe moved, whether or not because of a new Windows VM.
These are very profound changes which need to be made by the SVA/BVQ SEs.
A working VM backup is necessary.

Applies to

All Versions and Systems, further info

Procedure

check for the current version 

...

titleexpand...

Image Removed

...

  1. Connect to the Mongo shell
    in order to connect, mongosh has to be installed as well, please see Install mongosh — MongoDB Shell

    Code Block
    >mongosh -u bvq -p P@ssw0rd

  2. Show DB´s

Code Block
> show dbs

Image Removed

Image Removed

Image Removed

Expand
titleexpand...
https://bamboo.sva.de/browse/BVQ

download the bvq-apache-server-installer

...

titleexpand...

...

install the server with admin rights,

...

Image Added

3.   Exit the shell

Code Block
> exit

4.   Stop all the BVQ Services but "bvq-mongodb" and start the backup, the time to complete this task is depending on the DB size

Code Block
C:\Users\bvq>mongodump --authenticationDatabase admin -u bvq -p P@ssw0rd -d bvq -j 8 --gzip --out="C:\Temp\test-backup"

Image Removed

Expand
titleexpand...

make sure to use the FQDN of the existing BVQ server

...

titleexpand...

Image Removed

make use of the self-signed certificates

...

Image Added

5.   Start & finish the installation of the same Version of BVQ on the new VM

6.   Stop all BVQ services but "bvq-mongodb" on the new VM

Expand
titleexpand...

Image Removed

the bvq-apache service has to be running, if its not running -start it manually 

...

titleexpand...

Image Removed

the BVQ server is now reachable through HTTPS

...

titleexpand...

Image Removed

scanners which are using HTTP have to be edited

...

titleexpand...

Image Removed

As BVQ is now accessible via HTTP & HTTPS, the customer has to implement the Firewall changes now

...

titleexpand...

Image Removed

...

Services
Image Added

8.   During the BVQ-Installation, using default values, a "db" named "bvq" is created.

A restore of a mongodb has to be made, using a not existing db.
If you would like to use the db "bvq" again (code: mongorestore  --authenticationDatabase admin -u bvq -p P@ssw0rd --db bvq --gzip -j 8 C:\bvq),
you have to drop the existing(just installed) bvq db.

Code Block
Connect to the mongo shell on the new VMC:\Users>mongo --authenticationDatabase admin -u bvq -p P@ssw0rd


show the db´s


> show dbs
admin 0.000GB
bvq 43.815GB
config 0.000GB
local 0.000GB
---------------------------------------------------------------------------


switch to the db, you would like to delete

> use bvq
switched to db bvq
---------------------------------------------------------------------------


delete db

> db.dropDatabase()
{ "ok" : 1 }
---------------------------------------------------------------------------


show the db´s

> show dbs
admin 0.000GB
config 0.000GB
local 0.000GB

 

9.   Restore the DB

Code Block
C:\bvq>mongorestore --authenticationDatabase admin -u bvq -p P@ssw0rd --db bvq -j 8 --gzip "C:\Temp\test-backup\bvq"

Image Removed

Expand
titleexpand...

Escalation

...

Image Added

Image Added