Skip to content

Solution for >>pacman and yay-bin are in conflict (libalpm.so). Remove yay-bin? [y/N]<<

yay-bin is currently not compatible with pacman 6.

If you update your system, you get the following error

pacman and yay-bin are in conflict (libalpm.so). Remove yay-bin? [y/N]

How to solve it? It is super simple, just build yay from source.

yay -S yay

Check the aur package page for an update.

Translate to de es fr it pt ja

Increase privacy, cleanup Posts and FileInfo table as well as local disk on your GPLv2 Mattermost server

I am happy to announce a free as in freedome tool for increasing the privacy of your open source mattermost server.

It is called mattermost housekeeping and comes as a full blown cronjob/systemd service.

It is easy to install and cleanes up your database as well as your file system.

It is highly configurable but the default values are good enough to use it right away.

Enjoy it!

Translate to de es fr it pt ja

Zabbix: Mass update items update interval

The issue was, that we've just added more and more systems and with that items to our zabbix monitoring solution.

The housekeeping process was getting slower and slower so we reasked our self "do we need that kind of accuracy"? Well, for the most parts, we figured out a bit "No". What was left was a handfull of critical sytems.

Instead of checking each host and item, we just noted the critical systems. This list represents the hosts we want to check individually. All otheres where "aligned" with one big mass updated.

We will use pure sql here, either via command line, adminer or what ever you like.

What do you need to know? Inside your database zabbix, there is a table called items. Each item has the column delay which represents the update interval.

After knowing this, we just need to know one more thing. What kind of update intervals do we have.

You fetch this information via the following sql statement.

SELECT `delay` FROM `items` GROUP BY `delay`;

After that, you only have to update each fitting item. For example, if you want to raise the delay from 1 minute to 5 minute just execute the following command.

UPDATE `items` SET `delay` = '5m' WHERE `delay` = '1m'

And that's it.

Translate to de es fr it pt ja

Create a list of operation system and build version from active directory clients with powershell

So the task was a result of a short question of "Do you know if each windows client got their upgrade?".

It turned out that it was easy to ask this question in powershell to the active directory.

Get-ADComputer -Filter { (Enabled -eq $true) -and (OperatingSystem -notlike "*server*") } -Properties Name,OperatingSystem,OperatingSystemVersion,SID | Format-Table

But, as usual, this results in to much information. Quickly some features where requested. We want to:

  • put this question into a script to ask it in a well defined way over and over again
  • we want to reduced the amount of information
  • we want to be able to filter against operation system
  • we want to filter against build version if more than one build version exists
  • we want to put it to a csv file

I was able to set all feature requests to "done" and more or less, you can find the result here.

Translate to de es fr it pt ja