ml-eds

SSL for Postgres connections

In the following we will create a self-signed certificate (without self-signed Root CA certificate, to keep things simple)

postgresql.conf

In /var/lib/postgresql/data:

nano postgresql.conf

ml-eds

# export all changed files from commit b58b5f9 to commit HEAD into tar archive

git diff-tree -r --no-commit-id --name-only --diff-filter=ACMRT b58b5f9^..HEAD | tar -czf file.tgz -T -

ml-eds

# Convert Unix timestamp to date in zsh/bash
# 
# Add to .zshrc or .bash_profile 
# 
# Example usage:  ts2date 1650621128
# Example output: 2022-04-22 11:52:08

timestamp2date() {
     date -r "$1" '+%Y-%m-%d %H:%M:%S' 
}

ml-eds

#!/bin/bash

# given list_search.txt with content, e.g.
# <PackageReference Include="Microsoft.EntityFrameworkCore.Design" Version="3.1.0" />
# <PackageReference Include="Microsoft.EntityFrameworkCore.InMemory" Version="3.1.0" />

# given list_replace.txt with content, e.g.
# <PackageReference Include="Microsoft.EntityFrameworkCore.Design" Version="3.1.5" />
# <PackageReference Include="Microsoft.EntityFrameworkCore.InMemory" Version="3.1.5" />

ml-eds

# good reference: https://wiki.ubuntuusers.de/CA/

# download missing cert DigiCertHighAssuranceEVRootCA.crt 
wget --no-check-certificate https://dl.cacerts.digicert.com/DigiCertHighAssuranceEVRootCA.crt

# convert to pem format
openssl x509 -inform DER -outform PEM -in DigiCertHighAssuranceEVRootCA.crt -out DigiCertHighAssuranceEVRootCA.pem.crt

# copy to /usr/local/share/ca-certificates
cp DigiCertHighAssuranceEVRootCA.pem.crt /usr/local/share/ca-certificates/

ml-eds

// Place the following in the "Tests" tab of a request

// Check HTTP status code 
tests['Status 200'] = responseCode.code === 200;

// We need valid JSON
var validJSON = false;
var resData = {};
try {
    resData = JSON.parse(responseBody);

ml-eds

TSLint pre-commit hook

Important!

Must be configured on top level directory of a project when having a multi-package project (e.g. frontend + backend).

Install

npm install --save-dev husky lint-staged

ml-eds

find . -type f -newermt '7/14/2019 16:00:00'

ml-eds

using System;
using Microsoft.AspNetCore.Identity;
using Microsoft.Extensions.Options;

namespace ConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {

ml-eds

get current ssh config of vagrant vm

vagrant ssh-config

Host default
  HostName 127.0.0.1
  User ubuntu
  Port 2222
  UserKnownHostsFile /dev/null

StrictHostKeyChecking no