brew install git

apt-get install git

git --version

# Set Identity
git config --global user.name "Marc Ouellet"
git config --global user.email "marc.ouellet@gmail.com"

# Set Default Branch to match GitHub (main)
git config --global init.defaultBranch main

# Verify Settings
git config --global user.name
git config --global user.email

# Common Alias
git config --global alias.s "status"

nano /etc/default/grub

GRUB_CMDLINE_LINUX_DEFAULT="quiet intel_iommu=on"

update-grub

dmesg | grep -e DMAR -e IOMMU

lspci -v

lspci -nnk | grep -iA2 nvidia

apt-get install -y apt-transport-https software-properties-common wget

mkdir -p /etc/apt/keyrings/

wget -q -O - [https://apt.grafana.com/gpg.key](https://apt.grafana.com/gpg.key) | gpg --dearmor | sudo tee /etc/apt/keyrings/grafana.gpg > /dev/null

echo "deb [signed-by=/etc/apt/keyrings/grafana.gpg] [https://apt.grafana.com](https://apt.grafana.com) stable main" | tee -a /etc/apt/sources.list.d/grafana.list

apt-get update

apt-get install grafana -y

systemctl daemon-reload

systemctl enable grafana-server

systemctl start grafana-server

systemctl status grafana-server

#!/usr/bin/env bash

echo "Installing latest Hugo Extended..."

ARCH=$(dpkg --print-architecture)

if [ "$ARCH" != "amd64" ]; then
  echo "This script currently supports amd64 only."
  echo "Detected architecture: $ARCH"
  exit 1
fi

echo "Fetching latest version..."
LATEST=$(curl -s [https://api.github.com/repos/gohugoio/hugo/releases/latest](https://api.github.com/repos/gohugoio/hugo/releases/latest) \
  | grep '"tag_name":' \
  | sed -E 's/.*"v([^"]+)".*/\1/')

if [ -z "$LATEST" ]; then
  echo "Failed to fetch latest version."
  exit 1
fi

echo "Latest version: $LATEST"
FILE="hugo_extended_${LATEST}_linux-amd64.deb"
URL="[https://github.com/gohugoio/hugo/releases/download/v$](https://github.com/gohugoio/hugo/releases/download/v$){LATEST}/${FILE}"

echo "Downloading $FILE..."
wget -q --show-progress "$URL"

if [ ! -f "$FILE" ]; then
  echo "Download failed."
  exit 1
fi

echo "Installing package..."
sudo dpkg -i "$FILE"
sudo apt-get -f install -y

echo "Cleaning up..."
rm -f "$FILE"

echo ""
echo "Installed Hugo version:"
hugo version

echo ""
echo "Done."

timedatectl set-timezone America/Toronto

apt update && apt full-upgrade -y

echo -e '\n# Auto-Warpify\nprintf '\''\eP$f{"hook": "SourcedRcFileForWarp", "value": { "shell": "bash", "uname": "'$(uname)'" }}\x9c'\'' ' >> ~/.bashrc

apt install gdebi curl sudo gpg ethtool ngrep lshw lsscsi cifs-utils ncdu etherwake lshw sudo tasksel fail2ban openssh-server qemu-guest-agent unzip smbclient fio iperf3 nmap net-tools apt-transport-https software-properties-common wget duf tldr zip git eza snapd samba glances -y

# Purge unused packages and clean cache
apt autoremove --purge && apt autoclean

# Reclaim journal log space (limit to 500MB)
journalctl --vacuum-size=500M

# List all files with human-readable sizes
ls -lah

# Summary of folder sizes in current directory
du -sh *

# Identify top 10 largest folders on root
sudo du -xh / | sort -rh | head -n 10

# Disk space usage summary (filtered for MB/GB)
du -cha --max-depth=1 / | grep -E "M|G"

# Find files larger than 25MB in project
find /home/marc/hugo/canada2argentina -type f -size +25M -exec ls -lh {} +

# Count total files in the public build folder
find /home/marc/hugo/canada2argentina/public -type f | wc -l

# List top 25 largest files in project
find /home/marc/hugo/canada2argentina -type f -exec du -h {} + | sort -rh | head -n 25

# Wipe all partitions/signatures from a disk (CAUTION)
sgdisk --zap-all /dev/sdX

# Detailed SMART health report
smartctl -a /dev/sda | less

# Deep scan for bad blocks (Takes a long time)
badblocks -v /dev/sda -s

# Unlock a stuck VM or Container
qm unlock <vmid>
pct unlock <ctid>

# Resize a container disk (Final size, cannot shrink)
pct resize 103 rootfs 16G

# List running LXC containers
pct list | awk 'NR>1'

# Disable HA for a specific VM/CT to allow manual fixes
ha-manager set vm:200 --state disabled
ha-manager set ct:103 --state disabled

# Update and list available CT templates
pveam update
pveam available

# List all active apt sources
grep -r '' /etc/apt/sources.list*

# List and pin a specific kernel
proxmox-boot-tool kernel list
proxmox-boot-tool kernel pin 6.8.8-4-pve

# Check DNS resolution
nslookup google.com
nslookup pi.hole

# Check open listening ports
ss -lntu
netstat -plant

# Performance test (Client mode, 8 parallel streams)
iperf3 -c 10.1.1.11 -P8

# View real-time system logs for USB/Kernel errors
dmesg -w
dmesg -T | grep usb

# Clear "Remote Host Identification Changed" error
nano ~/.ssh/known_hosts

# Copy local images from Mac to Hugo site on Server
scp -v /Users/marc/Downloads/to_convert/* root@10.1.2.202:/home/marc/hugo/canada2argentina/static/images/

# Backup and transfer a folder between servers
tar -czvf "$(date +%Y-%m-%d_%Hh%M)_PangolinBackup.tar.gz" pangolin/
scp pangolin.tar.gz root@72.11.147.220:/home/marc/docker-compose

# Clear RAM cache (Drop caches)
sync && echo 3 | tee /proc/sys/vm/drop_caches

# Check ZFS ARC summary and free RAM
arc_summary -s arc && free -h

# Get BIOS version and serial info
sudo dmidecode -t bios

# List SCSI and PCIe hardware
lsscsi -u
lspci

# Make script executable and run
chmod +x ./unifi-9.0.114.sh && ./unifi-9.0.114.sh

# Instant test of cron behavior (Sends message to all terminals)
* * * * * echo "Hello from cron" | wall

# Cancel a pending shutdown
shutdown -c

# Print the path of the folder you are in
pwd

# Add user to sudo group
sudo usermod -aG sudo marc

# Activate root account
sudo passwd root

# File Browsers (Dolphin is recommended)
sudo apt install dolphin krusader konqueror -y

# Partition Manager
sudo apt install gparted -y

# Synaptic & GDebi
sudo apt install synaptic gdebi -y

docker exec -it n8n_postgres16 psql -U n8n -d n8n

-- Count entries in knowledge base
SELECT COUNT(*) FROM n8n_knowledge_base;

-- Count entries in chat history
SELECT COUNT(*) FROM n8n_chat_histories;

-- View table structure
\d n8n_knowledge_base

-- Preview top 20 entries
SELECT * FROM n8n_knowledge_base LIMIT 20;

-- Clear all chat histories
DELETE FROM n8n_chat_histories;

-- Clear all knowledge base vectors
DELETE FROM n8n_knowledge_base;