Tick all three options under Objects to Export:

• Dump Stored Procedures and Functions
• Dump Events
• Dump Triggers

As part of the backup process with regards to Curator services, it is recommended to make a backup of the Solr folder structure in the event of needing to roll back. 

Note: This is a manual step and should only be attempted when the Curator Server Service has been stopped, making a backup copy while it is running may lead to corruption of the copied database.

By default, the Solr folder to copy is found here: C:\Program Files\IPV\Curator\Server\Solr\server\

Copy the entire Plugins folder to a safe location.

Browse to:

%ROOT_TO_INETPUB%\inetpub\wwwroot\CuratorClipSelect  

The Microsoft Visual C++ Runtime libraries are required. Download and run the installers using the links below and accept default settings.

Visual Studio 2013 C++ Redistributable can be downloaded from Microsoft's Website.

Visual Studio 2015-2019 C++ Redistributable can be downloaded from Microsoft's Website.

Only install Apple's ProRes codecs if the system needs to support ProRes material - this is an optional component that only applies to XCode machines.

The ProRes codecs are included as "QuickTime Essentials" within the QuickTime installer from Apple's Website.

Click Install IIS to look at a detailed install guide if required.

IIS (Internet Information Services) is a webserver which can be selected as a Server Role in the OS Server Manager.

Add all dot net options to the default features and select all the Application Development options under Role Services when prompted.

WebDeploy is an IIS tool that enables Curator Web applications to be easily imported into the webserver.

Download the 64-bit installer from Microsoft's official website.

Note: You may already have WebDeploy installed as part of your previous install.
Please ensure you have upgraded to version 3.6 Refer to the guide here on how to upgrade if necessary.

URL Rewrite is a module for IIS

Download an installer from Microsoft's Website.

Java provides features to the Curator Server Service.

Click here to view the recommended Java options.

Some IPV Services require the MySQL relational database.

Download the installer from MySQL's Official Website.

Ghostscript is a standalone installer required for creating thumbnail previews of graphic files, providing support for .ai,  .eps and .psd files. Download version 9.25 from Ghostscripts github. 

Sept 2022 Note: gs9561w64.exe has been downloaded and tested from Ghostscript : Downloads.

Note that this test has been completed using the GNU Affero General Public License version, NOT the Artifex Commercial License which is likely required to be a paid for licence in order to download and install for commercial entitles in this respect. 

 Erlang 

- During the upgrade to this release, you MUST delete the Solr Core located in [installation path]\Curator\Server\Solr\server\solr\. From here, delete the  curator_2_4 folder. The correct Core will be generated by starting the service.

1. Ensure that curatordb has been backed up. If there is no backup, then manually create one before upgrading Curator Server.
2. In Workbench - close the Database Connection (if already open)
3. Under the Home tab, go to the edit menu > preferences and access the SQL Editor on the left.
4. Increase the timeout. To do this, under MySQL Session on the right, update the 3x (in seconds) values dramatically, by a factor of 10 or even 100 (at least temporarily).
5. On the right scroll down and under Other UNTICK Safe Updates
6. Click OK for these settings to take effect.
7. Open the Database Connection.
8. Double click and expand the Curator Server Database on the left.
9. From the File menu in the database tab select Run SQL Script and select the Sql\Upgrade\UpgradeV2-7ToV3-0[manual].sql script provided in Curator Server installation path, ensure the correct database is selected and press Run.

Click Test Connection: 
 
A dialog box will appear confirming if the credentials are valid: 

If the MySQL Dump Fullpath field is not already configured as shown in the screenshots, find the MySQL installation directory and the mysqldump.exe file under the Bin folder.

After confirming valid details, click Next:

Note: Do not change the Solr core configuration. Solr is installed alongside Curator Server.

Enter an SSL certificate thumbprint for setting up HTTPS connectivity.

For finding a Certificate thumbprint, click here. 

 

Change the Curator Gateway host with the IIS hosts FQDN/IP.

Replace:

https://localhost/CuratorGateway 

With:

https://IIS_HOST/CuratorGateway 

Once the helper scripts have been run and the database version is up-to-date, start the Curator Server Service.

To do this, load the Services list and start IPV Curator Server:

Device Director requires the following prerequisites:

• .NET 4.7.2
• WebDeploy 3.6
• MySQL

Change the Curator Gateway host with the IIS host FQDN/IP.

Replace:

https://localhost/CuratorGateway 

With:

https://IIS_HOST/CuratorGateway

The Client Id for IPV Device Director Service and Client Secret for IPV Device Director Service should be entered here to allow Device Director to use Curator Gateway authentication.

