All Posts

All Posts (530)

• 

  Published on

  2022-10-04 5:47 a.m.

  Authors

  koskila

  Tags

  homeassistantsonoff

  How to configure your Smart Home wifi devices that fail to connect due to a weak wifi signal?

  This article describes a solution to a problem that I have had with pairing different Smart Home devices with my app or some cloud service using wifi. Weirdly, wifi can be strong enough to provide connectivity to any of the devices, but weak enough for the pairing to fail. Fun stuff. You can usually just move the devices closer to your router, but with some devices that might be a bit more complicated... But as usual, workarounds exist!

  Read more →
• 

  Published on

  2022-09-27 2:47 a.m.

  Authors

  koskila

  Tags

  azuredevopsgit

  How to import an Azure DevOps Git repository... From another Azure DevOps organization?

  A while ago, I needed to move an Azure DevOps Git repository from one organization to another. And that was far easier than I thought. For once, a nice surprise from Git _and_ Azure DevOps 😀 So, let me tell you how that's done! Well, how it's done if it goes well, anyway. And if still works as it used to when you're reading this. We'll see! Solution

  Read more →
• 

  Published on

  2022-09-20 4:07 a.m.

  Authors

  koskila

  Tags

  azuredevopsnuget

  How to fix NU3028 and NU3037 errors in Azure DevOps builds?

  This article explains a solution to a rather annoying issue, where certificate validation for builds trying to fetch NuGet packages published by Microsoft fails when using .NET 5. This happens at least with Docker build when you're relying on some Microsoft-provided images... But probably also in a lot of other cases. Problem When running an Azure DevOps pipeline with any task that does any Docker stuff, your build fails.

  Read more →
• 

  Published on

  2022-09-13 3:51 a.m.

  Authors

  koskila

  Tags

  debuggingmsbuildvisual-studio

  How to kill the process causing the "MSB3021 Unable to copy file -- The process cannot access the file because it is being used by another process." error?

  This time, we're taking a look at an annoying situation where your previous debugging session, or perhaps your dotnet serve, somehow locks up your dlls or other important files that you kind of need to overwrite when rebuilding. And that, well, causes your build or debugging session to fail. So, let's take a closer look at the actual errors we've run ourselves into!

  Read more →
• 

  Published on

  2022-09-06 3:53 a.m.

  Authors

  koskila

  Tags

  appsettingsdotnet

  How to replace and reload application settings changes in .NET?

  This article explains a curious workaround that I figured out. In case you need a way to force app setting changes to be reflected in some libraries you need in your application, even if they don't support any configuration after application startup. Problem Normally, a .NET application loads the configuration - environment variables, appsettings.json files, wherever your secrets come from, and all the other good stuff - when it's started, and it's good with that.

  Read more →
• 

  Published on

  2022-08-30 5:47 a.m.

  Authors

  koskila

  Tags

  postgresql

  How to store a complex object as JSON in a PostgreSQL database using Entity Framework (Npgsql)?

  Okay, that's a title and a half. But let's see - what are we actually doing and why? In my particular case, I had to store a Dictionary<string, string> in a Postgres database. By default, that's not something Entity Framework handles. But as usual, there's a way around that - and the same concept we'll take a look at below should work for other complex data types or objects too! Solution

  Read more →
• 

  Published on

  2022-08-23 6:57 p.m.

  Authors

  koskila

  Tags

  fqdnnetwork

  How to configure FQDN on a workgroup computer?

  My ASUS AC-68U requires an external server with a Fully-Qualified Domain Name for any logging to be persisted beyond a reboot of the router. And since the router regularly needs rebooting (and will usually just automatically reboot if any errors are encountered), logging errors without them being persisted after a reboot is pretty useless. So, a computer with an FQDN I'll need. But I don't have a domain for my computers at home, so I don't really have Fully-Qualified Domain Names , either.

  Read more →
• 

  Published on

  2022-08-16 7:19 p.m.

  Authors

  koskila

  Tags

  aimeshasuswifi

  ASUS AiMesh tips and tricks

  This post is meant to gather my tips and tricks for surviving life with ASUS AiMesh wifi routers. Draw on my experience so that your life would be easier :) A quick word of advice before you proceed, though: you'll save yourself from a lot of trouble by buying actual networking gear instead of this flea market discount garden-variety rubbish. I got my ASUS AiMesh routers (RT-AC68U, RT-AC66U B1, and RT-AC1750) at a deeply discounted price, and I still don't think they've been worth the trouble.

  Read more →
