Docker

Migration from 3.10 (or less) to 3.11 (or up) requires additional steps because we have significantly improved the data protection mechanism - now it is built on certificates and doesn't require entering the password manually on server start. Please follow these steps to update your IES:

1. Update all IPI Clients to 3.15.X, the new version can work with both old and new versions of the IES.

2. Disable the Data Protection on the IES.

3. Update the server using the following instruction.

4. Enable Data Protection again.

Create folder for backup

$ sudo mkdir /opt/IES.old

Backup the Database (Optimal(for possible further recovery)):

• MySQL Database:

The following command will create a copy of the database (dump) in file db.sql in /opt/IES.old directory (on host) from container with name hes-mysql:

$ cd /opt/IES/
$ sudo sh -c "docker exec hes-mysql /usr/bin/mysqldump -u root --password=password db > /opt/IES.old/db.sql"

• MS SQL Database:

The following command will create a backup of the database db in file db.bak in /opt/IES/mssql/data/ local directory:

 $ cd /opt/IES/
 $ sudo docker exec -it hes-mssql /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P "C00ll_Passwrd_here"  -Q "BACKUP DATABASE [db] TO DISK = N'/var/opt/mssql/data/db.bak' WITH NOFORMAT, NOINIT, NAME = 'db-full', SKIP, NOREWIND, NOUNLOAD, STATS = 10"

instead of "C00ll_Passwrd_here", enter your password here, which you specified in the /opt/IES/docker-compose.yml file

Stop containers:

$ cd /opt/IES/
$ sudo docker compose down

(Optimal) Save the image of IES to a tar file (for possible further recovery):

$ sudo docker save -o /opt/IES.old/hes.tar hes

Remove image of IES:

$ sudo docker rmi hes --force

To upgrade the server to the latest version, run commands:

$ sudo docker build . -t hes

and Restart containers:

$ sudo docker compose up -d

If something goes wrong, you can restore the IES server using the following commands:

Stop containers:

$ cd /opt/IES/
$ sudo docker compose down

Remove image of IES:

$ sudo docker rmi hes --force

Restore the Database

• My SQL:

Start MySQL container only:

$ sudo docker compose up -d hes-mysql

Restore the MySQL Database from dump file:

$ sudo cat /opt/IES.old/db.sql | sudo docker exec -i hes-mysql /usr/bin/mysql -u root --password=password db
$ sudo docker compose down 

• MS SQL:

Start MS SQL container only:

$ sudo docker compose up -d hes-mssql

Restore the MS SQL Database from bak file:

 $ cd /opt/IES/
 $ sudo docker exec -it hes-mssql /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P "C00ll_Passwrd_here"  -Q "RESTORE DATABASE [db] FROM DISK = N'/var/opt/mssql/data/db.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 5"

instead of "C00ll_Passwrd_here", enter your password here, which you specified in the /opt/IES/docker-compose.yml file

Restore old image of IES from tar file:

$ sudo docker load -i /opt/IES.old/hes.tar

and start containers:

$ sudo docker compose up -d

After checking that the update was successful and everything works fine, you can delete copies of the database and server:

$ sudo rm -rf /opt/IES.old