To find these, go to the Curator Gateway Clients tab and select Device Director Service from the list, then copy the Id and Secret values using the copy to clipboard icon to the right of each value.

If the Secret value is not yet present, this will need to be set for this client.

The client secret can be set by selecting the edit icon to the right of the Device Director Service client and saving without making any changes.

This will generate the Secret where this is not yet present, which you will then be able to copy.

Process Engine Service requires the following Prerequisites.

•  .NET 4.7.2
• WebDeploy 3.6
• MySQL
• GhostScript

Change the Curator Gateway host with the IIS hosts FQDN/IP.

Replace:

https://localhost/CuratorGateway 

With:

https://IIS_HOST/CuratorGateway 

Process Designer requires the following Prerequisites.

•  .NET 4.7.2
• WebDeploy 3.6
• MySQL
• GhostScript

XCode has the following required prerequisites:

• Licence Manager

XFer requires the following Prerequisites.

•  .NET 4.7.2

Remove and Import the following applications:

• Curator Clip Link
• Curator Clip Select
• Curator Gateway
• Curator Logger
• Device Director Website
• Process Engine Monitor
• XChange Manager Website

Import the following application: 

• Curator File Service (Click here for a guide)

Use WebDeploy to import the new version.

For a reminder on how to import applications in IIS, click here.

Additional web.config modification is needed in systems running Curator 3.4 or newer with CSA version 1.6 where the TSL1 has been removed as is possible from Curator 3.4 onwards. This will be automatically set from CSA 2.0 (scheduled for Curator 3.6)

The CSA 1.6 web.config needs to be modified where TSL1 is not available. You will need to add the following two lines to the CSA web.config file:

<add key="AppContext.SetSwitch:Switch.System.Net.DontEnableSchUseStrongCrypto" value="false" />
<add key="AppContext.SetSwitch:Switch.System.Net.DontEnableSystemDefaultTlsVersions" value="false" />

For Curator Connect

Open Curator System Administrator navigating to the configuration tab

Note: If upgrading from any previous release of this product on a PC, please uninstall the previous release and check that the following folder locations are empty before attempting to install this version:
- C:\Program Files\Adobe\Common\Plug-ins\7.0\MediaCore
- C:\Program Files\IPV\IPV Curator For Adobe\ 
Also delete: C:\Users[user]\AppData\Roaming\IPV\Premiere Extensions\IPVExtension.config.json
This will ensure correct installation, especially of the correct importer and exporter components (which cannot be directly visually verified)

Start Curator Server

Browse to:

http://localhost/ProcessEngineMonitor/Modules 

Browse to the Process Engine install directory and select the corresponding version package ( x.y.z.a and in the image below replaced by the version of Workflows-Core  provided with your installation of the Process Engine e.g. 3.3.0.7)

%INSTALL_PATH%\Program Files\IPV\Process Engine Service\BundledModules\Workflows-Core-x.y.z.a.zip

Click Open.

Choose the appropriate Adobe workflow zip file, then click Open:

This is necessary where the site requires non-default settings.

• In Curator 3.5, by default, image Essence is not generated during the ingest. If Curator Clip Select is required you should alter StoreEssenceBlob to True in IMAGE-PROXY MediaStore.

Execute the steps on this page for the two folders listed below. The examples are on CuratorGateway but must also be applied to ProgramData\IPV:

• \inetpub\wwwroot\CuratorGateway
• \ProgramData\IPV

Under the root Windows install directory, find the ProgramData folder:

This folder is a hidden item. To show this folder, ensure hidden items are visible (these can be made visible from the View tab):

Click Add: 

Click Locations. If prompted to log in, provide valid credentials or credentials to the system, and select the host machine:In the object names field, enter IIS_IUSRS and click Check Names:When finished, click OK.

In Name, enter:

Access-Control-Allow-Headers

In Value, enter:

Range,Cache-Control

 
Click OK to confirm.

In Name, enter: 
Access-Control-Allow-Origin

In Value, enter the server name hosting the IIS.

Alternatively, "*" can be used for all hosts but poses security risks: 
http://IIS_HOST 
Click OK to confirm. 

Change the maxRequestEntityAllowed value (if not already set) to: 4294967295

Change the uploadReadAheadSize value from: 49152

To: 2147483647

Expand requestLimits and change the maxAllowedContentLength value from: 30000

To: 4294967295 

Additional web.config modification is needed in systems running Curator 3.4 or newer with CSA version 1.6 where the TSL1 has been removed as is possible from Curator 3.4 onwards. This will be automatically set from CSA 2.0 (scheduled for Curator 3.6)

