User Tools

Site Tools


software:website

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
software:website [2023/09/24 19:14] – ↷ Page moved from staff:website to software:website smartin015software:website [2024/12/28 18:10] (current) – [Tools & Equipment] airtable -> http://protohaven.org/maintenance kathryn.mazaitis
Line 29: Line 29:
  
 === Certificate Refresh Directions === === 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   - Login to the accounts area at namecheap.com
Line 35: Line 37:
   - Click Generate, view, or delete SSL certificate signing requests.   - Click Generate, view, or delete SSL certificate signing requests.
   - Complete the CSR Form   - Complete the CSR Form
-  Include www.protohaven.org and protohaven.org in the domain section. +    Add "protohaven.organd "www.protohaven.orgin the Domains text input, separated by a newline 
-  Complete CityStateCountryCompany +    PittsburghPAUS for citystate, 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   - 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.   - 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
-  - ??? Describe the submission part the next time we re-issue ??? +  - 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. 
-  - After the new certificates are minted download and extract the zip file.+  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. 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.)   - 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.   - In the section where it says upload new certificate choose to upload the protohaven_org.crt file and click upload certificate.
-  - Open the protohaven_org-ca_bundle file and copy the contents. 
-  - Paste the contents into the textarea for ca-bundle when given the opportunity. 
   - Once uploaded you’ll see a new entry under “Certificates on Server” with an expiry date 1 year from now.  Click Install.    - Once uploaded you’ll see a new entry under “Certificates on Server” with an expiry date 1 year from now.  Click Install. 
 +  - Paste the contents of protohaven_org-ca_bundle file into the textarea for ca-bundle if it isn't already populated.
   - It may take 5 minutes before the new cert is live on the server, check the server’s certificate and verify that the new expiry date is shown.   (Click on the lock icon by the protohaven.org domain on the web browser and view the certificate.)   - It may take 5 minutes before the new cert is live on the server, check the server’s certificate and verify that the new expiry date is shown.   (Click on the lock icon by the protohaven.org domain on the web browser and view the certificate.)
  
Line 122: Line 128:
 ===== Integrations with Other Systems ===== ===== Integrations with Other Systems =====
 ==== Set Equipment Status from Airtable ==== ==== 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. 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 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 ===== ===== API Keys =====
 Below are various API keys that are setup so that other programs are able to interact with Neon. 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/shr0Oji4gCWFi0b9N|Protohaven Tool List]]
   * [[https://airtable.com/shr9Hbyf7tdf7Y5LD|Current Tool Status]]   * [[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/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 === === Automations ===
software/website.1695582871.txt.gz · Last modified: 2023/09/24 19:14 by smartin015