nanusdad

tar tvf redis-stable.tar
cd ~/bin
tar xfv ~/Downloads/redis-stable.tar
cd redis-stable
make
make test
cd src
./redis-server
redis-cli

nanusdad

MSSQL commands on Azure Data Studio

To read a .bak file from a MS SQL Server database on MacOS, one has to run MS SQL server using Docker and then use Azure Data Studio to access / query the database after restoring it.

Installing Docker image

You need to have Docker installed. Docker Desktop for MacOS is available at this link.

Once installed run the following commands.

# Pull latest image

nanusdad

Accessing / Exporting Apple's Screen Time Data

Some notes on accessing / exporting Apple's Screen Time data

Table of Contents

• knowledgeC.db SQLite CoreData Models / Tables
• Unsorted
• See Also

nanusdad

To configure a Dell Thin Client to boot directly into a Windows RDP login prompt, you need to adjust the settings in the `wnos.ini` file and ensure the correct configuration for Remote Desktop connections. Here are the steps to achieve this:

### 1. **Edit the wnos.ini File**

The `wnos.ini` file is used to configure various settings for the Dell Thin Client. You need to modify this file to enable direct RDP login.

1. **Access the wnos.ini File**:
   - You can edit the `wnos.ini` file using the Wyse Management Suite or by manually editing it if you have access to the file system of the thin client.

2. **Add Necessary Settings**:

nanusdad

To add a Let's Encrypt SSL certificate to an Amazon S3 static site, you will need to use Amazon CloudFront as an intermediary, since S3 does not support SSL certificates directly. Here are the detailed steps to achieve this:

Step 1: Set Up Your S3 Bucket

1. Create an S3 Bucket:

   • Go to the AWS Management Console.
   • Create a new S3 bucket with a unique name (this will be your static website).
   • Enable static website hosting in the bucket properties.

2. Upload Your Website Files:

nanusdad

How to resolve - unable to verify the first certificate in NodeJS

Connect using SSL to ascertain the error

openssl s_client -connect foo.badssl.com:443 -servername foo.badssl.com

Save output to tmp file

openssl s_client -connect foo.badssl.com:443 -servername foo.badssl.com | tee /tmp/logcertfile

Find issuer and CRT file

openssl x509 -in /tmp/logcertfile -noout -text | grep -i "issuer"

Get the intermediate certificate from issues

curl --output sectigo.crt http://crt.sectigo.com/SectigoRSAOrganizationValidationSecureServerCA.crt

Convert to pem file

nanusdad

Creating systemd service

Create Systemd Service File

sudo touch /etc/systemd/system/foo-daemon.service
sudo chmod 664 /etc/systemd/system/foo-daemon.service

Edit service file

vi /etc/systemd/system/foo-daemon.service

nanusdad

1. Run Software Update

Make sure everything is up to date in the App Store

2. Install Homebrew

1. Open a terminal window and execute the Homebrew install script:

/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"

nanusdad

Simple ExpressJS API to use local sendmail

API code

const express = require('express');
const nodemailer = require('nodemailer');
const app = express();

app.use(express.json());

// Configure Nodemailer to use the local sendmail service

nanusdad

Setting up SSL cert with nginx

1. Copy the .crt file and encrypted .key file to nginx server
2. Decrypt the .key file

openssl rsa -in encrypted.key -out decrypted.key

4. Concatenate the .crt and and encrypted .key file

cat domain.crt encrypted.key > domain.pem