Sherpa Orchestrator Update Process (Local Version)#

# Create a database dump
mysqldump -u root -p orchestrator > orchestrator_backup_$(date +%Y%m%d_%H%M%S).sql

# Create a dump of the archive database (if used)
mysqldump -u root -p orchestrator_archive > orchestrator_archive_backup_$(date +%Y%m%d_%H%M%S).sql

# Create a backup of the configuration
cp -r /opt/SherpaOrchestrator/backend/config /opt/SherpaOrchestrator/backend/config_backup_$(date +%Y%m%d_%H%M%S)

# Create a backup of SSL certificates
cp -r /opt/SherpaOrchestrator/backend/config/certs /opt/SherpaOrchestrator/backend/config/certs_backup_$(date +%Y%m%d_%H%M%S)

# Create a backup of the logs
cp -r /opt/SherpaOrchestrator/backend/logs /opt/SherpaOrchestrator/backend/logs_backup_$(date +%Y%m%d_%H%M%S)

# Navigate to the /opt directory and download the file as in the preparation step
cd /opt

# Download the update archive
orchestrator_local_update_*.tgz

# Stop PM2 processes
sudo pm2 stop all
sudo pm2 delete all

# Stop Nginx
sudo systemctl stop nginx

# Stop PHP-FPM
sudo systemctl stop php8.5-fpm

# Stop MySQL/MariaDB (optional, for complete shutdown)
sudo systemctl stop mariadb

# Rename the current directory
sudo mv /opt/SherpaOrchestrator /opt/SherpaOrchestrator_backup_$(date +%Y%m%d_%H%M%S)

# Create a new directory
sudo mkdir /opt/SherpaOrchestrator

# Find and extract the update archive (the latest version is automatically selected)
tar -xvzf "$(ls orchestrator_local_update_*.tgz | sort -V | tail -n 1)"

# Navigate to the application directory
cd /opt/SherpaOrchestrator

# Make scripts executable
sudo find ./*.sh -type f | xargs chmod +x

# Restore configuration files from backup
sudo cp -r /opt/SherpaOrchestrator_backup_*/backend/config/* /opt/SherpaOrchestrator/backend/config/

# Restore SSL certificates
sudo cp -r /opt/SherpaOrchestrator_backup_*/backend/config/certs/* /opt/SherpaOrchestrator/backend/config/certs/

# Set correct permissions
sudo chown -R www-data:www-data /opt/SherpaOrchestrator
sudo chmod -R 775 /opt/SherpaOrchestrator

# Check connection settings in phinx.php (passwords must match config.ini)
sudo nano backend/config/phinx.php

# Run database migrations
sudo ./migrate.sh

# Navigate to the websocket directory
cd /opt/SherpaOrchestrator/backend/app/websocket/

# Update dependencies
sudo npm install

# Return to the main directory
cd /opt/SherpaOrchestrator

# Start MySQL/MariaDB (if stopped)
sudo systemctl start mariadb

# Start PHP-FPM
sudo systemctl start php8.5-fpm

# Start Nginx
sudo systemctl start nginx

# Start WebSocket service
cd /opt/SherpaOrchestrator/backend/app/websocket/
sudo pm2 start index.js --name "Websockets"
sudo pm2 save

# Return to the main directory
cd /opt/SherpaOrchestrator

# Check the status of services
sudo systemctl status nginx
sudo systemctl status php8.5-fpm
sudo systemctl status mariadb

# Check PM2 processes
sudo pm2 list
sudo pm2 logs Websockets --lines 20

# Check the availability of the web interface
curl -I https://your-domain-or-ip

# Check Nginx logs for errors
sudo tail -f /var/log/nginx/error.log

# After successful testing, delete old backups
# (only perform after confirming functionality!)

# Remove old update files
rm -f /opt/orch_local_update_*.tgz

# Remove old backups (if confident in functionality)
# rm -rf /opt/SherpaOrchestrator_backup_*

# Stop all services
sudo pm2 stop all
sudo systemctl stop nginx php8.5-fpm

# Restore from backup
sudo rm -rf /opt/SherpaOrchestrator
sudo mv /opt/SherpaOrchestrator_backup_* /opt/SherpaOrchestrator

# Restore permissions
sudo chown -R www-data:www-data /opt/SherpaOrchestrator
sudo chmod -R 775 /opt/SherpaOrchestrator

# Start services
sudo systemctl start php8.5-fpm nginx
cd /opt/SherpaOrchestrator/backend/app/websocket/
sudo pm2 start index.js --name "Websockets"