Letsencrypt wildcard subdomains

It’s not easy to find proper search results for this topic.

You have a domain and would like to have wildcard subdomains but are not a customer of the prominent cloud providers aka your domain reseller or DNS provider isn’t supported.

Prerequisite:
We already have a *.domain.tld DNS record pointing to our server with certbot installed.

The command is

You run this command, then you have to add a TXT record to your DNS zone.
Something like

as the key.
The trailing dot (.) is required.
And the value you receive from the command as well.
Then wait until it’s updated in the DNS, you can check if it was with

.

And then you just hit ENTER in the console and it should be completed.

I’ll now add a wildcard nginx configuration for ZITADEL, which is an web based identity management software.

MySQL 8.4+ : Set new password after new installation on CentOS Rocky Alma RHEL

MySQL 8.4 has a catch 22 situation where you can’t set a new password with mysqladmin anymore, because

So if you had an automated setup script that does something like this:

and wanting to lower the password verification level all results in

Why always so complicated, Oracle? Why always so hostile towards the user?

Anyhow.
Solution

Remove cookie banner from shopware documentation

Shopware’s documentation site nags you with an annoying cookie banner.
This is the ublock origin Firefox addon (might not work with the new Chrome browser) filter to remove that cookie banner.

Shopware people, don’t set cookies on a documentation site, for real.

Wochenmärkte Kreis Göppingen

Mittwochs:
Göppingen
Geislingen
Bad Ditzenbach
Reichenbach im Täle

Donnerstags:
Bad Boll
Bad Überkingen
Uhingen
Salach

Freitags:
Eislingen
Kuchen
Heiningen
Donzdorf

Samstags:
Göppingen
Geislingen
Ebersbach an der Fils
Süßen
Rechberghausen
Reichenbach im Täle

Pacman remove a package from the registry

Sometimes it happens that package maintainers are slow and you’ve deleted the installed files manually and replaced them with current files.
Example Android Studio (android-studio).
You tried to do a upgrade because it signaled there was a newer version available.

When a program has an self-upgrade feature you don’t really need a package manager anymore, right?

So in my case I have sudo rm -rf /opt/android-studio and downloaded the current files and extracted into /opt/android-studio. But it’s now 2 weeks later and I’m trying to upgrade my system and android-studio doesn’t want to install.

I’m removing the package from the pacman package registry or database and managing Android Studio upgrades manually from now on.

Solution