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 HES:
1.Update all Hideez Clients to 3.11, the new version can work with both old and new versions of the HES.
2.Disable the Data Protection on the HES.
3.Update the server using the following instruction.
4.Enable Data Protection again.
Create folder for backup
$ sudo mkdir /opt/HES.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/HES.old directory (on host) from container with name hes-mysql:
$ cd /opt/HES/
$ sudo sh -c "docker exec hes-mysql /usr/bin/mysqldump -u root --password=password db > /opt/HES.old/db.sql"
MS SQL Database:
The following command will create a backup of the database db in file db.bak in /opt/HES/mssql/data/ local directory:
 $ cd /opt/HES/
 $ 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/HES/docker-compose.yml file
Stop containers:
$ cd /opt/HES/
$ sudo docker compose down
(Optimal) Save the image of HES to a tar file (for possible further recovery):
$ sudo docker save -o /opt/HES.old/hes.tar hes
Remove image of HES:
$ 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 HES server using the following commands:
Stop containers:
$ cd /opt/HES/
$ sudo docker compose down
Remove image of HES:
$ 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/HES.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/HES/
 $ 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/HES/docker-compose.yml file
Restore old image of HES from tar file:
$ sudo docker load -i /opt/HES.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/HES.old

Last modified 2mo ago