• 

  Published on

  2022-08-09 9:47 a.m.

  Authors

  koskila

  Tags

  powershellpowershell7windowsterminal

  How to use Microsoft.Online.SharePoint.PowerShell with PowerShell 7?

  This article explains an annoying extra step (or a really nifty trick - depending on how you choose to look at it!) that you can take to make sure your PowerShell 7 is able to import a module that was developed for .NET Framework, instead of .NET Core. This is super helpful when you run into weirdness with some of the more, let's call them CLASSICAL , PowerShell modules. Such as Microsoft.Online.SharePoint.PowerShell . Problem I use PowerShell 7 as the default shell in my Windows Terminal.

  Read more →
• 

  Published on

  2022-08-04 7:06 a.m.

  Authors

  koskila

  Tags

  authenticationpowershellsharepointsharepoint-online

  How to fix "The website does not support SharePoint Online credentials. The response status code is 'Unauthorized'"

  Whilst running some SharePoint Online PowerShell commandlets, or connecting to a SharePoint Online site from your app, you get the following (or similar) error about your SharePoint Online credentials being unauthorized for something you should definitely be authorized to do: Cannot contact web site 'https://[tenant]-admin.sharepoint.com/' or the web site does not support SharePoint Online credentials. The response status code is 'Unauthorized'.

  Read more →
• 

  Published on

  2022-08-02 3:01 a.m.

  Authors

  koskila

  Tags

  azureazureclipowershell

  How to refresh all Az CLI subscriptions?

  This article explains how to "reactivate" all of your accounts stored in your az account by refreshing your sessions. You might need this if you suddenly run into a script that needs to iterate all of your subscriptions without you being there to sign in to each one of them. Having a recently active session for each will help, and you can run your massive script unattended overnight or something like that :) But let's take a step back - what's the issue we're dealing with here?

  Read more →
• 

  Published on

  2022-07-26 2:28 a.m.

  Authors

  koskila

  Tags

  entityframeworkentityframeworkcore

  How to fix another weird Entity Framework Core dependency issue?

  Okay - so that's a non-descriptive title if I've ever written one - I apologize for that! I just couldn't figure out a way to shorten the error when "Microsoft.AspNetCore.Diagnostics.EntityFrameworkCore" is referencing "Microsoft.AspNetCore.Http.Abstractions", and even though you're not referencing that dependency directly, you get an error where you have both 3.x and 5.x or 6.x major versions of the assembly in use. Which, in layman's terms, is no good.

  Read more →
• 

  Published on

  2022-07-19 7:38 a.m.

  Authors

  koskila

  Tags

  rdp

  How to CTRL+ALT+DEL into RDP?

  This is going to be another one of those really quick and short reminders to myself. I don't use remote desktop connections that much, when I occasionally need to - and the computer asks me to press Control, Alt, and Delete for whatever reason, I'll just hit them and bring up the stupid system screen on my own laptop. Yes, apparently I'm that guy . Anyway, let's... Uh.. Get to it, then? How to CTRL+ALT+DEL into your RDP window instead of your own machine? Time needed: 1 minute.

  Read more →
• 

  Published on

  2022-07-12 8:08 p.m.

  Authors

  koskila

  Tags

  azuredevopsazureiotazureiotedgeyaml

  How to roll back an Azure IoT Edge layered deployment?

  Have you ever wondered how you could roll back the latest layered Azure IoT Edge deployment? I have - it's actually pretty useful. But what for? Well, perhaps it's useful as the last step or whatever interesting Azure DevOps pipelines you have to deploy changes to an Edge device, run tests, and then remove the deployment.

  Read more →
• 

  Published on

  2022-07-05 3:37 a.m.

  Authors

  koskila

  How to get a free Office 365 Developer tenant?

  In this article, I am pretty much just sharing one link - the one, where you can request a new free Office 365 Developer subscription. And while I'm not sure if anyone else ever needs to google for this, I am actually quite comfortable just documenting it for myself.

  Read more →
• 

  Published on

  2022-06-28 5:37 a.m.

  Authors

  koskila

  Tags

  azureiotedge

  Azure IoT Edge order of deployment operations

  This article tries to bridge a gap in Microsoft's documentation for the Azure IoT Edge deployment model. Namely - all different ways to deploy modules or module configurations to your Azure IoT Edge devices, and which takes precedence over which. Problem The documentation for Azure IoT Edge is surprisingly immature. As you go about your first projects, you will run into all kinds of gaps.

  Read more →
