Upgrades

Upgrade CQ from V2.20 to V2.30

Prerequisites

• A CYBERQUEST 2.20 instance must be installed

• Back-up by creating a snapshot of the CYBERQUEST VM is recommended in this stage

• CYBERQUEST upgrade packets must be downloaded prior to the beginning of the upgrade process

Technical operations

Using WinSCP, copy from Upgrade2.20-2.30.7z file the following folders: Debian, mq and UpgradeFomOldVersion to the CYBERQUEST server in the following path: /home/superadmin/

Access your CYBERQUEST instance via ssh and follow the steps bellow:

1.Login as root with password toor1 and select Exit option

The result should look like this:

2.Create a new directory using th following command:

mkdir -p /media/iso1/

3.Edit the file fstab

A.Open the file fstab using the following command:

nano /etc/fstab

B.Add the following line of code at the end of the file:

/home/superadmin/Debian/DVD-1.iso /media/iso1/ udf,iso9660 loop 0 0

C.Save the file and exit.

4.Edit the file sources.list

A.Open the file sources.list using the following command:

nano /etc/apt/sources.list

B.Comment all lines in the file:

C.Add the following line of code at the end of the file:

deb [trusted=yes] file:/media/iso1/ bullseye main contrib

D.Save the file and exit.

5.Edit the file php.list

A.Open the file php.list using the following command:

nano /etc/apt/sources.list.d/php.list 

B.Comment out the line in the file:

6.Edit the file opendistroforelasticsearch.list

A.Open the file opendistroforelasticsearch.list using the following command:

nano /etc/apt/sources.list.d/opendistroforelasticsearch.list

B.Comment out the line in the file:

7.Mount ISO image using the following command:

mount -a

8.Update CYBERQUEST server using the following command:

apt-get update

9.Upgrade CYBERQUEST server to Debian 11

A.Upgrade CYBERQUEST server using the following command:

apt-get upgrade

B.Press Y on "Do you want to continue? [Y/n]" and Enter

C.Press q button

D.Select Yes on "Restart services during package upgrades without asking?" and Enter

10.Upgrade CYBERQUEST server

A.Upgrade CYBERQUEST server using the following command:

apt-get dist-upgrade

B.Press Y on "Do you want to continue? [Y/n]" and Enter

C.Press q button

D.Press Enter on "rsyslog.conf (Y/I/N/O/D/Z) [default=N] ?"

E.Press Enter on "sysctl.conf (Y/I/N/O/D/Z) [default=N] ?"

11.Unmask the RabbitMQ and restart the service

A.Unmask the RabbitMQ service using the following command:

systemctl unmask rabbitmq-server.service

B.Restart RabbitMQ service

systemctl restart rabbitmq-server.service

12.Install RabbitMQ packets

A.Go to the path /home/superadmin/mq/ using the following command:

cd /home/superadmin/mq

B.Install packages using the following command:

dpkg -i *

C.Automatically resolve installation issues using the following command:

apt-get -f install

D.Press Y on "Do you want to continue? [Y/n]" and Enter

E. Restart RabbitMQ service

systemctl restart rabbitmq-server.service

13.Update Web Application and services

A.Change the path to: /home/superadmin/UpgradeFromOldVersion using the following command:

cd /home/superadmin/UpgradeFromOldVersion

B.Run the script Script.sh using the following command:

bash Script.sh "mysql database password"

C.Press Enter on "lic (Y/I/N/O/D/Z) [default=N] ?"

12.Return to the default settings for data correlation and data storage services, then delete the assets table

A.Connect to the mysql database using the command below and enter the mysql database password

mysql -u root -p;

B.Return to default settings for Data Storage service

delete from config.settings where name like 'DataStorage%';

C.Return to default settings for Data Correlation service

delete from config.settings where name like 'DataCorrelation%';

D.Delete content from assets table

use reports;

truncate table assets;

E. Disconnect from the MySQL database using the CTRL+D keys.

F.Restart services

systemctl restart data-storage.service data-correlation.service data-acquisition.service

12.Logon to web interface and check the About page in Settings: