All Posts

All Posts (549)

• 

  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 →
• 

  Published on

  2022-04-19 8:33 p.m.

  Authors

  koskila

  Tags

  itjobssharepoint

  Joining the Omnia team!

  Exciting news right after the Easter break (and a bit of a change from the usual flow of technical stuff) - I've joined the Omnia team at Precio Fishbone. Over the last 12 months, I have been working mostly on Azure IoT projects and was already debating renaming the blog. The title #SharePointProblems matches the content poorly when most of my new posts are about Docker, Azure DevOps, or Entity Framework .

  Read more →
• 

  Published on

  2022-04-12 3:30 a.m.

  Authors

  koskila

  Tags

  dockerwsl

  Upgrade from WSL 1 to WSL 2 in Windows 10 to fix Docker

  Okay - another one of the topics that I'm explaining probably more to myself than whoever's reading this later. But that's why I write this blog, so please bear with me. 🙂 Anyway, onto the actual issue at hand! I was configuring Docker on WSL on my Windows laptop for development purposes.

  Read more →
• 

  Published on

  2022-04-05 2:56 a.m.

  Authors

  koskila

  Tags

  azuredevopsyaml

  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.

  Read more →
• 

  Published on

  2022-03-29 3:04 p.m.

  Authors

  koskila

  Tags

  graph-apigraphexplorer

  How to fix Graph API returning null properties for Users?

  This article explains a quick fix to a small but annoying issue: Microsoft Graph API SDK persistently returning null values for most properties of your Microsoft.Graph.User objects. The issue might happen when using either the Graph API SDK or just calling the REST API directly. Both options are entirely acceptable, and in both cases, you're not getting the properties you wanted. Well, I wasn't, anyway.

  Read more →
• 

  Published on

  2022-03-22 4:27 a.m.

  Authors

  koskila

  Tags

  azureiotazureiotedge

  How to get your Azure IoT Edge runtime to use port 443 instead of using 5671 and 8883?

  Are you struggling with your Azure IoT Edge modules not receiving your Direct Method calls? Is EdgeHub reporting transient network issues? Are you seeing "Could not connect to your IoT hub: could not complete TLS handshake" errors? Are your modules experiencing constant 104 errors (connection reset by peer)? Fear not! This article explains how to fix them. Kind of. Problem We were experiencing some major issues with our customer's Edge devices.

  Read more →
• 

  Published on

  2022-03-15 5:03 a.m.

  Authors

  koskila

  Tags

  dotnetmsbuild

  How to copy dependent assemblies to the bin folder on build?

  This is something that comes up pretty often - when you're building an application, or maybe a library you're sharing as a NuGet package to your friends: You'll need to share a dependency or two with your particular package, and you don't want your end users having to reference those libraries, too. Sounds easy, right?

  Read more →
• 

  Published on

  2022-03-15 4:00 a.m.

  Authors

  koskila

  Tags

  azureiotedgeazureiothub

  "Unable to retrieve IoT Edge informationIoT Edge configuration uses an unsupported schema and cannot be displayed." after deploying from VS Code. What do?

  This article explains a couple of steps you might need to take when executing a Single-Device deployment from Visual Studio Code to an Azure IoT Edge device. Through a bit of trial and error, I learned quite a few things that might go wrong when VSCode is building your deployment manifest (the one that'll be hosted under "config" folder and used for the deployment - that is). Background So a while ago, I was updating the base deployment of an Azure IoT Edge device.

  Read more →