Todd Heslin toddheslin

Setting up a SSL Cert from Comodo

I use Namecheap.com as a registrar, and they resale SSL Certs from a number of other companies, including Comodo.

These are the steps I went through to set up an SSL cert.

Purchase the cert

Better local require() paths for Node.js

Problem

When the directory structure of your Node.js application (not library!) has some depth, you end up with a lot of annoying relative paths in your require calls like:

const Article = require('../../../../app/models/article');

Those suck for maintenance and they're ugly.

Possible solutions

Option 1: Command-line download extension as zip and extract

extension_id=jifpbeccnghkjeaalbbjmodiffmgedin   # change this ID
curl -L -o "$extension_id.zip" "https://clients2.google.com/service/update2/crx?response=redirect&os=mac&arch=x86-64&nacl_arch=x86-64&prod=chromecrx&prodchannel=stable&prodversion=44.0.2403.130&x=id%3D$extension_id%26uc" 
unzip -d "$extension_id-source" "$extension_id.zip"

Thx to crxviewer for the magic download URL.

PostgreSQL Data Types	AWS DMS Data Types	Redshift Data Types
INTEGER	INT4	INT4
SMALLINT	INT2	INT2
BIGINT	INT8	INT8
NUMERIC (p,s)	If precision is 39 or greater, then use STRING.	If the scale is => 0 and =< 37 then: NUMERIC (p,s) If the scale is => 38 and =< 127 then: VARCHAR (Length)
DECIMAL(P,S)	If precision is 39 or greater, then use STRING.	If the scale is => 0 and =< 37 then: NUMERIC (p,s) If the scale is => 38 and =< 127 then: VARCHAR (Length)
REAL	REAL4	FLOAT4
DOUBLE	REAL8	FLOAT8
SMALLSERIAL	INT2	INT2
SERIAL	INT4	INT4

exFAT support on macOS seems to have some bugs because my external drives with exFAT formatting will randomly get corrupted.

If Disk Utility is unable to repair, consider trying this:

In Disk Utility, ensure that the drive is not mounted, eject it if it is mounted.
Use diskutil list to find the right drive id.
You want the id under the IDENTIFIER column, it should look like disk1s1
Run sudo fsck_exfat -d <id from above>. eg sudo fsck_exfat -d disk1s3
-d is debug so you'll see all your files output as they're processed.

🚨 2020 Update: I recommend using mkcert to generate local certificates. You can do everything below by just running the commands brew install mkcert and mkcert -install. Keep it simple!

This gives you that beautiful green lock in Chrome. I'm assuming you're putting your SSL documents in /etc/ssl, but you can put them anywhere and replace the references in the following commands. Tested successfully on Mac OS Sierra and High Sierra.

Set up `localhost.conf`

sudo nano /etc/ssl/localhost/localhost.conf

	const validateUrl = /(https?\:\/\/([\w\-]+)?.?pointhacks.com(.au)?)/gi

	// In use
	validateUrl.test('https://broken.com')
	validateUrl.test('https://working.pointhacks.com.au')

	import { renderToStream } from "@react-pdf/renderer";
	import ReactDOMServer from "react-dom/server";
	import { EntryContext, Headers, RemixServer, Request, Response } from "remix";
	import PDF, { loader } from "./pdfs/my-pdf.server";

	async function handlePDFRequest(request: Request, headers: Headers) {
	// get the data for the PDF
	let response = await loader({ request, context: {}, params: {} });
	// if it's a response return it, this means we redirected
	if (response instanceof Response) return response;

	[
	{ "from": "/old", "to": "https://new-site.ru" },
	{ "from": "/old2", "to": "/new" }
	]