Allgemein

8. December 2024

Flixbus Innenansicht?

Warum gibt es eigentlich keine Bilder oder Videos von Flixbus Bussen von Innen?

Nicht auf flixbus.de, nicht mal auf Youtube, aber ganz viele Videos von Fahrsimulationsspielen mit dem Wort Flixbus im Titel, welche die Suchergebnisse zuspammen.

Für meine Mutter habe ich Bilder gesucht. Die Wahl ist von Göppingen nach Ulm und von Ulm nach Böfingen und von dort mit Flixbus nach Rijeka oder mit der Bahn von Göppingen nach Celje in Slowenien und von dort nach 3 Stunden nach Pivka und dort wieder umsteigen nach Rijeka. 18 Stunden, eher 19. Für eine 90jährige.
Oder halt 2 Stunden nach Ulm mit Wartezeit und von dort 10 Stunden.

Macht doch mal Bilder und Videos.

#flixbus #Bilder #Videos

15. November 2024

Gestern WhatsApp installiert heute Werbeanrufe

Gestern habe ich WhatsApp installiert und meine Telefonnummer angegeben und nach wenigen Minuten wieder gelöscht, heute schon der 2. Werbeanruf.

#Spam #WhatsApp #Werbung

10. October 2024

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

certbot certonly --manual -d *.domain.tld

1	certbot certonly --manual -d *.domain.tld

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

_acme-challenge.domain.tld.

1	_acme-challenge.domain.tld.

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

dig TXT _acme-challenge.domain.tld

1	dig TXT _acme-challenge.domain.tld

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.

server {
  listen 80;
  listen [::]:80;
  server_name *.domain.tld;
  location / {
    return 301 https://$host$request_uri;
  }
}

server {
  listen 443 ssl;
  listen [::]:443 ssl;
  http2 on;
  server_name *.domain.tld;
  access_log  /var/log/nginx/domain.tld.access.log;
  error_log   /var/log/nginx/domain.tld.error.log;
  ssl_certificate /etc/letsencrypt/live/domain.tld-0001/fullchain.pem;
  ssl_certificate_key /etc/letsencrypt/live/domain.tld-0001/privkey.pem;
  add_header Strict-Transport-Security "max-age=63072000" always;
  root /var/www/domain.tld;
  location / {
    grpc_pass grpc://localhost:12345;
    grpc_set_header Host $host:$server_port;
  }
}

server {

listen 80;

listen [::]:80;

server_name *.domain.tld;

location / {

return 301 https://$host$request_uri;

}

server {

listen 443 ssl;

listen [::]:443 ssl;

http2 on;

server_name *.domain.tld;

access_log /var/log/nginx/domain.tld.access.log;

error_log /var/log/nginx/domain.tld.error.log;

ssl_certificate /etc/letsencrypt/live/domain.tld-0001/fullchain.pem;

ssl_certificate_key /etc/letsencrypt/live/domain.tld-0001/privkey.pem;

add_header Strict-Transport-Security "max-age=63072000" always;

root /var/www/domain.tld;

location / {

grpc_pass grpc://localhost:12345;

grpc_set_header Host $host:$server_port;

}

24. September 2024

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

'Plugin 'mysql_native_password' is not loaded'

1	'Plugin 'mysql_native_password' is not loaded'

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

# PASSWORD=$(grep 'A temporary password' /var/log/mysqld.log |awk -F: '{print $NF}' | xargs)
# NEW_PASSWORD=`pwgen -s -1 -y 32`
# mysqladmin -u root- p"$PASSWORD" password "$NEW_PASSWORD"
mysqladmin: connect to server at 'localhost' failed
error: 'Plugin 'mysql_native_password' is not loaded'

# PASSWORD=$(grep 'A temporary password' /var/log/mysqld.log |awk -F: '{print $NF}' | xargs)

# NEW_PASSWORD=`pwgen -s -1 -y 32`

# mysqladmin -u root- p"$PASSWORD" password "$NEW_PASSWORD"

mysqladmin: connect to server at 'localhost' failed

error: 'Plugin 'mysql_native_password' is not loaded'

and wanting to lower the password verification level all results in

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

1	ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

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

Anyhow.
Solution

PASSWORD=$(grep 'A temporary password' /var/log/mysqld.log |awk -F: '{print $NF}' | xargs)
NEW_PASSWORD="{{{password}}}"
echo "ALTER USER 'root'@'localhost' IDENTIFIED BY '$NEW_PASSWORD';"|mysql -u root -p"$PASSWORD"
echo "SET GLOBAL validate_password.policy=MEDIUM"|mysql -u root -p"$NEW_PASSWORD"

PASSWORD=$(grep 'A temporary password' /var/log/mysqld.log |awk -F: '{print $NF}' | xargs)

NEW_PASSWORD="{{{password}}}"

echo "ALTER USER 'root'@'localhost' IDENTIFIED BY '$NEW_PASSWORD';"|mysql -u root -p"$PASSWORD"

echo "SET GLOBAL validate_password.policy=MEDIUM"|mysql -u root -p"$NEW_PASSWORD"