Hans Harhoff Andersen

I have bought a Home Assistant yellow which has been serving me well for a while. Recently I started getting errors from Zigbee2mqtt (Z2M).Some research suggested that I needed to use the new ember driver in Z2M, but instructions where very unclear. The Home Assistant Yellow contains a radio from Silabs and there is an… Continue reading Home assistant yellow and what I wished would be clearly written elsewhere

Neat packages to install VS Code + peacock Altsnap WinCompose (disabled Xorg conf) CopyQ From Windows 11. Source: https://kskroyal.com/run-ubuntu-24-04-on-windows-11-with-gui-using-wsl/ Add the key to github etc. cat ~/.ssh/id_ed25519https://github.com/settings/ssh/new Add eternal bash history Disable password on sudo

If you want an eternal bash history (including stuff you do in parallel terminals) put this in your .bashrc file: To load your existing history do this: This will add a breaker between each command. The only downside is that all the commands will be listed as having occured in 1970 🙂 Source: https://stackoverflow.com/questions/9457233/unlimited-bash-history

Using Dynaconf for settings and secrets in Python projects is my favorite approach. Connecting it to Hashicorp vault as the backend is a bit tricky though since the documentation for this is very sparse. The documentation here gives a working example, but does not explain how you set up the same with a config.py file… Continue reading Connecting Dynaconf to Hashicorp Vault

How do I access my Azure Devops hosted python packages via poetry? Simply add the feed url e.g. Source: https://python-poetry.org/docs/master/repositories/

If you need to load data from Azure SQL server to Azure Databricks you have several options. Using JDBC Using JDBC you can simple paste username/password, however this only works with sql authentication i.e. NOT with Azure Active Directory (AAD) Auth. A guide is available here: https://docs.microsoft.com/en-us/azure/databricks/data/data-sources/sql-databases However, I recommend using the Spark Connector as… Continue reading Connecting from Azure Databricks to Azure SQL with AAD auth (with and without service principal)

If you ever get this error when using numpy e.g. with Azure ML: RuntimeError: module compiled against API version 0xf but this version of numpy is 0xd You probably have mismatched versions of Numpy.Check the version and API version of your Numpy like this: You can check the mapping from Numpy version to C_API_VERSION here:… Continue reading RuntimeError: module compiled against API version 0xf but this version of numpy is 0xd

This great blog post just needs a simple change. Instead of (Meeting) you should pattern match for “Microsoft Teams”.All the MS Teams windows have this in their title, luckily and Teams window allows for the input eof the Mute command shortcut. My final script looks like this now: SetTitleMatchMode, 2 ; 2 = a partial… Continue reading Using AutoHotKeys to mute/unmute teams meetings