blog.icod.de

Letsencrypt wildcard subdomains

By Darko Luketic 10. October 2024 1 min read 0 Comments

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…

Read Article

20 Jahre icod.de

By Darko Luketic 8. October 2024 1 min read 0 Comments

Am 07.10.2004, vor 20 Jahren wurde icod.de gegründet bzw. Das Gewerbe angemeldet. Ein Bekannter brauchte ein Webseitendesign, und wollte natürlich eine anständige Rechnung haben. Also wurde ein Gewerbe angemeldet und besteht seither. 20 Jahre Webentwicklung, Linux Server Administration. Leider gibt es nichts zu feiern, da es seit 2020 so gut wie keine Einnahmen mehr gibt.…

Read Article

A list of self-hosted OSS or free PaaS solutions

By Darko Luketic 6. October 2024 1 min read 0 Comments

Kamal https://kamal-deploy.org/ https://github.com/basecamp/kamal +: No central management interface needed, per project configuration -; Uses “kamal-proxy”, not nginx. Kamal-proxy is written in Go and significantly slowerthan nginx, as is Traefic and Caddy. Coolify https://coolify.io https://github.com/coollabsio/coolify +: Nice looking UI and has continuous integration -: Requires 2CPU 2GB RAM and 30GB per node for the UI alone.…

Read Article

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

By Darko Luketic 24. September 2024 1 min read 0 Comments

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'

1

2

3

4

5

# 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…

Read Article

Göppingen IT Firma

By Darko Luketic 8. September 2024 1 min read 0 Comments

Wenn ich bei Google nach Göppingen IT Firma suche, dann kommt meine Seite überhaupt nicht vor, obwohl ich seit 2004 ein Gewerbe habe und einen Google Business Eintrag. Also hiermit, ich, Darko Luketic, habe seit 07.10.2004 eine IT Firma. Ich mache – Webentwicklung – Server Administration – Datenbanken – Frontend SPA, PWA, SSR, Hybrid mit…

Read Article