sahapasci

Enable Group Policy Editor on Windows Home using DISM

Windows Home editions do not include Group Policy Editor (gpedit.msc) by default. However, the required Group Policy Client packages are already present in the system and can be installed manually using DISM.

This document explains how to enable them safely using built-in Windows components.

---

Commands

sahapasci

ELAN I2C Touchpad Click Fix (Lenovo ThinkBook / Linux)

This document describes an issue with ELAN I2C touchpads on Lenovo ThinkBook laptops running Linux (Debian 13 in this case), where tap works but physical click does not, and how it was resolved using an automatic unbind/bind systemd service.

1. Problem Summary

On certain Lenovo ThinkBook models, the ELAN touchpad appears as both a Mouse and a Touchpad:

ELAN06FA:00 04F3:327E Mouse

sahapasci

#!/bin/bash
# This script downloads and installs latest FortiClient VPN-only Debian 13 (Trixie).
# It resolves the redirected download URL, installs required dependencies.

set -e  # Stop on error

generic_url='https://links.fortinet.com/forticlient/deb/vpnagent'
tmp_dir=/tmp/forticlient_vpn

# Create temporary directory

sahapasci

# Forticlient Debian 13 (Trixie) Installation
# This script adds the Forticlient repository, imports the GPG key, updates package lists, and installs Forticlient 7.4.
# Notes:
#   The repository URL references Ubuntu, but it works on Debian 13 (Trixie) as well.
#   FortiClient is a licensed product. If you do not have a valid license, install the "FortiClient VPN-only" package instead for VPN access only.

# Download Fortinet GPG key
wget https://repo.fortinet.com/repo/forticlient/7.4/ubuntu22/DEB-GPG-KEY --output-document=/etc/apt/keyrings/repo.fortinet.com.asc

# Add Forticlient repository

sahapasci

# bash completion for etcdctl                              -*- shell-script -*-

__etcdctl_debug()
{
    if [[ -n ${BASH_COMP_DEBUG_FILE:-} ]]; then
        echo "$*" >> "${BASH_COMP_DEBUG_FILE}"
    fi
}

# Homebrew on Macs have version 1.3 of bash-completion which doesn't include

sahapasci

# bash completion for etcdutl                              -*- shell-script -*-

__etcdutl_debug()
{
    if [[ -n ${BASH_COMP_DEBUG_FILE:-} ]]; then
        echo "$*" >> "${BASH_COMP_DEBUG_FILE}"
    fi
}

# Homebrew on Macs have version 1.3 of bash-completion which doesn't include

sahapasci

-- base table

-- drop table users cascade;

CREATE TABLE users (
    id             serial PRIMARY KEY,
    username       text NOT NULL UNIQUE,
    password       text,
    created_on     timestamptz NOT NULL,
    last_logged_on timestamptz NOT NULL

sahapasci

create table my_table (id integer primary key, data text);
create function my_func(id integer, data text) 
returns void
language plpgsql
as 
$$
begin
insert into my_table values (id, data);
end;
$$;

sahapasci

/*
* This query creates JSON input for AWS DMS (Data Migration Service) selection rules.
* It incluedes all schemas. 
*/

WITH rules AS (
  SELECT
      format('{
        "rule-type": "selection",
        "rule-id": "%s",