Apt Key Expired in Ubuntu

I was updating my boxes as usual when I encountered an error when trying to run updates on my unifi controller. This lives on a slightly older box (I tried upgrading it at one point and not all the dependencies were supported yet on the newer version), and I ran into an error when running the apt commands. One of the keys was expired for a component needed by the controller. So lets figure out how to update that key so we can update the box once more.

Continue reading “Apt Key Expired in Ubuntu”

Calling HASS API from Various Shells

While working on making my macro pad trigger Home Assistant automations, I found the API would be the easiest way to integrate the systems. Here’s some of my experimenting with the API and how to call it from Linux curl and PowerShell Invoke-WebRequest

Linux Curl

Using the Linux curl command is pretty straight forward.

curl -X POST http://hass.local:8123/api/services/switch/toggle -H 'Authorization: Bearer ABCDEF' -d '{"entity_id": "switch.testsubject_test_subject"}'

PowerShell Invoke-WebRequest

PowerShell is a bit more annoying to get everything right, as Invoke-WebRequest is a bit pickier on its input arguments.

Invoke-WebRequest -Method POST -Uri "http://hass.local:8123/api/services/switch/toggle" -H @{"Authorization"="Bearer ABCDEF"} -Body '{"entity_id": "switch.testsubject_test_subject"}'

Apparently windows has a build of the official Unix curl and tar commands, but my PowerShell prompts all had curl as an alias to Invoke-WebRequest. I did find that if i call curl.exe, it would run the official curl command.


Do be careful when copying and pasting between shells, I found that copying out of the PowerShell prompt and back in would yield an invalid token. This was also encountered in the WSL terminal as well.

The API is pretty straight forward after a little bit of trying things out. The documentation covers the capability but doesn’t have as many examples as I would have liked otherwise.


WLED Automation for Roku in Home Assistant

I was able to get WLED going on a light strip but I do have a lack of ideas on how to make use of it. I finally decided to go with the tried and true movie lighting. So my goal is to setup automations so that when my Roku begins playing something, the WLED strip dims and sets to a specific color (we’ll go with red), and when I pause or stop playing, it will turn to max brightness white light. This will give lower lighting while watching and brighter lights if something is paused (and I have to go get something). I’m still not entirely sure if I will end up making use of this in the end, but it will give me some ideas on what I can do and how to do it.


  • Adjust lighting when Roku plays some media
    • If light is on, dim when playing
    • If light is on, brighten and go to white when paused or stopped
  • Change to solid colors and a specific color
  • When the Roku goes to Idle, turn the light strip off


The Roku integration has a number of different statuses, however we’ll be focusing on 3 of them:

  • idle
  • playing
  • paused

For our automations, we’ll be looking for changes in status in the following ways:

  • any status to playing
  • any status to idle
  • playing to any status

The plan is to create an automation for each one of these status changes. And each of those automations will perform the actions we have listed in the goals. To do this, we’ll be making use of the Roku and WLED integrations as well as the WLED webui for creating presets.


Setting everything up starts on the WLED webui side of things. This is where presets can be added to the device and various settings can be changed on the fly. We will be adding two presets for our set of automations (bright white and dim red). I did this on a desktop, so with the webui all the way open, it was on the far right side. I first set the LED strip to the settings I wanted the preset to use, then I clicked to add a new preset. Doing this twice got me the two presets.

Do make sure to note the presets numbers since this will be used to call up the presets when used in the automations later on.

Those presets can be called by the HASS automation to set things a bit more specifically than the HASS service will allow. The presets allow setting the solid color to use which I didn’t see as an option using the home assistant WLED service.

Dim when Playing

The first automation in our set of 3 is to dim the lights when the Roku starts playing some content.


The trigger for dimming the lights uses a state change from any state to ‘playing’. Since we don’t care about the original state, we leave the ‘from’ field blank, essentially acting as a wildcard, and we set the ‘to’ field to ‘playing’. This trigger will work when going from paused to playing, from an app to playing, etc.


The condition here is that the LED strip is already on. If the LED strip is off, we do not want to turn it on and start manipulating it.


It may seem a bit strange that we’re turning on the light as the action here when we already know its on, but it was the most straight forward way I could find to set the brightness on the light strip.

After turning the lights on, we want to set the lights to a solid color and call the preset to our dim red preset. I realize this could all be performed using the preset, but this is in part a relic of my experimenting with the automations. This can probably be simplified into the preset to handle the brightness, effect, and color.

The final (and only really necessary) action is to call a service with one argument to the light strip. The argument is the preset number that was created in the webui of WLED.

Turn Bright when Paused

