Gravatar for jonathan@interactivestrategies.com

Question by jfolland, Jan 2, 2019 2:42 PM

Content Delivery Servers - Copying the Coveo Data Directory - Coveo for Sitecore 9

In the article, https://docs.coveo.com/en/2264/coveo-for-sitecore-v5/deploying-coveo-for-sitecore-on-the-content-delivery-servers, it states: "Coveo for Sitecore stores the encryption keys in the Properties table of the Core database. These keys must be the same on all the Sitecore instances to be able to decrypt the encrypted configuration elements."

What are the keys that must be the same? In the properties table in the core database, I find an entry for: CORE_ENCRYPTIONKEYS. I also find a number of entries COVEO*, but none seem to be encryption key like. Is the CORE_ENCRYPTIONKEYS item the one that needs to be synced?

2 Replies
Gravatar for hsantos@coveo.com

Answer by Hugo Santos, Jan 2, 2019 3:15 PM

Hi @jfolland,

You are right, the CORE_ENCRYPTIONKEYS is the one that the documentation is talking about.

Gravatar for jonathan@interactivestrategies.com

Comment by jfolland, Jan 2, 2019 9:05 PM

Is there an associated configuration? When I change this value, I am getting an error in DynamicPlaceholdersRenderingModel. A null reference exception on line 18:

Line 16:     <div class="component-content" @Html.Raw(backgroundStyle)>
Line 17:         @using (PlaceholderDatasourceContext.EnterContext(Model.Rendering.Item)) 
Line 18:         { @Html.Sitecore().Placeholder(key) }
Line 19:     </div>
Line 20: </div>


Gravatar for jonathan@interactivestrategies.com

Comment by jfolland, Jan 2, 2019 11:14 PM

When I update this value in my core database, this causes a null reference exception on line 18 below. Error while rendering view: '/Views/Coveo Hive/Resources/Coveo Search Resources.cshtml'. It occurs withing SXA container.cshtml. So I am guessing either that is the wrong property or there is something else that needs to be done in conjunction?


Line 16:     <div class="component-content" @Html.Raw(backgroundStyle)>
Line 17:         @using (PlaceholderDatasourceContext.EnterContext(Model.Rendering.Item)) 
Line 18:         { @Html.Sitecore().Placeholder(key) }
Line 19:     </div>
Line 20: </div>
Gravatar for jflheureux@coveo.com

Comment by Jean-François L'Heureux, Jan 3, 2019 11:03 AM

I thought Coveo encryption key was stored in the `encryptionKeys` property of the core database as mentioned in this other answer: https://answers.coveo.com/answers/12504/view.html

Gravatar for jonathan@interactivestrategies.com

Answer by jfolland, Jan 4, 2019 8:44 PM

I think the correct answer here is that the encryption keys are not used. I am not solidly confident in this; but, I have the content delivery server working and I can find no encryption keys (nor did I set any). I looked here:

In a file located Data\Coveo\ConfigurationEncryptionKeys

In the database:

SELECT [Key],[Value]
FROM [sitecore_Core].[dbo].[Properties] 
WHERE [key] like '%encryp%' or [key] like '%coveo%'
Gravatar for jflheureux@coveo.com

Comment by Jean-François L'Heureux, Jan 4, 2019 9:00 PM

They are used on a CD instance to read the encrypted API key in order to request search tokens for the visitors.

Ask a question