Aaron Lauterer

Blog

Biblatex - Customizing citations

Recently I had a friend who needs to write essays on a frequent basis for their studies. After hearing how they were struggling with Microsoft Word in combination with the citation style mandated by their university department, I suggested the use of LaTEX. So one evening we sat together and created a template for her to use which would fit these requirements. After a lot of searching in LaTEX forums and the Tex part of s…

Static Site Generator - Deployment strategies

Even though there are countless guides for this, I still need a place to document my way of deploying my websites. If it is useful for other people, even better. Most of my current websites are created with static site generators. In particular with Hugo and Zola. But having to build them locally and then transfer the files to the web server is a tedious and manual task that can be improved upon with …

Install Proxmox on HP DL380 Gen8

UPDATE I had to learn it the hard way... Just don't do what I did and get yourself an HBA controller right away! Otherwise you will run into (performance) problems sooner or later. I was in the situation to install Proxmox on a second hand HP DL380 Gen8 Server with a P420i RAID controller. Since Proxmox supports installation to ZFS out of the box I wanted to make use of that. Unfortunately…

Use Exiftool to shift time for a specific camera

This is a quick reminder for myself because even though I was able to find quite some information online, nothing really fit. The situation was that a session was shot with two cameras. Unfortunately the clocks were off by about 25 minutes between the cameras. To make matters more complicated the files of both cameras were in the same directory sharing the same naming scheme. Because of this it was not as easy as applying exiftool to a certain directory…

NGINX GeoIP testing

At work I had the task to implement a redirection based on the visitors country for the company website. I came to use this serverfault.com answer as a base for my implementation. But how do I test this? In order to test the behavior I need to fake IP adresses from all over the world. iptables to the rescue! Faking the source IP address To test this I had the NGIN…

I3 Scratchpad to access often used applications

I do have a few applications that I need many times throughout the day but usually only for a very short time. One of the prime examples for this is my password manager. Others are a go to terminal or some note taking application. You might have some other needs like a messenger or who knows what.

Sync Linux File Permissions

I ran into the situation where I had a directory tree restored from backup but the permissions were all messed up. The directory with the corrupted files still existed and the permissions there were intact. So the idea was to sync the permissions of the one directory tree to the other. I found the solution to my problem in this Serverfault thread.…

MSSQL Accross Subnets

A was faced with the situation that a client could not connect to it's MSSQL named instance in another subnet. There is a firewall in between those subnets. The firewall rule allowed TCP 1433, 1434 and Pings. The client was able to ping the server. So far so good. But the SQL client could not connect to the server. A nmap scan of the server showed that port 1433 or 1434, the classical MSSQL ports, were not open. As it turns out, the server was set to use dynamic por…

Tomcat behind reverse proxy

I had to set up a system for Atlassian's Jira and Confluence that would be accessed by at least two different URLs. The Tomcat servers are behind an NGINX server that handles the whole SSL stuff. In the past, when such a system would have only one very specific URL I would set the proxyName=<FQDN/URL> in the connector section in the server.xml and be good. Jira or Confluence would generate the right URLs. But in this case I ran…

Migrate a VirtualBox OVA to ESXi

I had to migrate an OVA exported by VirtualBox to an ESXi 6. TL;DR: Untar the OVA, copy the vmdk file to ESXi, migrate the vmdk with vmkfstools and create a new VM using the new vmdk file for the HDD. You got time to read it all An OVA file is a tarball of the VMs vmdk and the OVF file containing all the settings in XML format. My first naive attempt by importing the OVA using t…