This topic is covered in Coveo documentation, but we found a quicker way to sync up Encryption Keys between all CMs and CDs. It might not be the best option if you are don't feel comfortable making database changes directly, but if you are confident in your SQL skills you might find the following script handy.
As Coveo documentation states the Encryption Keys values must match between all instances. By default, the key is generated at the first request and inserted into the Properties table in Sitecore Master or Web database depending on the version of Sitecore you are using.
The following SQL script will give you the value of the key:
SELECT TOP (1000) [ID]
,[Key]
,[Value]
FROM [Properties]
WHERE [Key] = 'WEB_ENCRYPTIONKEYS'
Copy the value of the "Value" column, update it in the following script and run it in all CM and CD Master or Web databases (depending on the Sitecore version).
UPDATE [Properties]
SET [Value] = 'MfAX2CR14H8mZFlzGoE6dEnLjXX48S5Ho2b/9RP7L7kl4LEg6CENyMCLx6kLjzh4'
WHERE [Key] = 'WEB_ENCRYPTIONKEYS'
Reset IIS in all instances.
As Coveo documentation states the Encryption Keys values must match between all instances. By default, the key is generated at the first request and inserted into the Properties table in Sitecore Master or Web database depending on the version of Sitecore you are using.
The following SQL script will give you the value of the key:
SELECT TOP (1000) [ID]
,[Key]
,[Value]
FROM [Properties]
WHERE [Key] = 'WEB_ENCRYPTIONKEYS'
Copy the value of the "Value" column, update it in the following script and run it in all CM and CD Master or Web databases (depending on the Sitecore version).
UPDATE [Properties]
SET [Value] = 'MfAX2CR14H8mZFlzGoE6dEnLjXX48S5Ho2b/9RP7L7kl4LEg6CENyMCLx6kLjzh4'
WHERE [Key] = 'WEB_ENCRYPTIONKEYS'
Reset IIS in all instances.
No comments:
Post a Comment