Bruno Cabral brccabral

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

Pihole

Before anything, check your docker log settings. I had Unbound consuming 17GB alone.
https://docs.docker.com/config/containers/logging/json-file/
/etc/docker/daemon.json

{
  "log-opts": {
    "max-size": "20m",
 "max-file": "3"

	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()
	{