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

Accessing / Exporting Apple's Screen Time Data

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

Step 1: Set Up Your S3 Bucket

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.
Upload Your Website Files:

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

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

1. Run Software Update

Make sure everything is up to date in the App Store

2. Install Homebrew

Open a terminal window and execute the Homebrew install script:

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

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

Setting up SSL cert with nginx

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

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

Concatenate the .crt and and encrypted .key file

cat domain.crt encrypted.key > domain.pem

Setting up sendmail relay on Ubuntu 22.04 (with PHP)

Test relay, needs host and port

One can use telnet to test; output will be similar to below. (use your email instead of [email protected])

telnet 172.16.10.100 8081
Trying 172.16.10.100...
Connected to 172.16.10.100.
Escape character is '^]'.
220 mailagent.test.com ESMTP Postfix (Ubuntu)

	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: