greenygh0st

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"
)

greenygh0st

IIS Certificate with SAN

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

1. Create a request config file for your server

[Version]
Signature="$Windows NT$"

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

greenygh0st

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

greenygh0st

How to connect Apple AirPods to Linux (Debian/Ubuntu/Mint)

Step 1.

Open your terminal.

In the root directory run the command:

sudo nano /etc/bluetooth/main.conf

greenygh0st

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

1. Save the Container as an Image (if needed)

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

docker stop <container_id_or_name>

greenygh0st

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

greenygh0st

ruby -e "require 'securerandom'; puts SecureRandom.uuid"

greenygh0st

sudo apt-get -s dist-upgrade | grep "^Inst" | grep -i securi | awk -F " " {'print $2'} | xargs sudo apt-get install -y

greenygh0st

-- 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;

greenygh0st

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
    }
}