The CSA 1.6 web.config needs to be modified where TSL1 is not available. You will need to add the following two lines to the CSA web.config file:

<add key="AppContext.SetSwitch:Switch.System.Net.DontEnableSchUseStrongCrypto" value="false" />

<add key="AppContext.SetSwitch:Switch.System.Net.DontEnableSystemDefaultTlsVersions" value="false" />

Replace

"Thumbnail VTT Location" key value

Search for the ThumbnailVttLocation key and replace the value with the fully qualified domain name for the webserver and the virtual directory configured during the ingest functionality deployment.

Replace:

<add key="ThumbnailVttLocation" value="https://WEBSERVER/Proxies/WebProxy/{proxy-path}/{name}/{name}_thumbnail.vtt" />

With:

<add key="ThumbnailVttLocation" value="https://IIS_HOST/Proxies/WebProxy/{proxy-path}/{name}/{name}_thumbnail.vtt" />

Search for:  

<OpenInLogger url="https://localhost/CuratorLogger/Log?assetId={id}" enabled="true" />

Setting (enabled="false") will hide the option in the Clip Link menu.

If Logging is required, replace localhost with the webserver hosting the logger application and set enabled="true":

<OpenInLogger url="https://IIS_HOST/CuratorLogger/Log?assetId={id}" enabled="true" />

Find the following keys and replace the value with the required metadata views:

<add key="SearchFilterViewName" value="SearchLevelView" />

Find the PinnedSearches tag and add all the missing lines below the cleartag:

<pinnedSearches>
<searches>
<clear />
<add imageFileName="Example.svg" tooltip="Example Search" searchParameters="?assetFilter=159&amp;s=ingestdate&amp;d=descending" />

Find the AddToCollection tag and change the values as required, adding missing metadata names within the Path Metadata tag if necessary.

<AddToCollection>
<MetadataView name="Collections" />
<BaseLocation name="Library" /
<PathMetadata>
<Metadata name="CollectionType" />
<Metadata name="CollectionDestination" />
<Metadata name="Priority" />
</PathMetadata>
</AddToCollection>

If you are upgrading a site where non-default tabs or views are configured, please note that as of Clip Link 3.3, the xml tags have changed from <View name=... /> to <Tab name=... /> (see the current form below).

NOTE: Do not copy over old lines of configuration file.

If you wish to configure additional or different metadata views in tabs, find the <AssetInfo> tag in web.config and configure this providing your view of choice, the name of the tab and whether to display metadata from the asset or its parent in this tab. With parent="true" for clipmarks this will be media metadata and nothing will display for popped up media, audio or images.

<AssetInfo>
<Tabs>
<Tab name="ViewName1" display="Displayed Name of Tab1" parent="false"/>
<Tab name="ViewName2" display="Displayed Name of Tab2" parent="false"/>
</Tabs>
</AssetInfo>

Replace any missing images in:

%INSTALL_PATH%\inetpub\wwwroot\CuratorClipLink\Content\Images\PinnedSearches\

Replace any missing custom plugins in the plugins top-level folder:

%INSTALL_PATH%\inetpub\wwwroot\CuratorClipLink\Plugins\

On the IIS server, open IIS manager and browse to the Curator Logger directory by right-clicking and selecting the Explore option: 

Open the web.config file in a text editor.

Replace

"Video Server

Address" key value

Set the value for the VideoServerAddress key with the fully qualified domain name for the IIS host.

Replace: 

<add key="VideoServerAddress" value="https://WEBSERVER" /> 

With:

<add key="VideoServerAddress" value="https://IIS_HOST" />

Replace

"Thumbnail Vtt Location" key value

Search for the ThumbnailVttLocation key and replace the value with the fully qualified domain name for the webserver and the virtual directory configured during the ingest functionality deployment.

Replace:

<add key="ThumbnailVttLocation" value="https://WEBSERVER/Proxies/WebProxy/{proxy-path}/{name}/{name}_thumbnail.vtt" />

With:

<add key="ThumbnailVttLocation" value="https://IIS_HOST/Proxies/WebProxy/{proxy-path}/{name}/{name}_thumbnail.vtt" />

Uninstall Apache

Open a Command Prompt window and execute the following two lines separately:

cd C:\Apache24\bin

.\httpd.exe -k uninstall

Remove Apache files

After Apache has been uninstalled, close the open Command Prompt window. It is now safe to delete the Apache24 folder.

Open Programs and Features

Open Control Panel and go to Programs and Features:

Uninstall ActivePerl

Right-click on ActivePerl and click Uninstall. To the prompt, click Yes.