The second automation in this grouping is to turn the lights up when pausing the video.


The trigger for turning up the lights when the media is paused is similar to the others. This time we want the state to change from playing to anything else. Due to this, we’re just using the ‘from’ field.


We only want to adjust the lights when they’re on, if we turn them off then we don’t want to be manipulating them.


The action for this automation is simple enough, we just need to set the light strip to the preset. This is a service call with one argument to the light strip.

Turn off When Idle

The final automation for this setup is to turn the lights off when the Roku goes idle. The idle state is when they Roku goes to the screensaver. In this automation, we’re not going to use the condition that the light strip is on, since if it is on or off, turning it off will have the exact same effect.


The trigger for turning off the lights when the Roku goes idle is similar to the others. This time we want the state to change from anything to idle. Due to this, we’re just using the ‘to’ field.


The action is simple to setup, we just want to turn off the light strip.

Testing and Changes to Plans

I went to play and pause the Roku far more times than I expected. Using the testing is how I found my sun condition of before sunrise and after sunset was causing problems. It took a few tries to figure out the right status settings for the automation. Below is the failed Sun condition that I tried to use.

Since this condition did not work, I decided to create a different condition, that the WLED strip is on already before manipulating it. Since the goal Sun condition was to manipulate the lights only at night, I decided that using the lights on/off status would be a good compromise and fit the same goal. I can just say ‘well if the lights are on already, then start manipulating them’.


This was a fun project to get some automation experience with WLED. I didn’t have the light strip setup with my TV as I hadn’t yet decided how I was going to use it, I just wanted to know what I could do. This does however work pretty well. This also gave me some other knowledge on the automations, triggers, and actions.

NextCloud File Lock Error in Joplin

I encountered a problem recently on the Joplin desktop app where it couldn’t synchronize due to a file lock being stuck in NextCloud. It uses a file in the jopline data directories to determine sync status and lock status on files being edited, and this file was stuck locked in NextCloud with no way to delete it. I performed some searching, finding some blog posts on the subject and found this on how to solve it. I’ll be going through the manual solution to this problem and updating the process with my experience.

Continue reading “NextCloud File Lock Error in Joplin”

WLED with ESP8266

I found a guide for running WLED on an ESP8266 micro controller to drive individually addressable RGB cables. I thought this would be a fun little project after working with the smart plugs and home assistant automations. Since WLED is another FOSS and cloud-free project, this still fits with my whole fully self hosted smart home ideal. Since no project is fool proof and I have run into small problems when working on the project.

Continue reading “WLED with ESP8266”

Adding a Current Month Numeric Sensor to Home Assistant

I have a number of Christmas light strands in various windows around my house. These get turned on once a year when we remember they exist and its around Christmas time. I decided that these would be a good use for home assistant to add some Christmas lighting during November and December.

To do this, I wanted an automation that would turn on the lights during specific months, and not during others. Thus I needed the current month available as a condition for my automation. I quickly found out that Home Assistant does not have this type of data built in, but can have it added relatively easily. I didn’t know how most of this was supposed to go together, so after a little bit of guess and check, here is what I ended up with.

Continue reading “Adding a Current Month Numeric Sensor to Home Assistant”

PhotoPrism MySQL DSN

Setting up the service was simple enough, I chose to run it on my UNRAID server however this meant I couldn’t use the example docker-compose file. I took all the settings from it and set it all up on my UNRAID server with the only changes being to paths for my file structure and the SQL database information. I use a MySQL database server for most of my services, so I needed to get the DSN for that server, however this was the first time I used DSNs, however it is pretty simple to setup correctly. I used PHPmyAdmin to add a user and database for PhotoPrism, and from there I used the default DSN with my username/password and host/port information


After that, everything was simple to setup and use. I logged in and was ready to start ingesting images.

Configuring PhotoPrism with NextCloud Sync

PhotoPrism is easy to setup with NextCloud sync, though it seems a bit odd the way its done. The NextCloud server is added to Settings / Backup in PhotoPrism, then you can click the circular arrows under the sync heading, and setup sync. To pick up the NextCloud auto uploads from my phone, I selected the InstantUploads folder to sync, with a daily interval. I told PhotoPrism to download remote files, preserve filenames, and sync raw and video files. I didn’t want PhotoPrism to upload to NextCloud as I wanted it to be a one way file sync to gather data. My PhotoPrism server is setup as a data viewer and not generating data itself as well. Then a flip of the “enable” switch and its complete. The first sync didn’t start instantaneously, however it did start not too long after setting it up, and it took a few hours to slowly sync and process all the files in my NextCloud folder (a few thousand files).