Dale Myszewski greenygh0st

IIS Certificate with SAN

When you absoluetly must deal with IIS and SAN...

[Version]
Signature="$Windows NT$"

[NewRequest]
Subject = "CN=me.com, OU=YourDepartment, O=YourCompany, L=YourCity, S=YourState, C=US"

If the trust relationship fails between a client machine and AD run the following command to fix it:

Reset-ComputerMachinePassword -Credential (Get-Credential) -Server "YourDomainController"

YourDomainController = the FQDN or ip address of the AD server

Open your terminal.

In the root directory run the command:

sudo nano /etc/bluetooth/main.conf

To export a Docker container to another host, you can follow these steps:

If the container you want to export is running, stop it first:

docker stop <container_id_or_name>

	definition(
	name: "Power Meter Mirror",
	namespace: "bubblelabs",
	author: "Dale Myszewski",
	description: "Mirrors only the power attribute from a selected device to a virtual device.",
	category: "Convenience",
	installOnOpen: true,
	singleInstance: false,
	iconUrl: "https://raw.githubusercontent.com/hubitat/HubitatPublic/master/hubitat.ico"
	)

	CREATE OR REPLACE FUNCTION SYSDATEUTC RETURN DATE AS
	BEGIN
	RETURN CAST(sys_extract_utc(SYSTIMESTAMP) AS DATE);
	END SYSDATEUTC;


	-- taken from: https://dba.stackexchange.com/questions/171739/change-owner-of-all-schema-objects
	CREATE OR REPLACE FUNCTION public.chown(in_schema character varying, new_owner character varying)
	RETURNS void
	LANGUAGE plpgsql
	AS $function$
	DECLARE
	object_types VARCHAR[];
	object_classes VARCHAR[];
	object_type record;

	extension Double {
	func reduceScale(to places: Int) -> Double {
	let multiplier = pow(10, Double(places))
	let newDecimal = multiplier * self // move the decimal right
	let truncated = Double(Int(newDecimal)) // drop the fraction
	let originalDecimal = truncated / multiplier // move the decimal back
	return originalDecimal
	}
	}