Adib adiberr

First Boot

PVE

Install Proxmox :

Proxmox ISO : https://enterprise.proxmox.com/iso/proxmox-ve_8.2-1.iso
Bootable USB : https://rufus.ie/en/ (DD mode)

Enable iGPU passthrough (for transcoding video):

Connect as SYSDBA :

sqlplus / as sysdba

Fix a down Database :

STARTUP MOUNT;
ALTER DATABASE OPEN;

Extract the source ip address and destination port :

sed -n 's/^.*SRC=\([0-9]\+\.[0-9]\+\.[0-9]\+\.[0-9]\+\).*DPT=\([0-9]\+\).*$/\1 \2/p' <<< $(sudo cat /var/log/ufw.log) \
| uniq -c \
| sort \
| column -t

Example (details omitted for simplicity):

docker run --name keycloak -p 8080:8080 quay.io/keycloak/keycloak:16.1.1

docker exec keycloak /opt/jboss/keycloak/bin/add-user-keycloak.sh -u admin -p admin

docker container restart keycloak

	import requests
	import webbrowser
	import sys
	import json

	CLIENT_ID=
	CLIENT_SECRET=
	REDIRECT_URI=

	def get_authorization_url():

	#!/bin/sh

	# Author: Adib Err (@adiberr)
	# GitLab Docs: https://docs.gitlab.com/ee/api/labels.html#create-a-new-label

	PROJECT_ID= # Your project id
	GITLAB_API="https://gitlab.com/api/v4/projects/${PROJECT_ID}/labels"

	if [ "$#" -ne 2 ]; then
	echo "Usage: mklabel <label> <color>"

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8" />
	<meta name="viewport" content="width=device-width, initial-scale=1.0" />
	<title>Document</title>
	<style>
	body {
	background-color: #f8f8f8;
	}

	SELECT
	Min(IT.DATE) AS DATE_MIN,
	Max(IT.DATE) AS DATE_MAX,
	DateDiff("d", Min([Date]), Max([Date])) AS DaysElapsed,
	COUNT(*) AS ITEMS
	FROM
	IT;

	#NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases.
	; #Warn ; Enable warnings to assist with detecting common errors.
	SendMode Input ; Recommended for new scripts due to its superior speed and reliability.
	SetWorkingDir %A_ScriptDir% ; Ensures a consistent starting directory.

	Stop := "163000" ; hhmiss

	FormatTime,TargetTime,,yyyyMMdd%Stop%
	Time := A_Now
	Time -= %TargetTime%, s

	#!/bin/sh
	echo "options sony-laptop kbd_backlight=0" \| sudo tee /etc/modprobe.d/sony-laptop.conf
	sudo rmmod -v sony-laptop; sudo modprobe -v sony-laptop kbd_backlight=0