1. Upgrading on Kubernetes

When it comes time to upgrade your various components, you can do so by updating the version number in your configuration files and applying the changes in ArgoCD.

1.1 Configuring to the Newest Version

1. Navigate to your cinchy devops.automation repository

   1. Navigate to your deployment.json (You may have renamed this during your original Kubernetes deployment)

   2. In the cinchy_instance_configs section, navigate to the image tags. Replace the version number with the instance that you wish to deploy (Ex: v5.0.0 > 5.1.0).

  // The component image tags are specified below to define which versions to deploy
  "connections_image_tag": "v5.1.0",
  "event_listener_image_tag": "v5.1.0",
  "idp_image_tag": "v5.1.0",
  "maintenance_cli_image_tag": "v5.1.0",
  "meta_forms_image_tag": "v5.1.0",
  "web_image_tag": "v5.1.0",
  "worker_image_tag": "v5.1.0"

2. Rerun the deployment script by using the following command in the root directory of your devops.automations repo:

dotnet Cinchy.DevOps.Automations.dll "deployment.json"

3. Commit and push your changes.

1.2 Apply your Configurations

If your environment is not set-up to automatically apply upon configuration, complete the following the apply the newest version:

1. Navigate to the ArgoCD portal.

2. Refresh your component(s). If that does not work, re-sync.

The pages under this section deal with upgrading your Cinchy platform.

• If you are currently running Cinchy v4+ or v5+ and wish to upgrade your components, please review the documentation here:

• If you are currently running Cinchy v4+ and wish to upgrade to v5+, please review the documentation here:

1. Upgrading on Kubernetes

When it comes time to upgrade your various components, you can do so by updating the version number in your configuration files and applying the changes in ArgoCD.

1.1 Configuring to the Newest Version

1. Navigate to your cinchy devops.automation repository

   1. Navigate to your deployment.json (You may have renamed this during your original Kubernetes deployment)

   2. In the cinchy_instance_configs section, navigate to the image tags. Replace the version number with the instance that you wish to deploy (Ex: v5.1.0 > 5.2.0).

  // The component image tags are specified below to define which versions to deploy
  "connections_image_tag": "v5.2.0",
  "event_listener_image_tag": "v5.2.0",
  "idp_image_tag": "v5.2.0",
  "maintenance_cli_image_tag": "v5.2.0",
  "meta_forms_image_tag": "v5.2.0",
  "web_image_tag": "v5.2.0",
  "worker_image_tag": "v5.2.0"

2. Rerun the deployment script by using the following command in the root directory of your devops.automations repo:

dotnet Cinchy.DevOps.Automations.dll "deployment.json"

3. Commit and push your changes.

1.2 Apply your Configurations

If your environment is not set-up to automatically apply upon configuration, complete the following the apply the newest version:

1. Navigate to the ArgoCD portal.

2. Refresh your component(s). If that does not work, re-sync.

1. Overview

The sub-pages in this section will refer you to upgrade guides for each Cinchy version. Ensure that you select either IIS Upgrades or Kubernetes Upgrades depending on your deployment type.

1. Overview

The pages under this section can be used to help guide you through an upgrade of your Cinchy instance.

1. Overview

The Cinchy Upgrade Utility was first introduced in v5.2 in order to facilitate a mandatory INT to BigInt upgrade. This tool has continued to be used in subsequent releases as an easy way to deploy necessary changes to your Cinchy platform.

2. Considerations

• Upgrades will also be specified on the applicable Upgrade Guide page for each release.

• Depending on your upgrade path, certain upgrades must be performed in sequential and/or specific order. This will be clearly marked in the "Overview and Considerations" section.

  • For example: To go from v5.1 to v5.5, you would first have to run the 5.2 upgrade utility and deploy the release. Once validated, you would then run the 5.5 upgrade and deploy that version.

• Not all new releases will have changes that require the utility to be run. Review the table in section 4 for the full list.

3. Prerequisites

• You will need to run this process as a user with admin/dbowner privileges to your database.

• You will need to have .NET Core 6.0.x installed on the machine that you will run the utility on.

