Uploaded image for project: 'EJBCA'
  1. EJBCA
  2. ECA-6777

Create new DB column for storing CSR in CertificateData

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: EJBCA 7.0.0
    • Component/s: None
    • Labels:
      None

      Description

      Premise

      Customer has requested that the CSR to a specific certificate be downloadable from the View Certificate page on the RA (see screenshot), rather than the View End Entity page as it is today, which will simply make available the latest known CSR to that EE. 

      Product Owner's Comments:

      This actually makes way more sense, so I agree that we should make this change. 

      Known Issues

      CSRs are currently saved in a field in the ExtendedInformation field in the EE, not in CertificateData. We need to figure out a good way of starting to store it there instead, either inside a freeform BLOB or in its own column. 

      Proposed Solution

      CSRs are currently saved in a field in the ExtendedInformation field in the EndEentity, not in CertificateData. Create new column "certificateRequest" type:LONGTEXT into CertificateData table (also into base64certdata and NoConflictCertificateData).

      CSR clearing in endEntity and downloading/accessing it from the certificate will be handled in tickets ECA-7608 and ECA-7693

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                tarmo_helmes Tarmo Raudsep
                Reporter:
                mikek Mike Agrenius Kushner
                Verified by:
                Henrik Sunmark, Samuel Lidén Borell
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 2 days
                  2d
                  Remaining:
                  Time Spent - 1 hour Remaining Estimate - 1 day, 7 hours
                  1d 7h
                  Logged:
                  Time Spent - 1 hour Remaining Estimate - 1 day, 7 hours
                  1h