Project/Homeserver

setup brew install exiftool https://exiftool.org/ exiftool -r -d %s -tagsfromfile "%d/%F.json" "-GPSAltitude<GeoDataAltitude" "-GPSLatitude<GeoDataLatitude" "-GPSLatitudeRef<GeoDataLatitude" "-GPSLongitude<GeoDataLongitude" "-GPSLongitudeRef<GeoDataLongitude" "-Keywords<Tags" "-Subject<Tags" "-Caption-Abstract<Description" "-ImageDescription<Description" "-DateTimeOriginal<PhotoTakenTimeTimestamp" -ext "*" -overwrite_original -progress --ext json . https://stackoverflow.com/questions/65210140/how-to-merge-json-and-google-takeout-photos-to-get-the-right-dates-back exiftool -r -d %s -tagsfromfile "%d/%F.json" "-GPSAltitude<GeoDataAltitude" "-GPSLatitude<GeoDataLatitude" "-GPSLatitudeRef<GeoDataLatitude" "-GPSLongitude<GeoDataLongitude" "-GPSLongitudeRef<GeoDataLongitude" "-Keywords<Tags" "-Subject<Tags" "-Caption-Abstract<Description" "-ImageDescription<Description" "-DateTimeOriginal<PhotoTakenTimeTimestamp" -ext "*" -overwrite_original -progress --ext json . 2>&1 | tee log.log prep: copy json file for -edited files find . -type f -name "*-edited.*" | sed 's/^\(....

https://ultimatehomeserver.com/docs/getting-started/ssl install certbot + route53 changed /opt/certbot/ to /opt/certbotfoo/ sudo apt update sudo apt install python3 python3-venv libaugeas0 sudo python3 -m venv /opt/certbotfoo/ sudo /opt/certbotfoo/bin/pip install --upgrade pip sudo /opt/certbotfoo/bin/pip install certbot sudo ln -s /opt/certbotfoo/bin/certbot /usr/bin/certbot sudo rm /usr/bin/certbot sudo ln -s /opt/certbotfoo/bin/certbot /usr/bin/certbot ls ~/.secrets/certbot # set credentials for aws route53 sudo vi /root/.aws/config sudo /opt/certbotfoo/bin/certbot certonly \ --dns-route53 \ --dns-route53-propagation-seconds 60 \ -d hs.tjenwellens.eu \ -d "*.hs.tjenwellens.eu" add cron...

kubectl exec --stdin --tty fireflyiii-importer-9dfd577c-r92wb -- php artisan importer:import /import/joint_activobank.json kubectl exec --stdin --tty fireflyiii-importer-9dfd577c-r92wb -- php artisan importer:import /import/joint_kbc.json

src: https://www.craftypenguins.net/blog/how-to-trigger-a-kubernetes-cronjob-manually/ kubectl create job --from=cronjob/<name of cronjob> <name of job> kgcj NAME SCHEDULE SUSPEND ACTIVE LAST SCHEDULE AGE fireflyiii-db-backup 0 3 * * * False 0 8h 2d18h cloudbackup 0 4 * * * False 0 5m9s kubectl create job --from=cronjob/cloudbackup cloudbackup-test

backup `pg_dump dbname > dumpfile https://www.postgresql.org/docs/current/backup-dump.html pg_dump -h $DBHOST -p $DBPORT -U $DBUSER --format=p --clean -d $DBNAME > /var/lib/backup/$DBNAME.sql https://github.com/firefly-iii/kubernetes/blob/main/charts/firefly-db/templates/backup.tpl pg_dump -h localhost -p 5432 -U firefly --format=p --clean -d firefly > /db-bcp/firefly.sql restore `psql dbname < dumpfile https://www.postgresql.org/docs/current/backup-dump.html psql -h $DBHOST -p $DBPORT -U $DBUSER < /var/lib/backup/${DBNAME}.sql https://github.com/firefly-iii/kubernetes/blob/main/charts/firefly-db/templates/firefly-db-restore-job.yml psql -h localhost -p 5432 -U firefly < /var/lib/postgresql/data/firefly.sql and maybe run this on the core (NOT the db) php artisan firefly-iii:correct-database

src: https://github.com/orgs/firefly-iii/discussions/7698#discussioncomment-6544051

➜ helmfile git:(main) ✗ helm install firefly-iii firefly-iii/firefly-iii-stack –create-namespace -n firefly2 -f firefly/values.yaml

curl https://baltocdn.com/helm/signing.asc | gpg --dearmor | sudo tee /usr/share/keyrings/helm.gpg > /dev/null sudo apt-get install apt-transport-https --yes echo "deb [arch=$(dpkg --print-architecture) signed-by=/usr/share/keyrings/helm.gpg] https://baltocdn.com/helm/stable/debian/ all main" | sudo tee /etc/apt/sources.list.d/helm-stable-debian.list sudo apt-get update sudo apt-get install helm

install tailscale on homeserver https://tailscale.com/download/linux curl -fsSL https://pkgs.tailscale.com/stable/ubuntu/focal.noarmor.gpg | sudo tee /usr/share/keyrings/tailscale-archive-keyring.gpg >/dev/null curl -fsSL https://pkgs.tailscale.com/stable/ubuntu/focal.tailscale-keyring.list | sudo tee /etc/apt/sources.list.d/tailscale.list sudo apt-get update sudo apt-get install tailscale sudo tailscale up tailscale ip -4

sudo apt install zsh -y also install ohmyzsh https://ohmyz.sh/#install sh -c "$(curl -fsSL https://raw.githubusercontent.com/ohmyzsh/ohmyzsh/master/tools/install.sh)" change prompt to include filename cp ~/.oh-my-zsh/themes/robbyrussell.zsh-theme ~/.oh-my-zsh/custom/themes PROMPT="%{$fg[blue]%}%m%{$fg[red]%}|%(?:%{$fg_bold[green]%}%1{➜%} :%{$fg_bold[red]%}%1{➜%} ) %{$fg[cyan]%}%c%{$reset_color%}" PROMPT+=' $(git_prompt_info)' ZSH_THEME_GIT_PROMPT_PREFIX="%{$fg_bold[blue]%}git:(%{$fg[red]%}" ZSH_THEME_GIT_PROMPT_SUFFIX="%{$reset_color%} " ZSH_THEME_GIT_PROMPT_DIRTY="%{$fg[blue]%}) %{$fg[yellow]%}%1{✗%}" ZSH_THEME_GIT_PROMPT_CLEAN="%{$fg[blue]%})"