• Retrieve the Upgrade Utility from the Cinchy Releases table.

4. Upgrades

5. Upgrade Overviews and Considerations

6. Upgrade Instructions

1. Turn off your Cinchy platform. (Note: This step is only required for the 5.2 upgrade)

   1. In a Kubernetes deployment, you can do so via ArgoCD.

   2. In an IIS Deployment:

      1. Open your Windows Services Panel.

      2. Select IIS Admin Service.

      3. Stop the service.

      4. Right-click IIS Admin Service and select Properties.

      5. Change 'Start Up Type' to 'Disabled'.

2. Create a backup snapshot of your platform.

   1. In a Kubernetes deployment on AWS, you can follow the documentation here.

   2. In a Kubernetes deployment on Azure, you can follow the documentation here.

   3. In an IIS Deployment, you can follow the documentation here.

3. Retrieve the Upgrade Utility from the Cinchy Releases table if you haven't already.

4. Run the following command through a command window as an admin/dbowner, using the table below as a guide.

dotnet cinchy.upgrade-utility.dll -d "TSQL" -s "Server=LAPTOP-4SUPR0L6;Database=T6;User ID=cinchy;Password=cinchy;Trusted_Connection=False;Connection Timeout=30;Min Pool Size=10;Encrypt=False" -v "5.2"

5. You will see the below progress bar as your upgrade completes (Image 1). Once it is done, you will see a VALIDATION PASSED check.

6. Deploy your Cinchy Upgrade.

7. If it was turned off in step 1, turn your Cinchy platform back on.

1. In a Kubernetes deployment, you can do so via Argo CD

2. In an IIS deployment:

1. Open your Windows Services Panel.

2. Select IIS Admin Service.

3. Start the service.

4. Right-click IIS Admin Service and select Properties.

5. Change 'Start Up Type' to 'Enabled'.

1. Upgrading on Kubernetes

When it comes time to upgrade your various components, you can do so by updating the version number in your configuration files and applying the changes in ArgoCD.

1.1 Configuring to the Newest Version

1. Navigate to your cinchy devops.automation repository

   1. Navigate to your deployment.json (You may have renamed this during your original Kubernetes deployment)

   2. In the cinchy_instance_configs section, navigate to the image tags. Replace the version number with the instance that you wish to deploy (Ex: v5.2.0 > 5.3.0).

  // The component image tags are specified below to define which versions to deploy
  "connections_image_tag": "v5.3.0",
  "event_listener_image_tag": "v5.3.0",
  "idp_image_tag": "v5.3.0",
  "maintenance_cli_image_tag": "v5.3.0",
  "meta_forms_image_tag": "v5.3.0",
  "web_image_tag": "v5.3.0",
  "worker_image_tag": "v5.3.0"

2. Rerun the deployment script by using the following command in the root directory of your devops.automations repo:

dotnet Cinchy.DevOps.Automations.dll "deployment.json"

3. Commit and push your changes.

1.2 Apply your Configurations

If your environment is not set-up to automatically apply upon configuration, complete the following the apply the newest version:

1. Navigate to the ArgoCD portal.

2. Refresh your component(s). If that does not work, re-sync.

Overview

The Kubernetes project runs a community-owned image registry called registry.k8s.io in which to host its container images. On April 3rd, 2023, the registry k8s.gcr.io was deprecated and no further images for Kubernetes and related subprojects are being pushed to this location.

Instead, there is a new registry: registry.k8s.io.

New Cinchy Deployments: this change will be automatically reflected in your installation.

For Current Cinchy Deployments: please follow the instructions outlined in this upgrade guide to ensure your components are pointed to the correct image repo.

You can review the full details on this change here: https://kubernetes.io/blog/2023/02/06/k8s-gcr-io-freeze-announcement/

Update Instructions

1. In a shell/terminal, run the below command to get a list of all the pods that are pointing to the old registry: k8s.gcr.io. These will need to be updated to point to the new image registry.

