Bruno Cabral brccabral

Let's Encrypt Certbot

sudo apt update
sudo apt install python3 python3-venv libaugeas0
# remove if installed from package manager, use python version
# sudo apt-get remove certbot
sudo python3 -m venv /opt/certbot/
sudo /opt/certbot/bin/pip install --upgrade pip
sudo /opt/certbot/bin/pip install certbot certbot-nginx

Termux Config

Install Termux from F-Droid.

Update and install useful packages.

pkg update
pkg upgrade
pkg install openssh
pkg install iproute2

Ollama OpenWebUI Raspberry Pi

Install Ollama

curl -fsSL https://ollama.com/install.sh | sh

Install the models

ollama run deepseek-r1:1.5b
ollama stop deepseek-r1:1.5b

SQL Custom Script

Set the environment variable DB_PASS. It will briefly create a temp file, execute it and load the password as PSSQL variable. The file is deleted.
Then, connect to the DB and run custom.sql.

set DB_PASS=secret
sqlplus /nolog @run_custom.sql

CMake print all variables matching pattern

Helper function that prints all variables matching pattern

function(print_cmake_variables_matching pattern)
    get_cmake_property(_variableNames VARIABLES)
    string(TOLOWER "${pattern}" pattern_lower)
    foreach (_variableName ${_variableNames})
        string(TOLOWER "${_variableName}" variable_lower)

Git Tips

Hook: post-receive

I have a repo on my machine, MyApp, I have a Bare Git Repo on a remote server production at /home/userName/MyApp.
When pushing to remote production, I need to update the code in the actual location /var/www/MyApp, but it needs root/sudo permission.

In the bare repo, add file /home/userName/MyApp/hooks/post-receive. This file is always executed after a push.
The idea is to execute this:

#!/bin/bash

Firefly III with Plaid Connector

A free and open source personal finance manager https://firefly-iii.org/

Documentation https://docs.firefly-iii.org/

Need to setup .env, .db.env and .importer.env before running docker compose.

The Importer is a separated web app (created by Firefly III) to support import of external files (CSV and other formats).
More details https://docs.firefly-iii.org/how-to/data-importer/installation/docker/

VNC server on Ubuntu Desktop

Followed these initial instructions
https://www.youtube.com/watch?v=3K1hUwxxYek

The video asks to install lightdm, but there is no need, we can use gdm3.
Install x11vnc.

sudo apt update

	import smtplib
	from email.mime.multipart import MIMEMultipart
	from email.mime.text import MIMEText


	class Email:
	def __init__(self, from_: str, to: list[str], subject: str):

	self.from_ = from_
	self.to = to

	// Original from https://gist.github.com/jouyouyun/669726de58df8d333666
	// Compile: gcc xgrabkey.c `pkg-config --cflags --libs x11` -o xgrabkey

	#include <stdio.h>
	#include <string.h>
	#include <X11/Xlib.h>
	#include <X11/Xutil.h>

	int main()
	{