Felipe Romero feliperomero3

Generate a self-signed root certificate using OpenSSL

This repository contains a script that will generate a trusted ssl certificate which can be used for local software development.

	<Query Kind="Statements">
	<NuGetReference>Microsoft.AspNetCore.DataProtection.Extensions</NuGetReference>
	<Namespace>Microsoft.AspNetCore.DataProtection</Namespace>
	<Namespace>Microsoft.AspNetCore.DataProtection.AuthenticatedEncryption</Namespace>
	<Namespace>Microsoft.AspNetCore.DataProtection.AuthenticatedEncryption.ConfigurationModel</Namespace>
	<Namespace>Microsoft.AspNetCore.DataProtection.Infrastructure</Namespace>
	<Namespace>Microsoft.AspNetCore.DataProtection.Internal</Namespace>
	<Namespace>Microsoft.AspNetCore.DataProtection.KeyManagement</Namespace>
	<Namespace>Microsoft.AspNetCore.DataProtection.KeyManagement.Internal</Namespace>
	<Namespace>Microsoft.AspNetCore.DataProtection.Repositories</Namespace>

	REM Export table to CSV file
	sqlite3 -header -csv "backup 2022-03-14 173525.mdb" "SELECT * FROM transactions" > "transactions.csv"

	REM Get schema information
	sqlite3 -header -csv "backup 2022-03-14 173525.mdb" "PRAGMA table_info(transactions)"

	REM Do this to enter Sqlite "REPL" or "interactive" mode (exit with .exit)
	sqlite3 "backup 2022-03-14 173525.mdb"

	<!doctype html>
	<html>
	<head>
	<title>Site Maintenance</title>
	<meta charset="utf-8"/>
	<meta name="robots" content="noindex"/>
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<style>
	body { text-align: center; padding: 20px; font: 20px Helvetica, sans-serif; color: #efe8e8; }
	@media (min-width: 768px){

	# Source: https://www.server-world.info/en/note?os=CentOS_7&p=ftp&f=2

	# [1] Install FTP Client.
	[root@dlp ~]# yum -y install lftp

	# [2] The connection with root account is prohibited by default, so access with an common user to FTP Server.

	# lftp [option] [hostname]
	[redhat@dlp ~]$ lftp -u cent www.srv.world

	#!/bin/bash

	# Only output headers
	curl -vs https://example.com > /dev/null

	# This command gets the certificate named TestCert01 from the key vault named ContosoKV01.
	# To download the certificate as pfx file, run following command.
	# These commands access SecretId and then save the content as a pfx file.

	$cert = Get-AzKeyVaultCertificate -VaultName "ContosoKV01" -Name "TestCert01"
	$secret = Get-AzKeyVaultSecret -VaultName $vaultName -Name $cert.Name -AsPlainText
	$secretByte = [Convert]::FromBase64String($secret)
	$x509Cert = New-Object System.Security.Cryptography.X509Certificates.X509Certificate2($secretByte, "", "Exportable,PersistKeySet")
	$type = [System.Security.Cryptography.X509Certificates.X509ContentType]::Pfx
	$pfxFileByte = $x509Cert.Export($type, $password)

	#Requires -Version 3.0

	Param(
	[string] [Parameter(Mandatory=$true)] $ResourceGroupLocation,
	[string] $ResourceGroupName = 'AzureResourceGroup3',
	[switch] $UploadArtifacts,
	[string] $StorageAccountName,
	[string] $StorageContainerName = $ResourceGroupName.ToLowerInvariant() + '-stageartifacts',
	[string] $TemplateFile = 'WebSite.json',
	[string] $TemplateParametersFile = 'WebSite.parameters.json',

	# https://www.digitalocean.com/community/tutorials/how-to-install-the-apache-web-server-on-ubuntu-18-04

	# Check with the systemd init system to make sure the service is running by typing:
	sudo systemctl status apache2

	# To stop your web server, type:
	sudo systemctl stop apache2

	# To start the web server when it is stopped
	sudo systemctl start apache2