blog.icod.de

Uncaught RangeError: date value is not finite in DateTimeFormat.format()

24. October 2024 | 2 min read

Playing with Flowbite React and their Datepicker component, I had data coming from the backend in this or similar form:

{
	"data": {
		"posts": {
			"edges": [
				{
					"node": {
						"id": "c57e4ea8-072e-4057-974f-bfb369504a57",
						"createdAt": "2024-10-24T12:21:20Z",
						"updatedAt": "2024-10-24T14:03:16Z",
						"title": "Jobangebot mit jemand ohne Namen",
						"body": "Dies ist ein Jobangebot von jemandem ohne Namen",
						"expires": true,
						"expireTime": "2024-10-31T23:00:00Z",
						"category": {
							"id": "df84950d-742b-4d07-9f11-04b8964bcb36",
							"title": "Jobangebote"
						},
						"profile": {
							"id": "0ce6ee59-4ebf-42cf-9c3a-69cf5e826b0b",
							"sub": "288686157058342913",
							"name": ""
						}
					}
				}
			]
		}
	}
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

{

"data": {

"posts": {

"edges": [

{

"node": {

"id": "c57e4ea8-072e-4057-974f-bfb369504a57",

"createdAt": "2024-10-24T12:21:20Z",

"updatedAt": "2024-10-24T14:03:16Z",

"title": "Jobangebot mit jemand ohne Namen",

"body": "Dies ist ein Jobangebot von jemandem ohne Namen",

"expires": true,

"expireTime": "2024-10-31T23:00:00Z",

"category": {

"id": "df84950d-742b-4d07-9f11-04b8964bcb36",

"title": "Jobangebote"

},

"profile": {

"id": "0ce6ee59-4ebf-42cf-9c3a-69cf5e826b0b",

"sub": "288686157058342913",

"name": ""

}

]

}

aka

"expireTime": "2024-10-31T23:00:00Z",

1	"expireTime": "2024-10-31T23:00:00Z",

React is a bit of a cringy special child. Angular, no problemo. Vue, no problemo. Anyhow. I have to set defaultValues in a React-hook-form form, because React is special with controlled and…

Read Article

Letsencrypt wildcard subdomains

10. October 2024 | 1 min read

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

8. October 2024 | 1 min read

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

6. October 2024 | 1 min read

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

24. September 2024 | 1 min read

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