v5.14 (IIS)

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

AppSetting changes

The upgrade of any version to Cinchy v5.14.x may require changes to be made to various AppSetting files.

Prerequisites

info

If you have made custom changes to your deployment file structure, please contact your Support team before you upgrade your environments.

• Download the latest Cinchy Artifacts from the Cinchy Releases Table > Release Artifacts column. Check this into your file repository and make note of the path so that you can easily find it again later. (For example: /Users/juliet/Desktop/Upgrades/Cinchy v5.14.x)
• Download the following if not already installed. Note that Cinchy v5.13+ has been updated from .NET 6 to .NET 8.
  • ASP.NET Core 8.0 Runtime (v8.0.x) Windows Hosting Bundle

Considerations

Depending on your current version, you may need to:

• Run the 5.2 upgrade script
• Run the 5.5 upgrade script
• Make changes to your connection string:

If you are upgrading from 5.0-5.3 to 5.14.x on an SQL Server Database, you will need to make a change to your connectionString in your SSO and Cinchy appsettings.json. Adding TrustServerCertificate=True will allow you to bypass the certificate chain during validation.

Ex:

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

Considerations Table

Current Version	Run the 5.2 Upgrade Script	Run the 5.5 Upgrade Script	Connection String Changes (SQL Server DB)
5.0	Yes	Yes	Yes
5.1	Yes	Yes	Yes
5.2	X	Yes	Yes
5.3	X	Yes	Yes
5.4	X	Yes	X
5.5	X	X	X
5.6	X	X	X
5.7	X	X	X
5.8	X	X	X
5.9	X	X	X
5.10	X	X	X
5.11	X	X	X
5.12	X	X	X
5.13	X	X	X

Upgrade process

1. Take a backup of your database.
   1. For an example on how to do so using SQL Server Management Studio, click here.
2. Navigate to the new Cinchy v5.14.x folder that was downloaded in the Prerequisites section of this guide.
3. From within the Cinchy v5.14.x folder, navigate to the /Cinchy v5.14.x/Cinchy/appsettings.json file.
4. Open the file in the text compare or merge utility tool of your choosing. (For example: VS Code.)
5. Open the matching file from your current configuration files, for example /Cinchy v5.13/Cinchy/appsettings.json, in the same text compare or merge utility tool.
6. Compare your old configuration to the new one, merging your settings into /Cinchy v5.14.x/Cinchy/appsettings.json. For instructions on doing this with VS Code, click here.

For example, in the below screenshot we have opened two files in VS Code to compare: /Cinchy v5.13/Cinchy/appsettings.json and /Cinchy v5.14.x/Cinchy/appsettings.json.

The utility tool identifies any differences between the two files and highlights them in red; in this case our config information. Using the right arrow that appears between the two configs, we can tell VS Code to merge the differences from the 5.13 file into the 5.14.x file. This prevents the manual re-entry of data.

Make sure to take note of any new section(s) that might appear in the 5.14.x config as well, inputting values as necessary.

After repeating this for all of the differences, save the /Cinchy v5.14.x/Cinchy/appsettings.json file.

4. Repeat this process for the following configuration files, comparing and merging your settings into the new files:

   • /Cinchy v5.14.x/Cinchy/web.config
   • /Cinchy v5.14.x/CinchySSO/appsettings.json
   • /Cinchy v5.14.x/CinchySSO/web.config

5. If you are upgrading to v5.14.x and didn't do so in any previous updates, you are required to make some changes to various appsettings.json files. These changes are outlined in the following sections:

   • CinchySSO\appsettings.json
   • Cinchy\appsettings.json
   • Worker Directory appsettings.json

6. Navigate to your Connections Server. Stop the following services by clicking on them and then the square stop icon in the task bar:

   1. Cinchy Listener service.
   2. Cinchy Worker service.

7. If there are any sync jobs scheduled in the Windows Task Scheduler:

   1. Make a note of which jobs are scheduled, as a backup.
   2. Disable the jobs.

8. As an administrator, open a command line/terminal and execute the following command:

iisreset -stop

9. Navigate to your Database Server.
10. Stop the SQL Server Cinchy Database by right-clicking it and selecting Stop.
11. Replace your current/old Cinchy and CinchySSO folders with the new 5.14.x folders, i.e. /Cinchy v5.14.x/Cinchy and /Cinchy v5.14.x/CinchySSO.
12. Start the SQL Server Cinchy Database by right-clicking it and selecting Start.
13. As an administrator, open a command line/terminal and execute the following command:

iisreset -start

14. Re-enable any jobs in the Task Scheduler.
15. Navigate to your Connections Server. Start the following services by clicking on them and then the triangle start icon in the task bar:
    1. Cinchy Listener service.
    2. Cinchy Worker service.
16. Open your Cinchy URL in your browser.
17. All users must log out and back in to your Cinchy environment in order for the changes to properly take effect.

Event Listener Service Change

The following needs to be done only if you did not do so in a previous upgrade.

When upgrading Cinchy Event Listener from v5.9 (or lower) to v5.10+, note that the service name has changed. To ensure this change is properly reflected in the Windows Service, you need to follow these steps:

1. Open a PowerShell 5.1 terminal within the CinchyEventListener deployment directory.
2. Run the PowerShell file remove-cinchy-event-listener-windows-service.ps1.
3. After removing the service, run the PowerShell file create-cinchy-event-listener-windows-service.ps1 "path to CinchyEventListener".

If your Cinchy Event Listener is using a trusted connection, remember to update these details for the CinchyENV Event Listener service in the Services.msc control panel.

Support

If you encounter an error during this process, restore your database backup and contact Cinchy Support.