How to upgrade XPRESSO to v21.1

Steps to upgrade:

1. git pull

   • You may have local changes to the following files or more:
     • docker-compose.yml
     • env/database.env
     • initializers/settings.yml
     • ...
   • make sure to git stash, git pull, then git stash apply (to pull and then apply your changes)

2. Create database for new Aggregator service - s3_aggregator

   • docker-compose exec database bash
   • mysql -u root -p
   • enter your root password
   • execute the following:

     CREATE DATABASE s3_aggregator;
     GRANT ALL PRIVILEGES ON `s3_aggregator`.* TO 'xpresso_admin'@'localhost'   WITH GRANT OPTION;
     GRANT ALL PRIVILEGES ON `s3_aggregator`.* TO 'xpresso_admin'@'192.168.66.%'   WITH GRANT OPTION;
     

   • exit (twice - shell and container) - back to root

3. Register new service - (may not be needed if auto registered from initializers/settings.yml)

   • docker ps | grep management (copy container name)
   • docker inspect {container name} | grep IPAddress (replace {container name} with your container name outputted above - take note of ipAddress)
   • Run the commands below replacing {IPAddress} with management ipAddress

   •   -d '{"name": "aggregator", "url": "http://aggregator:8000/aggregator/api/", "description": "A service for aggregating XPRESSO cross group 
           requests."}' \
          {IPAddress}:8000/management/api/v1/settings/microservices```
     
     

   •   -d '{"settings":{"DATABASES": { "default": {"NAME": "s3_aggregator"} },"TOPIC": {"name": "s3_aggregator","key": 
          "aggregator_data"},"REQUEST_ID_LENGTH":10,"WEBEX": true,"REQUEST_PREFIX": "AGG"},"url": "http://aggregator:8000/aggregator/api/"}'\
         {IPAddress}:8000/management/api/v1/settings/microservices/aggregator```
     
     

4. Bring up containers

   • docker-compose up -d