Differences

This shows you the differences between two versions of the page.

--- software:website [2023/10/25 23:35] – [TLS/SSL Certificates] smartin015
+++ software:website [2024/12/28 18:10] (current) – [Tools & Equipment] airtable -> http://protohaven.org/maintenance kathryn.mazaitis
@@ Line 29: / Line 29: @@
 === Certificate Refresh Directions ===
+**Note: For two years in a row, Namecheap has failed the auto CSR signing process with an internal error. This has required reaching out to support to do the verification manually. The process takes up to 1-2 business days on the Certificate Authority Sectigo end; requirements can be checked here: https://www.namecheap.com/support/knowledgebase/article.aspx/9502/68/what-do-i-need-to-validate-an-ov-certificate/. After the validation is finished and SSL is reissued, a follow-up email ticket gets sent to purchasing@protohaven.org**
   - Login to the accounts area at namecheap.com
@@ Line 35: / Line 37: @@
   - Click Generate, view, or delete SSL certificate signing requests.
   - Complete the CSR Form
-  - Include www.protohaven.org and protohaven.org in the domain section.
+    - Add "protohaven.org" and "www.protohaven.org" in the Domains text input, separated by a newline
-  - Complete City, State, Country, Company
+    - Pittsburgh, PA, US for city, state, country
-  - Do not set a passphrase
+    - Protohaven for company
-  - Generate CSR
+    - system@protohaven.org for email address
+    - Do not set a passphrase
+  - Click "Generate" to generate the CSR
   - Open the accounts area at namecheap.com in a new tab
-  - Click on the SSL Certificates section
+  - Click on the [[https://ap.www.namecheap.com/ProductList/SslCertificates|SSL Certificates section]]
   - Next to the protohaven.org entry click the down arrow and reissue.
-  - Open the csr file in a text editor and copy and paste the contents into the textarea where it says to enter the csr.
+  - Copy and paste the encoded contents of the CSR (including hyphenated header and footer) into the textarea where it says to enter the csr. Click Next.
-  - Ensure you have group membership in webmaster@protohaven.org (via admin.google.com) and set the DCV method to "receive an email" with webmaster@ as the target. The new cert will be sent to admin@protohaven.org.
+  - Ensure you have group membership in webmaster@protohaven.org (via admin.google.com) and set the DCV method to "receive an email" with webmaster@ as the target. Click Next.
+  - Fill in representative information, click Next.
+  - Review and click Submit.
   - https://www.namecheap.com/support/knowledgebase/article.aspx/9418/33/installing-an-ssl-certificate-on-your-server-using-cpanel/
-  - After the new certificates are minted download and extract the zip file.
+  - After the new certificates are minted download and extract the zip file. As of 2024 this is done in the [[https://ap.www.namecheap.com/ProductList/SslCertificates|SSL Certificates]] NameCheap page.
   - Go back to the other tab where the cpanel TLS pages are and go to: Generate, view, upload, or delete SSL certificates.  (Many of these pages have a “go back” link at the bottom if you’re feeling lost.)
   - In the section where it says upload new certificate choose to upload the protohaven_org.crt file and click upload certificate.
@@ Line 122: / Line 128: @@
 ===== Integrations with Other Systems =====
 ==== Set Equipment Status from Airtable ====
-Any time the status of equipment is changed in airtable with the [[https://airtable.com/shrBGlpdm2XlwlsUw|Set Tool Status Form]] it will trigger an [[https://airtable.com/appbIlORlmbIxNU1L/wflMSK4FI3BNnUGrZ/wacs6sv2EgMprI7zH|automation in Airtable]] that will set the reservable status in Booked to match.  The source code is [[https://github.com/protohaven/systems-integration/blob/main/airtable-automations/UpdateBookedStatus.js|managed in our Github]].
+Any time the status of equipment is changed in airtable with the [[https://protohaven.org/maintenance|Set Tool Status Form]] it will trigger an [[https://airtable.com/appbIlORlmbIxNU1L/wflMSK4FI3BNnUGrZ/wacs6sv2EgMprI7zH|automation in Airtable]](**automation link may be outdated as of Dec 2024**) that will set the reservable status in Booked to match.  The source code is [[https://github.com/protohaven/systems-integration/blob/main/airtable-automations/UpdateBookedStatus.js|managed in our Github]].
 The booked credentials that Airtable uses to auth with booked is the airtableapi user.
@@ Line 133: / Line 139: @@
 Constiuient user login here: https://protohaven.app.neoncrm.com/login
+Testing users:
+  * Test Member (has active membership) https://protohaven.app.neoncrm.com/admin/accounts/1797
+  * Testing Nonmember (membership is expired) https://protohaven.app.neoncrm.com/admin/accounts/1727
 ===== API Keys =====
 Below are various API keys that are setup so that other programs are able to interact with Neon.
@@ Line 172: / Line 181: @@
   * [[https://airtable.com/shr0Oji4gCWFi0b9N|Protohaven Tool List]]
   * [[https://airtable.com/shr9Hbyf7tdf7Y5LD|Current Tool Status]]
-  * [[https://airtable.com/shrluff2WSzy8c3xd|File Tool Report]]
+  * [[http://protohaven.org/maintenance|File Tool Report/Set Tool Status]]
-  * [[https://airtable.com/shrBGlpdm2XlwlsUw|Set Tool Status]]
   * [[https://airtable.com/shr216hqgOdWSsRY6|New Recurring Task]]
-  * [[https://airtable.com/shrxigAGlM9XSsjQD|New Occasional Task]]
+  * <del>[[https://airtable.com/shrxigAGlM9XSsjQD|New Occasional Task]]</del> (no longer working, Dec 2024)
-  * [[https://airtable.com/shrArOIPjLpfquJMC|Trigger Occasional Tasks]]
+  * <del>[[https://airtable.com/shrArOIPjLpfquJMC|Trigger Occasional Tasks]]</del> (no longer working, Dec 2024)
 === Automations ===