System access has been restored, and the public-facing reports are available again. I have sent the "end of outage" notice.

Before starting the migration work, I made copies of the public-facing CSV reports, and they are available at the links below.

CSV Format of Spreadsheet of Included CA Certificates
https://drive.google.com/file/d/0Bx-tHXMAwqU3eDN1SHZoN3FUUVk/view?usp=sharing

CSV Format of Report on Upcoming Root Inclusions
https://drive.google.com/file/d/0Bx-tHXMAwqU3N3FDNDhYLXVQUUk/view?usp=sharing

CSV Format of Spreadsheet of Pending CA Certificate Requests
https://drive.google.com/file/d/0Bx-tHXMAwqU3WGdmMDBCUEZPQkU/view?usp=sharing

CSV Format of Spreadsheet of Removed Root Certificates
https://drive.google.com/file/d/0Bx-tHXMAwqU3eElKVTd0SjBkUk0/view?usp=sharing

CSV Format of Upcoming Root Cert Removals
https://drive.google.com/file/d/0Bx-tHXMAwqU3RTYwRTlEbTgxX0E/view?usp=sharing

CSV version of the Spreadsheet of Intermediate CA Certificates with PEM
https://drive.google.com/file/d/0Bx-tHXMAwqU3c3NJQ29sRVRfUms/view?usp=sharing

CSV version of the Spreadsheet of Revoked Intermediate CA Certificates
https://drive.google.com/file/d/0Bx-tHXMAwqU3WDlwYnEwUEh1aXM/view?usp=sharing


Please let me know if you notice any issues with the merged data.

Thanks,
Kathleen


On 6/29/16 9:00 AM, Kathleen Wilson wrote:
The data migration has happened, and I have reviewed the data in the
production DB. We will need to do some tweaking/fixing over then next
couple of weeks, but I think we're good to go.

So, we will begin restoring access to the system, and I will send the
"end of service outage" notice as soon as it has all been restored.

Kathleen


On 6/28/16 8:57 PM, Kathleen Wilson wrote:
All,

The signature that we were waiting for has happened, so we will continue
with the data migration. The public-facing reports will not be available
when the data import is happening, and until we have verified the data.

Kathleen


On 6/28/16 7:56 PM, Kathleen Wilson wrote:
All,

I apologize for the delay. We are waiting for a signature on the
agreement that must be completed before we can import the Microsoft root
store data into production. It is looking like we may have to wait until
tomorrow morning (PDT).

In the meantime, public-facing reports are working, but access to the
system is very limited because we don't want any changes going into the
system until we finish the data import.

I will provide status updates as things progress.

Kathleen



On 6/28/16 8:29 AM, Kathleen Wilson wrote:
The work on this data migration is starting now. The CA Community in
Salesforce (a.k.a. the Common CA Database) will be offline while we do
this data migration.

I have kicked off the process to send an email with subject
"CA Community in Salesforce - Planned Outage - Starting Now"
to everyone who has a login to the CA Community in Salesforce.

Kathleen



On 6/27/16 3:56 PM, Kathleen Wilson wrote:
All,

We are planning to do the import of the data corresponding to
Microsoft's root store program into the CA Community in Salesforce,
with
the hopeful start time of 8:00am PDT on Tuesday, June 28. We expect
the
work to take 8 to 10 hours.

I understand that many of you are working to get your intermediate
certificate data entered by the end of June, so I will grant a
reprieve
of a few days for those of you who are impacted by the system being
down
tomorrow. Also, I had to postpone some of the mass importing of
intermediate certificate data, and will resume that when I return from
vacation. So, please understand that our target date of having the
intermediate cert data entered by June 30 will be delayed a bit
longer.

Jody and I are hoping to get his data imported tomorrow, so that we
have
a day to recover and handle any fine tuning, before I go on
vacation. We
decided not to wait until after my vacation, because Jody has a lot of
work to do on restoring his data, hopes to do the work once (not
have to
repeat), and wants to get started as soon as possible. We were
hoping to
get this data import done much earlier, but there have been unforeseen
delays.

Below is the draft of the mass email that I plan to send to everyone
who
has access to the CA Community in Salesforce -- one message will be
sent
at the beginning of the data migration, and the other at the end.

Please let me know if you have any feedback on this.

Thanks,
Kathleen

== At beginning of migration day ==

Dear Certification Authority,

Today, {!Today}, the Common CA Database (a.k.a. CA Community in
Salesforce) will be offline while we import Microsoft’s root store
data
into the production database.

During that time, the following things will happen:
1) You will not be able to login to the CA Community in Salesforce.
2) The urls to Mozilla’s public-facing reports will not work.

Background on the Common CA Database may be found here:
https://wiki.mozilla.org/CA:CommonCADatabase:RootStoreOperators

I will send another email as soon as the data migration has been
completed.

I apologize for any inconvenience this causes.

Regards,
Kathleen Wilson
Mozilla
CA Program Manager
==
== At end of migration day ==

Dear Certification Authority,

The work on the Common CA Database (a.k.a. CA Community in Salesforce)
has been completed. Your access to the system and Mozilla's
public-facing reports have been restored.

You may notice the following:
1) Microsoft’s root store data has been imported and merged, so there
are more CA Owner and Root Certificate records.
2) The “Status” field in the CA Owner and Root Certificate records has
been changed to “Mozilla Status”.
3) There is a “Microsoft Fields” section in the page layout for CA
Owner
and Root Certificate records, and those fields can only be edited by
Microsoft’s root store operator, Jody Cloutier.
4) There is a “Mozilla Fields” section in the page layout for the Root
Certificate records and those fields can only be edited by Mozilla’s
root store operator, Kathleen Wilson.
5) Mozilla’s public-facing reports should still only indicate
information pertaining to Mozilla’s root store.

Please reply to this email if you notice any issues with your CA’s
data,
or if you have any problems logging into the system.

Regards,
Kathleen Wilson
Mozilla
CA Program Manager
==








_______________________________________________
dev-security-policy mailing list
[email protected]
https://lists.mozilla.org/listinfo/dev-security-policy

Reply via email to