kubectl get pods --all-namespaces -o jsonpath="{.items[*].spec.containers[*].image}" |\
tr -s '[[:space:]]' '\n' |\
sort |\
uniq -c
grep "k8s.gcr.io"

1. Once you find which pods are using old image registry, you need to update its deployment/daemonset/stateful set with new registry.k8s.io registry. Find the right resource type for your pods with below command:

kubectl get deployment,daemonset,statefulset --all-namespaces

1. Once you have your pod name and resource type, run the below command to open the manifest file in an editor:

kubectl edit deployment cluster-autoscaler -n kube-system

1. In the editor, find any instances of k8s.gcr.io and replace it with registry.k8s.io.

2. Save and close the file.

3. Repeat steps 3-5 for the rest of your pods until they are all pointing to the correct registry.

1. Upgrading on Kubernetes

When it comes time to upgrade your various components, you can do so by following the below instructions.

"cinchy_instance_configs": {
          "database_connection_string": "User ID=cinchy;Password=<password>;Host=<db_hostname>;Port=5432;Database=development;Timeout=300;Keepalive=300;TrustServerCertificate=True",

2. Prerequisites

• Download the latest Cinchy Artifacts from the Cinchy Releases Table > Kubernetes Artifacts column (Image 1). For this upgrade, please download the Cinchy v5.4 k8s-template.zip file.

3. Take your Platform Offline

1. Turn off your Cinchy platform. In a Kubernetes deployment, you can do so via ArgoCD.

4. Configuring to the Newest Version

1. Navigate to your cinchy.argocd repository. Delete all existing folder structure except for the .git file and any custom changes you may have implemented.

2. Navigate to your cinchy.kubernetes repository. Delete all existing folder structure except for the .git file and any custom changes you may have implemented.

1. Navigate to your cinchy.terraform repository. Delete all existing folder structure except for the .git file and any custom changes you may have implemented.

2. Navigate to your cinchy.devops.automation repository. Delete all existing folder structure except for the .git file and any custom changes you may have implemented.

3. Open the new Cinchy v5.4 k8s-template.zip file you downloaded from the Cinchy Releases table.

4. Navigate to the new aws.json/azure.json files and compare them with your current deployment.json file. Any additional fields in the new aws.json/azure.json files should be added to your current deployment.json.

"cinchy_instance_configs": {
          "database_connection_string": "User ID=cinchy;Password=<password>;Host=<db_hostname>;Port=5432;Database=development;Timeout=300;Keepalive=300;TrustServerCertificate=True",

1. Open a shell/terminal from the cinchy.devops.automations directory and execute the following command:

dotnet Cinchy.DevOps.Automations.dll "deployment.json"

1. Commit all of your changes (if there were any) in each repository.

2. If there were any changes in your cinchy.argocd repository you may need to redeploy ArgoCD.

   1. Launch a shell/terminal with the working directory set to the root of the cinchy.argocd repository.

   2. Execute the following command to deploy ArgoCD:

bash deploy_argocd.sh

1. If there were any change to the cluster components, execute the following command from the cinchy.argocd repository:

bash deploy_cluster_components.sh

1. If there were any change to the Cinchy instance, execute the following command from the cinchy.argocd repository:

bash deploy_cinchy_components.sh

1. Log in to your ArgoCD application console and refresh the apps to ensure that all changes were picked up.

1.3 Turn your Platform On and Apply your Configurations

1. Turn your platform back on. In a Kubernetes deployment, you can do so via Argo CD

1. Upgrading on Kubernetes

When it comes time to upgrade your various components, you can do so by following the below instructions.

2. Prerequisites

• Download the latest Cinchy Artifacts from the Cinchy Releases Table > Kubernetes Artifacts column (Image 1). For this upgrade, please download the Cinchy v5.5 k8s-template.zip file.

3. Configuring to the Newest Version

1. Navigate to your cinchy.argocd repository. Delete all existing folder structure except for the .git folder/directory and any custom changes you may have implemented.

2. Navigate to your cinchy.kubernetes repository. Delete all existing folder structure except for the .git file and any custom changes you may have implemented.

1. Navigate to your cinchy.terraform repository. Delete all existing folder structure except for the .git file and any custom changes you may have implemented.

2. Navigate to your cinchy.devops.automation repository. Delete all existing folder structure except for the .git file and any custom changes you may have implemented and your deployment.json.

3. Open the new Cinchy v5.4 k8s-template.zip file you downloaded from the Cinchy Releases table and check the files into their respective cinchy.kubernete, cinchy.argocd, cinchy.terraform and cinchy.devops.automation repositories.

4. Navigate to the new aws.json/azure.json files and compare them with your current deployment.json file. Any additional fields in the new aws.json/azure.json files should be added to your current deployment.json.

1. Open a shell/terminal from the cinchy.devops.automations directory and execute the following command:

1. Commit all of your changes (if there were any) in each repository.

2. If there were any changes in your cinchy.argocd repository you may need to redeploy ArgoCD.

   1. Launch a shell/terminal with the working directory set to the root of the cinchy.argocd repository.

   2. Execute the following command to deploy ArgoCD:

1. If there were any change to the cluster components, execute the following command from the cinchy.argocd repository:

1. If there were any change to the Cinchy instance, execute the following command from the cinchy.argocd repository:

1. Log in to your ArgoCD application console and refresh the apps to ensure that all changes were picked up.

1. Overview

This page will guide you through how to update your AWS EKS Kubernetes version for your Cinchy v5 platform.

2. Prerequisites

• Update your Cinchy platform to the

• Confirm the latest Cinchy supported version of EKS. You can find the version number in the cinchy.devops.automations\aws-deployment.json as "cluster_version": "1.xx".

3. Considerations

• You must upgrade your EKS sequentially. For example, if you are on EKS cluster version 1.22 and wish to upgrade to 1.24, you must upgrade from 1.22 > 1.23 > 1.24.

4. Upgrade Instructions

1. Navigate to your cinchy.devops.automations\aws-deployment.json file.

2. Change the cluster_version key value to the EKS version you wish to upgrade to. (Example: "1.24")

3. Open a shell/terminal and navigate to the cinchy.devops.automations directory location.

4. Execute the following command:

1. Commit changes for all the repositories (cinchy.argocd, cinchy.kubernetes, cinchy.terraform and cinchy.devops.automation).

2. Open a new shell/terminal and navigate to the cinchy.terraform\aws\eks_cluster\CLUSTER_NAME directory location.

3. Execute the following command:

1. Verify the changes are as expected and then accept.

This process will first upgrade the managed master node version and then the worker nodes. During the upgrade process, existing pods get migrated to new worker nodes and all pods will get migrated to new upgraded worker nodes automatically.

The below two commands can be used to verify that all pods are being migrated to new worker nodes.

• To show both old and new nodes:

• To show all the pods on the new worker nodes and the old worker nodes.

5. Reinstalling the Metrics Server

For EKS version 1.24, the metrics server goes into a crashed loop status. Reinstalling the metrics server will fix this, should you encounter this during your upgrade.

1. In a code editor, open the cinchy.terraform\aws\eks_cluster\CLUSTER_NAME\new-vpc.tf or existing-VPC.tf file.

2. Find the enable_metrics_server key and mark its value to false.

3. Open a new shell/terminal and navigate to the cinchy.terraform\aws\eks_cluster\CLUSTER_NAME file.

4. Run the below command to remove metrics server.

1. Revert the enable_metrics_server key value from step 1 to true.

2. Run the below command within the same shell/terminal as step 3 to deploy metrics server with

1. Upgrading on Kubernetes

When it comes time to upgrade your various components, you can do so by following the below instructions.

2. Prerequisites

• Download the latest Cinchy Artifacts from the Cinchy Releases Table > Kubernetes Artifacts column (Image 1). For this upgrade, please download the Cinchy v5.6 k8s-template.zip file.

3. Configuring to the Newest Version

1. Navigate to your cinchy.argocd repository. Delete all existing folder structure except for the .git folder/directory and any custom changes you may have implemented.

2. Navigate to your cinchy.kubernetes repository. Delete all existing folder structure except for the .git file and any custom changes you may have implemented.

1. Navigate to your cinchy.terraform repository. Delete all existing folder structure except for the .git file and any custom changes you may have implemented.

2. Navigate to your cinchy.devops.automation repository. Delete all existing folder structure except for the .git file and any custom changes you may have implemented and your deployment.json.

3. Open the new Cinchy v5.6 k8s-template.zip file you downloaded from the Cinchy Releases table and check the files into their respective cinchy.kubernete, cinchy.argocd, cinchy.terraform and cinchy.devops.automation repositories.

4. Navigate to the new aws.json/azure.json files and compare them with your current deployment.json file. Any additional fields in the new aws.json/azure.json files should be added to your current deployment.json.

1. Open a shell/terminal from the cinchy.devops.automations directory and execute the following command:

1. Commit all of your changes (if there were any) in each repository.

2. If there were any changes in your cinchy.argocd repository you may need to redeploy ArgoCD.

   1. Launch a shell/terminal with the working directory set to the root of the cinchy.argocd repository.

   2. Execute the following command to deploy ArgoCD:

1. If there were any change to the cluster components, execute the following command from the cinchy.argocd repository:

1. If there were any change to the Cinchy instance, execute the following command from the cinchy.argocd repository:

1. Log in to your ArgoCD application console and refresh the apps to ensure that all changes were picked up.

1. Upgrading on IIS

This process can be run when upgrading from a Cinchy version that is not v5.0+.

1.1 Prerequisites

1. Follow this guide to take a backup of your database.

2. Extract the new build for the version you wish to upgrade to.

1.2 Upgrade Process

1. Swap out the following configs with your current instance configs:

   1. Cinchy/web.config

   2. CinchySSO/appsettings.json

   3. Log4net.config

   4. Web.config

2. Execute the following command:

iisreset -stop 

5. Replace the Cinchy and CinchySSO folders with the new build and your merged configs.

6. Execute the following command:

iisreset -start 

7. Start Cinchy in your browser.

1. Upgrading on IIS

The following process can be run when upgrading any v5.x instance to v5.2 on IIS.

1.1 Prerequisites

1. Take a backup of your database.

2. Extract thefor the version you wish to upgrade to.

1.2 Upgrade Process

1. Merge the following configs with your current instance configs:

   • Cinchy/web.config

   • Cinchy/appsettings.json

   • CinchySSO/appsettings.json

   • CinchySSO/web.config

2. Execute the following command:

3. Replace the Cinchy and CinchySSO folders with the new build and your merged configs.

4. Execute the following command:

5. Open your Cinchy URL in your browser.

6. Ensure you can log in.

1. Upgrading on IIS

The following process can be run when upgrading from v5.0 to v5.1 on IIS.

1.1 Prerequisites

1. Take a backup of your database.

2. Extract the new build for the version you wish to upgrade to.

1.2 Upgrade Process

1. Merge the following configs with your current instance configs:

   • Cinchy/web.config

   • Cinchy/appsettings.json

   • CinchySSO/appsettings.json

   • CinchySSO/web.config

2. Execute the following command:

iisreset -stop 

3. Replace the Cinchy and CinchySSO folders with the new build and your merged configs.

4. Execute the following command:

iisreset -start 

5. Open your Cinchy URL in your browser.

6. Ensure you can log in.

1. Upgrading on IIS (v4 to v5+)

"SqlServer" : "Server=MyServer;Database=Cinchy;User ID=cinchy;Password=password;Trusted_Connection=False;Connection Timeout=30;Min Pool Size=10;TrustServerCertificate=True"

1.1 Prerequisites

1. Follow this guide to take a backup of your database.

2. Extract the new build for the version you wish to upgrade to.

1.2 Update the CinchySSO appsettings.json

1. Open the C:\CinchySSO\appsettings.json file in a text editor and update the values below.

1.2.1 App Settings

1. Under AppSettings section, update the values outlined in the table.

2. Wherever you see <base url> in the value, replace this with the actual protocol (i.e. http or https) and the domain name (or ip address) you plan to use.

Ex:. if you're using https with the domain app.cinchy.co, then <base url> should be replaced with https://app.cinchy.co

Below values are only required for SSO, otherwise leave them as blank

1.2.2 Connection String

In order for the application to connect to the database, the "SqlServer" value needs to be set.

"SqlServer" : "Server=MyServer;Database=Cinchy;User ID=cinchy;Password=password;Trusted_Connection=False;Connection Timeout=30;Min Pool Size=10;TrustServerCertificate=True"

1. Find and update the value under the "ConnectionStrings" section:

SQL Server Authentication Example:

"SqlServer" : "Server=MyServer;Database=Cinchy;User ID=cinchy;Password=password;Trusted_Connection=False;Connection Timeout=30;Min Pool Size=10;"

SQL Server Windows Authentication Example:

"SqlServer" : "Server=MyServer;Database=Cinchy;Trusted_Connection=True;Connection Timeout=30;Min Pool Size=10;"

1.2.3 External Identity Claim Section

Under the "ExternalIdentityClaimSection" section you'll see the following values.

These values are used for SAML SSO. If you are not using SSO, keep these values as blank

1.2.4 Serilog

1. There is a "Serilog" property that allows you to configure where it logs to. In the below code, update the following:

   1. "Name" must be set to "File" so it writes to a physical file on the disk.

   2. "Path" must be set to the file path to where you want it to log.

  "Serilog": {
    "MinimumLevel": {
      "Default": "Debug",
      "Override": {
        "Microsoft": "Warning",
        "System.Net": "Warning"
      }
    },
    "WriteTo": [
      {
        "Name": "File",
        "Args": {
          "path": "C:\\CinchyLogs\\Cinchy\\log.json",
          "formatter": "Serilog.Formatting.Compact.CompactJsonFormatter, Serilog.Formatting.Compact"
        }
      }
    ]
  }

1.3 Update the Cinchy appsettings.json

1. Navigate to C:\Cinchy

2. Delete the appsettings.Development.json

3. Navigate to the appsettings.json file and update the following properties:

1.3.1 AppSettings

1.3.2 Connection String

In order for the application to connect to the database, the "SqlServer" value needs to be set.

"SqlServer" : "Server=MyServer;Database=Cinchy;User ID=cinchy;Password=password;Trusted_Connection=False;Connection Timeout=30;Min Pool Size=10;TrustServerCertificate=True"

1. Find and update the value under the "ConnectionStrings" section:

SQL Server Authentication Example:

"SqlServer" : "Server=MyServer;Database=Cinchy;User ID=cinchy;Password=password;Trusted_Connection=False;Connection Timeout=30;Min Pool Size=10;"

SQL Server Windows Authentication Example:

"SqlServer" : "Server=MyServer;Database=Cinchy;Trusted_Connection=True;Connection Timeout=30;

1.3.3 Serilog

1. There is a "Serilog" property that allows you to configure where it logs to. In the below code, update the following:

   • "Name" must be set to "File" so it writes to a physical file on the disk.

   • "Path" must be set to the file path to where you want it to log.

  "Serilog": {
    "MinimumLevel": {
      "Default": "Debug",
      "Override": {
        "Microsoft": "Warning",
        "System.Net": "Warning"
      }
    },
    "WriteTo": [
      {
        "Name": "File",
        "Args": {
          "path": "C:\\CinchyLogs\\Cinchy\\log.json",
          "formatter": "Serilog.Formatting.Compact.CompactJsonFormatter, Serilog.Formatting.Compact"
        }
      }
    ]
  }

You can also use an alternative setting if you want to have rolling log files with retention settings by adding in the following parameters:

          "preserveLogFilename": true,
          "shared": "true",
          "rollingInterval": "Day",
          "rollOnFileSizeLimit": true,
          "fileSizeLimitBytes": 100000000,
          "retainedFileCountLimit": 30,

• Your full "Serilog" property, if you choose to use the alternative settings, would look like this, inputting your own variables as required:

"Serilog": {
    "MinimumLevel": {
      "Default": "Debug",
      "Override": {
        "Microsoft": "Warning",
        "System.Net": "Warning"
      }
    },
    "WriteTo": [
      {
        "Name": "File",
        "Args": {
          "path": "C:\\CinchyLogs\\Cinchy\\log.txt",
          "preserveLogFilename": true,
          "shared": "true",
          "rollingInterval": "Day",
          "rollOnFileSizeLimit": true,
          "fileSizeLimitBytes": 100000000,
          "retainedFileCountLimit": 30,
          "formatter": "Serilog.Formatting.Compact.CompactJsonFormatter, Serilog.Formatting.Compact"
        }
      }
    ]
  }

1.4 Configuring the IIS Manager and Running your Upgrade

1. Open your Internet Information Services (IIS) Manager.

2. Navigate to Connections > Sites.

3. Right click on the Cinchy site and select Manage Application > Advanced Settings.

4. Change the Cinchy folder path to that of the version you're deploying.

5. Right click on the CinchySSO site and select Manage Application > Advanced Settings

6. Ensure that both Applications Pools for Cinchy and CinchySSO have their .NET CLR Versions set to No Managed Code.

7. Change the Cinchy SSO folder path to that of the version you're deploying.

8. Execute the following command:

iisreset -stop 

9. Execute the following command:

iisreset -start 

10. Open your Cinchy URL in your browser.

11. Ensure that you can log in.

1. Overview

AKS (Azure Kubernetes Service) is a managed K8 service used when deploying Cinchy v5 over Azure. Once you have deployed your v5 instance of Cinchy, you may want to upgrade your AKS to a newer version. You can do so with the below guide.

2. Prerequisites

Before proceeding for the AKS version upgrade, ensure that you have enough IP address space, as this process will need to start new nodes and pods.

You will need more than 1024 IP addresses in total when you have single Cinchy instance/environment.

If you have limited IP address space, you can upgrade the master node and then the worker node pools one by one.

Upgrading AKS

1. Navigate to your ArgoCD Dashboard.

2. Find and click on your Istio app > disable auto-sync.

3. Find and click on your Istio-ingress app > disable auto-sync.

4. Open a terminal and run the following command to get the currently available Kubernetes versions for AKS, inputting your AKS cluster name and resource group where specified:

5. Within your cinchy.devops.automations folder/repo, navigate to the deployment-azure.json file and change the values for kubernetes_version and orchestrator_version to the currently available Kubernetes version found in step 4.

6. Within the cinchy.devops.automations folder/repo, run the following command to push your new values:

7. Within your cinchy.terraform/azure/aks_cluster/ directory, run bash create.sh and accept the change.

8. AKS has three node pools, one node pool per availability zone. Terraform will now start the upgrade of the master node and the zone1 node pool.

9. Verify which nodes that the istio-ingressgateway and istiod pods are running on with below command.

10. In the output you will see aks-zone1/2/3-xxxxx under the Nodes column.

If one or both pods are running on aks-zone1-xxxxx then you need to scale up replicas 2 by following steps 12-14. If not, skip to step 15.

11. Use the following command to start replica on zone2 or zone3 nodes; once you scale down it will terminate from zone1 upgrading nodes.

12. Verify that new pods are running on other node pool by running the following command:

13. Run the following command to scale it back. This will remove the pod from cordoned node:

14. Once Maser node and zone1 upgrade is done, you will see a message such as:

15. The Terraform script will continue with the zone2 and zone3 node pool upgrade. You will see messages like the below when thee zone2 and zone3 node pool upgrade is in process:

16. Repeat steps 11-13. This will make sure that istio-ingressgateway and istiod are running on zone1 nodes.

17. Return to your ArgoCD dashboard and re-enable the auto sync for Istio and Istio-ingress apps auto sync on argocd dashboard.

1. Overview

The pages under this section can be used to help guide you through an upgrade of your Cinchy instance on IIS.

1. Upgrading on IIS

The following process can be run when upgrading any v5.x instance to Cinchy v5.3 on IIS.

1.1 Prerequisites

1. Take a backup of your database.

2. Extract thefor the version you wish to upgrade to.

1.2 Upgrade Process

1. Merge the following configs with your current instance configs:

   • Cinchy/web.config

   • Cinchy/appsettings.json

   • CinchySSO/appsettings.json

   • CinchySSO/web.config

2. Execute the following command:

3. Replace the Cinchy and CinchySSO folders with the new build and your merged configs.

4. Execute the following command:

5. Open your Cinchy URL in your browser.

6. Ensure you can log in.

1. Upgrading on IIS

The following process can be run when upgrading any v5.x instance to v5.4 on IIS.

1.1 Prerequisites

1. Take a backup of your database.

2. Extract thefor the version you wish to upgrade to.

1.2 Upgrade Process

1. Merge the following configs with your current instance configs:

   • Cinchy/web.config

   • Cinchy/appsettings.json

   • CinchySSO/appsettings.json

   • CinchySSO/web.config

2. If you are upgrading to 5.4+ on an SQL Server Database, you will need to make a change to your connectionString in both your SSO and Cinchy appsettings. Adding will allow you to bypass the certificate chain during validation.

   Ex:

3. Execute the following command:

4. Replace the Cinchy and CinchySSO folders with the new build and your merged configs.

5. Execute the following command:

6. Open your Cinchy URL in your browser.

7. Ensure you can log in.

1. Upgrading on IIS

The following process can be run when upgrading any v5.x instance to v5.5 on IIS.

1.1 Prerequisites

1. Take a backup of your database.

2. Extract thefor the version you wish to upgrade to.

1.2 Upgrade Process

1. Merge the following configs with your current instance configs:

   • Cinchy/web.config

   • Cinchy/appsettings.json

   • CinchySSO/appsettings.json

   • CinchySSO/web.config

2. If you are upgrading to 5.5 on an SQL Server Database and did not do so in any previous updates, you will need to make a change to your connectionString in both your SSO and Cinchy appsettings. Adding will allow you to bypass the certificate chain during validation.

   Ex:

3. Execute the following command:

4. Replace the Cinchy and CinchySSO folders with the new build and your merged configs.

5. Execute the following command:

6. Open your Cinchy URL in your browser.

7. Ensure you can log in.

1. Upgrading on IIS

The following process can be run when upgrading any v5.x instance to v5.6 on IIS.

1.1 Prerequisites

1. Take a backup of your database.

2. Extract thefor the version you wish to upgrade to.

1.2 Upgrade Process

1. Merge the following configs with your current instance configs:

   • Cinchy/web.config

   • Cinchy/appsettings.json

   • CinchySSO/appsettings.json

   • CinchySSO/web.config

2. If you are upgrading to 5.6 on an SQL Server Database and did not do so in any previous updates, you will need to make a change to your connectionString in both your SSO and Cinchy appsettings. Adding will allow you to bypass the certificate chain during validation.

   Ex:

3. When upgrading to 5.6, you are required to make the following changes to various appsettings.json files:

1. Execute the following command:

1. Replace the Cinchy and CinchySSO folders with the new build and your merged configs.

2. Execute the following command:

1. Open your Cinchy URL in your browser.

2. Ensure you can log in.

Table of Contents

1. Upgrading to v5 on Kubernetes

When you upgrade to Cinchy v5 on Kubernetes you are creating a separate instance. You will need to plan the migration of your database, and then follow the deployment installation guide.

2. Upgrading to v5 on IIS

To upgrade from v4+ to v5+ on IIS, review the documentation here.

3. Compatibility Issues Between Databases/Versions

If you choose to upgrade to Cinchy v5 on PostgreSQL, please review the following features that are not currently available in that deployment.

These may be implemented in future versions of the platform.

• No Partitioning

• No Geospatial

• No Column Indexing

• No Full Text Indexing

• No Column Level Encryption

You may also wish to review the list of CQL functions currently unsupported in PGSQL. Please note that this is a living document and that the development team is actively working on function translations between databases. Make sure to check back for the most up to date information.

• CQL Functions