SOLVE ALL THE ERRORS!

How to solve “Npgsql: 42883: function create_hypertable(…) does not exist”?

Have you run into this puzzling error? It comes in a couple of flavors, but it boils down to you failing miserably when you run the create_hypertable() function on your PostgreSQL TimescaleDB database server! Annoyingly, it might mean that the whole function is missing (extension is not installed or loaded) or that your parameters are not properly parsed (an issue with your command). I know, that it sucks. I have been there. That’s why I wrote this article! Problem You’re trying to transform your PostgreSQL…Continue reading How to solve “Npgsql: 42883: function create_hypertable(…) does not exist”?

Docker is the unfortunate future

Solving “invalid reference format.” when trying to run “docker whatever”

So another simple one. (I just seem to run into all of the issues whenever I try to do the simplest thing with Docker!) Or with anything, I guess – but yeah, that’s another article then! Problem I was trying to run a Docker container called Syslog-ng, and had to add quite a few parameters in order to map the volumes and ports that I needed. Any time that I would run it, I’d get a really non-descript error message. This is what I ran:…Continue reading Solving “invalid reference format.” when trying to run “docker whatever”

Not sure if a bug or a feature

Azure DevOps incoming webhook just won’t fire? Easy (stupid) fix!

This article documents a simple but annoying fix to an issue with Azure DevOps. In this particular case, an incoming webhook (configured as a service connection) would fail to fire, no matter what. It turns out that it’s a bug in Azure DevOps – who would have thought :) Luckily, there’s a fairly simple workaround available! Problem A colleague was configuring a new pipeline in Azure DevOps. It was supposed to fire based on an external webhook that was defined as a service connection to…Continue reading Azure DevOps incoming webhook just won’t fire? Easy (stupid) fix!

IIS 10 welcome splash

How to install IIS (Internet Information Services) on Windows 10?

It’s the roaring twenties again, cloud is the hot stuff, and nobody needs a server anymore. Right? Nope! I’ve been involved in more on-prem or hybrid projects in the last 12 months than in the last 3-4 years combined. There are plenty of industries and valid uses for still setting up on-prem servers. And quite often, that includes setting up IIS (Internet Information Services) on said machines. And of course, there’s the classic use case – local development. Depending on what you’re trying to achieve,…Continue reading How to install IIS (Internet Information Services) on Windows 10?

Home Assistant logo

How to move the Home Assistant SQLite database in Docker on Windows?

This article explains how you can move your Home Assistant’s SQLite database files to another location by mapping them to another volume in Docker. Using Docker on Windows. Which might not be a smart move, but it’s one I went with anyway. The article will explain how to do this with docker-compose, but the steps pretty much apply to vanilla docker as well. With that said – let’s move on! Background Like so many times before, I was quite annoyed by the relatively small number…Continue reading How to move the Home Assistant SQLite database in Docker on Windows?

Azure IoT Edge is just Docker containers all the way

Azure IoT Edge gotchas – and how to overcome them!

This article describes the gotchas and weird one-offs that I’ve encountered with Azure IoT Edge so far. Consider them not-too-thoroughly tested quick fixes that aren’t significant enough to warrant an actual blog post themselves :) Okay – let’s get to them gotchas, then! Posts Related to “Azure IoT Edge gotchas – and how to overcome them!”:How to update application settings of an Azure Functions App in Azure DevOps PipelineHow to authenticate against npm registries in Azure DevOps?How to access invisible packages in Azure DevOps artifact…Continue reading Azure IoT Edge gotchas – and how to overcome them!

PostgreSQL everywhere

How to run SQL commands in a Postgre SQL Docker container?

This article will explain how to run your arbitrary SQL commands against a Postgre SQL database running in a Docker container in Windows. That should be super simple, but since I never remember anything like this by heart, I had to google it – and turns out, either I didn’t know how to google this properly or people haven’t bothered to document this. So, let’s fix that. But first, why did I need to do this, again? Problem So – I meant to run some…Continue reading How to run SQL commands in a Postgre SQL Docker container?

Damn you, WordPress!

How to modify CORS settings using a .htaccess file

Recently, I needed to host a web-based thingamajiggy in WordPress and needed to include a couple of custom libraries. For the sake of quick iteration, I decided to use a public FTP folder that I already had on the same server in order to host this. So I had configured a subdomain to host the files, and wanted to reference them from my WordPress site. Not quite a CDN, but something a little bit like that. Well, of course, I ran into an issue again.…Continue reading How to modify CORS settings using a .htaccess file

Vidyard logo

How to download audio files from Vidyard

Today, I’m documenting a simple way to download audio files from Vidyard. This approach only works for files that aren’t password-protected or behind authentication – I don’t think you can use it easily for nefarious stuff, but just in case you’re trying to commit some kind of IP theft (intellectual property), please don’t. And definitely do not ask for instructions in the comments section :) Anyway – why did I take up this task? What did I want to achieve, in order to need… This?…Continue reading How to download audio files from Vidyard

git logo

Visual Studio Code fails when running “git pull” for a new project

This article describes a simple fix to an issue (well… One or many possible issues), where git fails to pull anything from remote, throwing instead an error somewhat like this: fatal: no such branch: ‘master’ Bah. This stops you from pulling any new changes from remote, and likewise, it will stop you from pushing your new stuff out there. Always something going wrong with git, right? But what is the reason this time exactly? Problem So there I was, just following a guide on docs.microsoft.com.…Continue reading Visual Studio Code fails when running “git pull” for a new project

ClimaCell / tomorrow.io logo

No way to renew a ClimaCell API subscription – what to do