• 

  Published on

  2022-06-21 2:01 a.m.

  Authors

  koskila

  Tags

  azuredevopsazureiotedgeazurepipelines

  How to configure Azure IoT Edge deployments in Azure DevOps pipeline?

  So some time ago, I needed to configure my first Azure DevOps pipeline for an Azure IoT Edge project. I needed to figure out which tasks to use, how to handle variables - all that good stuff. And let's call it a learning experience. Pro tip: AzureIoTEdge task is not the way to go :) This article has actually been more than a year in the making, but as usual, it takes me a while to get around to polishing things into a publishable form. This time, it took until I went on 6-week paternity leave.

  Read more →
• 

  Published on

  2022-06-14 8:05 a.m.

  Authors

  koskila

  Tags

  onedrivewindows

  How to fix "This file does not have an app associated with it for performing this action" in Windows 10/11?

  Another fun Windows-related debugging article! This time, I had to dive in to find a fix to an error along the lines of "This file does not have an app associated with it for performing this action." constantly popping up on my Windows 10 workstation. While I had this error constantly popping up, the same fixes should apply to the situation when the error only comes up when you're actually trying to open a file.

  Read more →
• 

  Published on

  2022-06-07 3:44 a.m.

  Authors

  koskila

  Tags

  typescript

  How to fix Visual Studio throwing a "This syntax requires an imported helper named '__spreadArray' which does not exist in 'tslib'. Consider upgrading your version of 'tslib'.

  This one is something that I keep running into. Visual Studio just throws an error for a missing helper __spreadArray in a library that you didn't even know you had installed, and you're not sure if it should - or even can - be updated. I guess Visual Studio just refuses to give me a break :) But like with so many different issues, there are multiple fixes available!

  Read more →
• 

  Published on

  2022-05-31 3:10 a.m.

  Authors

  koskila

  Tags

  azurefunctionsazureiothub

  How to fix "The listener for function was unable to start. Out of retries creating lease for partition 0"

  Here is another pretty quick one - trying to debug Azure Functions fails with a confusing error message about failing to create a lease for a partition. But as usual, the fix is (probably) simple, and this article explains what to do :) So, hey future me, finding this article on Google! 🙋‍♂️ Let's get to it, then! Problem When trying to debug your Azure Function, you get an error somewhat like this: The listener for function [function name] was unable to start. Microsoft.Azure.EventHubs.

  Read more →
• 

  Published on

  2022-05-24 4:04 a.m.

  Authors

  koskila

  Tags

  authorizationwebsockets

  Using role claims to target WebSockets

  This article explains a (fairly) simple solution on how you can grab role claims - or any other claims with some tweaking - and use them as the basis for targeting your WebSocket messages. Very nifty, if you ask me, without all the enterprisiness of SignalR. Talking about SignalR, another way to implement pretty much the same thing, but with all of the enterprisey goodness of SignalR, is described in this blog post: How to access claims of a SignalR user in ASP.NET Core?

  Read more →
• 

  Published on

  2022-05-17 2:18 a.m.

  Authors

  koskila

  Tags

  azuritedockervisual-studio

  The simplest fixes to "500 (Internal Server Error)" from Azurite

  This quick blog post explains a couple of very simple fixes - essentially, user errors - to a simple problem that you might run into with Visual Studio when developing the latest of your cool Azure bits. Well, to be fair, a few simple fixes and one heavyweight. A final ditch effort to learn to live with Azurite. But we'll get to it. So, let's embark on a journey, to try and make some sense of the whole Azure Storage emulating/exploring a side of things in your inner development loop.

  Read more →
• 

  Published on

  2022-05-10 11:58 a.m.

  Authors

  koskila

  Tags

  postgresqltimescaledb

  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!

  Read more →
• 

  Published on

  2022-05-03 2:51 a.m.

  Authors

  koskila

  Tags

  azurecloudshellpostgresql

  How to configure Azure PostgreSQL to allow Cloud Shell connections?

  I was setting up a PostgreSQL database in Azure, to be used by a cutesy little Azure Function storing telemetry from a bunch of Azure IoT Edge Devices. But when everything was (supposed to be) configured successfully, my Azure Function failed to store anything anywhere because of a missing database... Oh, right. Entity Framework can't create PostgreSQL databases, as the connection is made to an existing database - so it can't be instantiated if the database doesn't exist on the server already.

  Read more →
• 

  Published on

  2022-04-26 3:03 a.m.

  Authors

  koskila

  Tags

  docker

  Solving "invalid reference format." when trying to run almost any docker commands

  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. This time about any docker commands failing (no matter what command and with what arguments!) 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.

  Read more →