<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Qlik Sense Root CA certificate manually recreated query in Management &amp; Governance</title>
    <link>https://community.qlik.com/t5/Management-Governance/Qlik-Sense-Root-CA-certificate-manually-recreated-query/m-p/1693933#M16021</link>
    <description>&lt;P&gt;We have upgraded DEV server to Nov’19 Patch 6 version . And followed manual steps to remove and recreate Root CA certificate.&lt;/P&gt;&lt;P&gt;I can see the following change in the Root CA certificate-&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Old Certificate&lt;/STRONG&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sharanh_0-1587022773474.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/31920i337C4F902D5E18DC/image-size/medium?v=v2&amp;amp;px=400" role="button" title="sharanh_0-1587022773474.png" alt="sharanh_0-1587022773474.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;STRONG&gt;New Certificate&lt;/STRONG&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sharanh_1-1587022773481.jpeg" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/31919i807ED7F378E0C076/image-size/medium?v=v2&amp;amp;px=400" role="button" title="sharanh_1-1587022773481.jpeg" alt="sharanh_1-1587022773481.jpeg" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;However, in the document Qlik has mentioned following –&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Finally, check that Basic Constraints attribute, and make sure it contains both of the following values "CA:TRUE;critical". If it does not, then this certificate is affected by the change.&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Its only that one difference in&lt;STRONG&gt; Root CA certificate’s Basic Constraints attribute value&lt;/STRONG&gt; that we need advice on because it is suggested some different value in Qlik’s document for validation.&lt;/P&gt;&lt;P&gt;Is our root CA certificate created fine ?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Steps followed –&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Installed Nov’19 version and Patch 6.&lt;/LI&gt;&lt;LI&gt;Stopped all services&lt;/LI&gt;&lt;LI&gt;Manually took back up of certificates (as mentioned in Qlik Document)&lt;/LI&gt;&lt;LI&gt;Deleted ONLY Root CA certificate from CENTRAL server (no other certificates deleted as DEV is a single node set up with no NON-Central nodes)&lt;/LI&gt;&lt;LI&gt;Started Qlik repository Database service and ran the cmd command for certificate recreation as in the document-&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;&lt;STRONG&gt;&lt;EM&gt;"C:\Program Files\Qlik\Sense\Repository\Repository.exe" -bootstrap –iscentral&lt;/EM&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Started Dispatcher and other services.&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Everything is running fine on DEV post upgrade – Tasks , Apps, access etc.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks in Advance.&lt;/P&gt;</description>
    <pubDate>Sat, 16 Nov 2024 18:46:50 GMT</pubDate>
    <dc:creator>sharanh</dc:creator>
    <dc:date>2024-11-16T18:46:50Z</dc:date>
    <item>
      <title>Qlik Sense Root CA certificate manually recreated query</title>
      <link>https://community.qlik.com/t5/Management-Governance/Qlik-Sense-Root-CA-certificate-manually-recreated-query/m-p/1693933#M16021</link>
      <description>&lt;P&gt;We have upgraded DEV server to Nov’19 Patch 6 version . And followed manual steps to remove and recreate Root CA certificate.&lt;/P&gt;&lt;P&gt;I can see the following change in the Root CA certificate-&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Old Certificate&lt;/STRONG&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sharanh_0-1587022773474.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/31920i337C4F902D5E18DC/image-size/medium?v=v2&amp;amp;px=400" role="button" title="sharanh_0-1587022773474.png" alt="sharanh_0-1587022773474.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;STRONG&gt;New Certificate&lt;/STRONG&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sharanh_1-1587022773481.jpeg" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/31919i807ED7F378E0C076/image-size/medium?v=v2&amp;amp;px=400" role="button" title="sharanh_1-1587022773481.jpeg" alt="sharanh_1-1587022773481.jpeg" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;However, in the document Qlik has mentioned following –&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Finally, check that Basic Constraints attribute, and make sure it contains both of the following values "CA:TRUE;critical". If it does not, then this certificate is affected by the change.&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Its only that one difference in&lt;STRONG&gt; Root CA certificate’s Basic Constraints attribute value&lt;/STRONG&gt; that we need advice on because it is suggested some different value in Qlik’s document for validation.&lt;/P&gt;&lt;P&gt;Is our root CA certificate created fine ?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Steps followed –&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Installed Nov’19 version and Patch 6.&lt;/LI&gt;&lt;LI&gt;Stopped all services&lt;/LI&gt;&lt;LI&gt;Manually took back up of certificates (as mentioned in Qlik Document)&lt;/LI&gt;&lt;LI&gt;Deleted ONLY Root CA certificate from CENTRAL server (no other certificates deleted as DEV is a single node set up with no NON-Central nodes)&lt;/LI&gt;&lt;LI&gt;Started Qlik repository Database service and ran the cmd command for certificate recreation as in the document-&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;&lt;STRONG&gt;&lt;EM&gt;"C:\Program Files\Qlik\Sense\Repository\Repository.exe" -bootstrap –iscentral&lt;/EM&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Started Dispatcher and other services.&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Everything is running fine on DEV post upgrade – Tasks , Apps, access etc.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks in Advance.&lt;/P&gt;</description>
      <pubDate>Sat, 16 Nov 2024 18:46:50 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Management-Governance/Qlik-Sense-Root-CA-certificate-manually-recreated-query/m-p/1693933#M16021</guid>
      <dc:creator>sharanh</dc:creator>
      <dc:date>2024-11-16T18:46:50Z</dc:date>
    </item>
  </channel>
</rss>