One day I suddenly realized that my Home Assistant’s ClimaCell integration had stopped working. That was weird – it had been running just fine for a while. I had signed up for a ClimaCell developer account at developer.tomorrow.io (or whatever the address was before rebranding from ClimaCell to Tomorrow.io – but this is the portal that I used) on the 28th of July, perhaps in 2020, or perhaps 2019. And it had worked brilliantly so far, but suddenly and without warning, it just stopped working.…Continue reading No way to renew a ClimaCell API subscription – what to do

Always ship Azure DevOps.

Azure DevOps suddenly 404s for your project? Easy fix!

This article explains a quick solution to a pretty common Azure DevOps problem. Namely – random and annoying 404 (or sometimes 401) errors when trying to access your dear team projects. I forgot to take screenshots of the errors and couldn’t figure out how to reproduce them, but hey, the fix is the main point, right? 😀 If you’ve ended up on this page, you’ve probably encountered the issue already, so why would you care about the screenshots anyway. Solution Ok, so this is a…Continue reading Azure DevOps suddenly 404s for your project? Easy fix!

Damn you, WordPress!

How to fix “Cannot read property ‘map’ of undefined (structured-data-blocks)”

So, once again, I find myself wasting time trying to fix WordPress. Though it is a powerful platform, it’s a never-ending source of grief when trying to maintain a site with a non-trivial number of plugins. Working with a static website creator would be much more fun, and there is a good chance that the site would stay up far more, but it would take considerable effort to set up Hugo or Gatsby – but we’ll see. We’ll see. Anyway, this time I had 2…Continue reading How to fix “Cannot read property ‘map’ of undefined (structured-data-blocks)”

Azure DevOps - Always Be Shipping!

How to update application settings of an Azure Functions App in Azure DevOps Pipeline

This article aims to patch one annoying gap in Microsoft’s documentation: how, exactly, do you update Azure Function App’s application settings using an Azure DevOps build/release pipeline? It sounds easy, and something that should happen almost automatically – and for Azure Web Apps (or App Services, as they are often called) it IS practically automatic. But for Azure Functions, it isn’t. And the docs aren’t perfect. Let me try and fix that. Problem Azure Functions won’t take your appsettings.json file, “mapping” your variable groups or…Continue reading How to update application settings of an Azure Functions App in Azure DevOps Pipeline

Azure DevOps throwing "Unexpected token < in JSON at position 4"

Azure DevOps throwing “Unexpected token < in JSON at position 4"

This article documents one of the simplest solutions to one of the simplest issues you might ever encounter with Azure DevOps. Still: it’s a pretty annoying one, and the solution – as simple as it is – seems worth documenting for the next time I’m googling this fervently as I’m afraid of losing my unsaved changes again… :) Essentially, your editor view in Azure DevOps times out and you risk losing any changes that you’ve made, and it’s all due to clumsy authentication implementation by…Continue reading Azure DevOps throwing “Unexpected token < in JSON at position 4"

Microsoft. Word.

How to copy a table in Microsoft Word (Office app)?

This article will document a super simple solution to an infuriating and stupid issue you might run into in Microsoft Office Word. Or maybe you might not, but I did. Can you tell I’m just sharing my own pains and whatever I needed to google and didn’t find a solution for? Yeah, another one of these. But hey – maybe that’ll be useful to someone else, too! Problem Long story short – copy-pasting this: Becomes this: WHAT – that’s not a table. That’s just weirdly…Continue reading How to copy a table in Microsoft Word (Office app)?

Everything is broken (a delicious lego meme)

How to fix a Logic App deployment that failed with error “UsageConfigurationNotSupportedInSubscription”?

This article explains a quick and dirty fix when you get an error somewhat like this: “UsageConfigurationNotSupportedInSubscription” when you’re deploying an Azure Logic App from a template. The same fix will probably apply to a number of other issues – but don’t hold me accountable for this :) Anyway – on to the topic of the day! Problem Can you tell by some of my recent blog posts that I’ve been deploying a few Logic Apps recently? :) Today, my Azure Logic App deployment from…Continue reading How to fix a Logic App deployment that failed with error “UsageConfigurationNotSupportedInSubscription”?

How to add an user or group to multiple Azure resources at once?

This article describes a solution to an age-old question of mine: how can I add an Azure Active Directory object – like a security group – to multiple resource groups at once? I’ve had to do this multiple times, and manual work takes quite a while. And who likes multiple manual steps? To be fair, this article could also be called something like: “Using Azure CLI to spend a lot of time unnecessarily complicating a mind-numbingly boring task of adding one Azure AD group to…Continue reading How to add an user or group to multiple Azure resources at once?

Azure Logic Apps logo

How to move your Microsoft PowerAutomate Flow to Logic Apps?

This article explains how you can export a Microsoft Power Automate Flow from, well, Microsoft Power Automate, and nicely and easily import it to Azure Logic Apps. I’ll explain the process step-by-step, and also explain solutions to a few hurdles you might run into! But first, let’s take a look at why you might want to consider taking this step in the first place, shall we? Why move to Logic Apps? Ah, a valid question. There are plenty of possible reasons why you might want…Continue reading How to move your Microsoft PowerAutomate Flow to Logic Apps?

Everything is broken (a delicious lego meme)

How to fix a Logic App deployment that failed with the error “ApiNotFound”?

This article explains a quick and dirty fix when you get an error somewhat like “ApiNotFound” when you’re deploying an Azure Logic App from a template. This seems to be a very typical hurdle to run into when you’re trying to deploy a PowerAutomate Flow you’ve exported. I guess despite being built on the same platform, Flow developers took some liberties and the migration is not quite as painless as one would hope… :) Anyway – on to the topic of the day! Problem This…Continue reading How to fix a Logic App deployment that failed with the error “ApiNotFound”?